PDO Side effects?

[nibb]

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

[rhenderson]

Hi,

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

[sirotex]

Hello,

We can second that. No problems here at all.

[nibb]

I actually did not meant PDO itself but running it in parallel with extension PHP on the same server.

[rhenderson]

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.

[nibb]

Ok, will try it then.

[phoenixweb]

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

[dexus]

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?

[dexus]

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?

[cPanelDavidG]

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?

I recommend having our technical analysts take a look at your servers to diagnose the cause for these issues: http://tickets.cPanel.net/submit