Roundcube Mail : Connection , Can't connect to local MySQL

[D4K]

I had a couple of problems , I'm here to report what i did and it worked :)
Problem1:
Running the database and "Error:Connection failed" in case of adding a new database from Vesta
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib /mysql/mysql.sock' (2)

Solution:
Installed "mariadb" and edited "/etc/roundcube/db.inc.php" to add the new root password

Problem2:
Error in roundcube webmail
DATABASE ERROR: CONNECTION FAILED!
Unable to connect to the database!
Please contact your server-administrator.
Solution:
I have created a database roundcube (which was already exist , and imported the tables) granted all privileges to roundcube user

Problem3:
Connecting to IMAP via Mail client ( Thunderbird ) , it tells me wrong username or password
Partial Solution:
Connect via POP3
I'm Still looking for a solution


Good-bad news , I'm still facing some problems ,I'll try to solve it and report it back to everyone :)

[imperio]

1.

Code: Select all

service mysqld stop
service mysqld start

[D4K]

1.

Code: Select all

service mysqld stop
service mysqld start

In my case it wasn't working with me , it gives me an errors , so I have installed MariaDB and it looks more stable to me

[turkey3]

Could you describe in more detail how to fix the roundcube database error? I really need this fixed and am a newbie and would appreciate any further explanation. Thanks!

[D4K]

Could you describe in more detail how to fix the roundcube database error? I really need this fixed and am a newbie and would appreciate any further explanation. Thanks!

For my case , I have removed MYSQL and installed MariaDB
follow the link to install mariadb instead of mysql
viewtopic.php?f=14&t=5802

then try to enter the database root password in "/usr/local/vesta/conf/mysql.conf" instead of the old one if it's cahnged

and then log in with the root and the pass you have entered

view this file /etc/roundcube/db.inc.php and check the database name , user and password

try to search for roundcube database if you have found it with tables then make sure the user has permissions to the database , use the following query to grant privileges for the user

GRANT ALL PRIVILEGES ON databasename.* TO user@localhost IDENTIFIED BY 'userpassword';

in databasename use roundcube database ( my case it was roundcube)
in user use the database user
and password make sure it matches the password here "/etc/roundcube/db.inc.php"

Regards,

[turkey3]

But does that relate to the mail server because that is what I have troubles with. I need MySQL because many of my clients use it, and it works great,but the only thing I have not working is the mail server.

[D4K]

But does that relate to the mail server because that is what I have troubles with. I need MySQL because many of my clients use it, and it works great,but the only thing I have not working is the mail server.

I'm not sure , but mariadb is a replacment of mysql and i feel it's more stable than Mysql

try to check the file "/etc/roundcube/db.inc.php"
and try to use the db information (username,password) to login in phpmyadmin

[turkey3]

But does that relate to the mail server because that is what I have troubles with. I need MySQL because many of my clients use it, and it works great,but the only thing I have not working is the mail server.

I'm not sure , but mariadb is a replacment of mysql and i feel it's more stable than Mysql

try to check the file "/etc/roundcube/db.inc.php"
and try to use the db information (username,password) to login in phpmyadmin

But phpmyadmin works perfectly fine. Roundcube Mail server is what does not work.

[jakepatrick]

Just dump the mail system in this thing all together and focus on making the web server 100% rock solid. (Make apache an option)
It's just not worth hosting your own mail these days when there are monsters like sendgrid, google and rackspace doing it for next to nothing.

Drop the mail stuff (which is crap by the way) and focus on more important things like firewalls, mod security, a proper compression format for backups, api documentation, securing phpmyadmin, incorporating memcache... etc...

[iamkingsleyf]

Just dump the mail system in this thing all together and focus on making the web server 100% rock solid. (Make apache an option)
It's just not worth hosting your own mail these days when there are monsters like sendgrid, google and rackspace doing it for next to nothing.

Drop the mail stuff (which is crap by the way) and focus on more important things like firewalls, mod security, a proper compression format for backups, api documentation, securing phpmyadmin, incorporating memcache... etc...

do you have links to tutorial on how to do this? also how to setup external mail system to work with wordpress?