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

Discussion in 'HOWTO-Related Questions' started by pwaterz, Apr 1, 2009.

  1. pwaterz

    pwaterz New Member

    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?
     
    Last edited: Apr 1, 2009
  2. deconectat

    deconectat New Member

    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
    
     
  3. pwaterz

    pwaterz New Member

    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
     
    Last edited: Apr 1, 2009
  4. deconectat

    deconectat New Member

    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.
     
  5. pwaterz

    pwaterz New Member

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

    pwaterz New Member

    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?
     
  7. deconectat

    deconectat New Member

    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
     
  8. pwaterz

    pwaterz New Member

    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!
     
  9. pwaterz

    pwaterz New Member

    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=<root@lightondesigns.com>, relay=virtual, delay=0.05, delays=0.02/0/0/0.03, dsn=5.1.1, status=bounced (unknown user: "root@lightondesigns.com")
    Apr 2 21:20:11 lightondesigns postfix/virtual[3173]: 5E9FB11A6321: to=<root@lightondesigns.com>, relay=virtual, delay=0.07, delays=0.04/0/0/0.03, dsn=5.1.1, status=bounced (unknown user: "root@lightondesigns.com")
    Apr 2 21:20:11 lightondesigns postfix/qmgr[2978]: 5E9FB11A6321: removed
    Apr 2 21:20:11 lightondesigns postfix/cleanup[3024]: 6FC5411A627D: message-id=<20090403022011.6FC5411A627D@mailbox.lightondesigns.com>
    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=<root@lightondesigns.com>, relay=virtual, delay=0.03, delays=0.02/0/0/0.01, dsn=5.1.1, status=bounced (unknown user: "root@lightondesigns.com")
    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=<20090403015703.CE0C111A6403@mailbox.lightondesigns.com>
    Apr 2 21:20:12 lightondesigns postfix/qmgr[2978]: 8E18511A627D: from=<root@lightondesigns.com>, size=1953, nrcpt=1 (queue active)
    Apr 2 21:20:12 lightondesigns amavis[3158]: (03158-02-19) Passed CLEAN, <root@lightondesigns.com> -> <root@lightondesigns.com>, Message-ID: <20090403015703.CE0C111A6403@mailbox.lightondesigns.com>, mail_id: ZAgx9IHq7E8z, Hits: 2.863, size: 1271, queued_as: 8E18511A627D, 1186 ms
    Apr 2 21:20:12 lightondesigns postfix/virtual[3173]: 8E18511A627D: to=<root@lightondesigns.com>, relay=virtual, delay=0.02, delays=0.01/0/0/0.01, dsn=5.1.1, status=bounced (unknown user: "root@lightondesigns.com")
    Apr 2 21:20:12 lightondesigns postfix/cleanup[3024]: 91F3011A62D5: message-id=<20090403022012.91F3011A62D5@mailbox.lightondesigns.com>
    Apr 2 21:20:12 lightondesigns postfix/smtp[3003]: CE0C111A6403: to=<root@lightondesigns.com>, 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=<root@lightondesigns.com>, relay=virtual, delay=0.03, delays=0.02/0/0/0.01, dsn=5.1.1, status=bounced (unknown user: "root@lightondesigns.com")
    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, user=patrick@lightondesigns.com, 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=<20090403022627.033C411A6283@mailbox.lightondesigns.com>
    Apr 2 21:26:27 lightondesigns postfix/qmgr[2978]: 033C411A6283: from=<root@lightondesigns.com>, 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=<20090403022627.033C411A6283@mailbox.lightondesigns.com>
    Apr 2 21:26:28 lightondesigns postfix/qmgr[2978]: 2BDE211A627D: from=<root@lightondesigns.com>, size=829, nrcpt=1 (queue active)
    Apr 2 21:26:28 lightondesigns amavis[3457]: (03457-01) Passed CLEAN, <root@lightondesigns.com> -> <patrick@lightondesigns.com>, Message-ID: <20090403022627.033C411A6283@mailbox.lightondesigns.com>, mail_id: yFgPUalfgtm6, Hits: 1.415, size: 337, queued_as: 2BDE211A627D, 1154 ms
    Apr 2 21:26:28 lightondesigns postfix/smtp[3671]: 033C411A6283: to=<patrick@lightondesigns.com>, 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=<patrick@lightondesigns.com>, relay=virtual, delay=0.05, delays=0.02/0.01/0/0.02, dsn=5.1.1, status=bounced (unknown user: "patrick@lightondesigns.com")
    Apr 2 21:26:28 lightondesigns postfix/cleanup[3668]: 37C2711A62D5: message-id=<20090403022628.37C2711A62D5@mailbox.lightondesigns.com>
    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=<root@lightondesigns.com>, relay=virtual, delay=0.03, delays=0.02/0/0/0.01, dsn=5.1.1, status=bounced (unknown user: "root@lightondesigns.com")
    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, user=patrick@lightondesigns.com, 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?
     
  10. falko

    falko Super Moderator

    Does patrick@lightondesigns.com exist in the database?
     
  11. pwaterz

    pwaterz New Member

    in my user table I have:

    email = patrick@lightondesigns.com
    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=<pwaterz@gmail.com> to=<postmaster@lightondesigns.com> 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=<20090403035255.642DD11A6321@mailbox.lightondesigns.com>
    Apr 2 22:52:55 lightondesigns postfix/qmgr[2970]: 642DD11A6321: from=<root@lightondesigns.com>, 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=<20090403035255.642DD11A6321@mailbox.lightondesigns.com>
    Apr 2 22:53:01 lightondesigns postfix/qmgr[2970]: 4F88111A6272: from=<root@lightondesigns.com>, size=1015, nrcpt=1 (queue active)
    Apr 2 22:53:01 lightondesigns postfix/smtp[3387]: 642DD11A6321: to=<patrick@lightondesigns.com>, 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=<patrick@lightondesigns.com>, relay=virtual, delay=0.07, delays=0.01/0.04/0/0.02, dsn=5.1.1, status=bounced (unknown user: "patrick@lightondesigns.com")
    Apr 2 22:53:01 lightondesigns postfix/cleanup[3384]: 6175F11A6322: message-id=<20090403035301.6175F11A6322@mailbox.lightondesigns.com>
    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=<root@lightondesigns.com>, relay=virtual, delay=0.03, delays=0.02/0/0/0.01, dsn=5.1.1, status=bounced (unknown user: "root@lightondesigns.com")
    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=<20090403035326.7E4D611A6321@mailbox.lightondesigns.com>
    Apr 2 22:53:26 lightondesigns postfix/qmgr[2970]: 7E4D611A6321: from=<root@lightondesigns.com>, 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=<20090403035326.7E4D611A6321@mailbox.lightondesigns.com>
    Apr 2 22:53:27 lightondesigns postfix/qmgr[2970]: 968CD11A6272: from=<root@lightondesigns.com>, size=796, nrcpt=1 (queue active)
    Apr 2 22:53:27 lightondesigns postfix/smtp[3387]: 7E4D611A6321: to=<pwaterz@gmail.com>, 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=<pwaterz@gmail.com>, 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 <patrick@lightondesigns.com>: Recipient address rejected: User unknown in virtual mailbox table; from=<pwaterz@gmail.com> to=<patrick@lightondesigns.com> 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=<20090403050001.9FB2C11A6321@mailbox.lightondesigns.com>
    Apr 3 00:00:01 lightondesigns postfix/qmgr[2964]: 9FB2C11A6321: from=<root@lightondesigns.com>, 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=<20090403050001.9FB2C11A6321@mailbox.lightondesigns.com>
    Apr 3 00:00:08 lightondesigns postfix/qmgr[2964]: F040A11A6320: from=<root@lightondesigns.com>, size=1019, nrcpt=1 (queue active)
    Apr 3 00:00:08 lightondesigns postfix/smtp[4998]: 9FB2C11A6321: to=<postmaster@lightondesigns.tld>, 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=<postmaster@lightondesigns.tld>, 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=<20090403050008.2BE2D11A6322@mailbox.lightondesigns.com>
    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=<root@lightondesigns.com>, relay=virtual, delay=0.07, delays=0.02/0.04/0/0.01, dsn=5.1.1, status=bounced (unknown user: "root@lightondesigns.com")
    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 <patrick@lightondesigns.com>: Recipient address rejected: User unknown in virtual mailbox table; from=<pwaterz@gmail.com> to=<patrick@lightondesigns.com> 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 <patrick@lightondesigns.com>: Recipient address rejected: User unknown in virtual mailbox table; from=<pwaterz@gmail.com> to=<patrick@lightondesigns.com> 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 ;=)
     
  12. falko

    falko Super Moderator

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

    pwaterz New Member

    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 <kink@users.sourceforge.net>
    * 2002-2005 Paul Lesneiwski <paul@openguild.net>
    * 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 "jose@example.com"
    // %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 "jose@example.com"
    // %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 "jose@example.com"
    // %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 "jose@example.com"
    // %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;



    ?>
     
  14. pwaterz

    pwaterz New Member

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

    Thanks again, your the shizznizzle, lol
     

Share This Page