[Bacula-bugs] [bacula 0000662]: MySQL connection problem: "Version error for database "bacula". Wanted 9, got 0"

[<bac...@li...>]

The following bug has been SUBMITTED.
======================================================================
http://bugs.bacula.org/bug_view_advanced_page.php?bug_id=0000662
======================================================================
Reported By:                ivanszky
Assigned To:                
======================================================================
Project:                    bacula
Bug ID:                     662
Category:                   sql
Reproducibility:            always
Severity:                   block
Priority:                   normal
Status:                     new
======================================================================
Date Submitted:             08-23-2006 10:42 PDT
Last Modified:              08-23-2006 10:42 PDT
======================================================================
Summary:                    MySQL connection problem: "Version error for database "bacula". Wanted 9, got 0"
Description: 
When starting bacula-director-mysql it crashes with the message:

Starting Bacula Director: 23-aug 19:33 bacula-dir:  Fatal error: Version
error for database "bacula". Wanted 9, got 0
23-aug 19:33 bacula-dir:  Fatal error: Could not open Catalog "MyCatalog",
database "bacula".
23-aug 19:33 bacula-dir:  Fatal error: Version error for database
"bacula". Wanted 9, got 0
23-aug 19:33 bacula-dir ERROR TERMINATION
Please correct configuration file: /etc/bacula/bacula-dir.conf
failed.


Database is fresh and new, made by the same version of bacula with which 
would like to use it. In MySql the table Version contains the number "9".
MySQL log contains only a message about the connection:
"060823 19:05:40       6 Connect     bacula@localhost on bacula"

no trace of a query or disconnect, or anything.

I also made a tcpdump about the connection between bacula-dir and MySQL.
It seems, that bacula-dir, connects, authenticates, and then sends an
invalid MySql COMMAND Code.

tcpdump attached



======================================================================

Bug History
Date Modified  Username       Field                    Change              
======================================================================
08-23-06 10:42 ivanszky       New Bug                                      
08-23-06 10:42 ivanszky       File Added: dump                             
======================================================================