[ale] Fwd: postfix+sasl-auth+courier-imap+mysql

[Dow Hurst]

Can we get some more info?  Such as what are your error messages?  What 
is crapping out on you?  What isn't working?
Dow


Hernan Arteta wrote:

>Hi,
>after a long time looking for a "howto" make this combo (postfix+sasl-
>auth+courier-imap+mysqlwork), postfix can 
>relay mail from authorized user looking in mysql DB, the problems start 
>with courier-imap and mysql I saw a lot of posted messages about this 
>issue but anything works for me.
>I'm using 
>RH7.2 updated on RH network
>Postfix 1.1.11 (Tuomo Soini)
>Cyrus-SASL 1.5.27 (Tuomo Soini)
>Courier-IMAP installed from a RPM, this was maked following instructions 
>founded in the source courier-imap-1.6.1.tar.bz2 (courier-imap-1.6.1-
>1.7.2.i386.rpm and courier-imap-mysql-1.6.1-1.7.2.i386.rpm).
>
>config files in /usr/lib/courier-imap/etc/
>authdaemonrc
>##NAME: authmodulelist:0
>#
># The authentication modules that are linked into authdaemond.  The
># default list is installed.  You may selectively disable modules simply
># by removing them from the following list.  The available modules you
># can use are: authcustom authcram authuserdb authldap authpgsql 
>authmysql authpam
>
>authmodulelist="authmysql"
>
>##NAME: authmodulelistorig:1
>#
># This setting is used by Courier's webadmin module, and should be left
># alone
>
>authmodulelistorig="authcustom authcram authuserdb authldap authpgsql 
>authmysql authpam"
>
>##NAME: daemons:0
>#
># The number of daemon processes that are started.  authdaemon is 
>typically
># installed where authentication modules are relatively expensive: such
># as authldap, or authmysql, so it's better to have a number of them 
>running.
># PLEASE NOTE:  Some platforms may experience a problem if there's more 
>than
># one daemon.  Specifically, SystemV derived platforms that use TLI with
># socket emulation.  I'm suspicious of TLI's ability to handle multiple
># processes accepting connections on the same filesystem domain socket.
>#
># You may need to increase daemons if as your system load increases.  
>Symptoms
># include sporadic authentication failures.  If you start getting
># authentication failures, increase daemons.  However, the default of 5
># SHOULD be sufficient.  Bumping up daemon count is only a short-term
># solution.  The permanent solution is to add more resources: RAM, faster
># disks, faster CPUs...
>
>daemons=5
>
>##NAME: version:0
>#
># When you have multiple versions of authdaemond.* installed, authdaemond
># just picks the first one it finds.  Set "version" to override that.
># For example:  version=authdaemond.plain
>
>version="authdaemond.mysql"
>
>##NAME: authdaemonvar:0
>#
># authdaemonvar is here, but is not used directly by authdaemond.  It's
># used by various configuration and build scripts, so don't touch it!
>
>authdaemonvar=/var/run/authdaemon.courier-imap
>
>
>
>authmysqlrc
>MYSQL_SERVER		localhost
>MYSQL_USERNAME		login
>MYSQL_PASSWORD		password
>MYSQL_SOCKET		/var/lib/mysql/mysql.sock
>MYSQL_PORT		3306
>MYSQL_DATABASE          maildb
>MYSQL_USER_TABLE        users
>MYSQL_CRYPT_PWFIELD     crypt
>MYSQL_CLEAR_PWFIELD     clear
>MYSQL_UID_FIELD         uid
>MYSQL_GID_FIELD         gid
>MYSQL_LOGIN_FIELD       id
>MYSQL_HOME_FIELD        home
>MYSQL_NAME_FIELD        name
>MYSQL_MAILDIR_FIELD     maildir
>MYSQL_WHERE_CLAUSE      imapok=1 AND bool1=1 AND bool2=1
>
>
>trace from /var/log/maillog
>Dec 18 13:40:48 localhost pop3d: Connection, ip=[::ffff:127.0.0.1]
>Dec 18 13:40:57 localhost pop3d: LOGIN: DEBUG: ip=[::ffff:127.0.0.1], 
>command=USER
>Dec 18 13:41:02 localhost pop3d: LOGIN: DEBUG: ip=[::ffff:127.0.0.1], 
>command=PASS
>Dec 18 13:41:02 localhost pop3d: LOGIN: DEBUG: ip=[::ffff:127.0.0.1], 
>username="username"
>Dec 18 13:41:02 localhost pop3d: LOGIN: DEBUG: ip=[::ffff:127.0.0.1], 
>password="password"
>Dec 18 13:41:02 localhost pop3d: Usage: /usr/lib/courier-
>imap/libexec/authlib/authdaemond.mysql start|stop|restart
>
>
>no trace in /var/log/mysql.log
>
>-mysql daemon is started because I can authenticate users for relay mail 
>from DB
>
>Maybe some one out there have this working and can help me.
>Thanks
>
>Hernan
>
>
>_______________________________________________
>Ale mailing list
>Ale at ale.org
>http://www.ale.org/mailman/listinfo/ale
>
>  
>

-- 
__________________________________________________________
Dow Hurst                  Office: 770-499-3428
Systems Support Specialist    Fax: 770-423-6744
1000 Chastain Rd., Bldg. 12
Chemistry Department SC428  Email:dhurst at kennesaw.edu
Kennesaw State University         Dow.Hurst at mindspring.com
Kennesaw, GA 30144
*********************************
*Computational Chemistry is fun!*
*********************************


_______________________________________________
Ale mailing list
Ale at ale.org
http://www.ale.org/mailman/listinfo/ale