A little update is in order.
I managed to restore the database back. Had to delete all indexes and
constraints, then restore the data and after that restore the indexes
and constraints.
Now I run the 2.0.9 imapd and it connects and all, but sees 0 messages.
I know the messages are there and should be available since I can see
and read them thru dbmailadministrator.
Also if I copy a message from different account to the inbox, there's
still nothing shown on the client window. From DBMA I can see the mails
are actually there and are readable.
Does the migrate2.0_2.2 script make so that the database is then
unusable for 2.0 series?
Here's a trace5 when I click on Inbox. I should see 4 read messages. MUA
is Thunderbird.
-- clip --
Jan 2 03:02:17 vanessa dbmail/imap4d[22073]:
serverchild.c,PerformChildTask: incoming connection from
[222.228.208.238 (d238.FtokyoFL32.vectant.ne.jp)]
Jan 2 03:02:17 vanessa kernel: Jan 2 03:02:17 vanessa
dbmail/imap4d[22073]: serverchild.c,PerformChildTask: incoming
connection from [222.228.208.238 (d238.FtokyoFL32.vectant.ne.jp)]
Jan 2 03:02:17 vanessa dbmail/imap4d[22073]:
serverchild.c,PerformChildTask: client info init complete, calling
client handler
Jan 2 03:02:17 vanessa dbmail/imap4d[22073]: IMAPClientHandler(): line
read for PID 22073
Jan 2 03:02:17 vanessa dbmail/imap4d[22073]: COMMAND: [1 capability]
Jan 2 03:02:17 vanessa dbmail/imap4d[22073]: IMAPClientHandler():
Executing command capability...
Jan 2 03:02:17 vanessa dbmail/imap4d[22073]: IMAPClientHandler():
Finished command capability
Jan 2 03:02:17 vanessa dbmail/imap4d[22073]: IMAPClientHandler(): line
read for PID 22073
Jan 2 03:02:17 vanessa dbmail/imap4d[22073]: COMMAND: [2 authenticate
login]
Jan 2 03:02:17 vanessa dbmail/imap4d[22073]: arg[0]: 'login'
Jan 2 03:02:17 vanessa dbmail/imap4d[22073]: IMAPClientHandler():
Executing command authenticate...
Jan 2 03:02:17 vanessa dbmail/imap4d[22073]: dbpgsql.c,db_query:
executing query [SELECT user_idnr, passwd, encryption_type FROM
dbmail_users WHERE userid = 'sty']
Jan 2 03:02:17 vanessa dbmail/imap4d[22073]: authsql.c,auth_validate:
validating using crypt() encryption
Jan 2 03:02:17 vanessa dbmail/imap4d[22073]: dbpgsql.c,db_query:
executing query [UPDATE dbmail_users SET last_login = '2007-01-02
03:02:17' WHERE user_idnr = '3']
Jan 2 03:02:17 vanessa dbmail/imap4d[22073]: dbpgsql.c,db_query:
executing query [SELECT idnr FROM dbmail_pbsp WHERE ipnumber =
'222.228.208.238']
Jan 2 03:02:17 vanessa dbmail/imap4d[22073]: dbpgsql.c,db_query:
executing query [UPDATE dbmail_pbsp SET since = CURRENT_TIMESTAMP WHERE
idnr='949']
Jan 2 03:02:17 vanessa dbmail/imap4d[22073]: db.c,db_log_ip: ip
[222.228.208.238] logged
Jan 2 03:02:17 vanessa dbmail/imap4d[22073]: IMAPD [PID 22073]: user
(id 3, name sty) login accepted @ 2007-01-02 03:02:17
Jan 2 03:02:17 vanessa kernel: Jan 2 03:02:17 vanessa
dbmail/imap4d[22073]: IMAPD [PID 22073]: user (id 3, name sty) login
accepted @ 2007-01-02 03:02:17
Jan 2 03:02:17 vanessa dbmail/imap4d[22073]: IMAPClientHandler():
Finished command authenticate
Jan 2 03:02:17 vanessa dbmail/imap4d[22073]: IMAPClientHandler(): line
read for PID 22073
Jan 2 03:02:17 vanessa dbmail/imap4d[22073]: COMMAND: [3 select "INBOX"]
Jan 2 03:02:17 vanessa dbmail/imap4d[22073]: arg[0]: 'INBOX'
Jan 2 03:02:17 vanessa dbmail/imap4d[22073]: IMAPClientHandler():
Executing command select...
Jan 2 03:02:17 vanessa dbmail/imap4d[22073]: db.c,db_findmailbox:
looking for mailbox with FQN [INBOX].
Jan 2 03:02:17 vanessa dbmail/imap4d[22073]: dbpgsql.c,db_query:
executing query [SELECT mailbox_idnr FROM dbmail_mailboxes WHERE
name='INBOX' AND owner_idnr='3']
Jan 2 03:02:17 vanessa dbmail/imap4d[22073]: db.c,db_acl_has_right:
checking ACL for user [3] on mailbox [1]
Jan 2 03:02:17 vanessa dbmail/imap4d[22073]: dbpgsql.c,db_query:
executing query [SELECT mailbox_idnr FROM dbmail_mailboxes WHERE
mailbox_idnr = '1' AND owner_idnr = '3']
Jan 2 03:02:17 vanessa dbmail/imap4d[22073]: dbpgsql.c,db_query:
executing query [SELECT no_select FROM dbmail_mailboxes WHERE
mailbox_idnr = '1']
Jan 2 03:02:17 vanessa dbmail/imap4d[22073]: dbpgsql.c,db_query:
executing query [SELECT
permission,seen_flag,answered_flag,deleted_flag,flagged_flag,recent_flag,draft_flag
FROM dbmail_mailboxes WHERE mailbox_idnr = '1']
Jan 2 03:02:17 vanessa dbmail/imap4d[22073]: dbpgsql.c,db_query:
executing query [SELECT 'a',COUNT(*) FROM dbmail_messages WHERE
mailbox_idnr='1' AND (status='0' OR status='1') UNION SELECT
'b',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='1' AND (status='0'
OR status='1') AND seen_flag=1 UNION SELECT 'c',COUNT(*) FROM
dbmail_messages WHERE mailbox_idnr='1' AND (status='0' OR status='1')
AND recent_flag=1]
Jan 2 03:02:17 vanessa dbmail/imap4d[22073]: dbpgsql.c,db_query:
executing query [SELECT message_idnr FROM dbmail_messages WHERE
mailbox_idnr = '1' AND status < '2' ORDER BY message_idnr ASC]
Jan 2 03:02:17 vanessa dbmail/imap4d[22073]: dbpgsql.c,db_query:
executing query [SELECT message_idnr + 1 FROM dbmail_messages ORDER BY
message_idnr DESC LIMIT 1]
Jan 2 03:02:17 vanessa dbmail/imap4d[22073]: dbpgsql.c,db_query:
executing query [SELECT MIN(message_idnr) FROM dbmail_messages WHERE
mailbox_idnr = '1' AND status < '2' AND seen_flag = '0']
Jan 2 03:02:17 vanessa dbmail/imap4d[22073]: IMAPClientHandler():
Finished command select
Jan 2 03:02:17 vanessa dbmail/imap4d[22073]: dbpgsql.c,db_query:
executing query [SELECT
permission,seen_flag,answered_flag,deleted_flag,flagged_flag,recent_flag,draft_flag
FROM dbmail_mailboxes WHERE mailbox_idnr = '1']
Jan 2 03:02:17 vanessa dbmail/imap4d[22073]: dbpgsql.c,db_query:
executing query [SELECT 'a',COUNT(*) FROM dbmail_messages WHERE
mailbox_idnr='1' AND (status='0' OR status='1') UNION SELECT
'b',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='1' AND (status='0'
OR status='1') AND seen_flag=1 UNION SELECT 'c',COUNT(*) FROM
dbmail_messages WHERE mailbox_idnr='1' AND (status='0' OR status='1')
AND recent_flag=1]
Jan 2 03:02:17 vanessa dbmail/imap4d[22073]: dbpgsql.c,db_query:
executing query [SELECT message_idnr FROM dbmail_messages WHERE
mailbox_idnr = '1' AND status < '2' ORDER BY message_idnr ASC]
Jan 2 03:02:17 vanessa dbmail/imap4d[22073]: dbpgsql.c,db_query:
executing query [SELECT message_idnr + 1 FROM dbmail_messages ORDER BY
message_idnr DESC LIMIT 1]
Jan 2 03:02:17 vanessa dbmail/imap4d[22073]: IMAPClientHandler(): line
read for PID 22073
Jan 2 03:02:17 vanessa dbmail/imap4d[22073]: COMMAND: [4 getquotaroot
"INBOX"]
Jan 2 03:02:17 vanessa dbmail/imap4d[22073]: arg[0]: 'INBOX'
Jan 2 03:02:17 vanessa dbmail/imap4d[22073]: IMAPClientHandler():
Executing command getquotaroot...
Jan 2 03:02:17 vanessa dbmail/imap4d[22073]: db.c,db_findmailbox:
looking for mailbox with FQN [INBOX].
Jan 2 03:02:17 vanessa dbmail/imap4d[22073]: dbpgsql.c,db_query:
executing query [SELECT mailbox_idnr FROM dbmail_mailboxes WHERE
name='INBOX' AND owner_idnr='3']
Jan 2 03:02:17 vanessa dbmail/imap4d[22073]: dbpgsql.c,db_query:
executing query [SELECT maxmail_size FROM dbmail_users WHERE user_idnr =
'3']
Jan 2 03:02:17 vanessa dbmail/imap4d[22073]: dbpgsql.c,db_query:
executing query [SELECT curmail_size FROM dbmail_users WHERE user_idnr =
'3']
Jan 2 03:02:17 vanessa dbmail/imap4d[22073]: IMAPClientHandler():
Finished command getquotaroot
Jan 2 03:02:17 vanessa dbmail/imap4d[22073]: IMAPClientHandler(): line
read for PID 22073
Jan 2 03:02:17 vanessa dbmail/imap4d[22073]: COMMAND: [5 UID fetch 1:*
(FLAGS)]
Jan 2 03:02:17 vanessa dbmail/imap4d[22073]: arg[0]: 'fetch'
Jan 2 03:02:17 vanessa dbmail/imap4d[22073]: arg[1]: '1:*'
Jan 2 03:02:17 vanessa dbmail/imap4d[22073]: arg[2]: '('
Jan 2 03:02:17 vanessa dbmail/imap4d[22073]: arg[3]: 'FLAGS'
Jan 2 03:02:17 vanessa dbmail/imap4d[22073]: arg[4]: ')'
Jan 2 03:02:17 vanessa dbmail/imap4d[22073]: IMAPClientHandler():
Executing command uid...
Jan 2 03:02:17 vanessa dbmail/imap4d[22073]: db.c,db_acl_has_right:
checking ACL for user [3] on mailbox [1]
Jan 2 03:02:17 vanessa dbmail/imap4d[22073]: dbpgsql.c,db_query:
executing query [SELECT mailbox_idnr FROM dbmail_mailboxes WHERE
mailbox_idnr = '1' AND owner_idnr = '3']
Jan 2 03:02:17 vanessa dbmail/imap4d[22073]: next_fetch_item():
args[idx = 2] = FLAGS (returning 3)
Jan 2 03:02:17 vanessa dbmail/imap4d[22073]: dbpgsql.c,db_query:
executing query [SELECT seen_flag, answered_flag, deleted_flag,
flagged_flag, draft_flag, recent_flag, TO_CHAR(internal_date,
'YYYY-MM-DD HH24:MI:SS' ), rfcsize, message_idnr FROM dbmail_messages
msg, dbmail_physmessage pm WHERE pm.id = msg.physmessage_id AND
message_idnr BETWEEN '1' AND '114514' AND mailbox_idnr = '1' AND status
< '2' ORDER BY message_idnr ASC]
Jan 2 03:02:17 vanessa dbmail/imap4d[22073]: ic_fetch(): no parsing at all
Jan 2 03:02:17 vanessa dbmail/imap4d[22073]: _ic_fetch(): no parsing,
into fetch loop
Jan 2 03:02:17 vanessa last message repeated 7 times
Jan 2 03:02:17 vanessa dbmail/imap4d[22073]: IMAPClientHandler():
Finished command uid
Jan 2 03:02:18 vanessa dbmail/imap4d[22073]: IMAPClientHandler(): line
read for PID 22073
Jan 2 03:02:18 vanessa dbmail/imap4d[22073]: COMMAND: [6 UID fetch
109005:114514 (UID RFC822.SIZE FLAGS BODY.PEEK[HEADER.FIELDS (From To Cc
Subject Date Message-ID Priority X-Priority References Newsgroups
In-Reply-To Content-Type)])]
Jan 2 03:02:18 vanessa dbmail/imap4d[22073]: arg[0]: 'fetch'
Jan 2 03:02:18 vanessa dbmail/imap4d[22073]: arg[1]: '109005:114514'
Jan 2 03:02:18 vanessa dbmail/imap4d[22073]: arg[2]: '('
Jan 2 03:02:18 vanessa dbmail/imap4d[22073]: arg[3]: 'UID'
Jan 2 03:02:18 vanessa dbmail/imap4d[22073]: arg[4]: 'RFC822.SIZE'
Jan 2 03:02:18 vanessa dbmail/imap4d[22073]: arg[5]: 'FLAGS'
Jan 2 03:02:18 vanessa dbmail/imap4d[22073]: arg[6]: 'BODY.PEEK'
Jan 2 03:02:18 vanessa dbmail/imap4d[22073]: arg[7]: '['
Jan 2 03:02:18 vanessa dbmail/imap4d[22073]: arg[8]: 'HEADER.FIELDS'
Jan 2 03:02:18 vanessa dbmail/imap4d[22073]: arg[9]: '('
Jan 2 03:02:18 vanessa dbmail/imap4d[22073]: arg[10]: 'From'
Jan 2 03:02:18 vanessa dbmail/imap4d[22073]: arg[11]: 'To'
Jan 2 03:02:18 vanessa dbmail/imap4d[22073]: arg[12]: 'Cc'
Jan 2 03:02:18 vanessa dbmail/imap4d[22073]: arg[13]: 'Subject'
Jan 2 03:02:18 vanessa dbmail/imap4d[22073]: arg[14]: 'Date'
Jan 2 03:02:18 vanessa dbmail/imap4d[22073]: arg[15]: 'Message-ID'
Jan 2 03:02:18 vanessa dbmail/imap4d[22073]: arg[16]: 'Priority'
Jan 2 03:02:18 vanessa dbmail/imap4d[22073]: arg[17]: 'X-Priority'
Jan 2 03:02:18 vanessa dbmail/imap4d[22073]: arg[18]: 'References'
Jan 2 03:02:18 vanessa dbmail/imap4d[22073]: arg[19]: 'Newsgroups'
Jan 2 03:02:18 vanessa dbmail/imap4d[22073]: arg[20]: 'In-Reply-To'
Jan 2 03:02:18 vanessa dbmail/imap4d[22073]: arg[21]: 'Content-Type'
Jan 2 03:02:18 vanessa dbmail/imap4d[22073]: arg[22]: ')'
Jan 2 03:02:18 vanessa dbmail/imap4d[22073]: arg[23]: ']'
Jan 2 03:02:18 vanessa dbmail/imap4d[22073]: arg[24]: ')'
Jan 2 03:02:18 vanessa dbmail/imap4d[22073]: IMAPClientHandler():
Executing command uid...
Jan 2 03:02:18 vanessa dbmail/imap4d[22073]: db.c,db_acl_has_right:
checking ACL for user [3] on mailbox [1]
Jan 2 03:02:18 vanessa dbmail/imap4d[22073]: dbpgsql.c,db_query:
executing query [SELECT mailbox_idnr FROM dbmail_mailboxes WHERE
mailbox_idnr = '1' AND owner_idnr = '3']
Jan 2 03:02:18 vanessa dbmail/imap4d[22073]: next_fetch_item():
args[idx = 2] = UID (returning 3)
Jan 2 03:02:18 vanessa dbmail/imap4d[22073]: next_fetch_item():
args[idx = 3] = RFC822.SIZE (returning 4)
Jan 2 03:02:18 vanessa dbmail/imap4d[22073]: next_fetch_item():
args[idx = 4] = FLAGS (returning 5)
Jan 2 03:02:18 vanessa dbmail/imap4d[22073]: next_fetch_item():
args[idx = 22] = ] (returning 23)
Jan 2 03:02:18 vanessa dbmail/imap4d[22073]: dbpgsql.c,db_query:
executing query [SELECT seen_flag, answered_flag, deleted_flag,
flagged_flag, draft_flag, recent_flag, TO_CHAR(internal_date,
'YYYY-MM-DD HH24:MI:SS' ), rfcsize, message_idnr FROM dbmail_messages
msg, dbmail_physmessage pm WHERE pm.id = msg.physmessage_id AND
message_idnr BETWEEN '109005' AND '114514' AND mailbox_idnr = '1' AND
status < '2' ORDER BY message_idnr ASC]
Jan 2 03:02:18 vanessa dbmail/imap4d[22073]: Fetching msgID 109005
(fetch num 109006)
Jan 2 03:02:18 vanessa dbmail/imap4d[22073]: dbpgsql.c,db_query:
executing query [SELECT messageblk FROM dbmail_messageblks blk,
dbmail_messages msg WHERE blk.physmessage_id = msg.physmessage_id AND
msg.message_idnr = '109005' ORDER BY blk.messageblk_idnr ASC LIMIT 1]
Jan 2 03:02:18 vanessa dbmail/imap4d[22073]: mime_readheader():
entering mime loop
Jan 2 03:02:18 vanessa dbmail/imap4d[22073]: Fetching msgID 109130
(fetch num 109131)
Jan 2 03:02:18 vanessa dbmail/imap4d[22073]: dbpgsql.c,db_query:
executing query [SELECT messageblk FROM dbmail_messageblks blk,
dbmail_messages msg WHERE blk.physmessage_id = msg.physmessage_id AND
msg.message_idnr = '109130' ORDER BY blk.messageblk_idnr ASC LIMIT 1]
Jan 2 03:02:18 vanessa dbmail/imap4d[22073]: mime_readheader():
entering mime loop
Jan 2 03:02:18 vanessa dbmail/imap4d[22073]: Fetching msgID 114513
(fetch num 114514)
Jan 2 03:02:18 vanessa dbmail/imap4d[22073]: dbpgsql.c,db_query:
executing query [SELECT messageblk FROM dbmail_messageblks blk,
dbmail_messages msg WHERE blk.physmessage_id = msg.physmessage_id AND
msg.message_idnr = '114513' ORDER BY blk.messageblk_idnr ASC LIMIT 1]
Jan 2 03:02:18 vanessa dbmail/imap4d[22073]: mime_readheader():
entering mime loop
Jan 2 03:02:18 vanessa dbmail/imap4d[22073]: mime_readheader(): found
double newline; header size: 21 lines
Jan 2 03:02:18 vanessa dbmail/imap4d[22073]: Fetching msgID 114514
(fetch num 114515)
Jan 2 03:02:18 vanessa dbmail/imap4d[22073]: dbpgsql.c,db_query:
executing query [SELECT messageblk FROM dbmail_messageblks blk,
dbmail_messages msg WHERE blk.physmessage_id = msg.physmessage_id AND
msg.message_idnr = '114514' ORDER BY blk.messageblk_idnr ASC LIMIT 1]
Jan 2 03:02:18 vanessa dbmail/imap4d[22073]: mime_readheader():
entering mime loop
Jan 2 03:02:18 vanessa dbmail/imap4d[22073]: mime_readheader(): found
double newline; header size: 21 lines
Jan 2 03:02:18 vanessa dbmail/imap4d[22073]: IMAPClientHandler():
Finished command uid
Jan 2 03:02:18 vanessa dbmail/imap4d[22073]: IMAPClientHandler(): line
read for PID 22073
Jan 2 03:02:18 vanessa dbmail/imap4d[22073]: COMMAND: [7 logout]
Jan 2 03:02:18 vanessa dbmail/imap4d[22073]: IMAPClientHandler():
Executing command logout...
Jan 2 03:02:18 vanessa dbmail/imap4d[22073]: _ic_logout(): user (id:3)
logging out @ [2007-01-02 03:02:18]
Jan 2 03:02:18 vanessa kernel: Jan 2 03:02:18 vanessa
dbmail/imap4d[22073]: _ic_logout(): user (id:3) logging out @
[2007-01-02 03:02:18]
Jan 2 03:02:18 vanessa dbmail/imap4d[22073]: IMAPClientHandler():
Finished command logout
Jan 2 03:02:18 vanessa dbmail/imap4d[22073]: IMAPClientHandler():
Closing connection for client from IP [222.228.208.238]
Jan 2 03:02:18 vanessa kernel: Jan 2 03:02:18 vanessa
dbmail/imap4d[22073]: IMAPClientHandler(): Closing connection for client
from IP [222.228.208.238]
Jan 2 03:02:18 vanessa dbmail/imap4d[22073]:
serverchild.c,PerformChildTask: client handling complete, closing streams
Jan 2 03:02:18 vanessa dbmail/imap4d[22073]:
serverchild.c,client_close: closing write stream
Jan 2 03:02:18 vanessa dbmail/imap4d[22073]:
serverchild.c,client_close: closing read stream
Jan 2 03:02:18 vanessa dbmail/imap4d[22073]:
serverchild.c,PerformChildTask: connection closed
Jan 2 03:02:18 vanessa dbmail/imap4d[22073]:
serverchild.c,PerformChildTask: waiting for connection
-- clip --
--
br,
Tommi
_______________________________________________
DBmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
