Php+pdo_informix on fedora 17

[waltermg117]

Hello, there's any one who knows how to setup a pdo_informix in fedora 17?

I have try with this guide for Centos http://lemachete.wordpress.com/category/php/

but when i try to connect with a database it thows me this error:

SQLSTATE=HY000, SQLDriverConnect: -23101 [Informix][Informix ODBC Driver][Informix]Unspecified System Error = -23101.

When i do a phpinfo(), it appears me all the modules of informix including INFORMIXDIR.

Im stuck guys please some help, i need this for work

[ocratato]

A quick Google for informix and 23101 gives a lot of results concerning locales and installation directories. Have you eliminated these problems ? I have seen things get very messy when locales are mismatched.

[waltermg117]

I've change my OS to debian and it result (Thanks to VirtualBox) , but i want to do this on fedora, if someone can do it, and post a tutorial ill will be gratefull

---------- Post added at 01:46 PM ---------- Previous post was at 01:43 PM ----------

Originally Posted by ocratato

A quick Google for informix and 23101 gives a lot of results concerning locales and installation directories. Have you eliminated these problems ? I have seen things get very messy when locales are mismatched.

there a part of the tutorial that saids:

"ahora vamos a dar de alta los servicios en el archivo /etc/services

Agrega al final los puertos 1526 y 1527. ejemplo:

# Local services

aplicaexec 1526/tcp

sqlexec2 1527/tcp
"

But this service ports are used for other services, someone knows about this services? can i use other ports for them?

regards

[waltermg117]

Hello, i've noted this when doing a php command:

"PHP Warning: PHP Startup: Unable to load dynamic library '/usr/lib64/php/modules/pdo_informix.so' - /usr/lib64/php/modules/pdo_informix.so: undefined symbol: pdo_parse_params in Unknown on line 0
PHP Warning: Module 'pdo_informix' already loaded in Unknown on line 0"

Maybe solving this, the problem will be fixed? How can i do this?

Heeellpppp Pleaaaseeeee

[RupertPupkin]

I don't know anything about Php, and I don't know if it will help but you could try looking at my guide for installing Informix in Fedora, which I just posted here: http://forums.fedoraforum.org/showthread.php?t=285308

In particular, look at steps 12 and 14. By default Informix does not allow TCP connections, you have to enable it as described in those two steps.

[waltermg117]

A light in the darkness!!! Thank you Rupert, i will try this, i hope it result

Thanks again man...

[volgon]

Assuming you have Informix setup and working correctly in /opt/IBM/informix, these are my notes for building the PHP PDO.

First create a file called /opt/IBM/informix/informix.env

# Script to setup environment for Informix

INFORMIXDIR=/opt/IBM/informix 
PATH=$PATH:/opt/IBM/informix/bin 
ODBCINI=/etc/odbc.ini 
INFORMIXSERVER={Your Informix server}

export INFORMIXDIR
export PATH
export ODBCINI
export INFORMIXSERVER

Then try these commands
# . /opt/IBM/informix/informix.env
# wget http://pecl.php.net/get/PDO_INFORMIX-1.2.6.tgz
# tar zxvf PDO_INFORMIX-1.2.6.tgz
# cd PDO_INFORMIX-1.2.6
# phpize
# ./configure
# make
# cp modules/pdo_informix.so /usr/lib64/php/modules/
# echo extension=pdo_informix.so > /etc/php.d/pdo_informix.ini
# echo " " >> /etc/sysconfig/httpd
# echo "# Setup Informix Environment" >> /etc/sysconfig/httpd
# echo ". /opt/IBM/informix/informix.env" >> /etc/sysconfig/httpd

Update /etc/odbc.ini and /etc/odbcinst.ini

NOTE:
If using PHP version 5.4 or newer, pdo_informix.c line 45 "function_entry" needs to be changed to "zend_function_entry".