Skip to content

Latest commit

 

History

History
50 lines (36 loc) · 1.62 KB

README.md

File metadata and controls

50 lines (36 loc) · 1.62 KB

ISPConfig MySQL limits

INSTALLATION (as root)

git clone https://github.com/alexalouit/ISPConfig-MySQL-limits.git
cd ISPConfig-MySQL-limits
php -q install.php

After install, a new tab (options) will be available in editing mysql user with an admin account.

COMPATIBILITY

ISPConfig (select version in branch)

NOTES

For multiple reasons, it works on RW users only

MANUAL INSTALLATION

  • patch ISPConfig
cp ispconfig.patch /usr/local/ispconfig/ispconfig.patch
cd /usr/local/ispconfig
patch -p3 < ./ispconfig.patch
rm ./ispconfig.patch
  • sql queries
ALTER TABLE `web_database_user` ADD `max_user_connections` int(11) NOT NULL DEFAULT '-1';
ALTER TABLE `web_database_user` ADD `max_queries_per_hour` int(11) NOT NULL DEFAULT '-1';
ALTER TABLE `web_database_user` ADD `max_updates_per_hour` int(11) NOT NULL DEFAULT '-1';
ALTER TABLE `web_database_user` ADD `max_connections_per_hour` int(11) NOT NULL DEFAULT '-1';
ALTER TABLE `client_template` ADD `max_user_connections` int(11) NOT NULL DEFAULT '-1';
ALTER TABLE `client_template` ADD `max_queries_per_hour` int(11) NOT NULL DEFAULT '-1';
ALTER TABLE `client_template` ADD `max_updates_per_hour` int(11) NOT NULL DEFAULT '-1';
ALTER TABLE `client_template` ADD `max_connections_per_hour` int(11) NOT NULL DEFAULT '-1';
ALTER TABLE `client` ADD `max_user_connections` int(11) NOT NULL DEFAULT '-1';
ALTER TABLE `client` ADD `max_queries_per_hour` int(11) NOT NULL DEFAULT '-1';
ALTER TABLE `client` ADD `max_updates_per_hour` int(11) NOT NULL DEFAULT '-1';
ALTER TABLE `client` ADD `max_connections_per_hour` int(11) NOT NULL DEFAULT '-1';