http://bugzilla.novell.com/show_bug.cgi?id=496196 User drankinatty@suddenlinkmail.com added comment http://bugzilla.novell.com/show_bug.cgi?id=496196#c12 David Rankin <drankinatty@suddenlinkmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEEDINFO |ASSIGNED Info Provider|drankinatty@suddenlinkmail. | |com | --- Comment #12 from David Rankin <drankinatty@suddenlinkmail.com> 2009-06-25 14:06:10 MDT --- [14:19 ecstasy:/home/david] # zypper up -t package -r database Downloading repository 'openSUSE BuildService - Database' metadata [done] Building repository 'openSUSE BuildService - Database' cache [done] Reading installed packages... The following packages are going to be upgraded: mysql-client mysql libmysqlclient16 libmysqlclient_r16 Overall download size: 10.7 M. After the operation, 2.1 M will be freed. Continue? [YES/no]: Downloading package libmysqlclient16-5.1.35-32.1.x86_64 (1/4), 490.0 K (1.4 M unpacked) Downloading: libmysqlclient16-5.1.35-32.1.x86_64.rpm [done (75.5 K/s)] Installing: libmysqlclient16-5.1.35-32.1 [done] Downloading package libmysqlclient_r16-5.1.35-32.1.x86_64 (2/4), 494.0 K (1.4 M unpacked) Downloading: libmysqlclient_r16-5.1.35-32.1.x86_64.rpm [done (94.8 K/s)] Installing: libmysqlclient_r16-5.1.35-32.1 [done] Downloading package mysql-client-5.1.35-32.1.x86_64 (3/4), 157.0 K (372.0 K unpacked) Downloading: mysql-client-5.1.35-32.1.x86_64.rpm [done (65.3 K/s)] Installing: mysql-client-5.1.35-32.1 [done] Downloading package mysql-5.1.35-32.1.x86_64 (4/4), 9.6 M (26.0 M unpacked) Downloading: mysql-5.1.35-32.1.x86_64.rpm [done (132.3 K/s)] Installing: mysql-5.1.35-32.1 [done] Seems to be an issue with the "rcmysql status" response: [14:29 ecstasy:/home/david] # rcmysql restart Restarting service MySQL Shutting down service MySQL done Starting service MySQL done [14:30 ecstasy:/home/david] # rcmysql status Checking for service MySQL: It isn't reporting that it is running for some reason?? Let's see: [14:31 ecstasy:/etc] # l /var/run/mysql/ total 12 -rw-rw---- 1 mysql mysql 6 2009-06-25 14:30 mysqld.pid [14:31 ecstasy:/etc] # l /var/lib/mysql | grep sock srwxrwxrwx 1 mysql mysql 0 2009-06-25 14:30 mysql.sock= pid is in /var/run/mysql/ .sock is in /var/lib/mysql/, seem to work fine that way. I can get to all the database driven apps without any problems. So that is fixed! OK, let's test 10.3: Current version: Server version: 5.0.67 SUSE MySQL RPM [14:39 providence/home/david] # l /var/lib/mysql/ total 20556 drwxr-xr-x 6 mysql mysql 4096 2009-06-25 14:39 ./ drwxr-xr-x 50 root root 4096 2009-06-25 02:33 ../ -rw-rw---- 1 mysql mysql 10485760 2009-06-25 14:18 ibdata1 -rw-rw---- 1 mysql mysql 5242880 2009-06-25 14:39 ib_logfile0 -rw-rw---- 1 mysql mysql 5242880 2009-06-25 14:17 ib_logfile1 drwx------ 2 mysql mysql 4096 2009-06-25 14:17 mysql/ -rw-rw---- 1 mysql mysql 2059 2009-06-25 14:39 mysqld.log -rw-rw---- 1 mysql mysql 6 2009-06-25 14:39 mysqld.pid srwxrwxrwx 1 mysql mysql 0 2009-06-25 14:39 mysql.sock= -rw-r--r-- 1 mysql mysql 6 2009-06-25 14:17 mysql_upgrade_info Prior to upgrade both .sock and .pid are in /var/lib/mysql/ Uh, Oh... Houston, we have a problem with 10.3: [14:41 providence/home/david] # zypper up -t package -r database Refreshing 'openSUSE BuildService - Database' * Cleaning repository 'openSUSE BuildService - Database' cache * Building repository 'openSUSE BuildService - Database' cache * Reading repository 'openSUSE BuildService - Database' cache * Reading installed packages [100%] The following packages are going to be upgraded: mysql-client mysql The following NEW packages are going to be installed: libmysqlclient16 libmysqlclient_r16 Overall download size: 12.7 M. After the operation, additional 4.9 M will be used. Continue? [yes/no]: yes Downloading package libmysqlclient16-5.1.35-32.1.i586, 637.7 K (1.3 M unpacked) Downloading: libmysqlclient16-5.1.35-32.1.i586.rpm * Downloading [100%] * Installing: libmysqlclient16-5.1.35-32.1 [100%] Downloading package libmysqlclient_r16-5.1.35-32.1.i586, 648.5 K (1.3 M unpacked) Downloading: libmysqlclient_r16-5.1.35-32.1.i586.rpm * Downloading [100%] * Installing: libmysqlclient_r16-5.1.35-32.1 [100%] Downloading package mysql-client-5.1.35-32.1.i586, 183.7 K (317.0 K unpacked) Downloading: mysql-client-5.1.35-32.1.i586.rpm * Downloading [100%] * Installing: mysql-client-5.1.35-32.1 [100%] Downloading package mysql-5.1.35-32.1.i586, 11.3 M (24.7 M unpacked) Downloading: mysql-5.1.35-32.1.i586.rpm * Downloading [100%] * Installing: mysql-5.1.35-32.1 [100%] [14:45 providence/home/david] # mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) [14:45 providence/home/david] # rcmysql status Checking for service MySQL: unused [14:45 providence/home/david] # rcmysql start Will update MySQL now, if you encounter any problems, please read following file: /usr/share/doc/packages/mysql/README.SuSE Running protected MySQL... error: /var/run/mysql/protected/mysql.sock file didn't appeared... failed [14:48 providence/home/david] # rcmysql status Checking for service MySQL: unused [14:48 providence/home/david] # l /etc/my.* -rw-rw---- 1 mysql mysql 6336 2009-06-25 14:41 /etc/my.cnf -rw-rw---- 1 mysql mysql 6273 2009-06-23 13:48 /etc/my.cnf.rpmnew [14:48 providence/home/david] # mv /etc/my.cnf /etc/my.cnf.sav [14:49 providence/home/david] # cp /etc/my.cnf.rpmnew /etc/my.cnf [14:49 providence/home/david] # rcmysql start Will update MySQL now, if you encounter any problems, please read following file: /usr/share/doc/packages/mysql/README.SuSE Running protected MySQL... Upgrading MySQL... Looking for 'mysql' as: /usr/bin/mysql Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck Running 'mysqlcheck'... Running 'mysqlcheck'... mysql.columns_priv OK mysql.db OK mysql.func OK <snip> Running 'mysql_fix_privilege_tables'... OK Starting service MySQL done OK, except for the situation where the /etc/my.cnf has been modified forcing the creation of /etc/my.cnf.rpmnew, the new packages work great! For this response I did upgrades on 3 servers one 11.0 and two 10.3. All worked fine after changing the my.cnf. I don't know how you handle the my.cnf issue. The biggest problem that remains is that upon install, no notice is given that mysql hasn't restarted until you manually check or hit one of your web pages. Then, there needs to be something that tells the admin that the location of the .pid file has changed and that to restart mysql, he will need to update my.cnf or simply copy my.cnf.rpmnew over the existing my.cnf and restart mysql to restore operation. Without some kinds of notice, the poor guy could be left scratching his head for a while, checking mailing lists, googling bugs, etc. unless he is told what has changes. Adding a post-install script that provides that WARNING would be a great way to resolve the issue for this -- and -- then next few updates (in case the user misses one or two of the updates) With that, I think this bug is squashed! -- Configure bugmail: http://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.