Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > HOWTO-Related Questions

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 28th October 2009, 23:00
philefluxx philefluxx is offline
Junior Member
 
Join Date: Oct 2009
Posts: 23
Thanks: 0
Thanked 1 Time in 1 Post
Default Increasing Mail Quota Perfect Server Postfix, MySql....Ubuntu 8.04

I'm migrating over mail from our Exchange server. I have about 2 users I know with tons and tons of email. In the middle of migrating over one of them I went over quota.

Ive tried to modify the quota size in the admin.php script provided by Volksman, as well as modifying it in the mysql database. Each time I change it and submit the change I get an error saying:

Warning: #1264 Out of range value adjusted for column 'quota'


Per the guide the table type in MySql for quota is built in INT.

Seems there might be some limitation with INT. Is there any way I can increase the size limit? I really dont want to have to go through this persons email box considering they are an ex-employee so I cannot make them clean it up themselves.

Currently using The Perfect Mail Server set up for Ubuntu 8.04
Reply With Quote
Sponsored Links
  #2  
Old 29th October 2009, 02:01
philefluxx philefluxx is offline
Junior Member
 
Join Date: Oct 2009
Posts: 23
Thanks: 0
Thanked 1 Time in 1 Post
Default

So I changed the table type to BIGINT, now I can modify the quota to a much larger value, but I still receive an error when copying mail over that I am over quota. Any ideas?
Reply With Quote
  #3  
Old 29th October 2009, 20:58
philefluxx philefluxx is offline
Junior Member
 
Join Date: Oct 2009
Posts: 23
Thanks: 0
Thanked 1 Time in 1 Post
Default

RESOLVED:


Found a "gotcha"


I modified the quota size directly in the MySql db, it did not modify the actual maildirsize file located in the individuals mail directory. I believe if I had used to front end provided by Volksman, this would have been modified as well. I will test this with the next users mail box and if the maildirsize file isnt modified I will report back.
Reply With Quote
  #4  
Old 29th October 2009, 23:04
philefluxx philefluxx is offline
Junior Member
 
Join Date: Oct 2009
Posts: 23
Thanks: 0
Thanked 1 Time in 1 Post
 
Default

So the script provided by Volksman does not modify the maildirsize file. You can however modify this manually to resolve the issue. Looking over Volksman script it doesnt look like it was designed to do so (as he stated you may need to tailor it to your needs). This could also be a problem with postfix not modifying the file per what the MySql database says it should be, postifx also may not be running a query for this information so in essence "working as intended".


Personally I dont think it is a big issue to make these modifications manually, the default is set to 2gigs. I only have a couple mailboxes that will need to exceed that size. Everyone else will just need to stay organized and remove things they dont need.
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Perfect Server Ubuntu 8.10 vs. 8.04 LTS atjensen11 HOWTO-Related Questions 1 13th April 2009 11:07
CentoS doesn't send the emails vaio1 Installation/Configuration 18 5th November 2008 17:51
Problem with dcc-client installation (Postfix) swap-as Installation/Configuration 9 18th September 2008 20:47
Filtering emails using Spamassassin and Clamav for Exchange 2000 Server Rocky Server Operation 19 11th March 2008 08:27
Virtual Users and Domains with Postfix... Problems hackerkatt Server Operation 2 29th January 2008 21:27


All times are GMT +2. The time now is 04:07.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.