Text only | Text with Images

KonaKart Community Forum

Installation / Configuration => Installation of KonaKart => Topic started by: sams on August 28, 2007, 04:09:36 pm

Title: Error>>> Database parameters
Post by: sams on August 28, 2007, 04:09:36 pm
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.
Title: Re: Error>>> Database parameters
Post by: trevor on August 28, 2007, 04:23:17 pm
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
Title: Re: Error>>> Database parameters
Post by: sams on August 28, 2007, 04:42:13 pm
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.
Title: Re: Error>>> Database parameters
Post by: trevor on August 28, 2007, 04:52:47 pm
Hi Sams,

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

Trevor
Title: Re: Error>>> Database parameters
Post by: sams on August 28, 2007, 05:03:19 pm
Hello Trevor,

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

thanks 4 your help.

S.
Title: Re: Error>>> Database parameters
Post by: BrianNicholas on March 08, 2012, 05:58:59 am
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.  ;D
Title: Re: Error>>> Database parameters
Post by: ming on March 08, 2012, 06:11:21 am
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
Title: Re: Error>>> Database parameters
Post by: BrianNicholas on March 08, 2012, 06:32:02 am
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!
Title: Re: Error>>> Database parameters
Post by: ming on March 08, 2012, 06:36:41 am
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?

Title: Re: Error>>> Database parameters
Post by: BrianNicholas on March 08, 2012, 07:31:43 am
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.  :)
Title: Re: Error>>> Database parameters
Post by: ming on March 08, 2012, 07:35:09 am
For the benefit of others, what was wrong in your case?
Title: Re: Error>>> Database parameters
Post by: BrianNicholas on March 08, 2012, 07:45:43 am
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.

:D
Text only | Text with Images