1 Topic by gilles.quenot (edited by gilles.quenot 2019-12-09 08:48:26)

  • gilles.quenot
  • Member
  • Offline
  • Registered: 2016-12-05
  • Posts: 61

Topic: Can't reset MariaDB password for sogo user

- iRedMail version: 1.0-beta2 MARIADB edition
- Deployed with  downloadable installer
- Linux/BSD distribution name and version: debian10
- Store mail accounts in MySQL backend
- Web server: Nginx


Hi,

I saw missing 'sogo-tool' (don't know why), so I reinstalled iRedMail 0.9.9 to 1.0-beta2 MARIADB edition and sogo debian package.
I can successfully open roundcube webmail, but when I try to open sogo page, I get error in sogo.log :

-------8<------------------
Dec 08 19:26:42 sogod [20103]: 79.82.84.181 "POST /SOGo/connect HTTP/1.0" 403 34/104 0.009 - - 0
2019-12-08 19:34:14.138 sogod[20103:20103] ERROR: could not open MySQL4 connection to database 'sogo': Access denied for user 'sogo'@'localhost' (using password: YES)
Dec 08 19:34:14 sogod [20103]: [ERROR] <0x0x557e28c52d50[GCSChannelManager]> could not open channel <MySQL4Channel[0x0x557e28d10350] connection=0x(null)> for mysql://127.0.0.1/sogo/users
Dec 08 19:34:14 sogod [20103]: [WARN] <0x0x557e28c52d50[GCSChannelManager]>   will prevent opening of this channel 5 seconds after 2019-12-08 19:34:14 -0500
Dec 08 19:34:14 sogod [20103]: [ERROR] <0x0x557e28d4a420[SQLSource]> failed to acquire channel for URL: mysql://sogo:password@127.0.0.1:3306/sogo/users
Dec 08 19:34:14 sogod [20103]: SOGoRootPage Login from 'x.x.x.x' for user 'gilles.quenot@domain.tld' might not have worked - password policy: 65535  grace: -1  expire: -1  bound: 0
Dec 08 19:34:14 sogod [20103]: 79.82.84.181 "POST /SOGo/connect HTTP/1.0" 403 34/104 0.008 - - 0
Dec 08 19:34:17 sogod [20103]: [ERROR] <0x0x557e28d4a420[SQLSource]> failed to acquire channel for URL: mysql://sogo:password@127.0.0.1:3306/sogo/users
-------8<------------------

I tried to restore mysql and sogo databases.

Any clue ?
Regards

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 30,792

Re: Can't reset MariaDB password for sogo user

gilles.quenot wrote:

2019-12-08 19:34:14.138 sogod[20103:20103] ERROR: could not open MySQL4 connection to database 'sogo': Access denied for user 'sogo'@'localhost' (using password: YES)

It's clearly that SQL username/password is incorrect.

Please try to drop SQL table "sogo.users" and re-create it:

USE sogo;
DROP VIEW users;
CREATE VIEW sogo.users (c_uid, c_name, c_password, c_cn, mail, domain) AS SELECT username, username, password, name, username, domain FROM vmail.mailbox WHERE enablesogo=1 AND active=1;

3 Reply by gilles.quenot

  • gilles.quenot
  • Member
  • Offline
  • Registered: 2016-12-05
  • Posts: 61

Re: Can't reset MariaDB password for sogo user

Thanks, solved by restoring files/mariadb dumps