Hi,
It's a while since I've used dbmail, but I'm building a new system and
thought I'd use the change to go back to dbmail... 2.0rc1 is available, so
I'm gonna try to go with that rather than install somthing that is about
to be obsolited...
Weird problems seem to plague me though!!!
Using Postgres (7.4.1), I create the database and schema, then a user and
I can pop3 to the user and verify that there is no mail...
So, try to deliver mail, and I get the log included below....
It seems that it finds the user_idnr (2) and then tried to create the
mailbox with ownder_idnr=0, this results in failure, since the database
schema (obviously) won't let it create a mailbox for a user who doesn't
exist.... ownder_idnr seems to always be '0' in this case, regardless of
the user_idnr...
I changed the user_idnr in the database to '0' and it got a little
further, but failed again because it seems that the '0' is only occuring
on some places.
Any suggestions?
Feb 1 19:21:12 dozer dbmail/smtp[1076]: authsql.c,auth_check_user_ext:
into checking loop
Feb 1 19:21:12 dozer dbmail/smtp[1076]: authsql.c,auth_check_user_ext:
checking user [EMAIL PROTECTED] to 2
Feb 1 19:21:12 dozer dbmail/smtp[1076]: authsql.c,auth_check_user_ext:
checking user [2] in alias table
Feb 1 19:21:12 dozer dbmail/smtp[1076]: authsql.c,auth_check_user_ext:
checks [1]
Feb 1 19:21:12 dozer dbmail/smtp[1076]: dbpgsql.c,db_query: executing
query [SELECT deliver_to FROM aliases WHERE alias='2']
Feb 1 19:21:12 dozer dbmail/smtp[1076]: authsql.c,auth_check_user_ext:
adding [2] to deliver_to address
Feb 1 19:21:12 dozer dbmail/smtp[1076]: pipe.c, resolve_address: user
[EMAIL PROTECTED] found total of [1] aliases
Feb 1 19:21:12 dozer dbmail/smtp[1076]: misc.c,create_unique_id: created:
d17f8f3488fea9f4c832fa2393756465
Feb 1 19:21:12 dozer dbmail/smtp[1076]: dbpgsql.c,db_query: executing
query [SELECT mailbox_idnr FROM mailboxes WHERE LOWER(name) =
LOWER('INBOX') AND owner_idnr='0']
Feb 1 19:21:12 dozer dbmail/smtp[1076]: dbpgsql.c,db_query: previous
result set is possibly not freed.
Feb 1 19:21:12 dozer dbmail/smtp[1076]: dbpgsql.c,db_query: executing
query [INSERT INTO mailboxes (name, owner_idnr,seen_flag, answered_flag,
deleted_flag, flagged_flag, recent_flag, draft_flag, permission) VALUES
('INBOX', '0', 1, 1, 1, 1, 1, 1, 2)]
Feb 1 19:21:12 dozer dbmail/smtp[1076]: dbpgsql.c, db_query: Error
executing query [INSERT INTO mailboxes (name, owner_idnr,seen_flag,
answered_flag, deleted_flag, flagged_flag, recent_flag, draft_flag,
permission) VALUES ('INBOX', '0', 1, 1, 1, 1, 1, 1, 2)] : [ERROR: insert
or update on table "mailboxes" violates foreign key constraint "$1"
DETAIL: Key (owner_idnr)=(0) is not present in table "users". ]
Feb 1 19:21:12 dozer dbmail/smtp[1076]: db.c,db_createmailbox: could not
create mailbox
(¯·.¸¸.·´¯·.¸¸.-> A. James Lewis ([EMAIL PROTECTED])
LINUX - World Domination Through World Cooperation.
