|
Hi everybody,
i'm trying to install courier-authlib-0.58 on my
SlackWare 10.2 with kernel 2.6.16.16 box that should work with a MySQL 5.0.21
database.
I've compiled it in this way:
./configure --prefix=/usr/local/courierauth
--with-gnu-ld --without-authuserdb --without-authpam --without-authldap
--without-authpwd --without-authshadow --without-authchkpw --without-authpgsql
--without-authcustom --without-authpipe --with-authmysql
--with-mysql-libs=/usr/local/mysql/lib/mysql
--with-mysql-includes=/usr/local/mysql/include/mysql
Then i've created a table named "mailbox" in
"postfix" database that contains:
mysql> describe
mailbox;
+----------+--------------+------+-----+---------------------+-------+ | Field | Type | Null | Key | Default | Extra | +----------+--------------+------+-----+---------------------+-------+ | username | varchar(255) | NO | PRI | NULL | | | password | varchar(255) | NO | | NULL | | | name | varchar(255) | NO | | NULL | | | maildir | varchar(255) | NO | | NULL | | | quota | int(10) | NO | | 0 | | | domain | varchar(255) | NO | | NULL | | | created | datetime | NO | | 0000-00-00 00:00:00 | | | modified | datetime | NO | | 0000-00-00 00:00:00 | | | active | tinyint(1) | NO | | 1 | | | uid | varchar(5) | YES | | NULL | | | gid | varchar(5) | YES | | NULL | | +----------+--------------+------+-----+---------------------+-------+ so 'ive configured my authmysqlrc
file:
MYSQL_SERVER
127.0.0.1
MYSQL_PORT 3306 MYSQL_USERNAME postfix MYSQL_PASSWORD postfix MYSQL_OPT 0 MYSQL_DATABASE postfix MYSQL_TABLE mailbox MYSQL_CLEAR_PWFIELD password MYSQL_LOGIN_FIELD username MYSQL_HOME_FIELD '/usr/local/virtual' MYSQL_NAME_FIELD name MYSQL_MAILDIR_FIELD maildir MYSQL_UID_FIELD '1001' MYSQL_GID_FIELD '1001' (i've checked username and password a loooooooooot
of times!)
but when i run "authtest" command i always
obtain:
Authentication FAILED: Input/output
error
Logging the MySQL queries i can see:
060523 18:01:45 11
Connect [EMAIL PROTECTED] on
11 Init DB postfix and no more............
Why??? Somebody can help me please, i'm becoming
crazy!!!!
Thanx a lot in advance.
Simone Nanni
ICT Technician A.O.U. Policlinico Tor Vergata Viale Oxford, 81 00133 - Roma - RM - Italy Tel: 06/20900081 Fax: 06/20900080 Mail: [EMAIL PROTECTED] |
- [courier-users] Authmysql trouble... Simone Nanni
