MySQL Bugs: #28168: odbc, non 7-bit password, connection failed

Bug #28168	odbc, non 7-bit password, connection failed
Submitted:	30 Apr 2007 20:25	Modified:	18 Nov 16:14
Reporter:	Susanne Ebrecht
Status:	Need Doc Info
Category:	Connector/ODBC	Severity:	S3 (Non-critical)
Version:	5.1	OS:	Any
Assigned to:		Target Version:
Triage:	D2 (Serious)

Description:
Hi all,

> select version();
5.1.17-beta

on FreeBSD 6.2 (32 Bit), installed via Ports

> show variables like 'char%';
character_set_client     | latin1
character_set_connection | latin1
character_set_database   | latin1
character_set_filesystem | binary
character_set_results    | latin1
character_set_server     | latin1
character_set_system     | utf8

$ locale
all variables are: de_DE.iso8859-15

I used xterm with encoding de_DE.iso8859-15

$ mysql
> create user foo identified by 'äöü';

I installed unixODBC 2.2.12 (from source) and MySQL-Connector-ODBC 3.51.12
I configured all correctly.

$ isql -v myconnect foo äöü
I get a connect

I add a new user on my system with default settings all are utf8
$ locale
all variables are: de_DE.utf8

I used xterm with encoding de_DE.utf8

$ isql -v myconnect foo äöü
connection failed.

My order for MySQL-Connector-ODBC v5 is, that we should provide, different client
encodings to different database encodings. Because, then the user must not be careful
with his encoding and it works from every environment.

Of course I also tested the other direction and it was the same.

The other guys from connector team told me, that my problem with the password is
definitely a server bug not a connector or unixodbc bug.

Kind Regards,

Susanne

How to repeat:
Try to connect from another enviroment with other encoding settings, than the settings
you have used to create the user.

It is a connector bug

The character set of the connection should be set in some way before attempting to call
mysql_real_connect() from inside connector/odbc because the character set is sent during
the authentication handshake.

Hi Susanne and thanks for your report. Since connector/ODBC v5 is still beta, please
consider lowering severity to S4 (feature request).

As Andrey already explained we do need configuration screen in v5 like 3.51 has (Connect
Options tab / Initial Statement field).

I verified this against MyODBC version 5.1.

mysql> grant all on *.* to müller@'localhost';

$ mysql -u müller test

mysql> select user();
müller@localhost

mysql> show grants;
GRANT ALL PRIVILEGES ON *.* TO 'müller'@'localhost'

changing my .odbc.ini:

User           = müller

Try to execute some tests ...
Connection failed.

Connecting with Unicode username and password works fine. It's stored and retrieved
correctly by the Windows GUI. This patch fixes the short-period when the character set is
utf8 so that we convert the error message correctly.

Index: driver/connect.c
===================================================================
--- driver/connect.c    (revision 1006)
+++ driver/connect.c    (working copy)
@@ -210,6 +210,7 @@
     We always use utf8 for the connection, and change it afterwards if needed.
   */
   mysql_options(mysql, MYSQL_SET_CHARSET_NAME, "utf8");
+  dbc->cxn_charset_info= utf8_charset_info;

   if (!mysql_real_connect(mysql,
                           ds_get_utf8attr(ds->server,   &ds->server8),

fix + test

Attachment: bug28168.diff (application/octet-stream, text), 3.60 KiB.

don't forget to remove the user in the test.

pushed as rev#857(5.1.7)