Bug 4930 - GDA can not connect to MySQL 4
Summary: GDA can not connect to MySQL 4
Status: RESOLVED FIXED
Alias: None
Product: Mageia
Classification: Unclassified
Component: RPM Packages (show other bugs)
Version: Cauldron
Hardware: All Linux
Priority: Normal normal
Target Milestone: ---
Assignee: Funda Wang
QA Contact:
URL: http://mail.gnome.org/archives/gnome-...
Whiteboard:
Keywords: PATCH
Depends on:
Blocks:
 
Reported: 2012-03-13 20:24 CET by Juan Magallon
Modified: 2012-03-14 01:24 CET (History)
0 users

See Also:
Source RPM: libgda5.0-5.0.3-1.mga2.src.rpm
CVE:
Status comment:


Attachments

Description Juan Magallon 2012-03-13 20:24:40 CET
I have just remembered this...
Current libgda contains a bug when connecting to MySQL v4 databases.
Problem (copy my original post on gnome-db list):

I an just trying to use gda-browser to connect to a mysql server, and
I just get an error on startup about the syntax of 'where Variable_name = ...'
thing. I will reproduce it from  mysql (well, really mariadb) cli client:

werewolf:~> mysql --host=xxxxx --user=magallon --password=xxxxx magallon
Welcome to the MariaDB monitor.  Commands end with ; or \g.
...
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MySQL [magallon]> show variables where Variable_name='lower_case_table_names';
ERROR 1064 (42000): 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 'where Variable_name='lower_case_table_names'' at line 1

This is the error I get from gda-browser-5.0 on connection.

It looks like the sorrect syntax is something like:

MySQL [magallon]> show variables like 'lower_case_table_names';
+------------------------+-------+
| Variable_name          | Value |
+------------------------+-------+
| lower_case_table_names | 0     |
+------------------------+-------+
1 row in set (0.06 sec)

Is this really a bug ? Is mysql 4.1 too old for gda ?

Response is here:

http://mail.gnome.org/archives/gnome-db-list/2012-January/msg00019.html

And patch here:

http://git.gnome.org/browse/libgda/commit/?id=96398ab6e71b5a966f34d8729d8c1213e9189c16

Probably this can go in even in freeze, as it is a bug fix, but maintainers decide.
Manuel Hiebel 2012-03-13 20:34:28 CET

Keywords: (none) => PATCH
Assignee: bugsquad => fundawang

Comment 1 Funda Wang 2012-03-14 01:24:52 CET
fixed in 2.mga2

Status: NEW => RESOLVED
Resolution: (none) => FIXED


Note You need to log in before you can comment on or make changes to this bug.