Jump to content

Krydos

Chief Executive Officer
 View Profile  See their activity

  • Posts

    24,162

  • Joined

  • Last visited

  • Days Won

    849

 Content Type 

Everything posted by Krydos

  1. Krydos
    https://cloud.google.com/appengine/docs/java/config/webxml What do you think you need to email to me?
  2. Krydos
    FTP and webdisk are two ways to upload files to the server.
  3. Krydos
    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?
  4. Krydos
    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
  5. Krydos
    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.
  6. Krydos
    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.
  7. Krydos
    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
  8. Krydos
    What is the transaction ID?
  9. Krydos
    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
  10. Krydos
    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.
  11. Krydos
    The afheaton2 account has been deleted.
  12. Krydos
    If you don't own the domain you'd need to ask whoever does own it to set the NS records for you.
  13. Krydos
    Not necessarily. As long as the nameservers are ns1.heliohost.org and ns2.heliohost.org and the domain doesn't already exist in our system you can add it as an addon domain.
  14. Krydos
    Renamed back.
  15. Krydos

    Stevie Backup

    Krydos replied to mirandat's topic in Questions

    There is no account in our system that used that email address.
  16. Krydos
    Yes. That's because your username already exists on this forum. Let us know once your account is created and we can change your forum username back.
  17. Krydos
    Sent.
  18. Krydos
    That's odd. SFTP on Tommy is still working for me just fine. Try going to https://tommy.heliohost.org:2083/frontend/paper_lantern/passwd/index.html and change your cPanel password. Can you log in after changing your password?
  19. Krydos
    You don't need to delete your account. Everything is already set up for you to create your new account. We can help you restore your backup once your account is created, but we can't create your account for you because we don't have access to check your email. I'll walk you through it step by step: Go to https://heliohost.org/signup/Enter your email addressCheck your email and click the link in the emailSelect the features you're interested in like php and click nextIf signups are available you'll be able to select Tommy. If not you'll have to wait until midnight UTCType your username, like 'sylvain'Type your domain, like 'sylvain.heliohost.org'Type your password twiceCheck the box if you agree to the terms and click next through the next few screensClick refresh a few times until your account is createdLog in using your username and password from aboveClick 'Continue to cPanel'Click 'File Manager'Click uploadClick select fileLocate your latest backup file, or the file you downloaded from https://heliohost.org/backupLet us know once you've gotten there or if you need more help. I'm not sure how that would work. Perhaps Ashoat could post his mailing address or create a PO box for mail? It would have to be up to him if he wanted to do that. That's a really good idea. I already had it on my todo list, but I hadn't gotten around to it yet. Thanks for the reminder.
  20. Krydos
    Any additional directory to add would just get appended on the end of the command like /bin/tar zcvf /home/cpUsername/backup.tar.gz *.sql public_html/* directory2/* directory3/*
  21. Krydos
    Do you get that error when you log in, or when you change directories, or when you upload something, or when you change permissions, or when?
  22. Krydos
    Unfortunately that means that the portion of the hard drive that your account was located was too corrupted to create a backup. You'll just have to use your most recent backup instead.
  23. Krydos

    Stevie Backup

    Krydos replied to mirandat's topic in Questions

    Thanks for letting us know. The account that stores the backups had gone inactive since no one had logged in to it for 30 days. Does the link work now?
  24. Krydos
    Thanks for letting us know. The account that stores the backups had gone inactive since no one had logged in to it for 30 days. Does the link work now?
  25. Krydos
    Thanks for letting us know. The account that stores the backups had gone inactive since no one had logged in to it for 30 days. Does the link work now?
×
×
  • Create New...