Hello,
if I try to delete some emails in my inbox (via thunderbird or outlook),
no-one email is really deleted.
Deleted email is in Thunderbird invisible, in Outlook is marked as
deleted (could be restored). But isn't way how to delete email directly
along with releasing space in INBOX.
Problem is somewhere around status column in dbmail_messages. Status
still reamain at 0 value (before and after delete) instead of value 2.
Because of false status value, "dbmail-util -pdy" doesn't work corretly.
Thanx for any help.
before:
mysql> select * from dbmail_messages;
+--------------+--------------+----------------+-----------+---------------+--------------+--------------+-------------+------------+----------------------------------+--------+
| message_idnr | mailbox_idnr | physmessage_id | seen_flag |
answered_flag | deleted_flag | flagged_flag | recent_flag | draft_flag |
unique_id | status |
+--------------+--------------+----------------+-----------+---------------+--------------+--------------+-------------+------------+----------------------------------+--------+
| 14 | 3 | 4 | 0 |
0 | 0 | 0 | 0 | 0 |
e9c4788f7304e783a2c30de2cd5f920d | 0 |
| 13 | 1 | 5 | 0 |
0 | 0 | 0 | 0 | 0 |
6dda9ad41e822c3f77de5a7553663bde | 0 |
+--------------+--------------+----------------+-----------+---------------+--------------+--------------+-------------+------------+----------------------------------+--------+
after:
mysql> select * from dbmail_messages;
+--------------+--------------+----------------+-----------+---------------+--------------+--------------+-------------+------------+----------------------------------+--------+
| message_idnr | mailbox_idnr | physmessage_id | seen_flag |
answered_flag | deleted_flag | flagged_flag | recent_flag | draft_flag |
unique_id | status |
+--------------+--------------+----------------+-----------+---------------+--------------+--------------+-------------+------------+----------------------------------+--------+
| 14 | 3 | 4 | 1 |
0 | 1 | 0 | 0 | 0 |
e9c4788f7304e783a2c30de2cd5f920d | 0 |
| 13 | 1 | 5 | 1 |
0 | 1 | 0 | 0 | 0 |
6dda9ad41e822c3f77de5a7553663bde | 0 |
+--------------+--------------+----------------+-----------+---------------+--------------+--------------+-------------+------------+----------------------------------+--------+
4 rows in set (0.00 sec)
output of dbmail-util -pdy:
Jun 09 02:52:09 kn.vutbr.net dbmail-util[12446]: Debug:[db]
dbmodule.c,db_load_driver(+53): no value for library_directory, using
default [/usr/local/lib/dbmail]
Jun 09 02:52:09 kn.vutbr.net dbmail-util[12446]: Debug:[db]
dbmodule.c,db_load_driver(+69): looking for mysql as
/usr/local/lib/dbmail/libmysql.so
Jun 09 02:52:09 kn.vutbr.net dbmail-util[12446]: Debug:[sql]
dbmysql.c,db_query(+287): query [SET NAMES utf8]
Jun 09 02:52:09 kn.vutbr.net dbmail-util[12446]: Debug:[db]
dbmodule.c,db_query(+145): last query took [0] seconds
Jun 09 02:52:09 kn.vutbr.net dbmail-util[12446]: Debug:[sql]
dbmysql.c,db_query(+287): query [SHOW VARIABLES LIKE 'collation_%']
Jun 09 02:52:09 kn.vutbr.net dbmail-util[12446]: Debug:[db]
dbmodule.c,db_query(+145): last query took [0] seconds
Jun 09 02:52:09 kn.vutbr.net dbmail-util[12446]: Debug:[sql]
dbmysql.c,db_mysql_check_collations(+121): does
[collation_database:utf8_general_ci] match
[collation_connection:utf8_general_ci]?
Jun 09 02:52:09 kn.vutbr.net dbmail-util[12446]: Debug:[auth]
authmodule.c,auth_load_driver(+48): no value for library_directory,
using default [/usr/local/lib/dbmail]
Jun 09 02:52:09 kn.vutbr.net dbmail-util[12446]: Debug:[auth]
authmodule.c,auth_load_driver(+64): looking for auth_sql as
/usr/local/lib/dbmail/libauth_sql.so
Deleting messages with DELETE status...
Jun 09 02:52:09 kn.vutbr.net dbmail-util[12446]: Debug:[db]
db.c,db_deleted_purge(+2475): executing query [SELECT message_idnr FROM
dbmail_messages WHERE status=3]
Jun 09 02:52:09 kn.vutbr.net dbmail-util[12446]: Debug:[sql]
dbmysql.c,db_query(+287): query [SELECT message_idnr FROM
dbmail_messages WHERE status=3]
Jun 09 02:52:09 kn.vutbr.net dbmail-util[12446]: Debug:[db]
dbmodule.c,db_query(+145): last query took [0] seconds
Jun 09 02:52:09 kn.vutbr.net dbmail-util[12446]: Debug:[db]
db.c,db_deleted_purge(+2484): no messages to purge
Ok. [0] messages deleted.
Setting DELETE status for deleted messages...
Jun 09 02:52:09 kn.vutbr.net dbmail-util[12446]: Debug:[sql]
dbmysql.c,db_query(+287): query [UPDATE dbmail_messages SET status = 3
WHERE status = 2]
Jun 09 02:52:09 kn.vutbr.net dbmail-util[12446]: Debug:[db]
dbmodule.c,db_query(+145): last query took [0] seconds
Ok. [2] messages set for deletion.
Re-calculating used quota for all users...
Jun 09 02:52:09 kn.vutbr.net dbmail-util[12446]: Debug:[sql]
dbmysql.c,db_query(+287): query [SELECT usr.user_idnr,
sum(pm.messagesize), usr.curmail_size FROM dbmail_users usr LEFT JOIN
dbmail_mailboxes mbx ON mbx.owner_idnr = usr.user_idnr LEFT JOIN
dbmail_messages msg ON msg.mailbox_idnr = mbx.mailbox_idnr LEFT JOIN
dbmail_physmessage pm ON pm.id = msg.physmessage_id AND msg.status < 2
GROUP BY usr.user_idnr, usr.curmail_size HAVING ((SUM(pm.messagesize) <>
usr.curmail_size) OR (NOT (SUM(pm.messagesize) IS NOT NULL) AND
usr.curmail_size <> 0))]
Jun 09 02:52:09 kn.vutbr.net dbmail-util[12446]: Debug:[db]
dbmodule.c,db_query(+145): last query took [0] seconds
Jun 09 02:52:09 kn.vutbr.net dbmail-util[12446]: Debug:[db]
db.c,db_calculate_quotum_all(+525): quotum is already up to date
Ok. Used quota updated for all users.
Maintenance done. No errors found.
I am using:
freebsd 6.3 + sendmail
dbmail-2.2.10
mysql-server-5.0.51a
thunderbird 2.0.0.14 (20080421)
outlook exprees 6
Pavel Kislinger
_______________________________________________
DBmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
