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 5 Times in 5 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: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,751 Times in 2,581 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 5 Times in 5 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 5 Times in 5 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 5 Times in 5 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
  #7  
Old 24th May 2013, 14:17
monkfish monkfish is offline
HowtoForge Supporter
 
Join Date: Mar 2013
Posts: 106
Thanks: 9
Thanked 15 Times in 14 Posts
Default

Quote:
how to see the password for ispconfig user in ispconfig database?
Told you that in post #5?

Think about the config - what interacts with the mysql databases and where are you going to find the files?

In this case I would look in any of the /etc/postfix/mysql-virtual_ files

I would also look in /etc/dovecot/dovecot-sql.conf

Or authlib config files, or even amavisd config files.


Seems like the mysql ispconfig username/password recorded in those files does not match permissions on the actual database itself. Have you manually copied SQL tables from somewhere else?

You could investigate whether or not to set permissions via a SQL "GRANT" statement on the database.

However, you might find the easiest way is to run update_from_tgz.sh and then answer "yes" to reconfigure database permissions.

Last edited by monkfish; 24th May 2013 at 14:20. Reason: places to find config
Reply With Quote
  #8  
Old 4th June 2013, 18:13
DUCKFACE DUCKFACE is offline
Member
 
Join Date: Dec 2008
Location: Bulgaria
Posts: 95
Thanks: 2
Thanked 5 Times in 5 Posts
Default

the password in mysql_virtual_clint.cf is diferent than the one set for the database. i check it by phpmuadmin. it starts with * .. (it suppose to be in md5 rith).
what is the easy whay to fix that?
Reply With Quote
  #9  
Old 5th June 2013, 01:14
monkfish monkfish is offline
HowtoForge Supporter
 
Join Date: Mar 2013
Posts: 106
Thanks: 9
Thanked 15 Times in 14 Posts
Default

Hello Duckface

The password specified in the file is the ispconfig user password. You need to ascertain if its just the file thats wrong, or whether its wider spread on your server.

The password in mysql_virtual_client.cf *should* be the same as all the other config files:

Code:
grep password /etc/postfix/mysql-virtual_*.cf
should return ALL the SAME password which *should* be the same as both config files for your ispconfig in the filenames

ispconfig/interface/lib/config.inc.php
ispconfig/server/lib/config.inc.php

If they ALL match then the issue is the password is incorrect. I would be surprised if your backend is working correctly in that case.

However, if you establish the password is indeed incorrect then http://dev.mysql.com/doc/refman/5.0/...-password.html may help you to reset it.
Don't forget you will be resetting the MYSQL ispconfig user password for access to the dbispconfig database and not the admin password inside the dbispconfig sys_user table.

Perhaps the easiest way will be to use phpmyadmin to reset it.

Hope that makes sense.

Last edited by monkfish; 5th June 2013 at 01:15. Reason: typo
Reply With Quote
  #10  
Old 6th June 2013, 14:38
DUCKFACE DUCKFACE is offline
Member
 
Join Date: Dec 2008
Location: Bulgaria
Posts: 95
Thanks: 2
Thanked 5 Times in 5 Posts
 
Default passwords match

mysql_virtual_client.cf , /etc/postfix/mysql-virtual_*.cf , ispconfig/interface/lib/config.inc.php and ispconfig/server/lib/config.inc.php are with same password. so i suppose to change the password in mysql table for user ispconfig? how am i suppose to make it the same as the one in the mysql_virtual_client.cf? i see it now in phpmyadmin it starts with * and its diferent than in mysql_virtual_client.cf. are they both in MD5 ?
what is the easiest way ?
thanks for the answers monkfish
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:50.


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