<html>
<head>
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">When I look at syslog I see the
following during startup:<br>
<br>
<tt><br>
</tt><tt>Aug 9 08:28:03 rt4 acpid: starting up with netlink and
the input layer</tt><tt><br>
</tt><tt>Aug 9 08:28:03 rt4 acpid: 1 rule loaded</tt><tt><br>
</tt><tt>Aug 9 08:28:03 rt4 acpid: waiting for events: event
logging is off</tt><tt><br>
</tt><tt>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)</tt><tt><br>
</tt><tt>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)</tt><tt><br>
</tt><tt>Aug 9 08:28:08 rt4 /usr/sbin/cron[2152]: (CRON) INFO
(pidfile fd = 3)</tt><tt><br>
</tt><tt>Aug 9 08:28:08 rt4 /usr/sbin/cron[2172]: (CRON) STARTUP
(fork ok)</tt><tt><br>
</tt><tt>Aug 9 08:28:08 rt4 /usr/sbin/cron[2172]: (CRON) INFO
(Running @reboot jobs)</tt><tt><br>
</tt><tt>Aug 9 08:28:08 rt4 mysqld_safe: Starting mysqld daemon
with databases from /var/lib/mysql</tt><tt><br>
</tt><tt>Aug 9 08:28:08 rt4 mysqld: 130809 8:28:08 [Note] Plugin
'FEDERATED' is disabled.</tt><tt><br>
</tt><tt>Aug 9 08:28:08 rt4 mysqld: 130809 8:28:08 InnoDB: The
InnoDB memory heap is disabled</tt><tt><br>
</tt><tt>Aug 9 08:28:08 rt4 mysqld: 130809 8:28:08 InnoDB:
Mutexes and rw_locks use GCC atomic builtins</tt><tt><br>
</tt><tt>Aug 9 08:28:08 rt4 mysqld: 130809 8:28:08 InnoDB:
Compressed tables use zlib 1.2.7</tt><tt><br>
</tt><tt>Aug 9 08:28:08 rt4 mysqld: 130809 8:28:08 InnoDB: Using
Linux native AIO</tt><tt><br>
</tt><tt>Aug 9 08:28:08 rt4 mysqld: 130809 8:28:08 InnoDB:
Initializing buffer pool, size = 128.0M</tt><tt><br>
</tt><tt>Aug 9 08:28:08 rt4 mysqld: 130809 8:28:08 InnoDB:
Completed initialization of buffer pool</tt><tt><br>
</tt><tt>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)</tt><tt><br>
</tt><tt>Aug 9 08:28:08 rt4 mysqld: 130809 8:28:08 InnoDB:
highest supported file format is Barracuda.</tt><tt><br>
</tt><tt>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)</tt><tt><br>
</tt><tt>Aug 9 08:28:09 rt4 mysqld: 130809 8:28:09 InnoDB:
Waiting for the background threads to start</tt><tt><br>
</tt><tt>Aug 9 08:28:10 rt4 mysqld: 130809 8:28:10 InnoDB:
5.5.31 started; log sequence number 2602152497</tt><tt><br>
</tt><tt>Aug 9 08:28:10 rt4 mysqld: 130809 8:28:10 [Note] Server
hostname (bind-address): '127.0.0.1'; port: 3306</tt><tt><br>
</tt><tt>Aug 9 08:28:10 rt4 mysqld: 130809 8:28:10 [Note] -
'127.0.0.1' resolves to '127.0.0.1';</tt><tt><br>
</tt><tt>Aug 9 08:28:10 rt4 mysqld: 130809 8:28:10 [Note] Server
socket created on IP: '127.0.0.1'.</tt><tt><br>
</tt><tt>Aug 9 08:28:10 rt4 mysqld: 130809 8:28:10 [Note] Event
Scheduler: Loaded 0 events</tt><tt><br>
</tt><tt>Aug 9 08:28:10 rt4 mysqld: 130809 8:28:10 [Note]
/usr/sbin/mysqld: ready for connections.</tt><tt><br>
</tt><tt>Aug 9 08:28:10 rt4 mysqld: Version: '5.5.31-0+wheezy1'
socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Debian)</tt><tt><br>
</tt><tt>Aug 9 08:28:10 rt4 /etc/mysql/debian-start[2704]:
Upgrading MySQL tables if necessary.</tt><tt><br>
</tt><tt>Aug 9 08:28:10 rt4 /etc/mysql/debian-start[2708]:
/usr/bin/mysql_upgrade: the '--basedir' option is always ignored</tt><br>
<br>
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.<br>
<br>
I'm at a loss here and really need to get this new install
stable. Any help is appreciated.<br>
<br>
<div class="moz-signature">
<meta http-equiv="Content-Type" content="text/html;
charset=UTF-8">
<title></title>
<div style="font-family: Arial,Helvetica,sans-serif">
<div style="color: gray"> <span style="font-weight: bold">Paul
O'Rorke</span><br>
Tracker Software Products Canada Limited<br>
<br>
<br>
<br>
</div>
</div>
</div>
On 08/09/2013 12:54 AM, Paul O'Rorke wrote:<br>
</div>
<blockquote cite="mid:5204A02F.70902@tracker-software.com"
type="cite">
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
<div class="moz-cite-prefix">OK - a little premature.<br>
<br>
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:<br>
<blockquote><tt>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)</tt><br>
</blockquote>
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.<br>
<br>
Any suggestions why I'm seeing (using password: NO) in my
logs? I get something similar at startup/shutdown.<br>
<br>
regards<br>
<div class="moz-signature">
<div style="font-family:Arial;font-size:12px">
<p><strong>Paul O’Rorke</strong><br>
Tracker Software Products<br>
<a moz-do-not-send="true"
href="mailto:paul.ororke@tracker-software.com">paul@tracker-software.com</a></p>
<br>
</div>
</div>
On 8/8/2013 9:52 PM, Paul O'Rorke wrote:<br>
</div>
<blockquote cite="mid:52047589.3000100@tracker-software.com"
type="cite">
<meta content="text/html; charset=UTF-8"
http-equiv="Content-Type">
<div class="moz-cite-prefix">Thanks for all the support. I have
a shiny new 4.0.17 ticking away nicely. Very happy.<br>
<div class="moz-signature">
<div style="font-family:Arial;font-size:12px">
<p><strong>Paul O’Rorke</strong><br>
Tracker Software Products<br>
<a moz-do-not-send="true"
href="mailto:paul.ororke@tracker-software.com">paul@tracker-software.com</a><br>
</p>
</div>
</div>
</div>
</blockquote>
<br>
</blockquote>
<br>
</body>
</html>