Many process connected to Mysql and consumming resources

huho78 · Post by **huho78** » Fri May 19, 2017 4:34 pm

Support Request Template
What version of phpBB are you using? phpBB 3.2.0
What is your board's URL? https://www.ellinceiberico.com
Who do you host your board with? webempresa
How did you install your board? I used the download package from phpBB.com
What is the most recent action performed on your board? Please select your answer
Is registration required to reproduce this issue? No
Do you have any MODs installed? No
Do you have any extensions installed? Yes
What extensions do you have installed? Adsense & Ads
Board announcements
Board rules
Database optimize & repair tool
Google analytics
Google translator
Lightbox
Relative dates
Topic preview
VigLink
What styles do you currently have installed? prosilver
What language(s) is your board currently using? spanish
Which database type/version are you using? MySQL 5
What is your level of experience? New to PHP and phpBB
What actions did you take (updating your board; installing a MOD, style or extension; etc.) prior to this problem becoming noticeable? Maybe installing an extension but i'm not sure
Please describe your problem. My phpbb forum is contnue activating process that are consumming a lot of resource. In my hosting say this error: "[Fri May 19 13:13:28.749437 2017] [:error] [pid 532276] mod_hostinglimits:Error on LVE enter: LVE(619) HANDLER(application/x-lsphp56) HOSTNAME(www.ellinceiberico.com) URL(/foro/app.php/feed) TID(532276) errno (7) Read more: http://e.cloudlinux.com/MHL-E2BIG min_uid (500)"
I see in my forum that always there are many users conected aroun 120; y purge all of them and inmediatly they are present again.
Generated by SRT Generator

janus_zonstraal · Post by **janus_zonstraal** » Sat May 20, 2017 6:06 am

You can have a look who the visitors are http://www.ellinceiberico.com/foro/viewonline.php?sg=1

david63 · Post by **david63** » Sat May 20, 2017 6:46 am

Is your site using some form of caching such as Cloudflare?

huho78 · Post by **huho78** » Sat May 20, 2017 9:59 am

Thanks. I'm not using Cloudflare or similar (is recommended?)
I have look in the list of people connected that there many of them with very similar ip....what can i do?is a kind of virus installed in my forum?

janus_zonstraal · Post by **janus_zonstraal** » Sat May 20, 2017 10:05 am

Search where the IP adress is from
http://whatismyipaddress.com/ip-lookup
And if not important block it

canonknipser · Post by **canonknipser** » Sat May 20, 2017 12:18 pm

I would suggest to create a bot with the agent string "[email protected]", the there will be only one connection instead of so many; banning IP addresses is mostly useless and ressource-consuming.

You can add to bot afterwards to a "no access" group, if you feel the need

huho78 · Post by **huho78** » Sun May 21, 2017 8:05 am

I have buikd a new bot as canonknipser suggest and now the number of user connected is low, but i'm still have the same problem of cpu resource

General Error
SQL ERROR [ mysqli ]
User ellincei_forumad already has more than 'max_user_connections' active connections [1203]
An sql error occurred while fetching this page. Please contact an administrator if this problem persists.

In my host a i can read this list of LVE limits reached errors:

[Sun May 21 09:43:17.584367 2017] [:error] [pid 589092] mod_hostinglimits:Error on LVE enter: LVE(619) HANDLER(application/x-lsphp70) HOSTNAME(www.ellinceiberico.com) URL(/foro/app.php/feed) TID(589092) errno (7) Read more: http://e.cloudlinux.com/MHL-E2BIG min_uid (500)

[Sun May 21 09:43:17.611513 2017] [:error] [pid 589151] mod_hostinglimits:Error on LVE enter: LVE(619) HANDLER(application/x-lsphp70) HOSTNAME(www.ellinceiberico.com) URL(/foro/app.php/feed) TID(589151) errno (7) Read more: http://e.cloudlinux.com/MHL-E2BIG min_uid (500)

[Sun May 21 09:43:18.400928 2017] [:error] [pid 584171] mod_hostinglimits:Error on LVE enter: LVE(619) HANDLER(application/x-lsphp70) HOSTNAME(www.ellinceiberico.com) URL(/foro/app.php/feed) TID(584171) errno (7) Read more: http://e.cloudlinux.com/MHL-E2BIG min_uid (500)

I don't know anything about php or mysql...but it seems that there is a process in my phpfourm folder /feed that could be the cause isn't it?

WelshPaul · Post by **WelshPaul** » Sun May 21, 2017 8:26 am

What's the max_user_connections in your MySQL configuration? It's obviously too low.

In centos 7 for example, edit the following file:
/etc/my.cnf

Look for:
[mysqld]

After add:
max_user_connections = 500

Should look like this:
[mysqld]
max_user_connections = 500

Save the file and restart mysql server.

huho78 · Post by **huho78** » Sun May 21, 2017 12:17 pm

Sorry, could you explain me how can i check the number of "max-user_connection" configuration? I have a CPANEL in my host where i can access to phpMyadmin...is there?

WelshPaul · Post by **WelshPaul** » Sun May 21, 2017 2:48 pm

Are you on shared hosting? If so then speak to your host!

In phpMyAdmin click on the Variables tab and scroll down until you find max user connections, click on edit and set it at a higher value.

huho78 · Post by **huho78** » Tue May 23, 2017 5:29 am

My host is shared and the company say me that max_user_connection allowed =15 and they say that is an enough value because is really immprobable that 1 5users at the same time make request on the table.
I have access to PHPMyAdmin but i don't find anything related with max-user-connecttion.
The problem continue. I have banned the list of IP that was causing to many user connection and now the number of users visiting my forum is more real.
Doyou have any reccomendation? can i change anything in PHPMyAdmin?Do i have any spam code inside?Do i need to re-install the forum?

Thank you

canonknipser · Post by **canonknipser** » Tue May 23, 2017 6:11 am

huho78 wrote: ↑Tue May 23, 2017 5:29 am I have banned the list of IP

as said above

canonknipser wrote: ↑Sat May 20, 2017 12:18 pm banning IP addresses is mostly useless and ressource-consuming.

. You've already added that user as a bot, so there is no need to ban the IP addresses.
Those users in mysql max user connection are not your board visitors, neither registererd or bots or guests , but are the technical users used by the backend processes to access your database (i.e. the database user configured in your config.php). It depends how many other installations (maybe yours like a wordpress site, maybe sites from other customers) are using the same database server. You need to speak to your host if they can identify which users are connected to the database server and who is the "owner" of those users

david63 · Post by **david63** » Tue May 23, 2017 6:44 am

With a maximum connection limit of 15 I would guess that you are either on free hosting or it is very cheap. The normal value is around 100.

No matter what you do there is no way to stop any bot/user or anything else from trying to access your server - yes you can put measures in place so that they do not show up but you cannot stop them.

If you host has such a low limit then it is probably time to find a new host.

huho78 · Post by **huho78** » Tue May 23, 2017 5:13 pm

Hosting company (it is not a free hosting) tell me that the max_connections=300 and the max_user_connections=15 (now 20 because they have improve a bit my account). When you say that usually hosting offers 100 connections is max_user_connections or max_connections?

thank you so much for your help

WelshPaul · Post by **WelshPaul** » Tue May 23, 2017 5:19 pm

You need a better host, it's as simple as that!

I would set max_connections at 500 as a starting point, 300 is on the low side too. These values will vary from server to server depending on spec and personal requirements etc.

Even if they push the values up a little, a bit more traffic and your site is going to go down again.