• Welcome to KonaKart Community Forum. Please login or sign up.
 

Starting KonaKart problem

Started by mt1, October 13, 2011, 02:34:34 pm

Previous topic - Next topic

mt1

When I click the desktop icon to start KonaKart, I get the following in the cmd console:

Using CATALINA_BASE:   C:\Users\Mike\workspace\KonaKart\bin\/..
Using CATALINA_HOME:   C:\Users\Mike\workspace\KonaKart\bin\/..
Using CATALINA_TMPDIR: C:\Users\Mike\workspace\KonaKart\bin\/..\temp
Using JRE_HOME:        C:/Program Files (x86)/Java/jre6
========================================
Waiting for the KonaKart server to start


Nothing happens, what might be wrong?

I have not managed to connect to my MySQL database either during installation because it cannot find the JDBC driver, so I just skipped and continued on, is this the problem? How can I resolve this issue?

kate

I would study the User Guide and start again with the installer.  Don't be tempted to proceed until your database connection is confirmed by the wizard.
You won't get far without a database connection.

mt1

Quote from: kate on October 13, 2011, 02:55:54 pm
I would study the User Guide and start again with the installer.  Don't be tempted to proceed until your database connection is confirmed by the wizard.
You won't get far without a database connection.


The manual doesn't help solve my JDBC problem, I already use a the reocmmended database (MySQL).

kate

when you are running the wizard and it tells you that the database connection fails, what error are you getting?

mt1

Quote from: kate on October 13, 2011, 03:17:33 pm
when you are running the wizard and it tells you that the database connection fails, what error are you getting?


Message: No suitable driver found for jdbc:mysql://127.0.0.1:3306
SQLState: 08001
Error Code: 0

The driver is: com.mysql.jdbc.Driver

kate

What did you specify as the connection URL?

mt1

Quote from: kate on October 13, 2011, 03:27:41 pm
What did you specify as the connection URL?


URL: jdbc:mysql://127.0.0.1:3306

kate

Well that looks like illegal syntax which will give you that error (you need the "/" at the end)

Regardless of that, for correct operation you should follow the format of the default provided and mentioned in the User Guide:

jdbc:mysql://localhost:3306/store1?zeroDateTimeBehavior=convertToNull

...where store1 should be replaced by your database schema name.

mt1

Quote from: kate on October 13, 2011, 03:38:58 pm
Well that looks like illegal syntax which will give you that error (you need the "/" at the end)

Regardless of that, for correct operation you should follow the format of the default provided and mentioned in the User Guide:

jdbc:mysql://localhost:3306/store1?zeroDateTimeBehavior=convertToNull

...where store1 should be replaced by your database schema name.


Ah ok, wasn't sure about the extra parameters were neccessary.

Problem fixed, thanks.

mt1

This still remains a problem however:

When I click the desktop icon to start KonaKart, I get the following in the cmd console the nothing happens even after 5-10 mins:

Using CATALINA_BASE:   C:\Users\Mike\workspace\KonaKart\bin\/..
Using CATALINA_HOME:   C:\Users\Mike\workspace\KonaKart\bin\/..
Using CATALINA_TMPDIR: C:\Users\Mike\workspace\KonaKart\bin\/..\temp
Using JRE_HOME:        C:/Program Files (x86)/Java/jre6
========================================
Waiting for the KonaKart server to start