Koozali.org: home of the SME Server

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

Offline flufdk

  • 7
  • +0/-0
Looking for HowTo install MySQL 5.x and PHP 5.x
« Reply #15 on: September 22, 2006, 11:26:22 AM »
Hi agian

I can not install domxml again.

Quote
Using username "root".
root@xxxxxx's password:
Last login: Fri Sep 22 05:54:11 2006 from xxxxxxx
[root@xxxx ~]# rpm -e --nodeps php-domxml
[root@xxxx ~]# rpm -Uvh http://mirror.contribs.org/smeserver/releases/7/updates/i386/RPMS/php-domxml-4.3.9-3.15.i386.rpm
Retrieving http://mirror.contribs.org/smeserver/releases/7/updates/i386/RPMS/php-domxml-4.3.9-3.15.i386.rpm
error: Failed dependencies:
        php = 4.3.9-3.15 is needed by php-domxml-4.3.9-3.15.i386
[root@bxxxx ~]#



Is the a other way to do this?
Its a fres inst. sme 7.0

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 #16 on: September 22, 2006, 11:28:45 AM »
Content deleted - outdated information.
Regards,
William

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

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 #17 on: September 22, 2006, 04:53:11 PM »
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 #18 on: September 22, 2006, 05:22:16 PM »
William,

Thanks for your time on this.

First, with regard to the installation you did, it's not MySQL that might break it.  vTiger will work with versions above 4.1.x.  However, it does need PHP 5.

Knowing this, and being that I had a combined howto for PHP 5 and MySQL 5, I installed both before trying to install vTiger.

I created a vtiger user in mySQL with all rights (grant all) and used that user during the configuration - which failed with the message included above.  Next, I created the database manually. The error remained.  Finally, I got a script from vtiger which allowed me to create the tables from the command line.  Obviously none of this solved the problem with the connection to mySQL.  It was at this point that I discovered, via phpinfo, that I was running  MySQL client API version 4.1.14   At this point I am only ASSUMING that this is the problem.

Perhaps my next attempt should be to start fresh and do only the PHP 5 install?

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 #19 on: September 22, 2006, 05:34:03 PM »
Content deleted - outdated information.
Regards,
William

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

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 #20 on: September 22, 2006, 05:39:20 PM »
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 #21 on: September 22, 2006, 05:59:58 PM »
I tried with both machine name and ip address.  Did not try localhost.  Though I will now.

Quote
Quote
jckelly wrote:
Finally, I got a script from vtiger which allowed me to create the tables from the command line.



There are 307 tables...


Just to be clear... the script created on the tables :)

regards,
Cavan

jckelly

Looking for HowTo install MySQL 5.x and PHP 5.x
« Reply #22 on: September 22, 2006, 06:06:02 PM »
William,

What's most interesting about your phpinfo() is that the mysqlclient is 4.1.20 while mine (after the php 5/mysql 5 upgrade) is 4.1.14.  On a fresh install, I also have 4.1.20.  The question is, where did 4.1.14 come from?  Was it the php/mysql upgrade? or did I do something else that caused this downgrade - perhaps via yum....  I just don't know.  I'll have to start fresh to figure that out.

Unfortunately, I have to go out and make a few bucks right now so I'll give it a try later tonight.

Thanks again for all your effort on this.

Cavan

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 #23 on: September 23, 2006, 03:13:25 AM »
Content deleted - outdated information.
Regards,
William

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

Offline pcdoc

  • *
  • 56
  • +0/-0
Looking for HowTo install MySQL 5.x and PHP 5.x
« Reply #24 on: September 26, 2006, 04:20:42 PM »
Have a bit of a problem still after installing php5 and mysql5

PHP5 won't start because it is looking for snmp.so and odbc.so

after commenting these out of /etc/php.ini, it also wanted domxml.so

commented that out as well, but still having same problem.

The problem is when I try to open a php page, ie webmail, the browser wants to save the php file. The server does not seem to be wanting to process the php and produce a html page for the browser.

Any thoughts?? - this is on my main test server, and I want to be able to update a lot of our servers to php5 because of software rollout requiring php5
There are 10 types of people in this world,
   Those that know binary, and those who don't!

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 #25 on: September 27, 2006, 01:52:12 AM »
Content deleted - outdated information.
Regards,
William

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

Offline RvLardin

  • ***
  • 82
  • +0/-0
    • http://sme.firewall-services.com
VTiger 5 CRM install
« Reply #26 on: October 10, 2006, 09:33:21 AM »
> jckelly
Your pb as nothing to do with PHP5 or MySQL5.
We are running VT5 on several SME7 servers without any upgrade.
It seems that you didn't create the MySQL DB before running the install scripts.
So, brief howto
1) DL & untar the files from VT5 in an ibay/html
2) Create your DB :
# mysql
> create database myVTbase;
> grant all prilileges on myVTbase.* to 'myVTuser'@'localhost' identified by 'myPWD';
> flush privileges;
> quit
#
3) Run the install script opening the http://myserver/ibay
and specifying "localhost" as "MySQLserverhost", "myVTbase" as name of the DB, "myVTuser" as database owner and "myPWD" as password.

It runs !
:)

May be you've done the frequent mistake that consist of changing the root password if you indicate "root" as base owner. That's bad !
In this case, search this forum  to fix it.

A+,
RV.
P.S. : To stick with this thread, we are also thinking to upgrade to PHP5 because one of the features of VTiger5 don't work : the imap connector.
----
"Those who are willing to lose some of their essential liberties in favour of security deserve neither and will lose both."
- Thomas Jefferson .

Offline william_syd

  • ****
  • 1,608
  • +0/-0
  • Nothing to see here.
    • http://www.magicwilly.info
Re: VTiger 5 CRM install
« Reply #27 on: October 10, 2006, 11:12:29 AM »
Content deleted - outdated information.
Regards,
William

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

pippin

Looking for HowTo install MySQL 5.x and PHP 5.x
« Reply #28 on: January 03, 2007, 01:14:40 AM »
I get this error when trying to update on a fresh install

Cannot open/read repomd.xml file for repository: smeaddons
failure: repodata/repomd.xml from smeaddons: [Errno 256] No more mirrors to try.
Error: failure: repodata/repomd.xml from smeaddons: [Errno 256] No more mirrors to try.

It seems like PHP5 isnt installed and the webserver isnt running

I get a error messages in httpd.conf in line 111 i guess

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 #29 on: January 03, 2007, 01:41:39 AM »
Content deleted - outdated information.
Regards,
William

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