That is where I got stuck actually. After some tiring search, I got to know the user_idnr. But the mysql query:
"select * from dbmail_mailboxes where owner_idnr = 'xx';" returns "Empty set (0.00 sec)" which leads me to think that the mailbox has been deleted? By guessing the mailbox_idnr of the user (by looking at users before and after the deleted user's owner_idnr (xx-1 and xx+1; which returns sequential numbers from '456-465')); the query: "select * from dbmail_messages where mailbox_idnr = 'xx-guess';" too returns "Empty set (0.00 sec)". FYI, the dbmail-util hasn't been run yet, it is configured in crontab to run at 12am everyday. Is dbmail-users -d [username] deletes the mailbox and messages? That should not be the case right? Is there any way that I can confirm that? Any log files I can look through maybe? Thanx man. Sincerely, Daniel Daniel Urstöger wrote: > > Hi Daniel, > > well, let´s take a look, do you know which user id the user had you > deleted? > mailbox_idnr would actually be even better, but I guess you have no > clue about that, right? > > greetings, > Daniel > > -- View this message in context: http://www.nabble.com/URGENT%3A-Accidentally-delete-mail-user-with-dbmail-users--d-tp24568228p24569311.html Sent from the dbmail users mailing list archive at Nabble.com. _______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
