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.
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?
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 ;=)
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
