Could not open database connection.

[Spacedust]

I got Could not open database connection. when trying to start Kloxo.

Code: [Select]

130812 00:11:41 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
130812  0:11:41 InnoDB: The InnoDB memory heap is disabled
130812  0:11:41 InnoDB: Mutexes and rw_locks use GCC atomic builtins
130812  0:11:41 InnoDB: Compressed tables use zlib 1.2.3
130812  0:11:41 InnoDB: CPU supports crc32 instructions
130812  0:11:41 InnoDB: Initializing buffer pool, size = 3.1G
130812  0:11:41 InnoDB: Completed initialization of buffer pool
130812  0:11:41 InnoDB: highest supported file format is Barracuda.
130812  0:11:41 InnoDB: 128 rollback segment(s) are active.
130812  0:11:41 InnoDB: 10.0.3-MariaDB started; log sequence number 81189317725
130812  0:11:41 [Note] Plugin 'FEEDBACK' is disabled.
130812  0:11:41 [Note] Server socket created on IP: '0.0.0.0'.
130812  0:11:41 [Note] Event Scheduler: Loaded 0 events
130812  0:11:41 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.0.3-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server

Tried this:

Code: [Select]

/script/fix-program-mysql
grant all on kloxo.* to kloxo@localhost identified by 'c532d47361'

But does not help. What should I do ?

[MRatWork]

How about 'service mysql restart' (using mysql instead mysqld because using MariaDB instead MySql).

Usually not 'match' related to '/etc/my.cnf'. Try replace '/etc/my.cnf.d/my.cnf' content with one of 'my*.cnf' inside '/usr/share/mysql'

[MRatWork]

If this error found after running 'sh /script/mysql-to-mariadb' need reboot.

[Spacedust]

It's missing mysqlclient18:

** Found 10 pre-existing rpmdb problem(s), 'yum check' output follows:
courier-authlib-toaster-0.59.2-1.3.12.mr.el6.x86_64 has missing requires of libmysqlclient.so.18()(64bit)
courier-authlib-toaster-0.59.2-1.3.12.mr.el6.x86_64 has missing requires of libmysqlclient.so.18(libmysqlclient_16)(64bit)
php-mysql-5.4.17-2.el6.remi.x86_64 has missing requires of libmysqlclient.so.18()(64bit)
php-mysql-5.4.17-2.el6.remi.x86_64 has missing requires of libmysqlclient.so.18(libmysqlclient_16)(64bit)
php-mysql-5.4.17-2.el6.remi.x86_64 has missing requires of libmysqlclient.so.18(libmysqlclient_18)(64bit)
qmail-toaster-1.03-1.3.27.mr.el6.x86_64 has missing requires of libmysqlclient.so.18()(64bit)
qmail-toaster-1.03-1.3.27.mr.el6.x86_64 has missing requires of libmysqlclient.so.18(libmysqlclient_16)(64bit)
vpopmail-toaster-5.4.33-1.4.3.mr.el6.x86_64 has missing requires of libmysqlclient.so.18()(64bit)
vpopmail-toaster-5.4.33-1.4.3.mr.el6.x86_64 has missing requires of libmysqlclient.so.18(libmysqlclient_16)(64bit)
vpopmail-toaster-5.4.33-1.4.3.mr.el6.x86_64 has missing requires of mysql >= ('0', '5.0.22', None)

[Spacedust]

Rebooted and installed mysqlclient18 still:

Could not open database connection.

[MRatWork]

It's maybe still using 'old' kloxo-mr.repo.

[Spacedust]

I've restored /usr/local/lxlabs/kloxo from backup and it started working.

I'm in a process of moving my machines from CentOS 5.9 to 6.4 that's why it's a very long process