When I look at syslog I see the following during startup:
Aug 9 08:28:03 rt4 acpid: starting up with netlink and the input layer
Aug 9 08:28:03 rt4 acpid: 1 rule loaded
Aug 9 08:28:03 rt4 acpid: waiting for events: event logging is off
Aug 9 08:28:04 rt4 RT: DBI
connect('dbname=rtdb;host=localhost','rtuser',...) failed: Can't connect
to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
at /usr/local/share/perl/5.14.2/DBIx/SearchBuilder/Handle.pm line 105.
(/usr/local/share/perl/5.14.2/Carp.pm:102)
Aug 9 08:28:05 rt4 RT: DBI
connect('dbname=rtdb;host=localhost','rtuser',...) failed: Can't connect
to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
at /usr/local/share/perl/5.14.2/DBIx/SearchBuilder/Handle.pm line 105.
(/usr/local/share/perl/5.14.2/Carp.pm:102)
Aug 9 08:28:08 rt4 /usr/sbin/cron[2152]: (CRON) INFO (pidfile fd = 3)
Aug 9 08:28:08 rt4 /usr/sbin/cron[2172]: (CRON) STARTUP (fork ok)
Aug 9 08:28:08 rt4 /usr/sbin/cron[2172]: (CRON) INFO (Running @reboot jobs)
Aug 9 08:28:08 rt4 mysqld_safe: Starting mysqld daemon with databases
from /var/lib/mysql
Aug 9 08:28:08 rt4 mysqld: 130809 8:28:08 [Note] Plugin 'FEDERATED' is
disabled.
Aug 9 08:28:08 rt4 mysqld: 130809 8:28:08 InnoDB: The InnoDB memory
heap is disabled
Aug 9 08:28:08 rt4 mysqld: 130809 8:28:08 InnoDB: Mutexes and rw_locks
use GCC atomic builtins
Aug 9 08:28:08 rt4 mysqld: 130809 8:28:08 InnoDB: Compressed tables
use zlib 1.2.7
Aug 9 08:28:08 rt4 mysqld: 130809 8:28:08 InnoDB: Using Linux native AIO
Aug 9 08:28:08 rt4 mysqld: 130809 8:28:08 InnoDB: Initializing buffer
pool, size = 128.0M
Aug 9 08:28:08 rt4 mysqld: 130809 8:28:08 InnoDB: Completed
initialization of buffer pool
Aug 9 08:28:08 rt4 RT: DBI
connect('dbname=rtdb;host=localhost','rtuser',...) failed: Can't connect
to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
at /usr/local/share/perl/5.14.2/DBIx/SearchBuilder/Handle.pm line 105.
(/usr/local/share/perl/5.14.2/Carp.pm:102)
Aug 9 08:28:08 rt4 mysqld: 130809 8:28:08 InnoDB: highest supported
file format is Barracuda.
Aug 9 08:28:08 rt4 RT: DBI
connect('dbname=rtdb;host=localhost','rtuser',...) failed: Can't connect
to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
at /usr/local/share/perl/5.14.2/DBIx/SearchBuilder/Handle.pm line 105.
(/usr/local/share/perl/5.14.2/Carp.pm:102)
Aug 9 08:28:09 rt4 mysqld: 130809 8:28:09 InnoDB: Waiting for the
background threads to start
Aug 9 08:28:10 rt4 mysqld: 130809 8:28:10 InnoDB: 5.5.31 started; log
sequence number 2602152497
Aug 9 08:28:10 rt4 mysqld: 130809 8:28:10 [Note] Server hostname
(bind-address): '127.0.0.1'; port: 3306
Aug 9 08:28:10 rt4 mysqld: 130809 8:28:10 [Note] - '127.0.0.1'
resolves to '127.0.0.1';
Aug 9 08:28:10 rt4 mysqld: 130809 8:28:10 [Note] Server socket created
on IP: '127.0.0.1'.
Aug 9 08:28:10 rt4 mysqld: 130809 8:28:10 [Note] Event Scheduler:
Loaded 0 events
Aug 9 08:28:10 rt4 mysqld: 130809 8:28:10 [Note] /usr/sbin/mysqld:
ready for connections.
Aug 9 08:28:10 rt4 mysqld: Version: '5.5.31-0+wheezy1' socket:
'/var/run/mysqld/mysqld.sock' port: 3306 (Debian)
Aug 9 08:28:10 rt4 /etc/mysql/debian-start[2704]: Upgrading MySQL
tables if necessary.
Aug 9 08:28:10 rt4 /etc/mysql/debian-start[2708]:
/usr/bin/mysql_upgrade: the '--basedir' option is always ignored
It almost looks like RT is trying to connect before MySQL is loaded.
Also - I find that the connection intermittently works then fails. One
minute I'm looking at my new RT tickets then on a page refresh I am back
to the RT setup screen because it thinks there is no database configured.
I'm at a loss here and really need to get this new install stable. Any
help is appreciated.
Paul O'Rorke
Tracker Software Products Canada Limited
On 08/09/2013 12:54 AM, Paul O'Rorke wrote:
OK - a little premature.
After running for a few hours I rebooted my new RT and get a database
connect fail. For some reason it's not trying to use a password in
DBI connect:
Aug 9 00:33:23 rt4 RT: DBI
connect('dbname=rtdb;host=localhost','rtuser',...) failed: Access
denied for user 'rtuser'@'localhost' (using password: NO) at
/usr/local/share/perl/5.14.2/DBIx/SearchBuilder/Handle.pm line
105. (/usr/local/share/perl/5.14.2/Carp.pm:102)
The database name, user and password are all correct in
RT_SiteConfig.pm and I can connect using those credentials from a
shell on that box and can access the right database.
Any suggestions why I'm seeing (using password: NO) in my logs? I
get something similar at startup/shutdown.
regards
*Paul O’Rorke*
Tracker Software Products
[email protected] <mailto:[email protected]>
On 8/8/2013 9:52 PM, Paul O'Rorke wrote:
Thanks for all the support. I have a shiny new 4.0.17 ticking away
nicely. Very happy.
*Paul O’Rorke*
Tracker Software Products
[email protected] <mailto:[email protected]>
