Successful install of MySQL 4.1 and PHP5 on a PSA 7.5 System

General Discussion of atomic repo and development projects.

Ask for help here with anything else not covered by other forums.
jclawson
Forum User
Forum User
Posts: 21
Joined: Fri Feb 18, 2005 5:42 am

Successful install of MySQL 4.1 and PHP5 on a PSA 7.5 System

Unread post by jclawson »

I finally got it all to work. To acheive this I had to completly remove my plesk installation and start from scratch installing each development RPM.

Ok... so there is a couple of quirks but I can live with them.

first, Plesk's php enabling doesn't work. It uses the wrong type of test to see if the php module is installed:

Plesk uses:
<IfModule sapi_apache2.c>
php_admin_flag engine on
php_admin_value open_basedir "/home/httpdocs:/tmp"
</IfModule>

When it should be:

<IfModule mod_php5.c>
php_admin_flag engine on
php_admin_value open_basedir "/home/httpdocs:/tmp"
</IfModule>

And of course Plesk doesn't use templates... all that is hard coded into a binary file. So I have to enable PHP by hand... :(

The final problem which is also very annoying is the updater utility doesn't work. It tries to reinstall PHP4 and a bunch of other things it doesn't need. So to update, I have to download it manually and apply with the --nodeps flag.

Thats it.. Webmail works, adding delteing domains work as well. Everythign works perfectly other than the 2 above quirks.
scott
Atomicorp Staff - Site Admin
Atomicorp Staff - Site Admin
Posts: 8355
Joined: Wed Dec 31, 1969 8:00 pm
Location: earth
Contact:

Unread post by scott »

Cool, so it might be the MySQL 4.1 does in fact work with 7.5. Can you keep us posted about any other issues you run into with it? Also whose package are you using? I don't want to declare victory on MySQL 4.1 until we've got a few weeks of testing behind it. I've stopped counting the times people have told me that it works only to find out later that they hadn't tested everything out :P
jclawson
Forum User
Forum User
Posts: 21
Joined: Fri Feb 18, 2005 5:42 am

Unread post by jclawson »

I spoke a little too soon. Some parts fo webmail don't work.

The only thing you must do to get MySQL 4.1 to work is add this line in your my.cnf file:

old-passwords

Plesk uses the old php-mysql client so it doesn't know about the new password format introduced in 4.1. To get around that the "old-passwords" option forces MySQL to use the old password fomat... which I don't see the downside to.

I installed the MySQL rpms from:

[development]
name=Fedora Core $releasever - Development Tree
baseurl=http://download.fedora.redhat.com/pub/f ... $basearch/

So far no problems with MySQL at all.

With PHP5 however there are those quirks which are a little annoying.... If someone rewrote /usr/local/psa/admin/sbin/domainmng then it could be fixed I bet :-)

I really wish the Plesk rpms would be configured for PHP >= 4 instead of PHP = 4.... its really annoying for the updater to try and reinstall PHP4... so upgrading to php5 makes the updater useless.
goodtim

Unread post by goodtim »

Hi there,

I got PHP 5.0.2 instalelled as well as MySQL 4.1. However when I try to access a php page, it does not get parsed, but rather I get prompted to download the file instead.

I think that the problem is that PSA incorrectly checks to see if php is installed, so I was wondering what exactly is the correct way, and how is it done. My first guess was in the vhost.conf conf file. I tried putting the following statement in that file:

Code: Select all

<IfModule mod_php5.c>
        php_admin_flag engine on
        php_admin_value open_basedir "/home/httpd/vhosts/DOMAIN/httpdocs:/tmp"
</IfModule>
That way then the websrvmng parses the httpd.include file for that vhost, that code gets stuck in there to. But it does not work.

So my questions is, how did you enable php manually? Or am I totally wrong?
Post Reply