Krydos

The postgresql user sis13_admin should now be able to connect to the database sis13_vava2017 remotely from any IP.

Does it work now?

There you go http://tamvan.men/ So, php-fpm was really broken on Johnny, and apparently has been for a while. This is the separate version of php that cpanel uses in the background for things like addon domains and phpmyadmin. It took quite a bit of tinkering and a full server reboot, but I think it's all working now. The problem was php-fpm was unable to start new threads due to too many files already being open. The process would wait and wait and wait for available file slots, and then either finally slowly work, or just fail completely from timing out. Anyways, mystery solved I think. Let me know if phpmyadmin works better now too.

Most of your load seems to be coming from /home/canicvs/public_html/chain-reaction/playGame.php

I've added it to my todo list.

So here's the thing. Most if not all free hosting other than us is owned by a paid hosting service. That sounds fine, but what ends up happening inevitably is you get pressured to upgrade from the free plans to paid plans. Most free hosts are completely unusable because they're so restricted, but you don't know that going in. You happily make your site and get everything the way you want it and then you find out something ridiculous like you only have 100mb total bandwidth allowed per month. They use all sort of other high pressure tactics to get you to upgrade other than just bandwidth though too. Anyways, what ends up happening is the "free" hosting ends up just being a scam basically to trick people into getting paid hosting. When you find out your website is unusable on the free plan your only choices are to just pay them what they're demanding or start over completely from scratch again somewhere else. Obviously most people just cough up the dough. Heliohost has always been different. We've always been truly free hosting with no gimmicks. The only limitations we put on accounts is to protect the integrity of our servers. We don't have the money or the man power to continuously buy more hard drives as we fill them so we can't offer unlimited disk space. We don't want to get our servers flagged permanently as a spam source so we throttle or suspend accounts that send more than ~50 emails per day without asking permission first and providing example emails to prove it's not spam. As I already explained the 30 day login requirement is just to prove that you're still using your account because our servers have a finite amount of room/resources and if an account is not being used we may as well delete it to make room for others. We're not trying to annoy you into paying, or forcing you to buy a paid plan. The other problem is we have been losing money the last couple years. That's why we've been asking for donations. We don't want to start offering paid plans for the reasons I've listed above. It goes against our philosophy, but donations are and have always been greatly appreciated. But how do you differentiate between a paid plan and donation driven plan? Money is exchanging hands for a service in either case. I guess it really comes down to donations can be whatever size you think the service is worth to you. Not everyone can afford to donate, we get that, but those who are willing and able should get some perks for being so generous. Long story short, we're going to try not to have set prices for things. The only reason we say it has to be more than a dollar at a time is so paypal doesn't take all of our money and leave us with nothing. I'll email you when we have the exact details of how this will work hammered out.

I've made some changes to the configuration of your account. Let us know if it does it again.

That page doesn't actually use sessions, or cookies, or anything. It just checks the status of your account, and verifies that your login credentials are correct to log in to cpanel before showing you that page. Just closing the tab, closing the browser, or even navigating to another page is sufficient to log you out. Do you think we should put a log out button there even though it wouldn't really be doing anything more than a link back to our homepage would?

Logging in every 30 days is how we check to see if you still need your website. Since we're a free hosting provider thousands of people create accounts and then never log in again. The system automatically suspends these abandoned accounts to reduce server load, and if the owner still doesn't renew their account they eventually get deleted to make room for other people who are still using their accounts. We're all for removing the annoyances of hosting a website on our service though. Since we've been struggling to pay the bills lately we've been brainstorming ideas to earn more revenue and donations. One idea is a user could set up a recurring monthly donation of any amount that they feel our service is worth from $1.00 USD or up. Much less than one dollar and paypal takes all of the money as fees so we don't get anything. As long as the monthly donation isn't canceled the recurring donor would never need to log in to their account again. If the recurring donation is canceled then you would go back to needing to log in once every 30 days or less. Is that something you would be interested in?

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

I should probably delete x3. Cpanel hasn't supported it for years, and Tommy is the only one of all of our servers that even has it anymore. Since cpanel doesn't support it anymore that means any relatively new features are going to be missing from x3. Plus all of the Heliohost custom plugins are only going to be written for paper_lantern too.

Thanks for pointing this out. It was a DNS issue. It should be working now. If it still isn't working for you it probably means that you have DNS cached.

If you run more than 2 cron jobs in a day all of your cron jobs will be deleted. Yeah, Tommy is much more stable. That's why we call him the stable server, and Johnny the unstable server. You can switch if you would rather have a server with better uptime.

Deployed. http://brassatom.heliohost.org/SpringClient/

If it only needs to be run once every 12 hours then you can use it the way it is with the cron page in cpanel. If you need it once an hour as you said earlier then you need to move your script to somewhere under public_html so it's accessible from a browser.

All I did was log in to your account and click "install ssl" just like you could have. There is nothing to resolve...

There you go https://grox.heliohost.org/

Tommy will need to have significantly fewer available free signups per day to keep from getting overloaded due to the extra high load services. Ricky will be a production quality server with free signups that should be open a lot longer than Tommy. We can't have another server like Tommy until we purchase another server. If we installed everything on Ricky that we have on Tommy it would barely even boot up probably. Tommy really is an amazing server. The main thing to keep in mind here is there is finite amount of space available on any given server. The more popular our service becomes the more money we'll make. The more money we make the more servers we'll buy. The more servers we buy the more users we'll be able to host without load getting ridiculous and uptime plummeting. There's only so many configurations we can make. Eventually our servers are going to be identical, and your choice is going to simply be determined by which server has more free space for your account.

The main difference is Tommy has Java/jsp/war, and ASP.net. Ricky will not have either of those. Heliohost users who want to experiment with php, java, aspx, ror, etc. that don't care too much about uptime can choose Johnny. Users who want java or aspx in a high uptime, high performance production environment should choose Tommy. Users who only want the basic lamp type setup (linux, apache, mysql, and php) should choose Ricky. Before Tommy if you wanted java, asp.net or ror you had to deal with high load and downtime. Our goal when purchasing the new server was to be able to provide high uptime production quality java, and asp.net while keeping the unlimited signups and experimental setup of Johnny. Ricky is essentially just the new Stevie. Because the vast majority of users just want php and mysql we can balance them between Tommy and Ricky.

No, because not everyone who uses mysql on our servers lives in Sao Paulo timezone. Just use this command in php: date_default_timezone_set("America/Sao_Paulo"); By the way you can do the simple queries I listed in my code with one mysql query. I just wanted to show you how to do a loop over each of your accounts because it seemed like it might be useful to you. update accounts set accounts.enabled = '0' where accounts.type = 'FREE' and accounts.reg_date < (date_sub(curdate(), interval 15 day));

You can only run it twice a day if you use the cron page in cpanel, but if you let us know the url of the script we can set up a cron to execute it once an hour.

Yeah, bdistler explained how to change the version of your php. Tommy already has php 7.0 and php 7.1 installed.

Yeah, but we can set up a remote cron job for you that can fire as often as every 5 minutes. You just need to set up a script like mydomain.com/cron/process_db.php and the remote cron will run the script every 5 minutes or however often you want. Here's some psuedocode to give you an idea: <?php // load up database details and password require_once(config.php); // create a database connection $con = new mysqli($db_host, $db_user, $db_pass, $db_data); // query for ids of accounts that are expired $sql = "select id from accounts where accounts.type = 'FREE' and accounts.reg_date < (date_sub(curdate(), interval 15 day))"; // execute the query $result = $con->query($sql); // store results in array $ids = mysqli_fetch_array($result); // cycle through each account foreach ($ids as $id) { // query to update $sql = "update accounts set accounts.enabled = '0' where accounts.id = '$id'"; // execute the query $con->query($sql); }

You can use a cron job to do what you're trying to do. I'm trying to help you set it up by figuring out what you're trying to do. https://dev.mysql.com/doc/refman/5.7/en/privileges-provided.html#priv_super You're not allowed to kill other users processes on a shared host. You're not allowed to purge our logs on a shared host. You're not allowed to change other people's global system variables. You're definitely not allowed to stop the mysql server. Etc., etc., etc. The good news is it sounds like you definitely don't need super privilege to do what you're wanting to do.

Well, you could have the license check occur each time the unity client connects to the database. That would probably be the best solution because then you wouldn't have to worry about someone buying your software and then not being able to use it until the scheduled event fires off 12 hours later.