Krydos

When you change your domain it breaks the java install. There you go http://van51.ml/test.jsp

No, there is no output to the screen as the script is meant to be run from cron. You can add this line if you want it to print something to the screen: <?php $db_host = "localhost"; $db_user = "luigi123_sb"; $db_pass = "bestpasswordever"; $con = new mysqli($db_host, $db_user, $db_pass); if ($con->connect_error) die("Connection failed: ".$con->connect_error); $sql = "select * from information_schema.processlist"; $result = $con->query($sql); while ($row = $result->fetch_assoc()) { $command = $row['COMMAND']; if ($command == "Sleep") { $mysql_id = $row['ID']; $con->query("kill $mysql_id"); echo "Killed mysql process $mysql_id. "; // <---- This is the new line } }

http://primeaircargoservice.heliohost.org/ works for me. What page is giving you a 404 error?

Have you requested java access on your account?

You may use cloudflare on any domain other than .heliohost.org domains, but in this case I doubt it will do much good. It's php files causing the problem not static content like cloudflare helps with. Since you have a forum are you sure you aren't being overrun with bots? Sometimes that is the cause of high load. Cloudflare can help with bots if you set up their protection though https://support.cloudflare.com/hc/en-us/articles/200171416-How-do-I-block-bots-and-crawlers- You can download your backup at https://tommy.heliohost.org:2083/frontend/paper_lantern/backup/index.html

Did you change your main domain?

Whatever you've changed in the last few days has resulted in your account spewing hundreds of zombie php processes which causes slow response time and downtime for all the other users on Tommy. Right now there is 0-4 zombie processes that haven't been reaped. When you account is unsuspended there are 140-180 of just your processes which haven't been reaped. You either need to move to a paid hosting such as http://partners.hostgator.com/c/391660/177309/3094 or figure out what is going on to cause these ridiculous levels of load.

Your high load appears to be coming from /home/tonsalya/public_html/index.php

Deployed. http://brassatom.heliohost.org/brass-db-one/

In order to test the script I changed the password of luigi123_sb so you'll need to change it back to whatever it was before so your gameserver will be able to connect to the database.

Unblocked.

Does logging in from constantly cycling dynamic IPs work any better now?

The account tonsalya has been suspended. To request an account be unsuspended and to find out why your account was suspended please post at https://www.helionet.org/index/forum/81-suspended-and-queued-accounts/

You can download backups of your site at https://tommy.heliohost.org:2083/frontend/paper_lantern/backup/index.html

There you go # nghttp -nv https://sheepy.heliohost.org [ 0.196] Connected The negotiated protocol: h2 [ 0.337] recv SETTINGS frame <length=6, flags=0x00, stream_id=0> (niv=1) [sETTINGS_MAX_CONCURRENT_STREAMS(0x03):100] [ 0.337] recv WINDOW_UPDATE frame <length=4, flags=0x00, stream_id=0> (window_size_increment=2147418112) [ 0.337] send SETTINGS frame <length=12, flags=0x00, stream_id=0> (niv=2) [sETTINGS_MAX_CONCURRENT_STREAMS(0x03):100] [sETTINGS_INITIAL_WINDOW_SIZE(0x04):65535] [ 0.337] send SETTINGS frame <length=0, flags=0x01, stream_id=0> ; ACK (niv=0) [ 0.337] send PRIORITY frame <length=5, flags=0x00, stream_id=3> (dep_stream_id=0, weight=201, exclusive=0) [ 0.337] send PRIORITY frame <length=5, flags=0x00, stream_id=5> (dep_stream_id=0, weight=101, exclusive=0) [ 0.337] send PRIORITY frame <length=5, flags=0x00, stream_id=7> (dep_stream_id=0, weight=1, exclusive=0) [ 0.337] send PRIORITY frame <length=5, flags=0x00, stream_id=9> (dep_stream_id=7, weight=1, exclusive=0) [ 0.337] send PRIORITY frame <length=5, flags=0x00, stream_id=11> (dep_stream_id=3, weight=1, exclusive=0) [ 0.337] send HEADERS frame <length=42, flags=0x25, stream_id=13> ; END_STREAM | END_HEADERS | PRIORITY (padlen=0, dep_stream_id=11, weight=16, exclusive=0) ; Open new stream :method: GET :path: / :scheme: https :authority: sheepy.heliohost.org accept: */* accept-encoding: gzip, deflate user-agent: nghttp2/1.7.1 [ 0.402] recv SETTINGS frame <length=0, flags=0x01, stream_id=0> ; ACK (niv=0) [ 0.405] recv (stream_id=13) :status: 403 [ 0.405] recv (stream_id=13) date: Wed, 26 Jul 2017 06:48:17 GMT [ 0.405] recv (stream_id=13) server: Apache [ 0.405] recv (stream_id=13) content-length: 328 [ 0.405] recv (stream_id=13) content-type: text/html; charset=iso-8859-1 [ 0.405] recv HEADERS frame <length=65, flags=0x04, stream_id=13> ; END_HEADERS (padlen=0) ; First response header [ 0.405] recv DATA frame <length=328, flags=0x01, stream_id=13> ; END_STREAM [ 0.405] send GOAWAY frame <length=8, flags=0x00, stream_id=0> (last_stream_id=0, error_code=NO_ERROR(0x00), opaque_data(0)=[])

Alright, I'm done testing. You can change your Tommy cpanel password back, and you can also change your luigi123_sb mysql user password back to what it was before. Here's your tested script: <?php $db_host = "localhost"; $db_user = "luigi123_sb"; $db_pass = "bestpasswordever"; $con = new mysqli($db_host, $db_user, $db_pass); if ($con->connect_error) die("Connection failed: ".$con->connect_error); $sql = "select * from information_schema.processlist"; $result = $con->query($sql); while ($row = $result->fetch_assoc()) { $command = $row['COMMAND']; if ($command == "Sleep") { $mysql_id = $row['ID']; $con->query("kill $mysql_id"); } } Put this somewhere in public_html and make sure you set the password for luigi123_sb properly. Even if your mysql user is at the max open connections this command will still function. It will scan through all of your open connections and if their status is sleeping it closes them. You can execute it manually by visiting the page in your browser or I can set up an external cron to run every 5 minutes or something. Hopefully this helps.

I'm going to change the password on your cpanel account to test this. Don't panic. I'll post in this thread when I'm done and you can change the password back.

What is your username or main domain?

LMGTFY: https://www.google.com/search?q=TypeError%3A+Cannot+read+property+%27slice%27+of+undefined Are you using javascript maybe?

150 is a no. I've got an idea. How about I write a script to kill the broken mysql connections every few seconds that this buggy software opens and never closes? Want to try that? I'm not going to let your account hog the entire server's worth of mysql connections without even transferring any data for hours. That's completely ridiculous.

Our servers use MySQL not MariaDB so I'm not sure how you're getting that error.

The domain ileren.be is not hosted with us. If you wish to host it on our servers you will need to set your nameservers to ns1.heliohost.org and ns2.heliohost.org.

Deployed. http://wilgil.heliohost.org/Zaxxon/

Deployed. http://brassatom.heliohost.org/brass-db-one/

Deployed. http://escrit.heliohost.org/escrit_plataforma/