[rt-users] Migration Prep

Fri Aug 9 09:36:49 EDT 2013

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
> paul at tracker-software.com <mailto:paul.ororke at tracker-software.com>
>
>
> 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
>> paul at tracker-software.com <mailto:paul.ororke at tracker-software.com>
>>
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20130809/9f210be0/attachment.htm>