wolstech

You're blocked for too many failed IMAP logins. You probably have a phone or something trying to check your old account's email... Unblocked.

I imported using PMA as well as workbench earlier...I wonder if it was a network issue honestly (the internet here is slow on occasion). The file from earlier is software.sql in the home folder (it's only a few queries, but a large amount of data). I've also uploaded rpc_ueip_aggregates.sql, which has 17000+ rows, but is much smaller, if you want to try it (I did not test this one myself).

Tommy's response time is a bit slower than Ricky (0.6s vs. 0.2s), but sites shouldn't be unusable. WordPress is also infamous for terrible performance (and security) though, and we recommend not using WordPress due to security issues anyway. I would try out some other software first. If that doesn't help, I can have Krydos look into the response times further.

That error doesn't tell us anything other than that ZeroSSL couldn't find the challenge file in the .well-known folder on your account. What is your account's username?

Escalating.

Krydos, When you get a chance can you look at the performance of Ricky's MySQL? There's an email user asking about it being really slow...I thought it had to do with the 6000 connections from yesterday, but she says it's still slow: http://www.helionet.org/index/topic/28421-hh-13010-slow-database/ I was sort of able to replicate the issue (a 6MB test import took me 3-4 minutes...I've done these in <1 before...). Load was 6.30 at the time, so doesn't appear to be that.

A second donation of $1 would be much appreciated (and the invite comes instantly now if you donate by credit card), but if you really don't want to, PM me your email address after deleting and I'll resend the invite. What's the reason you want to do this anyway? I've been here 6 years and have never had a good reason to do this. The easiest solution has always been to uninstall any softactulous software, delete the contents of public_html (not the folder itself though, leave the empty folder), delete any backups/softaculous data in your home folder, delete the contents of ~/tmp, drop your databases and users, and remove all of your domains. If you used the CloudFlare plugin, be sure to turn that off before starting. That should get you an empty hosting account that's pretty close to stock.

Now that's a lot of connections. More surprised he didn't just fall over under the load. Were those connections actually doing anything that you could tell, or were they just open and idle? The fact those are AWS IPs could mean a bunch of things...using us as a data source of some form perhaps?

This issue appears to have subsided around 8PM EDT.

If it doesn't exist, just create it. It needs to be named exactly .htaccess with the leading period, in all lower case. Please be aware that it's difficult to create such a file on Windows, so if you're using a Windows PC and plan to upload via FTP, you may need to name it something else and rename the file once you've uploaded it. Alternately, just use the file manager in cPanel to create it (you will need the hidden files option turned on).

Your domain is still queued. It takes up to 24 hours for the domain to start working. By the way, that email address is the owner of the hosting company. I've edited it out to help prevent spam. The server is showing you the default cPanel 404 error (which shows the server owners information) because Apache doesn't know about your domain yet When Apache next restarts, it will pick up the new domain and start working.

That account is archived. Escalating so it can be restored.

Glad to hear it's working for you Please let us know if you need anything else.

Unblocked. You were blocked for too many failed cPanel logins.

Ricky has been having performance issues for the past day or so: http://www.helionet.org/index/topic/28419-rickys-http-performance/ The Internal Server Error is probably something timing out on the server because of the performance problems. Follow the above topic for more information when it becomes available.

Ricky is showing poor performance for the past 24 hours (since 7AM PDT yesterday): http://heliohost.grd.net.pl/monitor/ I've noticed a few others commenting on the performance as well, and we just received a support email for MySQL being extremely slow on Ricky too.

The AutoSSL can take up to 24 hours to issue certificates after installation I believe. Also, AutoSSL will fail if you have an .htaccess that redirects to HTTPS or restricts access to a domain (the server creates a random-named text file in your domain's root to verify ownership, if Comodo's servers can't reach that file for any reason, it fails...common reasons for failures are forced HTTPS to a domain with a bad cert, forbidden errors, etc.) If it's still not working tomorrow, I'll escalate and have Krydos force the AutoSSL to run for your domains. If there's something wrong, he'd be able to post the logs as well.

Tommy is working fine. What IP address are you connecting from? (You can see it here: https://krydos.heliohost.org/ip.php)

There's something wrong with the certificate. I'm not sure why it mid-issued, but that cert is not for that domain. You need to get another certificate. The easy fix is to delete the certificate entirely and have us install autoSSL for you. The domain whatsnew.cf is not queued and is showing content just fine for me. Please clear your cache.

That website works fine for me. What error are you seeing?

The files typically cannot be recovered when an account is banned like this because there's a risk we'd give you copies of the illegal hacking tools or any stolen data they might have saved. Sometimes we're able to send you the databases though if you have any. I'll also escalate to ask about the domain for you.

That account cannot be unsuspended (it was hacked and used for illegal activity). Please create a new account.

He was referring to the SQL I posted above. He's suggesting you use a query like mine where the SQL itself adds 1 and updates the field in a single command. Reading the value into your script, incrementing it using PHP, and writing it back is what causes your data loss.

You can do something like this (assuming $videoID is the unique Identifier of the video to increment the count on, and your `views` counter column is of type INT): UPDATE videos SET `views` = `views`+1 WHERE `VideoID` = '$videoID';

A certificate signed by your own personal CA will always throw that error since nobody trusts the CA. If you install your root certificate in the trusted CA store, that error should go away. Be aware that people won't just install some random CA though (and for good reason), so using this certificate is effectively pointless. The domain name issue is odd. It's indeed showing sgnetworks, which means the CN field was probably incorrect (CN needs to be the exact domain it's for). Also, wildcard certificates are frowned upon by some (though they're acceptable), and services like LE won't even let you issue one. I'd recommend either using our free cPanel/Comodo SSL or Lets Encrypt (both of which is signed by a CA trusted by all modern computers). Our Comodo/cPanel SSL does all the work for you too...it auto-issues the certificates when you add domains, and renews them automatically as they approach expiration.