Koozali.org: home of the SME Server

Legacy Forums => Suggestions => Topic started by: chaissac on January 20, 2004, 04:48:15 PM

Title: MySql 4.x
Post by: chaissac on January 20, 2004, 04:48:15 PM

Could we please consider the passage in version 4.x of MySql, to enjoy the variables, the subqueries, etc... ?

Title: Re: MySql 4.x
Post by: dsemuk on January 20, 2004, 04:55:55 PM

Quote from: "chaissac"

Could we please consider the passage in version 4.x of MySql, to enjoy the variables, the subqueries, etc... ?

MySQL can be updated to v4.x by following this simple howto:

http://forums.contribs.org/index.php?topic=18597.0

Dave

Title: Re: MySql 4.x
Post by: chaissac on January 20, 2004, 07:06:46 PM

Quote from: "dsemuk"

http://forums.contribs.org/index.php?topic=18597.0

Doesn't seem to work  :cry:

"No posts exist for this topic"

But it seems to be a forum failure. Hope it will be fix soon  :lol:

Title: MySQL 4.x howto
Post by: ergozd on January 20, 2004, 07:54:40 PM

Cut & paste from the link. ;-)

UPDATING TO MYSQL 4.0..(tested on sme 6.0b3)

1. STOP MYSQL

/etc/rc.d/init.d/mysql stop

2. REMOVE OLD RPM

rpm -e --nodeps mysql-client mysql-server
rpm -e mysql-devel
rpm -e mysqlclient9

3. DOWNLOAD MySQL 4.0. FROM WWW.MYSQL.COM

INSTAL NEW RPMS:

rpm -Uhv MySQL-server-4.0.15-0.i386.rpm
rpm -Uhv MySQL-client-4.0.15-0.i386.rpm
rpm -Uhv MySQL-shared-compat-4.0.15-0.i386.rpm
rpm -Uvh MySQL-devel-4.0.15-0.i386.rpm

4. CONFIGURE

chkconfig --levels 2345 mysql on
rm /etc/rc.d/rc7.d/S90mysqld
ln -s /etc/rc.d/init.d/mysql /etc/rc.d/rc7.d/S90mysqld

/sbin/e-smith/config setprop mysqld LocalNetworkingOnly no (enable remote access)
/sbin/e-smith/expand-template /root/.my.cnf
/etc/rc.d/init.d/mysql restart

5. ENJOY..

Title: MySQL 4.x howto
Post by: ergozd on January 20, 2004, 07:55:20 PM

Cut & paste from the link. ;-)

UPDATING TO MYSQL 4.0..(tested on sme 6.0b3)

1. STOP MYSQL

/etc/rc.d/init.d/mysql stop

2. REMOVE OLD RPM

rpm -e --nodeps mysql-client mysql-server
rpm -e mysql-devel
rpm -e mysqlclient9

3. DOWNLOAD MySQL 4.0. FROM WWW.MYSQL.COM

INSTAL NEW RPMS:

rpm -Uhv MySQL-server-4.0.15-0.i386.rpm
rpm -Uhv MySQL-client-4.0.15-0.i386.rpm
rpm -Uhv MySQL-shared-compat-4.0.15-0.i386.rpm
rpm -Uvh MySQL-devel-4.0.15-0.i386.rpm

4. CONFIGURE

chkconfig --levels 2345 mysql on
rm /etc/rc.d/rc7.d/S90mysqld
ln -s /etc/rc.d/init.d/mysql /etc/rc.d/rc7.d/S90mysqld

/sbin/e-smith/config setprop mysqld LocalNetworkingOnly no (enable remote access)
/sbin/e-smith/expand-template /root/.my.cnf
/etc/rc.d/init.d/mysql restart

5. ENJOY..

Title: MySql 4.x
Post by: chaissac on January 21, 2004, 10:13:19 AM

thx for the explanations.

During this time, the forum ended up functioning again, so the link works now.

I'll try it soon, it's a real need.

BTW, I maintenances my position: it would be nice to update mysql (and php besides) in the future isos of SME Server.

 :pint:
one pint to help to swallow my bad English :-) !

Title: MySql 4.x
Post by: grand-pa on January 22, 2004, 02:10:06 AM

I agree. For the SME Server v7.0 ;-) it would be nice to have at least (and even newer if available) :
- Apache v2.x
- MySQL v4.x
- PHP v5.x
- PERL v6.x

For the two last ones, i know they are not yet released, but for the v7.0, who knows... :-D
And, yes, i know it's a very huge work to do. :cry:

Title: MySql 4.x
Post by: Anonymous on January 23, 2004, 12:48:48 AM

I guess the 'latest and greatest' does not imply thew most stable and secure.

So maybe a discussion about 'policy' may be usefull.

Let me start off by my point of view;

I go for stable and secure, I can always update server components if I need to do so, and I myself will be responisble for doing so.

Any thoughts?

RequestedDeletion

Title: MySql 4.x
Post by: grand-pa on January 23, 2004, 01:20:06 AM

You're wright, the very last version isn't always the best choice.
But i think there is a need to upgrade some componants with the latest major release versions (ie. Apache 1.3.x -> 2.0.x).

Title: MySql 4.x
Post by: webster on January 23, 2004, 10:43:14 PM

Quote from: "Anonymous"

I guess the 'latest and greatest' does not imply thew most stable and secure.

RequestedDeletion

I Agree Latest and greatest isnt the best option, but there are also problems in the other direction.
Some othe the lesser important packages(to the operation of the server and security) like php, perl, mysql etc have been lagging (i guess the view has always been if they do what they need to, there is need to change it) which means people have to "try" :-?  and upgrade them themselves.

The problem I see(and have found) is that anyone that wants to use these other packages often find some of the features are are missing because they are so old and limited...so its becomes harder to do things that we would like to. :cry:

From what I read on a previous post.... the php/gd version on the current system is from about feb 2002? packages from this age could atleast be upgraded to something from last year!! (not thats not me volunteering!!!  :-( )

anyone want to share thier view... visit my previous post and use the poll
http://forums.contribs.org/index.php?topic=20283.msg79813#msg79813

Title: MySql 4.x
Post by: haj on January 27, 2004, 12:13:54 AM

Latest version are needed if they give essential new features...

Quote from: "grand-pa"

Apache v2.x

I have had a try with it on redhat 8.0 and it is realy slow!