1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

PHP and mySQL 5

Discussion in 'Plesk for Linux - 8.x and Older' started by dyrer, Mar 27, 2007.

  1. dyrer

    dyrer Basic Pleskian

    26
     
    Joined:
    Mar 27, 2007
    Messages:
    51
    Likes Received:
    0
    Location:
    Greece
    Hello
    How can set my vps to PHP 5 and mysql 5
    I have plesk 8.1 installed
     
  2. matbeard

    matbeard Guest

    0
     
    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).
     
  3. danliker

    danliker Silver Pleskian Plesk Certified Professional

    33
    43%
    Joined:
    Feb 15, 2006
    Messages:
    575
    Likes Received:
    0
    Location:
    Switzerland
    just install php5 / mysql5 from your distribution and have fun

    search the forum, there are many threads about how to do this ...
     
  4. matbeard

    matbeard Guest

    0
     
    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.
     
  5. dyrer

    dyrer Basic Pleskian

    26
     
    Joined:
    Mar 27, 2007
    Messages:
    51
    Likes Received:
    0
    Location:
    Greece
    Can someone help us?
     
  6. matbeard

    matbeard Guest

    0
     
    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
     
  7. benji

    benji Guest

    0
     
    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...

    :mad:
     
  8. atomicturtle

    atomicturtle Golden Pleskian

    29
     
    Joined:
    Nov 20, 2002
    Messages:
    2,110
    Likes Received:
    7
    Location:
    Washington, DC
    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.
     
  9. benji

    benji Guest

    0
     
    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 ?
     
  10. atomicturtle

    atomicturtle Golden Pleskian

    29
     
    Joined:
    Nov 20, 2002
    Messages:
    2,110
    Likes Received:
    7
    Location:
    Washington, DC
    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.
     
  11. benji

    benji Guest

    0
     
    Ok, I will wait 'till its stable.

    Will it be matter of , days?, months?, years?

    Thanks again.
     
  12. atomicturtle

    atomicturtle Golden Pleskian

    29
     
    Joined:
    Nov 20, 2002
    Messages:
    2,110
    Likes Received:
    7
    Location:
    Washington, DC
    Probably not until after we finish up ASL 2.0
     
  13. Spre

    Spre Guest

    0
     
    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..
     
  14. atomicturtle

    atomicturtle Golden Pleskian

    29
     
    Joined:
    Nov 20, 2002
    Messages:
    2,110
    Likes Received:
    7
    Location:
    Washington, DC
    MySQL-server-5.1.16-0.glibc23.i386 is not installed by default. Someone had to have grabbed that from the Mysql.com website.
     
  15. magentait

    magentait Guest

    0
     
    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
     
  16. Vitaly Malakhov

    Vitaly Malakhov Guest

    0
     
    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.
     
  17. atomicturtle

    atomicturtle Golden Pleskian

    29
     
    Joined:
    Nov 20, 2002
    Messages:
    2,110
    Likes Received:
    7
    Location:
    Washington, DC
    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.
     
  18. shredsalot

    shredsalot Guest

    0
     
    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).
     
  19. atomicturtle

    atomicturtle Golden Pleskian

    29
     
    Joined:
    Nov 20, 2002
    Messages:
    2,110
    Likes Received:
    7
    Location:
    Washington, DC
    Yum is the network centric package management system for Fedora, CentOS, and as of version 5, RHEL.
     
  20. danl

    danl Guest

    0
     
    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();?)
     
Loading...