authenticating courier against postgresql with authpgsql fails
Hi
I tried the whole day to get this courier and postgresql thing flying. I
managed it that postfix looks it's virtual table from the database. But with
courier no chance. I am not sure if it is an error in my configuration (I
think not) or if some package is broken. Perhaps one of you guys can give me
a hint.
PostgreSQL Table
Table "courier"
Column | Type | Modifiers
----------+------------------------+------------------------
id | character varying(128) | not null default ''
password | character varying(128) | not null default ''
vollname | character varying(128) | not null default ''
uid | numeric(10,0) | not null default '101'
gid | numeric(10,0) | not null default '101'
home | character varying(255) | not null default ''
maildir | character varying(255) | not null default ''
Primary key: courier_pkey
/etc/courier/authpgsqlrc
PGSQL_SERVER localhost
PGSQL_USERNAME courier
PGSQL_PASSWORD courier
PGSQL_PORT /var/run/postgresql/.s.PGSQL.5432
PGSQL_DATABASE courier
PGSQL_USERTABLE courier
PGSQL_CLEAR_PWFIELD password
PGSQL_MAILDIR_FIELD maildir
DEFAULT_DOMAIN pingu.weber.hargarten
When I connect to the box via imap or pop3 I hear some harddisk noise and
find this in the logs (not always but sometimes):
May 16 20:06:10 pingu postgres[23338]: [18] DEBUG: proc_exit(0)
May 16 20:06:10 pingu postgres[23338]: [19] DEBUG: shmem_exit(0)
May 16 20:06:10 pingu postgres[23338]: [20] DEBUG: exit(0)
May 16 20:06:10 pingu postgres[22884]: [18] DEBUG: reaping dead processes
May 16 20:06:10 pingu postgres[22884]: [19] DEBUG: child process (pid
23338) ex
ited with exit code 0
May 16 20:07:31 pingu imaplogin: Connection, ip=[::ffff:192.168.10.16]
May 16 20:07:39 pingu imaplogin: LOGIN FAILED, ip=[::ffff:192.168.10.16]
May 16 20:08:08 pingu last message repeated 2 times
May 16 20:08:12 pingu imaplogin: LOGOUT, ip=[::ffff:192.168.10.16]
Don't know if there is any connection between the two things.
Actually I followed the manual one can find under
http://www.sweeney.demon.co.uk/pfix_imap_virtual.html and adopted it for
postgresql.
Installed packages are:
postgresql 7.2.1-2
courier-authpostgresql 0.37.3-2
courier-imap 1.4.3-2
courier-pop 0.37.3-2
courier-authdaemon 0.37.3-2
I also tried the sid packages for courier, at least for the
courier-authpostgresql
Hope that there is someone who can help me... At least that I know if it is
my fault or if I should file a bug report.
Marcel
--
______
(Muuuhh)
Global Village Sau ==> ^..^ |/¯¯¯¯¯
(Kann Fremdsprache) ==> (oo)
--
To UNSUBSCRIBE, email to debian-testing-request@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org
Reply to: