Mysql Quota
Apr 4, 2007
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.
View 3 Replies
ADVERTISEMENT
Mar 16, 2007
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.
View 2 Replies
View Related
Jun 27, 2007
how i could define a maximum size for a certain folder on my web hosting thus the folder size cannot exceed this ??
Also how could i set a maximum quota for an ftp account ?? provided that i have no cpanel im on GoDaddy host
View 0 Replies
View Related
Jun 28, 2007
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!
View 3 Replies
View Related
Sep 1, 2007
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
View 6 Replies
View Related
Aug 10, 2007
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?
View 2 Replies
View Related
Oct 25, 2009
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.
How can i add quota to folder test?
View 5 Replies
View Related
Apr 25, 2009
how can i enable second level quota step by step?
View 3 Replies
View Related
May 1, 2008
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
View 5 Replies
View Related
Jun 6, 2008
there is a quota problem, i have just checked my server
home/username/.spamassassing
.Spamassassing directoy using much Space .
what is that dirctory doing ?
and what will happen if i will delete all the files in the directory
(Specially : auto_whitelist)
View 0 Replies
View Related
May 16, 2007
I just copied an account over to my new server. The site is only 10 megabytes. In cpanel, it shows:
Disk Space Usage 15670.15 Megabytes
MySQL Disk Space 0 Megabytes
Disk space available -15170.15 Megabytes
The quota is set to 500 megabytes, I ran /scripts/fixquotas twice to no avail. What could the problem be? Cpanel bug?
View 6 Replies
View Related
Oct 31, 2009
how we can extend account quota using ssh, previously cpanel was installed on vps.
View 8 Replies
View Related
Apr 27, 2009
We have this problem .
For example when we create package with 5 gig space and assign it to user that user is able to use more than 5gigs when his disk quota expires.
It is as if the limits are not being enforced upon his account.
View 4 Replies
View Related
May 16, 2008
i have new vps server..
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
View 14 Replies
View Related
Jul 14, 2008
How can I do this on my server to prevent people from abusing
[url]
View 4 Replies
View Related
Jul 8, 2008
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)
View 3 Replies
View Related
May 7, 2008
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% /
# df -i
Filesystem Inodes IUsed IFree IUse% Mounted on
/dev/simfs 1500000 80589 1419411 6% /
# du -hs /tmp
8.2M /tmp
# echo 11111111 > /tmp/testfile
# cat /tmp/testfile
11111111
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.
View 5 Replies
View Related
Mar 25, 2007
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
View 6 Replies
View Related
Sep 28, 2007
I have a Problem with quota. All my account have an Unlimited Package and there quota is 0 MB.
I run following command:
Quote:
/scripts/initquotas
/scripts/resetquotas
/scripts/fixquotas
/scripts/upcp --force
when I ran /scripts/fixquotas and /scripts/resetquotas I saw following error (in SSH) :
Quote:
Resetting quota for zryco to 100 M
No filesystems with quota detected.
View 11 Replies
View Related
Dec 9, 2007
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.
....Done
How do I fix this?
Code:
LABEL=/1 / ext3 defaults,usrquota 1 1
LABEL=/boot1 /boot ext3 defaults 1 2
devpts /dev/pts devpts gid=5,mode=620 0 0
tmpfs /dev/shm tmpfs defaults 0 0
proc /proc proc defaults 0 0
sysfs /sys sysfs defaults 0 0
LABEL=SWAP-sda2 swap swap defaults 0 0
View 1 Replies
View Related
Jan 2, 2007
we have a plan that is go out quota.
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.
how to config this?
View 5 Replies
View Related
Apr 18, 2007
Quota: Unlimeted
disk used: 0
for all listed account in WebHostManager.
Why?
what should i do in SSH for correct this?
View 3 Replies
View Related
Jan 15, 2007
I am trying to restore my backup and system keep saying.
Disk quota exceeded
in whm i have used only 40% from 20 gb
my backup size is only 500mb
View 3 Replies
View Related
Jun 11, 2007
Actually I am work on mail server.
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}
View 2 Replies
View Related
Feb 4, 2007
I accidentally enabled quotas, how can I undo this action?
View 1 Replies
View Related
Mar 21, 2007
How can i set the server to suspend accounts over Quota?
View 3 Replies
View Related
Sep 23, 2007
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.
View 1 Replies
View Related
Nov 21, 2007
A hack program (i do not know what its name is) cause following error via vBulletin or any forum
Code:
This Account Has Exceeded Its CPU Quota
i do not know how i can find out accesing ip and block access request
and
i do not know its runining system ?
i m in shared host (have SSH account)
View 14 Replies
View Related
May 19, 2009
Using cPanel/WHM to administer Accounts.
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.
View 3 Replies
View Related
Mar 22, 2008
is there a way to stop the quota.user files from being created? They're taking up a lot of diskspace.
View 3 Replies
View Related
Nov 2, 2008
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.
View 5 Replies
View Related
