Virtual Users And Domains With Postfix, Courier, MySQL And SquirrelMail Can't telnet

Hello everyone,

I have been following the tutorial on Virtual Users And Domains With Postfix, Courier, MySQL And SquirrelMail (Ubuntu 8.10), and I am stuck on step where you have to telnet into local host. when I try to telent localhost pop3 this is my output. Also FYI i am running Jaunti not intrepid.

Trying ::1...
Trying 127.0.0.1...
telnet: Unable to connect to remote host: Connection refused

I've done some searching and I think I know where the problem lies but don't know how to fix it. My out put of netstat -tap | grep mysql is this

tcp 0 0 localhost:mysql *:* LISTEN 11598/mysqld

which not the same out put as in the tutorial

also after scrumeging around google I ran netstat -napt
and the something about the first line doesn't make sense

Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
tcp 0 0 127.0.0.1:3306 0.0.0.0:* LISTEN 11598/mysqld
tcp 0 0 0.0.0.0:10000 0.0.0.0:* LISTEN 2621/perl
tcp 0 0 0.0.0.0:80 0.0.0.0:* LISTEN 2594/apache2
tcp 0 0 74.63.90.38:53 0.0.0.0:* LISTEN 2094/named
tcp 0 0 74.63.90.37:53 0.0.0.0:* LISTEN 2094/named
tcp 0 0 74.63.90.36:53 0.0.0.0:* LISTEN 2094/named
tcp 0 0 74.63.90.35:53 0.0.0.0:* LISTEN 2094/named
tcp 0 0 74.63.90.34:53 0.0.0.0:* LISTEN 2094/named
tcp 0 0 67.159.45.60:53 0.0.0.0:* LISTEN 2094/named
tcp 0 0 127.0.0.1:53 0.0.0.0:* LISTEN 2094/named
tcp 0 0 0.0.0.0:22 0.0.0.0:* LISTEN 2116/sshd
tcp 0 0 0.0.0.0:25 0.0.0.0:* LISTEN 27431/master
tcp 0 0 127.0.0.1:953 0.0.0.0:* LISTEN 2094/named
tcp 0 240 67.159.45.60:22 99.141.66.13:51067 ESTABLISHED 29304/sshd: patrick
tcp 0 0 67.159.45.60:22 99.141.66.13:51062 ESTABLISHED 29202/sshd: patrick
tcp 0 0 67.159.45.60:22 99.141.66.13:50911 ESTABLISHED 26644/sshd: patrick
tcp6 0 0 :::53 :::* LISTEN 2094/named
tcp6 0 0 :::22 :::* LISTEN 2116/sshd
tcp6 0 0 ::1:953 :::* LISTEN 2094/named

also when I nmap localhost I get the following output
Starting Nmap 4.76 ( http://nmap.org ) at 2009-04-01 10:12 CDT
Warning: Hostname localhost resolves to 2 IPs. Using 127.0.0.1.
Interesting ports on localhost (127.0.0.1):
Not shown: 994 closed ports
PORT STATE SERVICE
22/tcp open ssh
25/tcp open smtp
53/tcp open domain
80/tcp open http
3306/tcp open mysql
10000/tcp open snet-sensor-mgmt

Also don't know if this is important but my mail.err log file is showing this error

Apr 1 07:34:22 lightondesigns postfix/trivial-rewrite[25734]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem




anyone have any idea on what's going?

 

Check /etc/postfix/mysql-virtual_domains.cf to see if your mysql connection settings are correct.
Try ps ax | grep postfix to see if postfix is running.

From what I see, it seems to crash because it can't connect to mysql to get the users table. I'm not sure if it's supposed to crash in this case, though...

My config file looks like this (yours could be a little different):

Code:

user = xxx
password = xxx
dbname = users_database
table = domains
select_field = 'virtual'
where_field = domainname
hosts = 127.0.0.1

 

my_virtual_domains.cf looks like this
user = mail_admin
password = xxx
dbname = mail
query = SELECT domain AS virtual FROM domains WHERE domain='%s'
hosts = 127.0.0.1

also here is the output of ps aux

USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND
root 1 0.0 0.0 3084 1888 ? Ss Mar31 0:01 /sbin/init
root 2 0.0 0.0 0 0 ? S< Mar31 0:00 [kthreadd]
root 3 0.0 0.0 0 0 ? S< Mar31 0:00 [migration/0]
root 4 0.0 0.0 0 0 ? S< Mar31 0:00 [ksoftirqd/0]
root 5 0.0 0.0 0 0 ? S< Mar31 0:00 [watchdog/0]
root 6 0.0 0.0 0 0 ? S< Mar31 0:00 [migration/1]
root 7 0.0 0.0 0 0 ? S< Mar31 0:00 [ksoftirqd/1]
root 8 0.0 0.0 0 0 ? S< Mar31 0:00 [watchdog/1]
root 9 0.0 0.0 0 0 ? S< Mar31 0:00 [events/0]
root 10 0.0 0.0 0 0 ? S< Mar31 0:00 [events/1]
root 11 0.0 0.0 0 0 ? S< Mar31 0:00 [khelper]
root 12 0.0 0.0 0 0 ? S< Mar31 0:00 [kstop/0]
root 13 0.0 0.0 0 0 ? S< Mar31 0:00 [kstop/1]
root 14 0.0 0.0 0 0 ? S< Mar31 0:00 [kintegrityd/0]
root 15 0.0 0.0 0 0 ? S< Mar31 0:00 [kintegrityd/1]
root 16 0.0 0.0 0 0 ? S< Mar31 0:00 [kblockd/0]
root 17 0.0 0.0 0 0 ? S< Mar31 0:00 [kblockd/1]
root 18 0.0 0.0 0 0 ? S< Mar31 0:00 [kacpid]
root 19 0.0 0.0 0 0 ? S< Mar31 0:00 [kacpi_notify]
root 20 0.0 0.0 0 0 ? S< Mar31 0:00 [cqueue]
root 21 0.0 0.0 0 0 ? S< Mar31 0:00 [ata/0]
root 22 0.0 0.0 0 0 ? S< Mar31 0:00 [ata/1]
root 23 0.0 0.0 0 0 ? S< Mar31 0:00 [ata_aux]
root 24 0.0 0.0 0 0 ? S< Mar31 0:00 [ksuspend_usbd]
root 25 0.0 0.0 0 0 ? S< Mar31 0:00 [khubd]
root 26 0.0 0.0 0 0 ? S< Mar31 0:00 [kseriod]
root 27 0.0 0.0 0 0 ? S< Mar31 0:00 [kmmcd]
root 28 0.0 0.0 0 0 ? S< Mar31 0:00 [btaddconn]
root 29 0.0 0.0 0 0 ? S< Mar31 0:00 [btdelconn]
root 30 0.0 0.0 0 0 ? S Mar31 0:00 [pdflush]
root 31 0.0 0.0 0 0 ? S Mar31 0:03 [pdflush]
root 32 0.0 0.0 0 0 ? S< Mar31 0:00 [kswapd0]
root 33 0.0 0.0 0 0 ? S< Mar31 0:00 [aio/0]
root 34 0.0 0.0 0 0 ? S< Mar31 0:00 [aio/1]
root 35 0.0 0.0 0 0 ? S< Mar31 0:00 [ecryptfs-kthrea]
root 38 0.0 0.0 0 0 ? S< Mar31 0:00 [scsi_eh_0]
root 39 0.0 0.0 0 0 ? S< Mar31 0:00 [scsi_eh_1]
root 40 0.0 0.0 0 0 ? S< Mar31 0:00 [kstriped]
root 41 0.0 0.0 0 0 ? S< Mar31 0:00 [kmpathd/0]
root 42 0.0 0.0 0 0 ? S< Mar31 0:00 [kmpathd/1]
root 43 0.0 0.0 0 0 ? S< Mar31 0:00 [kmpath_handlerd]
root 44 0.0 0.0 0 0 ? S< Mar31 0:00 [ksnapd]
root 45 0.0 0.0 0 0 ? S< Mar31 0:00 [kondemand/0]
root 46 0.0 0.0 0 0 ? S< Mar31 0:00 [kondemand/1]
root 47 0.0 0.0 0 0 ? S< Mar31 0:00 [krfcommd]
root 581 0.0 0.0 0 0 ? S< Mar31 0:02 [kjournald]
root 668 0.0 0.0 2224 536 ? S<s Mar31 0:00 /sbin/udevd --daemon
postfix 1327 0.0 0.0 6168 2548 ? S 11:04 0:00 tlsmgr -l -t unix -u -c
postfix 1927 0.0 0.0 5792 1692 ? S 11:22 0:00 pickup -l -t fifo -u -c
root 1982 0.0 0.0 1808 532 tty4 Ss+ Mar31 0:00 /sbin/getty 38400 tty4
root 1983 0.0 0.0 1808 532 tty5 Ss+ Mar31 0:00 /sbin/getty 38400 tty5
root 1986 0.0 0.0 1808 532 tty2 Ss+ Mar31 0:00 /sbin/getty 38400 tty2
root 1987 0.0 0.0 1808 528 tty3 Ss+ Mar31 0:00 /sbin/getty 38400 tty3
root 1988 0.0 0.0 1808 528 tty6 Ss+ Mar31 0:00 /sbin/getty 38400 tty6
syslog 2035 0.0 0.0 2040 696 ? Ss Mar31 0:00 /sbin/syslogd -u syslog
root 2053 0.0 0.0 1968 536 ? S Mar31 0:00 /bin/dd bs 1 if /proc/kmsg of /var/run/klogd/kmsg
klog 2055 0.0 0.0 3620 2388 ? Ss Mar31 0:00 /sbin/klogd -P /var/run/klogd/kmsg
104 2073 0.0 0.0 2672 844 ? Ss Mar31 0:01 /bin/dbus-daemon --system
bind 2094 0.0 0.5 63528 22176 ? Ssl Mar31 0:00 /usr/sbin/named -u bind
root 2116 0.0 0.0 5436 1076 ? Ss Mar31 0:00 /usr/sbin/sshd
root 2274 0.0 0.0 1996 476 ? S Mar31 0:00 /usr/sbin/courierlogger -pid=/var/run/courier/authdaemon/pid -start /usr/lib/courier/courier-authlib/authdaemo
root 2275 0.0 0.0 4528 1080 ? S Mar31 0:00 /usr/lib/courier/courier-authlib/authdaemond
root 2313 0.0 0.0 4528 372 ? S Mar31 0:00 /usr/lib/courier/courier-authlib/authdaemond
root 2314 0.0 0.0 4528 372 ? S Mar31 0:00 /usr/lib/courier/courier-authlib/authdaemond
root 2315 0.0 0.0 4528 372 ? S Mar31 0:00 /usr/lib/courier/courier-authlib/authdaemond
root 2316 0.0 0.0 4528 372 ? S Mar31 0:00 /usr/lib/courier/courier-authlib/authdaemond
root 2317 0.0 0.0 4528 372 ? S Mar31 0:00 /usr/lib/courier/courier-authlib/authdaemond
root 2480 0.0 0.0 8416 876 ? Ss Mar31 0:00 /usr/sbin/saslauthd -a pam -c -m /var/spool/postfix/var/run/saslauthd -r -n 5
root 2481 0.0 0.0 8416 512 ? S Mar31 0:00 /usr/sbin/saslauthd -a pam -c -m /var/spool/postfix/var/run/saslauthd -r -n 5
root 2482 0.0 0.0 8416 428 ? S Mar31 0:00 /usr/sbin/saslauthd -a pam -c -m /var/spool/postfix/var/run/saslauthd -r -n 5
root 2483 0.0 0.0 8416 428 ? S Mar31 0:00 /usr/sbin/saslauthd -a pam -c -m /var/spool/postfix/var/run/saslauthd -r -n 5
root 2484 0.0 0.0 8416 428 ? S Mar31 0:00 /usr/sbin/saslauthd -a pam -c -m /var/spool/postfix/var/run/saslauthd -r -n 5
snmp 2499 0.0 0.1 9108 4244 ? S Mar31 0:12 /usr/sbin/snmpd -Lsd -Lf /dev/null -u snmp -I -smux -p /var/run/snmpd.pid 127.0.0.1
daemon 2550 0.0 0.0 2096 456 ? Ss Mar31 0:00 /usr/sbin/atd
root 2575 0.0 0.0 3480 1036 ? Ss Mar31 0:00 /usr/sbin/cron
root 2594 0.0 0.1 34276 8168 ? Ss Mar31 0:00 /usr/sbin/apache2 -k start
www-data 2620 0.0 0.2 37668 11296 ? S Mar31 0:01 /usr/sbin/apache2 -k start
root 2621 0.0 0.1 10296 6168 ? Ss Mar31 0:00 /usr/bin/perl /usr/share/webmin/miniserv.pl /etc/webmin/miniserv.conf
root 2622 0.0 0.0 1808 528 tty1 Ss+ Mar31 0:00 /sbin/getty 38400 tty1
root 2628 0.0 0.0 17948 3696 ? Ssl Mar31 0:03 /usr/sbin/console-kit-daemon
root 2897 0.0 0.0 2768 1028 pts/1 R+ 11:53 0:00 ps aux
www-data 3060 0.0 0.2 37608 11388 ? S Mar31 0:01 /usr/sbin/apache2 -k start
www-data 3681 0.0 0.2 37600 10828 ? S Mar31 0:00 /usr/sbin/apache2 -k start
www-data 11484 0.0 0.2 37428 11204 ? S Mar31 0:00 /usr/sbin/apache2 -k start
www-data 11493 0.0 0.2 37204 11300 ? S Mar31 0:00 /usr/sbin/apache2 -k start
root 11559 0.0 0.0 3968 1368 ? S Mar31 0:00 /bin/sh /usr/bin/mysqld_safe
mysql 11598 0.0 0.4 129708 18784 ? Sl Mar31 0:13 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --
root 11599 0.0 0.0 3052 704 ? S Mar31 0:00 logger -p daemon.err -t mysqld_safe -i -t mysqld
www-data 11941 0.0 0.2 37336 10676 ? S Mar31 0:00 /usr/sbin/apache2 -k start
www-data 12069 0.0 0.2 37444 10760 ? S Mar31 0:00 /usr/sbin/apache2 -k start
www-data 12319 0.0 0.2 37140 10568 ? S 00:02 0:00 /usr/sbin/apache2 -k start
root 26644 0.0 0.1 12600 4464 ? Ss 08:01 0:00 sshd: patrick [priv]
patrick 26652 0.0 0.0 12600 1968 ? S 08:01 0:00 sshd: patrick@pts/0
patrick 26653 0.0 0.0 5764 3076 pts/0 Ss+ 08:01 0:00 -bash
root 27431 0.0 0.0 5780 1772 ? Ss 08:02 0:00 /usr/lib/postfix/master
postfix 27434 0.0 0.0 5836 1744 ? S 08:02 0:00 qmgr -l -t fifo -u
www-data 28875 0.0 0.2 37400 10688 ? S 08:41 0:00 /usr/sbin/apache2 -k start
www-data 28988 0.0 0.1 34828 5384 ? S 08:46 0:00 /usr/sbin/apache2 -k start
root 29202 0.0 0.1 12600 4440 ? Ss 08:50 0:00 sshd: patrick [priv]
patrick 29210 0.0 0.0 12956 2388 ? S 08:50 0:03 sshd: patrick@notty
patrick 29211 0.0 0.0 5272 1980 ? Ss 08:50 0:01 /usr/lib/openssh/sftp-server
root 29304 0.0 0.1 12600 4468 ? Ss 08:54 0:00 sshd: patrick [priv]
patrick 29312 0.0 0.0 12764 2088 ? S 08:54 0:00 sshd: patrick@pts/1
patrick 29313 0.0 0.0 5764 3044 pts/1 Ss 08:54 0:00 -bash
root 29437 0.0 0.0 8300 2372 pts/1 S 08:56 0:00 su
root 29444 0.0 0.0 4376 1924 pts/1 S 08:56 0:00 bash

 

Ups...i made a mistake.

Courier listens on port 110; postfix has nothing to do with your problem. From your ps output, i see the pop3d isn't running. Try to start it manualy:

Code:

sudo /etc/init.d/courier-pop start

and see if you get any errors.

 

no errors but process does not start, do you know where the error log would be for this?

 

I managed to fix my problem, i didn't have courier-pop installed, kinda wired but it worked. Now went through the rest of the tutorial and I am still having problems with mysql connecting to the database. I can't log in. Anyone know where to start looking to figure this problem out?

 

Can you give more details?

Try:

Code:

mysql -u root -p

to see if you cam connect to mysql (you'll have to enter mysql's root password)
In mysql type

Code:

use mail;

If you get a "database changed" message, then your database exists.

If everything is ok, type quit to exit mysql, then try:

Code:

mysql -u mail_admin -p

to see if the user you created for postfix works (you'll have to enter the password you set in the postfix configuration).

This probably means there-s something wrong with the tables in your database. You could try to drop your database and redo the 4th chapter from the tutorial (Create The MySQL Database For Postfix/Courier).
To drop your database:

Code:

mysqladmin -u root -p drop mail

 

Alright well I just did what you told me and rebuilt the database, and still the same error. I can't login to squirrelmail. I think because it's not connecting to the database. Still getting this error:

Apr 2 15:11:56 lightondesigns postfix/trivial-rewrite[4595]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem

The only other this that I have noticed where things don't look right are when I run netstat -tap | grep mysql, I don't get the same output from the tutorial. Here is my output :

tcp 0 0 localhost:mysql *:* LISTEN 2228/mysqld
tcp 0 0 localhost:38846 localhost:mysql TIME_WAIT -
tcp 0 0 localhost:mysql localhost:38848 ESTABLISHED 2228/mysqld
tcp 0 0 localhost:mysql localhost:38849 TIME_WAIT -
tcp 0 0 localhost:38848 localhost:mysql ESTABLISHED 4450/proxymap

Thanks again for all your help!

 

alright well I figure out that I had spelled my password wrong in one of my .cf files, but now on the next problem. i still can not login to squirrelmail. My mail.log is as follows:

this is just a slice of it:

pr 2 21:20:11 lightondesigns postfix/virtual[3021]: 6383711A6283: to=<[email protected]>, relay=virtual, delay=0.05, delays=0.02/0/0/0.03, dsn=5.1.1, status=bounced (unknown user: "[email protected]")
Apr 2 21:20:11 lightondesigns postfix/virtual[3173]: 5E9FB11A6321: to=<[email protected]>, relay=virtual, delay=0.07, delays=0.04/0/0/0.03, dsn=5.1.1, status=bounced (unknown user: "[email protected]")
Apr 2 21:20:11 lightondesigns postfix/qmgr[2978]: 5E9FB11A6321: removed
Apr 2 21:20:11 lightondesigns postfix/cleanup[3024]: 6FC5411A627D: message-id=<[email protected]>
Apr 2 21:20:11 lightondesigns postfix/bounce[3175]: 6383711A6283: sender non-delivery notification: 6FC5411A627D
Apr 2 21:20:11 lightondesigns postfix/qmgr[2978]: 6FC5411A627D: from=<>, size=3742, nrcpt=1 (queue active)
Apr 2 21:20:11 lightondesigns postfix/qmgr[2978]: 6383711A6283: removed
Apr 2 21:20:11 lightondesigns postfix/virtual[3021]: 6FC5411A627D: to=<[email protected]>, relay=virtual, delay=0.03, delays=0.02/0/0/0.01, dsn=5.1.1, status=bounced (unknown user: "[email protected]")
Apr 2 21:20:11 lightondesigns postfix/qmgr[2978]: 6FC5411A627D: removed
Apr 2 21:20:12 lightondesigns postfix/smtpd[3169]: 8E18511A627D: client=localhost[127.0.0.1]
Apr 2 21:20:12 lightondesigns postfix/cleanup[3170]: 8E18511A627D: message-id=<[email protected]>
Apr 2 21:20:12 lightondesigns postfix/qmgr[2978]: 8E18511A627D: from=<[email protected]>, size=1953, nrcpt=1 (queue active)
Apr 2 21:20:12 lightondesigns amavis[3158]: (03158-02-19) Passed CLEAN, <[email protected]> -> <[email protected]>, Message-ID: <[email protected]>, mail_id: ZAgx9IHq7E8z, Hits: 2.863, size: 1271, queued_as: 8E18511A627D, 1186 ms
Apr 2 21:20:12 lightondesigns postfix/virtual[3173]: 8E18511A627D: to=<[email protected]>, relay=virtual, delay=0.02, delays=0.01/0/0/0.01, dsn=5.1.1, status=bounced (unknown user: "[email protected]")
Apr 2 21:20:12 lightondesigns postfix/cleanup[3024]: 91F3011A62D5: message-id=<[email protected]>
Apr 2 21:20:12 lightondesigns postfix/smtp[3003]: CE0C111A6403: to=<[email protected]>, orig_to=<root>, relay=127.0.0.1[127.0.0.1]:10024, conn_use=19, delay=1390, delays=1355/33/0/1.2, dsn=2.0.0, status=sent (250 2.0.0 Ok, id=03158-02-19, from MTA([127.0.0.1]:10025): 250 2.0.0 Ok: queued as 8E18511A627D)
Apr 2 21:20:12 lightondesigns postfix/qmgr[2978]: CE0C111A6403: removed
Apr 2 21:20:12 lightondesigns postfix/bounce[3023]: 8E18511A627D: sender non-delivery notification: 91F3011A62D5
Apr 2 21:20:12 lightondesigns postfix/qmgr[2978]: 91F3011A62D5: from=<>, size=3898, nrcpt=1 (queue active)
Apr 2 21:20:12 lightondesigns postfix/qmgr[2978]: 8E18511A627D: removed
Apr 2 21:20:12 lightondesigns postfix/virtual[3021]: 91F3011A62D5: to=<[email protected]>, relay=virtual, delay=0.03, delays=0.02/0/0/0.01, dsn=5.1.1, status=bounced (unknown user: "[email protected]")
Apr 2 21:20:12 lightondesigns postfix/qmgr[2978]: 91F3011A62D5: removed
Apr 2 21:20:13 lightondesigns postfix/smtpd[3167]: disconnect from localhost[127.0.0.1]
Apr 2 21:20:14 lightondesigns postfix/smtpd[3169]: disconnect from localhost[127.0.0.1]
Apr 2 21:22:25 lightondesigns imapd: Connection, ip=[::1]
Apr 2 21:22:25 lightondesigns imapd: LOGIN FAILED, [email protected], ip=[::1]
Apr 2 21:22:30 lightondesigns imapd: LOGOUT, ip=[::1], rcvd=69, sent=332
Apr 2 21:23:31 lightondesigns postfix/scache[3172]: statistics: start interval Apr 2 21:19:49
Apr 2 21:23:31 lightondesigns postfix/scache[3172]: statistics: domain lookup hits=36 miss=2 success=94%
Apr 2 21:23:31 lightondesigns postfix/scache[3172]: statistics: address lookup hits=0 miss=2 success=0%
Apr 2 21:23:31 lightondesigns postfix/scache[3172]: statistics: max simultaneous domains=1 addresses=1 connection=2
Apr 2 21:26:27 lightondesigns postfix/pickup[2976]: 033C411A6283: uid=0 from=<root>
Apr 2 21:26:27 lightondesigns postfix/cleanup[3668]: 033C411A6283: message-id=<[email protected]>
Apr 2 21:26:27 lightondesigns postfix/qmgr[2978]: 033C411A6283: from=<[email protected]>, size=337, nrcpt=1 (queue active)
Apr 2 21:26:28 lightondesigns postfix/smtpd[3676]: connect from localhost[127.0.0.1]
Apr 2 21:26:28 lightondesigns postfix/smtpd[3676]: 2BDE211A627D: client=localhost[127.0.0.1]
Apr 2 21:26:28 lightondesigns postfix/cleanup[3668]: 2BDE211A627D: message-id=<[email protected]>
Apr 2 21:26:28 lightondesigns postfix/qmgr[2978]: 2BDE211A627D: from=<[email protected]>, size=829, nrcpt=1 (queue active)
Apr 2 21:26:28 lightondesigns amavis[3457]: (03457-01) Passed CLEAN, <[email protected]> -> <[email protected]>, Message-ID: <[email protected]>, mail_id: yFgPUalfgtm6, Hits: 1.415, size: 337, queued_as: 2BDE211A627D, 1154 ms
Apr 2 21:26:28 lightondesigns postfix/smtp[3671]: 033C411A6283: to=<[email protected]>, relay=127.0.0.1[127.0.0.1]:10024, delay=1.2, delays=0.06/0.01/0.01/1.2, dsn=2.0.0, status=sent (250 2.0.0 Ok, id=03457-01, from MTA([127.0.0.1]:10025): 250 2.0.0 Ok: queued as 2BDE211A627D)
Apr 2 21:26:28 lightondesigns postfix/qmgr[2978]: 033C411A6283: removed
Apr 2 21:26:28 lightondesigns postfix/virtual[3677]: 2BDE211A627D: to=<[email protected]>, relay=virtual, delay=0.05, delays=0.02/0.01/0/0.02, dsn=5.1.1, status=bounced (unknown user: "[email protected]")
Apr 2 21:26:28 lightondesigns postfix/cleanup[3668]: 37C2711A62D5: message-id=<[email protected]>
Apr 2 21:26:28 lightondesigns postfix/bounce[3678]: 2BDE211A627D: sender non-delivery notification: 37C2711A62D5
Apr 2 21:26:28 lightondesigns postfix/qmgr[2978]: 37C2711A62D5: from=<>, size=2808, nrcpt=1 (queue active)
Apr 2 21:26:28 lightondesigns postfix/qmgr[2978]: 2BDE211A627D: removed
Apr 2 21:26:28 lightondesigns postfix/virtual[3677]: 37C2711A62D5: to=<[email protected]>, relay=virtual, delay=0.03, delays=0.02/0/0/0.01, dsn=5.1.1, status=bounced (unknown user: "[email protected]")
Apr 2 21:26:28 lightondesigns postfix/qmgr[2978]: 37C2711A62D5: removed
Apr 2 21:28:47 lightondesigns imapd: Connection, ip=[::1]
Apr 2 21:28:47 lightondesigns imapd: LOGIN FAILED, [email protected], ip=[::1]
Apr 2 21:28:52 lightondesigns imapd: LOGOUT, ip=[::1], rcvd=69, sent=332


One thing I noticed is that imapd is connecting to ::1, which i think is ipv6 of localhost. Is this right? Anyone know what's going on?

 

Does [email protected] exist in the database?

 

in my user table I have:

email = [email protected]
password = encrypted pw
quota = 10485760

domiains i have

lightondesigns.com

so I believed that it is setup right.

I have a question, on the second page of this tutorial it tell you to specifiy a FQDN. I choose mailbox.lightondesings.com and I created this domain in virtualmin. Is that the correct thing to do?


I am also not recieving mails from outside sources. Here is a chunk of my mail.log:


ejected: User unknown in virtual mailbox table; from=<[email protected]> to=<[email protected]> proto=ESMTP helo=<qw-out-2122.google.com>
Apr 2 22:51:51 lightondesigns postfix/smtpd[3334]: disconnect from qw-out-2122.google.com[74.125.92.25]
Apr 2 22:52:55 lightondesigns postfix/pickup[2968]: 642DD11A6321: uid=0 from=<root>
Apr 2 22:52:55 lightondesigns postfix/cleanup[3384]: 642DD11A6321: message-id=<[email protected]>
Apr 2 22:52:55 lightondesigns postfix/qmgr[2970]: 642DD11A6321: from=<[email protected]>, size=331, nrcpt=1 (queue active)
Apr 2 22:53:01 lightondesigns postfix/smtpd[3393]: connect from localhost[127.0.0.1]
Apr 2 22:53:01 lightondesigns postfix/smtpd[3393]: 4F88111A6272: client=localhost[127.0.0.1]
Apr 2 22:53:01 lightondesigns postfix/cleanup[3384]: 4F88111A6272: message-id=<[email protected]>
Apr 2 22:53:01 lightondesigns postfix/qmgr[2970]: 4F88111A6272: from=<[email protected]>, size=1015, nrcpt=1 (queue active)
Apr 2 22:53:01 lightondesigns postfix/smtp[3387]: 642DD11A6321: to=<[email protected]>, relay=127.0.0.1[127.0.0.1]:10024, delay=6, delays=0.15/0.02/0.01/5.8, dsn=2.0.0, status=sent (250 2.0.0 Ok, id=03137-01, from MTA([127.0.0.1]:10025): 250 2.0.0 Ok: queued as 4F88111A6272)
Apr 2 22:53:01 lightondesigns postfix/qmgr[2970]: 642DD11A6321: removed
Apr 2 22:53:01 lightondesigns postfix/virtual[3396]: 4F88111A6272: to=<[email protected]>, relay=virtual, delay=0.07, delays=0.01/0.04/0/0.02, dsn=5.1.1, status=bounced (unknown user: "[email protected]")
Apr 2 22:53:01 lightondesigns postfix/cleanup[3384]: 6175F11A6322: message-id=<[email protected]>
Apr 2 22:53:01 lightondesigns postfix/bounce[3397]: 4F88111A6272: sender non-delivery notification: 6175F11A6322
Apr 2 22:53:01 lightondesigns postfix/qmgr[2970]: 6175F11A6322: from=<>, size=2994, nrcpt=1 (queue active)
Apr 2 22:53:01 lightondesigns postfix/qmgr[2970]: 4F88111A6272: removed
Apr 2 22:53:01 lightondesigns postfix/virtual[3396]: 6175F11A6322: to=<[email protected]>, relay=virtual, delay=0.03, delays=0.02/0/0/0.01, dsn=5.1.1, status=bounced (unknown user: "[email protected]")
Apr 2 22:53:01 lightondesigns postfix/qmgr[2970]: 6175F11A6322: removed
Apr 2 22:53:26 lightondesigns postfix/pickup[2968]: 7E4D611A6321: uid=0 from=<root>
Apr 2 22:53:26 lightondesigns postfix/cleanup[3384]: 7E4D611A6321: message-id=<[email protected]>
Apr 2 22:53:26 lightondesigns postfix/qmgr[2970]: 7E4D611A6321: from=<[email protected]>, size=322, nrcpt=1 (queue active)
Apr 2 22:53:27 lightondesigns postfix/smtpd[3404]: connect from localhost[127.0.0.1]
Apr 2 22:53:27 lightondesigns postfix/smtpd[3404]: 968CD11A6272: client=localhost[127.0.0.1]
Apr 2 22:53:27 lightondesigns postfix/cleanup[3384]: 968CD11A6272: message-id=<[email protected]>
Apr 2 22:53:27 lightondesigns postfix/qmgr[2970]: 968CD11A6272: from=<[email protected]>, size=796, nrcpt=1 (queue active)
Apr 2 22:53:27 lightondesigns postfix/smtp[3387]: 7E4D611A6321: to=<[email protected]>, relay=127.0.0.1[127.0.0.1]:10024, delay=1.1, delays=0.03/0/0.01/1.1, dsn=2.0.0, status=sent (250 2.0.0 Ok, id=03138-01, from MTA([127.0.0.1]:10025): 250 2.0.0 Ok: queued as 968CD11A6272)
Apr 2 22:53:27 lightondesigns postfix/qmgr[2970]: 7E4D611A6321: removed
Apr 2 22:53:28 lightondesigns postfix/smtp[3405]: 968CD11A6272: to=<[email protected]>, relay=gmail-smtp-in.l.google.com[74.125.45.27]:25, delay=0.84, delays=0.01/0.01/0.53/0.28, dsn=2.0.0, status=sent (250 2.0.0 OK 1238730800 4si4865484yxj.21)
Apr 2 22:53:28 lightondesigns postfix/qmgr[2970]: 968CD11A6272: removed
Apr 2 22:55:11 lightondesigns postfix/anvil[3309]: statistics: max connection rate 1/60s for (smtp:74.125.92.24) at Apr 2 22:50:09
Apr 2 22:55:11 lightondesigns postfix/anvil[3309]: statistics: max connection count 1 for (smtp:74.125.92.24) at Apr 2 22:50:09
Apr 2 22:55:11 lightondesigns postfix/anvil[3309]: statistics: max cache size 1 at Apr 2 22:50:09
Apr 2 22:58:01 lightondesigns postfix/smtpd[3393]: timeout after END-OF-MESSAGE from localhost[127.0.0.1]
Apr 2 22:58:01 lightondesigns postfix/smtpd[3393]: disconnect from localhost[127.0.0.1]
Apr 2 22:58:27 lightondesigns postfix/smtpd[3404]: timeout after END-OF-MESSAGE from localhost[127.0.0.1]
Apr 2 22:58:27 lightondesigns postfix/smtpd[3404]: disconnect from localhost[127.0.0.1]
Apr 2 23:09:57 lightondesigns postfix/master[2959]: terminating on signal 15
Apr 2 23:10:55 lightondesigns postfix/master[2954]: daemon started -- version 2.5.5, configuration /etc/postfix
Apr 2 23:19:28 lightondesigns postfix/smtpd[3330]: connect from mail-qy0-f112.google.com[209.85.221.112]
Apr 2 23:19:28 lightondesigns postfix/smtpd[3330]: NOQUEUE: reject: RCPT from mail-qy0-f112.google.com[209.85.221.112]: 550 5.1.1 <[email protected]>: Recipient address rejected: User unknown in virtual mailbox table; from=<[email protected]> to=<[email protected]> proto=ESMTP helo=<mail-qy0-f112.google.com>
Apr 2 23:19:28 lightondesigns postfix/smtpd[3330]: disconnect from mail-qy0-f112.google.com[209.85.221.112]
Apr 2 23:22:48 lightondesigns postfix/anvil[3333]: statistics: max connection rate 1/60s for (smtp:209.85.221.112) at Apr 2 23:19:28
Apr 2 23:22:48 lightondesigns postfix/anvil[3333]: statistics: max connection count 1 for (smtp:209.85.221.112) at Apr 2 23:19:28
Apr 2 23:22:48 lightondesigns postfix/anvil[3333]: statistics: max cache size 1 at Apr 2 23:19:28
Apr 3 00:00:01 lightondesigns postfix/pickup[2963]: 9FB2C11A6321: uid=0 from=<root>
Apr 3 00:00:01 lightondesigns postfix/cleanup[4979]: 9FB2C11A6321: message-id=<[email protected]>
Apr 3 00:00:01 lightondesigns postfix/qmgr[2964]: 9FB2C11A6321: from=<[email protected]>, size=527, nrcpt=1 (queue active)
Apr 3 00:00:07 lightondesigns postfix/smtpd[5252]: connect from localhost[127.0.0.1]
Apr 3 00:00:07 lightondesigns postfix/smtpd[5252]: F040A11A6320: client=localhost[127.0.0.1]
Apr 3 00:00:07 lightondesigns postfix/cleanup[4979]: F040A11A6320: message-id=<[email protected]>
Apr 3 00:00:08 lightondesigns postfix/qmgr[2964]: F040A11A6320: from=<[email protected]>, size=1019, nrcpt=1 (queue active)
Apr 3 00:00:08 lightondesigns postfix/smtp[4998]: 9FB2C11A6321: to=<[email protected]>, relay=127.0.0.1[127.0.0.1]:10024, delay=6.5, delays=0.21/0.01/0.01/6.2, dsn=2.0.0, status=sent (250 2.0.0 Ok, id=03130-01, from MTA([127.0.0.1]:10025): 250 2.0.0 Ok: queued as F040A11A6320)
Apr 3 00:00:08 lightondesigns postfix/qmgr[2964]: 9FB2C11A6321: removed
Apr 3 00:00:08 lightondesigns postfix/smtp[5255]: F040A11A6320: to=<[email protected]>, relay=none, delay=0.15, delays=0.03/0.05/0.08/0, dsn=5.4.4, status=bounced (Host or domain name not found. Name service error for name=lightondesigns.tld type=A: Host not found)
Apr 3 00:00:08 lightondesigns postfix/cleanup[4979]: 2BE2D11A6322: message-id=<[email protected]>
Apr 3 00:00:08 lightondesigns postfix/qmgr[2964]: 2BE2D11A6322: from=<>, size=3133, nrcpt=1 (queue active)
Apr 3 00:00:08 lightondesigns postfix/bounce[5256]: F040A11A6320: sender non-delivery notification: 2BE2D11A6322
Apr 3 00:00:08 lightondesigns postfix/qmgr[2964]: F040A11A6320: removed
Apr 3 00:00:08 lightondesigns postfix/virtual[5257]: 2BE2D11A6322: to=<[email protected]>, relay=virtual, delay=0.07, delays=0.02/0.04/0/0.01, dsn=5.1.1, status=bounced (unknown user: "[email protected]")
Apr 3 00:00:08 lightondesigns postfix/qmgr[2964]: 2BE2D11A6322: removed
Apr 3 00:05:08 lightondesigns postfix/smtpd[5252]: timeout after END-OF-MESSAGE from localhost[127.0.0.1]
Apr 3 00:05:08 lightondesigns postfix/smtpd[5252]: disconnect from localhost[127.0.0.1]
Apr 3 00:41:01 lightondesigns postfix/smtpd[6682]: connect from qw-out-2122.google.com[74.125.92.27]
Apr 3 00:41:01 lightondesigns postfix/smtpd[6682]: NOQUEUE: reject: RCPT from qw-out-2122.google.com[74.125.92.27]: 550 5.1.1 <[email protected]>: Recipient address rejected: User unknown in virtual mailbox table; from=<[email protected]> to=<[email protected]> proto=ESMTP helo=<qw-out-2122.google.com>
Apr 3 00:41:01 lightondesigns postfix/smtpd[6682]: disconnect from qw-out-2122.google.com[74.125.92.27]
Apr 3 00:43:43 lightondesigns postfix/smtpd[6732]: connect from qw-out-2122.google.com[74.125.92.26]
Apr 3 00:43:43 lightondesigns postfix/smtpd[6732]: NOQUEUE: reject: RCPT from qw-out-2122.google.com[74.125.92.26]: 550 5.1.1 <[email protected]>: Recipient address rejected: User unknown in virtual mailbox table; from=<[email protected]> to=<[email protected]> proto=ESMTP helo=<qw-out-2122.google.com>
Apr 3 00:43:43 lightondesigns postfix/smtpd[6732]: disconnect from qw-out-2122.google.com[74.125.92.26]
Apr 3 00:47:03 lightondesigns postfix/anvil[6684]: statistics: max connection rate 1/60s for (smtp:74.125.92.27) at Apr 3 00:41:01
Apr 3 00:47:03 lightondesigns postfix/anvil[6684]: statistics: max connection count 1 for (smtp:74.125.92.27) at Apr 3 00:41:01
Apr 3 00:47:03 lightondesigns postfix/anvil[6684]: statistics: max cache size 1 at Apr 3 00:41:01

thanks again for any help in advance ;=)

 

Please compare your setup with the tutorial again. Maybe you made a typo somewhere.

 

Thanks soooo much Falko, your a true Hackzor, lol...
Yea i figured it out, I had one of my domains spelled wrong in my mysql database. Everything is working great.

Except for one thing with squirrelmail. If I try to enable the mysql change password plugin. I can't login to squirellmail, just get a blank screen. This isn't that big of deal cause I can just change the passwords manually.

Any idea what that could be?

here is my config.php

<?php

/**
* SquirrelMail Change SQL Password Plugin
* Copyright (C) 2001-2002 Tyler Akins
* 2002 Thijs Kinkhorst <[email protected]>
* 2002-2005 Paul Lesneiwski <[email protected]>
* This program is licensed under GPL. See COPYING for details
*
* @package plugins
* @subpackage Change SQL Password
*
*/


// Global Variables, don't touch these unless you want to break the plugin
//
global $csp_dsn, $password_update_queries, $lookup_password_query,
$force_change_password_check_query, $password_encryption,
$csp_salt_query, $csp_salt_static, $csp_secure_port,
$csp_non_standard_http_port, $csp_delimiter, $csp_debug,
$min_password_length, $max_password_length, $include_digit_in_password,
$include_uppercase_letter_in_password, $include_lowercase_letter_in_password,
$include_nonalphanumeric_in_password;



// csp_dsn
//
// Theoretically, any SQL database supported by Pear should be supported
// here. The DSN (data source name) must contain the information needed
// to connect to your database backend. A MySQL example is included below.
// For more details about DSN syntax and list of supported database types,
// please see:
// http://pear.php.net/manual/en/package.database.db.intro-dsn.php
//
$csp_dsn = 'mysql://mail_admin:xxx@localhost/mail';


// lookup_password_query
//
// This plugin will always verify the user's old password
// against their login password, but an extra check can also
// be done against the database for more security if you
// desire. If you do not need the extra password check,
// make sure this setting is empty.
//
// This is a query that returns a positive value if a user
// and password pair are found in the database.
//
// This query should return one value (one row, one column), the
// value being ideally a one or a zero, simply indicating that
// the user/password pair does in fact exist in the database.
//
// %1 in this query will be replaced with the full username
// (including domain), such as "[email protected]"
// %2 in this query will be replaced with the username (without
// any domain portion), such as "jose"
// %3 in this query will be replaced with the domain name,
// such as "example.com"
// %4 in this query will be replaced with the current (old)
// password in whatever encryption format is needed per other
// plugin configuration settings (Note that the syntax of
// the password will be provided depending on your encryption
// choices, so you NEVER need to provide quotes around this
// value in the query here.)
// %5 in this query will be replaced with the current (old)
// password in unencrypted plain text. If you do not use any
// password encryption, %4 and %5 will be the same values,
// except %4 will have double quotes around it and %5 will not.
//
//$lookup_password_query = '';
// TERRIBLE SECURITY: $lookup_password_query = 'SELECT count(*) FROM users WHERE username = "%1" AND plain_password = "%5"';
$lookup_password_query = 'SELECT count(*) FROM users WHERE email = "%1" AND password = %4';



// password_update_queries
//
// An array of SQL queries that will all be executed
// whenever a password change attempt is made.
//
// Any number of queries may be included here.
// The queries will be executed in the order given here.
//
// %1 in all queries will be replaced with the full username
// (including domain), such as "[email protected]"
// %2 in all queries will be replaced with the username (without
// any domain portion), such as "jose"
// %3 in all queries will be replaced with the domain name,
// such as "example.com"
// %4 in all queries will be replaced with the new password
// in whatever encryption format is needed per other
// plugin configuration settings (Note that the syntax of
// the password will be provided depending on your
// encryption choices, so you NEVER need to provide quotes
// around this value in the queries here.)
// %5 in all queries will be replaced with the new password
// in unencrypted plain text - BEWARE! If you do not use
// any password encryption, %4 and %5 will be the same
// values, except %4 will have double quotes around it
// and %5 will not.
//
$password_update_queries = array('UPDATE users SET password = %4 WHERE email = "%1"');
// 'UPDATE user_flags SET force_change_pwd = 0 WHERE username = "%1"',
// 'UPDATE users SET crypt_password = %4, force_change_pwd = 0 WHERE username = "%1"',
);



// force_change_password_check_query
//
// A query that checks for a flag that indicates if a user
// should be forced to change their password. This query
// should return one value (one row, one column) which is
// zero if the user does NOT need to change their password,
// or one if the user should be forced to change it now.
//
// This setting should be an empty string if you do not wish
// to enable this functionality.
//
// %1 in this query will be replaced with the full username
// (including domain), such as "[email protected]"
// %2 in this query will be replaced with the username (without
// any domain portion), such as "jose"
// %3 in this query will be replaced with the domain name,
// such as "example.com"
//
//$force_change_password_check_query = 'SELECT IF(force_change_pwd = "yes", 1, 0) FROM users WHERE username = "%1"';
//$force_change_password_check_query = 'SELECT force_change_pwd FROM users WHERE username = "%1"';
$force_change_password_check_query = '';



// password_encryption
//
// What encryption method do you use to store passwords
// in your database? Please use one of the following,
// exactly as you see it:
//
// NONE Passwords are stored as plain text only
// MYSQLPWD Passwords are stored using the MySQL password() function
// MYSQLENCRYPT Passwords are stored using the MySQL encrypt() function
// PHPCRYPT Passwords are stored using the PHP crypt() function
// MD5CRYPT Passwords are stored using encrypted MD5 algorithm
// MD5 Passwords are stored as MD5 hash
//
$password_encryption = 'MYSQLENCRYPT';



// csp_salt_query
// csp_salt_static
//
// Encryption types that need a salt need to know where to get
// that salt. If you have a constant, known salt value, you
// should define it in $csp_salt_static. Otherwise, leave that
// value empty and define a value for the $csp_salt_query.
//
// Leave both values empty if you do not need (or use) salts
// to encrypt your passwords.
//
// The query should return one value (one row, one column) which
// is the salt value for the current user's password. This
// query is ignored if $csp_salt_static is anything but empty.
//
// %1 in this query will be replaced with the full username
// (including domain), such as "[email protected]"
// %2 in this query will be replaced with the username (without
// any domain portion), such as "jose"
// %3 in this query will be replaced with the domain name,
// such as "example.com"
//
//$csp_salt_static = 'LEFT(crypt_password, 2)';
//$csp_salt_static = '"a4"'; // use this format with MYSQLENCRYPT
//$csp_salt_static = '$2$blowsomefish$'; // use this format with PHPCRYPT
$csp_salt_static = 'LEFT(password, 2)';

//$csp_salt_query = 'SELECT SUBSTRING_INDEX(crypt_password, '$', 1) FROM users WHERE username = "%1"';
//$csp_salt_query = 'SELECT SUBSTRING(crypt_password, (LENGTH(SUBSTRING_INDEX(crypt_password, '$', 2)) + 2)) FROM users WHERE username = "%1"';
//$csp_salt_query = 'SELECT salt FROM users WHERE username = "%1"';
//$csp_salt_query = '';



// csp_secure_port
//
// You may ensure that SSL encryption is used during password
// change by setting this to the port that your HTTPS is served
// on (443 is typical). Set to zero if you do not wish to force
// an HTTPS connection when users are changing their passwords.
//
// You may override this value for certain domains, users, or
// service levels through the Virtual Host Login (vlogin) plugin
// by setting a value(s) for $vlogin_csp_secure_port in the vlogin
// configuration.
//
$csp_secure_port = 0;
//$csp_secure_port = 443;



// csp_non_standard_http_port
//
// If you serve standard HTTP web requests on a non-standard
// port (anything other than port 80), you should specify that
// port number here. Set to zero otherwise.
//
// You may override this value for certain domains, users, or
// service levels through the Virtual Host Login (vlogin) plugin
// by setting a value(s) for $vlogin_csp_non_standard_http_port
// in the vlogin configuration.
//
//$csp_non_standard_http_port = 8080;
$csp_non_standard_http_port = 0;



// min_password_length
// max_password_length
// include_digit_in_password
// include_uppercase_letter_in_password
// include_lowercase_letter_in_password
// include_nonalphanumeric_in_password
//
// You can set the minimum and maximum password lengths that
// you accept or leave those settings as zero to indicate that
// no limit should be applied.
//
// Turn on any of the other settings here to check that the
// new password contains at least one digit, upper case letter,
// lower case letter and/or one non-alphanumeric character.
//
$min_password_length = 6;
$max_password_length = 0;
$include_digit_in_password = 0;
$include_uppercase_letter_in_password = 0;
$include_lowercase_letter_in_password = 0;
$include_nonalphanumeric_in_password = 0;



// csp_delimiter
//
// if your system has usernames with something other than
// an "@" sign separating the user and domain portion,
// specify that character here
//
//$csp_delimiter = '|';
$csp_delimiter = '@';



// debug mode
//
$csp_debug = 0;



?>

 

LoL, just saw the error, under password part a ');' needed to be commeneted out.

Thanks again, your the shizznizzle, lol