[arch-dev-public] Mysql update
Hi guys, Finnaly i took some time and updated mysql to testing. I did almost all the needed rebuilds - i did not rebuilt dovecot as it needs the new libpcap, can someone build it for me ? - Im also uploading mysql-gui-tools 5.0r14 for my public page. Thanks all =)
Am Dienstag, 24. März 2009 12:28:25 schrieb Douglas Soares de Andrade:
Hi guys,
Finnaly i took some time and updated mysql to testing. I did almost all the needed rebuilds - i did not rebuilt dovecot as it needs the new libpcap, can someone build it for me ? - Im also uploading mysql-gui-tools 5.0r14 for my public page.
Thanks all =)
Just a little question about this. You compiled with "--with-charset=latin1 -- with-collation=latin1_general_ci" Is there a reason for doing so? I wonder if utf8 might be better but I am not sure if that would break compatibility. -- Pierre Schmitz Clemens-August-Straße 76 53115 Bonn Telefon 0228 9716608 Mobil 0160 95269831 Jabber pierre@jabber.archlinux.de WWW http://www.archlinux.de
Am Dienstag, 24. März 2009 12:32:34 schrieb Pierre Schmitz:
Am Dienstag, 24. März 2009 12:28:25 schrieb Douglas Soares de Andrade:
Hi guys,
Finnaly i took some time and updated mysql to testing. I did almost all the needed rebuilds - i did not rebuilt dovecot as it needs the new libpcap, can someone build it for me ? - Im also uploading mysql-gui-tools 5.0r14 for my public page.
Thanks all =)
Just a little question about this. You compiled with "--with-charset=latin1 -- with-collation=latin1_general_ci" Is there a reason for doing so? I wonder if utf8 might be better but I am not sure if that would break compatibility.
Ah, and I forgot: Is it compatible with previous mysql? If not there are some packages that have to be rebuild (qt, qt3, php and others). -- Pierre Schmitz Clemens-August-Straße 76 53115 Bonn Telefon 0228 9716608 Mobil 0160 95269831 Jabber pierre@jabber.archlinux.de WWW http://www.archlinux.de
Am Dienstag 24 März 2009 12:35:11 schrieb Pierre Schmitz:
Ah, and I forgot: Is it compatible with previous mysql? If not there are some packages that have to be rebuild (qt, qt3, php and others).
I think I'll build qt and php tonight anyway. -- Pierre Schmitz Clemens-August-Straße 76 53115 Bonn Telefon 0228 9716608 Mobil 0160 95269831 Jabber pierre@jabber.archlinux.de WWW http://www.archlinux.de
Em Terça-feira 24 Março 2009, às 08:35:11, Pierre Schmitz escreveu:
Am Dienstag, 24. März 2009 12:32:34 schrieb Pierre Schmitz:
Am Dienstag, 24. März 2009 12:28:25 schrieb Douglas Soares de Andrade:
Hi guys,
Finnaly i took some time and updated mysql to testing. I did almost all the needed rebuilds - i did not rebuilt dovecot as it needs the new libpcap, can someone build it for me ? - Im also uploading mysql-gui-tools 5.0r14 for my public page.
Thanks all =)
Just a little question about this. You compiled with "--with-charset=latin1 -- with-collation=latin1_general_ci" Is there a reason for doing so? I wonder if utf8 might be better but I am not sure if that would break compatibility.
Ah, and I forgot: Is it compatible with previous mysql? If not there are some packages that have to be rebuild (qt, qt3, php and others).
Unfortunatelly not, .so bump 15 -> 16, so i rebuilt the packages that were listed in the libmysqlclient package.
Em Terça-feira 24 Março 2009, às 08:32:34, Pierre Schmitz escreveu:
Am Dienstag, 24. März 2009 12:28:25 schrieb Douglas Soares de Andrade:
Hi guys,
Finnaly i took some time and updated mysql to testing. I did almost all the needed rebuilds - i did not rebuilt dovecot as it needs the new libpcap, can someone build it for me ? - Im also uploading mysql-gui-tools 5.0r14 for my public page.
Thanks all =)
Just a little question about this. You compiled with "--with-charset=latin1 -- with-collation=latin1_general_ci" Is there a reason for doing so? I wonder if utf8 might be better but I am not sure if that would break compatibility.
Hi Pierre, Sometime ago, when i started to work in the mysql update, i was going to use utf8, but, talking to Jan, he pointed some cases where this could break existing databases, so i had to maintain latin-1 as the default encoding.
Douglas Soares de Andrade schrieb:
Just a little question about this. You compiled with "--with-charset=latin1 -- with-collation=latin1_general_ci" Is there a reason for doing so? I wonder if utf8 might be better but I am not sure if that would break compatibility.
Hi Pierre,
Sometime ago, when i started to work in the mysql update, i was going to use utf8, but, talking to Jan, he pointed some cases where this could break existing databases, so i had to maintain latin-1 as the default encoding.
You can still choose the collation on a per-database basis, so this shouldn't hurt anyone!
Douglas Soares de Andrade schrieb:
i did not rebuilt dovecot as it needs the new libpcap, can someone build it for me ?
I cannot see a new libpcap. According to the homepage, libpcap 1.0.0 is the most recent version.
Douglas Soares de Andrade schrieb:
i did not rebuilt dovecot as it needs the new libpcap, can someone build it for me ?
I assume this is because you are not running [testing] on the machine where you are building packages. So, I will once again point out this: http://wiki.archlinux.org/index.php/DeveloperWiki:Building_in_a_Clean_Chroot That allows you to easily create a chroot with [testing] enabled to build packages. Allan
Em Terça-feira 24 Março 2009, às 09:22:53, Allan McRae escreveu:
Douglas Soares de Andrade schrieb:
i did not rebuilt dovecot as it needs the new libpcap, can someone build it for me ?
I assume this is because you are not running [testing] on the machine where you are building packages. So, I will once again point out this: http://wiki.archlinux.org/index.php/DeveloperWiki:Building_in_a_Clean_Chroo t
That allows you to easily create a chroot with [testing] enabled to build packages.
Thanks for poiting this out, Allan. I will create the chroots tonight in my build machine.
Allan
Em Terça-feira 24 Março 2009, às 09:09:33, Allan McRae escreveu:
Thomas Bächler wrote:
Douglas Soares de Andrade schrieb:
i did not rebuilt dovecot as it needs the new libpcap, can someone build it for me ?
I cannot see a new libpcap. According to the homepage, libpcap 1.0.0 is the most recent version.
I think he means libcap.
Allan
Right, is libcap - pardon me, i finished the mysql update at 05:30 am =)
Am Dienstag, 24. März 2009 12:28:25 schrieb Douglas Soares de Andrade:
Hi guys,
Finnaly i took some time and updated mysql to testing. I did almost all the needed rebuilds - i did not rebuilt dovecot as it needs the new libpcap, can someone build it for me ? - Im also uploading mysql-gui-tools 5.0r14 for my public page.
Thanks all =)
The mysql-fix-libs.patch is missing for mysql so I cannot build it for x86_64. -- Pierre Schmitz Clemens-August-Straße 76 53115 Bonn Telefon 0228 9716608 Mobil 0160 95269831 Jabber pierre@jabber.archlinux.de WWW http://www.archlinux.de
Em Terça-feira 24 Março 2009, às 17:01:16, Pierre Schmitz escreveu:
Am Dienstag, 24. März 2009 12:28:25 schrieb Douglas Soares de Andrade:
Hi guys,
Finnaly i took some time and updated mysql to testing. I did almost all the needed rebuilds - i did not rebuilt dovecot as it needs the new libpcap, can someone build it for me ? - Im also uploading mysql-gui-tools 5.0r14 for my public page.
Thanks all =)
The mysql-fix-libs.patch is missing for mysql so I cannot build it for x86_64.
Hi Pierre, Sorry, just commited it. By the way, it is the same used in mysql-clients. Thanks for building it for x86_64.
Am Dienstag, 24. März 2009 21:12:14 schrieb Douglas Soares de Andrade:
Em Terça-feira 24 Março 2009, às 17:01:16, Pierre Schmitz escreveu:
Am Dienstag, 24. März 2009 12:28:25 schrieb Douglas Soares de Andrade:
Hi guys,
Finnaly i took some time and updated mysql to testing. I did almost all the needed rebuilds - i did not rebuilt dovecot as it needs the new libpcap, can someone build it for me ? - Im also uploading mysql-gui-tools 5.0r14 for my public page.
Thanks all =)
The mysql-fix-libs.patch is missing for mysql so I cannot build it for x86_64.
Hi Pierre,
Sorry, just commited it. By the way, it is the same used in mysql-clients.
Thanks for building it for x86_64.
Thanks, but it does not build: gcc -DHAVE_CONFIG_H -I. -I../../include -I../../include -I../../include - I../../regex -I../../sql -I. -march=x86-64 -mtune=generic -O2 -pipe - DUNIV_LINUX -MT archive_test-archive_test.o -MD -MP -MF .deps/archive_test- archive_test.Tpo -c -o archive_test-archive_test.o `test -f 'archive_test.c' || echo './'`archive_test.c mv -f .deps/archive_test-archive_test.Tpo .deps/archive_test-archive_test.Po gcc -DHAVE_CONFIG_H -I. -I../../include -I../../include -I../../include - I../../regex -I../../sql -I. -march=x86-64 -mtune=generic -O2 -pipe - DUNIV_LINUX -MT archive_test-azio.o -MD -MP -MF .deps/archive_test-azio.Tpo -c -o archive_test-azio.o `test -f 'azio.c' || echo './'`azio.c mv -f .deps/archive_test-azio.Tpo .deps/archive_test-azio.Po make[1]: *** No rule to make target `../../mysys/libmysys.a', needed by `archive_test'. Stop. make[1]: Leaving directory `/home/pierre/chroot/arch64- testing/mysql/trunk/src/mysql-5.1.32/storage/archive' make: *** [all-recursive] Error 1 Any ideas? -- Pierre Schmitz Clemens-August-Straße 76 53115 Bonn Telefon 0228 9716608 Mobil 0160 95269831 Jabber pierre@jabber.archlinux.de WWW http://www.archlinux.de
Am Dienstag, 24. März 2009 21:28:15 schrieb Pierre Schmitz:
Thanks, but it does not build:
Well, the last update solved the problem. -- Pierre Schmitz Clemens-August-Straße 76 53115 Bonn Telefon 0228 9716608 Mobil 0160 95269831 Jabber pierre@jabber.archlinux.de WWW http://www.archlinux.de
Pierre Schmitz wrote:
Am Dienstag, 24. März 2009 21:28:15 schrieb Pierre Schmitz:
Thanks, but it does not build:
Well, the last update solved the problem.
FYI, this is the complete rebuild list for the libmysqlclient soname bumps: amarok-base courier-authlib cyrus-sasl-plugins dovecot dovecot fssos-nsvs gnokii koffice libgda lighttpd myodbc mysql mysql-clients mysql-python pdns perl-dbd-mysql php postfix qt qt3 redland Allan
Em Quarta-feira 25 Março 2009, às 08:35:04, Allan McRae escreveu:
Pierre Schmitz wrote:
Am Dienstag, 24. März 2009 21:28:15 schrieb Pierre Schmitz:
Thanks, but it does not build:
Well, the last update solved the problem.
FYI, this is the complete rebuild list for the libmysqlclient soname bumps:
Thanks Allan, I already did these rebuilds:
amarok-base cyrus-sasl-plugins libgda mysql mysql-clients mysql-python pdns perl-dbd-mysql postfix redland
Allan McRae wrote:
Pierre Schmitz wrote:
Am Dienstag, 24. März 2009 21:28:15 schrieb Pierre Schmitz:
Thanks, but it does not build:
Well, the last update solved the problem.
FYI, this is the complete rebuild list for the libmysqlclient soname bumps:
<snip>
Or just the remaining rebuilds: courier-authlib fssos-nsvs gnokii koffice myodbc mysql-python qt3 Allan
Em Quarta-feira 25 Março 2009, às 08:41:13, Allan McRae escreveu:
Allan McRae wrote:
Pierre Schmitz wrote:
Am Dienstag, 24. März 2009 21:28:15 schrieb Pierre Schmitz:
Thanks, but it does not build:
Well, the last update solved the problem.
FYI, this is the complete rebuild list for the libmysqlclient soname bumps:
<snip>
Or just the remaining rebuilds: courier-authlib fssos-nsvs gnokii koffice myodbc mysql-python qt3
I already update mysql-python too, so the remaining are: courier-authlib fssos-nsvs gnokii koffice myodbc qt3 Thanks
Am Dienstag, 24. März 2009 12:28:25 schrieb Douglas Soares de Andrade:
Hi guys,
Finnaly i took some time and updated mysql to testing. I did almost all the needed rebuilds - i did not rebuilt dovecot as it needs the new libpcap, can someone build it for me ? - Im also uploading mysql-gui-tools 5.0r14 for my public page.
Thanks all =)
Does anybody know how to upgrade to this new server? When trying to start it it fails with the following log entries: 090325 15:27:28 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 090325 15:27:28 [Warning] The syntax '--log_slow_queries' is deprecated and will be removed in MySQL 7.0. Please use '--slow_query_log'/'-- slow_query_log_file' instead. /usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist 090325 15:27:28 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 090325 15:27:28 [ERROR] /usr/sbin/mysqld: unknown option '--skip-innodb' 090325 15:27:28 [ERROR] Aborting 090325 15:27:28 [Note] /usr/sbin/mysqld: Shutdown complete 090325 15:27:28 mysqld_safe mysqld from pid file /var/lib/mysql/opteron.pid ended So, I tried sudo mysql_upgrade Looking for 'mysql' as: mysql Looking for 'mysqlcheck' as: mysqlcheck Running 'mysqlcheck'... mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) when trying to connect FATAL ERROR: Upgrade failed Does this mean I cannot start mysql until I had run mysql_upgrade? And mysql_upgrade does only work when the server is running? -- Pierre Schmitz Clemens-August-Straße 76 53115 Bonn Telefon 0228 9716608 Mobil 0160 95269831 Jabber pierre@jabber.archlinux.de WWW http://www.archlinux.de
Am Mittwoch, 25. März 2009 15:36:30 schrieb Pierre Schmitz:
Am Dienstag, 24. März 2009 12:28:25 schrieb Douglas Soares de Andrade:
Hi guys,
Finnaly i took some time and updated mysql to testing. I did almost all the needed rebuilds - i did not rebuilt dovecot as it needs the new libpcap, can someone build it for me ? - Im also uploading mysql-gui-tools 5.0r14 for my public page.
Thanks all =)
Does anybody know how to upgrade to this new server? When trying to start it it fails with the following log entries:
090325 15:27:28 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 090325 15:27:28 [Warning] The syntax '--log_slow_queries' is deprecated and will be removed in MySQL 7.0. Please use '--slow_query_log'/'-- slow_query_log_file' instead. /usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist 090325 15:27:28 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 090325 15:27:28 [ERROR] /usr/sbin/mysqld: unknown option '--skip-innodb' 090325 15:27:28 [ERROR] Aborting
090325 15:27:28 [Note] /usr/sbin/mysqld: Shutdown complete
090325 15:27:28 mysqld_safe mysqld from pid file /var/lib/mysql/opteron.pid ended
So, I tried
sudo mysql_upgrade Looking for 'mysql' as: mysql Looking for 'mysqlcheck' as: mysqlcheck Running 'mysqlcheck'... mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) when trying to connect FATAL ERROR: Upgrade failed
Does this mean I cannot start mysql until I had run mysql_upgrade? And mysql_upgrade does only work when the server is running?
Well, after removing the following config entries I was able to start mysqld and run mysql_upgrade. #skip-innodb #skip-bdb #skip-federated However: I think we'll need some kind of upgrade guide. Especially intersting would be the names of the new config parameters and how to run mysql_upgrade. -- Pierre Schmitz Clemens-August-Straße 76 53115 Bonn Telefon 0228 9716608 Mobil 0160 95269831 Jabber pierre@jabber.archlinux.de WWW http://www.archlinux.de
On Wed, 2009-03-25 at 15:47 +0100, Pierre Schmitz wrote:
Well, after removing the following config entries I was able to start mysqld and run mysql_upgrade.
#skip-innodb #skip-bdb #skip-federated
However: I think we'll need some kind of upgrade guide. Especially intersting would be the names of the new config parameters and how to run mysql_upgrade.
Is skip-innodb no longer compatible? Weird, I remember having that option on one of our databaseservers. Are you sure this mysql is built with innodb support?
Am Mittwoch, 25. März 2009 15:50:06 schrieb Jan de Groot:
Is skip-innodb no longer compatible? Weird, I remember having that option on one of our databaseservers. Are you sure this mysql is built with innodb support?
Not sure but it seems innodb is no longer supported. I can only create myisam, merged and cvs tables. -- Pierre Schmitz Clemens-August-Straße 76 53115 Bonn Telefon 0228 9716608 Mobil 0160 95269831 Jabber pierre@jabber.archlinux.de WWW http://www.archlinux.de
On Wed, 2009-03-25 at 16:13 +0100, Pierre Schmitz wrote:
Am Mittwoch, 25. März 2009 15:50:06 schrieb Jan de Groot:
Is skip-innodb no longer compatible? Weird, I remember having that option on one of our databaseservers. Are you sure this mysql is built with innodb support?
Not sure but it seems innodb is no longer supported. I can only create myisam, merged and cvs tables.
If innodb isn't disabled from config, this is a package failure. InnoDB is one of the most important engines nowadays and is still supported by MySQL 5.1.
Em Quarta-feira 25 Março 2009, às 12:13:34, Pierre Schmitz escreveu:
Am Mittwoch, 25. März 2009 15:50:06 schrieb Jan de Groot:
Is skip-innodb no longer compatible? Weird, I remember having that option on one of our databaseservers. Are you sure this mysql is built with innodb support?
Not sure but it seems innodb is no longer supported. I can only create myisam, merged and cvs tables.
In part my bad - now to use innodb (and other types) you need to specify in the ./configure process. Here is the troublemaker: --with-plugins=PLUGIN[[[,PLUGIN..]]] Plugins to include in mysqld. (default is: none) Must be a configuration name or a comma separated list of plugins. Available configurations are: none max max-no-ndb all. Available plugins are: partition daemon_example ftexample archive blackhole csv example federated heap innobase myisam myisammrg ndbcluster. So, im enabling the plugins.
Em Quarta-feira 25 Março 2009, às 12:13:34, Pierre Schmitz escreveu:
Am Mittwoch, 25. März 2009 15:50:06 schrieb Jan de Groot:
Is skip-innodb no longer compatible? Weird, I remember having that option on one of our databaseservers. Are you sure this mysql is built with innodb support?
Not sure but it seems innodb is no longer supported. I can only create myisam, merged and cvs tables.
Updated: Changed the ./configure to: ./configure --prefix=/usr --libexecdir=/usr/sbin \ --localstatedir=/var --sysconfdir=/etc \ --without-debug --without-docs --without-readline \ --enable-local-infile --with-ssl \ --with-charset=latin1 --with-collation=latin1_general_ci \ --with-extra-charsets=complex --enable-thread-safe-client \ --with-libwrap \ --with-plugins=partition,ftexample,archive,\ blackhole,federated,heap,innobase,ndbcluster And it is working great. Thanks
Em Quarta-feira 25 Março 2009, às 12:13:34, Pierre Schmitz escreveu:
Am Mittwoch, 25. März 2009 15:50:06 schrieb Jan de Groot:
Is skip-innodb no longer compatible? Weird, I remember having that option on one of our databaseservers. Are you sure this mysql is built with innodb support?
Not sure but it seems innodb is no longer supported. I can only create myisam, merged and cvs tables. uc
Am Dienstag, 24. März 2009 12:28:25 schrieb Douglas Soares de Andrade:
Hi guys,
Finnaly i took some time and updated mysql to testing. I did almost all the needed rebuilds - i did not rebuilt dovecot as it needs the new libpcap, can someone build it for me ? - Im also uploading mysql-gui-tools 5.0r14 for my public page.
Thanks all =)
I have added a todo list at https://dev.archlinux.org/todo/8/ -- Pierre Schmitz Clemens-August-Straße 76 53115 Bonn Telefon 0228 9716608 Mobil 0160 95269831 Jabber pierre@jabber.archlinux.de WWW http://www.archlinux.de
Am Montag, 30. März 2009 19:51:26 schrieb Pierre Schmitz:
Am Dienstag, 24. März 2009 12:28:25 schrieb Douglas Soares de Andrade:
Hi guys,
Finnaly i took some time and updated mysql to testing. I did almost all the needed rebuilds - i did not rebuilt dovecot as it needs the new libpcap, can someone build it for me ? - Im also uploading mysql-gui-tools 5.0r14 for my public page.
Thanks all =)
I have added a todo list at https://dev.archlinux.org/todo/8/
To speed things up I have completed the list except koffice and myodbc which both don't compile anymore. -- Pierre Schmitz Clemens-August-Straße 76 53115 Bonn Telefon 0228 9716608 Mobil 0160 95269831 Jabber pierre@jabber.archlinux.de WWW http://www.archlinux.de
On Tue, Mar 31, 2009 at 1:30 PM, Pierre Schmitz <pierre@archlinux.de> wrote:
Am Montag, 30. März 2009 19:51:26 schrieb Pierre Schmitz:
Am Dienstag, 24. März 2009 12:28:25 schrieb Douglas Soares de Andrade:
Hi guys,
Finnaly i took some time and updated mysql to testing. I did almost all the needed rebuilds - i did not rebuilt dovecot as it needs the new libpcap, can someone build it for me ? - Im also uploading mysql-gui-tools 5.0r14 for my public page.
Thanks all =)
I have added a todo list at https://dev.archlinux.org/todo/8/
To speed things up I have completed the list except koffice and myodbc which both don't compile anymore.
I assume koffice still fails against libpqxx3. I planned to fix it by building against a libpqxx2 package but after my initital attempt failed I haven't had much time to look into it. I'll see if I can fix it in the next couple of days, otherwise I'll just disable the libpqxx backend in kexi. Ronald
participants (6)
-
Allan McRae
-
Douglas Soares de Andrade
-
Jan de Groot
-
Pierre Schmitz
-
Ronald van Haren
-
Thomas Bächler