Error>>> Database parameters

[sams]

Hello everyone,

I have a problem installing KonaKart, it is about the database connection. I am using MYSQL. When the installation comes to the database parameters step I get the error below:

==================================================
Connection Parameters:
   User       = root
   Password   = ********
   Driver     = com.mysql.jdbc.Driver
   Url        = jdbc:mysql://localhost:3306/dbname?zeroDateTimeBehavior=convertToNull
Message:   Unknown database 'dbname'
SQLState:  42000
ErrorCode: 1049

_____________________________________________________________
Database Connection Test Failed.
=================================================================

I would really appreciate it if anyone can help.

Thanks in advance,

S.

[trevor]

Hi Sams,

The clue is in the error message...  Unknown database 'dbname'

You will have to replace "dbname" with the name of your database.

Trevor

[sams]

Trevor,

Thanks alot for your help. I did replace it with the name of my database. However, I got a new error when I tried to initialise the Kona database. The error is :

============================================
DROP FUNCTION IF EXISTS KK_IF;
Message:   You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IF EXISTS KK_IF' at line 1
SQLState:  42000
ErrorCode: 1064

_____________________________________________________________
SQL execution failed.
===========================================

Any idea what the problem might be?

Thanks again,

S.

[trevor]

Hi Sams,

You need MySQL v5 or later for KonaKart v2.2.0.4 and above.  Which one were you using?

Trevor

[sams]

Hello Trevor,

I am using MYSQL v4. I am uninstalling it and installing the v5 one.

thanks 4 your help.

S.

[BrianNicholas]

Hi there. I have also face the same problem when I am installing Konakart on my system. However, I renamed my database name as follows because I am using mySQL workbench 5.2 CE.


Connection Parameters:
   User       = root
   Password   = ********
   Driver     = com.mysql.jdbc.Driver
   Url        = jdbc:mysql://localhost:3306/mysqlzeroDateTimeBehavior=convertToNull
Message:   Access denied for user 'root'@'localhost' (using password: NO)
SQLState:  28000
ErrorCode: 1045

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


Can you tell me where did I go wrong?
Thanks alot in advanced. 

[ming]

It just looks like you specified your database URL incorrectly:   (missing ?)

Not this:

Code: [Select]

Url        = jdbc:mysql://localhost:3306/mysqlzeroDateTimeBehavior=convertToNull
but this:

Code: [Select]

Url        = jdbc:mysql://localhost:3306/mysql?zeroDateTimeBehavior=convertToNull
Assuming your database schema is called mysql

[BrianNicholas]

Hi there Ming,

The result I get is still the same.   

Connection Parameters:
   User       = root
   Password   = ********
   Driver     = com.mysql.jdbc.Driver
   Url        = jdbc:mysql://localhost:3306/mysql?zeroDateTimeBehavior=convertToNull
Message:   Access denied for user 'root'@'localhost' (using password: NO)
SQLState:  28000
ErrorCode: 1045

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


Do you have any clues on where could I have gone wrong?
I merely, pressed the next button during the installation and have never changed anything only for the database name.

Thank you very much for your help!

[ming]

I can't help you any more than to repeat the error message that you get:

Code: [Select]

Access denied for user 'root'@'localhost' (using password: NO)

You need to check your db credentials.

Maybe you have a firewall that's blocking access?

[BrianNicholas]

Hi Ming,

I have already successfully installed KonaKart.
Thanks a lot for your help.
I will post if I were to need any help connecting KonaKart to Eclipse.

Once again, I would like to thank you Ming for helping me. 

[ming]

For the benefit of others, what was wrong in your case?

[BrianNicholas]

I went into mySQL and typed in a root password for the database which I am using.
So during the installation, I renamed the part with " jdbc:mysql://localhost:3306/dbname?zeroDateTimeBehavior=convertToNull " to " jdbc:mysql://localhost:3306/mysql?zeroDateTimeBehavior=convertToNull " under the URL for the database and also typed in my root password for the database which actually allowed me to successfully complete the installation of KonaKart.