[rt-users] Re: Internal Server Error

[Ruslan U. Zakirov]

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