On Tue, Nov 16, 2004 at 12:39:54PM -0800, Brion Vibber wrote:
On Nov 16, 2004, at 11:48 AM, Jot Powers wrote:
* Connected to database... 4.1.7-standard;
enabling MySQL 4
enhancements
Before you do anything else, recompile PHP from source and make sure it
uses the updated MySQL client libraries.
Ok, it seems to have been a combination of things. Here is what
I did.
1) Removed the older mysql and php packages that were installed.
rpm -e --nodeps mysql-3.23.58-1
rpm -e --nodeps mysql-devel-3.23.58-1
rpm -e --nodeps php-mysql-4.3.2-11.ent
rpm -e --nodeps php-4.3.2-11.ent
2) Blew away /var/lib/mysql
3) Reinstalled the latest SQL rpms
rpm -i --nodeps --force MySQL-server-4.1.7-0.i386.rpm
rpm -i --nodeps --force MySQL-client-4.1.7-0.i386.rpm
4) Recompiled and installed the latest version of php
(don't forget to run libtool! It scrolled off my screen
and took me a few minutes to figure out why my lib wasn't
being installed)
5) Configured Apache to load the module (different location)
6) Editted my /etc/php.ini to include /usr/local/lib/php
7) Restarted the SQL server
8) Tried the install
It still failed, but it failed complaining differently about the
DB. Looked like it might be user related so I once again
did the following (necessitated because I had blown away the
DB intentionally in step #2)
9) mysql> update mysql.user set password = OLD_PASSWORD('XXXXXX')
-> where host = 'localhost' and user = 'wikiuser';
10) mysql> grant all privileges on db.* to wikiuser@'localhost';
mysql> flush privileges;
11) Shutdown sql server
12) Edit /etc/init.d/mysql to include --old-passwords
13) Started the sql server up and tried the MediaWiki install again.
VOILA! Success!
Thanks for the recommendations, it seemed to get me to stick
to the right track.
-Jot
--
Jot Powers <misc(a)bofh.com>
http://www.bofh.com/
"I'm upping my standards, so up yours!"
-Pat Paulsen (1927-1997), Presidential Campaign Slogan