Koozali.org: home of the SME Server

Looking for HowTo install MySQL 5.x and PHP 5.x

Offline Snoopyski

  • *
  • 141
  • +0/-0
    • http://www.serviceinfosg.com
Looking for HowTo install MySQL 5.x and PHP 5.x
« on: August 24, 2006, 02:13:41 AM »
Hello Everybody,

I'm looking for a REAL HowTo about upgrade for PHP 5.X et MySQL 5.x on a SME Server 7...

If anybody have a link or something, I will very appreciate  !!!

Thanks

Snoopyski

Offline cactus

  • *
  • 4,880
  • +3/-0
    • http://www.snetram.nl
Re: Looking for HowTo install MySQL 5.x and PHP 5.x
« Reply #1 on: August 24, 2006, 11:47:14 AM »
Quote from: "Snoopyski"
Hello Everybody,

I'm looking for a REAL HowTo about upgrade for PHP 5.X et MySQL 5.x on a SME Server 7...

If anybody have a link or something, I will very appreciate  !!!

Thanks

Snoopyski
There are to my knowledge no finished how-to's, however there are a few threads on this forum on how to install both... maybe you van help out as well...
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 kruhm

  • *
  • 680
  • +0/-0
Looking for HowTo install MySQL 5.x and PHP 5.x
« Reply #2 on: August 27, 2006, 02:23:16 PM »
They are in the CENTOSPLUS yum repository. This repo is already installed on your system by default so that you can easily grab stuff from it.

All you have to do is enable it with a search:
yum --enablerepo=centosplus search mysql

or enable it with an install:
yum --enablerepo=centosplus yum <casesensitivepackagename>

Offline Jean-Philippe Pialasse

  • *
  • 2,721
  • +11/-0
  • aka Unnilennium
    • http://smeserver.pialasse.com
Looking for HowTo install MySQL 5.x and PHP 5.x
« Reply #3 on: August 28, 2006, 01:42:00 AM »
i have a how to , but i am sorry as it is only in French:


http://smeserver.pialasse.com/index.php/Php_5_mysql_5

Offline william_syd

  • ****
  • 1,608
  • +0/-0
  • Nothing to see here.
    • http://www.magicwilly.info
Looking for HowTo install MySQL 5.x and PHP 5.x
« Reply #4 on: September 05, 2006, 02:44:38 PM »
Content deleted - outdated information.
Regards,
William

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

Offline Jean-Philippe Pialasse

  • *
  • 2,721
  • +11/-0
  • aka Unnilennium
    • http://smeserver.pialasse.com
Looking for HowTo install MySQL 5.x and PHP 5.x
« Reply #5 on: September 06, 2006, 10:13:05 PM »
wonderfull job  just what is needed for a rush job for non french speeking people.


unnilennium AKA Jean-Philippe Pialasse

Offline flufdk

  • 7
  • +0/-0
Looking for HowTo install MySQL 5.x and PHP 5.x
« Reply #6 on: September 20, 2006, 02:01:47 PM »
The link is broken to eng. ver. is the any who there have a new link?

Offline william_syd

  • ****
  • 1,608
  • +0/-0
  • Nothing to see here.
    • http://www.magicwilly.info
Looking for HowTo install MySQL 5.x and PHP 5.x
« Reply #7 on: September 20, 2006, 02:06:56 PM »
Content deleted - outdated information.
Regards,
William

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

Offline flufdk

  • 7
  • +0/-0
Looking for HowTo install MySQL 5.x and PHP 5.x
« Reply #8 on: September 20, 2006, 09:09:06 PM »
Thanks william_syd

now i get this.

Quote

--> Running transaction check
--> Processing Dependency: php-domxml for package: e-smith-horde
--> Finished Dependency Resolution
Error: Missing Dependency: php-domxml is needed by package e-smith-horde
================================================================
No new rpms were installed. No additional commands are required.
================================================================


What do I have to do now??


/Brian Bech

Offline william_syd

  • ****
  • 1,608
  • +0/-0
  • Nothing to see here.
    • http://www.magicwilly.info
Looking for HowTo install MySQL 5.x and PHP 5.x
« Reply #9 on: September 21, 2006, 03:34:41 AM »
Content deleted - outdated information.
Regards,
William

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

jckelly

Looking for HowTo install MySQL 5.x and PHP 5.x
« Reply #10 on: September 21, 2006, 05:43:21 AM »
I followed the php 5 & MySQL 5 howto this past Sunday (before it disappeared) and all seemed to go well.  However, I still wasn't able to get vTiger 5.0 CRM running which was the purpose of the whole exersize.  Earlier today I discovered that the mysql client is still version 4.1.14.  Now, I can't be sure if I messed up in some way, or if the packages are at fault.  I'd be grateful if anyone else who followed the howto could check their version of the MySQL client and let me know what they've got.

By the way, one of the messages above mentions a link to the contribs, I received this message "You are not authorized to view this resource.
You need to login." upon trying that link.

regards,
jc kelly

Offline william_syd

  • ****
  • 1,608
  • +0/-0
  • Nothing to see here.
    • http://www.magicwilly.info
Looking for HowTo install MySQL 5.x and PHP 5.x
« Reply #11 on: September 21, 2006, 05:56:04 AM »
Content deleted - outdated information.
Regards,
William

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

jckelly

Looking for HowTo install MySQL 5.x and PHP 5.x
« Reply #12 on: September 21, 2006, 05:24:35 PM »
William,

Thanks for the help.  Here's what's happening...

Running yum list | grep "mysql" on a freshly installed SME 7 gives me:

Code: [Select]
e-smith-mysql.noarch                     1.12.0-06              installed
mysql.i386                               4.1.20-1.RHEL4.1       installed
mysql-server.i386                        4.1.20-1.RHEL4.1       installed
php-mysql.i386                           4.3.9-3.15             installed



Running the same command after installing PHP 5 and MySQL 5 gives:

Code: [Select]
e-smith-mysql.noarch                     1.12.0-06              installed
mysql.i386                               5.0.22-1.centos.1      installed
mysql-server.i386                        5.0.22-1.centos.1      installed
mysqlclient14.i386                       4.1.14-4.2.c4.1        installed
php-mysql.i386                           5.0.4-5.centos4        installed
mysql.i386                               4.1.20-1.RHEL4.1       smeos
mysql-server.i386                        4.1.20-1.RHEL4.1       smeos
php-mysql.i386                           4.3.9-3.15             smeupdates



If I try yum remove mysqlclient14.i386, I get a 46 item listing of things that are going to be removed.  Needless to say, I didn't do THAT.

If I've irrepairably screwed up, that's ok - starting again is an option

Thanks for any light you can shed on this for me.

jckelly

Offline william_syd

  • ****
  • 1,608
  • +0/-0
  • Nothing to see here.
    • http://www.magicwilly.info
Looking for HowTo install MySQL 5.x and PHP 5.x
« Reply #13 on: September 22, 2006, 02:02:08 AM »
Content deleted - outdated information.
Regards,
William

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

jckelly

Looking for HowTo install MySQL 5.x and PHP 5.x
« Reply #14 on: September 22, 2006, 04:35:46 AM »
vtiger gives the following error while trying to connect to database:

Code: [Select]
Unable to connect to database Server. Invalid mySQL Connection Parameters specified

This may be due to the following reasons:
- specified database user, password, hostname, database type, or port is invalid.
- specified database user does not have access to connect to the database server from the host


However, the connection info is correct and the username/password works from the command line.  When I noticed that the mysqlclient was version 4.1.14 I thought it might have something to do with the problem.

I have since installed mysql-shared-5.0.22-0 but phpinfo still reports the client as 4.1.14

Still looking....