[SOLVED] Can't login to webmail using any customer accounts

[fossxplorer]

Now i get database connection error from Roundcube

Tried to change the password in mysql:
[root@mail ]# sh /script/reset-mysql-kloxo-password mypass123
Stop MySQL service...
MySQL kloxo password reset...
Start MySQL service...
Connect failed: Access denied for user 'kloxo'@'localhost' to database 'mysql'
[root@mail ]#

What am i doing wrong here?

[MRatWork]

Don't care if nothing problem to login.

[fossxplorer]

But now i can't login to the panel as admin 
Just get "Login Unsuccessful"
How can i fix this?

[MRatWork]

using reset-mysql-root-password

[fossxplorer]

I ran sh /script/reset-mysql-root-password newpassword, but did not help.
Where is the config file that contains password for user 'kloxo' to db "kloxo" on localhost?

Or  lxguard might have blocked my ip?  Edit: tested from other IPs, so this is not the cause.

using reset-mysql-root-password

[MRatWork]

/usr/local/lxlabs/kloxo/etc/conf/kloxo.pass

[fossxplorer]

[root@mail httpdocs]# ll  /usr/local/lxlabs/kloxo/etc/conf/kloxo.pass
-rw-r--r--. 1 lxlabs root 10 Jan 26 00:10 /usr/local/lxlabs/kloxo/etc/conf/kloxo.pass

So the password isn't touched since 26.01.2014.

Does kloxo-mr use root password for access to the db 'kloxo' as user 'kloxo'?

[root@mail httpdocs]# tail  -f /usr/local/lxlabs/kloxo/log/database
14:13 Apr/20/2014: DbError: Insert Failed for dbadmin:
14:13 Apr/20/2014: DbError: Update Failed for update dbadmin set  where nname= 'mysql___localhost'
15:13 Apr/20/2014: DbError: Insert Failed for watchdog:
15:13 Apr/20/2014: DbError: Insert Failed for watchdog:
15:13 Apr/20/2014: DbError: Insert Failed for watchdog:
15:13 Apr/20/2014: DbError: Insert Failed for watchdog:
15:13 Apr/20/2014: DbError: Insert Failed for watchdog:
15:13 Apr/20/2014: DbError: Insert Failed for watchdog:
15:13 Apr/20/2014: DbError: Insert Failed for dbadmin:
15:13 Apr/20/2014: DbError: Update Failed for update dbadmin set  where nname= 'mysql___localhost


I've no idea how to fix this 

EDIT:  Using mysql -p -D kloxo -u kloxo and entering the password, i'm able to access the the db 'kloxo'
So there must be a mismatch beetween the actual password for the db 'kloxo' with user 'kloxo' and what's inside /usr/local/lxlabs/kloxo/etc/conf/kloxo.pass.

[MRatWork]

Try to change password inside kloxo.pass

[fossxplorer]

Didn't help neither

Here is the original password value:
[root@mail ]# cat /usr/local/lxlabs/kloxo/etc/conf/kloxo.pass
03ec2c13d6

Hash value?

Omg, finally fixed:
mysql>use mysql;
mysql> update user set Password=password("password from kloxo.pass") where user="kloxo";
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

Now i can finally login to the panel at least

Mustafa: thank you very much for trying to help me out and giving me hint about kloxo.pass file