max_user_connections for new users

[gdaniele]

Hello all,

 

long time froxlor-user, first time poster

 

I don't know if it's something only we are facing, but in the last weeks there are quite a lot of brute-forcing bots hitting the wordpress installations of our clients on the server where we use froxlor (still debian squeeze). The worst part is that they keep mysql busy and this impacts the smtp server as well(*) so I was thinking of possible solutions, and one of them could be to limit the maximum number of concurrent connections to mysql for panel customers.

 

It should be fairly simple since it's just a matter of adding a clause to the GRANT query ( http://dev.mysql.com/doc/refman/5.1/en/grant.html search for MAX_USER_CONNECTIONS in the page) and the only instances of GRANT I found are into admin_customers.php and customer_mysql.php

 

I would like to know whether such a feature would be welcome (if so, I can try to provide a patch for it) and in general if you faced similar issues and how you solved them.

 

Regards,

Daniele

 

(*) we are already using postfix proxymap and nscd

[d00p]

very specific - most users won't need that. Plus: Problem seems to be Wordpress here (i know that from my servers as well, wordpress is a pain in the ass)