Kloxo Change Password via SSH

1. Change root password:

su - root
passwd



2. Mysql root password: --> ERROR 1045 (28000): Access denied for user 'root'@'localhost'

service mysqld stop

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

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

service mysqld start



3. Kloxo admin password login:

sh /script/resetpassword master {newpassword}



4. 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



5. 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



6. 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).