Gyara kurakuran DATABASE zagaye na zagaye: Haɗin ya gaza!

Log inCibiyar Kula da CWPakwatin saƙo mai zagaye, saƙon kuskuren yana bayyana ▼

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

Bincika kurakuran bayanai na zagaye-zagaye

Da fatan za a duba▼

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

Idan kuskurenku yayi kama da haka▼

[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/)

Duba fayil ɗin daidaita cube

Duba kalmar sirri da aka saita a cikin fayil ɗin sanyi na zagaye cube  /usr/local/cwpsrv/var/services/roundcube/config/config.inc.php

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

Fitowar za ta kasance kamar haka ▼

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

• Wannan yana nuna cewa kalmar sirri ce 42Etn3fd7skc

Bari mu yanzuMySQLsaita ƙima ɗaya a cikin ▼

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

Duba idan roundcube yana aiki?

Yanzu, sake dubawa idan roundcube yana aiki?

Idan wannan kuskure ya faru ▼

[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/)

gudanar da wannan umarni ▼

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

Shi ke nan, ji daɗin naku zagaye (cube mai zagaye).

Bugu da kari, akwai wani kuskuren da ya bambanta da kuskuren da ke sama, mafita da hanyar gyarawa, da fatan za a bincika mahaɗin labarin da ke ƙasa▼

🔗 warware Kuskuren DB: [1286] Injin ajiya wanda ba a sani ba 'InnoDB'