srihari

Dear admin,

From spring boot, i am still getting the same error after changing the URL.

so i tried using PHP and normal java to connect with DB.

the result is success.

i even tried this configurations in spring

do i need any special permission to connect via spring boot (java)?

kindly help.

hi admin,

this is the configuration i am using to connect to the db with my local dev environment and allowed remote access.

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: User srihari9_bhrigub already has more than 'max_user_connections' active connections
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.8.0_131]
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) ~[na:1.8.0_131]
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) ~[na:1.8.0_131]
	at java.lang.reflect.Constructor.newInstance(Unknown Source) ~[na:1.8.0_131]
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) ~[mysql-connector-java-5.1.43.jar:5.1.43]
	at com.mysql.jdbc.Util.getInstance(Util.java:408) ~[mysql-connector-java-5.1.43.jar:5.1.43]
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:943) ~[mysql-connector-java-5.1.43.jar:5.1.43]
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973) ~[mysql-connector-java-5.1.43.jar:5.1.43]
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909) ~[mysql-connector-java-5.1.43.jar:5.1.43]
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:873) ~[mysql-connector-java-5.1.43.jar:5.1.43]
	at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1710) ~[mysql-connector-java-5.1.43.jar:5.1.43]
	at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1226) ~[mysql-connector-java-5.1.43.jar:5.1.43]

i am using hibernate and spring (java) to connect to this db. kindly help

Hi,

i am also having the same problem.

just after creating a database i using my program to test the connection for the first time. i am getting this error

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: User srihari9_test already has more than 'max_user_connections' active connections

and i am sure this is my is my first time i am creating a connection. i not even opened phpmyadmin, deleted db and create new one same there.

mydomain is srihari92.heliohost.com

user mail : srihari92@ymail.com

how can i close the connections that are opened using cpanel. or how can i make limit higher (like 15)

i am doing an experiment may have aleat 3 to 5 active connections

kindly help.

kindly help.

This is not fully supported here. You can use sockets (fsock, etc) to make connections outbound to other servers on standard web ports (21,80,443,3306,8080, the mail ports, and maybe a few others) only. Inbound connections are not allowed. You can't run a server that listens for connections on a custom port, which it sounds like you're trying to do.

thanks for the reply

hi i would like to run a php websocket server in heliohost. As every tutorial said to run the php file in shell or command prompt, i know that heliohost dont provide shell and blocked the exec(), .., etc. And port are not open as i tried normal socket programming.

i have recently search and find some discussion that websocket is allowed in heliohost and can choose the easier language to do that.

i am wondering how to do that because websocker url look like

ws://host:port/some/path as port are not allowed to open.

anyone know how to do it. as discussion clearly said that websocket can be run in heliohost

these are the links

http://www.helionet....red-websockets/

http://www.helionet....ebsocket-setup/

please anyone can i run websocket if so how can i do it using php or other language (supported by heliohost stevie server)

thanks in advance