wolstech

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.

You install it like any other application. It needs a folder inside of public_html so you can access it from the web. After that, follow the instructions it comes with to configure it. I'd also recommend password protecting that folder in cpanel.

Perhaps the webdisk or FTP client are using an old password saved somewhere? Those types of applications will often try over and over to connect when they fail. The brute-force should clear on its own with time. If it doesn't, an admin can reset it for you.

As yashrs said, you can run your own copy if you prefer a different version. Database server is localhost, use your cpanel credentials as the username and password. As for the 4.1+ PMA versions in general, I actually don't like them. 4.0 was OK although not great, and then it became very bloated when everything in it started using AJAX. 3.x has an option to disable all that javascript junk and have a traditional post-back-based application...I much prefer it over AJAX any day. They removed that option in v4 for some reason. Also, please stop asking us to upgrade things. We're aware of the newer versions. So far, you've asked us to upgrade mysql, php, apache, and phpmyadmin. While the concern about old versions is appreciated, we're using them for many reasons, the biggest of which is because some programs are not backwards compatible (PHP 5.5 is a good example), and upgrading requires time to make sure things won't break and to fix the things that do. If you like newer versions, you should consider Johnny since that's where new stuff will usually appear first when we get it. All of them are somewhat newer over there now, although by rather minor versions.

I keep getting malware warnings from 2 different AVs (AVG and Malwarebytes) when trying to open either of those. Alert is a connection to malicious IP address 31.170.163.172 from malwarebytes and malicious JS file from AVG. Please look into this. Homebux.com.br is not queued though. In fact, it's not even be hosted here. Homebux.heliohost.org does not appear to be valid (it won't resolve).

That periodic MySQL downtime sounds like Stevie in general these days. My site does that too...spitting out "FATAL: cannot connect to database server" half the time. No fix except to wait, and there's no estimate on the repair time as far as I know. I'll agree it is very frustrating.

The 500 error could be a lot of things. The most common causes are errors in htaccess, hitting your process limit (usually being logged into cPanel does it), or high server load. The database error could be the db server being down, which it is quite a bit these days, or a configuration error like a bad password. If it comes and goes on its own, odds are the server is just down. The domain mapping issue is odd...did you change your main domain and include the www by mistake, then change it again to correct it? If so, you need to recreate the subdomains.

The downtime and inability to edit your posts are related to the database crash in February. The database server downtime is unfortunately normal on Stevie for the moment, but the inability to edit posts sounds like InnoDB tables. You can check for InnoDB tables by going into phpmyadmin and selecting your database. In the list of tables, see if any of them show InnoDB in the "Engine" column. If they do, you should convert your database tables to the MyISAM engine. To do that: Make a backup of your database through cPanel or phpmyadmin. You want a plain text (.sql) file. Open backup file in a text editor, then do a find and replace. 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 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 name. Ignore the old database. Do not attempt to drop it. Also, for what it's worth, right now that account's main domain won't resolve for me. Is that the site you're referring to?

That error is likely because you're creating an InnoDB table or importing a schema that includes InnoDB tables. InnoDB does not work on Stevie due to damage from a crash in February. Modify the schema to use MyISAM tables and the error will go away.

Johnny is really slow or down a lot, usually due to excess load. Uptime is only like 80-85% compared to Stevie's 99+%. Johnny is often down multiple times per day. If you check the server monitor site, you can see the difference in load and uptime. It's due to the fact we offer more features on it, allow each user to use more resources, and have more users in general on it since the sign ups aren't limited. On the upside, MySQL isn't broken on Johnny. If you need any kind if reliability or uptime, which it sounds like you do, do NOT move to Johnny.

Good to see the FTP issue is cleared up. As for the database issues, the connection issue and inability to drop databases are all related to the crash Stevie experienced in February. Unless you want to move to johnny, there is currently no fix for any of them. You will need to not use innodb, ignore the extra databases that won't drop, and tolerate the MySQL server downtime.

The database issue has no fix right now. Just ignore the extra database in phpmyadmin. Once Stevie's MySQL is fixed, an admin will need to drop it for you. The FTP issue sounds like either you using the wrong host, or port 21 being blocked on your end. What settings are you using (host and username)?

That site is working fine. I see this: http://imgur.com/YjXrjP3 Clear your cache again, and if it still does not work, try a different internet connection.

Not sure what was up with this one. It was showing as active but was actually suspended... Your account has been unsuspended.

Error 1045 is Access Denied, so likely a password or suspension-related issue. Try it again now. If it still doesn't work, try changing your password in cPanel. When you change it, be sure the box for "allow MySQL password change" is checked. After that, log out, then back in and try again. .

@yashrs: actually it's the other way around. A records do NOT work if you use it as an addon or parked domain (it won't let you add it). You need to set it as your main domain to use an A record. Also, proudlyb, please do not TYPE IN ALL CAPS, do not repeat the same thing 6 times, and please use proper grammar. It is quite difficult to understand you. If it is not working, it isn't set up right. What are you seeing when you visit your site, what is your username, and what is your domain?

CSS is another language used for describing the appearance of elements on a website. It sounds like your book should cover it. Font tags are commonly used in books for beginners because they are easy to understand and eliminate the complexity associated with CSS. They technically shouldn't be used anymore on published sites because they are from an older HTML standard, but that's not to say they won't work, as all major browsers still understand them. Since you're a beginner, you might just want to keep the font tags for now.

Our name servers are ns1.heliohost.org and ns2.heliohost.org. Do note though that NS2 is often slow to respond (or down entirely) because it is located on the same server as Johnny. Some people have reported trouble adding it to a domain because their registrar verifies it's availability. If this happens to you, your website will work fine with just NS1, and you can try adding NS2 again later.

Your account was suspended for inactivity, because you haven't logged into your account in the last 30 days. To reactivate your account, please visit http://www.heliohost.org/home/support/scripts/renew. To prevent this from happening in the future please remember to visit http://heliohost.org/ to log into your account at least once every 30 days. If you are still seeing the Account Suspended page after renewing your account, please clear your cache.

The innodb tables are read-only, so you won't be able to remove their records. If you have any MyISAM tables mixed in with the innodb tables though, you can remove the records from those particular tables (or drop the MyISAM table entirely.)