Idozi mperi DATABASE okirikiri: njikọ adaala!

AbanyeOgwe njikwa CWPigbe ozi okirikiri, ozi njehie na-egosi ▼

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

Lelee maka njehie nchekwa data okirikiri

Biko leleefaịlụ ndekọ njehie roundcude ▼

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

Ọ bụrụ na njehie gị dị ka nke a ▼

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

Lelee faịlụ nhazi okirikiri okirikiri

Lelee okwuntughe edobere na faịlụ nhazi okirikiri  /usr/local/cwpsrv/var/services/roundcube/config/config.inc.php

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

Mpụta ga-adị ka nke a ▼

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

• Nke a na-egosi na paswọọdụ bụ 42Etn3fd7skc

Ugbu a, ka anyịMySQLtọọ otu uru ahụ na▼

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

Lelee ma roundcube na-arụ ọrụ?

Ugbu a, lelee ọzọ ma roundcube na-arụ ọrụ?

Ọ bụrụ na njehie a emee ▼

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

gbaa iwu a▼

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

Ọ bụ ya, nwee mmasị na nke gị gburugburu (cube gbara gburugburu).

Na mgbakwunye, enwere njehie ọzọ dị iche na njehie ahụ dị n'elu, ihe ngwọta na usoro nrụzi, biko chọgharịa njikọ isiokwu dị n'okpuru ▼

🔗 Idozi njehie DB: [1286] injin nchekwa amaghi ama 'InnoDB'