Tusaha Maqaalka
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.
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!
📚 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!