Php Informix Connect
Posted in 2007
A user on Fedora Core 6 with PHP 5.2.3/Apache 2 couldn't build the PDO_Informix extension, as configure found no Informix driver under /opt/informix. Replies confirmed the Informix Client SDK (not the server) must be downloaded and installed first, then build PDO_Informix from PECL via phpize/configure --with-pdo-informix=/opt/informix/make, copy pdo_informix.so into the PHP modules dir and add extension=pdo_informix.so to php.ini. Advice also covered adding TRANSLATIONDLL to the PDO connection string on Unix/Linux and ensuring INFORMIXDIR/INFORMIXSERVER are set for Apache. The user then hit a CSDK install error (missing /opt/informix/etc/make_lvers) and was asked for install logs; no resolution to that is recorded.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Topics: Installation, Setup & Upgrades
Hello, I want to connect my intranet server (with php/apache) to the other informix database server, But I didnt it. I dont know how i can do it? Can i use php_informix extensions for example ifx_connect(); I was read this article: http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0606bombardier/index.html and doing step one step but i was not success. Firstly I reading this page and copy PDO_INFORMIX to Php.5.3/ext/ pdo_informix directory. Before i was download Php.5.2.3 source code and compiled Php.5.2.3 from the source code ./configure --enable-pdo --with-pdo-informix=/opt/ informix bla bla... then make / make install it. But that not found informix driver to /opt/informix shuold I download and setup Informix Client SDK ? to /opt/informix directory My Intranet Server Fetaures Fedora Core 6 and Php 5.2.3 and Apache 2 can anyone help me? I shoud connect this database server. If you could to informix database server contact with me please. I'am sad for bad english. Thank you everything
Khan wrote: > Firstly I reading this page and copy PDO_INFORMIX to Php.5.3/ext/ > pdo_informix directory. > Before i was download Php.5.2.3 source code and compiled Php.5.2.3 > from the source code ./configure --enable-pdo --with-pdo-informix=/opt/ > informix bla bla... then make / make install it. > But that not found informix driver to /opt/informix > shuold I download and setup Informix Client SDK ? to /opt/informix > directory Yes, download, install and setup the csdk first. It must not be /opt/informix but that is the default more or less. Install instructions for pdo_informix when the csdk is already installed: Untar the PECL pdo_informix package and: phpize ./configure --with-pdo-informix=/opt/informix make Then copy the resulting pdo_informix.so from modules directory to your php modules dir. Then in php.ini setup: extension=pdo_informix.so HTH, -- Aleksander Kamenik system administrator +372 6659 649 aleksander@krediidiinfo.ee Krediidiinfo AS http://www.krediidiinfo.ee/
Khan wrote: > Hello, > > I want to connect my intranet server (with php/apache) to the other > informix database server, > But I didnt it. I dont know how i can do it? > > Can i use php_informix extensions for example ifx_connect(); > I haven't done it in a long time... before PDO was released. > I was read this article: http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0606bombardier/index.html > and doing step one step but i was not success. > Seems a step by step article... You should continue. > Firstly I reading this page and copy PDO_INFORMIX to Php.5.3/ext/ > pdo_informix directory. > Before i was download Php.5.2.3 source code and compiled Php.5.2.3 > from the source code ./configure --enable-pdo --with-pdo-informix=/opt/ > informix bla bla... then make / make install it. > But that not found informix driver to /opt/informix > shuold I download and setup Informix Client SDK ? to /opt/informix > directory > Yes. It's one of the steps in the article you mentioned. PDO will require the informix libraries. Keep following the article and if you have any issues come back here. > can anyone help me? Hopefully yes. > I shoud connect this database server. > If you could to informix database server contact with me please. What I can do for the moment is assure you it can be done and has been done by a lot of people. > I'am sad for bad english. It's a problem for all of us, non natives... But I could understand you perfectly... maybe because my english is bad also :) Regards, -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently...
Fernando Nunes wrote:
> Khan wrote:
>> Hello,
>>
>> I want to connect my intranet server (with php/apache) to the other
>> informix database server,
>> But I didnt it. I dont know how i can do it?
>>
>> Can i use php_informix extensions for example ifx_connect();
>>
>
> I haven't done it in a long time... before PDO was released.
>
>> I was read this article:
>> http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0606bombardier/index.html
>>
>> and doing step one step but i was not success.
>>
>
> Seems a step by step article... You should continue.
>
Just one note... The article expects you to install the Informix server.
(it references the tests with onstat etc.). Skip that part. You just need the
client side product (CSDK). You already have the server.
It's in the article, but I leave it here: the csdk can be downloaded from
http://www-306.ibm.com/software/data/informix/downloads.html
Check the other answer someone left. It's more detailed.
Regards.
--
Fernando Nunes
Portugal
http://informix-technology.blogspot.com
My email works... but I don't check it frequently...
On 5 Temmuz, 15:30, Fernando Nunes <s...@domus.online.pt> wrote: > Khan wrote: > > Hello, > > > I want to connect my intranet server (with php/apache) to the other > > informix database server, > > But I didnt it. I dont know how i can do it? > > > Can i use php_informix extensions for example ifx_connect(); > > I haven't done it in a long time... before PDO was released. > > > I was read this article:http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0606... > > and doing step one step but i was not success. > > Seems a step by step article... You should continue. > > > Firstly I reading this page and copy PDO_INFORMIX to Php.5.3/ext/ > > pdo_informix directory. > > Before i was download Php.5.2.3 source code and compiled Php.5.2.3 > > from the source code ./configure --enable-pdo --with-pdo-informix=/opt/ > > informix bla bla... then make / make install it. > > But that not found informix driver to /opt/informix > > shuold I download and setup Informix Client SDK ? to /opt/informix > > directory > > Yes. It's one of the steps in the article you mentioned. PDO will require the > informix libraries. Keep following the article and if you have any issues come > back here. > > > can anyone help me? > > Hopefully yes. > > > I shoud connect this database server. > > If you could to informix database server contact with me please. > > What I can do for the moment is assure you it can be done and has been done by > a lot of people. > > > I'am sad for bad english. > > It's a problem for all of us, non natives... But I could understand you > perfectly... maybe because my english is bad also :) > > Regards, > > -- > Fernando Nunes > Portugal > > http://informix-technology.blogspot.com > My email works... but I don't check it frequently... Thank you for your cooperate and interesting :) I will try everyone :) thank you a lot
Khan wrote: > Hello, > > I want to connect my intranet server (with php/apache) to the other > informix database server, > But I didnt it. I dont know how i can do it? > > Can i use php_informix extensions for example ifx_connect(); > > I was read this article: http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0606bombardier/index.html > and doing step one step but i was not success. > > Firstly I reading this page and copy PDO_INFORMIX to Php.5.3/ext/ > pdo_informix directory. > Before i was download Php.5.2.3 source code and compiled Php.5.2.3 > from the source code ./configure --enable-pdo --with-pdo-informix=/opt/ > informix bla bla... then make / make install it. > But that not found informix driver to /opt/informix > shuold I download and setup Informix Client SDK ? to /opt/informix > directory > > > My Intranet Server Fetaures > Fedora Core 6 and Php 5.2.3 and Apache 2 If you have installed cdsk and cut and paste the test.php from the example in the techarticel in your test.php on a linux/unix host it will not run. Look at: http://www-03.ibm.com/developerworks/blogs/page/gbowerman?tag=apache Change the connection string from: -------------------------------- $db = new PDO("informix:host=servername.domain.com; service=8201; database=test_db; server=testserver; protocol=onsoctcp; EnableScrollableCursors=1;", "testuser", "testpass"); -------------------------------- to: -------------------------------- $db = new PDO("informix:host=servername.domain.com; service=8201;" . "database=test_db; server=testserver; protocol=onsoctcp;" . "EnableScrollableCursors=1;" . "TRANSLATIONDLL=/opt/informix/lib/esql/igo4a304.so", "testuser", "testpass"); -------------------------------- Make sure that the Environmetvariables INFORMIXSERVER and INFORMIXDIR are known to your Apache server at runtime. -- Holger de Wall
Fernando Nunes wrote: > Khan wrote: >> Hello, >> >> I want to connect my intranet server (with php/apache) to the other >> informix database server, >> But I didnt it. I dont know how i can do it? >> >> Can i use php_informix extensions for example ifx_connect(); >> > > I haven't done it in a long time... before PDO was released. > >> I was read this article: >> http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0606bombardier/index.html >> >> and doing step one step but i was not success. >> > > Seems a step by step article... You should continue. > >> Firstly I reading this page and copy PDO_INFORMIX to Php.5.3/ext/ >> pdo_informix directory. >> Before i was download Php.5.2.3 source code and compiled Php.5.2.3 >> from the source code ./configure --enable-pdo --with-pdo-informix=/opt/ >> informix bla bla... then make / make install it. >> But that not found informix driver to /opt/informix >> shuold I download and setup Informix Client SDK ? to /opt/informix >> directory >> > > Yes. It's one of the steps in the article you mentioned. PDO will > require the informix libraries. Keep following the article and if you > have any issues come back here. > >> can anyone help me? > > Hopefully yes. > >> I shoud connect this database server. >> If you could to informix database server contact with me please. > > What I can do for the moment is assure you it can be done and has been > done by a lot of people. > > >> I'am sad for bad english. > > It's a problem for all of us, non natives... But I could understand you > perfectly... maybe because my english is bad also :) > > Regards, > And BTW - both of your English is much better than many Americans I know! :-) -- ================== Remove the "x" from my email address Jerry Stuckle JDS Computer Training Corp. jstucklex@attglobal.net ==================
On 5 Temmuz, 20:08, Jerry Stuckle <jstuck...@attglobal.net> wrote: > Fernando Nunes wrote: > > Khan wrote: > >> Hello, > > >> I want to connect my intranet server (with php/apache) to the other > >> informix database server, > >> But I didnt it. I dont know how i can do it? > > >> Can i use php_informix extensions for example ifx_connect(); > > > I haven't done it in a long time... before PDO was released. > > >> I was read this article: > >>http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0606... > > >> and doing step one step but i was not success. > > > Seems a step by step article... You should continue. > > >> Firstly I reading this page and copy PDO_INFORMIX to Php.5.3/ext/ > >> pdo_informix directory. > >> Before i was download Php.5.2.3 source code and compiled Php.5.2.3 > >> from the source code ./configure --enable-pdo --with-pdo-informix=/opt/ > >> informix bla bla... then make / make install it. > >> But that not found informix driver to /opt/informix > >> shuold I download and setup Informix Client SDK ? to /opt/informix > >> directory > > > Yes. It's one of the steps in the article you mentioned. PDO will > > require the informix libraries. Keep following the article and if you > > have any issues come back here. > > >> can anyone help me? > > > Hopefully yes. > > >> I shoud connect this database server. > >> If you could to informix database server contact with me please. > > > What I can do for the moment is assure you it can be done and has been > > done by a lot of people. > > >> I'am sad for bad english. > > > It's a problem for all of us, non natives... But I could understand you > > perfectly... maybe because my english is bad also :) > > > Regards, > > And BTW - both of your English is much better than many Americans I > know! :-) > > -- > ================== > Remove the "x" from my email address > Jerry Stuckle > JDS Computer Training Corp. > jstuck...@attglobal.net > ==================- Al nt y gizle - > > - Al nt y g'ster - I started setup by Informix Client SDK but I had this error Installing SDK Files by RPM /bin/sh: /opt/informix/etc/make_lvers: (like: Havent got files and directory) Please read the information below. ***** Error occurred during installation. Please refer to log file for details. ***** What can i do?
Khan wrote: > On 5 Temmuz, 20:08, Jerry Stuckle <jstuck...@attglobal.net> wrote: >> Fernando Nunes wrote: >>> Khan wrote: >>>> Hello, >>>> I want to connect my intranet server (with php/apache) to the other >>>> informix database server, >>>> But I didnt it. I dont know how i can do it? >>>> Can i use php_informix extensions for example ifx_connect(); >>> I haven't done it in a long time... before PDO was released. >>>> I was read this article: >>>> http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0606... >>>> and doing step one step but i was not success. >>> Seems a step by step article... You should continue. >>>> Firstly I reading this page and copy PDO_INFORMIX to Php.5.3/ext/ >>>> pdo_informix directory. >>>> Before i was download Php.5.2.3 source code and compiled Php.5.2.3 >>>> from the source code ./configure --enable-pdo --with-pdo-informix=/opt/ >>>> informix bla bla... then make / make install it. >>>> But that not found informix driver to /opt/informix >>>> shuold I download and setup Informix Client SDK ? to /opt/informix >>>> directory >>> Yes. It's one of the steps in the article you mentioned. PDO will >>> require the informix libraries. Keep following the article and if you >>> have any issues come back here. >>>> can anyone help me? >>> Hopefully yes. >>>> I shoud connect this database server. >>>> If you could to informix database server contact with me please. >>> What I can do for the moment is assure you it can be done and has been >>> done by a lot of people. >>>> I'am sad for bad english. >>> It's a problem for all of us, non natives... But I could understand you >>> perfectly... maybe because my english is bad also :) >>> Regards, >> And BTW - both of your English is much better than many Americans I >> know! :-) >> >> -- >> ================== >> Remove the "x" from my email address >> Jerry Stuckle >> JDS Computer Training Corp. >> jstuck...@attglobal.net >> ==================- Al nt y gizle - >> >> - Al nt y g'ster - > > I started setup by Informix Client SDK but I had this error > > > Installing SDK Files by RPM > /bin/sh: /opt/informix/etc/make_lvers: (like: Havent got files and > directory) > > > Please read the information below. > > ***** Error occurred during installation. Please refer to log file for > details. > ***** > > What can i do? > Can you give us details about the steps you took? Check /tmp/ for something that resembles an installation log file. Regards -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently...