The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

PDO Side effects?

Discussion in 'General Discussion' started by nibb, Dec 5, 2008.

  1. nibb

    nibb Well-Known Member

    Joined:
    Mar 22, 2008
    Messages:
    301
    Likes Received:
    1
    Trophy Points:
    18
    Im wondering I have some things turned off like:

    The PDO extension in PHP, pdo_mysql, etc.

    Most scripts use PHP and MySQL extension so no problem at all until i came up with 1 little devil taht requires php with PDO and pdo_mysql

    My question is, is there any side effect on a production server if i recompile apache with those extensiones turned on?

    Do they run in parallel to the way php and mysql runs now or will it break the whole scripts running and send the server to hell?

    Basically what i mean is, i have the resources on the server to run it but do they run in parallel or they change/reconfigure the whole way php and mysql works?

    Thanks for the community. Wonder what the side effects are.

    About that app, well is EGroupware, and I hate it...
     
  2. rhenderson

    rhenderson Well-Known Member

    Joined:
    Apr 21, 2005
    Messages:
    785
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Oklahoma
    cPanel Access Level:
    Root Administrator
    Hi,

    We've been running pdo extension for around two year (or so) and had no issues with it.
     
  3. sirotex

    sirotex Well-Known Member

    Joined:
    Jul 10, 2008
    Messages:
    121
    Likes Received:
    0
    Trophy Points:
    16
    Hello,

    We can second that. No problems here at all.
     
  4. nibb

    nibb Well-Known Member

    Joined:
    Mar 22, 2008
    Messages:
    301
    Likes Received:
    1
    Trophy Points:
    18
    I actually did not meant PDO itself but running it in parallel with extension PHP on the same server.
     
  5. rhenderson

    rhenderson Well-Known Member

    Joined:
    Apr 21, 2005
    Messages:
    785
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Oklahoma
    cPanel Access Level:
    Root Administrator
    If this helps we are running

    In the configure for php
    pdo=shared
    --with-pdo-mysql=shared
    --with-pdo-sqlite=shared

    Modules:

    PDO
    PDO support enabled
    PDO drivers sqlite, sqlite2, mysql


    pdo_mysql
    PDO Driver for MySQL, client library version 5.0.67


    pdo_sqlite
    PDO Driver for SQLite 3.x enabled
    PECL Module version (bundled) 1.0.1 $Id: pdo_sqlite.c,v 1.10.2.6.2.3 2007/12/31 07:20:10 sebastian Exp $
    SQLite Library 3.3.7

    No problems, hope that helps. :)
     
  6. nibb

    nibb Well-Known Member

    Joined:
    Mar 22, 2008
    Messages:
    301
    Likes Received:
    1
    Trophy Points:
    18
    Ok, will try it then.
     
  7. phoenixweb

    phoenixweb Well-Known Member

    Joined:
    Jun 3, 2004
    Messages:
    68
    Likes Received:
    0
    Trophy Points:
    6
    cPanel Access Level:
    DataCenter Provider
    Same problems.

    I have been looking for more information about PDO.

    On EA3 is written this:

    (UNSUPPORTED EXPERIMENTAL) Includes SQLite support. Other drivers (freetds, oracle, etc) can be installed with PECL. If you use rawopts to add them during compile then you will have to have them '=shared' and *NOT* do the PHP "versioning" option. Custom opt mods for PDO extensions should also do the "versioning" logic this one does.

    This means that can be dangerous to put in a production enviroment.
    I found also helpfull articles that say it's an alpha (or a beta), do not put in prodution enviroment.

    After I while I realised that all the articles are OLD, that PDO in stable since 2006, and maybe also the written on EA3 is an old warning never removed.

    If there is any Cpanel Admin, can please check this out?

    If all the problems are removed, then I can install for my littles devils :D:D
     
  8. dexus

    dexus Well-Known Member

    Joined:
    Jan 14, 2006
    Messages:
    169
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    Root Administrator
    We have on two servers PHP compiled with PDO support but it looks like it is not working...

    in configure there are following options...

    --enable-pdo=shared
    --with-pdo-mysql=shared
    --with-pdo-sqlite=shared

    ...but that's it, there are no PDO modules, driver versions etc shown in phpinfo...

    What can be the reason for this?
     
  9. dexus

    dexus Well-Known Member

    Joined:
    Jan 14, 2006
    Messages:
    169
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    Root Administrator
    I noticed that extensions are not loaded in php.ini...

    This is missing...

    extension = "pdo.so"
    extension = "pdo_sqlite.so"
    extension = "sqlite.so"
    extension = "pdo_mysql.so"

    Why? I have this on one server and EasyApache added that, but why is that not added on other two servers???

    Can someone please explain this?
     
  10. cPanelDavidG

    cPanelDavidG Technical Product Specialist

    Joined:
    Nov 29, 2006
    Messages:
    11,279
    Likes Received:
    8
    Trophy Points:
    38
    Location:
    Houston, TX
    cPanel Access Level:
    Root Administrator
    I recommend having our technical analysts take a look at your servers to diagnose the cause for these issues: http://tickets.cPanel.net/submit
     
Loading...

Share This Page