Your message dated Wed, 04 Oct 2006 01:19:14 +0200
with message-id <[EMAIL PROTECTED]>
and subject line mysql-server-5.0: mysql_fix_privilege_tables.sql file depends
on sql_mode='mysql40'
has caused the attached Bug report to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what I am
talking about this indicates a serious mail system misconfiguration
somewhere. Please contact me immediately.)
Debian bug tracking system administrator
(administrator, Debian Bugs database)
--- Begin Message ---
Package: mysql-server-5.0
Version: 5.0.22-3
Severity: normal
Hello,
The sql syntaxe used in /usr/share/mysql/mysql_fix_privilege_tables.sql
is specific to mysql (id est : sql_mode='mysql40'). When the
default mode is set to 'ANSI'(in my case), the script (/etc/mysql/debian-start)
fails silently. Please add
'set @@session.sql_mode='mysql40' ;' to the begining of
/usr/share/mysql/mysql_fix_privilege_tables.sql.
Moreover, this should be done to /usr/share/mysql/fill_help_tables.sql
and imported to the mysql database automaticly by the debian startup
scripts.
-- System Information:
Debian Release: testing/unstable
APT prefers unstable
APT policy: (990, 'unstable'), (500, 'testing')
Architecture: i386 (i686)
Shell: /bin/sh linked to /bin/bash
Kernel: Linux 2.6.12.4-vs2.0nephthys
Locale: LANG=C, LC_CTYPE=C (charmap=ANSI_X3.4-1968)
Versions of packages mysql-server-5.0 depends on:
ii adduser 3.90 Add and remove users and groups
ii debconf [debconf-2.0] 1.5.2 Debian configuration management sy
ii libc6 2.3.6-15 GNU C Library: Shared libraries
ii libdbi-perl 1.51-1 Perl5 database interface by Tim Bu
ii libgcc1 1:4.1.1-5 GCC support library
ii libmysqlclient15off 5.0.22-3 mysql database client library
ii libncurses5 5.5-2 Shared libraries for terminal hand
ii libreadline5 5.1-7 GNU readline and history libraries
ii libstdc++6 4.1.1-5 The GNU Standard C++ Library v3
ii libwrap0 7.6.dbs-9 Wietse Venema's TCP wrappers libra
ii mysql-client-5.0 5.0.22-3 mysql database client binaries
ii mysql-common 5.0.22-3 mysql database common files (e.g.
ii passwd 1:4.0.16-2 change and administer password and
ii perl 5.8.8-6 Larry Wall's Practical Extraction
ii psmisc 22.2-1 Utilities that use the proc filesy
ii zlib1g 1:1.2.3-12 compression library - runtime
Versions of packages mysql-server-5.0 recommends:
ii mailx 1:8.1.2-0.20050715cvs-1 A simple mail user agent
-- debconf information:
mysql-server-5.0/really_downgrade: false
mysql-server-5.0/start_on_boot: true
mysql-server-5.0/mysql_update_hints1:
mysql-server-5.0/nis_warning:
mysql-server-5.0/postrm_remove_databases: false
mysql-server-5.0/no_upgrade_with_isam_tables:
* mysql-server-5.0/mysql_install_db_notes:
--- End Message ---
--- Begin Message ---
Hello
> The sql syntaxe used in /usr/share/mysql/mysql_fix_privilege_tables.sql
> is specific to mysql (id est : sql_mode='mysql40').
What ever this was, it's not present in 5.0.24a anymore so I close the
report.
I've just tested it in a Sarge chroot with MySQL 4.0 + sql_mode='ANSI'
and the backport.org 5.0.24a-3~bpo.1 packages. Both, the upgrade and
granting rights to a new user works fine.
bye,
-christian-
For the reference:
app109:~# apt-get install mysql-server-5.0 mysql-client-5.0
libmysqlclient15off mysql-common=5.0.24a-3~bpo.1
Reading Package Lists... Done
Building Dependency Tree... Done
Suggested packages:
tinyca
The following packages will be REMOVED:
mysql-client mysql-server
The following NEW packages will be installed:
libmysqlclient15off mysql-client-5.0 mysql-server-5.0
The following packages will be upgraded:
mysql-common
1 upgraded, 3 newly installed, 2 to remove and 0 not upgraded.
Need to get 0B/30.6MB of archives.
After unpacking 60.5MB of additional disk space will be used.
Do you want to continue? [Y/n]
Preconfiguring packages ...
(Reading database ... 34277 files and directories currently installed.)
Removing mysql-server ...
Stopping MySQL database server: mysqld.
Removing mysql-client ...
(Reading database ... 34075 files and directories currently installed.)
Preparing to replace mysql-common 4.0.24-10sarge2 (using
.../mysql-common_5.0.24a-3~bpo.1_all.deb) ...
Unpacking replacement mysql-common ...
Selecting previously deselected package libmysqlclient15off.
Unpacking libmysqlclient15off (from
.../libmysqlclient15off_5.0.24a-3~bpo.1_i386.deb) ...
Selecting previously deselected package mysql-client-5.0.
Unpacking mysql-client-5.0 (from
.../mysql-client-5.0_5.0.24a-3~bpo.1_i386.deb) ...
Selecting previously deselected package mysql-server-5.0.
Unpacking mysql-server-5.0 (from
.../mysql-server-5.0_5.0.24a-3~bpo.1_i386.deb) ...
Setting up mysql-common (5.0.24a-3~bpo.1) ...
Configuration file `/etc/mysql/my.cnf'
==> Modified (by you or by a script) since installation.
==> Package distributor has shipped an updated version.
What would you like to do about it ? Your options are:
Y or I : install the package maintainer's version
N or O : keep your currently-installed version
D : show the differences between the versions
Z : background this process to examine the situation
The default action is to keep your current version.
*** my.cnf (Y/I/N/O/D/Z) [default=N] ? n
Setting up libmysqlclient15off (5.0.24a-3~bpo.1) ...
Setting up mysql-client-5.0 (5.0.24a-3~bpo.1) ...
Setting up mysql-server-5.0 (5.0.24a-3~bpo.1) ...
Installing new version of config file /etc/init.d/mysql ...
Installing new version of config file /etc/logrotate.d/mysql-server ...
Installing new version of config file /etc/mysql/debian-start ...
Stopping MySQL database server: mysqld.
Starting MySQL database server: mysqld . ..
Checking for corrupt, not cleanly closed and upgrade needing tables..
app109:~# mysql mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 7 to server version:
5.0.24a-Debian_3~bpo.1-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> SHOW CREATE TABLE user;
...
"Repl_client_priv" enum('N','Y') NOT NULL default 'N',
"ssl_type" enum('','ANY','X509','SPECIFIED') NOT NULL default '',
"ssl_cipher" blob NOT NULL,
"x509_issuer" blob NOT NULL,
"x509_subject" blob NOT NULL,
"max_questions" int(11) unsigned NOT NULL default '0',
"max_updates" int(11) unsigned NOT NULL default '0',
"max_connections" int(11) unsigned NOT NULL default '0',
...
mysql> SELECT @@sql_mode;
+-------------------------------------------------------------+
| @@sql_mode |
+-------------------------------------------------------------+
| REAL_AS_FLOAT,PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,ANSI |
+-------------------------------------------------------------+
1 row in set (0.00 sec)
mysql> GRANT SELECT ON test.* TO 'ch' IDENTIFIED BY 'secret';
Query OK, 0 rows affected (0.00 sec)
mysql> Bye
app109:~# mysql test -u ch -psecret
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8 to server version:
5.0.24a-Debian_3~bpo.1-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> SELECT * FROM test;
+------+
| v |
+------+
| a |
+------+
1 row in set (0.00 sec)
mysql> INSERT INTO test VALUES ('b');
ERROR 1142 (42000): INSERT command denied to user 'ch'@'localhost' for
table 'test'
--- End Message ---
