Search the Community
Showing results for tags 'database'.
-
Hi, I've noticed that at some point, why does the data inside the database table getting deleted even though i did nothing? It seems like there's an issue here but i don't know why it happens.
-
database: chrislyt_CRL_DB connection url: jdbc:postgresql://johnny.heliohost.org:5432/chrislyt_CRL_DB Is it possible to extract the DB data in case this will continue for more days? -
Dear sir/madam, Recently, I have created a database with my Tommy account and wanted to connect it with my Lily ASP.NET website. I have managed to receive the data from the SQL database when I open the website locally but when I publish the website to the server and try to open the page with the SQL database records, I get an error (see picture). Could somebody help me to resolve this error? Thank you in advance. Yours faithfully, Robin (nickname: novafox)
-
I want to access my postgre sql from external but I don't really know how can someone provide me some informations and enable external access please. primary domain: cryptex.heliohost.us database name: cryptex_userdata database user: cryptex_admin
-
Hello, I'd like to connect to my database remotely. database: eitan27_<removed> user: eitan27_<removed> host: ricky I am getting: OperationalError: FATAL: no pg_hba.conf entry for host "...", user "eitan27_<removed>", database "eitan27_<removed>", SSL off This should mean that this user needs to be whitelisted for remote access. I would also request that this post be removed or edited after be issue is resolved. (I'm happy to do that, so long as I have privileges to, in order to not expose the host & username to the broader internet). Thanks!
-
Have a nice day. I have the problem that I can't connect remotely to the postgres database I've made My connection parameters are database: enesonme_upcycling user: enesonme_local host: johnny.heliohost.org And the command from debian I'm using is: psql -h johnny.heliohost.org -p 5432 -U enesonme_local -W pwd -d enesonme_upcycling Then the connection responds: psql: FATAL: no pg_hba.conf entry for host "your ip", user "enesonme_local", database "enesonme_upcycling", SSL off I need help. Thanks
-
Username: kikiEmail Adress: christianvelazquezalvarez@gmail.comHosting: christian.heliohost.org / Domain name: christianenremoto.tkServer: Tommy Hello! Is it possible to activate my account? Suddenly, you have blocked it. I use it for exposure and testing. And I intend to delete the internal scripts that can overload the web (and the hosting). I have donated before and I just want to regain access and service. Thank you. Merry Xmas, crew!
-
Hi, Please can you assist me with enabling remote access on my PostgreSql database? I've tried to connect with pgAdmin4, and enters the following information: Name: slimsim_ava_db_dev_1 Host name / address: johnny.heliohost.org Port: 5432 Maintenance database: postgresql Username: slimsim_db_user This is error i get when trying to connect: Unable to connect to server: FATAL: no pg_hba.conf entry for host "92.34.255.150", user "slimsim_db_user", database "postgresql", SSL offThanks!
-
Hello, I would like to have remote connections enabled for any ip to my postgres DB please. username: bee1 db: bee1_sensor_data Let me know if you need anything additional, thanks!
-
user: quagesh_mainbot database: quagesh_popheads host: johnny.heliohost.org if you could enable access for all ips it would be much appreciated, thank you so much in advance!
-
Hello, I would like to be able to access my PostgreSQL database from outside Helio. What do I have to do to make that happen?
-
Hello! May I have an from-outside-access to my helio postgre db? Can't host data on local db, need to share access with some other people. Parameters: GENERAL INFORMATION:Current user: andreikuhost: johnny.heliohost.org:2083 POSTGRESQL INFO: database: andreiku_student_platform user: andreiku_db_admin Can provide more information if needed.
-
Is it possible to create a database through MySQL commands using PHP here? Look at this situation: I want the clients to create a database with the click of a button, containing several preset tables, using SQL commands inside PDOs in PHP. That being said, I want those databases to be created automatically, because this is part of a customized simple application.
-
I'm unable to connect to database. Following are my account details: Control Panel Username: sidsk99 Main domain name: sidsk99.heliohost.org Kindly help with this issue.
-
this is code of dbconnection.java file which is inside my javaee webapplicataion my web application is hosted on heliohost package Database; import java.sql.Connection; import java.sql.DriverManager; public class DbConnection { public static Connection getconnection() { Connection con=null; try { Class.forName("com.mysql.jdbc.Driver");//load the driver //Create the connection //Connection is an interface //Drivermanager is a class and getConnetcion()is a static metod of DriverManager class whose return type is Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/yo52674_wp678"+"?verifyServerCertificate=false&useSSL=false&autoReconnect=true&useUnicode=true&characterEncoding=utf8","yo52674_R","<removed>"); } catch(Exception e){ System.out.println(e); } return con; //return the connection } } my web application is trying to connect heliohost mysql database but it can only connect and perform queries when my heliohost phpmyadmin page is open after when i close php my admin it gives me error e Exception Report Message An exception occurred processing JSP page [/userregact.jsp] at line [17] Description The server encountered an unexpected condition that prevented it from fulfilling the request. Exception org.apache.jasper.JasperException: An exception occurred processing JSP page [/userregact.jsp] at line [17] 14: //String feedback = request.getParameter("feedback"); 15: Connection getconnection = DbConnection.getconnection(); 16: //String sql=; 17: PreparedStatement st = getconnection.prepareStatement("insert into user values(?,?,?,?)"); 18: 19: st.setString(1,username); 20: st.setString(2,password); Stacktrace: org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:584) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:481) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:386) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:330) javax.servlet.http.HttpServlet.service(HttpServlet.java:742) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) Root Cause java.lang.NullPointerException org.apache.jsp.userregact_jsp._jspService(userregact_jsp.java:147) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) javax.servlet.http.HttpServlet.service(HttpServlet.java:742) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:443) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:386) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:330) javax.servlet.http.HttpServlet.service(HttpServlet.java:742) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) Note The full stack trace of the root cause is available in the server logs. Apache Tomcat/8.5.24 this is code of dbconnection.java file
-
Connection details: Host: johnny.heliohost.org Database: jongonza_prototype User: jongonza_prototype_user Remote connection with DBeaver client fails with: FATAL: no pg_hba.conf entry for host "<IP>", user "jongonza_prototype_user", database "jongonza_prototype", SSL off -
i get this error when i acccess mysql databases through cpanel my account is very new: https://i.imgur.com/xYMBxTg.png Error while connecting to MySQL: (XID w7mbus) The system failed to connect to the “MySQL” database “mysql” because of an error: CR_CONNECTION_ERROR (Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)) Error while connecting to MySQL: (XID w7mbus) The system failed to connect to the “MySQL” database “mysql” because of an error: CR_CONNECTION_ERROR (Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)) at /usr/local/cpanel/Cpanel/Mysql/Basic.pm line 391, <STDIN> line 1. -
Hi. I changed my password twice on Johnny. But from that moment on, I've never been able to connect to my database. This message shown on the top there: Error: SQLSTATE[HY000] [3118] Access denied for user 'munny'@'johnny.heliohost.org'. Account is locked. I'd like to know what I chould do to solve this problem as soon as possible. Thanks! -
Hi again, I need help connecting my flask app to the postgres database on the server. PS. I'm not trying to connect from outside although having remote access would be a bonus username: geojoe database: geojoe_flask-app database user: geojoe_admin server: Tommy Issue 2: how do I hide the flask.wsgi from urls e.g instead of flask.geoffery.ml/flask.wsgi/login, i want it to be flask.geoffery.ml/login thanks in anticipation
-
Hi all, Something weird happened just now and I'm a little freaked. Three things, actually. Some background: I run a Ghost site on Heroku, which uses a HelioHost database via "remote MySQL". Today, the site failed to startup due to an application timeout, which I assume was a timeout while trying to connect to the database (it was working fine in the morning so I can't think of any other explanation). When I tried to sign in, the password was rejected thrice. That might have been just me in a panic, but I know what my password's supposed to be, so was wondering if someone's broken in and changed it. In any case, I reset via email to a different one. After signing in, I tried opening phpMyAdmin to test the database, but it fails with an error: As a side note: Tommy's cPanel seems much slower than usual. This might be unrelated, but it may also explain all the errors (maybe the password checks and database calls all timed out). If possible, would you admins be able to do the following: Send me IPs and login times for my last 3 cPanel logins (I got the last one's IP, but I'm travelling so would need a couple others to compare). Maybe also password reset logs or something to see if there's anything suspicious.Look into phpMyAdmin and remote SQL and see if others are having issues tooNot sure what else, but maybe something in the syslogs to indicate what may be happening?Thanks in advance! -
Hi everyone, Regarding the PostgreSQL database we can have on Johnny, two questions: Which size does it actually have? I can see 1,000 MB from my cPanel but I wonder if this is the actual size it has. If so, could it be extended in the future?How many concurrent connections does it support?Thanks in advance! Kind regards.
-
Hello, After Johnny's server upgrade I've started receiving this error whenever I try to connect remotely to my database: FATAL: no pg_hba.conf entry for host ..., user "gabfam_BTAU", database "gabfam_BTA", SSL off Could you please give me remote access again? Thank you. Server: Johnny Database Name: gabfam_BTA User: gabfam_BTAU
-
Hello! I'm trying to instal a small "program"/database (=>http://robertmanager.org/index.php) (downloadable on bash git clone https://github.com/RobertManager/robert.git) on my account (Johnny server)... But (until now) I can't reach to do it/make it runs.. I'm looking for someone to help me... It's a Mysql plugin to help poeple to manage "renting of goods"... It's in french... My problem (now) is just to reach to instal and run the "pluginn"/"program" Thanks Bonjour! J'essaye d'installer ce petit logiciel: http://robertmanager.org/index.php... Je n'arrive pour l'instant à (presque) rien... je cherche qqn pour m'aider... Merci -
Hello teamIs it possible to create a database mysql or postgresql with PHP?
-
Problem with database connection using JAVA
garoskul posted a topic in Website Management and Coding
Hi there! I have a java web project that used jsp and servlet. I´ve done correctly all the database and there is no problem with that. In the section of MySql Databases I´ve created a new user and I attached it to the database created. The problem is that I don´t get the connection to the database. I genere a .war file to be deployed . I attach part of the code that I use to connect java to the database. public class Clase_Conexion{ private Connection cn; private String user="garoskul_garos"; //The user I created private String password="mypassword"; private String url="jdbc:mysql://64.62.211.131:3306/prueba"; //I used hnny.heliohost.org fist and it doesn´t work public Clase_Conexion(){ cn=null; try{ Class.forName("com.mysql.jdbc.Driver"); cn=DriverManager.getConnection(url,user,password); if(cn!=null){ System.out.println("Conexion establecida"); } }catch ( SQLException e){ System.out.println("error al conectar"+e); } catch (ClassNotFoundException ex) { Logger.getLogger(Clase_Conexion.class.getName()).log(Level.SEVERE, null, ex); } } public Connection getConnection(){ return cn; } Please if u don´t mine to help me I´ll be very grateful.
