SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Cannot connect with MYSQL database

 
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools View previous topic
View next topic
Cannot connect with MYSQL database
Author Message
Jaime



Joined: 21 May 2015
Posts: 6
Country: Portugal

Post Cannot connect with MYSQL database Reply with quote
Dear softree technologies,

To SQL Server could connect me well, but when I tried to connect to a mysql database can not ..

what I have to do differently? : /

best regards

Jaime
Thu May 21, 2015 1:19 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7833

Post Reply with quote
Hi Jaime,

Please have a look at page 26 in the SQL Assistant User's Guide which describes "MySQL connections and settings"
Also please read pages 21 to 23 describing connection parameters for all supported database systems, MySQL included.

If you get a specific error when connecting to MySQL, please let us know the complete error message so we can help you with that error.
Thu May 21, 2015 1:32 pm View user's profile Send private message
Jaime



Joined: 21 May 2015
Posts: 6
Country: Portugal

Post Reply with quote
hi again!

Itīs done ;)

thanks for your help.

best regards

Jaime
Thu May 21, 2015 2:34 pm View user's profile Send private message
Jaime



Joined: 21 May 2015
Posts: 6
Country: Portugal

Post Reply with quote
hi Nyydgsxllo!


I think you're being ironic, but the clarification of SysOp is good.

Install the odbc driver to mysql is the solution to my problem.

best regards

Jaime
Mon May 25, 2015 8:29 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7833

Post Reply with quote
Jaime - please ignore Nyydgsxllo posts, this is spam bot.
Tue May 26, 2015 12:55 am View user's profile Send private message
Jaime



Joined: 21 May 2015
Posts: 6
Country: Portugal

Post Reply with quote
hi softTree,

I have another problem :/

When I am trying enable 'operations' in 'system audit options' I have this error:

"sqlstate 42000 [mysql][odbc 5.3(a) driver][mysqld-5.6.24-log] you have an error in your sql sintax; check that the manual that corresponds to your mysql server version for the rigth syntax to use near 'TYPE=MyISAM' at line 13"


best regards

Jaime[/img]
Thu May 28, 2015 2:47 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7833

Post Reply with quote
Hi. It looks like your MySQL version doesn't like TYPE=MyISAM syntax in the query that the console is running to create audit repository tables.

Which DB Audit version are you using?
Thu May 28, 2015 3:04 pm View user's profile Send private message
Jaime



Joined: 21 May 2015
Posts: 6
Country: Portugal

Post Reply with quote
Hi,

My dbaudit version is 4.2.26.1.


best regards
Fri May 29, 2015 10:47 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7833

Post Reply with quote
Hi,

Your version doesn't support MySQL 5.5 and 5.6, because they contain backward incompatible changes, not supporting TYPE keyword in CREATE TABLE syntax. You need to upgrade to a more recent version of DB Audit. The latest is 5.04.

Hope this helps
Fri May 29, 2015 11:11 am View user's profile Send private message
Jaime



Joined: 21 May 2015
Posts: 6
Country: Portugal

Post Reply with quote
DONE and resolved problem with version,

but now I have another problem, this time with logs, when I try enable error log and gereral query log, when I chose my error log file "C:\wamp\logs\mysql.log" MySQL error appears the indicated path does not exist.

And the path exists .... :/ what is the problem now?

Best regards

Jaime
Fri May 29, 2015 1:56 pm View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.