Ok guys, here is the status
First of all, thank you all for your help, I've managed to get this far just beacause of your help! I promise i'm gonna make a great howto when we're done!
I've managed to build these RPM's with rpmbuild --rebuild package
Mysql
- mysql-4.1.9-1.i386.rpm - mysql-bench-4.1.9-1.i386.rpm - mysql-debuginfo-4.1.9-1.i386.rpm - mysql-devel-4.1.9-1.i386.rpm - mysql-server-4.1.9-1.i386.rpm
PHP
- php-5.0.3-2.i386.rpm - php-debuginfo-5.0.3-2.i386.rpm - php-devel-5.0.3-2.i386.rpm - php-gd-5.0.3-2.i386.rpm - php-imap-5.0.3-2.i386.rpm - php-ldap-5.0.3-2.i386.rpm - php-mbstring-5.0.3-2.i386.rpm - php-mysql-5.0.3-2.i386.rpm - php-ncurses-5.0.3-2.i386.rpm - php-odbc-5.0.3-2.i386.rpm - php-pear-5.0.3-2.i386.rpm - php-pgsql-5.0.3-2.i386.rpm - php-snmp-5.0.3-2.i386.rpm - php-soap-5.0.3-2.i386.rpm - php-xml-5.0.3-2.i386.rpm - php-xmlrpc-5.0.3-2.i386.rpm
SQLite
- sqlite3-3.0.8-3.i386.rpm - sqlite3-debuginfo-3.0.8-3.i386.rpm - sqlite3-devel-3.0.8-3.i386.rpm
Well done!
I tried installing MySQl first and recieved this message: #>rpm -hUv mysql-4.1.9-1.i386.rpm error: Failed dependencies: libmysqlclient.so.10 is needed by (installed) perl-DBD-MySQL-2.9003-5.i386 libmysqlclient.so.10 is needed by (installed) mod_auth_mysql-20030510-5.i386 libmysqlclient.so.10 is needed by (installed) cyrus-sasl-sql-2.1.19-3.i386 libmysqlclient.so.10 is needed by (installed) libdbi-dbd-mysql-0.6.5-9.i386 libmysqlclient.so.10 is needed by (installed) qt-MySQL-3.3.3-8.i386 libmysqlclient.so.10 is needed by (installed) gda-mysql-1.0.4-3.i386 libmysqlclient.so.10 is needed by (installed) freeradius-mysql-1.0.1-1.i386 libmysqlclient.so.10 is needed by (installed) php-mysql-4.3.10-3.2.i386 libmysqlclient.so.10 is needed by (installed) dovecot-0.99.13-3.FC3.i386 libmysqlclient.so.10 is needed by (installed) mysql-server-3.23.58-14.i386 libmysqlclient.so.10 is needed by (installed) MyODBC-2.50.39-19.1.i386 libmysqlclient_r.so.10 is needed by (installed) MySQL-python-0.9.2-4.i386 mysql = 3.23.58 is needed by (installed) mysql-server-3.23.58-14.i386 mysql = 3.23.58 is needed by (installed) mysql-devel-3.23.58-14.i386 mysql = 3.23.58 is needed by (installed) mysql-bench-3.23.58-14.i386
Well... i've done a rpm -q on all the packages listed to see if i have them and i do... then i took a second look and deducted that i need libmysqlclient.so.10 ... is that available in the same dev dir? maybe... i'll go see..
The mysql package is probably going to be the hardest one to install actually.
The problems you're having here are because you already have all of these standard FC3 packages installed but they are built against the MySQL version 3 libraries, so when you update to version 4, they will no longer work.
What you need to be able to do is to install the version 4 libraries and also an additional "backwards compatibility" package at the same time containing the version 3 libraries.
There is an article here: http://fedoranews.org/contributors/tony_smith/mysql/ that shows one way of creating such a package.
Paul.