[debian-mysql] Bug#481303: Critical errors in debian-start script

[Wouter Bolsterlee]

Package: mysql-server-5.0

The debian-start script (that supposedly checks for table errors) has
critical errors if the database name contains a character that needs to be
quoted in SQL, e.g. somedb-dev doesn't work, while `somedb-dev` does.

The resulting errors look like this (one for *each* table in databases with
such names):

  /etc/mysql/debian-start[2715]: ERROR 1064 (42000) at line 1: 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 '-dev.news' at line 1

You may agree this is pretty critical for a server.

This is the version I'm using:

  $ dpkg -l mysql-server-5.0 |grep ^ii
  ii  mysql-server-5.0   5.0.51a-5     MySQL database server binaries

The fix would be to escape the name appropriately. The attached patch fixes
the issue.

  mvrgr, Wouter

-- 
:wq                                                       mail uws at xs4all.nl
                                                      web http://uwstopia.nl
-------------- next part --------------
A non-text attachment was scrubbed...
Name: mysql-debian-start-escaping-fix.patch
Type: text/x-diff
Size: 864 bytes
Desc: not available
Url : http://lists.alioth.debian.org/pipermail/pkg-mysql-maint/attachments/20080515/6f98b725/attachment.patch 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 245 bytes
Desc: Digital signature
Url : http://lists.alioth.debian.org/pipermail/pkg-mysql-maint/attachments/20080515/6f98b725/attachment.pgp