Jump to content

Krydos

Chief Executive Officer
  • Posts

    24,562
  • Joined

  • Last visited

  • Days Won

    869

Everything posted by Krydos

  1. 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.
  2. 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.
  3. 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));
  4. 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.
  5. Yeah, bdistler explained how to change the version of your php. Tommy already has php 7.0 and php 7.1 installed.
  6. 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); }
  7. 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.
  8. 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.
  9. 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?
  10. What kind of event are you trying to schedule? Is it something that runs once a day or something?
  11. What domain are you referring to? Posting some actual information instead of obscenities would be helpful.
  12. 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.
  13. 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
  14. 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.
  15. 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.
  16. /home/kamu/public_html/fb.php has been deleted and your account has been unsuspended.
  17. If you want any IP to connect to the database then put a % there instead of the IP.
  18. The script that was causing heavy load is /home/kamu/public_html/fb.php Which appears to be a facebook bot liking script.
  19. Tommy's smtp certificate is fine https://www.sslshopper.com/ssl-checker.html#hostname=tommy.heliohost.org:465 mail.abdu.io doesn't have an ssl certificate installed https://www.sslshopper.com/ssl-checker.html#hostname=mail.abdu.io See how it says nossl.heliohost.org? Go to https://mail.abdu.io/ and approve the incorrect certificate and there are instructions on how to install an ssl certificate.
  20. It could be that you don't have reverse dns set up on your domain. Some email servers, most notably AOL, refuse all email from any domains that don't have a valid ptr record. It could also be that the inbox that you're sending to has a filter that any address that isn't in their contact list gets sent to spam. Since you use cloudflare you won't be able to use mail.abdu.io because cloudflare isn't proxying your mail connections correctly. You can either change the cloudflare settings or just use tommy.heliohost.org as your smtp/imap domain.
  21. Probably before since it's an apache module. Test it out and let us know.
  22. When you include a php script into another php script as far as the server is concerned it just copy/pastes the code from the included file into the spot where the include/require command is and run the script with the permissions of the called php script. So what matter here is that the read flag was set. If you were to curl to another php script or use something silly like exec("script.php") then the permissions of that script would matter. Suphp cares a lot about permissions and if they're a little off it just shuts down with a 500 error.
  23. 428.74 MB is the size of all of your databases summed.
  24. The wait on Tommy for java is only a few hours.
  25. http://lillianday.com/thething.php works for me.
×
×
  • Create New...