← Back to team overview

linux-traipu team mailing list archive

[Bug 904203] [NEW] bug in MySQL protocol (client authentication packet)

 

Public bug reported:

Drizzle JDBC always  MySQLServerCapabilities.CONNECT_WITH_DB flag, even
if database name is not given

Looking at the code in MySQLProtocol.java, it was not intended

            // If a database is given, but createDB is not defined or is false,            
           // then just try to connect to the given database            
           if (this.database != null && !createDB()) 
                 capabilities.add(MySQLServerCapabilities.CONNECT_WITH_DB);

However this.database is never null, it is set to  an empty string prior
to this code.

This broke Tungsten with MariaDB in recent MariaDBs :
https://bugs.launchpad.net/maria/+bug/904097 .

MariaDB happened to interpret protocol a bit stricter than MySQL (s.
http://forge.mysql.com/wiki/MySQL_Internals_ClientServer_Protocol#Client_Authentication_Packet
)

** Affects: drizzle
     Importance: Undecided
         Status: New

-- 
You received this bug notification because you are a member of UBUNTU -
AL - BR, which is subscribed to Drizzle.
https://bugs.launchpad.net/bugs/904203

Title:
  bug in MySQL protocol (client authentication packet)

Status in A Lightweight SQL Database for Cloud Infrastructure and Web Applications:
  New

Bug description:
  Drizzle JDBC always  MySQLServerCapabilities.CONNECT_WITH_DB flag,
  even if database name is not given

  Looking at the code in MySQLProtocol.java, it was not intended

              // If a database is given, but createDB is not defined or is false,            
             // then just try to connect to the given database            
             if (this.database != null && !createDB()) 
                   capabilities.add(MySQLServerCapabilities.CONNECT_WITH_DB);

  However this.database is never null, it is set to  an empty string
  prior to this code.

  This broke Tungsten with MariaDB in recent MariaDBs :
  https://bugs.launchpad.net/maria/+bug/904097 .

  MariaDB happened to interpret protocol a bit stricter than MySQL (s.
  http://forge.mysql.com/wiki/MySQL_Internals_ClientServer_Protocol#Client_Authentication_Packet
  )

To manage notifications about this bug go to:
https://bugs.launchpad.net/drizzle/+bug/904203/+subscriptions


Follow ups

References