MySQL 5.0 released

i download rpm then i run
Code:
#!/bin/sh

/etc/rc.d/init.d/mysqld stop


rpm -Uvh ./MySQL-server-4.1.14-0.i386.rpm
rpm -Uvh ./MySQL-client-4.1.14-0.i386.rpm
rpm -Uvh ./MySQL-shared-4.1.14.i386.rpm
rpm -Uvh ./MySQL-devel-4.1.14-0.i386.rpm


/etc/rc.d/init.d/mysqld restart


rm -f /etc/init.d/mysql
rm -f /etc/rc?.d/*mysql



exit 0;

still 5.0.15 run :confused:
tell me stip by stop if you can ;)
 
runing this before
Code:
#!/bin/sh

/etc/rc.d/init.d/mysqld stop


rpm -Uvh ./MySQL-server-4.1.14-0.i386.rpm
rpm -Uvh ./MySQL-client-4.1.14-0.i386.rpm
rpm -Uvh ./MySQL-shared-4.1.14.i386.rpm
rpm -Uvh ./MySQL-devel-4.1.14-0.i386.rpm


/etc/rc.d/init.d/mysqld restart


rm -f /etc/init.d/mysql
rm -f /etc/rc?.d/*mysql



exit 0;

then take a look here

Code:
warning: ./MySQL-server-4.1.14-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
Preparing...                ########################################### [100%]
        package MySQL-server-5.0.15-0 (which is newer than MySQL-server-4.1.14-0) is already installed
warning: ./MySQL-client-4.1.14-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
Preparing...                ########################################### [100%]
        package MySQL-client-5.0.15-0 (which is newer than MySQL-client-4.1.14-0) is already installed
error: open of ./MySQL-shared-4.1.14.i386.rpm failed: No such file or directory
warning: ./MySQL-devel-4.1.14-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
Preparing...                ########################################### [100%]
        package MySQL-devel-5.0.15-0 (which is newer than MySQL-devel-4.1.14-0) is already installed
No mysqld pid file found. Looked for /var/lib/mysql/server.******.*****.pid.


in DA show MySQL 5.0.15
 
Phpinfo
Code:
Active Persistent Links 	2
Active Links 	3
Client API version 	5.0.15
MYSQL_MODULE_TYPE 	external
MYSQL_SOCKET 	/var/lib/mysql/mysql.sock
MYSQL_INCLUDE 	-I/usr/include/mysql
MYSQL_LIBS 	-L/usr/lib -lmysqlclient
 
Use this --force

Code:
#!/bin/sh

cd $HOME

echo -e "\n\n\033[1;37mUpgrade to what version? (e.g. 4.1.10a )\033[0m"
read INSTALL_VER

echo -e "\n\n\033[1;37mUpgrading to MySQL ${INSTALL_VER}\033[0m\n\n";

wget [url]http://mysql.he.net/Downloads/MySQL-4.1/MySQL-server-[/url]${INSTALL_VER}-0.i386.rpm
wget [url]http://mysql.he.net/Downloads/MySQL-4.1/MySQL-client-[/url]${INSTALL_VER}-0.i386.rpm
wget [url]http://mysql.he.net/Downloads/MySQL-4.1/MySQL-devel-[/url]${INSTALL_VER}-0.i386.rpm

rpm -Uh --force ./MySQL-server-${INSTALL_VER}-0.i386.rpm ./MySQL-client-${INSTALL_VER}-0.i386.rpm ./MySQL-devel-${INS$

rm -fr ./MySQL-server-${INSTALL_VER}-0.i386.rpm ./MySQL-client-${INSTALL_VER}-0.i386.rpm ./MySQL-devel-${INSTALL_VER}$

/sbin/service mysql restart

echo -e "\n\n\033[1;37mSuccessfully upgraded to MySQL ${INSTALL_VER}\033[0m\n\n";

exit 0;
 
Code:
package MySQL-devel-5.0.15-0 (which is newer than MySQL-devel-4.1.14-0) is already installed


now i use --force --nodeps



then
cd /usr/local/directadmin/customapache
./build clean
./build update
./build all d

RedHat:

/sbin/service httpd restart

FreeBSD:

/usr/local/etc/rc.d/httpd restart

now ok show in DA MySQL 4.1.14 :D :D :D


but still error in all forums in server and i go back to MySQL 5 :mad:
 
So, it's ok to install the default rpms from mysql.com? We don't need to install a customised DirectAdmin RPM?
 
hmm, weird.

I've installed the latest MySQL rpms from mysql.com. DA shows
MySQL 5.0.19 Running
in System Information.

However phpinfo still shows MySQL 4.1.11. I've rerun

make
and
make install

in my php 5.1.2 folder as well as reloaded apache. However I'm still getting the old mysql version reflected in phpinfo. Any ideas?


----
UPDATE
--
Fixed it by actually running configure.php first before Make and Make Install. Had forgotten all about it.
 
Last edited:
my recent DA installation, installed 5.0.15 by default. shows up in DA and in phpinfo...
 
Tarionyx,

Do you mean that DA installed MySQL automatically?

tarionyx said:
my recent DA installation, installed 5.0.15 by default. shows up in DA and in phpinfo...
 
My recollection is that DA will install MySQL if it's not already installed.

Jeff
 
albatroz said:
Tarionyx,

Do you mean that DA installed MySQL automatically?

yes, when you run the DA installation, like Jeff said, it'll install it automatically. In my case it installed 5.0.15...
 
CrazyLane said:
MySQL 5 will break oscommerce and other carts based on oscommerce. joins and oscommerce are written incorrectly.

Joins are handled differently mysql5.

There's a workaround for this, and one of our customers who we designed a cart around OSCommerce for them, we had to alter two pages for it to work correctly...no big deal
 
So I take it we can not rely on this page to be updated then?

http://www.directadmin.com/install.html

At least as far as what is installed.

I personally do not want MySQL 5 installed and would be a little pissed if I had to redo a bunch of stuff on a fresh install after checking the above page before installation.
 
mysql5 is an issue with DA I think, john listened to my comments but didnt sound too keen on making mysql optional, or choice of version on installation.

Even when I had mysql 4.1.18 already installed DA overwrote it with 5.x.
 
Ouch! Is there some reason they want to force us to use MySQL5? I mean are they depending on it in any way as far as wanting to have only one install routine and will only use latest versions or something?

Otherwise we have to uninstall it and reinstall it. I just hate mucking with a fresh install.

Plus I hate to deviate from the standard base when I am new to a CP.
 
Well it would be for ease of maintaing their install script I think and support.
 
Chrysalis, our servers are running MySQL 4, as listed on the DA site. Did you make a typo? Or did DA really install MySQL 5 on your server?

Jeff
 
Back
Top