We are happy to announce that Vesta is back under active development as of 25 February 2024. We are working on v1 candidate and expect to engage more with the community over the coming months. We are committed to open source, and we encourage contributors to help us build the future of Vesta.
Roundcube Mail : Connection , Can't connect to local MySQL
Roundcube Mail : Connection , Can't connect to local MySQL
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 :)
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 :)
Re: Roundcube Mail : Connection , Can't connect to local MyS
1.
Code: Select all
service mysqld stop
service mysqld start
Re: Roundcube Mail : Connection , Can't connect to local MyS
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 meimperio wrote:1.Code: Select all
service mysqld stop service mysqld start
Re: Roundcube Mail : Connection , Can't connect to local MyS
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!
Re: Roundcube Mail : Connection , Can't connect to local MyS
turkey3 wrote: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,
Re: Roundcube Mail : Connection , Can't connect to local MyS
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.
Re: Roundcube Mail : Connection , Can't connect to local MyS
I'm not sure , but mariadb is a replacment of mysql and i feel it's more stable than Mysqlturkey3 wrote: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.
try to check the file "/etc/roundcube/db.inc.php"
and try to use the db information (username,password) to login in phpmyadmin
Re: Roundcube Mail : Connection , Can't connect to local MyS
But phpmyadmin works perfectly fine. Roundcube Mail server is what does not work.D4K wrote:I'm not sure , but mariadb is a replacment of mysql and i feel it's more stable than Mysqlturkey3 wrote: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.
try to check the file "/etc/roundcube/db.inc.php"
and try to use the db information (username,password) to login in phpmyadmin
-
- Posts: 14
- Joined: Sat Oct 04, 2014 2:13 am
Re: Roundcube Mail : Connection , Can't connect to local MyS
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...
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...
-
- Posts: 30
- Joined: Sun Nov 23, 2014 4:41 am
Re: Roundcube Mail : Connection , Can't connect to local MyS
do you have links to tutorial on how to do this? also how to setup external mail system to work with wordpress?jakepatrick wrote: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...