

![]() | Start a set with this search |
![]() | Include this search in one of my sets |
![]() | Exclude this search from one of my sets |
![]() | Permalink to these results Paste this link in email or IM: |
| Atom feed for tracking future search results Paste this URL into your reader: |
6 messages in net.sourceforge.lists.courier-users[courier-users] Authmysql trouble...| From | Sent On | Attachments |
|---|---|---|
| Simone Nanni | May 23, 2006 9:05 am | |
| Jay Lee | May 23, 2006 10:02 am | |
| ma...@intron.ac | May 23, 2006 10:36 am | |
| mouss | May 28, 2006 2:01 pm | |
| ma...@intron.ac | May 28, 2006 11:11 pm | |
| mouss | May 29, 2006 6:17 pm |

![]() | Permalink for this message Paste this link in email or IM: |
![]() | Permalink for this thread Paste this link in email or IM: |
| Atom feed for this thread Paste this URL into your reader: |
| Subject: | [courier-users] Authmysql trouble... | Actions... |
|---|---|---|
| From: | Simone Nanni (simo...@ptvonline.it) | |
| Date: | May 23, 2006 9:05:47 am | |
| List: | net.sourceforge.lists.courier-users | |
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 postfix@localhost 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: simo...@ptvonline.it







