Mysql root changed now cleanup error

[chrisf]

Mustafa, I changed MySql Root password using KloxoMR panel, now when running sh script/cleanup I get error:

Code: [Select]

Preparing Roundcube Database
-MySql root password incorrect

Please advise how to fix this, seems KloxoMR didn't change Roundcube config to new root password, or something like that.

Thank you

[MRatWork]

Try 'sh /script/reset-mysql-root-password YOURPASSWORDHERE' and then try running 'sh /script/cleanup'.

Have you change to mariadb or update mysql?.

[chrisf]

I have not changed or updated.  Mysql is my database.  I just changed the root password in KloxoMR admin panel.

Will try to run script.  Will report.

[MRatWork]

Better inform here your 'sh /script/sysinfo' to advice better solutions.

[chrisf]

Code: [Select]

A. Kloxo-MR: 6.5.0.f-2013082102
B. OS: CentOS release 6.4 (Final) x86_64
C. Apps:
1. MySQL: mysql-5.5.29-1.el6.x86_64
2. PHP: php54-5.4.17-1.ius.el6.x86_64
3. Httpd: httpd-2.2.25-1.el6.x86_64
4. Lighttpd: --uninstalled--
5. Nginx: --uninstalled--
6. Qmail: qmail-toaster-1.03-1.3.27.mr.el6.x86_64
- with: courier-imap-toaster-4.1.2-1.3.14.mr.el6.x86_64
7. Dns: bind-9.8.2-0.17.rc1.el6_4.5.x86_64
D. Php-type (for Httpd/proxy): php-fpm_event
E. Memory:
total used free shared buffers cached
Mem: 3072 1193 1878 0 0 644
-/+ buffers/cache: 549 2522
Swap: 2560 2 255 7

/script/reset-mysql-root-password MYPASS ran without error, restarted mysql Ok.

/script/cleanup still fails at:

Code: [Select]

Preparing Roundcube Database
- Mysql root password incorrect

It fails and stops cleanup script.  I had to run fixdns fixweb to bring server back online.

Please advise a fix.

Thank you

[MRatWork]

Better update again to 2013082201. Version of 2013082102 have a problem fixdns.

About reset password, usually reset password from panel is ok but sometimes reset from ssh not work.

Maybe something wrong with /etc/my.cnf file. Inform here with 'cat /etc/my.cnf'

[chrisf]

Mustafa - Mysql is fine.  Kloxo can connect - all my sites and clients can connect.  This is a issue with cleanup and Roundcube.

I will inform my.cnf but it is default unchanged.

[chrisf]

/etc/my.cnf

Code: [Select]

[mysqld]
# Settings user and group are ignored when systemd is used (fedora >= 15).
# If you need to run mysqld under different user or group,
# customize your systemd unit file for mysqld according to the
# instructions in http://fedoraproject.org/wiki/Systemd
user=mysql
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
# Semisynchronous Replication
# http://dev.mysql.com/doc/refman/5.5/en/replication-semisync.html
# uncomment next line on MASTER
;plugin-load=rpl_semi_sync_master=semisync_master.so
# uncomment next line on SLAVE
;plugin-load=rpl_semi_sync_slave=semisync_slave.so
# Others options for Semisynchronous Replication
;rpl_semi_sync_master_enabled=1
;rpl_semi_sync_master_timeout=10
;rpl_semi_sync_slave_enabled=1
# http://dev.mysql.com/doc/refman/5.5/en/performance-schema.html
;performance_schema
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pi d


[chrisf]

If I try to change password in KloxoMR, Datbase Admins, root

I get this error:

Code: [Select]

Alert: could_not_connect_to_db_admin

Seems KloxoMR not updating password somewhere.  Please advise how to fix.

[MRatWork]

I am not sure about it. Look like ';' commenting not 'standard' on my.cnf.

About your issue. try using 1 of my-*.cnf from /usr/share/mysql. Example you can copy my-small.cnf to /etc/my.inf and then restart mysql with 'service mysqld restart'.

[chrisf]

Mustafa - using Kloxo panel reset password has made errors.  I did not notice error and did this on three servers.

Two servers are fresh installs.  Now I can not use Database Admins, root, change password on any of the changed servers.

Please test.  reset root password using control panel then try Database Admin, root, change password.

It is not updating somewhere.  Please advise.  Changing my.cnf had no effect - still error.

[chrisf]

Cannot login to phpMyAdmin either.  Nothing that uses the root user is available.

I need to fix the kloxo database where it saves the root password.

if I ssh and mysql the root password has changed to the reset-mysql-root-password but kloxo is not updating root password.

Can not add databases or anything.

Please advise.

[chrisf]

I FIXED IT

Report:
KloxoMR when using:
Server - Reset Mysql Password

It changed root password but did not update database kloxo table dbuser.

I ssh mysql and updated that table with correct password.  All fixed now.

A bug?

[MRatWork]

Already try to change dbuser table but maybe function mysql_connect not compatible.

[chrisf]

table was dbadmin (my mistake).  But i tried it on a clean server, same result.  If I use server - reset mysql password it changes the mysql password for root but does not update kloxo,dbadmin table for password.

had to manually change it there.  then all is ok.

this is a bug for sure