Installation Problem with konakart

[sheva99]

As far as I can see I have followed instructions to a tee.  Please show me where I am going wrong here, thanks..

Have created mysql database as instructed.
OS: linux
PHP: 5.x
hosting: shared hosting
url of my database: hobbycart.db.3892814.hostedresource.com
verified java files are located in the correct directory in the gui install
port number used is default 8780
mysql selected in the gui screen

origional url for gui install screen
jdbc:mysql://localhost:3306/dbname?zeroDateTimeBehavior=convertToNull
changed to
jdbc:mysql://hobbycart.db.3892814.hostedresource.com:8780/hobbycart?zeroDateTimeBehavior=convertToNull
hobbycart being the user name
database driver is default
com.mysql.jdbc.Driver

error receveived when attempting to connect to database.
Message:   Communications link failure due to underlying exception:

** BEGIN NESTED EXCEPTION **

java.net.SocketException
MESSAGE: java.net.ConnectException: Connection timed out: connect

STACKTRACE:

java.net.SocketException: java.net.ConnectException: Connection timed out: connect
   at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:156)
   at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:276)
   at com.mysql.jdbc.Connection.createNewIO(Connection.java:2666)
   at com.mysql.jdbc.Connection.<init>(Connection.java:1531)
   at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
   at java.sql.DriverManager.getConnection(Unknown Source)
   at java.sql.DriverManager.getConnection(Unknown Source)
   at com.konakartadmin.db.TestDbConnection.main(Unknown Source)


** END NESTED EXCEPTION **



Last packet sent to the server was 32 ms ago.
SQLState:  08S01
ErrorCode: 0

_____________________________________________________________
Database Connection Test Failed.
Please correct the errors before running KonaKart.
You can find help in the KonaKart FAQs and in the KonaKart Forum.

[greg]

It looks like you haven't specified the database URL correctly.

Possible clue:  KonaKart usually runs on port 8780 (by default) - not the database

[sheva99]

ok, then where am I going wrong here?   what should the port be, and what am I doing wrong with the url.  I am already aware that this configuration does not work.

I would like to know how to fix it.
thank you,

[sheva99]

As far as I can see I have followed instructions to a tee.  Please show me where I am going wrong here, thanks..

Have created mysql database as instructed.
OS: linux
PHP: 5.x
hosting: shared hosting
url of my database: hobbycart.db.3892814.hostedresource.com
verified java files are located in the correct directory in the gui install
port number used is default 8780
mysql selected in the gui screen

origional url for gui install screen
jdbc:mysql://localhost:3306/dbname?zeroDateTimeBehavior=convertToNull
changed to
jdbc:mysql://hobbycart.db.3892814.hostedresource.com:8780/hobbycart?zeroDateTimeBehavior=convertToNull
hobbycart being the user name
database driver is default
com.mysql.jdbc.Driver

error receveived when attempting to connect to database.
Message:   Communications link failure due to underlying exception:

** BEGIN NESTED EXCEPTION **

java.net.SocketException
MESSAGE: java.net.ConnectException: Connection timed out: connect

STACKTRACE:

java.net.SocketException: java.net.ConnectException: Connection timed out: connect
   at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:156)
   at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:276)
   at com.mysql.jdbc.Connection.createNewIO(Connection.java:2666)
   at com.mysql.jdbc.Connection.<init>(Connection.java:1531)
   at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
   at java.sql.DriverManager.getConnection(Unknown Source)
   at java.sql.DriverManager.getConnection(Unknown Source)
   at com.konakartadmin.db.TestDbConnection.main(Unknown Source)


** END NESTED EXCEPTION **



Last packet sent to the server was 32 ms ago.
SQLState:  08S01
ErrorCode: 0

_____________________________________________________________
Database Connection Test Failed.
Please correct the errors before running KonaKart.
You can find help in the KonaKart FAQs and in the KonaKart Forum.