Fix fix roundcude DATABASE FOUT: Ferbining mislearre!

OanmeldeCWP Control Panelroundcude postfak, it folgjende flaterberjocht ferskynt ▼

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

Kontrolearje op roundcude databank flaters

Kontrolearje asjebleaftroundcude flater log triem ▼

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

As jo ​​flater liket as dit ▼

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

Kontrolearje it roundcube-konfiguraasjetriem

Kontrolearje it wachtwurd ynsteld yn it roundcube-konfiguraasjetriem  /usr/local/cwpsrv/var/services/roundcube/config/config.inc.php

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

De útfier sil sa wêze ▼

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

• Dit jout oan dat it wachtwurd is 42Etn3fd7skc

Lit ús noMySQLset deselde wearde yn ▼

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

Kontrolearje oft roundcube wurket?

No, kontrolearje nochris as roundcube wurket?

As dizze flater optreedt ▼

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

útfiere dit kommando ▼

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

Dat is it, genietsje fan dy round cut (ronde kubus).

Derneist is d'r in oare flater dy't oars is fan 'e boppesteande flater, de oplossing en reparaasjemetoade, blêdzje asjebleaft troch de artikellink hjirûnder▼

🔗 DB-flater oplosse: [1286] Unbekende opslachmotor 'InnoDB'