Hagaaji qaladka DATABASE-ka wareega wareega ah: Xidhiidhku wuu fashilmay!

Log inCWP Control Panelsanduuqa boostada wareegsan, fariinta qaladka soo socota ayaa soo baxaysa ▼

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

Hagaaji qaladka DATABASE-ka wareega wareega ah: Xidhiidhku wuu fashilmay!

Hubi khaladaadka xogta wareega wareega

Fadlan hubigalka qaladka wareega wareega ▼

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

Haddi khaladkaagu u ekaado sidan▼

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

Hubi faylka isku xidhka wareega

Hubi erayga sirta ah ee ku jira faylka qaabeynta wareega  /usr/local/cwpsrv/var/services/roundcube/config/config.inc.php

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

Wax-soo-saarku wuxuu ahaan doonaa sidan ▼

$config['db_dsnw'] = 'mysqli://roundcube:42Etn3fd7skc@localhost/roundcube';
  • Tani waxay muujinaysaa in erayga sirta ah uu yahay 42Etn3fd7skc

Hadda aynuMySQLqiime isku mid ah dhig ▼

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

Hubi haddii wareeggu shaqaynayo?

Hadda, mar kale hubi haddii wareeggu shaqeeyo?

Haddi ciladani dhacdo ▼

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

ku socodsii amarkan ▼

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

Waa taas, ku raaxayso kaaga wareegsan (cube wareegsan).

Intaa waxaa dheer, waxaa jira qalad kale oo ka duwan qaladka kor ku xusan, xalka iyo habka hagaajinta, fadlan ka daalaco xiriirka maqaalka ee hoose▼

Hope Chen Weiliang Blog ( https://www.chenweiliang.com/ ) la wadaago "Xallinta iyo hagaajinta qaladka DATABASE: XIRIIRKU waa fashilmay!", kaas oo adiga ku caawinaya.

Ku soo dhawoow inaad wadaagto xiriirka maqaalkan:https://www.chenweiliang.com/cwl-1163.html

Ku soo dhawoow kanaalka Telegramka ee Chen Weiliang's blog si aad u hesho wararkii ugu dambeeyay!

🔔 Noqo kuwa ugu horreeya ee hela "ChatGPT Content Suuqgeynta AI Hagaha Isticmaalka Qalabka" ee tusaha sare ee kanaalka! 🌟
📚 Hagahan waxa uu ka kooban yahay qiimo aad u weyn, 🌟Tani waa fursad naadir ah, ha seegin! ⏰⌛💨
Share iyo like saar hadaad jeceshahay!
Wadaagistaada iyo jeceylkaaga ayaa ah dhiirigelintayada joogtada ah!

 

评论

Cinwaanka emailkaaga lama daabici doono. 项 已 用 * Calaamadda

kor ugu rog