Ispconfig3 Debian 8 site update, made email stop. SQL Problem?

Discussion in 'Installation/Configuration' started by Ole Vangen, Mar 14, 2020.

  1. Ole Vangen

    Ole Vangen Member

    Hi
    I did an update form shell. I followed all recomendation in the prompt for choices.
    Now I have a problem. It seems definitly that there is an issue with sql database and email.

    I cant send or recive email.
    I have logged onto my webmail for testing and I cant send. it just hang. In my email and I see msg like this..
    I have put in from all email logs.

    IN mail que

    -Queue ID- --Size-- ----Arrival Time---- -Sender/Recipient-------
    49BB23E414CF 412 Sat Mar 14 16:00:06 [email protected]
    (host 127.0.0.1[127.0.0.1] said: 421 4.3.2 Service shutting down, closing channel (in reply to RCPT TO command))
    [email protected]

    IN MAIL LOG: (HAS CHANGED SOEM DOMAIN FOR SOME PRIVACY) :D
    Mar 14 23:14:42 www postfix/smtpd[12230]: warning: mysql:/etc/postfix/mysql-virtual_client.cf: table lookup problem
    Mar 14 23:14:42 www postfix/smtpd[12230]: NOQUEUE: reject: RCPT from smtp-out-2.wideroe.no[85.196.86.198]: 451 4.3.5 <smtp-out-2.wideroe.no[85.196.86.198]>: Client host rejected: Server configuration error; from=<[email protected]> to=<[email protected]> proto=ESMTP helo=<smtp-out-2.wideroe.no>
    Mar 14 23:14:42 www postfix/smtpd[12102]: disconnect from mail-qk1-x72b.google.com[2607:f8b0:4864:20::72b]
    Mar 14 23:14:42 www postfix/smtpd[12230]: disconnect from smtp-out-2.wideroe.no[85.196.86.198]
    Mar 14 23:14:43 www postfix/submission/smtpd[11462]: disconnect from unknown[92.118.38.42]
    Mar 14 23:14:46 www postfix/postsuper[12947]: Deleted: 2 messages
    Mar 14 23:14:47 www dovecot: imap([email protected]): Disconnected: Logged out in=11 out=407
    Mar 14 23:14:47 www dovecot: imap-login: Login: user=<[email protected]>, method=PLAIN, rip=2a01:4f8:190:448d::2, lip=2a01:4f8:190:448d::2, mpid=12949, secured, session=<QVoB6teglAAqAQT4AZBEjQAAAAAAAAAC>
    Mar 14 23:14:47 www dovecot: imap([email protected]): Disconnected: Logged out in=90 out=876
    Mar 14 23:14:51 www dovecot: imap-login: Login: user=<[email protected]n.com>, method=PLAIN, rip=2a01:4f8:190:448d::2, lip=2a01:4f8:190:448d::2, mpid=12951, secured, session=<YqQ96teglQAqAQT4AZBEjQAAAAAAAAAC>
    Mar 14 23:14:51 www postfix/smtpd[12102]: connect from MAILDOMAIN.com[2a01:4f8:190:448d::2]
    Mar 14 23:14:55 www postfix/smtpd[12230]: connect from mailgwgb05.rightnowtech.com[208.72.90.125]
    Mar 14 23:14:55 www postfix/submission/smtpd[11462]: warning: hostname ip-38-42.ZervDNS does not resolve to address 92.118.38.42: Name or service not known
    Mar 14 23:14:55 www postfix/submission/smtpd[11462]: connect from unknown[92.118.38.42]
    Mar 14 23:14:56 www postfix/smtpd[12953]: connect from omp.email.norwegianreward.com[12.130.153.134]
    Mar 14 23:14:56 www postfix/smtpd[12952]: connect from omp.air.norwegian.com[12.130.153.117]
    Mar 14 23:14:57 www dovecot: imap-login: Login: user=<[email protected]>, method=PLAIN, rip=2a01:4f8:190:448d::2, lip=2a01:4f8:190:448d::2, mpid=12955, secured, session=<KuyW6teglwAqAQT4AZBEjQAAAAAAAAAC>
    Mar 14 23:14:57 www dovecot: imap([email protected]): Disconnected: Logged out in=89 out=884

    IN MAIL WARNING LOG.:

    Mar 14 23:18:14 www postfix/trivial-rewrite[12104]: warning: virtual_mailbox_domains lookup failure
    Mar 14 23:18:26 www postfix/submission/smtpd[11462]: warning: hostname ip-38-42.ZervDNS does not resolve to address 92.118.38.42: Name or service not known
    Mar 14 23:19:12 www last message repeated 2 times
    Mar 14 23:19:35 www postfix/submission/smtpd[11462]: warning: hostname ip-38-42.ZervDNS does not resolve to address 92.118.38.42: Name or service not known
    Mar 14 23:19:50 www postfix/proxymap[12231]: warning: connect to mysql server 74.125.224.72: Can't connect to MySQL server on '74.125.224.72' (110)
    Mar 14 23:19:50 www postfix/trivial-rewrite[13551]: warning: proxy:mysql:/etc/postfix/mysql-virtual_transports.cf lookup error for "*"
    Mar 14 23:19:50 www postfix/trivial-rewrite[13551]: warning: proxy:mysql:/etc/postfix/mysql-virtual_transports.cf lookup error for "*"
    Mar 14 23:19:59 www postfix/submission/smtpd[11462]: warning: hostname ip-38-42.ZervDNS does not resolve to address 92.118.38.42: Name or service not known


    In mail Error log:
    14 20:20:34 www amavis[6872]: (06872-01) (!!)TROUBLE in process_request: connect_to_sql: unable to connect to any dataset at (eval 99) line 252.
    Mar 14 20:55:34 www amavis[10712]: (10712-01) (!!)TROUBLE in process_request: connect_to_sql: unable to connect to any dataset at (eval 99) line 252.
    Mar 14 21:35:35 www amavis[16045]: (16045-01) (!!)TROUBLE in process_request: connect_to_sql: unable to connect to any dataset at (eval 99) line 252.
    Mar 14 22:10:34 www amavis[20677]: (20677-01) (!!)TROUBLE in process_request: connect_to_sql: unable to connect to any dataset at (eval 99) line 252.
    Mar 14 22:50:35 www amavis[26021]: (26021-01) (!!)TROUBLE in process_request: connect_to_sql: unable to connect to any dataset at (eval 99) line 252.
     
  2. Steini86

    Steini86 Active Member

  3. Ole Vangen

    Ole Vangen Member

    I got now help this morning from the business support.
    I was told that I had put an ip adress in when I did the ispconfig update. and not used 127.0.0.1

    I can understand how that has been happening but main thing is that I got help and system runs again.
    So case is solved now
     
    Steini86 likes this.

Share This Page