Author Topic: Instructions for fixing roundcube issues  (Read 1071 times)

0 Members and 1 Guest are viewing this topic.

Offline
*
Instructions for fixing roundcube issues
« on: May 17, 2017, 08:13:17 PM »
If you get this error message on your roundcube link:
Code: [Select]
DATABASE ERROR: CONNECTION FAILED!
Unable to connect to the database!
Please contact your server-administrator.

Check roundcube logs in file: /usr/local/cwpsrv/var/services/roundcube/logs/errors

In case that your error looks like this
Code: [Select]
[17-May-2017 20:18:11 +0000]: <gv4343g> DB Error: SQLSTATE[HY000] [1045] Access denied for user 'roundcube'@'localhost' (using password: YES) in /usr/local/cwpsrv/var/services/roundcube/program/lib/Roundcube/rcube_db.php on line 173 (GET /roundcube/)
[17-May-2017 20:18:11 +0000]: <gv4343g> DB Error: SQLSTATE[HY000] [1045] Access denied for user 'roundcube'@'localhost' (using password: YES) (GET /roundcube/)

Check the password set in roundcube config in file /usr/local/cwpsrv/var/services/roundcube/config/config.inc.php
Code: [Select]
grep db_dsnw /usr/local/cwpsrv/var/services/roundcube/config/config.inc.php
Output will be like this
Code: [Select]
$config['db_dsnw'] = 'mysqli://roundcube:42Etn3fd7skc@localhost/roundcube';** This means that your password is 42Etn3fd7skc

Now lets set the same in mysql.
Code: [Select]
mysql -e "SET PASSWORD FOR 'roundcube'@'localhost' = PASSWORD('42Etn3fd7skc');"
mysql -e "FLUSH PRIVILEGES;"

Now again check if roundcube works.

In case you get this error:
Code: [Select]
[17-May-2017 20:29:09 +0000]: <gv91fd30g> DB Error: [1146] Table 'roundcube.session' doesn't exist (SQL Query: SELECT `vars`, `ip`, `changed`, now() AS ts FROM `session` WHERE `sess_id` = 'gv93bfdsfdffdfdj3') in /usr/local/cwpsrv/var/services/roundcube/program/lib/Roundcube/rcube_db.php on line 539 (GET /roundcube/)

run this command
Code: [Select]
mysql -u root 'roundcube' < /usr/local/cwpsrv/var/services/roundcube/SQL/mysql.initial.sqlthat is it, enjoy your roundcube.
AntiDDoS Protection (web + mail)
http://centos-webpanel.com/website-ddos-protection-proxy

Join our Development Team and get paid !
http://centos-webpanel.com/develope-modules-for-cwp


Services Monitoring & RBL Monitoring
http://centos-webpanel.com/services-monitor


Do you need Fast and FREE Support included for your CWP linux server?
http://centos-webpanel.com/noc-partner-list
Installation Instructions
http://centos-webpanel.com/installation-instructions
Get Fast Support Here
http://centos-webpanel.com/support-services

Offline
*
Re: Instructions for fixing roundcube issues
« Reply #1 on: May 24, 2017, 02:42:56 PM »
If you get this error message on your roundcube link:
Code: [Select]
DATABASE ERROR: CONNECTION FAILED!
Unable to connect to the database!
Please contact your server-administrator.

Check roundcube logs in file: /usr/local/cwpsrv/var/services/roundcube/logs/errors

In case that your error looks like this
Code: [Select]
[17-May-2017 20:18:11 +0000]: <gv4343g> DB Error: SQLSTATE[HY000] [1045] Access denied for user 'roundcube'@'localhost' (using password: YES) in /usr/local/cwpsrv/var/services/roundcube/program/lib/Roundcube/rcube_db.php on line 173 (GET /roundcube/)
[17-May-2017 20:18:11 +0000]: <gv4343g> DB Error: SQLSTATE[HY000] [1045] Access denied for user 'roundcube'@'localhost' (using password: YES) (GET /roundcube/)

Check the password set in roundcube config in file /usr/local/cwpsrv/var/services/roundcube/config/config.inc.php
Code: [Select]
grep db_dsnw /usr/local/cwpsrv/var/services/roundcube/config/config.inc.php
Output will be like this
Code: [Select]
$config['db_dsnw'] = 'mysqli://roundcube:42Etn3fd7skc@localhost/roundcube';** This means that your password is 42Etn3fd7skc

Now lets set the same in mysql.
Code: [Select]
mysql -e "SET PASSWORD FOR 'roundcube'@'localhost' = PASSWORD('42Etn3fd7skc');"
mysql -e "FLUSH PRIVILEGES;"

Now again check if roundcube works.

In case you get this error:
Code: [Select]
[17-May-2017 20:29:09 +0000]: <gv91fd30g> DB Error: [1146] Table 'roundcube.session' doesn't exist (SQL Query: SELECT `vars`, `ip`, `changed`, now() AS ts FROM `session` WHERE `sess_id` = 'gv93bfdsfdffdfdj3') in /usr/local/cwpsrv/var/services/roundcube/program/lib/Roundcube/rcube_db.php on line 539 (GET /roundcube/)

run this command
Code: [Select]
mysql -u root 'roundcube' < /usr/local/cwpsrv/var/services/roundcube/SQL/mysql.initial.sqlthat is it, enjoy your roundcube.

HI, Ive ran the command # mysql -u root 'roundcube' < /usr/local/cwpsrv/var/services/roundcube/SQL/mysql.initial.sql
but i get..
ERROR 1146 (42S02) at line 8: Table 'roundcube.session' doesn't exist

how can I fix this?
Thanks (Im using Centos 6.8 CWP 0.9.8.239 (with mysql not maria db)


Offline
*
Re: Instructions for fixing roundcube issues
« Reply #2 on: May 26, 2017, 01:58:14 PM »
If you get this error message on your roundcube link:
Code: [Select]
DATABASE ERROR: CONNECTION FAILED!
Unable to connect to the database!
Please contact your server-administrator.

Check roundcube logs in file: /usr/local/cwpsrv/var/services/roundcube/logs/errors

In case that your error looks like this
Code: [Select]
[17-May-2017 20:18:11 +0000]: <gv4343g> DB Error: SQLSTATE[HY000] [1045] Access denied for user 'roundcube'@'localhost' (using password: YES) in /usr/local/cwpsrv/var/services/roundcube/program/lib/Roundcube/rcube_db.php on line 173 (GET /roundcube/)
[17-May-2017 20:18:11 +0000]: <gv4343g> DB Error: SQLSTATE[HY000] [1045] Access denied for user 'roundcube'@'localhost' (using password: YES) (GET /roundcube/)

Check the password set in roundcube config in file /usr/local/cwpsrv/var/services/roundcube/config/config.inc.php
Code: [Select]
grep db_dsnw /usr/local/cwpsrv/var/services/roundcube/config/config.inc.php
Output will be like this
Code: [Select]
$config['db_dsnw'] = 'mysqli://roundcube:42Etn3fd7skc@localhost/roundcube';** This means that your password is 42Etn3fd7skc

Now lets set the same in mysql.
Code: [Select]
mysql -e "SET PASSWORD FOR 'roundcube'@'localhost' = PASSWORD('42Etn3fd7skc');"
mysql -e "FLUSH PRIVILEGES;"

Now again check if roundcube works.

In case you get this error:
Code: [Select]
[17-May-2017 20:29:09 +0000]: <gv91fd30g> DB Error: [1146] Table 'roundcube.session' doesn't exist (SQL Query: SELECT `vars`, `ip`, `changed`, now() AS ts FROM `session` WHERE `sess_id` = 'gv93bfdsfdffdfdj3') in /usr/local/cwpsrv/var/services/roundcube/program/lib/Roundcube/rcube_db.php on line 539 (GET /roundcube/)

run this command
Code: [Select]
mysql -u root 'roundcube' < /usr/local/cwpsrv/var/services/roundcube/SQL/mysql.initial.sqlthat is it, enjoy your roundcube.

HI, Ive ran the command # mysql -u root 'roundcube' < /usr/local/cwpsrv/var/services/roundcube/SQL/mysql.initial.sql
but i get..
ERROR 1146 (42S02) at line 8: Table 'roundcube.session' doesn't exist

how can I fix this?
Thanks (Im using Centos 6.8 CWP 0.9.8.239 (with mysql not maria db)


Ive fix the roundcube issue... it turned out that although roundcube database existed in the server.. I couldnt access to any of its tables.. so Ive erased the rondcube table, then created a new one and the I executed the script..mysql -u root 'roundcube' < /usr/local/cwpsrv/var/services/roundcube/SQL/mysql.initial.sql

and voila! now it's working! hope this update help others...

Cheers!

Offline
*
sensitivity tips that will raise your life
« Reply #3 on: August 12, 2017, 11:38:31 AM »
New Balance Herren Blau
 This has been claimed that web marketing comes in great shape and has limitless options for the business proprietor. There is certainly not other better approach to bring around the world consumers through the door of your organization. By getting into motion, the ideas put forth in this post, you may know the accomplishment for your personal business which you have constantly wanted.How To Have Success With Your Mobile phone Marketing and advertising
 

 
You can make your eyes show up visibly larger plus more open up, use this secret for using your eyeshadow. Use a light-colored (taupe, bone tissue, or ivory) shadow in the innermost corner of your own vision, then apply a progressively more dark hue along the way further more out. The darkest hue needs to be placed on the outer spot from the eyes.