1

Topic: [Re-Open] warning: connect to 127.0.0.1:7777: Connection refused

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

http://www.iredmail.org/forum/topic9889 … fused.html

This problem came back.

So .... What happen after a reboot of: iRedapd ?

root@hostname:~# /etc/init.d/iredapd restart
iredapd is already stopped.
Starting iredapd ...
root@hostname:~# tail -20f /var/log/iredapd.log
2015-09-28 08:29:34 DEBUG SQL: Get policy senders: SELECT id,email FROM mailaddr WHERE email IN ('@.', 'user1+caf_=user1=domain.ltd@gmail.com', '@gmail.com', '@.gmail.com', '@com', '@.com', '54.186.172.23', '54.*.172.23', '54.186.*.23', '*.186.172.23', '*.*.*.*', '54.186.172.*', '*.*.172.23', '54.*.*.23', '54.186.*.*', '*.*.*.23', '54.*.*.*') ORDER BY priority DESC
2015-09-28 08:29:34 DEBUG No senders found in SQL database.
2015-09-28 08:29:34 DEBUG <-- Result: DUNNO
2015-09-28 08:29:34 DEBUG --> Apply plugin: sql_alias_access_policy
2015-09-28 08:29:34 DEBUG SQL: query access policy: SELECT accesspolicy, goto, moderators
            FROM alias
            WHERE
                address='user1@domain.ltd'
                AND address <> goto
                AND active=1
            LIMIT 1

2015-09-28 08:29:34 DEBUG SQL: record: None
2015-09-28 08:29:34 DEBUG <-- Result: DUNNO (Not a mail alias account)
2015-09-28 08:29:34 INFO [54.186.172.23] RCPT, user1+caf_=user1=domain.ltd@gmail.com -> user1@domain.ltd, DUNNO
2015-09-28 08:29:34 DEBUG Session ended
2015-09-28 13:45:10 INFO Starting iRedAPD (version: 1.6.0, backend: mysql), listening on 127.0.0.1:7777.
2015-09-28 13:45:10 INFO Loading plugin: amavisd_message_size_limit
2015-09-28 13:45:10 INFO Loading plugin: amavisd_wblist
2015-09-28 13:45:10 INFO Loading plugin: sql_alias_access_policy

Thx

----

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

2

Re: [Re-Open] warning: connect to 127.0.0.1:7777: Connection refused

No idea if no more related debug log.

*) How often did it happen?
*) Could you please turn on debug mode in iRedAPD and keep tracking this issue? if it stopped again, please try to extract related debug message in its log file.

Reference: http://www.iredmail.org/docs/debug.iredapd.html

3

Re: [Re-Open] warning: connect to 127.0.0.1:7777: Connection refused

Related issue:
http://www.iredmail.org/forum/post42919.html#p42919

@Thierry does this happen to you every Sunday too?

4 (edited by Thierry 2015-09-28 21:04:28)

Re: [Re-Open] warning: connect to 127.0.0.1:7777: Connection refused

Already on Debug mode.
For your information, I have received, from the cron.daily job of this morning this:

/etc/cron.daily/logrotate:
Stopping iredapd ...
Starting iredapd ...
/etc/cron.daily/tmpreaper:
Please read /usr/share/doc/tmpreaper/README.security.gz first;
edit /etc/tmpreaper.conf to remove this message (look for SHOWWARNING).

Perhaps there is a link ?

I will check next Sunday ...

5

Re: [Re-Open] warning: connect to 127.0.0.1:7777: Connection refused

I received a similar email from anacron.

Please update us on whether this happens on Sundays (or every 7 days)

6

Re: [Re-Open] warning: connect to 127.0.0.1:7777: Connection refused

I am not able to retrieved my previous logs ...
I am doing this: tail -500f /var/log/iredapd.log|grep refused
Do not find anything ....

7

Re: [Re-Open] warning: connect to 127.0.0.1:7777: Connection refused

We are sunday ....

Error 4.3.5 Server config problem

When the pb occured:

:~# tail -20f /var/log/iredapd.log
2015-10-04 08:14:49 DEBUG Skip plugin: amavisd_message_size_limit (protocol_state != RCPT)
2015-10-04 08:14:49 DEBUG --> Apply plugin: amavisd_wblist
2015-10-04 08:14:49 DEBUG Possible policy senders: ['@.', 'user2@domain.ltd', '@domain.ltd', '@.domain.ltd', '@org', '@.org', '192.168.x.x', '*.168.0.x', '192.*.0.x', '192.168.0.*', '192.*.*.*', '*.*.0.x', '*.*.*.x', '*.*.*.*', '192.168.*.*', '192.168.*.x', '192.*.*.x']
2015-10-04 08:14:49 DEBUG Possible policy recipients: ['@.', 'user1.f@gmail.com', '@gmail.com', '@.gmail.com', '@com', '@.com', 'user1.f@*']
2015-10-04 08:14:49 DEBUG SQL: Get policy senders: SELECT id,email FROM mailaddr WHERE email IN ('@.', 'user2@domain.ltd', '@domain.ltd', '@.domain.ltd', '@org', '@.org', '192.168.x.x', '*.168.0.x', '192.*.0.x', '192.168.0.*', '192.*.*.*', '*.*.0.x', '*.*.*.x', '*.*.*.*', '192.168.*.*', '192.168.*.x', '192.*.*.x') ORDER BY priority DESC
2015-10-04 08:14:49 DEBUG No senders found in SQL database.
2015-10-04 08:14:49 DEBUG <-- Result: DUNNO
2015-10-04 08:14:49 DEBUG --> Apply plugin: sql_alias_access_policy
2015-10-04 08:14:49 DEBUG SQL: query access policy: SELECT accesspolicy, goto, moderators
            FROM alias
            WHERE
                address='user1.f@gmail.com'
                AND address <> goto
                AND active=1
            LIMIT 1

2015-10-04 08:14:49 DEBUG SQL: record: None
2015-10-04 08:14:49 DEBUG <-- Result: DUNNO (Not a mail alias account)
2015-10-04 08:14:49 INFO [192.168.x.x] RCPT, user2@domain.ltd -> user1.f@gmail.com, DUNNO
2015-10-04 08:14:49 DEBUG Session ended
:~# systemctl status iredapd.service
â iredapd.service - LSB: Control iredapd daemon.
   Loaded: loaded (/etc/init.d/iredapd)
   Active: active (exited) since mar. 2015-09-29 16:14:57 CEST; 4 days ago
  Process: 3147 ExecStart=/etc/init.d/iredapd start (code=exited, status=0/SUCCESS)

sept. 29 16:14:10 zobe iredapd[3147]: Starting iredapd ...

After restating "iredapd"

2015-10-04 08:39:02 INFO Starting iRedAPD (version: 1.6.0, backend: mysql), listening on 127.0.0.1:7777.
2015-10-04 08:39:02 INFO Loading plugin: amavisd_message_size_limit
2015-10-04 08:39:02 INFO Loading plugin: amavisd_wblist
2015-10-04 08:39:02 INFO Loading plugin: sql_alias_access_policy

Thx

8

Re: [Re-Open] warning: connect to 127.0.0.1:7777: Connection refused

Please this the topic I marked as relevant.

This cause of this issue has been found and it is resolved.

9 (edited by Thierry 2015-10-04 15:56:17)

Re: [Re-Open] warning: connect to 127.0.0.1:7777: Connection refused

I have replied to your previous post wink
ok ... this is resolved  cool .... where/how ?
How to upgrade iredapd ?

Thx

10 (edited by Thierry 2015-10-09 12:51:36)

Re: [Re-Open] warning: connect to 127.0.0.1:7777: Connection refused

Hi,

Is there any procedure do correct this bug on 0.9.2 ?

Thx

11

Re: [Re-Open] warning: connect to 127.0.0.1:7777: Connection refused

Hello,

We are sunday, and the bug came back ...
Is it possible to know how this problem has been resolved ?
If I am not able to get access to my emails server on Sunday to correct this, people won't be able to send any emails ...
I am running version 0.9.2.

Thx

12

Re: [Re-Open] warning: connect to 127.0.0.1:7777: Connection refused

@Thierry did you ever checked the other issue I linked in my first reply?

All the steps to temporarily solve the problem are there (stop restart of iredapd from logrotate) plus information from Zhang on what he is preparing for the next version.

13 (edited by Thierry 2015-10-12 18:21:11)

Re: [Re-Open] warning: connect to 127.0.0.1:7777: Connection refused

Hi there,
Sorry to bother you, but we don not have the same logs output ...
And I am using Sogo ....
I have read all the 24 posts from your link and I do not see any clear solutions .... Except perhaps removing tmpreaper but seems to have Sogo dependencies  ??
Thx

14

Re: [Re-Open] warning: connect to 127.0.0.1:7777: Connection refused

no, you comment out restart of iredapd from logrotate file. iredapd won't be able to log, but I can live with that

15

Re: [Re-Open] warning: connect to 127.0.0.1:7777: Connection refused

ok

16

Re: [Re-Open] warning: connect to 127.0.0.1:7777: Connection refused

I did comment the three lines .... Will see next sunday.
Thx anyway for your help.