How do I delete a user mailbox?

[gehenna]

Hi there,

I recently deployed Sugar Open Source in my office. I know very little about the software but it was requested by the higher ups so i had to install it for them. Now the task of supporting it falls to me, and as I said - i know very little about it.

I added mail details for one of the users. I allowed him access to his Exchange mailbox via POP. I tested this on my own mailbox and it worked fine with my details. I then added his mail details and proceeded to download his mailbox via POP. Unfortunately I did not notice that he has over 6000 emails in his Exchange mailbox. Sugar proceeded to download all these emails to his account.

Following this his account ran very slowly. I noticed also that his mailbox was getting larger and larger. 7000, 8000, 9000 etc, all the way up to 24500 emails that are currently in his Sugar mailbox. As noone noticed this increase in mail box size over the last few days I have only just managed to disable his account details and stop the influx of emails.

My problem now is: How do i delete the content of the mailbox?
I can only select 20 emails at a time to bulk delete....is there a way to select all and delete? IF there is no gui way, can i go in using ssh and delete them from the command line?

Any help would be greatly appreciated.

Thanks

[sanjaykatiyar1]

Sugar stores all mails in the 'emails' table.
So you can delete mail from the table itself, but make sure only the mails related with the particular user should be deleted.
There is one field 'to_addrs' in the 'emails' table so if you are sure that this field is with the particular user then you can write/execute one sql query in the sugar database.

delete from emails where to_addrs='mail_Id' ;

[gehenna]

thats great thanks for the info....

now, where do i find the database to delete the infomation you've mentioned?

[paikmoses]

thats great thanks for the info....

now, where do i find the database to delete the infomation you've mentioned?

To follow sanjaykatiyar1's instructions, you need to open your database client like phpMyAdmin. You can run the query(mentioned above) in the database that you have created for the Sugar instance.

HTH.

Regards,

[gehenna]

hi there,
i haven;'t had much luck getting phpMyAdmin to work but i have been able to open the database in Access. I'm able to get into the Email table and i can see all the data for the user in question, however when I select a field and try to delete it shows up saying the microsoft jet database engine stopped the process because you and another user are attempting to change the same data at the same time.

all users are logged off properly.

i need to delete all records from this table because only one user has ever been configured to use email and it is only that user who has the 25000 emails that need to be deleted.

any further help greatly appreciated.