paul at tracker-software
Aug 9, 2013, 6:36 AM
Post #28 of 31
(13 views)
Permalink
|
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 <mailto:paul.ororke [at] tracker-software>
>
>
> 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 <mailto:paul.ororke [at] tracker-software>
>>
>
|
