Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > HOWTO-Related Questions

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #71  
Old 28th November 2008, 17:45
Nehalem Nehalem is offline
Junior Member
 
Join Date: Nov 2008
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I have just figured out what went wrong with help by a friend of mine.

libpam-mysql was not installed.

Maybe I missed it in your tutorial, I don't know. Now it works perfectly well
Thanks for your support
Reply With Quote
Sponsored Links
  #72  
Old 22nd December 2008, 01:26
rule3 rule3 is offline
Junior Member
 
Join Date: Dec 2008
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I am trying to install this whole thing to Ubuntu 8.10

At the moment that is not work is:

/home/vmail/

MTA whatever not make domain folders or even user folders..


mail.info

Code:
Dec 21 23:28:32 server amavis[4283]: (04283-02) (!)rw_loop: leaving rw loop, no progress
Dec 21 23:28:32 server amavis[4283]: (04283-02) Negative SMTP resp. to DATA: 
Dec 21 23:28:32 server amavis[4283]: (04283-02) (!)FWD via SMTP: <root@sever.domain.tld> -> <testmail@sever.domain.tld>,BODY=7BIT 451 4.5.0 No resp. to MAIL FROM, id=04283-02, from MTA([127.0.0.1]:10025): 
Dec 21 23:28:32 server amavis[4283]: (04283-02) Blocked MTA-BLOCKED, <root@sever.domain.tld> -> <testmail@sever.domain.tld>, Message-ID: <20081221192508.A3E214FB3DC@sever.domain.tld>, mail_id: mtem81lxOSi7, Hits: -0.001, size: 358, 539499 ms
Dec 21 23:28:32 server postfix/smtp[10579]: A3E214FB3DC: to=<testmail@sever.domain.tld>, relay=127.0.0.1[127.0.0.1]:10024, delay=14603, delays=14064/0.01/0/539, dsn=4.5.0, status=deferred (host 127.0.0.1[127.0.0.1] said: 451 4.5.0 No resp. to MAIL FROM, id=04283-02, from MTA([127.0.0.1]:10025):  (in reply to end of DATA command))
Dec 21 23:28:32 server postfix/smtp[10579]: connect to sever.domain.tld[232.56.78.21]:10024: Connection refused
Dec 21 23:28:32 server postfix/smtp[10579]: 4197B4FB3E3: to=<testmail@sever.domain.tld>, relay=none, delay=12013, delays=11773/240/0/0, dsn=4.4.1, status=deferred (connect to sever.domain.tld[232.56.78.21]:10024: Connection refused)
Dec 21 23:28:32 server amavis[4284]: (04284-02) (!)rw_loop: leaving rw loop, no progress
Dec 21 23:28:32 server amavis[4284]: (04284-02) Negative SMTP resp. to DATA: 
Dec 21 23:28:32 server amavis[4284]: (04284-02) (!)FWD via SMTP: <root@sever.domain.tld> -> <testmail@sever.domain.tld>,BODY=7BIT 451 4.5.0 No resp. to MAIL FROM, id=04284-02, from MTA([127.0.0.1]:10025): 
Dec 21 23:28:32 server amavis[4284]: (04284-02) Blocked MTA-BLOCKED, <root@sever.domain.tld> -> <testmail@sever.domain.tld>, Message-ID: <20081221194537.E38E84FB3E1@sever.domain.tld>, mail_id: ToQO9X9jEluN, Hits: -0.001, size: 362, 540330 ms
Dec 21 23:28:32 server postfix/smtp[10580]: E38E84FB3E1: to=<testmail@sever.domain.tld>, relay=127.0.0.1[127.0.0.1]:10024, delay=13375, delays=12835/0.01/0/540, dsn=4.5.0, status=deferred (host 127.0.0.1[127.0.0.1] said: 451 4.5.0 No resp. to MAIL FROM, id=04284-02, from MTA([127.0.0.1]:10025):  (in reply to end of DATA command))
Dec 21 23:28:49 server postfix/proxymap[10591]: warning: connect to mysql server 127.0.0.1: Can't connect to MySQL server on '127.0.0.1' (111)
Dec 21 23:28:49 server postfix/proxymap[10591]: warning: connect to mysql server 127.0.0.1: Can't connect to MySQL server on '127.0.0.1' (111)
Dec 21 23:28:49 server postfix/trivial-rewrite[11201]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem
Dec 21 23:28:49 server postfix/trivial-rewrite[11202]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem
Dec 21 23:28:49 server postfix/trivial-rewrite[11203]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem

Dec 22 00:25:19 server postfix/proxymap[2510]: warning: connect to mysql server 127.0.0.1: Can't connect to MySQL server on '127.0.0.1' (111)
Dec 22 00:25:19 server postfix/proxymap[2510]: warning: connect to mysql server 127.0.0.1: Can't connect to MySQL server on '127.0.0.1' (111)
Dec 22 00:25:19 server postfix/trivial-rewrite[4182]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem
Dec 22 00:25:19 server postfix/trivial-rewrite[4183]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem
Dec 22 00:25:19 server postfix/trivial-rewrite[4184]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem
Dec 22 00:25:19 server postfix/trivial-rewrite[4185]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem
Dec 22 00:25:19 server postfix/trivial-rewrite[4186]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem
Dec 22 00:25:19 server postfix/trivial-rewrite[4187]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem
Dec 22 00:25:19 server postfix/trivial-rewrite[4188]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem
Dec 22 00:25:19 server postfix/trivial-rewrite[4189]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem
Dec 22 00:25:19 server postfix/trivial-rewrite[4191]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem
Dec 22 00:25:19 server postfix/trivial-rewrite[4190]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem
Dec 22 00:25:19 server postfix/trivial-rewrite[4192]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem
mail.err

Code:
Dec 22 00:27:21 server postfix/trivial-rewrite[4212]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem
Dec 22 00:27:21 server postfix/trivial-rewrite[4213]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem
Dec 22 00:27:21 server postfix/trivial-rewrite[4214]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem
Dec 22 00:28:22 server postfix/trivial-rewrite[4215]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem
Dec 22 00:28:22 server postfix/trivial-rewrite[4216]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem
Dec 22 00:28:22 server postfix/trivial-rewrite[4217]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem
Dec 22 00:28:22 server postfix/trivial-rewrite[4219]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem
Dec 22 00:28:22 server postfix/trivial-rewrite[4218]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem
Dec 22 00:28:22 server postfix/trivial-rewrite[4220]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem
Dec 22 00:28:22 server postfix/trivial-rewrite[4221]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem
Dec 22 00:28:22 server postfix/trivial-rewrite[4222]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem
Dec 22 00:28:22 server postfix/trivial-rewrite[4224]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem
Dec 22 00:28:22 server postfix/trivial-rewrite[4223]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem
Dec 22 00:28:22 server postfix/trivial-rewrite[4225]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem
I am tested everything a hours but I don't find a issue..

Courier seams to transfert email to Thunderbird is I making mail dir manually and then place come .txt file to new dir...

So there is some errors to connect Db..
fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem

And this

forge amavis[4284]: (04284-02) Blocked MTA-BLOCKED, <root@sever.domain.tld> -> <testmail@sever.domain.tld>, Message-ID: <20081221194537.E38E84FB3E1@sever.domain.tld>, mail_id: ToQO9X9jEluN, Hits: -0.001, size: 362, 540330 ms

Btw, I did not do everythig similar in HowTo and not going to do because I can not really change mysql bind-address to 127.0.0.1

Every other mysql connections works..

Last edited by rule3; 22nd December 2008 at 17:01.
Reply With Quote
  #73  
Old 22nd December 2008, 02:51
rule3 rule3 is offline
Junior Member
 
Join Date: Dec 2008
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi, I edited all, mysql host setings to localhost instead 127.0.0.1...

Now there is a line

Code:
Dec 22 01:43:19 server postfix/smtpd[5526]: warning: connect to mysql server localhost: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Dec 22 01:40:51 server postfix/cleanup[5529]: warning: connect to mysql server localhost: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Dec 22 01:40:51 server postfix/cleanup[5529]: warning: D7E5F4FB3E7: virtual_alias_maps map lookup problem for postmaster@sever.domain.tld
No other MySQL connect errors..

So... some functions of postfix tries to use socket.. instead TCP/IP connection.. my server is confed to use MySQL bind-address for external use if domain is in MySQL user's host.
And that setting can not be or I can not go to change..

MTA do not get needed information to transfert mail to /var/vmail/sever.doamin.tld/testmail ...

And when this is fixed there will be a next issue..

Last edited by rule3; 22nd December 2008 at 17:00.
Reply With Quote
  #74  
Old 22nd December 2008, 11:46
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,744 Times in 2,577 Posts
Default

What's in /etc/postfix/mysql-virtual_domains.cf?
__________________
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
  #75  
Old 22nd December 2008, 15:30
rule3 rule3 is offline
Junior Member
 
Join Date: Dec 2008
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by falko View Post
What's in /etc/postfix/mysql-virtual_domains.cf?
Code:
user = mail_admin
password = mail_admin_password
dbname = mail
query = SELECT domain AS virtual FROM domains WHERE domain='%s'
hosts = localhost
mail_admin_password is same in other files and removed from this reply
Reply With Quote
  #76  
Old 22nd December 2008, 16:04
rule3 rule3 is offline
Junior Member
 
Join Date: Dec 2008
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi,

I changed all hosts for MySQL to serve.domain.tld and allowed user access with domain serve.domain.tld

No MySQL-errors anymore..

I get bumerang mail.. when I tru to sent mail to my test address..

<testmail@serve.domain.tld>: mail for
server.domain.tld loops back to myself


In logs email is removed by some reason "mail for
server.domain.tld loops back to myself"


And yes in transtport table we have
domain: server.domain.tld
transport: smtp:server.domain.tld

Code:
Dec 22 14:57:43 server postfix/smtpd[16274]: connect from emh06.mail.isp.tld[34.78.6.111]
Dec 22 14:57:43 server postfix/smtpd[16274]: 2D3AE4FB3D5: client=emh06.mail.isp.tld[34.78.6.111]
Dec 22 14:57:43 server postfix/cleanup[16279]: 2D3AE4FB3D5: message-id=<494FAAFC.2010606@domain.tld>
Dec 22 14:57:43 server postfix/qmgr[16263]: 2D3AE4FB3D5: from=<logan@domain.tld>, size=1642, nrcpt=1 (queue active)
Dec 22 14:57:43 server postfix/smtpd[16274]: disconnect from emh06.mail.isp.tld[34.78.6.111]
Dec 22 14:57:45 server postfix/smtpd[16286]: connect from localhost[127.0.0.1]
Dec 22 14:57:45 server postfix/smtpd[16286]: BB3174FB3FF: client=localhost[127.0.0.1]
Dec 22 14:57:45 server postfix/cleanup[16279]: BB3174FB3FF: message-id=<494FAAFC.2010606@domain.tld>
Dec 22 14:57:45 server postfix/qmgr[16263]: BB3174FB3FF: from=<logan@domain.tld>, size=2181, nrcpt=1 (queue active)
Dec 22 14:57:45 server postfix/trivial-rewrite[16366]: warning: do not list domain server.domain.tld in BOTH mydestination and virtual_mailbox_domains
Dec 22 14:57:45 server postfix/smtpd[16286]: disconnect from localhost[127.0.0.1]
Dec 22 14:57:45 server amavis[13303]: (13303-10) Passed CLEAN, [34.78.6.111] [11.11.11.23] <logan@domain.tld> -> <testmail@server.somain.tld, Message-ID: <494FAAFC.2010606@domain.tld>, mail_id: u-TE8m2RH+wi, Hits: 0, size: 1642, queued_as: BB3174FB3FF, 2571 ms
Dec 22 14:57:45 server postfix/smtp[16280]: 2D3AE4FB3D5: to=<testmail@server.somain.tld, relay=127.0.0.1[127.0.0.1]:10024, delay=2.6, delays=0.05/0/0/2.6, dsn=2.0.0, status=sent (250 2.0.0 Ok, id=13303-10, from MTA([127.0.0.1]:10025): 250 2.0.0 Ok: queued as BB3174FB3FF)
Dec 22 14:57:45 server postfix/qmgr[16263]: 2D3AE4FB3D5: removed
Dec 22 14:57:45 server postfix/smtp[16287]: BB3174FB3FF: to=<testmail@server.somain.tld, relay=none, delay=0.01, delays=0.01/0/0/0, dsn=5.4.6, status=bounced (mail for server.domain.tld loops back to myself)
Dec 22 14:57:45 server postfix/cleanup[16279]: C39F64FB3D5: message-id=<20081222145745.C39F64FB3D5@server.somain.tld
Dec 22 14:57:45 server postfix/qmgr[16263]: C39F64FB3D5: from=<>, size=4302, nrcpt=1 (queue active)
Dec 22 14:57:45 server postfix/bounce[16308]: BB3174FB3FF: sender non-delivery notification: C39F64FB3D5
Dec 22 14:57:45 server postfix/qmgr[16263]: BB3174FB3FF: removed
Dec 22 14:57:45 server postfix/smtp[16287]: C39F64FB3D5: to=<logan@domain.tld>, relay=mail.domain.tld[194.79.16.40]:25, delay=0.13, delays=0.01/0/0.01/0.11, dsn=2.0.0, status=sent (250 ok 1229957865 qp 15717)
Dec 22 14:57:45 server postfix/qmgr[16263]: C39F64FB3D5: removed
And on testmail folder haves now a courierpop3dsizelist

Content:

/2 3 1229904926
somecofigureddomain.domaid.tld:2, 3686 2:1229904926

And that domain fo not belongs to whole thing..

Last edited by rule3; 22nd December 2008 at 17:10.
Reply With Quote
  #77  
Old 23rd December 2008, 10:31
rule3 rule3 is offline
Junior Member
 
Join Date: Dec 2008
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I got everytihng to work..

Issue was simple:

Just forget the 127.0.0.1 host and use yourserver.domain.tld for MySQL and make MySQL user with that host

Plese be sure you can not use emails like test@yourserver.domain.tld use emails like test@domain.tld
Wathever other... is confed to your sever at some DNS.. in fact you can not use emails with that address which is your SMTP/POP/IMAP host.. so use some other domain.

Last edited by rule3; 23rd December 2008 at 10:37.
Reply With Quote
  #78  
Old 30th December 2008, 21:14
rule3 rule3 is offline
Junior Member
 
Join Date: Dec 2008
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default

...

Finally I got it work but sometimes mail server not response

Last edited by rule3; 31st December 2008 at 05:56.
Reply With Quote
  #79  
Old 27th January 2009, 16:47
klangen klangen is offline
Junior Member
 
Join Date: Jan 2009
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default Problem with domain alias.

Thanks for a really good guide. Really helped me alot!

I do have one problem though.

I can't get the domain forwards to work (@example.com > @anotherdomain.tld).
All the other forwards work (catch all etc).
Anyone else have this problem?
Reply With Quote
  #80  
Old 28th January 2009, 18:23
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,744 Times in 2,577 Posts
 
Default

Any errors in your mail log?
__________________
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
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
Virtual Users And Domains With Postfix, Courier, MySQL And SquirrelMail (Ubuntu 8.04) canardwc HOWTO-Related Questions 12 29th May 2008 18:29
Virtual Users And Domains With Postfix, Courier And MySQL (Ubuntu 7.10) ShadyB HOWTO-Related Questions 1 1st April 2008 18:00
Virtual Users And Domains W/ Postfix, Courier and MySql + Squirrelmail prob nsurge HOWTO-Related Questions 10 23rd October 2006 17:43
Virtual Users And Domains W/ Postfix, Courier and MySql + Squirrelmail prob kwinnuxbie HOWTO-Related Questions 7 22nd October 2006 19:26
Autoreply problem using Virtual Users And Domains With Postfix, Courier And MySQL triak HOWTO-Related Questions 1 19th May 2006 15:25


All times are GMT +2. The time now is 02:12.


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