Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > Installation/Configuration
Reload this Page Another Problem: Virtual Users And Domains With Postfix, Courier And MySQL (+ SMTP
Register FAQ Members List Social Groups Calendar Search Today's Posts Mark Forums Read

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
Page 2 of 3 1 2 3
 
Thread Tools Display Modes
  #11  
Old 20th February 2006, 15:43
falko falko is offline
Super Moderator
  
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,665
Thanks: 1,896
Thanked 2,595 Times in 2,446 Posts
Default
What's in the 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
Sponsored Links
  #12  
Old 21st February 2006, 01:09
bluegrass bluegrass is offline
Member
  
Join Date: Jan 2006
Location: Pinas
Posts: 51
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to bluegrass
Default
Quote:
Originally Posted by falko
What's in the mail log?
Here's the latest mail log I get, when I tested sending email...

Feb 20 17:30:07 debbie imaplogin: Connection, ip=[::ffff:203.177.xx.xx]
Feb 20 17:30:07 debbie imaplogin: LOGIN, user=rtjuarez@cpu.xxx.xx, ip=[::ffff:203.177.xx.xx], protocol=IMAP
Feb 20 17:31:03 debbie postfix/proxymap[4514]: warning: connect to mysql server 127.0.0.1: Lost connection to MySQL server during query
Feb 20 17:31:03 debbie postfix/proxymap[4514]: warning: connect to mysql server 127.0.0.1: Lost connection to MySQL server during query
Feb 20 17:31:03 debbie postfix/trivial-rewrite[4695]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,100): table lookup problem
Feb 20 17:31:03 debbie postfix/trivial-rewrite[4696]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,100): table lookup problem
Feb 20 17:31:03 debbie postfix/trivial-rewrite[4697]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,100): table lookup problem
Feb 20 17:31:03 debbie postfix/trivial-rewrite[4698]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,100): table lookup problem
Feb 20 17:31:03 debbie postfix/trivial-rewrite[4699]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,100): table lookup problem
Feb 20 17:31:04 debbie postfix/smtpd[2297]: warning: premature end-of-input on private/rewrite socket while reading input attribute name
Feb 20 17:31:04 debbie postfix/smtpd[2297]: warning: problem talking to service rewrite: Success
Feb 20 17:31:04 debbie postfix/smtpd[3299]: warning: premature end-of-input on private/rewrite socket while reading input attribute name
Feb 20 17:31:04 debbie postfix/smtpd[3299]: warning: problem talking to service rewrite: Connection reset by peer
Feb 20 17:31:04 debbie postfix/master[1359]: warning: process /usr/lib/postfix/trivial-rewrite pid 4695 exit status 1
Feb 20 17:31:04 debbie postfix/master[1359]: warning: /usr/lib/postfix/trivial-rewrite: bad command startup -- throttling
Feb 20 17:31:04 debbie postfix/master[1359]: warning: process /usr/lib/postfix/trivial-rewrite pid 4696 exit status 1
Feb 20 17:31:04 debbie postfix/smtpd[3301]: warning: premature end-of-input on private/rewrite socket while reading input attribute name
Feb 20 17:31:04 debbie postfix/smtpd[3301]: warning: problem talking to service rewrite: Success
Feb 20 17:31:04 debbie postfix/smtpd[4341]: warning: premature end-of-input on private/rewrite socket while reading input attribute name
Feb 20 17:31:04 debbie postfix/smtpd[4341]: warning: problem talking to service rewrite: Connection reset by peer
Feb 20 17:31:04 debbie postfix/master[1359]: warning: process /usr/lib/postfix/trivial-rewrite pid 4697 exit status 1
Feb 20 17:31:04 debbie postfix/smtpd[4523]: warning: premature end-of-input on private/rewrite socket while reading input attribute name
Feb 20 17:31:04 debbie postfix/smtpd[4523]: warning: problem talking to service rewrite: Success
Feb 20 17:31:04 debbie postfix/smtpd[4537]: warning: premature end-of-input on private/rewrite socket while reading input attribute name
Feb 20 17:31:04 debbie postfix/smtpd[4537]: warning: problem talking to service rewrite: Connection reset by peer
Feb 20 17:31:04 debbie postfix/master[1359]: warning: process /usr/lib/postfix/trivial-rewrite pid 4698 exit status 1
Feb 20 17:31:04 debbie postfix/smtpd[3179]: warning: premature end-of-input on private/rewrite socket while reading input attribute name
Feb 20 17:31:04 debbie postfix/smtpd[3179]: warning: problem talking to service rewrite: Success
Feb 20 17:31:04 debbie postfix/smtpd[2359]: warning: premature end-of-input on private/rewrite socket while reading input attribute name
Feb 20 17:31:04 debbie postfix/smtpd[2359]: warning: problem talking to service rewrite: Connection reset by peer
Feb 20 17:31:04 debbie postfix/master[1359]: warning: process /usr/lib/postfix/trivial-rewrite pid 4699 exit status 1
Feb 20 17:31:04 debbie postfix/qmgr[4642]: warning: premature end-of-input on private/rewrite socket while reading input attribute name
Feb 20 17:31:04 debbie postfix/qmgr[4642]: warning: problem talking to service rewrite: Success
Feb 20 17:31:04 debbie postfix/smtpd[4644]: warning: premature end-of-input on private/rewrite socket while reading input attribute name
Feb 20 17:31:04 debbie postfix/smtpd[4644]: warning: problem talking to service rewrite: Connection reset by peer
Reply With Quote
  #13  
Old 21st February 2006, 10:04
falko falko is offline
Super Moderator
  
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,665
Thanks: 1,896
Thanked 2,595 Times in 2,446 Posts
Default
Quote:
Feb 20 17:31:03 debbie postfix/proxymap[4514]: warning: connect to mysql server 127.0.0.1: Lost connection to MySQL server during query
Is MySQL running? Please post the output of
Code:
netstat -tap
Also, compare your configuration files with the ones from the tutorial. Make sure the format (white spaces, etc.) is the same.
__________________
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
  #14  
Old 22nd February 2006, 00:43
bluegrass bluegrass is offline
Member
  
Join Date: Jan 2006
Location: Pinas
Posts: 51
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to bluegrass
Default
Quote:
Originally Posted by falko
Is MySQL running? Please post the output of
Code:
netstat -tap
Here's the output of netstat -tap
Code:
Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address           Foreign Address         State       PID/Program name   
tcp        0      0 *:tcpmux                *:*                     LISTEN     1516/portsentry     
tcp        0      0 *:imaps                 *:*                     LISTEN     1128/couriertcpd    
tcp        0      0 *:20034                 *:*                     LISTEN     1516/portsentry     
tcp        0      0 *:32771                 *:*                     LISTEN     1516/portsentry     
tcp        0      0 *:pop3s                 *:*                     LISTEN     1151/couriertcpd    
tcp        0      0 *:32772                 *:*                     LISTEN     1516/portsentry     
tcp        0      0 *:40421                 *:*                     LISTEN     1516/portsentry     
tcp        0      0 *:32773                 *:*                     LISTEN     1516/portsentry     
tcp        0      0 *:32774                 *:*                     LISTEN     1516/portsentry     
tcp        0      0 localhost.localdo:10024 *:*                     LISTEN     14454/amavisd (mast 
tcp        0      0 *:31337                 *:*                     LISTEN     1516/portsentry     
tcp        0      0 localhost.localdo:10025 *:*                     LISTEN     1359/master         
tcp        0      0 localhost.localdo:mysql *:*                     LISTEN     1223/mysqld         
tcp        0      0 *:ircd                  *:*                     LISTEN     1516/portsentry     
tcp        0      0 *:systat                *:*                     LISTEN     1516/portsentry     
tcp        0      0 *:5742                  *:*                     LISTEN     1516/portsentry     
tcp        0      0 *:pop3                  *:*                     LISTEN     1137/couriertcpd    
tcp        0      0 *:finger                *:*                     LISTEN     1516/portsentry     
tcp        0      0 *:netstat               *:*                     LISTEN     1516/portsentry     
tcp        0      0 *:imap2                 *:*                     LISTEN     1114/couriertcpd    
tcp        0      0 *:sunrpc                *:*                     LISTEN     874/portmap         
tcp        0      0 *:54320                 *:*                     LISTEN     1516/portsentry     
tcp        0      0 *:sieve                 *:*                     LISTEN     1516/portsentry     
tcp        0      0 *:www                   *:*                     LISTEN     1479/apache         
tcp        0      0 *:27665                 *:*                     LISTEN     1516/portsentry     
tcp        0      0 *:auth                  *:*                     LISTEN     1166/inetd          
tcp        0      0 *:ingreslock            *:*                     LISTEN     1516/portsentry     
tcp        0      0 *:ftp                   *:*                     LISTEN     1372/pure-ftpd (SER 
tcp        0      0 *:ssh                   *:*                     LISTEN     1389/sshd           
tcp        0      0 *:nntp                  *:*                     LISTEN     1516/portsentry     
tcp        0      0 *:socks                 *:*                     LISTEN     1516/portsentry     
tcp        0      0 *:728                   *:*                     LISTEN     1394/rpc.statd      
tcp        0      0 *:12345                 *:*                     LISTEN     1516/portsentry     
tcp        0      0 *:smtp                  *:*                     LISTEN     1359/master         
tcp        0      0 *:12346                 *:*                     LISTEN     1516/portsentry     
tcp        0      0 *:635                   *:*                     LISTEN     1516/portsentry     
tcp        0      0 *:49724                 *:*                     LISTEN     1516/portsentry     
tcp        0      0 *:uucp                  *:*                     LISTEN     1516/portsentry     
tcp        0      0 localhost.localdo:mysql localhost.localdo:37300 TIME_WAIT  -                   
tcp        0     52 192.168.0.3:ssh         192.168.1.9:1110        ESTABLISHED11585/0             
tcp        0      0 localhost.localdo:mysql localhost.localdo:37299 TIME_WAIT  -
Quote:
Originally Posted by falko
Also, compare your configuration files with the ones from the tutorial. Make sure the format (white spaces, etc.) is the same.
Yes, all configuration files are the same. As I have mentioned before, when I was still using a test ip of 192.168.0.2, it was running fine, but when I put the server on a production environment with a class 'a' ip of 10.0.0.2, the mail system doesn't work.
Reply With Quote
  #15  
Old 22nd February 2006, 08:53
till till is offline
Super Moderator
  
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 31,911
Thanks: 693
Thanked 4,198 Times in 3,213 Posts
Default
Did you get any error messages in your mail log? have you changed the IP in /etc/network/interfaces
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #16  
Old 22nd February 2006, 09:28
bluegrass bluegrass is offline
Member
  
Join Date: Jan 2006
Location: Pinas
Posts: 51
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to bluegrass
Default
Quote:
Originally Posted by till
Did you get any error messages in your mail log? have you changed the IP in /etc/network/interfaces
yes that was the first file i changed, then restarted the network. here are the files i have so far edited.

/etc/network/interfaces
Code:
# This file describes the network interfaces available on your system
# and how to activate them. For more information, see interfaces(5).

# The loopback network interface
auto lo
iface lo inet loopback

# The primary network interface
auto eth0
#iface eth0 inet static
#	address 192.168.0.2
#	netmask 255.255.255.0
#	network 192.168.0.0
#	broadcast 192.168.0.255
#	gateway 192.168.0.100
iface eth0 inet static
	address 10.0.0.2
	netmask 255.255.255.240
	network 10.10.0.0
	broadcase 10.0.0.15
	gateway 10.0.0.1
/etc/resolv.conf
Code:
search
nameserver 10.0.0.1
nameserver 203.177.255.10
nameserver 203.177.3.100
/etc/hosts
Code:
127.0.0.1	localhost.localdomain	localhost	debbie
10.0.0.2	debbie.cpu.***.**	debbie

# The following lines are desirable for IPv6 capable hosts
::1     ip6-localhost ip6-loopback
fe00::0 ip6-localnet
ff00::0 ip6-mcastprefix
ff02::1 ip6-allnodes
ff02::2 ip6-allrouters
ff02::3 ip6-allhosts
Reply With Quote
  #17  
Old 22nd February 2006, 09:47
falko falko is offline
Super Moderator
  
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,665
Thanks: 1,896
Thanked 2,595 Times in 2,446 Posts
Default
Quote:
Originally Posted by bluegrass
yes that was the first file i changed, then restarted the network. here are the files i have so far edited.

/etc/network/interfaces
Code:
# This file describes the network interfaces available on your system
# and how to activate them. For more information, see interfaces(5).

# The loopback network interface
auto lo
iface lo inet loopback

# The primary network interface
auto eth0
#iface eth0 inet static
#	address 192.168.0.2
#	netmask 255.255.255.0
#	network 192.168.0.0
#	broadcast 192.168.0.255
#	gateway 192.168.0.100
iface eth0 inet static
	address 10.0.0.2
	netmask 255.255.255.240
	network 10.10.0.0
	broadcase 10.0.0.15
	gateway 10.0.0.1
You have a typo there, it should be
Code:
broadcast 10.0.0.15
__________________
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
  #18  
Old 22nd February 2006, 10:17
bluegrass bluegrass is offline
Member
  
Join Date: Jan 2006
Location: Pinas
Posts: 51
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to bluegrass
Default
Quote:
Originally Posted by falko
You have a typo there, it should be
Code:
broadcast 10.0.0.15
aargh.... thanks falko... okay now i corrected the typo and restarted actually the server in order to restart all services.... then i tested telnet, here's an output of the telnet....

Code:
debbie:~# telnet localhost 25
Trying 127.0.0.1...
Connected to localhost.localdomain.
Escape character is '^]'.
220 debbie.cpu.edu.ph ESMTP Postfix (Debian/GNU)
mail from:<royski_it2004@yahoo.com>
^]
telnet> quit
Connection closed.
debbie:~#
I have to disconnect because it just stop after entering the "mail from" sentence.

here's the mail log:
Code:
Feb 22 17:21:50 debbie postfix/qmgr[1369]: warning: premature end-of-input on private/rewrite socket while reading input attribute name
Feb 22 17:21:50 debbie postfix/qmgr[1369]: warning: problem talking to service rewrite: Success
Feb 22 17:21:50 debbie postfix/cleanup[1370]: warning: premature end-of-input on private/rewrite socket while reading input attribute name
Feb 22 17:21:50 debbie postfix/cleanup[1370]: warning: problem talking to service rewrite: Connection reset by peer
Feb 22 17:21:50 debbie postfix/master[1359]: warning: process /usr/lib/postfix/trivial-rewrite pid 2328 exit status 1
Feb 22 17:21:50 debbie postfix/master[1359]: warning: /usr/lib/postfix/trivial-rewrite: bad command startup -- throttling
Feb 22 17:21:50 debbie postfix/smtpd[2207]: warning: premature end-of-input on private/rewrite socket while reading input attribute name
Feb 22 17:21:50 debbie postfix/smtpd[2207]: warning: problem talking to service rewrite: Success
Feb 22 17:21:50 debbie postfix/smtpd[2255]: warning: premature end-of-input on private/rewrite socket while reading input attribute name
Feb 22 17:21:50 debbie postfix/smtpd[2255]: warning: problem talking to service rewrite: Connection reset by peer
Feb 22 17:21:50 debbie postfix/master[1359]: warning: process /usr/lib/postfix/trivial-rewrite pid 2329 exit status 1
Feb 22 17:21:50 debbie postfix/smtpd[2306]: warning: premature end-of-input on private/rewrite socket while reading input attribute name
Feb 22 17:21:50 debbie postfix/smtpd[2306]: warning: problem talking to service rewrite: Success
Feb 22 17:21:50 debbie postfix/master[1359]: warning: process /usr/lib/postfix/trivial-rewrite pid 2330 exit status 1
Feb 22 17:22:12 debbie postfix/qmgr[1369]: fatal: watchdog timeout
Feb 22 17:22:13 debbie postfix/master[1359]: warning: process /usr/lib/postfix/qmgr pid 1369 exit status 1
Feb 22 17:22:13 debbie postfix/master[1359]: warning: /usr/lib/postfix/qmgr: bad command startup -- throttling
Feb 22 17:22:23 debbie postfix/pickup[1368]: fatal: watchdog timeout
Feb 22 17:22:24 debbie postfix/master[1359]: warning: process /usr/lib/postfix/pickup pid 1368 exit status 1
Feb 22 17:22:25 debbie postfix/pickup[2331]: CD4CA7BC160: uid=110 from=<logcheck>
Reply With Quote
  #19  
Old 22nd February 2006, 18:43
falko falko is offline
Super Moderator
  
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,665
Thanks: 1,896
Thanked 2,595 Times in 2,446 Posts
Default
Maybe you should consider redoing the Postfix configuration again, as close as possible to the tutorial... You seem to have some problems there...
__________________
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
  #20  
Old 23rd February 2006, 00:39
bluegrass bluegrass is offline
Member
  
Join Date: Jan 2006
Location: Pinas
Posts: 51
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to bluegrass
 
Default
Quote:
Originally Posted by falko
Maybe you should consider redoing the Postfix configuration again, as close as possible to the tutorial... You seem to have some problems there...

Thanks, falko. Actually I've been considering to re-do everything, from scratch using the class 'a' private ip instead of the test ip (class 'c'), but I was just curious why it didn't work when i just changed the ip's. Anyway, I'll give you some updates on the outcome.

BTW, can you PM to me on how & what I can possibly give to help for this 'how to' site keep on running.
Reply With Quote
Reply
Page 2 of 3 1 2 3

Bookmarks

« Previous Thread | Next Thread »
Thread Tools
Display Modes
Linear Mode Linear Mode

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 And MySQL (+ SMTP-AUTH, Quota... killfrog HOWTO-Related Questions 3 25th September 2009 21:45
Virtual Users + Domains With Postfix, Courier + MySQL (+SMTP-AUTH, SpamA, ClamAV) brianwc HOWTO-Related Questions 6 9th May 2007 02:44
Virtual Users And Domains With Postfix, Courier And MySQL (+ SMTP-AUTH, Quota, SpamAs Rocky Installation/Configuration 24 9th February 2006 11:08
Backup the Virtual Users And Domains With Postfix, Courier And MySQL (+ SMTP-AUTH, Qu rogierbanis HOWTO-Related Questions 1 13th January 2006 09:34
Virtual Users And Domains With Postfix, Courier And MySQL: POP/IMAP authentication SeanG HOWTO-Related Questions 3 1st January 2006 17:08


All times are GMT +2. The time now is 23:29.

Contact Us - HowtoForge - Linux Howtos and Tutorials - Archive - Top

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