[rt-users] Re: Internal Server Error

[Scott T. Hildreth]

..got rejected, had wrong email...here it is again.

On Tue, 2004-11-16 at 09:05, Scott T. Hildreth wrote:
> When you installed mysql did you check if the server is running?
> FreeBSD 5.3 uses more of the rc.conf control, the startup script 
> for the mysqld is in /usr/local/etc/rc.d.  Add the line 
> 
>  mysql_enable="YES"
> 
> to /etc/rc.conf and then as root type
>  
>   '/usr/local/etc/rc.d/mysql-server.sh' start
> 
> all this is only helpful, if your server isn't running, so do a
> 
>  'ps -auxww | grep mysqld'
> 
> ...see if it is running.
> 
> On Tue, 2004-11-16 at 01:26, Ruslan U. Zakirov wrote:
> > Partom Rule wrote:
> > > --- seph <seph at directionless.org> wrote:
> > > 
> > >  > > DBI
> > >  > connect('dbname=rt3;host=localhost','rt_user',...)
> > >  > > failed: Can't connect to local MySQL server
> > >  > through
> > >  > > socket '/tmp/mysql.sock' (2) at
> > > 
> > > I could not find this file mysql.sock. Where is this
> > > defenishion, at? on what file? 
> > May be your mysql is stopped? Did you run `make initdb` while RT install?
> > 
> > As variant you can add
> > [mysqld]
> > ...
> > socket=/tmp/mysql.sock
> > 
> > to /etc/my.cnf
> > 
> > 
> > > 
> > >  > 
> > >  > well, is /tmp/mysql.sock where your mysql leaves
> > >  > it's socket? I bet
> > >  > not. 
> > >  > 
> > >  > mysql tries to use the socket to talk to the server
> > >  > when the hostname
> > >  > is localhost. However, DBD::mysql doesn't read
> > >  > my.cnf, which means
> > >  > that if your socket is in a funny location, you can
> > >  > lose trying to
> > >  > connect to database running on localhost.
> > >  > 
> > >  > There are 2 easy ways to fix this. Not using
> > >  > "localhost" as the db
> > >  > server name should work, or you can set the
> > >  > environmental variable
> > >  > MYSQL_UNIX_PORT appropriately. for example, one of
> > >  > my RT_SiteConfig
> > >  > files has:
> > >  >
> > > $ENV{'MYSQL_UNIX_PORT'}="/opt/mysql/var/mysql.sock";
> > > 
> > > where do i configure that? on what file? the
> > > configuration of mysql or RT? 
> > > 
> > >  > 
> > >  > seph
> > >  >  
> > > 
> > > 
> > > 
> > > 		
> > > __________________________________ 
> > > Do you Yahoo!? 
> > > Meet the all-new My Yahoo! - Try it today! 
> > > http://my.yahoo.com
> > >  
> > > 
> > > _______________________________________________
> > > http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> > > 
> > > Be sure to check out the RT wiki at http://wiki.bestpractical.com
> > 
> > _______________________________________________
> > http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> > 
> > Be sure to check out the RT wiki at http://wiki.bestpractical.com