Koozali.org: home of the SME Server

How to install MySQL5 on SME7

Offline mike_mattos

  • *
  • 313
  • +0/-0
How to install MySQL5 on SME7
« on: May 30, 2006, 05:22:54 PM »
Please test on a fresh install, because it is likely to destroy some settings and data!   Perhaps someone can refine it to not kill webmail!

1 # mysql
logs in as version 4.1.12

2 mysql> quit;

3 # /etc/rc.d/init.d/supervise/mysqld status
/service/mysqld: run (pid 29128) 53510 seconds, normally down

4 # /etc/rc.d/init.d/supervise/mysqld stop
Stopping mysqld: [ OK ]

5 # /etc/rc.d/init.d/supervise/mysqld status
/service/mysqld: down 6 seconds

6 # rpm -e mysql-server --nodeps

7 # rpm -e mysql --nodeps

8 Download
http://dev.centos.org/centos/4/testing/i386/RPMS/mysql-5.0.18-1.c4.i386.rpm
http://dev.centos.org/centos/4/testing/i386/RPMS/mysql-server-5.0.18-1.c4.i386.rpm

Do NOT get the versions with 5.0.18-2.1, they fail dependecies!

9 # rpm -Uvh mysql-5.0.18-1.c4.i386.rpm

10 # rpm -Uvh mysql-server-5.0.18-1.c4.i386.rpm

11 # mysql ( see what happens )
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 5.0.18

13 reboot

14 # mysql ( make sure it restarted automatically! )
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 5.0.18

15 Check Web Mail
A fatal error has occurred
DB Error: insufficient permissions
Details have been logged for the administrator.

16 Reset per Charly Brady , destroys data!!
# cd /service/mysqld
# runsvctrl d .
# /etc/e-smith/events/actions/mysql-delete-db-files
# signal-event post-upgrade
# signal event reboot

15 Check Web Mail
GOT LOGIN!!!
...

DarkMirage

How to install MySQL5 on SME7
« Reply #1 on: May 31, 2006, 12:04:04 AM »
This would be the short version:
(Note that this includes mysqlclient because of the dependencies mentioned above)

Download and install:
Code: [Select]
wget \
http://dev.centos.org/centos/4/testing/i386/RPMS/mysqlclient14-4.1.14-4.c4.i386.rpm \
http://dev.centos.org/centos/4/testing/i386/RPMS/mysql-server-5.0.18-2.1.c4.i386.rpm \
http://dev.centos.org/centos/4/testing/i386/RPMS/mysql-5.0.18-2.1.c4.i386.rpm
rpm -U \
mysql-5.0.18-2.1.c4.i386.rpm \
mysql-server-5.0.18-2.1.c4.i386.rpm \
mysqlclient14-4.1.14-4.c4.i386.rpm


Remove extra configuration file and apply changes to daemon
Code: [Select]
rm -f /etc/my.cnf.rpmnew
service mysqld restart


Fix privileges
(See Horde issue below for details)
Code: [Select]
mysql -e "GRANT SELECT,INSERT,UPDATE,DELETE ON horde.* TO 'horde'@'localhost';FLUSH PRIVILEGES"

Testing went as follows:
System: VMWare  SME Server 7.0rc2 default configuration
Clean installation
Server Manager: Enable Webmail
MySQL: Create mydb, mydb.mytable, grant select by myuser:mypw@localhost
Backup to Desktop
Webmail login
Verify: describe mydb.mytable using myuser
(Upgrade as above)
Webmail login
Verify: describe mydb.mytable using myuser
Restore from desktop
Webmail login
Verify: describe mydb.mytable using myuser
Backup to Desktop
Restore from Desktop
Webmail login
Verify: describe mydb.mytable using myuser

All successful

Horde issue:
It seems horde does not init with a grant statement, rather it inserts what it assumes is correct.
The issue is due to missing data in mysql.db. The grant statement fixes this.
This means that after restoring a backup previous to the upgrade, this command should be reissued.
However, in the above tests, this wasn't necessary. Don't know why though...

Offline cactus

  • *
  • 4,880
  • +3/-0
    • http://www.snetram.nl
How to install MySQL5 on SME7
« Reply #2 on: May 31, 2006, 10:04:05 AM »
Quote from: "DarkMirage"
Download and install:
Code: [Select]
wget \
http://dev.centos.org/centos/4/testing/i386/RPMS/mysqlclient14-4.1.14-4.c4.i386.rpm \
http://dev.centos.org/centos/4/testing/i386/RPMS/mysql-server-5.0.18-2.1.c4.i386.rpm \
http://dev.centos.org/centos/4/testing/i386/RPMS/mysql-5.0.18-2.1.c4.i386.rpm
rpm -U \
mysql-5.0.18-2.1.c4.i386.rpm \
mysql-server-5.0.18-2.1.c4.i386.rpm \
mysqlclient14-4.1.14-4.c4.i386.rpm
Is there a special reason to install the 4.1.14 client and not the 5.0.18 client?
Be careful whose advice you buy, but be patient with those who supply it. Advice is a form of nostalgia, dispensing it is a way of fishing the past from the disposal, wiping it off, painting over the ugly parts and recycling it for more than its worth ~ Baz Luhrmann - Everybody's Free (To Wear Sunscreen)

DarkMirage

How to install MySQL5 on SME7
« Reply #3 on: May 31, 2006, 11:18:44 AM »
Quote from: "cactus"
Is there a special reason to install the 4.1.14 client and not the 5.0.18 client?


What 5.0.18 client? Didn't see it on http://dev.centos.org/centos/4/testing/i386/RPMS/

Offline cactus

  • *
  • 4,880
  • +3/-0
    • http://www.snetram.nl
How to install MySQL5 on SME7
« Reply #4 on: May 31, 2006, 12:00:33 PM »
Quote from: "DarkMirage"
Quote from: "cactus"
Is there a special reason to install the 4.1.14 client and not the 5.0.18 client?


What 5.0.18 client? Didn't see it on http://dev.centos.org/centos/4/testing/i386/RPMS/
Sorry, did not have a look there. Normally MySQL ships a client with the same version number as the server, at least on their own site. I don't understand why it isn't on the Centos site...

MySQL hosts the RHEL 4 version of there RPMS itself, maybe they will work on SME Server as well. If I have the time I might give it a go.
Be careful whose advice you buy, but be patient with those who supply it. Advice is a form of nostalgia, dispensing it is a way of fishing the past from the disposal, wiping it off, painting over the ugly parts and recycling it for more than its worth ~ Baz Luhrmann - Everybody's Free (To Wear Sunscreen)

lexi

How to install MySQL5 on SME7
« Reply #5 on: May 31, 2006, 12:38:49 PM »
I followed the how to from mike_mattos, but webmail -horde is starting in the browser fatal error.

further i tried to install phpbb for mysql test and the install script said that the the php version doesn´t support the database type.

How can the problems fixed?

Offline mike_mattos

  • *
  • 313
  • +0/-0
How to install MySQL5 on SME7
« Reply #6 on: May 31, 2006, 04:58:55 PM »
the last 3 items in the how to relate to the horde issue, also the grant statement in the follow up!

I'll try to update this again with the lastest rpm's

BTW, I put in a lot of extra steps just to be sure everything was working/shutdown, this upgrade has been a real pain in the ass for working for a while for some features, and then failing!  So please let me know if you did the webmail test & repair I suggested
...

lexi

How to install MySQL5 on SME7
« Reply #7 on: June 01, 2006, 03:56:47 PM »
i tried it as decribed and executed

rm -f /etc/my.cnf.rpmnew
service mysqld restart

mysql -e "GRANT SELECT,INSERT,UPDATE,DELETE ON horde.* TO 'horde'@'localhost';FLUSH PRIVILEGES"  too

But webmail had fatal error.

DarkMirage

How to install MySQL5 on SME7
« Reply #8 on: June 01, 2006, 04:06:16 PM »
Could you tell us a little bit more about this fatal error?
(On screen and preferably from logs)

Offline Snoopyski

  • *
  • 141
  • +0/-0
    • http://www.serviceinfosg.com
How to install MySQL5 on SME7
« Reply #9 on: June 02, 2006, 11:40:45 PM »
Hello mike_mattos,

I try it and work fine for me !!!  :-D  :-D  :-D

But I di this command:

mysql -e "GRANT SELECT,INSERT,UPDATE,DELETE ON horde.* TO 'horde'@'localhost';FLUSH PRIVILEGES"

AND I don't di this command:

16 Reset per Charly Brady , destroys data!!
# cd /service/mysqld
# runsvctrl d .
# /etc/e-smith/events/actions/mysql-delete-db-files
# signal-event post-upgrade
# signal event reboot

After I go to the server-manager and click on REBOOT AND RECONFIGURE

So everything goes fine for the moment My eGroupWare application works  :-D  :-D  :-D

So I will be able now to use SynML with eGroupWare and Outlokk...

Thanks,

Snoopyski

Offline Snoopyski

  • *
  • 141
  • +0/-0
    • http://www.serviceinfosg.com
How to install MySQL5 on SME7
« Reply #10 on: June 03, 2006, 03:06:47 PM »
Hello

I found one BUG this morning in a eGroupWare module:

PHPSYSINFO

Quote

ERRORS
File    Line    Command    Message
common_functions.php    313    file_exists(/proc/loadavg)    the file does not exist on your machine
common_functions.php    313    file_exists(/proc/sys/kernel/hostname)    the file does not exist on your machine
common_functions.php    313    file_exists(/proc/version)    the file does not exist on your machine
common_functions.php    313    file_exists(/proc/uptime)    the file does not exist on your machine
common_functions.php    152    find_program(who)    program not found on the machine
common_functions.php    313    file_exists(/proc/net/dev)    the file does not exist on your machine
common_functions.php    313    file_exists(/proc/cpuinfo)    the file does not exist on your machine
common_functions.php    313    file_exists(/proc/pci)    the file does not exist on your machine
common_functions.php    340    is_dir(/proc/ide)    directory does not exist on your machine
common_functions.php    313    file_exists(/proc/scsi/scsi)    the file does not exist on your machine
common_functions.php    313    file_exists(/proc/bus/usb/devices)    the file does not exist on your machine
common_functions.php    313    file_exists(/proc/meminfo)    the file does not exist on your machine
common_functions.php    152    find_program(df)    program not found on the machine
common_functions.php    152    find_program(mount)    program not found on the machine


Any Idea ?

Thanks,

Snoopyski

DarkMirage

How to install MySQL5 on SME7
« Reply #11 on: June 03, 2006, 09:21:37 PM »
There seems to be some security in place keeping the web server process www confined to it's own directories. Meaning php can't read files in / or /proc,  or detect programs located in PATH or things like that.

Anyway, it's completely unrelated to MySQL, try a new thread if you wish to continue trying to resolve this...

Offline Snoopyski

  • *
  • 141
  • +0/-0
    • http://www.serviceinfosg.com
How to install MySQL5 on SME7
« Reply #12 on: June 03, 2006, 10:05:33 PM »
Yes ??????????

But works before the MySQL upgrade I think !!!

I will let you know...

A+

Snoopyski

Offline mike_mattos

  • *
  • 313
  • +0/-0
How to install MySQL5 on SME7
« Reply #13 on: June 04, 2006, 02:37:45 AM »
intersting glitch ;  if you stop mysql5 with
/etc/init.d/mysqld  stop

it appears to restart but you can;'t run a MySQL session, you get an error about the socket not working.

HOWEVER,
/etc/rc.d/init.d/supervise/mysqld stop
followed by
/etc/rc.d/init.d/supervise/mysqld start
repairs the problem
...

Offline mike_mattos

  • *
  • 313
  • +0/-0
How to install MySQL5 on SME7
« Reply #14 on: August 24, 2006, 01:50:32 AM »
http://dev.centos.org/centos/4/testing/i386/RPMS/*mysql* seem to have been deleted!

the Centos rpm's that CentOS 'yum update mysql' detects work fine on my CentOS 4 system, but won't install on SME! (dependencies!)

Prior to downloading from MySQL, am I missing something obvious?  I looked in centos/4 and in centos/4.3

thx all
...

Offline cactus

  • *
  • 4,880
  • +3/-0
    • http://www.snetram.nl
How to install MySQL5 on SME7
« Reply #15 on: August 24, 2006, 11:42:46 AM »
Quote from: "mike_mattos"
http://dev.centos.org/centos/4/testing/i386/RPMS/*mysql* seem to have been deleted!

the Centos rpm's that CentOS 'yum update mysql' detects work fine on my CentOS 4 system, but won't install on SME! (dependencies!)

Prior to downloading from MySQL, am I missing something obvious?  I looked in centos/4 and in centos/4.3

thx all
Following centos bug 1124 it is now in http://mirror.centos.org/centos/4/centosplus/i386/RPMS/
Be careful whose advice you buy, but be patient with those who supply it. Advice is a form of nostalgia, dispensing it is a way of fishing the past from the disposal, wiping it off, painting over the ugly parts and recycling it for more than its worth ~ Baz Luhrmann - Everybody's Free (To Wear Sunscreen)

Offline mike_mattos

  • *
  • 313
  • +0/-0
How to install MySQL5 on SME7
« Reply #16 on: August 24, 2006, 04:43:31 PM »
here is a revised script that works (Aug 24,2006)  Note the new server and new version numbers.

Thanks DarkMirage and Cactus!


wget \
http://mirror.centos.org/centos/4/centosplus/i386/RPMS/mysqlclient14-4.1.14-4.2.c4.1.i386.rpm \
http://mirror.centos.org/centos/4/centosplus/i386/RPMS/mysql-server-5.0.22-1.centos.1.i386.rpm \
http://mirror.centos.org/centos/4/centosplus/i386/RPMS/mysql-5.0.22-1.centos.1.i386.rpm

rpm -U mysql-5.0.22-1.centos.1.i386.rpm \
mysql-server-5.0.22-1.centos.1.i386.rpm \
mysqlclient14-4.1.14-4.2.c4.1.i386.rpm

rm -f /etc/my.cnf.rpmnew
service mysqld restart

mysql -e "GRANT SELECT,INSERT,UPDATE,DELETE ON horde.* TO 'horde'@'localhost';FLUSH PRIVILEGES"
...

Offline cactus

  • *
  • 4,880
  • +3/-0
    • http://www.snetram.nl
How to install MySQL5 on SME7
« Reply #17 on: August 24, 2006, 04:48:20 PM »
Can someone confirm that webmail functions properly after this upgrade?
Be careful whose advice you buy, but be patient with those who supply it. Advice is a form of nostalgia, dispensing it is a way of fishing the past from the disposal, wiping it off, painting over the ugly parts and recycling it for more than its worth ~ Baz Luhrmann - Everybody's Free (To Wear Sunscreen)

Offline mike_mattos

  • *
  • 313
  • +0/-0
How to install MySQL5 on SME7
« Reply #18 on: August 24, 2006, 09:34:04 PM »
it worked ok for me
this was a new system, and web mail worked when I added accounts
...

Offline Jean-Philippe Pialasse

  • *
  • 2,721
  • +11/-0
  • aka Unnilennium
    • http://smeserver.pialasse.com
How to install MySQL5 on SME7
« Reply #19 on: August 25, 2006, 09:31:31 AM »
it works fine

here my methode with yum:
Code: [Select]

mysqldump -aec >mondump.sql
/etc/rc.d/init.d/mysql stop
yum --enablerepo=centosplus update mysql
/etc/rc.d/init.d/mysql start


And if the webmail has no access to the data :
Code: [Select]

mysql -e "GRANT SELECT,INSERT,UPDATE,DELETE ON horde.* TO 'horde'@'localhost';FLUSH PRIVILEGES"
[/code]

Offline kruhm

  • *
  • 680
  • +0/-0
How to install MySQL5 on SME7
« Reply #20 on: August 27, 2006, 02:34:51 PM »
any reason why nobody is using yum in this thread?

yum --enablerepo=centosplus search mysql

Offline cactus

  • *
  • 4,880
  • +3/-0
    • http://www.snetram.nl
How to install MySQL5 on SME7
« Reply #21 on: August 27, 2006, 03:09:51 PM »
Quote from: "kruhm"
any reason why nobody is using yum in this thread?

yum --enablerepo=centosplus search mysql
READ! just before you someone posted his way using yum.

The rpm command comes from people who are used to using rpm from earlier times, it allows for a lot more options, which can be very usefull if you are trying to figure out why things do not work (as long as you know what you are doing off course).

I would indeed also preffer to use yum, especially if posting Howto's as this is the preffered method of installing packages on CentOS (and therefore SME Server).
Be careful whose advice you buy, but be patient with those who supply it. Advice is a form of nostalgia, dispensing it is a way of fishing the past from the disposal, wiping it off, painting over the ugly parts and recycling it for more than its worth ~ Baz Luhrmann - Everybody's Free (To Wear Sunscreen)

Offline Rien

  • *
  • 216
  • +0/-0
    • http://www.taurix.nl
How to install MySQL5 on SME7
« Reply #22 on: August 27, 2006, 11:47:15 PM »
Hi Unnilennium,

I've a production server (SME7) with some Joomla! sites on it. The next version of Joomla (1.5) is based on MySQL 5 so I want to be able to migrate to that version.  

My SME-box is also my  mailserver and fileserver. I also have several Dungog modules installed.

How save is it to use your "yum" script on a production server?

Quote from: "unnilennium"
it works fine

here my methode with yum:
Code: [Select]

mysqldump -aec >mondump.sql
/etc/rc.d/init.d/mysql stop
yum --enablerepo=centosplus update mysql
/etc/rc.d/init.d/mysql start


And if the webmail has no access to the data :
Code: [Select]

mysql -e "GRANT SELECT,INSERT,UPDATE,DELETE ON horde.* TO 'horde'@'localhost';FLUSH PRIVILEGES"
[/code]


Thanks,
Rien
(The Netherlands)......

Offline Jean-Philippe Pialasse

  • *
  • 2,721
  • +11/-0
  • aka Unnilennium
    • http://smeserver.pialasse.com
How to install MySQL5 on SME7
« Reply #23 on: August 28, 2006, 01:26:08 AM »
Hi

I have my production server running mysql5 for few days with this methode. it works great and with php 4.3.9-3.15.

What i could add is :
-i didn't need to grant the mysql rights for the webmail it was ok for me.
-i would add another thing a new table is necessary for mysql 5 so you will have  to add it manually (if you forgot it, it may works, but it's better to have a clean install):

So here the complete how to :
Code: [Select]

mysqldump -aec >mondump.sql
/etc/rc.d/init.d/mysql stop
yum --enablerepo=centosplus update mysql
/etc/rc.d/init.d/mysql start


And if the webmail has no access to the data :
Code: [Select]

mysql -e "GRANT SELECT,INSERT,UPDATE,DELETE ON horde.* TO 'horde'@'localhost';FLUSH PRIVILEGES"


Finaly:
Code: [Select]
-- MySQL dump 10.10
--
-- Host: localhost Database: mysql
-- ------------------------------------------------------
-- Server version 5.0.22
 
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table proc
--

DROP TABLE IF EXISTS proc;
CREATE TABLE proc (
db char(64) character set utf8 collate utf8_bin NOT NULL default ,
name char(64) NOT NULL default ,
type enum('FUNCTION','PROCEDURE') NOT NULL,
specific_name char(64) NOT NULL default ,
language enum('SQL') NOT NULL default 'SQL',
sql_data_access enum('CONTAINS_SQL','NO_SQL','READS_SQL_DATA','MODIFIES_SQL_DATA') NOT NULL default 'CONTAINS_SQL',
is_deterministic enum('YES','NO') NOT NULL default 'NO',
security_type enum('INVOKER','DEFINER') NOT NULL default 'DEFINER',
param_list blob NOT NULL,
returns char(64) NOT NULL default ,
body longblob NOT NULL,
definer char(77) character set utf8 collate utf8_bin NOT NULL default ,
created timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
modified timestamp NOT NULL default '0000-00-00 00:00:00',
sql_mode     set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','NOT_USED','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NO_AUTO_CREATE_USER','HIGH_NOT_PRECEDENCE')  NOT NULL default ,
comment char(64) character set utf8 collate utf8_bin NOT NULL default ,
PRIMARY KEY (db,name,type)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Stored Procedures';

Offline fixit

  • *
  • 216
  • +0/-0
    • http://www.fixitcomputers.com.au
How to install MySQL5 on SME7
« Reply #24 on: August 28, 2006, 01:32:03 AM »
I removed my stupid post because I had no idea that mysql has been updated, my mistake
.........

Offline kruhm

  • *
  • 680
  • +0/-0
How to install MySQL5 on SME7
« Reply #25 on: August 28, 2006, 05:40:28 AM »
@catus
You'll have to forgive me if I don't have time to read every post from every member. You might want to watch your tone of voice -afterall, I'm trying to help.

Even if it is there, it probably isn't a bad idea to post it again -even now. After all, it did take everyone on this thread (including yourself) more than 20 posts to come to that joint conclusion.

Furthermore, even after the yum post (in duplicate), people are  continuing to post scripts that do what yum is already designed to do.

yum --enablerepo=centosplus search mysql
yum --enablerepo=centosplus yum <casesensitivepackagename>

Finally, there's probably good reason as to why these are not in the centos base. If a production server is in question, general wisdom would urge the server admin to follow what the maintainers recommend.

Offline Rien

  • *
  • 216
  • +0/-0
    • http://www.taurix.nl
How to install MySQL5 on SME7
« Reply #26 on: August 28, 2006, 10:57:30 PM »
Hi Unnilennium,

Thanks for your script. I updated MySQL. I had also to fix Horde but now it works fine.

But when I want to create the table proc I got an error.

I did:

Code: [Select]
DROP TABLE IF EXISTS proc;
CREATE TABLE proc (
db char(64) character set utf8 collate utf8_bin NOT NULL default ,
name char(64) NOT NULL default ,
type enum('FUNCTION','PROCEDURE') NOT NULL,
specific_name char(64) NOT NULL default ,
language enum('SQL') NOT NULL default 'SQL',
sql_data_access enum('CONTAINS_SQL','NO_SQL','READS_SQL_DATA','MODIFIES_SQL_DATA') NOT NULL default 'CONTAINS_SQL',
is_deterministic enum('YES','NO') NOT NULL default 'NO',
security_type enum('INVOKER','DEFINER') NOT NULL default 'DEFINER',
param_list blob NOT NULL,
returns char(64) NOT NULL default ,
body longblob NOT NULL,
definer char(77) character set utf8 collate utf8_bin NOT NULL default ,
created timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
modified timestamp NOT NULL default '0000-00-00 00:00:00',
sql_mode     set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','NOT_USED','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NO_AUTO_CREATE_USER','HIGH_NOT_PRECEDENCE')  NOT NULL default ,
comment char(64) character set utf8 collate utf8_bin NOT NULL default ,
PRIMARY KEY (db,name,type)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Stored Procedures';


The following error pops up:

Quote
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '
name char(64) NOT NULL default ,
type enum('FUNCTION','PROCEDURE') NOT NU' at line 2


Any idea what could be wrong?

Thanks,
Rien
(The Netherlands)......

Offline cactus

  • *
  • 4,880
  • +3/-0
    • http://www.snetram.nl
How to install MySQL5 on SME7
« Reply #27 on: August 28, 2006, 11:13:33 PM »
Quote from: "DarkMirage"
There seems to be some security in place keeping the web server process www confined to it's own directories. Meaning php can't read files in / or /proc,  or detect programs located in PATH or things like that.

Anyway, it's completely unrelated to MySQL, try a new thread if you wish to continue trying to resolve this...
It is PHP basedir security and is indeed worth a seperate thread, is allows PHP to only access subdirectories in the tree below as specified per the httpd.conf file.
Be careful whose advice you buy, but be patient with those who supply it. Advice is a form of nostalgia, dispensing it is a way of fishing the past from the disposal, wiping it off, painting over the ugly parts and recycling it for more than its worth ~ Baz Luhrmann - Everybody's Free (To Wear Sunscreen)

Offline Rien

  • *
  • 216
  • +0/-0
    • http://www.taurix.nl
How to install MySQL5 on SME7
« Reply #28 on: August 28, 2006, 11:51:01 PM »
I think that:

Code: [Select]
default ,

must be:

Code: [Select]
default '',


is that correct ?

Thanks,
Rien
(The Netherlands)......

Offline Jean-Philippe Pialasse

  • *
  • 2,721
  • +11/-0
  • aka Unnilennium
    • http://smeserver.pialasse.com
How to install MySQL5 on SME7
« Reply #29 on: August 29, 2006, 12:01:57 AM »
that's right

here is the new version:

Code: [Select]
CREATE TABLE proc (
db char( 64 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL default '',
name char( 64 ) NOT NULL default '',
type enum( 'FUNCTION', 'PROCEDURE' ) NOT NULL ,
specific_name char( 64 ) NOT NULL default '',
language enum( 'SQL' ) NOT NULL default 'SQL',
sql_data_access enum( 'CONTAINS_SQL', 'NO_SQL', 'READS_SQL_DATA', 'MODIFIES_SQL_DATA' ) NOT NULL default 'CONTAINS_SQL',
is_deterministic enum( 'YES', 'NO' ) NOT NULL default 'NO',
security_type enum( 'INVOKER', 'DEFINER' ) NOT NULL default 'DEFINER',
param_list blob NOT NULL ,
returns char( 64 ) NOT NULL default '',
body longblob NOT NULL ,
definer char( 77 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL default '',
created timestamp NOT NULL default CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ,
modified timestamp NOT NULL default '0000-00-00 00:00:00',
sql_mode set( 'REAL_AS_FLOAT', 'PIPES_AS_CONCAT', 'ANSI_QUOTES', 'IGNORE_SPACE', 'NOT_USED', 'ONLY_FULL_GROUP_BY', 'NO_UNSIGNED_SUBTRACTION', 'NO_DIR_IN_CREATE', 'POSTGRESQL', 'ORACLE', 'MSSQL', 'DB2', 'MAXDB', 'NO_KEY_OPTIONS', 'NO_TABLE_OPTIONS', 'NO_FIELD_OPTIONS', 'MYSQL323', 'MYSQL40', 'ANSI', 'NO_AUTO_VALUE_ON_ZERO', 'NO_BACKSLASH_ESCAPES', 'STRICT_TRANS_TABLES', 'STRICT_ALL_TABLES', 'NO_ZERO_IN_DATE', 'NO_ZERO_DATE', 'INVALID_DATES', 'ERROR_FOR_DIVISION_BY_ZERO', 'TRADITIONAL', 'NO_AUTO_CREATE_USER', 'HIGH_NOT_PRECEDENCE' ) NOT NULL default '',
comment char( 64 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL default '',
PRIMARY KEY ( db , name , type )
) ENGINE = MYISAM DEFAULT CHARSET = utf8 COMMENT = 'Stored Procedures'

Offline mike_mattos

  • *
  • 313
  • +0/-0
How to install MySQL5 on SME7
« Reply #30 on: August 29, 2006, 05:24:09 PM »
why not yum?    well, I used yum on a CentOS system with no problems,

yum update mysql  and yum update php both work without breaking anything on CentOS

 but got errors using yum on SME, even after enabling Centosplss.  ( It retrieved MySQL5 but then gave errors )

The CentOS site has many posts and links saying which repositories have which features, and also how to add to the repositories, but I'm not finding that information on this site.  How would one know that MySQL is in CentosPlus and not in centos testing,  or sme testing?

Is there an SME yum guide to explain the differences between SME and CentOS repositories, and how to enable them?  On Centos the ini file is edited, that doesn't seem to be the sme method
...

Offline jfarschman

  • *
  • 406
  • +0/-0
How to install MySQL5 on SME7
« Reply #31 on: August 30, 2006, 03:44:40 PM »
Mike,

  Yum is like an UNIX command.  Flexible to the point that it's frustrating the first few times you use it.  Once you get over that hump it saves time. Yum sure is good with dependencies.

  Here's what I do:

NEED TO MY INSTALLED REPOSITORIES?
db yum_repositories show |grep repository

NEED TO FIND IF AN RPM IS IN A REPO?
yum search --enablerepo=<reponame>

NEED TO INSTALL FROM A NON STANDARD REPO?
yum install --enablerepo=<reponame>

or update or remove

NEED TO TURN ON A REPO FULL TIME
Use caution here... because, as you discussed, you don't know what's in a repo and could update things you don't want updated.

db yum_repositories setprop centosplus Visible yes
db yum_repositories setprop centosplus status enabled
expand-template /etc/yum.conf

EXCLUDE AN RPM FROM UPADATING FROM A PARTICULAR REPO?
For instance you are using an openldap that is likely to be overwritten by a SME update one of your "enabled" repos.

db yum_repositories setprop base Exclude openldap*
db yum_repositories setprop updates Exclude openldap*
db yum_repositories setprop smeos Exclude openldap*
expand-template /etc/yum.conf

Hope this helps.
Jay Farschman
ICQ - 60448985
jay@hitechsavvy.com

Offline mike_mattos

  • *
  • 313
  • +0/-0
How to install MySQL5 on SME7
« Reply #32 on: August 30, 2006, 11:08:36 PM »
thx, I'll poke around at it

one question though, how do you get the "name" to search?  That  is to say, if you wanted to update MySQL from 4.0 to 4.1   and not to 5.0, or wanted to know if there was an update for an application, how do you see the rpm version info?

Is there a generic site for yum to search the way you can search for rpm's or distro's or dll's?


thx again
...

Offline jfarschman

  • *
  • 406
  • +0/-0
How to install MySQL5 on SME7
« Reply #33 on: August 30, 2006, 11:34:14 PM »
yum search --enablerepo=<reponame>

Unfortunately... this will come up with lots of answers... mysql-client is easier to find... returns fewer results.
Jay Farschman
ICQ - 60448985
jay@hitechsavvy.com

Offline Rien

  • *
  • 216
  • +0/-0
    • http://www.taurix.nl
Error mysql.init during reboot
« Reply #34 on: September 01, 2006, 12:09:49 AM »
I use SME7 + MySQL 5.0.22

It works fine but when I reboot I get the following error:

Quote
Starting mysql.init: Loading 30mysql_create_tables into MySQL. Error 2013 (HY000) at line 11: Lost connection to MySQL server during query [FAILED][FAILED]



I looked into 30mysql_create_tables:
Code: [Select]
CREATE DATABASE IF NOT EXISTS horde;

CONNECT horde;

CREATE TABLE IF NOT EXISTS horde_users (
    user_uid       varchar(255) not null,
    user_pass      varchar(32) not null,
    primary key (user_uid)
);

GRANT SELECT, INSERT, UPDATE, DELETE ON horde_users TO horde@localhost;

CREATE TABLE IF NOT EXISTS horde_prefs (
    pref_uid        char(255) not null,
    pref_scope      char(16) not null default '',
    pref_name       char(32) not null,
    pref_value      text null,
    primary key (pref_uid, pref_scope, pref_name)
);

GRANT SELECT, INSERT, UPDATE, DELETE ON horde_prefs TO horde@localhost;

CREATE TABLE IF NOT EXISTS horde_categories (
       category_id INT not null,
       group_uid VARCHAR(255) not null,
       user_uid VARCHAR(255),
       category_name VARCHAR(255) not null,
       category_data TEXT null,
       category_serialized SMALLINT DEFAULT 0 not null,
       category_updated TIMESTAMP,
       PRIMARY KEY (category_id)
);

CREATE TABLE IF NOT EXISTS horde_categories_categories (
       category_id_parent INT not null,
       category_id_child INT not null,
       PRIMARY KEY (category_id_parent, category_id_child)
);

GRANT SELECT, INSERT, UPDATE, DELETE ON horde_categories TO horde@localhost;
GRANT SELECT, INSERT, UPDATE, DELETE ON horde_categories_categories TO horde@localhost;

FLUSH PRIVILEGES;


When I tried to execute this query from PhpMyAdmin it gives the following error:
Quote
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CONNECT horde' at line 1



What could be wrong?

Thanks,
Rien
(The Netherlands)......

Offline Jean-Philippe Pialasse

  • *
  • 2,721
  • +11/-0
  • aka Unnilennium
    • http://smeserver.pialasse.com
How to install MySQL5 on SME7
« Reply #35 on: September 01, 2006, 01:17:30 AM »
hi here something funny:

this commands
Code: [Select]
GRANT SELECT, INSERT, UPDATE, DELETE ON horde_users TO horde@localhost does not seem to be accepted by mysql 5 on SME ...


it is from the dump /home/e-smith/httpd/horde/scripts/db/mysql_create_tables.sql
it called by /etc/e-smith/sql/init/30mysql_create_tables
which is called when you do
/etc/rc.d/init.d/mysql.init restart

one othe rtable forgotten :

DROP TABLE IF EXISTS procs_priv;
CREATE TABLE procs_priv (
  Host char(60) collate utf8_bin NOT NULL default '',
  Db char(64) collate utf8_bin NOT NULL default '',
  User char(16) collate utf8_bin NOT NULL default '',
  Routine_name char(64) collate utf8_bin NOT NULL default '',
  Routine_type enum('FUNCTION','PROCEDURE') collate utf8_bin NOT NULL,
  Grantor char(77) collate utf8_bin NOT NULL default '',
  Proc_priv set('Execute','Alter Routine','Grant') character set utf8 NOT NULL default '',
  Timestamp timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (Host,Db,User,Routine_name,Routine_type),
  KEY Grantor (Grantor)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Procedure privileges';

and after it works !!!!!!!!!!!!!!

Offline kruhm

  • *
  • 680
  • +0/-0
How to install MySQL5 on SME7
« Reply #36 on: September 01, 2006, 02:12:58 AM »
@mike_mattos
Yum searches are not case sensitive. The following search will pull a list of every rpm in a repo that has mysql in the name or description:
#yum search --enablerepo=extras mysql

Yum installs are case sensitive and version sensitive.
#yum install mysql.i386-4.1.20-1.RHEL4.1

The following will show more:
#man yum

Offline Rien

  • *
  • 216
  • +0/-0
    • http://www.taurix.nl
How to install MySQL5 on SME7
« Reply #37 on: September 01, 2006, 05:06:29 PM »
So what you have to do to install MySQL 5 on SME7 is:


==============================
STEP 1: MAKE A BACKUP OF YOUR DATABASES:
==============================

Code: [Select]
mysqldump -aec >backup_mysql_databases.sql



==========================
STEP 2: GET THE NEW RPM'S:
==========================

THERE ARE TWO WAYS OF DOING THIS:

-------------
FIRST METHOD:
-------------

Code: [Select]
wget \
http://mirror.centos.org/centos/4/centosplus/i386/RPMS/mysqlclient14-4.1.14-4.2.c4.1.i386.rpm \
http://mirror.centos.org/centos/4/centosplus/i386/RPMS/mysql-server-5.0.22-1.centos.1.i386.rpm \
http://mirror.centos.org/centos/4/centosplus/i386/RPMS/mysql-5.0.22-1.centos.1.i386.rpm

rpm -U mysql-5.0.22-1.centos.1.i386.rpm \
mysql-server-5.0.22-1.centos.1.i386.rpm \
mysqlclient14-4.1.14-4.2.c4.1.i386.rpm


Code: [Select]
/etc/rc.d/init.d/mysqld stop
rm -f /etc/my.cnf.rpmnew
/etc/rc.d/init.d/mysqld start


To fix the privileges on Horde:

Code: [Select]
mysql -e "GRANT SELECT,INSERT,UPDATE,DELETE ON horde.* TO 'horde'@'localhost';FLUSH PRIVILEGES"

-------------------------
SECOND METHOD: (prefered)
-------------------------

Code: [Select]
/etc/rc.d/init.d/mysqld stop
yum --enablerepo=centosplus update mysql
/etc/rc.d/init.d/mysqld start


To fix the privileges on Horde:

Code: [Select]
mysql -e "GRANT SELECT,INSERT,UPDATE,DELETE ON horde.* TO 'horde'@'localhost';FLUSH PRIVILEGES"




===================================================
STEP 3: ADD MISSING MySQL-TABLES TO MYSQL DATABASE: (for instance with PhpMyAdmin)
===================================================

Code: [Select]
DROP TABLE IF EXISTS proc;
CREATE TABLE proc (
db char( 64 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL default '',
name char( 64 ) NOT NULL default '',
type enum( 'FUNCTION', 'PROCEDURE' ) NOT NULL ,
specific_name char( 64 ) NOT NULL default '',
language enum( 'SQL' ) NOT NULL default 'SQL',
sql_data_access enum( 'CONTAINS_SQL', 'NO_SQL', 'READS_SQL_DATA', 'MODIFIES_SQL_DATA' ) NOT NULL default 'CONTAINS_SQL',
is_deterministic enum( 'YES', 'NO' ) NOT NULL default 'NO',
security_type enum( 'INVOKER', 'DEFINER' ) NOT NULL default 'DEFINER',
param_list blob NOT NULL ,
returns char( 64 ) NOT NULL default '',
body longblob NOT NULL ,
definer char( 77 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL default '',
created timestamp NOT NULL default CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ,
modified timestamp NOT NULL default '0000-00-00 00:00:00',
sql_mode set( 'REAL_AS_FLOAT', 'PIPES_AS_CONCAT', 'ANSI_QUOTES', 'IGNORE_SPACE', 'NOT_USED', 'ONLY_FULL_GROUP_BY', 'NO_UNSIGNED_SUBTRACTION', 'NO_DIR_IN_CREATE', 'POSTGRESQL', 'ORACLE', 'MSSQL', 'DB2', 'MAXDB', 'NO_KEY_OPTIONS', 'NO_TABLE_OPTIONS', 'NO_FIELD_OPTIONS', 'MYSQL323', 'MYSQL40', 'ANSI', 'NO_AUTO_VALUE_ON_ZERO', 'NO_BACKSLASH_ESCAPES', 'STRICT_TRANS_TABLES', 'STRICT_ALL_TABLES', 'NO_ZERO_IN_DATE', 'NO_ZERO_DATE', 'INVALID_DATES', 'ERROR_FOR_DIVISION_BY_ZERO', 'TRADITIONAL', 'NO_AUTO_CREATE_USER', 'HIGH_NOT_PRECEDENCE' ) NOT NULL default '',
comment char( 64 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL default '',
PRIMARY KEY ( db , name , type )
) ENGINE = MYISAM DEFAULT CHARSET = utf8 COMMENT = 'Stored Procedures';

DROP TABLE IF EXISTS procs_priv;
CREATE TABLE procs_priv (
Host char(60) collate utf8_bin NOT NULL default '',
Db char(64) collate utf8_bin NOT NULL default '',
User char(16) collate utf8_bin NOT NULL default '',
Routine_name char(64) collate utf8_bin NOT NULL default '',
Routine_type enum('FUNCTION','PROCEDURE') collate utf8_bin NOT NULL,
Grantor char(77) collate utf8_bin NOT NULL default '',
Proc_priv set('Execute','Alter Routine','Grant') character set utf8 NOT NULL default '',
Timestamp timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
PRIMARY KEY (Host,Db,User,Routine_name,Routine_type),
KEY Grantor (Grantor)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Procedure privileges';



======================
STEP 4: RESTART MySQL:
======================

You simply reboot the server

OR

without rebooting the server:

Code: [Select]
/etc/rc.d/init.d/mysqld stop;
/etc/rc.d/init.d/mysqld start;
/etc/rc.d/init.d/mysql.init restart;


===========================================
Is this correct?
Rien
(The Netherlands)......

Offline Jean-Philippe Pialasse

  • *
  • 2,721
  • +11/-0
  • aka Unnilennium
    • http://smeserver.pialasse.com
How to install MySQL5 on SME7
« Reply #38 on: September 01, 2006, 05:18:26 PM »
correct no more to add, the perfect how to .


---

and stop flood, just  open a new topic for YUM discusions, thank you.

munter

How to install MySQL5 on SME7
« Reply #39 on: September 02, 2006, 01:40:55 PM »
this is what i got after wget all 3:

[root@jttrade lib]# rpm -U mysql-5.0.22-1.centos.1.i386.rpm
error: Failed dependencies:
        libmysqlclient.so.14 is needed by (installed) perl-DBD-MySQL-2.9004-3.1.i386
        libmysqlclient.so.14 is needed by (installed) dovecot-0.99.14-1.2.el4.rf.i386
        libmysqlclient.so.14 is needed by (installed) mysql-server-4.1.20-1.RHEL4.1.i386
        libmysqlclient.so.14 is needed by (installed) php-mysql-4.3.9-3.15.i386
        libmysqlclient.so.14(libmysqlclient_14) is needed by (installed) mysql-server-4.1.20-1.RHEL4.1.i386
        libmysqlclient.so.14(libmysqlclient_14) is needed by (installed) php-mysql-4.3.9-3.15.i386
        libmysqlclient_r.so.14 is needed by (installed) mysql-server-4.1.20-1.RHEL4.1.i386
        libmysqlclient_r.so.14(libmysqlclient_14) is needed by (installed) mysql-server-4.1.20-1.RHEL4.1.i386
        mysql = 4.1.20-1.RHEL4.1 is needed by (installed) mysql-server-4.1.20-1.RHEL4.1.i386

munter

How to install MySQL5 on SME7
« Reply #40 on: September 02, 2006, 02:03:21 PM »
are there any easy way to install this?

php-domxml is needed by package e-smith-horde

tryed

wget ftp://download.fedora.redhat.com/pub/fedora/linux/core/updates/2/SRPMS/php-4.3.10-2.4.src.rpm

rpm -U php-4.3.10-2.4.src.rpm

trying to install mysql but fails everytime

Offline Jean-Philippe Pialasse

  • *
  • 2,721
  • +11/-0
  • aka Unnilennium
    • http://smeserver.pialasse.com
How to install MySQL5 on SME7
« Reply #41 on: September 02, 2006, 02:20:10 PM »
Quote from: "munter"
are there any easy way to install this?

php-domxml is needed by package e-smith-horde

tryed

wget ftp://download.fedora.redhat.com/pub/fedora/linux/core/updates/2/SRPMS/php-4.3.10-2.4.src.rpm

rpm -U php-4.3.10-2.4.src.rpm

trying to install mysql but fails everytime


Are you trying to update MYSQL or PHP ?

Rien was saying for the without yum methode:
Code: [Select]
rpm -U mysql-5.0.22-1.centos.1.i386.rpm \
mysql-server-5.0.22-1.centos.1.i386.rpm \
mysqlclient14-4.1.14-4.2.c4.1.i386.rpm


Which doesn't mean
Code: [Select]
rpm -U mysql-5.0.22-1.centos.1.i386.rpm
then
Code: [Select]
rpm -U mysql-server-5.0.22-1.centos.1.i386.rpm
then
Code: [Select]
rpm -U mysqlclient14-4.1.14-4.2.c4.1.i386.rpm

so copy and paste the 3 lines in one time and execute.

BUT I suggest you the easier methode : the yum one:
Code: [Select]
/etc/rc.d/init.d/mysqld stop
yum --enablerepo=centosplus update mysql
/etc/rc.d/init.d/mysqld start


The update of PHP is a little more complicated, and it is even more difficult when youy use a source RPM :)[/code]

munter

How to install MySQL5 on SME7
« Reply #42 on: September 02, 2006, 04:25:25 PM »
Thank you...this was helpful.
Now i understand the syntax.

But still doesnt apply on my server.

Te goal is to run it as a webserver ontop of all feature  like mail, ftp, firewall, printer-server.

I want this webserver to host my website written in php.

I understud the other part with hosting several domains.

Offline Jean-Philippe Pialasse

  • *
  • 2,721
  • +11/-0
  • aka Unnilennium
    • http://smeserver.pialasse.com
How to install MySQL5 on SME7
« Reply #43 on: September 02, 2006, 08:03:44 PM »
Munter,

there's already PHP4 and mysql 4 to run a website in php on sme 7.

do you absolutly need to update to mysql 5 ?

if yes what return the try with yum ?

Code: [Select]
/etc/rc.d/init.d/mysqld stop
yum --enablerepo=centosplus update mysql
/etc/rc.d/init.d/mysqld start

munter

How to install MySQL5 on SME7
« Reply #44 on: September 04, 2006, 09:45:04 AM »
Quote from: "unnilennium"
Munter,

there's already PHP4 and mysql 4 to run a website in php on sme 7.

do you absolutly need to update to mysql 5 ?

if yes what return the try with yum ?

Code: [Select]
/etc/rc.d/init.d/mysqld stop
yum --enablerepo=centosplus update mysql
/etc/rc.d/init.d/mysqld start


First of all, thanks for trying help me.

Did trye yum but it also complaining about this: Error: Missing Dependency: php-domxml is needed by package e-smith-horde
================================================================
No new rpms were installed. No additional commands are required.
================================================================
[root@jttrade ~]# /etc/rc.d/init.d/mysqld start

Timeout error occurred trying to start MySQL Daemon.
Starting MySQL:                                            [FAILED]


its not really important to upgrade to ver5 but now doesnt mysql start at all :-)

maybe i should reinstall my server and be happy with ver 4.
I do have some small issues with password streangth and backup.
So i think we save some time to reinstall this time.

After that i need to learn howto manage mysql and php on my server aswell... dont have any knowlege in manage mysql.... just use it on an expensive payserver

Offline william_syd

  • ****
  • 1,608
  • +0/-0
  • Nothing to see here.
    • http://www.magicwilly.info
How to install MySQL5 on SME7
« Reply #45 on: September 06, 2006, 10:38:17 AM »
Quote from: "munter"



its not really important to upgrade to ver5 but now doesnt mysql start at all :-)


Reboot and it should restart.

Have a look at this post..
http://forums.contribs.org/index.php?topic=33434.msg143545#msg143545

and try the how-to to get around the php-domxml problem.
Regards,
William

IF I give advise.. It's only if it was me....

munter

How to install MySQL5 on SME7
« Reply #46 on: October 03, 2006, 07:47:23 PM »
Quote from: "william_syd"
Quote from: "munter"



its not really important to upgrade to ver5 but now doesnt mysql start at all :-)


Reboot and it should restart.

Have a look at this post..
http://forums.contribs.org/index.php?topic=33434.msg143545#msg143545

and try the how-to to get around the php-domxml problem.


found another post in this forum.

Guess what dudes??...YES .. its working..my webmail, server-manager..ffs everything works!!!

good job everyone involved  :lol:

munter

How to install MySQL5 on SME7
« Reply #47 on: October 03, 2006, 07:49:08 PM »
Quote from: "munter"
Quote from: "william_syd"
Quote from: "munter"



its not really important to upgrade to ver5 but now doesnt mysql start at all :-)


Reboot and it should restart.

Have a look at this post..
http://forums.contribs.org/index.php?topic=33434.msg143545#msg143545

and try the how-to to get around the php-domxml problem.


found another post in this forum.

Guess what dudes??...YES .. its working..my webmail, server-manager..ffs everything works!!!

good job everyone involved  :lol:


Thanks

Offline soprom

  • *
  • 589
  • +0/-0
    • www.logiciel-libre.org
How to install MySQL5 on SME7
« Reply #48 on: October 06, 2006, 05:51:14 PM »
Works for me too!
Sophie from Montréal