Author |
Message |
Jaime
Joined: 21 May 2015 Posts: 6 Country: Portugal |
|
Cannot connect with MYSQL database |
|
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 |
|
![](templates/GreenTech/images/spacer.gif) |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7849
|
|
|
|
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 |
|
![](templates/GreenTech/images/spacer.gif) |
Jaime
Joined: 21 May 2015 Posts: 6 Country: Portugal |
|
|
|
hi again!
Itīs done ;)
thanks for your help.
best regards
Jaime
|
|
Thu May 21, 2015 2:34 pm |
|
![](templates/GreenTech/images/spacer.gif) |
Jaime
Joined: 21 May 2015 Posts: 6 Country: Portugal |
|
|
|
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 |
|
![](templates/GreenTech/images/spacer.gif) |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7849
|
|
|
|
Jaime - please ignore Nyydgsxllo posts, this is spam bot.
|
|
Tue May 26, 2015 12:55 am |
|
![](templates/GreenTech/images/spacer.gif) |
Jaime
Joined: 21 May 2015 Posts: 6 Country: Portugal |
|
|
|
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 |
|
![](templates/GreenTech/images/spacer.gif) |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7849
|
|
|
|
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 |
|
![](templates/GreenTech/images/spacer.gif) |
Jaime
Joined: 21 May 2015 Posts: 6 Country: Portugal |
|
|
|
Hi,
My dbaudit version is 4.2.26.1.
best regards
|
|
Fri May 29, 2015 10:47 am |
|
![](templates/GreenTech/images/spacer.gif) |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7849
|
|
|
|
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 |
|
![](templates/GreenTech/images/spacer.gif) |
Jaime
Joined: 21 May 2015 Posts: 6 Country: Portugal |
|
|
|
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 |
|
![](templates/GreenTech/images/spacer.gif) |
|