Topic: Upgrading Mysql to 4.0 ...

[chrsim]

I got this link from the web links.
http://mirror.contribs.org/smeserver/contribs/star/mitel/contrib/howto-mysql4.txt
Thank for replies :
I did actually try this link, and even if it seemed to go right, I lost the sockets. And because I am more a Network & security guy, I was not able to see where the problem was. The daemon was not able to wake up anymore. That was on a fresh install of Server-only version 6.03b. If anyone can look at the commands it will probably help us all ...
Another try was on a server+gateway with a fresh new user on mysql, just in case this could have been the problem. Sorry, this just did not work out with me. I have been on mysql.com forums, and they do not seem to have seen those problems before.

http://mirror.contribs.org/smeserver/contribs/star/mitel/contrib/howto-mysql4.txt

should be a little tweaked to reflect this new how-to

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

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
in a fresh directory
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
Should be rpm -Uvh *.pm for dependancies
4. CONFIGURE

chkconfig --levels 2345 mysql on
rm /etc/rc.d/rc7.d/S90mysqld
ln -s /etc/rc.d/init.d/mysqld /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. ENJOYING..

[maple]

What exactly went wrong?

What do u mean by "lost the sockets", could you use different words?

It seems to work on my machine.
I have installed these rpms:

Code: [Select]

MySQL-client-4.0.18-0.i386.rpm
MySQL-devel-4.0.18-0.i386.rpm
MySQL-shared-compat-4.0.18-0.i386.rpm
MySQL-server-4.0.18-0.i386.rpm

[chrsim]

Well, it did work 'my ' way, but still, if you reboot the machine, you will enjoy mysql not restarting. I am not in the contest of the biggest uptime, I run 15 databases linked to my websites and need memory. Therefore, I reboot the machine every day at early morning. After this, I have to manually reboot the mysqld otherwise it doesn't start ...

By loosing the socket, I meant that as a single
 

[root@sme /]# mysql

gave me a splendid

Code: [Select]

Can't connect to local Mysql server through socket ...
I am going over to Mysql this very minute to check.
It seems that the daemon doesn't start at reboot ...

[Tech]

I have the same problems with MySQL not starting automatically after reboot.

Appearantly, the service name has changed from "mysqld" to "mysql", Could that be the cause?

How to fix it?[/quote]

[ergozd]

I have MySQL 4.0.18 installed

To start mysql when server starts up

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/S90mysql

[maple_243]

I'm now maple_243 and not maple  

Can't connect to local Mysql server through socket...

I completelly understand now what u meant by "lossing socket" chrsim, coz the same thing is happening here.
As if that wasn't 'enough', this error is displayed when I access phpMyAdmin which I installed yesterday.

Code: [Select]

#1045 - Access denied for user: 'root@localhost' (Using password: YES)
I can't connect to MySQL server so offcourse this should happen, on the other hand it is said to be a bug by some members here.

I really am tired now so I'll just mix Noah Berlove's approach into this and see, as john's alone isn't sufficient I think. (See RPM issues in Noah Berlove's post)

I tried to reset MySQL password and got an error.

Code: [Select]

Can't exec "/usr/libexec/mysqld": No such file or directory at /etc/e-smith/events/actions/conf-mysql-password line 76.
With that I think I need to do what Noah suggest on my next reinstall,

Code: [Select]

cp /usr/sbin/mysqld /usr/libexec
cp /usr/lib/libmy* /usr/lib/mysql

[Anonymous]

Thanks ergozd,
At first I thought your version is the same as John's.

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/S90mysql

Is that a typo?
It works for me if I ommit the d.

[maple_243]

I thought I logged in already.
The above post is mine.

[maple_243]

I can't remember the axact error I had here.

Can't connect to local Mysql server through socket...

But you'll get this error if MySQL isn't running.

Code: [Select]

ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

Someone was asking about "mysql.sock" that was being deleted repeatedly. I thought it has something to do with this problem of mine so I placed /var/lib/mysql/mysql.sock
in /etc/php.ini file

mysql.default_socket = /var/lib/mysql/mysql.sock

I'm not at all sure about this so look yourself here, RedHat 7.2 Bug #60515.

For some reason I got this error again,

#1045 - Access denied for user: 'root@localhost' (Using password: YES)

but this time I was able to reset MySQL password, and that solved the problem.

I'm new to Linux/MySQL, could someone point out mistakes on this? (if there's any   )

[ergozd]

Try
See http://www.familybrown.org/howtos/mysql-password-howto.html

[haj]

Can you all review my comment here:
http://no.longer.valid/mylinks/singlelink.php?cid=208&lid=355&com_id=77&com_rootid=77&com_mode=flat&com_order=0#comment77

It works for me   [/url]

[haj]

Can you all review my comment here:
http://no.longer.valid/mylinks/singlelink.php?cid=208&lid=355

It works for me  

[wellsi]

It seems that many people want MySQL 4, but that there have been problems in making this work.

There is a mini-HowTo in the classification section that you can find below.

http://no.longer.valid/phpwiki/index.php/Upgrading%20MySQL%20to%204.0.x%20for%20SME%20Server

It would be really good if someone could write up a single definitive HowTo for upgrading to MySQL 4.

Ian

[haj]

It seems that many people want MySQL 4, but that there have been problems in making this work.

There is a mini-HowTo in the classification section that you can find below.

http://no.longer.valid/phpwiki/index.php/Upgrading%20MySQL%20to%204.0.x%20for%20SME%20Server

It would be really good if someone could write up a single definitive HowTo for upgrading to MySQL 4.

Ian

Here is a working how to.

Notice the green line that is the tip that make things work. Altought I had to install 'MySQL-shared-compat' fist to bypass dependencies problem (rpm -Uvh MySQL*.rpm should do it but haven't tried).

Please give me your feedback: it worked for me on two SME6.0
 boxes. If any problem, I will edit this post and when enought success reports are posted I will publish it.

UPDATING TO MYSQL 4.0

1. STOP MYSQL

service mysqld 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  http://www.mysql.com/downloads/mysql-4.0.html in a fresh directory.
Note: this shows 4.0.15 but replace this with the actual version downloaded.

4. INSTALL NEW RPMS:

rpm -Uhv MySQL-shared-compat-4.0.15-0.i386.rpm
rpm -Uhv MySQL-server-4.0.15-0.i386.rpm
rpm -Uhv MySQL-client-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

mv /etc/rc.d/init.d/mysql /etc/rc.d/init.d/mysqld
ln -s /etc/rc.d/init.d/mysqld /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
ln -s /usr/sbin/mysqld /usr/libexec/ (for conf-mysql-password script)

service mysqld restart

5. OPTIONAL: INNODB SUPPORT (information from Haj)

mkdir /etc/e-smith/templates-custom/etc/my.cnf
cp /etc/e-smith/templates/etc/my.cnf/009innodb /etc/e-smith/templates-custom/etc/my.cnf
pico /etc/e-smith/templates-custom/etc/my.cnf/009innodb

And comment the only line it contains so the file should look like this:

#skip-innodb

Save the file then do:

/sbin/e-smith/expand-template /etc/my.cnf
service mysqld restart

[Anonymous]

Hello,

Has this happened to anyone else. After upgrading to MySQL 4.0.18 I cannot alter or grant users privileges in the mysql db.

This command should update the privileges for the horde DB user to allow SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES but does nothing.

]# mysql < /home/httpd/html/horde/scripts/db/mysql_update_privs.sql

Additionally this should create a user called 'test' with all privileges. But in checking the mysql db the user is created but is set to no privileges, none.

]# mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 124 to server version: 4.0.18-standard

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> GRANT ALL PRIVILEGES ON test.* TO test@localhost
    -> IDENTIFIED BY 'ojbY5onXmeYz';
Query OK, 0 rows affected (0.00 sec)

mysql> quit
Bye
]# mysqladmin flush-privileges

I can make changes using PhpMyAdmin and the changes are effected.

Any thoughts?


--
Doug M.
"Rigger"