KonaKart Community Forum

Installation / Configuration => Installation of KonaKart => Topic started by: mt1 on October 13, 2011, 02:34:34 pm

Title: Starting KonaKart problem
Post by: mt1 on October 13, 2011, 02:34:34 pm
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?
Title: Re: Starting KonaKart problem
Post by: 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.
Title: Re: Starting KonaKart problem
Post by: mt1 on October 13, 2011, 03:15:10 pm
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).
Title: Re: Starting KonaKart problem
Post by: 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?
Title: Re: Starting KonaKart problem
Post by: mt1 on October 13, 2011, 03:20:14 pm
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
Title: Re: Starting KonaKart problem
Post by: kate on October 13, 2011, 03:27:41 pm
What did you specify as the connection URL?
Title: Re: Starting KonaKart problem
Post by: mt1 on October 13, 2011, 03:28:35 pm
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
Title: Re: Starting KonaKart problem
Post by: 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.
Title: Re: Starting KonaKart problem
Post by: mt1 on October 13, 2011, 03:42:10 pm
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.
Title: Re: Starting KonaKart problem
Post by: mt1 on October 13, 2011, 03:47:52 pm
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