New Install question

For some reason, when I’m installing I get this:

/usr/bin/perl tools/initdb ‘mysql’ ‘/usr/local’ ‘localhost’ ‘’ ‘root’
‘rt’ create
Now creating a database for RT.
Enter the mysql password for root:
Creating mysql database rt.
DBI->connect(dbname=;host=localhost) failed: Can’t connect to local MySQL
server through socket ‘/var/lib/mysql/mysql.sock’ (111) at
/usr/local/lib/perl5/site_perl/5.6.1/DBIx/DataSource/Driver.pm line 74
Can’t connect to local MySQL server through socket
’/var/lib/mysql/mysql.sock’ (111) at
/usr/local/lib/perl5/site_perl/5.6.1/DBIx/DataSource/Driver.pm line 74,
line 1.
make: *** [createdb] Error 255
[root@stewie rt-2-0-9]#

But MySQL IS working.

[root@stewie rt-2-0-9]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 47 to server version: 3.22.32

Type ‘help’ for help.

Any ideas?

thanks.

Thanks,
Mike Krebs

“The things you own end up owning you.” - Tyler Durden

Mike Krebs wrote:

Your MySQL connection id is 47 to server version: 3.22.32

Your MySQL server is old and buggy. I’d lay odds that
upgrading to 3.23.x will fix your problem.

I upgraded… yet I still get this error.

Any ideas?

[root@stewie rt-2-0-9]# make install
mkdir -p //opt/rt2/bin
mkdir -p //opt/rt2/WebRT/data
mkdir -p //opt/rt2/WebRT/sessiondata
mkdir -p //opt/rt2/etc
mkdir -p //opt/rt2/lib
mkdir -p //opt/rt2/WebRT/html
mkdir -p //opt/rt2/local/WebRT/html
/usr/bin/perl tools/initdb ‘mysql’ ‘/usr/local/mysql’ ‘localhost’ ‘’
‘root’ ‘rt’ create
Now creating a database for RT.
Enter the mysql password for root:
Creating mysql database rt.
DBI->connect(dbname=;host=localhost) failed: Can’t connect to local MySQL
server through socket ‘/var/lib/mysql/mysql.sock’ (111) at
/usr/local/lib/perl5/site_perl/5.6.1/DBIx/DataSource/Driver.pm line 74
Can’t connect to local MySQL server through socket
’/var/lib/mysql/mysql.sock’ (111) at
/usr/local/lib/perl5/site_perl/5.6.1/DBIx/DataSource/Driver.pm line 74,
line 1.
make: *** [createdb] Error 255

[root@stewie rt-2-0-9]# mysqladmin version
mysqladmin Ver 8.23 Distrib 3.23.45, for pc-linux-gnu on i686
Copyright © 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

Server version 3.23.45
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 18 min 20 sec

Threads: 1 Questions: 9 Slow queries: 0 Opens: 6 Flush tables: 1 Open
tables: 0 Queries per second avg: 0.008

Delivered-To: telocity.com%mkrebs@telocity.com
X-Received: 30 Nov 2001 02:53:11 GMT
Delivered-To: rt-users@pallas.eruditorum.org
X-Sender: mkrebs@mail.telocity.com
X-Mailer: QUALCOMM Windows Eudora Version 5.1
Date: Thu, 29 Nov 2001 21:49:00 -0500
To: rt-users@lists.fsck.com
From: Mike Krebs mkrebs@telocity.com
Subject: [rt-users] New Install question
Sender: rt-users-admin@lists.fsck.com
X-BeenThere: rt-users@lists.fsck.com
X-Mailman-Version: 2.0beta5
List-Id: For users of RT: Request Tracker <rt-users.lists.fsck.com>

For some reason, when I’m installing I get this:

/usr/bin/perl tools/initdb ‘mysql’ ‘/usr/local’ ‘localhost’ ‘’ ‘root’
‘rt’ create
Now creating a database for RT.
Enter the mysql password for root:
Creating mysql database rt.
DBI->connect(dbname=;host=localhost) failed: Can’t connect to local MySQL
server through socket ‘/var/lib/mysql/mysql.sock’ (111) at
/usr/local/lib/perl5/site_perl/5.6.1/DBIx/DataSource/Driver.pm line 74
Can’t connect to local MySQL server through socket
’/var/lib/mysql/mysql.sock’ (111) at
/usr/local/lib/perl5/site_perl/5.6.1/DBIx/DataSource/Driver.pm line 74,
line 1.
make: *** [createdb] Error 255
[root@stewie rt-2-0-9]#

But MySQL IS working.

[root@stewie rt-2-0-9]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 47 to server version: 3.22.32

Type ‘help’ for help.

Any ideas?

thanks.


Thanks,
Mike Krebs

“The things you own end up owning you.” - Tyler Durden


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

Thanks,
Mike Krebs

“The things you own end up owning you.” - Tyler Durden

This is well-covered in the archives. you’ve either got a permissions problem
or a mysql config problem. Go to http://lists.fsck.com
Search for mysql.sockOn Sat, Dec 01, 2001 at 07:39:41PM -0500, Mike Krebs wrote:

I upgraded… yet I still get this error.

Any ideas?

[root@stewie rt-2-0-9]# make install
mkdir -p //opt/rt2/bin
mkdir -p //opt/rt2/WebRT/data
mkdir -p //opt/rt2/WebRT/sessiondata
mkdir -p //opt/rt2/etc
mkdir -p //opt/rt2/lib
mkdir -p //opt/rt2/WebRT/html
mkdir -p //opt/rt2/local/WebRT/html
/usr/bin/perl tools/initdb ‘mysql’ ‘/usr/local/mysql’ ‘localhost’ ‘’
‘root’ ‘rt’ create
Now creating a database for RT.
Enter the mysql password for root:
Creating mysql database rt.
DBI->connect(dbname=;host=localhost) failed: Can’t connect to local MySQL
server through socket ‘/var/lib/mysql/mysql.sock’ (111) at
/usr/local/lib/perl5/site_perl/5.6.1/DBIx/DataSource/Driver.pm line 74
Can’t connect to local MySQL server through socket
’/var/lib/mysql/mysql.sock’ (111) at
/usr/local/lib/perl5/site_perl/5.6.1/DBIx/DataSource/Driver.pm line 74,
line 1.
make: *** [createdb] Error 255

[root@stewie rt-2-0-9]# mysqladmin version
mysqladmin Ver 8.23 Distrib 3.23.45, for pc-linux-gnu on i686
Copyright © 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

Server version 3.23.45
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 18 min 20 sec

Threads: 1 Questions: 9 Slow queries: 0 Opens: 6 Flush tables: 1 Open
tables: 0 Queries per second avg: 0.008

Delivered-To: telocity.com%mkrebs@telocity.com
X-Received: 30 Nov 2001 02:53:11 GMT
Delivered-To: rt-users@pallas.eruditorum.org
X-Sender: mkrebs@mail.telocity.com
X-Mailer: QUALCOMM Windows Eudora Version 5.1
Date: Thu, 29 Nov 2001 21:49:00 -0500
To: rt-users@lists.fsck.com
From: Mike Krebs mkrebs@telocity.com
Subject: [rt-users] New Install question
Sender: rt-users-admin@lists.fsck.com
X-BeenThere: rt-users@lists.fsck.com
X-Mailman-Version: 2.0beta5
List-Id: For users of RT: Request Tracker <rt-users.lists.fsck.com>

For some reason, when I’m installing I get this:

/usr/bin/perl tools/initdb ‘mysql’ ‘/usr/local’ ‘localhost’ ‘’ ‘root’
‘rt’ create
Now creating a database for RT.
Enter the mysql password for root:
Creating mysql database rt.
DBI->connect(dbname=;host=localhost) failed: Can’t connect to local MySQL
server through socket ‘/var/lib/mysql/mysql.sock’ (111) at
/usr/local/lib/perl5/site_perl/5.6.1/DBIx/DataSource/Driver.pm line 74
Can’t connect to local MySQL server through socket
’/var/lib/mysql/mysql.sock’ (111) at
/usr/local/lib/perl5/site_perl/5.6.1/DBIx/DataSource/Driver.pm line 74,
line 1.
make: *** [createdb] Error 255
[root@stewie rt-2-0-9]#

But MySQL IS working.

[root@stewie rt-2-0-9]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 47 to server version: 3.22.32

Type ‘help’ for help.

Any ideas?

thanks.


Thanks,
Mike Krebs

“The things you own end up owning you.” - Tyler Durden


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


Thanks,
Mike Krebs

“The things you own end up owning you.” - Tyler Durden


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

http://www.bestpractical.com/products/rt – Trouble Ticketing. Free.

Mike Krebs wrote:

I upgraded… yet I still get this error.

Any ideas?

Hmm…

/usr/bin/perl tools/initdb ‘mysql’ ‘/usr/local/mysql’ ‘localhost’ ‘’
‘root’ ‘rt’ create

Looks good, but…

Now creating a database for RT.
Enter the mysql password for root:
Creating mysql database rt.
DBI->connect(dbname=;host=localhost) failed: Can’t connect to local MySQL
server through socket ‘/var/lib/mysql/mysql.sock’ (111) at
/usr/local/lib/perl5/site_perl/5.6.1/DBIx/DataSource/Driver.pm line 74

“dbname=”. Maybe some kind of parsing bug in DBIx::DataSource::mysql…
Jesse/Ivan?

Now creating a database for RT.
Enter the mysql password for root:
Creating mysql database rt.
DBI->connect(dbname=;host=localhost) failed: Can’t connect to local MySQL
server through socket ‘/var/lib/mysql/mysql.sock’ (111) at
/usr/local/lib/perl5/site_perl/5.6.1/DBIx/DataSource/Driver.pm line 74

“dbname=”. Maybe some kind of parsing bug in DBIx::DataSource::mysql…

I believe that’s actually correct. that’s before there’s a db named ‘rt’ to connect to. Mike’s problem was, I believe either a permissions issue with /var/lib/mysql/mysql.sock being unreadable or mysql not running.


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

http://www.bestpractical.com/products/rt – Trouble Ticketing. Free.