Problems "starting up" RT2 - can't connect to MySQL


#1

Yesterday I’ve sent a message about my problems conserning DBI.pm, after
some more checks, I managed to solve the problem (i dunno if it’s the
right way), by making a symlink.

DBI.pm is located in /usr/local/lib/perl5/site_perl/5.6.1/Apache/DBI.pm
when Apache complained that it doesn’t find it in @INC, so i made a
symlink in /usr/lib/perl5/site_perl/5.6.0/i386-linux/Apache/DBI.pm which
solved the problem.

In httpd.conf I have:

<VirtualHost 192.168.1.8>
DocumentRoot /opt/rt2/WebRT/html
ServerName rt2.sportina.si
PerlModule Apache::DBI
PerlRequire /opt/rt2/bin/webmux.pl

SetHandler perl-script
PerlHandler RT::Mason

I get a 500 server internal error if I point the browser to rt2.sportina.si.
In error log of apache I found this:

[Tue May 22 13:32:11 2001] [notice] Apache/1.3.14 (Unix)
(Red-Hat/Linux) DAV/1.0.1 PHP/4.0.1pl2 mod_perl/1.24 configured –
resuming normal operations
DBI->connect(dbname=rt2;host=localhost) failed: Can’t connect to local
MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (111) at
/usr/lib/perl5/site_perl/5.6.0/DBIx/SearchBuilder/Handle.pm line 118
[Tue May 22 13:32:13 2001] [error] Connect Failed Can’t connect to local
MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (111)
at /opt/rt2/lib/RT.pm line 14

I tried perl -MCPAN -e’install DBD::mysql::Install’ didn’t help either.

And yes mysql is running, and yes it’s the correct version.

Can anyone advise what to do?

Thank you in advance,
Alesh


#2

Have you checked to make sure that the mysql.socket file described exists
and is accessable. This gets asked pretty frequently. Is anyone out there
willing to step up and maintain the FAQ? If so, please write me privately.

    Thanks,
    jesseOn Wed, May 23, 2001 at 09:30:08AM +0200, Alesh Mustar wrote:

Yesterday I’ve sent a message about my problems conserning DBI.pm, after
some more checks, I managed to solve the problem (i dunno if it’s the
right way), by making a symlink.

DBI.pm is located in /usr/local/lib/perl5/site_perl/5.6.1/Apache/DBI.pm
when Apache complained that it doesn’t find it in @INC, so i made a
symlink in /usr/lib/perl5/site_perl/5.6.0/i386-linux/Apache/DBI.pm which
solved the problem.

In httpd.conf I have:

<VirtualHost 192.168.1.8>
DocumentRoot /opt/rt2/WebRT/html
ServerName rt2.sportina.si
PerlModule Apache::DBI
PerlRequire /opt/rt2/bin/webmux.pl

SetHandler perl-script
PerlHandler RT::Mason

I get a 500 server internal error if I point the browser to rt2.sportina.si.
In error log of apache I found this:

[Tue May 22 13:32:11 2001] [notice] Apache/1.3.14 (Unix)
(Red-Hat/Linux) DAV/1.0.1 PHP/4.0.1pl2 mod_perl/1.24 configured –
resuming normal operations
DBI->connect(dbname=rt2;host=localhost) failed: Can’t connect to local
MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (111) at
/usr/lib/perl5/site_perl/5.6.0/DBIx/SearchBuilder/Handle.pm line 118
[Tue May 22 13:32:13 2001] [error] Connect Failed Can’t connect to local
MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (111)
at /opt/rt2/lib/RT.pm line 14

I tried perl -MCPAN -e’install DBD::mysql::Install’ didn’t help either.

And yes mysql is running, and yes it’s the correct version.

Can anyone advise what to do?

Thank you in advance,
Alesh


rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

jesse reed vincent – root@eruditorum.orgjesse@fsck.com
70EBAC90: 2A07 FC22 7DB4 42C1 9D71 0108 41A3 3FB3 70EB AC90

Any e-mail sent to the SLA will immediately become the intellectual property
of the SLA and the author of said message will enter into a period of
indentured servitude which will last for a period of time no less than seven
years.


#3

Jesse,

while hitting my head at the desk yes the permission on /var/lib/mysql
were not ok, otherwise mysql.sock is/was there (that was actually the
first thing i checked, after manually logging to mysql with rt_user
username.

Thank you again,
A.

Jesse wrote: