Can't get authenticated.

Discussion in 'HOWTO-Related Questions' started by kwinnuxbie, Oct 28, 2006.

  1. kwinnuxbie

    kwinnuxbie New Member

    I hope this will get me going. I installed everything with out a hitch, for the Nth time, all went well untill I try to login..
    I used the the Inserts

    INSERT INTO `domains` (`domain`) VALUES ('example.com');
    INSERT INTO `users` (`email`, `password`, `quota`) VALUES ('[email protected]', ENCRYPT('secret'), 10485760);

    Should I have used SALT on Encrypt? If so where do I set it...
    Here is my maillog
    Oct 27 21:32:58 ridersnet authdaemond: modules="authmysql", daemons=5
    Oct 27 21:32:58 ridersnet authdaemond: Installing libauthmysql
    Oct 27 21:32:58 ridersnet authdaemond: Installation complete: authmysql
    Oct 27 21:33:03 ridersnet clamd[2186]: Daemon started.
    Oct 27 21:33:03 ridersnet clamd[2186]: clamd daemon 0.88.5 (OS: linux-gnu, ARCH: x86_64, CPU: x86_64)
    Oct 27 21:33:03 ridersnet clamd[2186]: Log file size limited to 1048576 bytes.
    Oct 27 21:33:03 ridersnet clamd[2186]: Running as user amavis (UID 101, GID 5001)
    Oct 27 21:33:03 ridersnet clamd[2186]: Reading databases from /var/lib/clamav
    Oct 27 21:33:06 ridersnet clamd[2186]: Protecting against 74614 viruses.
    Oct 27 21:33:06 ridersnet clamd[2187]: Unix socket file /var/spool/amavisd/clamd.sock
    Oct 27 21:33:06 ridersnet clamd[2187]: Setting connection queue length to 15
    Oct 27 21:33:06 ridersnet clamd[2187]: Archive: Archived file size limit set to 10485760 bytes.
    Oct 27 21:33:06 ridersnet clamd[2187]: Archive: Recursion level limit set to 8.
    Oct 27 21:33:06 ridersnet clamd[2187]: Archive: Files limit set to 1000.
    Oct 27 21:33:06 ridersnet clamd[2187]: Archive: Compression ratio limit set to 250.
    Oct 27 21:33:06 ridersnet clamd[2187]: Archive support enabled.
    Oct 27 21:33:06 ridersnet clamd[2187]: Archive: RAR support disabled.
    Oct 27 21:33:06 ridersnet clamd[2187]: Portable Executable support enabled.
    Oct 27 21:33:06 ridersnet clamd[2187]: Mail files support enabled.
    Oct 27 21:33:06 ridersnet clamd[2187]: OLE2 support enabled.
    Oct 27 21:33:06 ridersnet clamd[2187]: HTML support enabled.
    Oct 27 21:33:06 ridersnet clamd[2187]: Self checking every 1800 seconds.
    Oct 27 21:33:08 ridersnet amavis[2195]: starting. /usr/sbin/amavisd at ridersnet.com amavisd-new-2.4.3 (20060930), Unicode aware, LANG=en_US.UTF-8
    Oct 27 21:33:08 ridersnet amavis[2195]: Perl version 5.008008
    Oct 27 21:33:10 ridersnet amavis[2196]: Module Amavis::Conf 2.072
    Oct 27 21:33:10 ridersnet amavis[2196]: Module Archive::Tar 1.30
    Oct 27 21:33:10 ridersnet amavis[2196]: Module Archive::Zip 1.16
    Oct 27 21:33:10 ridersnet amavis[2196]: Module BerkeleyDB 0.27
    Oct 27 21:33:10 ridersnet amavis[2196]: Module Compress::Zlib 1.41
    Oct 27 21:33:10 ridersnet amavis[2196]: Module Convert::TNEF 0.17
    Oct 27 21:33:10 ridersnet amavis[2196]: Module Convert::UUlib 1.06
    Oct 27 21:33:10 ridersnet amavis[2196]: Module DBD::mysql 3.0004
    Oct 27 21:33:10 ridersnet amavis[2196]: Module DBI 1.50
    Oct 27 21:33:10 ridersnet amavis[2196]: Module DB_File 1.814
    Oct 27 21:33:10 ridersnet amavis[2196]: Module Digest::MD5 2.36
    Oct 27 21:33:10 ridersnet amavis[2196]: Module MIME::Entity 5.420
    Oct 27 21:33:10 ridersnet amavis[2196]: Module MIME::parser 5.420
    Oct 27 21:33:10 ridersnet amavis[2196]: Module MIME::Tools 5.420
    Oct 27 21:33:10 ridersnet amavis[2196]: Module Mail::Header 1.74
    Oct 27 21:33:10 ridersnet amavis[2196]: Module Mail::Internet 1.74
    Oct 27 21:33:10 ridersnet amavis[2196]: Module Mail::SPF::Query 1.999001
    Oct 27 21:33:10 ridersnet amavis[2196]: Module Mail::SpamAssassin 3.001003
    Oct 27 21:33:10 ridersnet amavis[2196]: Module Net::Cmd 2.26
    Oct 27 21:33:10 ridersnet amavis[2196]: Module Net::DNS 0.59
    Oct 27 21:33:10 ridersnet amavis[2196]: Module Net::SMTP 2.29
    Oct 27 21:33:10 ridersnet amavis[2196]: Module Net::Server 0.94
    Oct 27 21:33:10 ridersnet amavis[2196]: Module Razor2::Client::Version 2.77
    Oct 27 21:33:10 ridersnet amavis[2196]: Module Time::HiRes 1.86
    Oct 27 21:33:10 ridersnet amavis[2196]: Module Unix::Syslog 0.100
    Oct 27 21:33:10 ridersnet amavis[2196]: Amavis::DB code loaded
    Oct 27 21:33:10 ridersnet amavis[2196]: Amavis::Cache code loaded
    Oct 27 21:33:10 ridersnet amavis[2196]: SQL base code loaded
    Oct 27 21:33:10 ridersnet amavis[2196]: SQL::Log code NOT loaded
    Oct 27 21:33:10 ridersnet amavis[2196]: SQL::Quarantine NOT loaded
    Oct 27 21:33:10 ridersnet amavis[2196]: Lookup::SQL code loaded
    Oct 27 21:33:10 ridersnet amavis[2196]: Lookup::LDAP code NOT loaded
    Oct 27 21:33:10 ridersnet amavis[2196]: AM.PDP-in proto code loaded
    Oct 27 21:33:10 ridersnet amavis[2196]: SMTP-in proto code loaded
    Oct 27 21:33:10 ridersnet amavis[2196]: Courier proto code NOT loaded
    Oct 27 21:33:10 ridersnet amavis[2196]: SMTP-out proto code loaded
    Oct 27 21:33:10 ridersnet amavis[2196]: Pipe-out proto code NOT loaded
    Oct 27 21:33:10 ridersnet amavis[2196]: BSMTP-out proto code NOT loaded
    Oct 27 21:33:10 ridersnet amavis[2196]: Local-out proto code loaded
    Oct 27 21:33:10 ridersnet amavis[2196]: OS_Fingerprint code NOT loaded
    Oct 27 21:33:10 ridersnet amavis[2196]: ANTI-VIRUS code loaded
    Oct 27 21:33:10 ridersnet amavis[2196]: ANTI-SPAM code loaded
    Oct 27 21:33:10 ridersnet amavis[2196]: ANTI-SPAM-SA code loaded
    Oct 27 21:33:10 ridersnet amavis[2196]: Unpackers code loaded
    Oct 27 21:33:11 ridersnet amavis[2196]: Found $file at /usr/bin/file
    Oct 27 21:33:11 ridersnet amavis[2196]: No $dspam, not using it
    Oct 27 21:33:11 ridersnet amavis[2196]: Internal decoder for .mail
    Oct 27 21:33:11 ridersnet amavis[2196]: Internal decoder for .asc
    Oct 27 21:33:11 ridersnet amavis[2196]: Internal decoder for .uue
    Oct 27 21:33:11 ridersnet amavis[2196]: Internal decoder for .hqx
    Oct 27 21:33:11 ridersnet amavis[2196]: Internal decoder for .ync
    Oct 27 21:33:11 ridersnet amavis[2196]: Found decoder for .F at /usr/bin/unfreeze
    Oct 27 21:33:11 ridersnet amavis[2196]: Found decoder for .Z at /usr/bin/gzip -d
    Oct 27 21:33:11 ridersnet amavis[2196]: Found decoder for .gz at /usr/bin/gzip -d
    Oct 27 21:33:11 ridersnet amavis[2196]: Found decoder for .bz2 at /usr/bin/bzip2 -d
    Oct 27 21:33:11 ridersnet amavis[2196]: Found decoder for .lzo at /usr/bin/lzop -d
    Oct 27 21:33:11 ridersnet amavis[2196]: Found decoder for .rpm at /usr/bin/rpm2cpio
    Oct 27 21:33:11 ridersnet amavis[2196]: Found decoder for .cpio at /usr/bin/pax
    Oct 27 21:33:11 ridersnet amavis[2196]: Found decoder for .tar at /usr/bin/pax
    Oct 27 21:33:11 ridersnet amavis[2196]: Found decoder for .deb at /usr/bin/ar
    Oct 27 21:33:11 ridersnet amavis[2196]: Internal decoder for .zip
    Oct 27 21:33:11 ridersnet amavis[2196]: No decoder for .rar tried: rar, unrar
    Oct 27 21:33:11 ridersnet amavis[2196]: Found decoder for .arj at /usr/bin/arj
    Oct 27 21:33:11 ridersnet amavis[2196]: Found decoder for .arc at /usr/bin/nomarch
    Oct 27 21:33:11 ridersnet amavis[2196]: No decoder for .zoo tried: zoo, unzoo
    Oct 27 21:33:11 ridersnet amavis[2196]: No decoder for .lha tried: lha
    Oct 27 21:33:11 ridersnet amavis[2196]: Found decoder for .cab at /usr/bin/cabextract
    Oct 27 21:33:11 ridersnet amavis[2196]: No decoder for .tnef tried: tnef
    Oct 27 21:33:11 ridersnet amavis[2196]: Internal decoder for .tnef
    Oct 27 21:33:11 ridersnet amavis[2196]: Found decoder for .exe at /usr/bin/arj
    Oct 27 21:33:11 ridersnet amavis[2196]: Using internal av scanner code for (primary) ClamAV-clamd
    Oct 27 21:33:11 ridersnet amavis[2196]: Found secondary av scanner ClamAV-clamscan at /usr/bin/clamscan
    Oct 27 21:33:11 ridersnet amavis[2196]: Creating db in /var/spool/amavisd/db/; BerkeleyDB 0.27, libdb 4.3
    Oct 27 21:33:11 ridersnet sendmail[2233]: alias database /etc/aliases rebuilt by root
    Oct 27 21:33:11 ridersnet sendmail[2233]: /etc/aliases: 76 aliases, longest 10 bytes, 765 bytes total
    Oct 27 21:33:14 ridersnet postfix/postfix-script: starting the Postfix mail system
    Oct 27 21:33:14 ridersnet postfix/master[2279]: daemon started -- version 2.2.8, configuration /etc/postfix
    Oct 27 21:36:55 ridersnet imapd: Connection, ip=[::ffff:127.0.0.1]
    Oct 27 21:36:55 ridersnet imapd: LOGIN FAILED, user=kerwin, ip=[::ffff:127.0.0.1]
    Oct 27 21:37:00 ridersnet imapd: LOGOUT, ip=[::ffff:127.0.0.1], rcvd=45, sent=332
    Oct 27 21:37:07 ridersnet imapd: Connection, ip=[::ffff:127.0.0.1]
    Oct 27 21:37:07 ridersnet imapd: LOGIN FAILED, user=kerwin, ip=[::ffff:127.0.0.1]
    Oct 27 21:37:12 ridersnet imapd: LOGOUT, ip=[::ffff:127.0.0.1], rcvd=37, sent=332
     
  2. falko

    falko Super Moderator ISPConfig Developer

    The tutorial works exactly as described, so no salt...
    You must send an email first to a new user before you can log in with IMAP.
     

Share This Page