Howdy Paul, On my test machine, there's a SQLExeption when running dbmail-util.
Attached there's a 511 log for you. Jorge,
Jul 10 10:45:01 flecha dbmail/maintenance[7954]: [0x8970b08] Database:[db] db_connect(+191): db at url: [mysql://127.0.0.1/dbmail?user=user&password=200901&charset=utf8&unix-socket=/var/run/mysqld/my Jul 10 10:45:01 flecha dbmail/maintenance[7954]: [0x8970b08] Database:[db] db_connect(+207): run a database connection reaper thread every [60] seconds Jul 10 10:45:01 flecha dbmail/maintenance[7954]: [0x8970b08] Database:[db] db_connect(+211): database connection pool started with [5] connections, max [20] Jul 10 10:45:01 flecha dbmail/maintenance[7954]: [0x8970b08] Database:[db] db_con_close(+275): [0x8973278] connection to pool Jul 10 10:45:01 flecha dbmail/maintenance[7954]: [0x8970b08] Debug:[auth] auth_load_driver(+48): no value for library_directory, using default [] Jul 10 10:45:01 flecha dbmail/maintenance[7954]: [0x8970b08] Debug:[auth] auth_load_driver(+64): looking for auth_sql as libauth_sql.so Jul 10 10:45:01 flecha dbmail/maintenance[7954]: [0x8970b08] Database:[db] db_con_get(+257): [0x8973278] connection from pool Jul 10 10:45:01 flecha dbmail/maintenance[7954]: [0x8970b08] Database:[db] db_exec(+312): [0x8973278] [UPDATE dbmail_messages SET status = 3 WHERE status = 2] Jul 10 10:45:01 flecha dbmail/maintenance[7954]: [0x8970b08] Database:[db] log_query_time(+290): last query took [0.000] seconds Jul 10 10:45:01 flecha dbmail/maintenance[7954]: [0x8970b08] Database:[db] db_con_close(+275): [0x8973278] connection to pool Jul 10 10:45:01 flecha dbmail/maintenance[7954]: [0x8970b08] Database:[db] db_con_get(+257): [0x8973278] connection from pool Jul 10 10:45:01 flecha dbmail/maintenance[7954]: [0x8970b08] Database:[db] db_query(+344): [0x8973278] [SELECT usr.user_idnr, SUM(pm.messagesize), usr.curmail_size FROM dbmail_users usr LEFT JOIN dbmail_mailboxe Jul 10 10:45:01 flecha dbmail/maintenance[7954]: [0x8970b08] Database:[db] log_query_time(+290): last query took [0.001] seconds Jul 10 10:45:01 flecha dbmail/maintenance[7954]: [0x8970b08] Database:[db] db_con_close(+275): [0x8973278] connection to pool Jul 10 10:45:01 flecha dbmail/maintenance[7954]: [0x8970b08] Debug:[db] dm_quota_rebuild(+973): quotum is already up to date Jul 10 10:45:01 flecha dbmail/maintenance[7963]: [0x8582b08] Database:[db] db_connect(+191): db at url: [mysql://127.0.0.1/dbmail?user=user&password=200901&charset=utf8&unix-socket=/var/run/mysqld/my Jul 10 10:45:01 flecha dbmail/maintenance[7963]: [0x8582b08] Database:[db] db_connect(+207): run a database connection reaper thread every [60] seconds Jul 10 10:45:01 flecha dbmail/maintenance[7963]: [0x8582b08] Database:[db] db_connect(+211): database connection pool started with [5] connections, max [20] Jul 10 10:45:01 flecha dbmail/maintenance[7963]: [0x8582b08] Database:[db] db_con_close(+275): [0x8585278] connection to pool Jul 10 10:45:01 flecha dbmail/maintenance[7963]: [0x8582b08] Debug:[auth] auth_load_driver(+48): no value for library_directory, using default [] Jul 10 10:45:01 flecha dbmail/maintenance[7963]: [0x8582b08] Debug:[auth] auth_load_driver(+64): looking for auth_sql as libauth_sql.so Jul 10 10:45:01 flecha dbmail/maintenance[7963]: [0x8582b08] Database:[db] db_con_get(+257): [0x8585278] connection from pool Jul 10 10:45:01 flecha dbmail/maintenance[7963]: [0x8582b08] Database:[db] db_exec(+312): [0x8585278] [DELETE FROM dbmail_messages WHERE status=3] Jul 10 10:45:01 flecha dbmail/maintenance[7963]: [0x8582b08] Database:[db] log_query_time(+290): last query took [0.000] seconds Jul 10 10:45:01 flecha dbmail/maintenance[7963]: [0x8582b08] Database:[db] db_con_close(+275): [0x8585278] connection to pool Jul 10 10:45:01 flecha dbmail/maintenance[7965]: [0x981fb08] Database:[db] db_connect(+191): db at url: [mysql://127.0.0.1/dbmail?user=user&password=200901&charset=utf8&unix-socket=/var/run/mysqld/my Jul 10 10:45:01 flecha dbmail/maintenance[7965]: [0x981fb08] Database:[db] db_connect(+207): run a database connection reaper thread every [60] seconds Jul 10 10:45:01 flecha dbmail/maintenance[7965]: [0x981fb08] Database:[db] db_connect(+211): database connection pool started with [5] connections, max [20] Jul 10 10:45:01 flecha dbmail/maintenance[7965]: [0x981fb08] Database:[db] db_con_close(+275): [0x9822278] connection to pool Jul 10 10:45:01 flecha dbmail/maintenance[7965]: [0x981fb08] Debug:[auth] auth_load_driver(+48): no value for library_directory, using default [] Jul 10 10:45:01 flecha dbmail/maintenance[7965]: [0x981fb08] Debug:[auth] auth_load_driver(+64): looking for auth_sql as libauth_sql.so Jul 10 10:45:01 flecha dbmail/maintenance[7965]: [0x981fb08] Database:[db] db_con_get(+257): [0x9822278] connection from pool Jul 10 10:45:01 flecha dbmail/maintenance[7965]: [0x981fb08] Database:[db] db_query(+344): [0x9822278] [SELECT mb.messageblk_idnr FROM dbmail_messageblks mb LEFT JOIN dbmail_physmessage pm ON mb.physmessage_id = Jul 10 10:45:01 flecha dbmail/maintenance[7965]: [0x981fb08] Error:[db] db_query(+351): SQLException: Jul 10 10:45:01 flecha dbmail/maintenance[7965]: [0x981fb08] Error:[db] db_query(+352): failed query [SELECT mb.messageblk_idnr FROM dbmail_messageblks mb LEFT JOIN dbmail_physmessage pm ON mb.physmessage_id Jul 10 10:45:01 flecha dbmail/maintenance[7965]: [0x981fb08] Database:[db] db_con_close(+275): [0x9822278] connection to pool Jul 10 10:45:01 flecha dbmail/maintenance[7965]: [0x981fb08] Debug:[db] db_icheck_messageblks(+1193): no lost messageblocks Jul 10 10:45:01 flecha dbmail/maintenance[7965]: [0x981fb08] Database:[db] db_con_get(+257): [0x9822278] connection from pool Jul 10 10:45:01 flecha dbmail/maintenance[7965]: [0x981fb08] Database:[db] db_query(+344): [0x9822278] [SELECT COUNT(*) FROM dbmail_physmessage p LEFT JOIN dbmail_messages m ON p.id = m.physmessage_id WHERE m.me Jul 10 10:45:01 flecha dbmail/maintenance[7965]: [0x981fb08] Database:[db] log_query_time(+290): last query took [0.001] seconds Jul 10 10:45:01 flecha dbmail/maintenance[7965]: [0x981fb08] Database:[db] db_con_close(+275): [0x9822278] connection to pool Jul 10 10:45:01 flecha dbmail/maintenance[7965]: [0x981fb08] Database:[db] db_con_get(+257): [0x9822278] connection from pool Jul 10 10:45:01 flecha dbmail/maintenance[7965]: [0x981fb08] Database:[db] db_query(+344): [0x9822278] [SELECT COUNT(*) FROM dbmail_mimeparts p LEFT JOIN dbmail_partlists l ON p.id = l.part_id WHERE l.physmessag Jul 10 10:45:01 flecha dbmail/maintenance[7965]: [0x981fb08] Database:[db] log_query_time(+290): last query took [0.001] seconds Jul 10 10:45:01 flecha dbmail/maintenance[7965]: [0x981fb08] Database:[db] db_con_close(+275): [0x9822278] connection to pool Jul 10 10:45:01 flecha dbmail/maintenance[7965]: [0x981fb08] Database:[db] db_con_get(+257): [0x9822278] connection from pool Jul 10 10:45:01 flecha dbmail/maintenance[7965]: [0x981fb08] Database:[db] db_query(+344): [0x9822278] [SELECT msg.message_idnr FROM dbmail_messages msg LEFT JOIN dbmail_mailboxes mbx ON msg.mailbox_idnr=mbx.mai Jul 10 10:45:01 flecha dbmail/maintenance[7965]: [0x981fb08] Database:[db] log_query_time(+290): last query took [0.001] seconds Jul 10 10:45:01 flecha dbmail/maintenance[7965]: [0x981fb08] Database:[db] db_con_close(+275): [0x9822278] connection to pool Jul 10 10:45:01 flecha dbmail/maintenance[7965]: [0x981fb08] Debug:[db] db_icheck_messages(+1277): no lost messages Jul 10 10:45:01 flecha dbmail/maintenance[7965]: [0x981fb08] Database:[db] db_con_get(+257): [0x9822278] connection from pool Jul 10 10:45:01 flecha dbmail/maintenance[7965]: [0x981fb08] Database:[db] db_query(+344): [0x9822278] [SELECT mbx.mailbox_idnr FROM dbmail_mailboxes mbx LEFT JOIN dbmail_users usr ON mbx.owner_idnr=usr.user_idn Jul 10 10:45:01 flecha dbmail/maintenance[7965]: [0x981fb08] Database:[db] log_query_time(+290): last query took [0.000] seconds Jul 10 10:45:01 flecha dbmail/maintenance[7965]: [0x981fb08] Database:[db] db_con_close(+275): [0x9822278] connection to pool Jul 10 10:45:01 flecha dbmail/maintenance[7965]: [0x981fb08] Debug:[db] db_icheck_mailboxes(+1307): no lost mailboxes
_______________________________________________ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev
