1 Topic by rmeskill

  • rmeskill
  • Member
  • Offline
  • Registered: 2015-10-26
  • Posts: 2

Topic: Cron errors in postmaster inbox

I am seeing the same errors as in this thread: http://www.iredmail.org/forum/topic9489 … inbox.html

I have started the sogo service and changed my cron settings to 5 minute increments, but am still seeing the following error emails coming into my postmaster account:

2015-10-25 16:10:01.920 sogo-ealarms-notify[430] ERROR: could not open MySQL4 connection to database 'sogo': Access denied for user 'sogo'@'localhost' (using password: YES)
<0x0x23b53a8[GCSChannelManager]> could not open channel <MySQL4Channel[0x0x244a1f8] connection=0x(null)> for mysql://127.0.0.1/sogo/sogo_alarms_folder
<0x0x23b53a8[GCSChannelManager]>   will prevent opening of this channel 5 seconds after 2015-10-25 16:10:01 -0400

And

2015-10-25 16:10:01.923 sogo-tool[431] ERROR: could not open MySQL4 connection to database 'sogo': Access denied for user 'sogo'@'localhost' (using password: YES)
<0x0x1a5a978[GCSChannelManager]> could not open channel <MySQL4Channel[0x0x1b14de8] connection=0x(null)> for mysql://127.0.0.1/sogo/sogo_sessions_folder
<0x0x1a5a978[GCSChannelManager]>   will prevent opening of this channel 5 seconds after 2015-10-25 16:10:01 -0400
2015-10-25 16:10:01.924 sogo-tool[431] Can't aquire channel

==== Required information ====
- iRedMail version (check /etc/iredmail-release): 0.9.2
- Linux/BSD distribution name and version: Ubuntu 14.04.3 LTS
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): LDAP
- Web server (Apache or Nginx): nginx
- Manage mail accounts with iRedAdmin-Pro?
- Related log if you're reporting an issue:
====

----

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,770

Re: Cron errors in postmaster inbox

rmeskill wrote:

2015-10-25 16:10:01.923 sogo-tool[431] ERROR: could not open MySQL4 connection to database 'sogo': Access denied for user 'sogo'@'localhost' (using password: YES)

That means you have wrong SQL username or password in /etc/sogo/sogo.conf. Please check it.

3 Reply by rmeskill

  • rmeskill
  • Member
  • Offline
  • Registered: 2015-10-26
  • Posts: 2

Re: Cron errors in postmaster inbox

I'm sorry, can you please clarify? Would this be the sections that have things like:

SOGoProfileURL = "mysql://sogo:XXXXXXXXXXXXXXXXXXXXXX@127.0.0.1:3306/sogo/sogo_user_profile";

or:

    SOGoUserSources = (
        {
            type = ldap;
            hostname = "ldap://127.0.0.1:389";
            baseDN = "o=domains,dc=mysite,dc=org";
            //bindAsCurrentUser = YES;
            bindDN = "cn=vmailadmin,dc=mysite,dc=org";
            bindPassword = "XXXXXXXXXXXXXXXXX";

I ran:

UPDATE mysql.user SET user='sogo', password=PASSWORD('XXXXXXXXXXXXXXXXXXX') WHERE user='root';

using the first password from above, but I'm not sure if this is correct or not.

Thanks!

-Ryan



ZhangHuangbin wrote:
rmeskill wrote:

2015-10-25 16:10:01.923 sogo-tool[431] ERROR: could not open MySQL4 connection to database 'sogo': Access denied for user 'sogo'@'localhost' (using password: YES)

That means you have wrong SQL username or password in /etc/sogo/sogo.conf. Please check it.

4 Reply by ZhangHuangbin

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

Re: Cron errors in postmaster inbox

rmeskill wrote:

UPDATE mysql.user SET user='sogo', password=PASSWORD('XXXXXXXXXXXXXXXXXXX') WHERE user='root';
using the first password from above, but I'm not sure if this is correct or not.

COMPLETELY WRONG.

Why update sql with "WHERE user='root'"? you should update like this:

UPDATE mysql.user SET password=password('xxxxxxx') WHERE user='sogo';