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) 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=<ole@mydomaincom>, 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]>, 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.
Looks like mysql server is not running. https://www.howtoforge.com/community/threads/please-read-before-posting.58408/
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
