how to configure quota in mysql? I found one project, but it is in beta state for long time, and nobody is developing it i think (names mysqlquota...)
i havent found anything better... and google is showing only links from 2001 or 2003.
Maybe something has changed, and newest mysql 5.1 has some quota support?
i have Linux and free hosting, and i want to limit size of the databases of my users. i got all users and database on one partition - XFS, which is disk array.
if the number of Mysql databases or email accounts on one account has any issue on the quota (hard disk) that I offer to my customers. I'm suggesting More databases will take more space but I need clarification.
I've a dedicated with VERY high-end specs 16gb ram SCSI RAID10 SATAII RAID5 CentOS 4.5 x86_64 Kernal 2.6.9-55.ELsmp cPanel
However, it has a serious problem, which is with any quota process such as, modifying accounts' quota/creating new account with specific quota(if set to unlimited no problem occurs)/restoring account from a backup file even its a 10mb file when it reaches the quota check section. When any of those happens the load goes Very high 50+ and even can hang the server for sometime if there is a big backup to restore so its quota is big . and the top process that appears at 'top' is quotaon 105% CPU.
When I reboot the server and it come back online I can do any quota process with no issues at all for few hours after a reboot then if I do any quota concerning action the problem happens again!
The DC said its not a hardware problem while I was suspecting it is!
I am trying to add a new user and here's what I'm doing:
Code: login as: root root@server.ip.address.here's password: Last login: Fri Aug 31 18:54:25 2007 from my.last.ip [18:56:05][root@chii]~$ useradd -d /home/chiisana_alf -G chiisana_crew chiisana_alf [18:56:31][root@chii]~$ passwd chiisana_alf Changing password for user chiisana_alf. New UNIX password: Retype new UNIX password: passwd: all authentication tokens updated successfully. So far so good; right?
Next:
Code: [18:56:40][root@chii]~$ cd /home [18:56:46][root@chii]/home$ ls -lha total 52K drwx--x--x 13 root root 4.0K Aug 31 18:54 . drwxr-xr-x 22 root root 4.0K Aug 31 17:45 .. drwxr-xr-x 5 root root 4.0K Aug 31 00:38 .cpan drwx------ 3 root root 4.0K Aug 31 00:37 .cpcpan drwx------ 2 root root 4.0K Aug 29 12:04 MySQL-install drwx--x--x 10 chiisana chiisana 4.0K Aug 30 09:54 chiisana drwx------ 2 root root 4.0K Aug 31 18:54 chiisana_alf drwx------ 4 chiisana_edo chiisana_edo 4.0K Aug 31 15:43 chiisana_edo drwx------ 4 chiisana_mrpc chiisana_mrpc 4.0K Aug 31 00:36 chiisana_mrpc drwx------ 4 chiisana_neo chiisana_neo 4.0K Aug 31 01:42 chiisana_neo drwx------ 3 root root 4.0K Aug 31 10:01 cpapachebuild drwxr-xr-x 3 root root 4.0K Aug 28 15:25 cpins drwx------ 2 webadmin webadmin 4.0K Nov 10 2006 webadmin [18:56:48][root@chii]/home$ What the? root? That's not right....
Code: [18:56:48][root@chii]/home$ chown chiisana_alf:chiisana_alf chiisana_alf/ chown: changing ownership of `chiisana_alf/': Disk quota exceeded Er....
Code: [18:58:54][root@chii]/home$ du -h chiisana_alf/ 4.0K chiisana_alf/ [18:59:10][root@chii]/home$ df -h Filesystem Size Used Avail Use% Mounted on /dev/vzfs 100G 3.4G 96G 4% / /tmp 100G 3.4G 96G 4% /var/tmp
I am running cPanel and all the quotas are showing as unlimited and 0mb space used, I have tryed the rebuilt quotas in cPanel but this has no effect, can anyone shed some light on this?
i want to know how i can add quota to different folders,
For example the ftp user "test" have the folder "/home/admin/folder/test/" but i want to set a max quota that he can have on the folder, i tried with ftpquota but the problem is that he can add files from http too.
I am receiving the following cpanel error (towards the left hand side column) when I login into an account:
Disk Space Usage Serious problem while fetching quota data (quota): Bad file descriptor (0) Megabytes.
I still don't know what went wrong all of a sudden. I did run /scripts/fixquotas through shell but that didn't fix anything either. Here are the errors I got from there:
Installing Default Quota Databases...../var/tmp/aquota.user..../var/tmp/quota.user.....Done WARNING! Backup dir is set to /. Unexpected results may occur! Quotas are now on touch: cannot touch `/var/tmp/quota.user': No such file or directory touch: cannot touch `/var/tmp/aquota.user': No such file or directory Resetting quota for cptest to 550 M No filesystems with quota detected
I added some new user to my server but when i went to List Accounts i found all users with unlimited Quota, i don't why? i already have Packages with specific quote for each one, even, if i made it Options Manually i have the same problem.
i made a reseller and from that reseller i added user with the same problem
if i loge in the cpenal for one user i have this message in the Disk Space Usage
Serious problem while fetching quota data (quota): Illegal seek (0) / MB
I'm running a VPS, it sounds weird but its more like a learning lab I bought to help me get better skills in linux environment, so far I've learned a bit more in BIND and apache.
I use the panel webmin, I tried setting a mount but it didn't work.
The mounted devices output this:
simfs on / type simfs (rw) tmpfs on /lib/init/rw type tmpfs (rw,nosuid) proc on /proc type proc (rw,nosuid,nodev,noexec) sysfs on /sys type sysfs (rw,nosuid,nodev,noexec) tmpfs on /dev/shm type tmpfs (rw,nosuid,nodev) devpts on /dev/pts type devpts (rw,nosuid,noexec)
Now, that struck me is that other VPSes that have CentOS with cpanel has their disk quota installed already. (That includes directadmin and lxadmin)
Has anyone ever run into this before? We are running into issues with one of our hosting servers, it claims that the /tmp folder has exceeded the disk quota but when you actually go to the /tmp folder it's not at all.
Here are the outputs:
# df -h Filesystem Size Used Avail Use% Mounted on /dev/simfs 60G 2.4G 58G 4% /
But it still gives a PHP error saying /tmp disk quota exceeded until I completely empty the folder and then it works for a few hours and does the same thing.
my costumer's web site often started to give "This Account Has Exceeded Its CPU Quota" error
his/her logs following.
Code: -------------------------------------------------------------------------------- CPU Exceeded Log For Thu Mar 22 11:55:12 2007
Thu Mar 22 11:52:19 2007: used 0.13 seconds of cpu time for HTTP Request: vbulletin.com : GET /external.php?type=RSS2 HTTP/1.1 Thu Mar 22 11:52:19 2007: used 0.13 seconds of cpu time for HTTP Request: vbulletin.com : GET /external.php?type=RSS2&forumids=12 HTTP/1.1 Thu Mar 22 11:53:25 2007: used 0.18 seconds of cpu time for HTTP Request: vbulletin.com : GET / HTTP/1.1 Thu Mar 22 11:52:00 2007: used 0.13 seconds of cpu time for HTTP Request: vbulletin.com : GET /external.php?type=RSS2&forumids=12 HTTP/1.1 Thu Mar 22 11:51:59 2007: used 0.20 seconds of cpu time for HTTP Request: vbulletin.com : GET /showthread.php?t=289 HTTP/1.1 Thu Mar 22 11:51:54 2007: used 0.12 seconds of cpu time for HTTP Request: vbulletin.com : GET /external.php?type=RSS2&forumids=12 HTTP/1.1 Thu Mar 22 11:53:35 2007: used 0.07 seconds of cpu time for HTTP Request: vbulletin.com : GET /clientscript/vbulletin_multi_quote.js?v=364 HTTP/1.1 Thu Mar 22 11:52:09 2007: used 0.12 seconds of cpu time for HTTP Request: vbulletin.com : GET /attachment.php?attachmentid=65&d=1168905639 HTTP/1.1 Thu Mar 22 11:52:27 2007: used 0.28 seconds of cpu time for HTTP Request: vbulletin.com : GET /forumdisplay.php?f=12&page=2&order=desc HTTP/1.1 Thu Mar 22 11:53:34 2007: used 0.19 seconds of cpu time for HTTP Request: vbulletin.com : GET /showthread.php?p=2784 HTTP/1.1 Thu Mar 22 11:52:29 2007: used 0.12 seconds of cpu time for HTTP Request: vbulletin.com : GET /external.php?type=RSS2 HTTP/1.1 Thu Mar 22 11:54:16 2007: used 0.19 seconds of cpu time for HTTP Request: vbulletin.com : GET /index.php HTTP/1.1 Thu Mar 22 11:54:16 2007: used 0.25 seconds of cpu time for HTTP Request: vbulletin.com : GET /forum/ HTTP/1.1 Thu Mar 22 11:54:00 2007: used 0.28 seconds of cpu time for HTTP Request: vbulletin.com : GET /forumdisplay.php?f=2 HTTP/1.1 Thu Mar 22 11:55:09 2007: used 0.18 seconds of cpu time for HTTP Request: vbulletin.com : GET /forum/cron.php?&rand=65617 HTTP/1.1 Thu Mar 22 11:55:08 2007: used 49.00 seconds of cpu time for [[mysql query]] Thu Mar 22 11:52:31 2007: used 0.13 seconds of cpu time for HTTP Request: vbulletin.com : GET /external.php?type=RSS2&forumids=12 HTTP/1.1 Thu Mar 22 11:51:57 2007: used 0.12 seconds of cpu time for HTTP Request: vbulletin.com : GET /external.php?type=RSS2 HTTP/1.1 Thu Mar 22 11:52:03 2007: used 0.15 seconds of cpu time for HTTP Request: vbulletin.com : GET /external.php?type=RSS2 HTTP/1.1
-------------------------------------------------------------------------------- CPU Exceeded Log For Thu Mar 22 12:34:21 2007
Thu Mar 22 12:31:10 2007: used 0.23 seconds of cpu time for HTTP Request: vbulletin.com : GET /forum/showthread.php?p=56720 HTTP/1.0 Thu Mar 22 12:33:25 2007: used 0.04 seconds of cpu time for HTTP Request: vbulletin.com : GET /forum/images/buttons/collapse_thead.gif HTTP/1.1 Thu Mar 22 12:33:23 2007: used 0.07 seconds of cpu time for HTTP Request: vbulletin.com.com : GET /forum/images/icons/icon1.gif HTTP/1.1 Thu Mar 22 12:33:15 2007: used 0.26 seconds of cpu time for HTTP Request: vbulletin.com : GET /forum/ HTTP/1.1 Thu Mar 22 12:33:50 2007: used 2.00 seconds of cpu time for [[mysql query]] Thu Mar 22 12:30:30 2007: used 0.22 seconds of cpu time for HTTP Request: vbulletin.com : GET /forum/showthread.php?p=62840 HTTP/1.0 Thu Mar 22 12:33:44 2007: used 0.13 seconds of cpu time for HTTP Request: vbulletin.com : GET /cron.php?&rand=790216 HTTP/1.1 Thu Mar 22 12:32:00 2007: used 0.22 seconds of cpu time for HTTP Request: vbulletin.com : GET /forum/member.php?find=lastposter&t=42694 HTTP/1.0 Thu Mar 22 12:33:12 2007: used 0.25 seconds of cpu time for HTTP Request: vbulletin.com : GET /forum/ HTTP/1.1 Thu Mar 22 12:34:02 2007: used 0.14 seconds of cpu time for HTTP Request: vbulletin.com : GET /cron.php?&rand=350679 HTTP/1.1 Thu Mar 22 12:33:59 2007: used 0.25 seconds of cpu time for HTTP Request: vbulletin.com : GET /showthread.php?p=2787 HTTP/1.1 Thu Mar 22 12:33:13 2007: used 2.00 seconds of cpu time for [[mysql query]] Thu Mar 22 12:33:54 2007: used 0.14 seconds of cpu time for HTTP Request: vbulletin.com : GET /cron.php?&rand=395167 HTTP/1.1 Thu Mar 22 12:33:35 2007: used 0.17 seconds of cpu time for HTTP Request: vbulletin.com : GET / HTTP/1.1 Thu Mar 22 12:34:19 2007: used 49.00 seconds of cpu time for [[mysql query]] Thu Mar 22 12:34:20 2007: used 0.24 seconds of cpu time for HTTP Request: vbulletin.com : GET /forum/showthread.php?p=68933 HTTP/1.0 Thu Mar 22 12:33:52 2007: used 0.28 seconds of cpu time for HTTP Request: vbulletin.com : GET /forumdisplay.php?f=2 HTTP/1.1 Thu Mar 22 12:32:42 2007: used 0.24 seconds of cpu time for HTTP Request: vbulletin.com : GET /forum/member.php?find=lastposter&t=41435 HTTP/1.0
-------------------------------------------------------------------------------- CPU Exceeded Log For Thu Mar 22 16:16:16 2007
Thu Mar 22 16:14:00 2007: used 0.18 seconds of cpu time for HTTP Request: vbulletin.com : POST /forum/login.php HTTP/1.1 Thu Mar 22 16:13:35 2007: used 0.32 seconds of cpu time for HTTP Request: vbulletin.com.com : GET / HTTP/1.1 Thu Mar 22 16:14:21 2007: used 3.00 seconds of cpu time for [[mysql query]] Thu Mar 22 16:14:21 2007: used 0.18 seconds of cpu time for HTTP Request: vbulletin.com : POST /forum/login.php HTTP/1.1 Thu Mar 22 16:16:15 2007: used 2.00 seconds of cpu time for [[mysql query]] Thu Mar 22 16:16:11 2007: used 38.00 seconds of cpu time for [[mysql query]] Thu Mar 22 16:14:03 2007: used 0.29 seconds of cpu time for HTTP Request: vbulletin.com.com : GET / HTTP/1.1 Thu Mar 22 16:15:22 2007: used 2.00 seconds of cpu time for [[mysql query]] Thu Mar 22 16:15:24 2007: used 0.24 seconds of cpu time for HTTP Request: vbulletin.com : GET /forum/ HTTP/1.1
Just installed fresh centos 5 / cpanel and now I get this:
No filesystems with quota detected.
[root@server scripts]# quotacheck -avugm quotacheck: Can't find filesystem to check or filesystem not mounted with quota option.
Code:
[root@server scripts]# /scripts/initquotas Quotas are now on Updating Quota Files...... quotacheck: Can't find filesystem to check or filesystem not mounted with quota option.
quotacheck: Can't find filesystem to check or filesystem not mounted with quota option.
In the old server we received an email alert when quota is near 80% and 100%.. now (new server) we haven't received nothing and our isp say that is not possible ...?
we have whm and notifications check is all cehcked.
I had been allocated a quota for particular domain using WHM panel. exmple. xyz.com allocated quota 1000MB
under this domain many user & for this user allocated quota using cpanel mk@xyz.com 20MB kk@xyz.com 20MB Dk@xyz.com 20MB
Using WHM & C-panel This is very essay, but without WHM and C PANEL how to do this ?
Because i am not installed cpanel and whm.
Question :===> how to allocated quota to particular domain and user under this domain on shell prompt or command prompt {also mail quota for particular user on shell prompt}
Lately on one of my servers I noticed everytime I try to modify an account or quota, the quotaon process goes to 100% cpu, server load gets to about 30, and if I tried to modify multiple quotas it would basically become unresponsive.
It all seemed to have started after stage2 upgrade.
I havent seen any errors from the filesystem or even any errors in messages after it does this.
I've been allocated additional disk space by my host, but can't seem to use it -- the existing (original) Account quota won't update.
I've tried changing the quota for the existing Package, as well as creating a new package with the desired quota and 'upgrading' the Account to the new Package, but the Account's quota remains the same.
It's as tho' the Account quota value is cached somewhere, and isn't getting refreshed.
Im having a bit of a problematic dilemma with one of my VPS providers.
I am running LXAdmin and every morning I get email alerts saying the following:
Warning: The Account chrisc is using 100% of quota for disk_usage. Limit: 20000 Used: 20000 Warning: The Account chrisc is using 100% of quota for memory_usage. Limit: 512 Used: 512 Warning: The Account chrisc is using 100% of quota for guarmem_usage. Limit: 512 Used: 512
Each time I have been told a user has used up all the server resources when they shouldn't have been allowed to..
Also I have been trying to configure my Thunderbird mail client to send and receive emails but I keep on getting password errors, webmail works fine but I just cant access the mail servers from my Thunderbird client. I have been told this is a problem with LXAdmin - I don't know whether this is the case or not but was advised the only way to get around this issue is to upgrade to cPanel and that will solve the problem, whilst I believe this to possibly be true I am a little concerned about this company.
Having spoken with another VPS seller about this they believe these VPS accounts are being oversold as I am only paying $6.36 per month for 20GB Disk Space and 200GB Bandwidth with 512MB Ram.
