Krydos

I've actually considered providing a free service like setcronjob that would run from Cody and hit scripts on people's hosting accounts at whatever frequency they wanted. There wasn't really a demand for it though since there were so many free options. The issue with cron jobs usually isn't load, but how powerful shell commands can be through cron. When you access a script remotely it has all the same load and access limitations of any php or cgi script. @kotha, if you can't find a free service let me know the url of the script you want accessed every half hour and I can set it up manually for you.

+-----------+---------------+ | host | user | +-----------+---------------+ | % | dobmkawe | | % | dobmkawe_najm | | localhost | dobmkawe | | localhost | dobmkawe_najm | +-----------+---------------+ Your remote mysql is set up correctly, and remote mysql definitely works on Tommy. My best guess is that port 3306 is probably blocked on your computer.

We'll need to delete the backups when Tommy's hard drive starts to get too full. We're not going to prevent people from creating accounts on Tommy simply because we have too much backed up data from old accounts. That's how Heliohost has always operated. We delete the oldest unused information as we need more space for new accounts.

Do you want your invite sent to your Helionet contact email address or somewhere else?

Heliohost users are allowed to run 2 cron jobs per day. I would recommend using a free service like https://www.setcronjob.com/ to execute your script every 30 minutes.

Don't know exactly. I changed it and everything worked, and files uploaded at 644 correctly. Then I updated some software on Tommy and I think openssh was updated, and then SFTP stopped working for anyone without shell access, but as soon as I reverted my permissions mask edit in the configuration file everyone without shell access can connect again.

Yeah, I had to remove the permission mask because no one could connect to SFTP anymore with it in place. Which would you rather have? Access to SFTP at all or have to right click and change all permissions once?

I just rebooted the ftp server on Tommy. Let us know if this helps. Does it work now?

We actually recommend https://www.heliohost.org/login/ or https://tommy.heliohost.org:2083/ because 2082 in the link above is insecure and unencrypted.

Just let us know by making a public post if you send any of us PMs. I don't know about anyone else, but I never check PMs unless someone tells me they sent me one. Here at Heliohost we like to provide support in a publicly accessible way so anyone who has the same or a similar issue in the future can search. That reduces the work load for the admins considerably.

Here's a good list https://en.wikipedia.org/wiki/List_of_free_and_open-source_software_packages

Here is the documentation for webdisk https://documentation.cpanel.net/display/ALD/Web+Disk If you connect to it via ssl on port 2078 it is secure. However, you're responsible for securing your own devices.

The first day after we started tracking how long signups were available for it filled in 6 seconds. Since then signups have been available for almost 3 minutes sometimes.

https://cloud.google.com/appengine/docs/java/config/webxml What do you think you need to email to me?

FTP and webdisk are two ways to upload files to the server.

In Filezilla go to Edit >> Settings >> Debug and set the Debug information level to '3 - Verbose'. Then try connecting again and post the log. Also, could you try connecting to SFTP with some client other than Filezilla to see if that works?

You only have to restart it if you add a new .jar file. Just changing the code will update on it's own. How often are you going to add new .jars? Right now you have any url being rewritten to giteshssroti.tk. Try this .htaccess code which should only redirect non-ssl http://giteshsshroti.tk/ to https://giteshsshroti.tk/ which is what I think you're trying to do, but it will leave http://giteshsshroti.heliohost.org/ alone: RewriteEngine On RewriteCond %{HTTP_HOST} ^giteshsshroti\.tk [NC] RewriteCond %{HTTPS} off RewriteRule ^(.*)$ https://%{HTTP_HOST}%{REQUEST_URI} Regarding aspx connection to mysql: Create a new file such as mysql.aspx with the contents: <%@ Page Language="C#" %> <%@ Assembly Name="MySql.Data" %> <%@ Import Namespace="System.Data" %> <%@ Import Namespace="MySql.Data.MySqlClient" %> <script RunAt="server"> void Page_Load(object sender, EventArgs e) { MySql.Data.MySqlClient.MySqlConnection conn; conn = new MySqlConnection("Database=giteshss_db; Data Source=localhost; User Id=giteshss_user; Password=password123;"); conn.Open(); MySql.Data.MySqlClient.MySqlDataAdapter myDataAdapter; myDataAdapter = new MySqlDataAdapter("select * from aspx", conn); System.Data.DataSet myDataSet; myDataSet = new DataSet(); myDataAdapter.Fill(myDataSet, "aspx"); string text = myDataSet.Tables[0].Rows[0]["data"].ToString(); myLabel.Text = text; conn.Close(); } </script> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "[url=http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd]http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd[/url]"> <html xmlns="[url=http://www.w3.org/1999/xhtml]http://www.w3.org/1999/xhtml[/url]" > <head RunAt="server"> <title>ASPX MySQL Test</title> </head> <body> <form id="form1" RunAt="server"> <div> <asp:Label id="myLabel" RunAt="server"/> </div> </form> </body> </html> Working example is located at https://krydos.heliohost.org/mysql.aspx

Source: http://wiki.helionet.org/Java_Servlet#Upload_The_.war_File EDIT: Users can now deploy their own .war files through the cpanel Java button once you have requested java access and it has been enabled.

Just make sure you have a strong password and it's reasonably safe. It's not like you're storing top secret national espionage in your database or anything. Take regular backups, and if someone manages to get in you can just drop the database, change the password, and import your latest backup. Regarding the mysql.jsp: When you put .jar files in your WEB-INF/lib/ directory Tomcat has to be restarted before it will find the files. Just ask me to restart it for you. After restarting Tomcat the errors went away, and it just showed a blank page since your query was looking for a column called data which your database didn't have. I updated your index.jsp for you so it looks like this now to match the columns you had entered <sql:setDataSource var="mysql_test" driver="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost/giteshss_db" user="giteshss_user" password="password123"/> <sql:query dataSource="${mysql_test}" var="result"> SELECT * from java; </sql:query> <table> <tr><th>Name</th><th>Age</th><th>City</th></tr> <c:forEach var="row" items="${result.rows}"> <tr> <td><c:out value="${row.name}"/></td> <td><c:out value="${row.age}"/></td> <td><c:out value="${row.city}"/></td> </tr> </c:forEach> </table> Here is the working test http://giteshsshroti.heliohost.org/mysql.jsp By the way, your .htaccess file was redirecting all requests to your .tk domain resulting in 404 errors so I renamed it .htaccess-old so I could actually see the /mysql.jsp/ directory.

My preferred way to access databases is on the command line. If you enabled remote access you can type something like this on your home pc mysql --host=tommy.heliohost.org --user=username --database=username_db -p It will then prompt you for the password, and you'll get a mysql> prompt where you can run commands like show tables; describe tablename; and various other queries. Regarding java connecting to mysql: Download https://krydos.heliohost.org/mysql.jsp/WEB-INF/lib/jstl-1.2.jar Download https://krydos.heliohost.org/mysql.jsp/WEB-INF/lib/mysql-connector-java-6.0.5.jar Upload both of those files to public_html/mysql.jsp/WEB-INF/lib Create public_html/mysql.jsp/index.jsp with the contents: <%@ page import="java.io.*,java.util.*,java.sql.*"%> <%@ page import="javax.servlet.http.*,javax.servlet.*" %> <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%> <%@ taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql"%> <!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> <title>JSP MySQL Test</title> </head> <body> <sql:setDataSource var="mysql_test" driver="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost/giteshss_db" user="giteshss_user" password="password123"/> <sql:query dataSource="${mysql_test}" var="result"> SELECT * from java; </sql:query> <c:forEach var="row" items="${result.rows}"> <c:out value="${row.data}"/> </c:forEach> </body> </html> Here is the live example https://krydos.heliohost.org/mysql.jsp

What is the transaction ID?

Oh sorry, I thought we were talking about a .com or some other purchased domain. You can't have two domain.heliohost.org domains on the same account... ...without help. Here you go http://mirandaterlaak.heliohost.org/ Put your files in public_html/mirandaterlaak

Yeah, you can go to https://tommy.heliohost.org:2096/ directly or go to https://tommy.heliohost.org:2083/frontend/paper_lantern/mail/pops.html click the more dropdown next to the email address, and select webmail.

The afheaton2 account has been deleted.

If you don't own the domain you'd need to ask whoever does own it to set the NS records for you.