On 12 May 2001 00:51:11 +0300, Michael Widenius wrote: > > You can now find MySQL-Max (MySQL binaries with support for the above > table types) for most supported platforms at > http://www.mysql.com/downloads/mysql-max-3.23.html That's great news!!! Congratulations, guys! Now the problems: :-) Everything i say here is valid for Linux Red Hat 7.0 (with all bugfixes applied) running on a dual-PIII. 1. If i download the RPM binaries from mysql.com and install them, everything's fine. I can login into the database and to all kind of fun things: ########################################## [florin@stantz florin]$ mysql -u root Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 3.23.38-Max Type 'help;' or '\h' for help. Type '\c' to clear the buffer mysql> show databases; +----------+ | Database | +----------+ | mysql | | test | +----------+ 2 rows in set (0.00 sec) mysql> exit; Bye [florin@stantz florin]$ ########################################## But if i download the src.rpm, rebuild it and install the resulted rpm binaries, many simple SQL commands do not work: ########################################### [root@stantz /root]# mysql -u root Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 3.23.38-Max Type 'help;' or '\h' for help. Type '\c' to clear the buffer mysql> show databases; +----------+ | Database | +----------+ | | | | | | | | | | | | | | +----------+ 7 rows in set (0.00 sec) mysql> exit; Bye [root@stantz /root]# ############################################ I had to uninstall my binaries and reinstall the downloaded ones to make it work again. 2. You may ask why i should rebuild the src.rpm when you already provided i386.rpm's that work? Well, the problem is, there's an incompatibility between your binaries and Red Hat. See here: ############################################# [root@stantz RPMS]# rpm -Uvh php-mysql-4.0.4pl1-9.i386.rpm error: failed dependencies: mysql is needed by php-mysql-4.0.4pl1-9 [root@stantz RPMS]# ############################################# Apparently, your packages provide a different set of "rpm-provides" than the ones from Red Hat. So then, even if i have your MySQL RPMs installed, the packages from Red Hat do not "see" them and refuse to install. My quick fix was to uninstall your binaries, download the src.rpm, rebuild it and install the resulted RPMs. But then, the mysql binaries do not work (see previous problem). What next? :-/ The patch for the .spec file that makes your binaries play well together with the Red Hat collection :-P is attached to this message. It's just a microscopic modification to the "Provides" line, and it shouldn't do any harm. Please, please include it in the "official" mysql rpms! Best regards, and keep up the good work! -- Florin Andrei "Remember, son: if you never try, you never fail" - Homer Simpson
--- mysql-3.23.38.spec.orig Wed May 9 13:56:54 2001 +++ mysql-3.23.38.spec Mon May 14 16:09:46 2001 @@ -18,7 +18,7 @@ URL: http://www.mysql.com/ Packager: David Axmark <[EMAIL PROTECTED]> Vendor: MySQL AB -Provides: msqlormysql MySQL-server +Provides: msqlormysql MySQL-server mysql Obsoletes: mysql # Think about what you use here since the first step is to
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <mysql-unsubscribe-##L=##[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php