Rekebisha HITILAFU YA DATABASE: MUunganisho UMESHINDWA!

Unapoingia kwenye barua pepe ya Roundcude kwenye paneli dhibiti ya CWP , ujumbe wa hitilafu ufuatao unaonekana: ▼

DATABASE ERROR: CONNECTION FAILED!
Unable to connect to the database!
Please contact your server-administrator.

Angalia makosa ya hifadhidata ya roundcude

Tafadhali angalia faili ya kumbukumbu ya hitilafu ya Roundcude ▼

/usr/local/cwpsrv/var/services/roundcube/logs/errors

Ikiwa kosa lako linaonekana kama hii ▼

[17-May-2021 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-2021 20:18:11 +0000]: <gv4343g> DB Error: SQLSTATE[HY000] [1045] Access denied for user 'roundcube'@'localhost' (using password: YES) (GET /roundcube/)

Angalia faili ya usanidi ya roundcube

Angalia nenosiri lililowekwa kwenye faili ya usanidi ya roundcube  /usr/local/cwpsrv/var/services/roundcube/config/config.inc.php

grep db_dsnw /usr/local/cwpsrv/var/services/roundcube/config/config.inc.php

Matokeo yatakuwa hivi ▼

$config['db_dsnw'] = 'mysqli://roundcube:42Etn3fd7skc@localhost/roundcube';

• Hii inaonyesha kuwa nenosiri ni 42Etn3fd7skc

Sasa hebu tuweke thamani sawa katika MySQL ▼

mysql -e "SET PASSWORD FOR 'roundcube'@'localhost' = PASSWORD('42Etn3fd7skc');"
mysql -e "FLUSH PRIVILEGES;"

Angalia ikiwa roundcube inafanya kazi?

Sasa, angalia tena ikiwa roundcube inafanya kazi?

Hitilafu hii ikitokea ▼

[17-May-2021 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/)

endesha amri hii ▼

mysql -u root 'roundcube' < /usr/local/cwpsrv/var/services/roundcube/SQL/mysql.initial.sql

Hiyo ndiyo yote, furahia mzunguko wako.

Kwa kuongezea, kuna hitilafu nyingine ambayo ni tofauti na hitilafu hapo juu, suluhisho na njia ya ukarabati, tafadhali vinjari kiungo cha makala hapa chini▼

🔗Tatua Hitilafu ya DB: [1286] Injini ya kuhifadhi isiyojulikana 'InnoDB'