Rekebisha HITILAFU YA DATABASE: MUunganisho UMESHINDWA!

kuingia katikaJopo la Kudhibiti la CWProundcude mailbox, ujumbe wa makosa unaofuata unaonekana ▼

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

Angalia makosa ya hifadhidata ya roundcude

Tafadhali angaliafaili ya kumbukumbu ya makosa 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 hebuMySQLweka thamani sawa katika ▼

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

Ni hayo tu, furahia yako mzunguko (mchemraba wa mviringo).

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'

Angalia kumbukumbu ya makosa ya roundcube ya paneli dhibiti ya CWP ▼/usr/local/cwpsrv/var/services/roundcube/logs/errors hifadhidata ya MySql au ujumbe wa hitilafu wa hifadhidata ya MariaDB inaonekana ▼Hitilafu ya DB: [1286] Injini ya hifadhi isiyojulikana...