Welcome! Log In Create A New Profile

Advanced

anybody succeeding in implementing PDO with their php-fpm setup?

Posted by Chris Cortese 
I don't know if there is something I'm not understanding about the
php.ini relations with php-fpm, but I cannot seem to get php compiled
with php-fpm and pdo and pdo_mysql.

I'm running:

Ubuntu Karmic Koala
php 5.3.2
php-fpm (the latest from svn per the php-fpm site's instructions)

I've tried many combinations of compiling, installing, uninstalling,
shared vs. dynamic, 6 hours of googling and building.

Still stuck pretty much where these folks were stuck:

http://ubuntu-virginia.ubuntuforums.org/showthread.php?p=9083208#post9083208



Chris


--
To unsubscribe, reply using "remove me" as the subject.
2010/4/6 Chris Cortese <cortese.consulting@gmail.com>:
> I don't know if there is something I'm not understanding about the php.ini
> relations with php-fpm, but I cannot seem to get php compiled with php-fpm
> and pdo and pdo_mysql.

It works well after compiling it with the rights option. There is
nothing FPM can do about make an extension working or not working.

root> /usr/local/php-5.3.2-stable/sbin/php-fpm -m
[PHP Modules]
bcmath
bz2
calendar
cgi-fcgi
Core
ctype
curl
date
dba
dom
enchant
ereg
exif
fileinfo
filter
ftp
gd
gettext
gmp
hash
iconv
json
libxml
mbstring
mcrypt
mhash
mysql
mysqli
mysqlnd
openssl
pcre
PDO
pdo_mysql
pdo_sqlite
Phar
posix
recode
Reflection
session
shmop
SimpleXML
soap
sockets
SPL
SQLite
sqlite3
standard
sysvmsg
sysvsem
sysvshm
tidy
tokenizer
wddx
xml
xmlreader
xmlwriter
xsl
zip
zlib

[Zend Modules]

An my configure options:

root@raptor> cat config.nice
#! /bin/sh
#
# Created by configure

'./configure' \
'--prefix=/usr/local/php-5.3.2-stable' \
'--enable-fpm' \
'--enable-cli' \
'--enable-bcmath' \
'--enable-calendar' \
'--enable-libxml' \
'--with-bz2' \
'--with-curl' \
'--with-curlwrappers' \
'--with-openssl' \
'--with-zlib' \
'--enable-dba' \
'--with-enchant' \
'--enable-exif' \
'--enable-ftp' \
'--with-gd' \
'--with-gettext' \
'--with-gmp' \
'--with-mhash' \
'--enable-mbstring' \
'--with-mcrypt' \
'--with-mysql=mysqlnd' \
'--with-mysqli=mysqlnd' \
'--with-pdo-mysql=mysqlnd' \
'--with-readline' \
'--with-recode' \
'--enable-shmop' \
'--enable-soap' \
'--enable-sockets' \
'--enable-sysvmsg' \
'--enable-sysvsem' \
'--enable-sysvshm' \
'--with-tidy' \
'--enable-wddx' \
'--with-xsl' \
'--enable-zip' \
'--with-pear' \
'--with-jpeg-dir=/usr/local' \
'--with-zlib-dir=/usr' \
'--with-png-dir=/usr/local' \
'--with-t1lib=/usr/local' \
'--with-freetype-dir=/usr/X11R6' \
'--enable-gd-native-ttf' \
'--enable-gd-jis-conv' \
"$@"

++ Jerome
>
> I'm running:
>
> Ubuntu Karmic Koala
> php 5.3.2
> php-fpm (the latest from svn per the php-fpm site's instructions)
>
> I've tried many combinations of compiling, installing, uninstalling, shared
> vs. dynamic, 6 hours of googling and building.
>
> Still stuck pretty much where these folks were stuck:
>
> http://ubuntu-virginia.ubuntuforums.org/showthread.php?p=9083208#post9083208
>
>
>
> Chris
>
>
> --
> To unsubscribe, reply using "remove me" as the subject.
>
On 06.04.2010 17:22, Chris Cortese wrote:
> I don't know if there is something I'm not understanding about the
> php.ini relations with php-fpm, but I cannot seem to get php compiled
> with php-fpm and pdo and pdo_mysql.
>
> I'm running:
>
> Ubuntu Karmic Koala
> php 5.3.2
> php-fpm (the latest from svn per the php-fpm site's instructions)
>
> I've tried many combinations of compiling, installing, uninstalling,
> shared vs. dynamic, 6 hours of googling and building.
>
> Still stuck pretty much where these folks were stuck:
>
> http://ubuntu-virginia.ubuntuforums.org/showthread.php?p=9083208#post9083208

PDO comes with PHP itself, no need to install it from PECL.
In fact it's enabled by default if you don't use --disable-all.
Just ./configure --with-pdo-mysql=/mysql/install/prefix/ does it.

--
Wbr,
Antony Dovgal
---
http://pinba.org - realtime statistics for PHP


--
To unsubscribe, reply using "remove me" as the subject.
Thanks,

I also tried Jerome's config options. I still get the same problems
afterwards when trying to run php-fpm. It's still looking for a
nonexistent pdo.so. I've also tried many different ways to install
pdo.so, no luck.

Here's where I'm at now:

/usr/src/php-5.3.2 $sudo php-fpm start
Starting php_fpm PHP Warning: PHP Startup: Unable to load dynamic
library '/usr/local/lib/php/extensions/no-debug-non-zts-20090626/pdo.so'
- /usr/local/lib/php/extensions/no-debug-non-zts-20090626/pdo.so: cannot
open shared object file: No such file or directory in Unknown on line 0
<br />
<b>Warning</b>: PHP Startup: Unable to load dynamic library
'/usr/local/lib/php/extensions/no-debug-non-zts-20090626/pdo.so' -
/usr/local/lib/php/extensions/no-debug-non-zts-20090626/pdo.so: cannot
open shared object file: No such file or directory in <b>Unknown</b> on
line <b>0</b><br />
PHP Warning: PHP Startup: Unable to load dynamic library
'/usr/local/lib/php/extensions/no-debug-non-zts-20090626/pdo_msql.so' -
/usr/local/lib/php/extensions/no-debug-non-zts-20090626/pdo_msql.so:
cannot open shared object file: No such file or directory in Unknown on
line 0
<br />
<b>Warning</b>: PHP Startup: Unable to load dynamic library
'/usr/local/lib/php/extensions/no-debug-non-zts-20090626/pdo_msql.so' -
/usr/local/lib/php/extensions/no-debug-non-zts-20090626/pdo_msql.so:
cannot open shared object file: No such file or directory in
<b>Unknown</b> on line <b>0</b><br />
done
/usr/src/php-5.3.2 $ ls -la
/usr/local/lib/php/extensions/no-debug-non-zts-20090626/
total 1000
drwxr-xr-x 2 root root 4096 2010-04-06 05:51 .
drwxr-xr-x 4 root root 4096 2009-06-29 19:43 ..
-rwxr-xr-x 1 root root 493111 2009-06-29 19:43 apc.so
-rwxr-xr-x 1 root root 200610 2009-06-29 19:51 memcache.so
-rwxr-xr-x 1 root root 130536 2010-04-06 05:51 pdo_mysql.so
-rwxr-xr-x 1 root root 169253 2009-06-29 19:52 syck.so



On 4/6/2010 6:42 AM, Antony Dovgal wrote:
> On 06.04.2010 17:22, Chris Cortese wrote:
>> I don't know if there is something I'm not understanding about the
>> php.ini relations with php-fpm, but I cannot seem to get php compiled
>> with php-fpm and pdo and pdo_mysql.
>>
>> I'm running:
>>
>> Ubuntu Karmic Koala
>> php 5.3.2
>> php-fpm (the latest from svn per the php-fpm site's instructions)
>>
>> I've tried many combinations of compiling, installing, uninstalling,
>> shared vs. dynamic, 6 hours of googling and building.
>>
>> Still stuck pretty much where these folks were stuck:
>>
>> http://ubuntu-virginia.ubuntuforums.org/showthread.php?p=9083208#post9083208
>
> PDO comes with PHP itself, no need to install it from PECL.
> In fact it's enabled by default if you don't use --disable-all.
> Just ./configure --with-pdo-mysql=/mysql/install/prefix/ does it.
>



--
To unsubscribe, reply using "remove me" as the subject.
Re: anybody succeeding in implementing PDO with their php-fpm setup?
April 06, 2010 05:26PM
look at the error

it's looking for pdo.so and pdo_msql.so - you have pdo_mysql.so only :)

typos? :)

On Tue, Apr 6, 2010 at 11:31 AM, Chris Cortese
<cortese.consulting@gmail.com> wrote:
> Thanks,
>
> I also tried Jerome's config options.  I still get the same problems
> afterwards when trying to run php-fpm.  It's still looking for a nonexistent
> pdo.so.  I've also tried many different ways to install pdo.so, no luck.
>
> Here's where I'm at now:
>
>  /usr/src/php-5.3.2 $sudo php-fpm start
> Starting php_fpm PHP Warning:  PHP Startup: Unable to load dynamic library
> '/usr/local/lib/php/extensions/no-debug-non-zts-20090626/pdo.so' -
> /usr/local/lib/php/extensions/no-debug-non-zts-20090626/pdo.so: cannot open
> shared object file: No such file or directory in Unknown on line 0
> <br />
> <b>Warning</b>:  PHP Startup: Unable to load dynamic library
> '/usr/local/lib/php/extensions/no-debug-non-zts-20090626/pdo.so' -
> /usr/local/lib/php/extensions/no-debug-non-zts-20090626/pdo.so: cannot open
> shared object file: No such file or directory in <b>Unknown</b> on line
> <b>0</b><br />
> PHP Warning:  PHP Startup: Unable to load dynamic library
> '/usr/local/lib/php/extensions/no-debug-non-zts-20090626/pdo_msql.so' -
> /usr/local/lib/php/extensions/no-debug-non-zts-20090626/pdo_msql.so: cannot
> open shared object file: No such file or directory in Unknown on line 0
> <br />
> <b>Warning</b>:  PHP Startup: Unable to load dynamic library
> '/usr/local/lib/php/extensions/no-debug-non-zts-20090626/pdo_msql.so' -
> /usr/local/lib/php/extensions/no-debug-non-zts-20090626/pdo_msql.so: cannot
> open shared object file: No such file or directory in <b>Unknown</b> on line
> <b>0</b><br />
>  done
>  /usr/src/php-5.3.2 $  ls -la
> /usr/local/lib/php/extensions/no-debug-non-zts-20090626/
> total 1000
> drwxr-xr-x 2 root root   4096 2010-04-06 05:51 .
> drwxr-xr-x 4 root root   4096 2009-06-29 19:43 ..
> -rwxr-xr-x 1 root root 493111 2009-06-29 19:43 apc.so
> -rwxr-xr-x 1 root root 200610 2009-06-29 19:51 memcache.so
> -rwxr-xr-x 1 root root 130536 2010-04-06 05:51 pdo_mysql.so
> -rwxr-xr-x 1 root root 169253 2009-06-29 19:52 syck.so
>
>
>
> On 4/6/2010 6:42 AM, Antony Dovgal wrote:
>>
>> On 06.04.2010 17:22, Chris Cortese wrote:
>>>
>>> I don't know if there is something I'm not understanding about the
>>> php.ini relations with php-fpm, but I cannot seem to get php compiled
>>> with php-fpm and pdo and pdo_mysql.
>>>
>>> I'm running:
>>>
>>> Ubuntu Karmic Koala
>>> php 5.3.2
>>> php-fpm (the latest from svn per the php-fpm site's instructions)
>>>
>>> I've tried many combinations of compiling, installing, uninstalling,
>>> shared vs. dynamic, 6 hours of googling and building.
>>>
>>> Still stuck pretty much where these folks were stuck:
>>>
>>>
>>> http://ubuntu-virginia.ubuntuforums.org/showthread.php?p=9083208#post9083208
>>
>> PDO comes with PHP itself, no need to install it from PECL.
>> In fact it's enabled by default if you don't use --disable-all.
>> Just ./configure --with-pdo-mysql=/mysql/install/prefix/ does it.
>>
>
>
>
> --
> To unsubscribe, reply using "remove me" as the subject.
>
Yeah I know at that time that first error is due to that file not
existing there. But this has been a 10 hour ordeal so far and I've
tried many different ways to build pdo.so.

Most recently, I've tried the 1st and 3rd methods here, to no avail:

http://constantshift.com/install-php-fpm-5-3-2-on-ubuntu-9-10/

Does anybody at all have php 5.3.2 working with PHP-FPM and PDO on
ubuntu 9.10?

I would love to know if you built from source, and if so, what config
options were used (and what you had to do beforehand so that those
config options actually worked).


Thanks,
Chris




On 4/6/2010 2:25 PM, Michael Shadle wrote:
> look at the error
>
> it's looking for pdo.so and pdo_msql.so - you have pdo_mysql.so only :)
>
> typos? :)
>
> On Tue, Apr 6, 2010 at 11:31 AM, Chris Cortese
> <cortese.consulting@gmail.com> wrote:
>> Thanks,
>>
>> I also tried Jerome's config options. I still get the same problems
>> afterwards when trying to run php-fpm. It's still looking for a nonexistent
>> pdo.so. I've also tried many different ways to install pdo.so, no luck.
>>
>> Here's where I'm at now:
>>
>> /usr/src/php-5.3.2 $sudo php-fpm start
>> Starting php_fpm PHP Warning: PHP Startup: Unable to load dynamic library
>> '/usr/local/lib/php/extensions/no-debug-non-zts-20090626/pdo.so' -
>> /usr/local/lib/php/extensions/no-debug-non-zts-20090626/pdo.so: cannot open
>> shared object file: No such file or directory in Unknown on line 0
>> <br />
>> <b>Warning</b>: PHP Startup: Unable to load dynamic library
>> '/usr/local/lib/php/extensions/no-debug-non-zts-20090626/pdo.so' -
>> /usr/local/lib/php/extensions/no-debug-non-zts-20090626/pdo.so: cannot open
>> shared object file: No such file or directory in<b>Unknown</b> on line
>> <b>0</b><br />
>> PHP Warning: PHP Startup: Unable to load dynamic library
>> '/usr/local/lib/php/extensions/no-debug-non-zts-20090626/pdo_msql.so' -
>> /usr/local/lib/php/extensions/no-debug-non-zts-20090626/pdo_msql.so: cannot
>> open shared object file: No such file or directory in Unknown on line 0
>> <br />
>> <b>Warning</b>: PHP Startup: Unable to load dynamic library
>> '/usr/local/lib/php/extensions/no-debug-non-zts-20090626/pdo_msql.so' -
>> /usr/local/lib/php/extensions/no-debug-non-zts-20090626/pdo_msql.so: cannot
>> open shared object file: No such file or directory in<b>Unknown</b> on line
>> <b>0</b><br />
>> done
>> /usr/src/php-5.3.2 $ ls -la
>> /usr/local/lib/php/extensions/no-debug-non-zts-20090626/
>> total 1000
>> drwxr-xr-x 2 root root 4096 2010-04-06 05:51 .
>> drwxr-xr-x 4 root root 4096 2009-06-29 19:43 ..
>> -rwxr-xr-x 1 root root 493111 2009-06-29 19:43 apc.so
>> -rwxr-xr-x 1 root root 200610 2009-06-29 19:51 memcache.so
>> -rwxr-xr-x 1 root root 130536 2010-04-06 05:51 pdo_mysql.so
>> -rwxr-xr-x 1 root root 169253 2009-06-29 19:52 syck.so
>>
>>
>>
>> On 4/6/2010 6:42 AM, Antony Dovgal wrote:
>>>
>>> On 06.04.2010 17:22, Chris Cortese wrote:
>>>>
>>>> I don't know if there is something I'm not understanding about the
>>>> php.ini relations with php-fpm, but I cannot seem to get php compiled
>>>> with php-fpm and pdo and pdo_mysql.
>>>>
>>>> I'm running:
>>>>
>>>> Ubuntu Karmic Koala
>>>> php 5.3.2
>>>> php-fpm (the latest from svn per the php-fpm site's instructions)
>>>>
>>>> I've tried many combinations of compiling, installing, uninstalling,
>>>> shared vs. dynamic, 6 hours of googling and building.
>>>>
>>>> Still stuck pretty much where these folks were stuck:
>>>>
>>>>
>>>> http://ubuntu-virginia.ubuntuforums.org/showthread.php?p=9083208#post9083208
>>>
>>> PDO comes with PHP itself, no need to install it from PECL.
>>> In fact it's enabled by default if you don't use --disable-all.
>>> Just ./configure --with-pdo-mysql=/mysql/install/prefix/ does it.
>>>
>>
>>
>>
>> --
>> To unsubscribe, reply using "remove me" as the subject.
>>
Please type the actual process you've tried, and the error you get
when trying to /etc/init.d/php-fpm start, rather than just linked to
various blogs and saying you've tried them. It's much easier to
determine a solution if the specific problem is visible.


--
To unsubscribe, reply using "remove me" as the subject.
Re: anybody succeeding in implementing PDO with their php-fpm setup?
April 06, 2010 06:58PM
Also look to make sure your extension_dir is setup properly.

php 5.3.2 is different than 5.2.x probably; you may need to adjust your php..ini.



On Tue, Apr 6, 2010 at 3:23 PM, Chris Cortese
<cortese.consulting@gmail.com> wrote:
> Yeah I know at that time that first error is due to that file not existing
> there.  But this has been a 10 hour ordeal so far and I've tried many
> different ways to build pdo.so.


--
To unsubscribe, reply using "remove me" as the subject.
Only a guess: did you install mysql (-client)?

7. Apr 2010 12:57 vorm. schrieb am "Michael Shadle" <mike503@gmail.com>:

Also look to make sure your extension_dir is setup properly.

php 5.3.2 is different than 5.2.x probably; you may need to adjust your
php.ini.



On Tue, Apr 6, 2010 at 3:23 PM, Chris Cortese

<cortese.consulting@gmail.com> wrote:

> Yeah I know at that time that first error is due to that file not existing
> there. But this has ...
--

To unsubscribe, reply using "remove me" as the subject.
I did finally get this to work.

There was so much trial and error that I can't post a straight solution.

I ended up removing any trace I could find of any past or present PHP on
the system.

I gave up on trying to load the PDO drivers shared, which wasn't really
that important for my purposes anyway.

Don't bother trying to PECL install pdo (only the DB-specific drivers
perhaps).

There were things to be sorted out about the extension_dir in going from
php 5.2.9 to 5.3.2.

If anybody else is trying to build the latest PHP (as of today) with the
latest Ubuntu, and needs help, feel free to email. I think I hit most
of the roadblocks already.


Chris




On 4/6/2010 11:49 PM, Stephen Mittag wrote:
> Only a guess: did you install mysql (-client)?
>
>> 7. Apr 2010 12:57 vorm. schrieb am "Michael Shadle" <mike503@gmail.com
>> <mailto:mike503@gmail.com>>:
>>
>> Also look to make sure your extension_dir is setup properly.
>>
>> php 5.3.2 is different than 5.2.x probably; you may need to adjust
>> your php.ini.
>>
>>
>>
>> On Tue, Apr 6, 2010 at 3:23 PM, Chris Cortese
>>
>> <cortese.consulting@gmail.com <mailto:cortese.consulting@gmail.com>>
>> wrote:
>>
>> > Yeah I know at that time that first error is due to that file not
>> existing > there. But this has ...
>>
>> --
>>
>> To unsubscribe, reply using "remove me" as the subject.
>>
Sorry, only registered users may post in this forum.

Click here to login

Online Users

Guests: 118
Record Number of Users: 8 on April 13, 2023
Record Number of Guests: 421 on December 02, 2018
Powered by nginx      Powered by FreeBSD      PHP Powered      Powered by MariaDB      ipv6 ready