HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   Installation/Configuration (http://www.howtoforge.com/forums/forumdisplay.php?f=27)
-   -   cant sedn email trought sqirrelmail (http://www.howtoforge.com/forums/showthread.php?t=61876)

DUCKFACE 17th May 2013 22:06

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 ?

falko 18th May 2013 07:37

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.

DUCKFACE 18th May 2013 08:46

its working.
all of the sites has mysql support

DUCKFACE 22nd May 2013 16:40

anyone help ?

monkfish 22nd May 2013 17:12

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?

DUCKFACE 24th May 2013 12:03

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

monkfish 24th May 2013 13:17

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.

DUCKFACE 4th June 2013 17:13

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?

monkfish 5th June 2013 00:14

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.

DUCKFACE 6th June 2013 13:38

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 :)


All times are GMT +2. The time now is 05:11.

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