MRatWork Forum by Mustafa Ramadhan

Sawo Project - Kloxo-MR Discussions => Kloxo-MR Development => Topic started by: fossxplorer on 2014-04-20, 14:56:34

Title: [SOLVED] Can't login to webmail using any customer accounts
Post by: fossxplorer on 2014-04-20, 14:56:34

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?

Title: Re: Can't login to webmail using any customer accounts
Post by: MRatWork on 2014-04-20, 15:45:13

Don't care if nothing problem to login.

Title: Re: Can't login to webmail using any customer accounts
Post by: fossxplorer on 2014-04-20, 15:49:27

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

Title: Re: Can't login to webmail using any customer accounts
Post by: MRatWork on 2014-04-20, 15:51:32

using reset-mysql-root-password

Title: Re: Can't login to webmail using any customer accounts
Post by: fossxplorer on 2014-04-20, 16:03:08

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.

Quote from: MRatWork on 2014-04-20, 15:51:32

using reset-mysql-root-password

Title: Re: Can't login to webmail using any customer accounts
Post by: MRatWork on 2014-04-20, 16:10:34

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

Title: Re: Can't login to webmail using any customer accounts
Post by: fossxplorer on 2014-04-20, 16:20:26

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

Title: Re: Can't login to webmail using any customer accounts
Post by: MRatWork on 2014-04-20, 16:32:54

Try to change password inside kloxo.pass

Title: Re: Can't login to Kloxo web interface
Post by: fossxplorer on 2014-04-20, 16:39:21

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 :)