Krydos

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/

What is your IP? You can check by going to https://www.heliohost.org/ip.php

That .war file cannot be deployed because java is not enabled on that account. To request java on your account please visit https://johnny.heliohost.org:2083/frontend/paper_lantern/java/index.live.php Once that page says that java is enabled make another post requesting your .war deployment. Keep in mind that since you picked the Johnny server the wait to receive java is quite long. If you would like to have java enabled on your account sooner we recommend transferring your account to Tommy where the wait to receive java is only a few hours.

Logging in to the forum definitely doesn't update your last login date.

I whitelisted your account to run long scripts again. We'll see how high the load gets. Another option that you could look in to is instead of one long several hour long script (which will always have a tendency to break anyways) you could find a way to break it down into smaller pieces. For instance, say you need to scrape 100 urls per day you could keep the current page saved in a database, and each time the script is called it checks the database to see what it needs to do next, scrapes the one page, increments the database, and then quits. If you made the script executable from a web browser (like in cgi-bin directory) I can set up an external cron job to execute the script as often as every 5 minutes. External cron jobs aren't limited to 2 per day like internal cron jobs are. This way also if one portion got corrupted it would only affect the small section instead of messing the entire script up.

How about you ask whomever it is that wrote the software how many simultaneous open mysql connections it needs?

You're the first in a long time to be approved to send more than 50 emails per day so this is pretty new to us. Manually looking at the logs it looks like you sent 352 emails, but it looks like our email counting script was counting a single email more than once. Sorry for that.

A few months ago a user scanned for all of the domains that were pointed to ns1.heliohost.org and ns2.heliohost.org but weren't currently hosted and added about 100 domains that didn't belong to him to his Tommy account. He was permanently suspended for being an attempted domain thief, and we kept all the domains on the suspended account so he couldn't just create a new account and do it all again. I wasn't sure if you'd want no2now.com created as an alias domain or an addon domain so I just cleared it up so you can add it to your Johnny account yourself. Let us know if you need any help with anything.