wolstech

Take a look at https://www.helionet.org/index/topic/28921-triggering-a-file-on-arrival-of-email/ (that person was using a Tommy account, but it works the same on Johnny as well, just change the server name in the URLs listed). When the server receives the email, it launches a configured program (such as a PHP script), and uses the email itself as the input. This way, there's nothing running at all until an email is received. When the email is received, it's immediately processed, then the script exits. The mail server itself is monitor as opposed to running something repeatedly.

Is the mailbox hosted here? If so, you could also just configure the email address to pipe the mail directly into the processing script when it arrives.

Please clear your cache.

You're looking for subdomain delegation... If you use cloudflare as the DNS, I think you can do this. You should be able to set it up through cPanel (use a "full" zone setup so it copies all of our records to make the initial zone), then log into cloudflare directly and add NS records for the relevant subdomains. After that, point your domain to cloudflare at your registrar.

You likely just need to remove this: DEFINER = `root`@`localhost` From the CREATE statement so the procedure is created using your account.

We run Linux...ASP.NET is a Windows technology. Mono is the runtime used to run .NET code under a linux OS. For a list of what's compatible between .NET and Mono, see http://www.mono-project.com/docs/about-mono/compatibility/

Escalating.

You can't do it yourself. You need to write the PHP script you want to run, upload it somewhere in your pubilc_html, and post the URL to the script here. Once you do, I'll pass it along to the root admin so a root admin can set it up for you.

Yeah, he saw a bit of a load spike. You can see the oranges fading away on the load bars right after he came back up. If you're curious, it was an abusive user who caused 4153% (!!!) more load than the second heaviest user. He got suspended for it. We apologize for the inconvenience.

ASP.NET should be compatible with .NET 4.5 on Tommy. Be aware that it's Mono though. There might be a few differences.

Cron is limited to 2 executions a day, so no. The most you could do is a single job every 12 hours. If you put the script somewhere accessible by browser, we can set up a call to the URL that runs every 4 minutes though.

Renamed.

You shouldn't need to since the root admin gets an email when you donate so he knows to send the invite. If the invite never arrives due to spam filters though, you can post your transaction ID and it can be resent.

https://heliohost.org/donate/ Once you donate, you'll get an email within 24 hours containing a link to create a tommy account (the root admin sends them manually, so they're not instant). Minimum is $1 USD. Anything smaller and we lose it all in fees (you'll get a refund if this happens).

It fills very quickly (within 30 minutes typically). It goes by number of accounts, not time, so some days fill quicker than others. It was actually open for an hour tonight. On Sunday it was open for 6 hours. On Thursday last week, it lasted <15 minutes. Our record is 9 seconds ("everybody mashed F5 at once"). You can see the periods of time when it was open here: http://heliohost.grd.net.pl/monitor/ If staying up to midnight and trying repeatedly isn't viable for you, you can also donate $1 and get an account that way.

Yes. It resets every night at midnight UTC. For you, it should be right at midnight since you're in the UK.

Marking solved per request.

Krydos hasn't been around to take a look at it, likely due to the weekend. Hopefully he'll stop by in the next 24 hours. Also, while this DNS issue might be our problem, Freenom is having some sort of problem lately. We had another 2 users with the "NS records were missing despite being set" issue for freenom domains earlier.

It's archived. Escalating to have it restored.

I've renamed your forum account to fuzmic2 so you can reuse your username when you register. Please note though that you won't be able to register until you receive the invite email. You have to use the special link contained in that email to register on Tommy since the free registrations are not open.

WAR files usually get deployed with the username in front of them, so it'll likely be at http://infotecq.heliohost.org/infotecq_lab5/ Deployment can only be done by one person (Krydos), so you have to wait for him to do it. He usually works the Escalated bin once or twice a day.

Have you already donated? If so, please post: Your transaction IDThe username of your existing Johnny account so we can move it (or make the username reusable if you've deleted the account).If not, you should donate through PayPal or Skrill using the buttons on the page at http://heliohost.org/tommy/. If you've deleted your account, be aware that it can take up to 24 hours for the email with the link to create the new Tommy account to arrive.

Actually, if you use http://heliohost.org/tommy/, you should NOT delete your account. We'll just move it for you. Be aware that getting a Tommy account this way is not free though (a donation of $1 USD or more is required). If you decide to donate, please let us know your Johnny account's username and your Paypal/Skrill Transaction ID and I can have it moved. If you want to move for free, you'll need to delete your account. This will delete all of your data, so back up anything you want save first. Deleting your hosting account does not delete your forum account. After deleting your account, wait several hours, then go to https://heliohost.org/signup/ and register when Tommy registrations are open. They open at midnight UTC every day and fill quickly. Please note you will not be able to reuse your username without an admin's assistance. If you want to reuse your username, let us know and we can rename your forum account so the username can be reused for the Tommy account.

Do some research on "SQL injection". Basically, the issue is that you allow your users to enter data that's then directly sent to MySQL without being checked for MySQL's reserved characters/commands. There's nothing stopping someone from putting SQL commands in one of those inputs. Once someone does that, PHP just happily inserts their code into yours, MySQL runs it, and all sorts of things can happen. For example, lets assume a simple search. In the below, $query is whatever a user types in a search box: SELECT * FROM data WHERE `text` LIKE ('%$query%'); In normal cases, this is fine. If "code" was searched, you'd get queries like this after the variable is filled in: SELECT * FROM data WHERE `text` LIKE ('%code%'); The above returns every result where `text` contains "code". This is what's supposed to happen, and a site with this code would work as expected. Now, let's be evil...I type this in the search box: '); DROP TABLE users; -- This results in the query becoming the following: SELECT * FROM data WHERE `text` LIKE ('%'); DROP TABLE users; --%'); That query gets sent to the server, and the server happily runs each of the queries listed, in order. The server will return everything in data where `text` is % (wildcard meaning "anything"), then drop the users table. You then come back later and wonder where your users table went...

I'm fairly certain that Cpanel doesn't support it. Krydos will know for sure, but you may end up needing to use CloudFlare or similar to do this.