Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > Installation/Configuration

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 17th May 2013, 23:06
DUCKFACE DUCKFACE is offline
Member
 
Join Date: Dec 2008
Location: Bulgaria
Posts: 95
Thanks: 2
Thanked 4 Times in 4 Posts
Default cant sedn email trought sqirrelmail

i cant send emails from web interface squirrelmail
i get this error
Message not sent. Server replied:

Code:
    Requested action aborted: error in processing
    451 4.3.5 <localhost[127.0.0.1]>: Client host rejected: Server configuration error
and here is the mail.log
Code:
May 17 22:50:01 server postfix/smtpd[30749]: lost connection after CONNECT from localhost[127.0.0.1]
May 17 22:50:01 server postfix/smtpd[30749]: disconnect from localhost[127.0.0.1]
May 17 22:53:48 server dovecot: auth-worker(30837): mysql(localhost): Connected to database dbispconfig
May 17 22:53:48 server dovecot: imap-login: Login: user=<office@example.com>, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, mpid=30839, secured, session=<0PNrV+/cvwB/AAAB>
May 17 22:53:48 server dovecot: imap(office@example.com): Disconnected: Logged out in=44 out=733
May 17 22:53:49 server dovecot: imap-login: Login: user=<office@example.com>, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, mpid=30841, secured, session=<nEtyV+/cwAB/AAAB>
May 17 22:53:49 server dovecot: imap(office@example.com): Disconnected: Logged out in=261 out=1670
May 17 22:53:49 server dovecot: imap-login: Login: user=<office@example.com>, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, mpid=30843, secured, session=<RvdzV+/cwQB/AAAB>
May 17 22:53:49 server dovecot: imap(office@expert-2002.com): Disconnected: Logged out in=117 out=1446
May 17 22:55:00 server postfix/smtpd[30886]: warning: database /var/lib/mailman/data/virtual-mailman.db is older than source file /var/lib/mailman/data/virtual-mailman
May 17 22:55:00 server postfix/smtpd[30886]: connect from localhost[127.0.0.1]
May 17 22:55:00 server postfix/smtpd[30886]: warning: connect to mysql server 127.0.0.1: Can't connect to MySQL server on '127.0.0.1' (111)
May 17 22:55:00 server postfix/smtpd[30886]: warning: mysql:/etc/postfix/mysql-virtual_client.cf: table lookup problem
May 17 22:55:00 server postfix/smtpd[30886]: NOQUEUE: reject: RCPT from localhost[127.0.0.1]: 451 4.3.5 <localhost[127.0.0.1]>: Client host rejected: Server configuration error; from=<office@eXpert-2002> to=<user1@abv.bg> proto=ESMTP helo=<example.com>
May 17 22:55:00 server postfix/smtpd[30886]: lost connection after RCPT from localhost[127.0.0.1]
May 17 22:55:00 server postfix/smtpd[30886]: disconnect from localhost[127.0.0.1]
May 17 23:00:02 server postfix/smtpd[31634]: warning: database /var/lib/mailman/data/virtual-mailman.db is older than source file /var/lib/mailman/data/virtual-mailman
May 17 23:00:02 server dovecot: imap-login: Disconnected (disconnected before greeting, waited 0 secs): user=<>, rip=127.0.0.1, lip=127.0.0.1, secured, session=<nK2tbe/c3QB/AAAB>
May 17 23:00:02 server postfix/smtpd[31634]: connect from localhost[127.0.0.1]
May 17 23:00:02 server dovecot: pop3-login: Disconnected (no auth attempts in 0 secs): user=<>, rip=127.0.0.1, lip=127.0.0.1, secured, session=<pDKube/crgB/AAAB>
May 17 23:00:02 server postfix/smtpd[31634]: lost connection after CONNECT from localhost[127.0.0.1]
May 17 23:00:02 server postfix/smtpd[31634]: disconnect from localhost[127.0.0.1]

how cam i fix it ?
Reply With Quote
Sponsored Links
  #2  
Old 18th May 2013, 08:37
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,749 Times in 2,579 Posts
Default

Quote:
May 17 22:55:00 server postfix/smtpd[30886]: warning: connect to mysql server 127.0.0.1: Can't connect to MySQL server on '127.0.0.1' (111)
May 17 22:55:00 server postfix/smtpd[30886]: warning: mysql:/etc/postfix/mysql-virtual_client.cf: table lookup problem
Looks like your MySQL server isn't running.
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #3  
Old 18th May 2013, 09:46
DUCKFACE DUCKFACE is offline
Member
 
Join Date: Dec 2008
Location: Bulgaria
Posts: 95
Thanks: 2
Thanked 4 Times in 4 Posts
Default

its working.
all of the sites has mysql support
Reply With Quote
  #4  
Old 22nd May 2013, 17:40
DUCKFACE DUCKFACE is offline
Member
 
Join Date: Dec 2008
Location: Bulgaria
Posts: 95
Thanks: 2
Thanked 4 Times in 4 Posts
Default

anyone help ?
Reply With Quote
  #5  
Old 22nd May 2013, 18:12
monkfish monkfish is offline
HowtoForge Supporter
 
Join Date: Mar 2013
Posts: 106
Thanks: 9
Thanked 15 Times in 14 Posts
Default

I think falko did with the bit highlighted...

Code:
May 17 22:55:00 server postfix/smtpd[30886]: warning: connect to mysql server 127.0.0.1: Can't connect to MySQL server on '127.0.0.1' (111)
May 17 22:55:00 server postfix/smtpd[30886]: warning: mysql:/etc/postfix/mysql-virtual_client.cf: table lookup problem
It looks like your mailer cannot confirm virtual recipients configured within ispconfig as it cannot gain correct access to mysql.

Check /etc/postfix/mysql-virtual_client.cf see if its got the right username/password/database name in etc for access to ispconfig tables.

Perhaps install a copy of phpmyadmin, gain access to the databases, see if they are populated properly.

Check where you are expecting your email to be sent FROM and TO, both email addresses and ip addresses, as this part looks a bit wrong to me:

Code:
May 17 22:55:00 server postfix/smtpd[30886]: NOQUEUE: reject: RCPT from localhost[127.0.0.1]: 451 4.3.5 <localhost[127.0.0.1]>: Client host rejected: Server configuration error; from=<office@eXpert-2002> to=<user1@abv.bg> proto=ESMTP helo=<example.com>
So, a submission from 127.0.0.1 sending an email with NON-FQDN from name and a possibly invalid HELO name unless you hid the actual name, but if that's the format may still cause a rejection the HELO itself doesnt appear to be FQDN. RFC2821 is your friend.

Have a look in mailer logs again, are you seeing ANY mail at all eg server messages to root, unless you've redirected them see /var/spool/mail/root.

Is MYSQL definitely running and can your mailer definitely get the correct access to it?

Last edited by monkfish; 22nd May 2013 at 18:14. Reason: added info
Reply With Quote
  #6  
Old 24th May 2013, 13:03
DUCKFACE DUCKFACE is offline
Member
 
Join Date: Dec 2008
Location: Bulgaria
Posts: 95
Thanks: 2
Thanked 4 Times in 4 Posts
Default

i hate this. in ISPCONFIG status for mysql server is offline!
mySQL-Server: Offline
but its working. i can acces it from phpmyadmin and make query.
how to see the password for ispconfig user in ispconfig database?

i have the follow errors in mail.log

May 24 13:20:02 server postfix/smtpd[20088]: warning: database /var/lib/mailman/data/virtual-mailman.db is older than source file /var/lib/mailman/data/virtual-mailman
May 24 13:20:02 server postfix/smtpd[20088]: connect from localhost[127.0.0.1]
May 24 13:20:02 server dovecot: imap-login: Disconnected (disconnected before greeting, waited 0 secs): user=<>, rip=127.0.0.1, lip=127.0.0.1, secured, session=<6DtRJHTdGAB/AAAB>
May 24 13:20:02 server dovecot: pop3-login: Disconnected (no auth attempts in 0 secs): user=<>, rip=127.0.0.1, lip=127.0.0.1, secured, session=<KZtRJHTd6QB/AAAB>
May 24 13:20:02 server postfix/smtpd[20088]: lost connection after CONNECT from localhost[127.0.0.1]
May 24 13:20:02 server postfix/smtpd[20088]: disconnect from localhost[127.0.0.1]
May 24 13:21:56 server postfix/proxymap[20163]: warning: connect to mysql server 127.0.0.1: Can't connect to MySQL server on '127.0.0.1' (111)
May 24 13:21:56 server postfix/cleanup[20166]: warning: proxy:mysql:/etc/postfix/mysql-virtual_email2email.cf lookup error for "root@server.expert-2002.com"
May 24 13:21:56 server postfix/cleanup[20166]: warning: C26341E0077: virtual_alias_maps map lookup problem for root@server.expert-2002.com -- deferring delivery
May 24 13:21:56 server amavis[24720]: (24720-12) Negative SMTP response to data-dot (<root@server.expert-2002.com>): 451 4.3.0 Error: queue file write error
May 24 13:21:56 server amavis[24720]: (24720-12) (!)FWD from <root@server.expert-2002.com> -> <root@server.expert-2002.com>,BODY=7BIT 451 4.3.0 from MTA(smtp:[127.0.0.1]:10025): 451 4.3.0 Error: queue file write error
May 24 13:21:56 server postfix/cleanup[20166]: warning: proxy:mysql:/etc/postfix/mysql-virtual_email2email.cf lookup error for "postmaster@server.expert-2002.com"
May 24 13:21:56 server postfix/cleanup[20166]: warning: C5C4A1E0077: virtual_alias_maps map lookup problem for postmaster@server.expert-2002.com -- deferring delivery
May 24 13:21:56 server postfix/smtpd[20162]: disconnect from localhost[127.0.0.1]
May 24 13:21:56 server amavis[24720]: (24720-12) Blocked MTA-BLOCKED {TempFailedInbound}, <root@server.expert-2002.com> -> <root@server.expert-2002.com>, Message-ID: <20130524094502.389191E0F50@server.expert-2002.com>, mail_id: cHUzlDDMTADZ, Hits: 1.178, size: 545, 553 ms
May 24 13:21:56 server postfix/cleanup[20167]: warning: database /var/lib/mailman/data/virtual-mailman.db is older than source file /var/lib/mailman/data/virtual-mailman
May 24 13:21:56 server postfix/smtp[20159]: 389191E0F50: to=<root@server.expert-2002.com>, orig_to=<root>, relay=127.0.0.1[127.0.0.1]:10024, delay=2215, delays=2214/0.03/0.01/0.55, dsn=4.3.0, status=deferred (host 127.0.0.1[127.0.0.1] said: 451 4.3.0 id=24720-12 - Temporary MTA failure on relaying, from MTA(smtp:[127.0.0.1]:10025): 451 4.3.0 Error: queue file write error (in reply to end of DATA command))
May 24 13:21:56 server postfix/smtp[20159]: warning: connect to mysql server 127.0.0.1: Can't connect to MySQL server on '127.0.0.1' (111)
May 24 13:21:56 server postfix/smtp[20159]: warning: mysql:/etc/postfix/mysql-virtual_relaydomains.cf: table lookup problem
May 24 13:21:56 server postfix/smtp[20159]: warning: 389191E0F50: flush service failure

Last edited by DUCKFACE; 24th May 2013 at 13:44.
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Gmail and Port25 Email Test Require IPv6 addresses now bpmee Server Operation 0 3rd April 2013 08:40
Email delivery problem - Ubuntu Karmic Koala (Ubuntu 9.10) [ISPConfig 2] qiubosu General 58 16th April 2010 13:24
Email delivery problem - Ubuntu Karmic Koala (Ubuntu 9.10) [ISPConfig 2] qiubosu Installation/Configuration 1 18th January 2010 10:21
hotmail rejects outgoing email nzimas Server Operation 3 1st May 2009 04:39
email forwarding locally consumes all resources rdells General 20 1st May 2006 20:43


All times are GMT +2. The time now is 01:14.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.