Search the Community

Hi, is there any way to create a foreign key linked to another database? I can't see all the databases in PMA.

Hi, i'm using Johnny Heliohost remote mysql and codeigniter 4 for development. After a few requests from the frontend, I'm seeing this error on mysql that user has more than max_user_connections (code 1203). While connecting db from backend, codeigniter seems to automatically close db connections. Even when I'm checking through workbench show processlist shows only 1 sleeping process. But then, suddenly max_user_connections exceeds the limit for the same request which was working a moment before. So, my asks are jotted below: - Can the mysql wait_timeout parameter be redued to 180 secs? - From mysql documentation it seems the max_user_connections are set to 150 and another for super user, is there any additional limit from heliohost's end? If there's any better way of dealing with this problem I'm all ears. regards inifinit5

Hey everybody, I'm quite new to this. I signed up yesterday to Johnny and started to send some data to a MySQL database. That worked quite good but since 3.5 hours the server seems not accessible and in the cpanel I get a message that the server is down. The MySQL server is currently offline. Error while connecting to MySQL: (XID 8f868x) 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' (111)) Error while connecting to MySQL: (XID 8f868x) 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' (111)) at /usr/local/cpanel/Cpanel/Mysql/Basic.pm line 391, <STDIN> line 1. Is there something wrong in my application posting the data or is the server really down? I'm quite confused... Thomas

Hello, As dumb as it may sound, I think I created a lot of connections with my DB without closing them. I am trying to Kill them but i cant see the connections. When I type : SHOW PROCESSLISTI get two processes: Id User Host db Command Time State Info Termina 17453 joaopm33 localhost joaopm33_Mush_Instagram Query 0 starting SHOW PROCESSLIST Termina 17454 joaopm33 localhost NULL Sleep 0 NULL When trying to kill them i get an unknow id error. I should see 4 connections once I am getting the error: mysql.connector.errors.ProgrammingError) 1203 (42000): User joaopm33_joaopm33 already has more than 'max_user_connections' active connectionsWhat am I doing wrong here (beside opening all those connections in the first place)

Hello Sir, I have just Started using your Service and you are offering a lot for all free is great, not explainable in words... But sir, I faced an Issue that my project require "aiomysql" module and can't work with the given "mysql connector" module.. I kindly Request to please Install this module to Johnny Server in python 3.7 version. If that works well.. I will definitely consider moving to tommy for a better experience! Thanks and Regards, Akshit Agarwal

How To Learn MySQL Password ?

Hello, I am trying to do a connect from Java to my DB, but I have a type error: “Access denied for user '_______'@'______' to database '_______'” I have the host, port, username and password of the helionet panel. The user is added to the database table and with all the privileges. Regards.

Hello, I have doubts about this host. I am developing a Java soap service, can I ?: Execute the mysql connector driver on your host to connect to the DB? Run tomcat ?, which max version?, Java max version? Do I have to use EJB or just uploading the project on your host will it work? Do I need permits with the EJB? The idea is to do it without the EJB (because sometimes when deploying the project many errors arise) You could tell me what I could do or what I have to do when I have a Java SOAP JAX-WS. For the DB issue, can I use ODBC, JDBC, OLE DB or other drivers in Java? That they fulfill these steps: 1 - How to upload a SOAP on your host? 2 - Once uploaded how to check that everything is correct 3 - Run the server 4 - Test the project through the URL. Regards

I am trying to make calls from python to a MySQL database using variables but the placeholder %s is not working. Here is my code: mycursor = connection.cursor() sql = "SELECT * FROM Users WHERE username = %s" val = ("Agwebberley") mycursor.execute(sql, val) myresult = mycursor.fetchall() print(myresult)

Please I am a student just studying how to use MySQL. Because of the constraints on having a laptop, I am using an iPad to write this, I have decided to register with heliohost to get a web database. But after registering I cannot see my host name and port at cpanel to connect to MySQL from the client I am using. Please can someone teach me how to get the host name and port number? What other parameters do I need to get started. I have checked the wiki but did not get any help there. Please I need to do this quickly so I can concentrate on my studies. I have spent more than a day trying to understand it. Thanks for your help.

Hi, i have the following Problem: I followed the instructions from https://wiki.helionet.org/MySQL_Databases#Connecting_Remotely and have added an IP Address (Host) in the remote MySQL Section and can connect with the database just fine. But when i try to create a table, i get the follwoing error: Error Code: 1044. Access denied for user 'user'@'*IP-Address*' to database 'database' I have also tried to grant priviliges to the user, but same error and i have also tried it over phpMyAdmin Section, and there i get another error that user@localhost doesn't have access to the database. I haven't tried it with a wildcard...

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

So I crated an account, log on to my cpanel, using database wizard created mysql db and user for it. Then I added % in mysql remote section. Now i'm trying to connect to my db using datagrip. my db name is: cvazer_dnd my username is: cvazer_hub URL: jdbc:mysql://johnny.heliohost.org:3306/cvazer_dnd And it is not working =( I'm not getting any errors it simply can't connect to remote host for some reason I switched off all ssl flags in connection settings on my side So what am I doing wrong?

https://submanga.heliohost.org Error while connecting to MySQL: (XID nzuste) 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 nzuste) 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 good day, I am current learning the flask micro framework and have built a relatively small app. said app runs well on my local machine but returns 500 error when uploaded to the server, attached are my details. any help will be highly appreciated. server tommy (I got lucky) username geojoe website: flask.geoffery.ml P.S. my app require some extra flask packages a list of which can be found in requirements.txt

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!

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?

Always I try to access my login.php shows the message: the path is: http://rpgmakergold2003.heliohost.org/php/ckeditor/samples/login.php please help me with this!

Hi everyone! I'm currently working on an app in Unity. I recently signed up on heliohost to use the hosting service. The first thing I am trying to accomplish is to access a php file from my C# script. However I really can't get it working, when I go to http:// ftp.martinv.heliohost.org, it says that my account is still queued but it has been 40 hours since I created the account. I already cleared my cache. I uploaded the php file through file manager. I'm wondering if I'm even heading in the right direction, I think I can access the file by using http://ftp.martinv.heliohost.org:port/phpfilename.php ? Is it true? When I try to access the file in Unity, i Get this debug.log 220---------- Welcome to Pure-FTPd [privsep] [TLS] ----------220-You are user number 5 of 50 allowed.220-Local time is now 16:09. Server port: port;220-This is a private system - No anonymous login220-IPv6 connections are also welcome on this server.220 You will be disconnected after 15 minutes of inactivity.500 HTTP command: UnityEngine.Debug:Log(Object) I'm looking for any ideas about how to fix it. Thanks a lot!

Hello well i have an error 500 thrown by the server after changing connection to mysql with django, it works all fine with sqlite3 but not with mysql i did enable all connections from remote connection, i even tested to connect from my local computer and it worked could it that the python modules aren't installed ? because it was all working before

My domain is www.madhusudanmishra.in. All index.php files are working fine but when files which have to make connection with the database are called it shows error 500. For eg: www.madhusudanmishra.in/register is working fine but when someone tries to make a login attempt (file signin.php works) and shows error 500. All php file permissions are set to 644 as well as db user has all privilege given. The same works fine on the localhost xampp. Please help and thanks in advance.

This question was changed to https://www.helionet.org/index/topic/36204-how-to-import-big-files-to-phpmyadmin/ Thank you