Apr 27 11:50:23 sumy dbmail/lmtpd[58512]: PerformChildTask(): incoming connection from [127.0.0.1] Apr 27 11:50:23 sumy dbmail/lmtpd[58512]: PerformChildTask(): client info init complete, calling client handler Apr 27 11:50:23 sumy dbmail/lmtpd[58512]: lmtp(): incoming buffer: [LHLO sumy.biz] Apr 27 11:50:23 sumy dbmail/lmtpd[58512]: lmtp(): command issued :cmd [LHLO], value [sumy.biz] Apr 27 11:50:23 sumy dbmail/lmtpd[58512]: lmtp(): command looked up as commandtype 0 Apr 27 11:50:23 sumy dbmail/lmtpd[58512]: lmtp(): incoming buffer: [MAIL FROM:<[EMAIL PROTECTED]> SIZE=990] Apr 27 11:50:23 sumy dbmail/lmtpd[58512]: lmtp(): command issued :cmd [MAIL], value [FROM:<[EMAIL PROTECTED]> SIZE=990] Apr 27 11:50:23 sumy dbmail/lmtpd[58512]: lmtp(): command looked up as commandtype 4 Apr 27 11:50:23 sumy dbmail/lmtpd[58512]: misc.c, find_bounded: Found [EMAIL PROTECTED] of length [zd] between '^P' and '<' so next skip [zd] Apr 27 11:50:23 sumy dbmail/lmtpd[58512]: lmtp(): incoming buffer: [RCPT TO:<[EMAIL PROTECTED]>] Apr 27 11:50:23 sumy dbmail/lmtpd[58512]: lmtp(): command issued :cmd [RCPT], value [TO:<[EMAIL PROTECTED]>] Apr 27 11:50:23 sumy dbmail/lmtpd[58512]: lmtp(): command looked up as commandtype 9 Apr 27 11:50:23 sumy dbmail/lmtpd[58512]: misc.c, find_bounded: Found [EMAIL PROTECTED] of length [zd] between '^O' and '<' so next skip [zd] Apr 27 11:50:23 sumy dbmail/lmtpd[58512]: dsn.c, dsnuser_init: dsnuser initialized Apr 27 11:50:23 sumy dbmail/lmtpd[58512]: lmtp(): incoming buffer: [DATA] Apr 27 11:50:23 sumy dbmail/lmtpd[58512]: lmtp(): command looked up as commandtype 3 Apr 27 11:50:23 sumy dbmail/lmtpd[58512]: dbmysql.c,db_query: executing query [SELECT user_idnr FROM users WHERE userid='[EMAIL PROTECTED]'] Apr 27 11:50:23 sumy postfix/smtpd[58554]: disconnect from f6.mail.ru[194.67.57.36] Apr 27 11:50:23 sumy dbmail/lmtpd[58512]: authsql.c,auth_check_user_ext: checking user [EMAIL PROTECTED] in alias table Apr 27 11:50:23 sumy dbmail/lmtpd[58512]: authsql.c,auth_check_user_ext: checks [-1] Apr 27 11:50:23 sumy dbmail/lmtpd[58512]: dbmysql.c,db_query: executing query [SELECT deliver_to FROM aliases WHERE lower(alias) = lower('[EMAIL PROTECTED]')] Apr 27 11:50:23 sumy dbmail/lmtpd[58512]: authsql.c,auth_check_user_ext: into checking loop Apr 27 11:50:23 sumy dbmail/lmtpd[58512]: authsql.c,auth_check_user_ext: checking user [EMAIL PROTECTED] to 668 Apr 27 11:50:23 sumy dbmail/lmtpd[58512]: authsql.c,auth_check_user_ext: checking user [668] in alias table Apr 27 11:50:23 sumy dbmail/lmtpd[58512]: authsql.c,auth_check_user_ext: checks [1] Apr 27 11:50:23 sumy dbmail/lmtpd[58512]: dbmysql.c,db_query: executing query [SELECT deliver_to FROM aliases WHERE lower(alias) = lower('668')] Apr 27 11:50:23 sumy dbmail/lmtpd[58512]: authsql.c,auth_check_user_ext: adding [668] to deliver_to address Apr 27 11:50:23 sumy dbmail/lmtpd[58512]: dsn.c, dsnuser_resolve_list: user [EMAIL PROTECTED] found total of [1] aliases Apr 27 11:50:23 sumy dbmail/lmtpd[58512]: main(): requesting sender to begin message. Apr 27 11:50:23 sumy dbmail/lmtpd[58512]: read_header(): readheader start
Apr 27 11:52:00 sumy postfix/smtpd[58554]: connect from f7.mail.ru[194.67.57.37] Apr 27 11:52:01 sumy postfix/smtpd[58554]: 323EA25F6E0: client=f7.mail.ru[194.67.57.37] Apr 27 11:52:01 sumy postfix/cleanup[58555]: 323EA25F6E0: message-id=<[EMAIL PROTECTED]> Apr 27 11:52:01 sumy postfix/qmgr[34479]: 323EA25F6E0: from=<[EMAIL PROTECTED]>, size=877, nrcpt=1 (queue active) Apr 27 11:52:01 sumy drweb-postfix: dwlib: scan[58587]: message(/tmp/drweb.tmp.3QbQed) sent by [EMAIL PROTECTED] is passed Apr 27 11:52:01 sumy postfix/pickup[57584]: 60B0A25F70D: uid=426 from=<[EMAIL PROTECTED]> Apr 27 11:52:01 sumy postfix/pipe[58564]: 323EA25F6E0: to=<[EMAIL PROTECTED]>, relay=drweb, delay=0, status=sent (dummy) Apr 27 11:52:01 sumy postfix/cleanup[58555]: 60B0A25F70D: message-id=<[EMAIL PROTECTED]> Apr 27 11:52:01 sumy postfix/qmgr[34479]: 60B0A25F70D: from=<[EMAIL PROTECTED]>, size=984, nrcpt=1 (queue active) Apr 27 11:52:01 sumy spamd[32390]: connection from localhost [127.0.0.1] at port 1256 Apr 27 11:52:01 sumy dbmail/smtp[58595]: GetConfigValue(): searching value for config item [host] Apr 27 11:52:01 sumy dbmail/smtp[58595]: GetConfigValue(): NULL item value in item-list Apr 27 11:52:01 sumy dbmail/smtp[58595]: GetConfigValue(): NULL item value in item-list Apr 27 11:52:01 sumy dbmail/smtp[58595]: GetConfigValue(): item not found Apr 27 11:52:01 sumy dbmail/smtp[58595]: GetConfigValue(): searching value for config item [db] Apr 27 11:52:01 sumy dbmail/smtp[58595]: GetConfigValue(): found value [dbmail2] Apr 27 11:52:01 sumy dbmail/smtp[58595]: GetConfigValue(): searching value for config item [user] Apr 27 11:52:01 sumy dbmail/smtp[58595]: GetConfigValue(): found value [dbmail] Apr 27 11:52:01 sumy dbmail/smtp[58595]: GetConfigValue(): searching value for config item [pass] Apr 27 11:52:01 sumy dbmail/smtp[58595]: GetConfigValue(): found value [gbpl.kbyf] Apr 27 11:52:01 sumy dbmail/smtp[58595]: GetConfigValue(): searching value for config item [sqlport] Apr 27 11:52:01 sumy dbmail/smtp[58595]: GetConfigValue(): NULL item value in item-list Apr 27 11:52:01 sumy dbmail/smtp[58595]: GetConfigValue(): NULL item value in item-list Apr 27 11:52:01 sumy dbmail/smtp[58595]: GetConfigValue(): item not found Apr 27 11:52:01 sumy dbmail/smtp[58595]: GetConfigValue(): searching value for config item [sqlsocket] Apr 27 11:52:01 sumy dbmail/smtp[58595]: GetConfigValue(): found value [/tmp/mysql.sock] Apr 27 11:52:01 sumy postfix/smtpd[58554]: disconnect from f7.mail.ru[194.67.57.37] Apr 27 11:52:01 sumy dbmail/smtp[58595]: read_header(): readheader start Apr 27 11:52:01 sumy spamd[58596]: processing message <[EMAIL PROTECTED]> for [EMAIL PROTECTED]:73. Apr 27 11:52:03 sumy spamd[58596]: clean message (-4.9/5.0) for [EMAIL PROTECTED]:73 in 2.3 seconds, 960 bytes. Apr 27 11:52:03 sumy dbmail/smtp[58595]: read_header(): copying line into header Apr 27 11:52:03 sumy dbmail/smtp[58595]: read_header(): copying line into header Apr 27 11:52:03 sumy dbmail/smtp[58595]: read_header(): readheader done Apr 27 11:52:03 sumy dbmail/smtp[58595]: read_header(): found header [ired=5.0 tests=BAYES_00 autolearn=ham version=2.63 X-Spam-Level: Regards, Igor A. Olemskoi, [nix] ] of len [104] using mem [104] Apr 27 11:52:03 sumy dbmail/smtp[58595]: read_header(): function successfull Apr 27 11:52:03 sumy dbmail/smtp[58595]: mime_readheader(): entering mime loop Apr 27 11:52:03 sumy dbmail/smtp[58595]: mime_readheader(): found double newline; header size: 4 lines Apr 27 11:52:03 sumy dbmail/smtp[58595]: mail_adr_list(): mimelist currently has [2] nodes Apr 27 11:52:03 sumy dbmail/smtp[58595]: mail_adr_list(): mail address parser starting Apr 27 11:52:03 sumy dbmail/smtp[58595]: mail_adr_list(): total fields in header 2 Apr 27 11:52:03 sumy dbmail/smtp[58595]: mail_adr_list(): scanning for Return-Path Apr 27 11:52:03 sumy dbmail/smtp[58595]: mail_adr_list(): scanning for Return-Path Apr 27 11:52:03 sumy dbmail/smtp[58595]: mail_adr_list(): found 0 emailaddresses Apr 27 11:52:03 sumy dbmail/smtp[58595]: mail_adr_list(): mail address parser finished Apr 27 11:52:03 sumy dbmail/smtp[58595]: mail_adr_list(): mimelist currently has [2] nodes Apr 27 11:52:03 sumy dbmail/smtp[58595]: mail_adr_list(): mail address parser starting Apr 27 11:52:03 sumy dbmail/smtp[58595]: mail_adr_list(): total fields in header 2 Apr 27 11:52:03 sumy dbmail/smtp[58595]: mail_adr_list(): scanning for From Apr 27 11:52:03 sumy dbmail/smtp[58595]: mail_adr_list(): scanning for From Apr 27 11:52:03 sumy dbmail/smtp[58595]: mail_adr_list(): found 0 emailaddresses Apr 27 11:52:03 sumy dbmail/smtp[58595]: mail_adr_list(): mail address parser finished Apr 27 11:52:03 sumy dbmail/smtp[58595]: main(): no return path found. Apr 27 11:52:03 sumy dbmail/smtp[58595]: dbmysql.c,db_query: executing query [SELECT user_idnr FROM users WHERE userid='[EMAIL PROTECTED]'] Apr 27 11:52:03 sumy dbmail/smtp[58595]: authsql.c,auth_check_user_ext: checking user [EMAIL PROTECTED] in alias table Apr 27 11:52:03 sumy dbmail/smtp[58595]: authsql.c,auth_check_user_ext: checks [-1] Apr 27 11:52:03 sumy dbmail/smtp[58595]: dbmysql.c,db_query: executing query [SELECT deliver_to FROM aliases WHERE lower(alias) = lower('[EMAIL PROTECTED]')] Apr 27 11:52:03 sumy dbmail/smtp[58595]: authsql.c,auth_check_user_ext: into checking loop Apr 27 11:52:03 sumy dbmail/smtp[58595]: authsql.c,auth_check_user_ext: checking user [EMAIL PROTECTED] to 1 Apr 27 11:52:03 sumy dbmail/smtp[58595]: authsql.c,auth_check_user_ext: checking user [1] in alias table Apr 27 11:52:03 sumy dbmail/smtp[58595]: authsql.c,auth_check_user_ext: checks [1] Apr 27 11:52:03 sumy dbmail/smtp[58595]: dbmysql.c,db_query: executing query [SELECT deliver_to FROM aliases WHERE lower(alias) = lower('1')] Apr 27 11:52:03 sumy dbmail/smtp[58595]: authsql.c,auth_check_user_ext: adding [1] to deliver_to address Apr 27 11:52:03 sumy dbmail/smtp[58595]: dsn.c, dsnuser_resolve_list: user [EMAIL PROTECTED] found total of [1] aliases Apr 27 11:52:03 sumy dbmail/smtp[58595]: dbmysql.c,db_query: executing query [SELECT user_idnr FROM users WHERE userid='[EMAIL PROTECTED]@__'] Apr 27 11:52:03 sumy dbmail/smtp[58595]: misc.c,create_unique_id: created: d578abea4d8ce1da1ab1a770434996dd Apr 27 11:52:03 sumy dbmail/smtp[58595]: dbmysql.c,db_query: executing query [SELECT mailbox_idnr FROM mailboxes WHERE LOWER(name) = LOWER('INBOX') AND owner_idnr='1612'] Apr 27 11:52:03 sumy dbmail/smtp[58595]: db.c, db_find_create_mailbox: mailbox [INBOX] found Apr 27 11:52:03 sumy dbmail/smtp[58595]: dbmysql.c,db_query: executing query [INSERT INTO physmessage (messagesize, internal_date) VALUES ('0', CURRENT_TIMESTAMP)] Apr 27 11:52:03 sumy dbmail/smtp[58595]: dbmysql.c,db_query: executing query [INSERT INTO messages(mailbox_idnr, physmessage_id, unique_id,recent_flag, status) VALUES ('13392', '1769759', 'd578abea4d8ce1da1ab1a770434996dd', '1', '005')] Apr 27 11:52:03 sumy dbmail/smtp[58595]: dbmysql.c,db_query: executing query [SELECT physmessage_id FROM messages WHERE message_idnr = '1919865'] Apr 27 11:52:03 sumy dbmail/smtp[58595]: dbmysql.c,db_query: executing query [INSERT INTO messageblks(messageblk,blocksize, physmessage_id) VALUES ('ired=5.0 tests=BAYES_00 autolearn=ham \n version=2.63\nX-Spam-Level: \n\n\n\nRegards, Igor A. Olemskoi, [nix]\n\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\ Apr 27 11:52:03 sumy dbmail/smtp[58595]: store_message_temp(): allocating [524288] bytes of memory for readblock Apr 27 11:52:03 sumy dbmail/smtp[58595]: store_message_temp(): end of instream Apr 27 11:52:03 sumy dbmail/smtp[58595]: store_message_temp(): tmpline freed Apr 27 11:52:03 sumy dbmail/smtp[58595]: store_message_temp(): strblock freed Apr 27 11:52:03 sumy dbmail/smtp[58595]: dbmysql.c,db_query: executing query [UPDATE messages SET unique_id = 'd578abea4d8ce1da1ab1a770434996dd', status = '000' WHERE message_idnr = '1919865'] Apr 27 11:52:03 sumy dbmail/smtp[58595]: dbmysql.c,db_query: executing query [SELECT physmessage_id FROM messages WHERE message_idnr = '1919865'] Apr 27 11:52:03 sumy dbmail/smtp[58595]: dbmysql.c,db_query: executing query [UPDATE physmessage SET messagesize = '1128', rfcsize = '1156' WHERE id = '1769759'] Apr 27 11:52:03 sumy dbmail/smtp[58595]: dbmysql.c,db_query: executing query [SELECT mailboxes.owner_idnr FROM mailboxes, messages WHERE mailboxes.mailbox_idnr = messages.mailbox_idnr AND messages.message_idnr = '1919865'] Apr 27 11:52:03 sumy dbmail/smtp[58595]: db.c,db_add_quotum_used: adding 1128 to mailsize Apr 27 11:52:03 sumy dbmail/smtp[58595]: dbmysql.c,db_query: executing query [UPDATE users SET curmail_size = curmail_size + '1128' WHERE user_idnr = '1612'] Apr 27 11:52:03 sumy dbmail/smtp[58595]: pipe.c, insert_messages: temporary msgidnr is [1919865] Apr 27 11:52:03 sumy dbmail/smtp[58595]: pipe.c, insert_messages: calling sort_and_deliver for useridnr [1] Apr 27 11:52:03 sumy dbmail/smtp[58595]: GetConfigValue(): searching value for config item [SQLREGEX] Apr 27 11:52:03 sumy dbmail/smtp[58595]: GetConfigValue(): item not found Apr 27 11:52:03 sumy dbmail/smtp[58595]: GetConfigValue(): searching value for config item [LIBSIEVE] Apr 27 11:52:03 sumy dbmail/smtp[58595]: GetConfigValue(): item not found Apr 27 11:52:03 sumy dbmail/smtp[58595]: dbmysql.c,db_query: executing query [SELECT mailbox_idnr FROM mailboxes WHERE LOWER(name) = LOWER('INBOX') AND owner_idnr='1'] Apr 27 11:52:03 sumy dbmail/smtp[58595]: db.c, db_find_create_mailbox: mailbox [INBOX] found Apr 27 11:52:03 sumy dbmail/smtp[58595]: dbmysql.c,db_query: executing query [SELECT pm.messagesize FROM physmessage pm, messages msg WHERE pm.id = msg.physmessage_id AND message_idnr = '1919865'] Apr 27 11:52:03 sumy dbmail/smtp[58595]: dbmysql.c,db_query: executing query [SELECT 1 FROM users WHERE user_idnr = '1' AND (maxmail_size > 0) AND (curmail_size + '1128' > maxmail_size)] Apr 27 11:52:03 sumy dbmail/smtp[58595]: misc.c,create_unique_id: created: b307fde1f6b9fec9aa55efd766b74919 Apr 27 11:52:03 sumy dbmail/smtp[58595]: dbmysql.c,db_query: executing query [INSERT INTO messages (mailbox_idnr,physmessage_id, seen_flag, answered_flag, deleted_flag, flagged_flag, recent_flag, draft_flag, unique_id, status) SELECT '1', physmessage_id, seen_flag, answered_flag, deleted_flag, flagged_flag, recent_flag, draft_flag, 'b307fde1f6b9fec9aa55efd766b74919', status FROM messages WHERE message_idnr = '1919865'] Apr 27 11:52:03 sumy dbmail/smtp[58595]: db.c,db_add_quotum_used: adding 1128 to mailsize Apr 27 11:52:03 sumy dbmail/smtp[58595]: dbmysql.c,db_query: executing query [UPDATE users SET curmail_size = curmail_size + '1128' WHERE user_idnr = '1'] Apr 27 11:52:03 sumy dbmail/smtp[58595]: sort.c, sort_and_deliver: message id=1919866, size=1128 is inserted Apr 27 11:52:03 sumy dbmail/smtp[58595]: pipe.c, insert_messages: successful sort_and_deliver for useridnr [1] Apr 27 11:52:03 sumy dbmail/smtp[58595]: GetConfigValue(): searching value for config item [AUTO_NOTIFY] Apr 27 11:52:03 sumy dbmail/smtp[58595]: GetConfigValue(): found value [yes] Apr 27 11:52:03 sumy dbmail/smtp[58595]: GetConfigValue(): searching value for config item [AUTO_REPLY] Apr 27 11:52:03 sumy dbmail/smtp[58595]: GetConfigValue(): found value [yes] Apr 27 11:52:03 sumy dbmail/smtp[58595]: execute_auto_ran(): starting auto-notification procedure Apr 27 11:52:03 sumy dbmail/smtp[58595]: dbmysql.c,db_query: executing query [SELECT notify_address FROM auto_notifications WHERE user_idnr = 1] Apr 27 11:52:03 sumy dbmail/smtp[58595]: execute_auto_ran(): no notification address specified, skipping Apr 27 11:52:03 sumy dbmail/smtp[58595]: execute_auto_ran(): starting auto-reply procedure Apr 27 11:52:03 sumy dbmail/smtp[58595]: dbmysql.c,db_query: executing query [SELECT reply_body FROM auto_replies WHERE user_idnr = 1] Apr 27 11:52:03 sumy dbmail/smtp[58595]: execute_auto_ran(): no reply body specified, skipping Apr 27 11:52:03 sumy dbmail/smtp[58595]: insert_messages(): we need to deliver [0] messages to external addresses Apr 27 11:52:03 sumy dbmail/smtp[58595]: dbmysql.c,db_query: executing query [SELECT physmessage_id FROM messages WHERE message_idnr = '1919865'] Apr 27 11:52:03 sumy dbmail/smtp[58595]: dbmysql.c,db_query: executing query [DELETE FROM messages WHERE message_idnr = '1919865'] Apr 27 11:52:03 sumy dbmail/smtp[58595]: dbmysql.c,db_query: executing query [SELECT message_idnr FROM messages WHERE physmessage_id = '1769759'] Apr 27 11:52:03 sumy dbmail/smtp[58595]: insert_messages(): temporary message deleted from database Apr 27 11:52:03 sumy dbmail/smtp[58595]: insert_messages(): End of function Apr 27 11:52:03 sumy dbmail/smtp[58595]: main(): freeing dsnuser list Apr 27 11:52:03 sumy dbmail/smtp[58595]: dsn.c, dsnuser_free: dsnuser freed Apr 27 11:52:03 sumy dbmail/smtp[58595]: main(): freeing all other lists Apr 27 11:52:03 sumy dbmail/smtp[58595]: main(): freeing memory blocks Apr 27 11:52:03 sumy dbmail/smtp[58595]: main(): they're all free. we're done. Apr 27 11:52:03 sumy dbmail/smtp[58595]: dbmysql.c,db_free_result: Trying to free result set that is already NULL! Apr 27 11:52:03 sumy dbmail/smtp[58595]: main(): exit code is [0]. Apr 27 11:52:03 sumy postfix/pipe[58591]: 60B0A25F70D: to=<[EMAIL PROTECTED]>, relay=dbmail, delay=2, status=sent (sumy.biz) > On Tue, 2004-04-27 at 10:31, Igor Olemskoi wrote: > > Current dbmail-cvs doesn't work on freebsd 4.9 (I think after > switching > > from fgets to fread). > > Interesting.. > > Does it fail to build or fail to run. If it's the former: can you show > the output from 'make'? If it's the latter, can you show some log > output? > > Ilja > > > _______________________________________________ > Dbmail-dev mailing list > Dbmail-dev@dbmail.org > http://twister.fastxs.net/mailman/listinfo/dbmail-dev >