-
Posts
25,179 -
Joined
-
Last visited
-
Days Won
900
Everything posted by Krydos
-
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/
-
Opinions Wanted: Php Version For Upcoming Server
Krydos replied to wolstech's topic in Customer Service
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. -
Opinions Wanted: Php Version For Upcoming Server
Krydos replied to wolstech's topic in Customer Service
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, 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.
-
So the first time a particular client/account connects the database stores the start timestamp, and then each time they connect it checks the difference between now() and the registration date to see if it exceeds their license period? Does the on or off bit need to update once a day or more often?
-
What kind of event are you trying to schedule? Is it something that runs once a day or something?
-
What domain are you referring to? Posting some actual information instead of obscenities would be helpful.
-
The database flm_dds1 should now be accessible by the potgresql user flm_postgres from any IP. Let us know if you still can't connect.
-
Aspx is working on Johnny for me: <%@ Page Language="C#" %> <% HelloWorldLabel.Text = "ASP.NET is working."; %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" > <head runat="server"> </head> <body> <form id="form1" runat="server"> <div> <asp:Label runat="server" id="HelloWorldLabel"></asp:Label> </div> </form> </body> </html> http://krydos2.heliohost.org/test.aspx
-
Any domain that you add to Johnny can take up to 24 hours to start working, and in the meantime will show the queued page.
-
From what I understand flask is used primarily on home computers where you might not have access to a mature tested apache server to test your python web scripts in a fully python environment. As soon as someone explains why they need flask to do something that django/apache cgi can't already do I'll be listening. Apache configuration can be daunting and complex. I get it. I'm the one that configures it, but the main advantage to flask is being able to run a janky webserver super easily by simply running the command ./runserver, but you really don't need that if you have a real http/https server.
-
/home/kamu/public_html/fb.php has been deleted and your account has been unsuspended.
-
If you want any IP to connect to the database then put a % there instead of the IP.