Fix fix roundcude BUNACHAR SONRAÍ EARRÁID: Theip ar an gceangal!

登录Painéal Rialúcháin CWPbosca poist roundcude, tá an chuma ar an teachtaireacht earráide seo a leanas ▼

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

Seiceáil le haghaidh earráidí bunachar sonraí roundcude

Seiceáil le do thoillogchomhad earráid roundcude ▼

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

Má bhreathnaíonn do earráid mar seo ▼

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

Seiceáil an comhad cumraíochta roundcube

Seiceáil an focal faire atá socraithe sa chomhad cumraíochta roundcube  /usr/local/cwpsrv/var/services/roundcube/config/config.inc.php

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

Beidh an t-aschur mar seo ▼

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

• Léiríonn sé seo go bhfuil an focal faire 42Etn3fd7skc

Lig dúinn anoisMySQLsocraigh an luach céanna in ▼

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

Seiceáil má oibríonn roundcube?

Anois, seiceáil arís má oibríonn roundcube?

Má tharlaíonn an earráid seo ▼

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

rith an t-ordú seo ▼

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

Sin é, bain sult as cruinneachán (ciúb cruinn).

Ina theannta sin, tá earráid eile ann atá difriúil ón earráid thuas, an modh réitigh agus deisiúcháin, le do thoil brabhsáil an nasc alt thíos ▼

Réitigh Earráid DB: [1286] Inneall stórála anaithnid 'InnoDB'

Féach ar loga earráide roundcube sa phainéal rialaithe CWP ▼/usr/local/cwpsrv/var/services/roundcube/logs/errors Tá teachtaireacht earráide bunachar sonraí MySql nó bunachar sonraí MariaDB ann ▼DB Earráid: [1286] Inneall stórála anaithnid…