Reset kloxo password

1.Kloxo admin password login:

#sh /script/resetpassword master {newpassword}

2.Reset Kloxo mysql password: --> Error "Could not open database connection." when access to Kloxo

#sh /script/fix-program-mysql {mysqlrootpassword}

or, enough:

#sh /script/fix-program-mysql

3. Reset Horde password: --> Error "Could not open database connection."
Open file:

#cat /home/kloxo/httpd/webmail/horde/config/conf.php

then find lines something like:

$conf['sql']['username'] = 'horde_groupware';
$conf['sql']['password'] = 'aVBq4yOrS';

then run:

service mysqld stop

mysqld_safe --skip-grant-tables &
mysql -u root

mysql>
mysql> use mysql;
mysql> UPDATE user SET Password = PASSWORD ('aVBq4yOrS') WHERE User='horde_groupware';
mysql> FLUSH PRIVILEGES;
mysql> quit;

service mysqld start

Or enough:

#sh /script/fixhorde

4. Reset Roundcube password: --> Error "Could not open database connection."
Open file:

#cat /home/kloxo/httpd/webmail/roundcube/config/db.inc.php

then find line something like:

$rcmail_config['db_dsnw'] = 'mysql://roundcube:pass@localhost/roundcubemail';

then run:

#service mysqld stop

#mysqld_safe --skip-grant-tables &
#mysql -u root
mysql>
mysql> use mysql;
mysql> UPDATE user SET Password = PASSWORD ('pass') WHERE User='roundcube';
mysql> FLUSH PRIVILEGES;
mysql> quit;

#service mysqld start

Note: Roundcube password always set as 'pass' (without quote).