Facebook
Twitter-
Introducing WebPros Cloud - a fully managed infrastructure platform purpose-built to simplify the deployment of WebPros products ! WebPros Cloud enables you to easily deliver WebPros solutions — without the complexity of managing the infrastructure.
Join the pilot program today! -
The Horde component is removed from Plesk Installer. We recommend switching to another webmail software supported in Plesk.
-
The BIND DNS server has already been deprecated and removed from Plesk for Windows.
If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS. We strongly recommend transitioning to Microsoft DNS within the next 6 weeks, before the Plesk 18.0.70 release.
PHP and mySQL 5
- Thread starter dyrer
- Start date
M
matbeard
Guest
I would also like to know how to use MySQL 5. I've upgraded to Plesk 8.1.1 which claims to support MySQL 5, but there are no details on how to actually use it. phpMyAdmin is still reporting version 4.
This is going to be a real problem, as I want to migrate a Web app to my server that's been created using a MySQL 5 db, with view, stored procs and foreign keys etc. That's not gonna work on version 4.
Any help would be much appreciated. (Then I've just got to figure out how to upgrade the PHP version).
This is going to be a real problem, as I want to migrate a Web app to my server that's been created using a MySQL 5 db, with view, stored procs and foreign keys etc. That's not gonna work on version 4.
Any help would be much appreciated. (Then I've just got to figure out how to upgrade the PHP version).
M
matbeard
Guest
It's not really as simple as that. I have searched these forums, and there isn't a simple solution.
I'm running a fc4 x86_64 virtual server from 1and1. I've run through all the updates via Plesk's own updater, so I'm now running 8.1.1
The Plesk desktop claims MySQL 5 support, but offes no way to install it.
I've managed to install yum, but given that the server is running fc4 (for which support has stopped), it reports that there are no updates available.
I really need a way to update to MySQL 5 and PHP 5.1.4 (well, 5.0.5 al least).
This is NOT simple.
M
matbeard
Guest
I've added the centosplus repo to my yum conf
This is looking reasonaly hopeful, but to be honest, I haven't got a clue as to whether I should be doing this on a fc4 x86_64 server.
The only problem I get when running yum update php now is:
Error: Missing Dependency: php = 5.0.4-10.5.1.swsoft is needed by package php-pear
From what I can see, if this dependency is sorted out, it will install PHP 5.1.6 and mysql 5.0.27 (amongst other things)
Am I on the right lines here, or is this going to screw everything up horribly?
I could do with a few tips here.
Thanks
This is looking reasonaly hopeful, but to be honest, I haven't got a clue as to whether I should be doing this on a fc4 x86_64 server.
The only problem I get when running yum update php now is:
Error: Missing Dependency: php = 5.0.4-10.5.1.swsoft is needed by package php-pear
From what I can see, if this dependency is sorted out, it will install PHP 5.1.6 and mysql 5.0.27 (amongst other things)
Am I on the right lines here, or is this going to screw everything up horribly?
I could do with a few tips here.
Thanks
B
benji
Guest
Yes, they claim that Plesk 8.1.0, and 8.1.1 supports MySQL 5, and PHP 5, but how do we install them? There is no RHEL4 rpm packages with MySQL5, nor with PHP5.
No official SwSoft help on that matter...
No official SwSoft help on that matter...
atomicturtle
Golden Pleskian
If you're on CentOS, php 5.1 and mysql5 are in the centosplus channel. If you're on FC5 or above, php 5.1 and mysql 5 come with the distribution by default.
B
benji
Guest
Hi ART,
Thanks for the reply.
I use RHEL4 on my box. I've been investigating ont this, and I can see a RHEL4 version of MySQL 5 on your bleeding channel. Do you know more or less when will be a stable version ?
atomicturtle
Golden Pleskian
Its stable now, I was just waiting to push that down into [atomic] since I know its going to wreck havok with the PSA 7.5/8.0 users. If you look here:
http://www.atomicorp.com/channels/atomic-bleeding/
that has the latest. Last thing to fix with that is the php-pear package. Everything is stable/feature complete, the upgrade path just isnt very pretty at the moment.
http://www.atomicorp.com/channels/atomic-bleeding/
that has the latest. Last thing to fix with that is the php-pear package. Everything is stable/feature complete, the upgrade path just isnt very pretty at the moment.
B
benji
Guest
Ok, I will wait 'till its stable.
Will it be matter of , days?, months?, years?
Thanks again.
Will it be matter of , days?, months?, years?
Thanks again.
atomicturtle
Golden Pleskian
Probably not until after we finish up ASL 2.0
S
Spre
Guest
How exactly do we do this in reverse? Just reformated and install centos4.3 and got everything installed and am trying to install plesk but get.
If plesk supports these it shouldn't be whining abou tthem being defaultly installed. How do I get passed this error?
and atomic-bleeding gives a error so yum cant continue..
If plesk supports these it shouldn't be whining abou tthem being defaultly installed. How do I get passed this error?
and atomic-bleeding gives a error so yum cant continue..
atomicturtle
Golden Pleskian
MySQL-server-5.1.16-0.glibc23.i386 is not installed by default. Someone had to have grabbed that from the Mysql.com website.
M
magentait
Guest
I reported this issue to SWSoft, and they promised to give us more information about PHP5 and MySQL5 support in this thread. So just keep looking
V
Vitaly Malakhov
Guest
Hi all,
I'm Vitaly Malakhov, Plesk for Unix Support Team Leader. I was asked to leave a comment here, so I've read the thread to see what the question is and would like to clear these things up..
# what does Plesk supports mysql5 and php5 mean
It means that there are no point in Plesk code which conflict with them. In general if you replace mysql4 with mysql5, it does not affect Plesk itself, all the SQL requests Plesk sends to it from any Plesk's place will be processed w/o problems. There are no dependencies which do not allow mysql5 be installed.
As for PHP, note first that we talk about that PHP used by hosted web sites, it is loaded by client copy of apache as module (Plesk panel itself uses separate apache server copy with other compiled-in PHP). If you look into apache configs, you will find there that directives for both php4 and php5 modules are always included. If you replace php4 module with php5 and restart apache, your sites and PHP scripts continue working w/o problems.
# I installed Plesk 8 which supports mysql5 but it installed mysql4 instead
First of all note that neither mysql nor php are part of Plesk, SWsoft does not build its own mysql and php packages, as well as SWsoft does not compile and provide openssl, perl, xinetd and a lot of other system applications used by Plesk. Plesk uses standard services which are installed on the system. If mysql/php are found on the system where Plesk in installed, Plesk will use them. If these installations are not found, Plesk will download and install standard packages of OS vendor from autoinstall.plesk.com.
The same can be said about Virtuozzo installations. Virtuozzo OS templates and application templates are only made by SWsoft as a copy of standard packages from OS vendors.
# is Plesk tested with mysql5/php5
In general Plesk is tested on and oriented to standard OS installations with standard packages from OS vendor. If mysql/php v5 are available from OS vendor, for example in SuSE 10.1 or RedoraCore 5, then it is tested with them. If outdated FedoraCore 1 provides mysql3, then Plesk build for this OS is tested with it. Plesk code is almost identical for any OS and there are no global problems with mysql5 and php5 at 8.x, both of them are supported and should work w/o problems.
# what the exact steps are, to install mysql/php5 on my system
There are no specific recommendations or steps because all the steps are identical to any other application update (a-la recommendation "use `rpm -U` for RedHat-like OSes"). Get package updates from OS vendor and use them. If OS vendor does not provide such packages, then mysql/php v5 you try to find can only be provided by third party. There are hundred custom builds can be found in the world, for example well known http://www.atomicrocketturtle.com is really great source for such updates for many years. Although SWsoft cannot officially guarantee anything for third-party updates, if you get a custom package which fits your OS environment - you will not have problems with it. The most of problems which may appear with them are usually related to dependencies to third or system applications and can be solved accordingly. The advanced admins may even compile from sources.
# despite of all of above I found that Plesk is not compatible to mysql/php v5 I installed
If you find the problem, please report to bugreport@swsoft.com problem description: what you do, where and what kind of error happens plus system details: OS, Plesk version/build, mysql/php builds, where they were taken and so on. If it is found that this is really Plesk issue, it will be corrected in further updates.
Known problems as far as I remember at current moment are:
- mysql may not be reported in Server > Components as installed if custom package is used
- Virtuozzo Plesk template for Centos-4 has dependency problems with php-5 Virtuozzo template for CentOS-4
NOTE FOR PLESK FOR FreeBSD USERS: I'm really sorry, but Plesk dependencies bound to mysql4 there. Although Plesk itself may work with mysql5, admin apache copy is linked to libmysqlclient.so.14. It is possible to manually install mysql5 ignoring all the dependencies but I would not recommend this it for a while, it is going to be corrected and I hope will be done soon.
I'm Vitaly Malakhov, Plesk for Unix Support Team Leader. I was asked to leave a comment here, so I've read the thread to see what the question is and would like to clear these things up..
# what does Plesk supports mysql5 and php5 mean
It means that there are no point in Plesk code which conflict with them. In general if you replace mysql4 with mysql5, it does not affect Plesk itself, all the SQL requests Plesk sends to it from any Plesk's place will be processed w/o problems. There are no dependencies which do not allow mysql5 be installed.
As for PHP, note first that we talk about that PHP used by hosted web sites, it is loaded by client copy of apache as module (Plesk panel itself uses separate apache server copy with other compiled-in PHP). If you look into apache configs, you will find there that directives for both php4 and php5 modules are always included. If you replace php4 module with php5 and restart apache, your sites and PHP scripts continue working w/o problems.
# I installed Plesk 8 which supports mysql5 but it installed mysql4 instead
First of all note that neither mysql nor php are part of Plesk, SWsoft does not build its own mysql and php packages, as well as SWsoft does not compile and provide openssl, perl, xinetd and a lot of other system applications used by Plesk. Plesk uses standard services which are installed on the system. If mysql/php are found on the system where Plesk in installed, Plesk will use them. If these installations are not found, Plesk will download and install standard packages of OS vendor from autoinstall.plesk.com.
The same can be said about Virtuozzo installations. Virtuozzo OS templates and application templates are only made by SWsoft as a copy of standard packages from OS vendors.
# is Plesk tested with mysql5/php5
In general Plesk is tested on and oriented to standard OS installations with standard packages from OS vendor. If mysql/php v5 are available from OS vendor, for example in SuSE 10.1 or RedoraCore 5, then it is tested with them. If outdated FedoraCore 1 provides mysql3, then Plesk build for this OS is tested with it. Plesk code is almost identical for any OS and there are no global problems with mysql5 and php5 at 8.x, both of them are supported and should work w/o problems.
# what the exact steps are, to install mysql/php5 on my system
There are no specific recommendations or steps because all the steps are identical to any other application update (a-la recommendation "use `rpm -U` for RedHat-like OSes"). Get package updates from OS vendor and use them. If OS vendor does not provide such packages, then mysql/php v5 you try to find can only be provided by third party. There are hundred custom builds can be found in the world, for example well known http://www.atomicrocketturtle.com is really great source for such updates for many years. Although SWsoft cannot officially guarantee anything for third-party updates, if you get a custom package which fits your OS environment - you will not have problems with it. The most of problems which may appear with them are usually related to dependencies to third or system applications and can be solved accordingly. The advanced admins may even compile from sources.
# despite of all of above I found that Plesk is not compatible to mysql/php v5 I installed
If you find the problem, please report to bugreport@swsoft.com problem description: what you do, where and what kind of error happens plus system details: OS, Plesk version/build, mysql/php builds, where they were taken and so on. If it is found that this is really Plesk issue, it will be corrected in further updates.
Known problems as far as I remember at current moment are:
- mysql may not be reported in Server > Components as installed if custom package is used
- Virtuozzo Plesk template for Centos-4 has dependency problems with php-5 Virtuozzo template for CentOS-4
NOTE FOR PLESK FOR FreeBSD USERS: I'm really sorry, but Plesk dependencies bound to mysql4 there. Although Plesk itself may work with mysql5, admin apache copy is linked to libmysqlclient.so.14. It is possible to manually install mysql5 ignoring all the dependencies but I would not recommend this it for a while, it is going to be corrected and I hope will be done soon.
atomicturtle
Golden Pleskian
I think what you're running into here is that other 3rd party packages are installed on the system. Specifically using the MySQL.com 5.1 rpms. 5.0 is officially supported, whereas 5.1 is still a beta that MySQL.com doesnt even recommend running in production. Given that its a newer release, theres no way to package around that cleanly.
Getting that off the system is a fair bit of trouble, probably involving some --nodeps removals.
For everyone running RHEL4, I highly recommend installing yum and configuring the centosplus channel if you'd like to use MySQL 5 or PHP 5.1.
I intend on supporting Mysql 5.0, and PHP 5.2 in [atomic], however I dont want to push those in yet because of the problems it will cause for the PSA 7.5 and 8.0 users.
Getting that off the system is a fair bit of trouble, probably involving some --nodeps removals.
For everyone running RHEL4, I highly recommend installing yum and configuring the centosplus channel if you'd like to use MySQL 5 or PHP 5.1.
I intend on supporting Mysql 5.0, and PHP 5.2 in [atomic], however I dont want to push those in yet because of the problems it will cause for the PSA 7.5 and 8.0 users.
S
shredsalot
Guest
What exactly does this mean? What is and where does one get "yum"? What do you mean by configuring a centoplus channel? I've worked with and even administered Unix (Solaris, SunOS and AIX) in the past, but this terminology is a complete mystery to me. FWIW, I'm running Virtuozzo VPS on CentOS 4.2 with Plesk 8.1.0. All I want to do is upgrade MySQL to version 5.0 or later, and PHP 5.1 or later (mostly for security purposes, though some features are desired as well).
atomicturtle
Golden Pleskian
Yum is the network centric package management system for Fedora, CentOS, and as of version 5, RHEL.
D
danl
Guest
Just wondering if anyone has found a php 5.1.x or 5.2.x package for fedora core 4 x86_64
What would be the possible drawbacks of compiling and installing php from source (isn't the ./configure string supplied in phpinfo();?)
What would be the possible drawbacks of compiling and installing php from source (isn't the ./configure string supplied in phpinfo();?)
