Manually changing the user.usage file or forcing a re-count?

[nielsh]

Hi there,

I've got a domain_create_post.sh script that automatically installs an application and creates a database/sets grants. In DirectAdmin, I can see the database under MySQL management perfectly fine - but the "Databases used" count is wrong. It still displays 0, even though there is of course a database created that the user can also see.

I'm not sure what the recommended way is to "signal" to DirectAdmin that the domain_create_post.sh script just added a database. Is there a command I can execute to force it to re-count? Or do I have to script a change to the /usr/local/directadmin/data/users/username/user.usage file and set mysql=<current_value>+1 ?

Thanks!
Niels

 

[zEitEr]

Hello,

I guess you need to update mysql= in /usr/local/directadmin/data/users/<username>/user.usage

# cat /usr/local/directadmin/data/users/userbob/user.usage
bandwidth=103.3
db_quota=41646912
domainptr=0
email_deliveries=162
email_deliveries_incoming=162
email_deliveries_outgoing=0
email_quota=8527872
ftp=2
inode=40363
mysql=5
nemailf=21
nemailml=0
nemailr=0
nemails=11
nsubdomains=1
quota=557.6
vdomains=6