Aaron, Just been a silent by stander for a while but getting ready to do some heavy load testing on dbmail. If there has been many bug fixes in the current svn trunk should there be a new development release e.g. 2.1.4? Just trying to get a feel for how things are going. As always I will test SVN over the current devel release. Also how close do you and paul and the rest of the developers think we are to a stable 2.2 ?
Thanks, Leif Jackson p.s. Aaron how is the sieve support in 2.1.x? Any luck getting it working? On Wed, January 4, 2006 4:22 pm, [EMAIL PROTECTED] wrote: > > The following issue has been CLOSED > ====================================================================== > http://www.dbmail.org/mantis/view.php?id=290 > ====================================================================== > Reported By: moje > Assigned To: > ====================================================================== > Project: DBMail > Issue ID: 290 > Category: Database layer > Reproducibility: always > Severity: block > Priority: normal > Status: closed > Resolution: open > Fixed in Version: > ====================================================================== > Date Submitted: 04-Jan-06 19:44 CET > Last Modified: 04-Jan-06 22:22 CET > ====================================================================== > Summary: Unable to create INBOX (or trash and next > ...) if > USER is not in dbmail_users (using LDAP auth) > Description: > errormsg: > dbpgsql.c, db_query: Error executing query [INSERT INTO dbmail_mailboxes > (name, owner_idnr,seen_flag, answered_flag, deleted_flag, flagged_flag, > recent_flag, draft_flag, permission) VALUES ('Trash', '500', 1, 1, 1, 1, 1, > 1, 2)] : [ERROR: insert or update on table "dbmail_mailboxes" violates > foreign key constraint "dbmail_mailboxes_owner_idnr_fkey" DETAIL: Key > (owner_idnr)=(500) is not present in table "dbmail_users". ] > > > Recomendation: > Create user in dbmail_users if auth is success, but user don't exists. > > > > ====================================================================== > > > ---------------------------------------------------------------------- > aaron - 04-Jan-06 21:00 > ---------------------------------------------------------------------- > Please set trace_syslog = 5 and post more of the output. I'm looking for > > > db.c,db_user_find_create: user_idnr [500] > > > If we don't see that, then I'll instrument some more code and have you > test again. > > ---------------------------------------------------------------------- > moje - 04-Jan-06 21:20 > ---------------------------------------------------------------------- > i have trace_syslog on level 5. problem is in file db.c, function > db_createmailbox() if LDAP auth is in use, no users are in dbmail_users > and default constraint is don't allow create mailboxes for users which are > not in dbmail_users. Current solution is exit from db_createmailbox(). > better may be create user and than create mailbox. > > ---------------------------------------------------------------------- > aaron - 04-Jan-06 21:31 > ---------------------------------------------------------------------- > In db_createmailbox, you will see this section: > > > if (auth_requires_shadow_user()) { ... > } > > > For auth ldap, this function returns true. The code inside creates the > shadow user. Please post the additional logs so that I can see if that code > is running. > > ---------------------------------------------------------------------- > moje - 04-Jan-06 22:13 > ---------------------------------------------------------------------- > Sorry, but can't use svn trunk. it's close to impossible to build > incomplete build tree on my test machine. I have 2.1.3 version only :-(. > > ---------------------------------------------------------------------- > aaron - 04-Jan-06 22:21 > ---------------------------------------------------------------------- > I *highly* recommend SVN trunk over 2.1.3. There are a number of known > bugs that have been fixed, and I don't believe that anything is totally > broken in trunk right now. > > If you have build problems, post to the mailing list and we'll help you > out! > > ---------------------------------------------------------------------- > aaron - 04-Jan-06 22:22 > ---------------------------------------------------------------------- > If the problem still appears in trunk, please reopen the bug. Otherwise, > gotta close it. The code has changed a lot since 2.1.3. > > Issue History > Date Modified Username Field Change > ====================================================================== > 04-Jan-06 19:44 moje New Issue > 04-Jan-06 21:00 aaron Note Added: 0000968 > 04-Jan-06 21:20 moje Note Added: 0000972 > 04-Jan-06 21:31 aaron Note Added: 0000973 > 04-Jan-06 22:13 moje Note Added: 0000974 > 04-Jan-06 22:21 aaron Note Added: 0000975 > 04-Jan-06 22:22 aaron Status new => closed > 04-Jan-06 22:22 aaron Note Added: 0000976 > ====================================================================== > > > _______________________________________________ > Dbmail-dev mailing list > Dbmail-dev@dbmail.org > http://twister.fastxs.net/mailman/listinfo/dbmail-dev > >