wolstech

Wait a little longer. Johnny accounts can sometimes take up to 5 days to come out of the queue.

Nothing has been said either way on it, but it's still broken

Not sure if it was restarted or not, but I agree that it does feel faster. I'm curious as to what the downtime was for...

No they will not appear in softaculous when the MySQL server is fixed, however these installations that do not appear in softaculous can be treated as if you manually installed it. If the installed software works, there's no need to remove them. If you want to remove them for some reason you will need to do so manually.

It broke on February 17th I believe, and nobody knows when it'll be fixed. As yashrs said, you can just delete the files and drop the database. As for installation of software, download it from the maker's website, upload it, and unpack the archive in file manager. Then just follow whatever instructions it comes with for installation. If it gives you database errors, you'll need to ask the maker how to modify it to not use InnoDB tables. I'd avoid remote install scripts. I've used a few that got flagged as malware. Also, cURL causes quite a bit of load. If anything, it adds complexity and probably increases your chances of being suspended.

That account is not suspended.

It is indeed inactive. You can use this script to renew it: http://www.heliohost.org/home/support/scripts/renew

Use this script to change your main domain: http://www.heliohost.org/home/support/scripts/domain

The database server is up on Stevie at the moment. Did you change something recently? Check your configuration to make sure the username and password are correct, and verify that the database user is assigned in cPanel.

Can you reach your website and other services like FTP?

http://www.helionet.org/index/topic/18875-stevie-mysql-common-questions-and-problems/ See "Softaculous does not work properly". I noticed it 2 weeks ago myself when an installation vanished on me.

Even I haven't heard anything about repair progress in a few weeks, so I wouldn't expect a fix in the immediate future. I'm in the same boat as everyone else, frustrated by frequent downtime due to database issues. Unlike you guys though, I can't switch to a different DB like postgres or sqlite since my applications are mostly custom stuff.

Appears to be fixed.

That happens every few weeks. An admin will fix it shortly.

Your account was suspended for the following reason: Malware. 1 file(s). Win.Trojan.Agent-303721 FOUND That means that there are some malware files found on your account. For your safety and to protect your website from potential further corruption the account has been suspended. To find the infected files we recommend making a backup of your site, download the backup file to your computer, and scan the backup using a reputable virus and malware scanner. If you're having trouble locating the offending files please ask and we can provide more information. If you are you certain that it is a false-positive, we strongly encourage you to file a false positive form here: http://cgi.clamav.net/sendvirus.cgi Your account should be unsuspended now, but keep in mind that this is a temporary unsuspension. You have 24 hours starting at the time of this post to clean your account of any and all malicious files or your account will be resuspended.

I somehow got myself suspended for malware...rax on Stevie. The malware was "Heuristics.Phishing.Email.SpoofedDomain"...I unsuspended myself and ran an AV scan on a backup, found nothing. Can an admin tell me what file this was for?

No it cannot. If you weren't the one engaging in the phishing, odds are you were hacked and the hacker put up a phishing site. It's happened before. Either way, unsuspending it would let the phisher retrieve any stolen data that might have been collected. If you weren't doing anything that might be classified as phishing, I'd recommend that you create a new account and just abandon this one. If what you were doing could be mistaken for phishing, feel free to explain, although you will probably still need to create a new account. An admin might know what got the account flagged (for example an Abuse report). If you were phishing, illegal activity is not welcome here.

You just created it yesterday, so just give it more time. Johnny accounts can take up to 5 days to become active.

That's what I was thinking too...we do not condone nor allow our resources to be used to commit piracy, so it should removed if that's the case. Either way, proxies in general are a common source of high load. I'd recommend that you not run a proxy on our servers especially since there are thousands of them already in existence.

This support request is being escalated to our root admin.

Very few people (if anyone) knows much of anything about pgsql. What I can say is that the few times I have used it, my database also had things in them that I didn't own.

That account cannot be unsuspended.

Your account was suspended for causing high server load. I have unsuspended your account, but please try to limit the load you put on our servers as it slows down not only your site, but the sites of all other HelioHost users sharing your server. If you still see the suspended page, please clear your cache.

That's the FTP subdomains. Your site is just saveapet.heliohost.org which is showing an empty directory listing, so you should be good to go. Just upload the files into the public_html folder on your account. Name the home page index.html.

This topic is a reference for those having problems with the MySQL server on Stevie. Due to a crash in February, Stevie's MySQL server has been experiencing frequent errors and downtime. There are a variety of error codes and problems, and the solutions to each are different. Common Issues Error -2002 ("Can't connect to local MySQL server...") Issue: You're receiving Error -2002 or a message saying you cannot connect to the database server when you try to use certain mysql applications or when you try to log into PhpMyAdmin. Solution: The server is down. Wait several minutes and try again. The server goes down very frequently due to the damage associated with the crash in February, Error -2013 ("Lost Connection during query...") / Database error installing software / Error editing tables in PhpMyAdmin Issue: You receive error -2013 or a message saying the connection was lost during a database query when executing queries in phpmyadmin, when restoring a backup, or when installing various software. This error is caused by attempting to create or modify a database table (or data within the table) that uses the InnoDB storage engine. InnoDB was damaged during the server crash in February. As a result, you cannot edit the data within a table, nor can you create/alter/drop InnoDB tables (or drop any database containing these tables). Instead, you will need to use MyISAM for all database tables. Solution: Solutions vary for this issue. For software installation issues, you will need to seek help from the software developer on how to modify the installer to use MyISAM database tables. If you are trying to edit an existing database table, see the solution for "My site works, but I get database errors when I try to edit my content". If you have a backup that you want to restore, make a copy of your backup's .sql file, then use the solution for "My website works but I get an error when I edit my content", starting at Step 2. My site works, but I get database errors when I try to edit my content Issue: Your application is probably using InnoDB tables in its database. To check if this is the case, log into PhpMyAdmin from cPanel, then select the database for your website. In the list of tables on the right side, look for InnoDB under the Engine column. Solution: If this is the issue, you can convert your database to use MyISAM instead of InnoDB. To do this: Make a backup of your database through cPanel or phpmyadmin. You want a plain text (.sql) file. Open your new backup file in a text editor, then use the "find and replace" feature of your editor. Find all ENGINE=InnoDB and replace them with ENGINE=MyISAM Save and close the backup after editing. Create a new database in cPanel, then import the edited backup file into it using cPanel or phpmyadmin. Assign your website's database user to the new database in cPanel. Edit the config file for your website to use the new database. The exact procedure will vary based upon which software you use. Consult its documentation for information on setting the database name. Ignore the old database. Do not attempt to drop it. Roundcube and Horde don't work Issue: Roundcube and Horde use a database with InnoDB tables to track users and mail. Because of this, they won't work without InnoDB functioning correctly. The issue manifests as either a database error or an infinite redirect in Roundcube, and a "not authorized" message in Horde. Solution: Use another webmail client. Softaculous does not work properly Issue: Softaculous and many of the software programs it can install rely upon InnoDB database tables. Installation of software may not work properly. Any installations performed will not be displayed in Softaculous and cannot be removed through Softaculous even if the software installed successfully. This issue is most commonly seen when installing WordPress (one of the most frequently installed choices), although many other applications will cause errors as well. Solution: Install applications manually. If you wish to remove an application and the installation does not appear in Softaculous, simply remove the installation through conventional means. I dropped my database and now it appears in PhpMyAdmin but not in cPanel. Issue: These "half-dropped" databases result from attempting to drop a database containing InnoDB tables. Attempting to drop these databases also sometimes causes ~10 minutes of MySQL downtime for the server. Solution: Just ignore the unwanted database. There is no fix at this time. When the server has been repaired, an admin will be able to drop these databases for you. We recommend that you do not attempt to drop databases containing InnoDB tables at this time. By not trying to drop them, you will be able to drop them yourself when the server has been repaired. If you are experiencing a problem not described here or need additional help with the solution, please create a new topic in Customer Service.