Connecting Tech Pros Worldwide Forums | Help | Site Map

Php Informix Connect

Khan
Guest
 
Posts: n/a
#1: Jul 5 '07
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/developerwork...ier/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


Fernando Nunes
Guest
 
Posts: n/a
#2: Jul 5 '07

re: Php Informix Connect


Khan wrote:
Quote:
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.
Quote:
I was read this article: http://www-128.ibm.com/developerwork...ier/index.html
and doing step one step but i was not success.
>
Seems a step by step article... You should continue.
Quote:
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.
Quote:
can anyone help me?
Hopefully yes.
Quote:
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.

Quote:
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
Guest
 
Posts: n/a
#3: Jul 5 '07

re: Php Informix Connect


Fernando Nunes wrote:
Quote:
Khan wrote:
Quote:
>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.
>
Quote:
>I was read this article:
>http://www-128.ibm.com/developerwork...ier/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...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...
Khan
Guest
 
Posts: n/a
#4: Jul 5 '07

re: Php Informix Connect


On 5 Temmuz, 15:30, Fernando Nunes <s...@domus.online.ptwrote:
Quote:
Khan wrote:
Quote:
Hello,
>
Quote:
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?
>
Quote:
Can i use php_informix extensions for example ifx_connect();
>
I haven't done it in a long time... before PDO was released.
>
Quote:
I was read this article:http://www-128.ibm.com/developerwork...rticle/dm-0606...
and doing step one step but i was not success.
>
Seems a step by step article... You should continue.
>
Quote:
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.
>
Quote:
can anyone help me?
>
Hopefully yes.
>
Quote:
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.
>
Quote:
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

Jerry Stuckle
Guest
 
Posts: n/a
#5: Jul 5 '07

re: Php Informix Connect


Fernando Nunes wrote:
Quote:
Khan wrote:
Quote:
>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.
>
Quote:
>I was read this article:
>http://www-128.ibm.com/developerwork...ier/index.html
>>
>and doing step one step but i was not success.
>>
>
Seems a step by step article... You should continue.
>
Quote:
>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.
>
Quote:
>can anyone help me?
>
Hopefully yes.
>
Quote:
>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.
>
>
Quote:
>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
==================
Khan
Guest
 
Posts: n/a
#6: Jul 5 '07

re: Php Informix Connect


On 5 Temmuz, 20:08, Jerry Stuckle <jstuck...@attglobal.netwrote:
Quote:
Fernando Nunes wrote:
Quote:
Khan wrote:
Quote:
Hello,
>
Quote:
Quote:
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?
>
Quote:
Quote:
Can i use php_informix extensions for example ifx_connect();
>
Quote:
I haven't done it in a long time... before PDO was released.
>
Quote:
Quote:
I was read this article:
>http://www-128.ibm.com/developerwork...rticle/dm-0606...
>
Quote:
Quote:
and doing step one step but i was not success.
>
Quote:
Seems a step by step article... You should continue.
>
Quote:
Quote:
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
>
Quote:
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.
>
Quote:
Quote:
can anyone help me?
>
Quote:
Hopefully yes.
>
Quote:
Quote:
I shoud connect this database server.
If you could to informix database server contact with me please.
>
Quote:
What I can do for the moment is assure you it can be done and has been
done by a lot of people.
>
Quote:
Quote:
I'am sad for bad english.
>
Quote:
It's a problem for all of us, non natives... But I could understand you
perfectly... maybe because my english is bad also :)
>
Quote:
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?

Fernando Nunes
Guest
 
Posts: n/a
#7: Jul 5 '07

re: Php Informix Connect


Khan wrote:
Quote:
On 5 Temmuz, 20:08, Jerry Stuckle <jstuck...@attglobal.netwrote:
Quote:
>Fernando Nunes wrote:
Quote:
>>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/developerwork...rticle/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...
Jerry Stuckle
Guest
 
Posts: n/a
#8: Jul 6 '07

re: Php Informix Connect


Khan wrote:
Quote:
On 5 Temmuz, 20:08, Jerry Stuckle <jstuck...@attglobal.netwrote:
Quote:
>Fernando Nunes wrote:
Quote:
>>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/developerwork...rticle/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?
>
Did you install the informix runtime environment first?

I don't know about via RPM - but in Debian you have to install the
runtime before the sdk.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
Khan
Guest
 
Posts: n/a
#9: Jul 6 '07

re: Php Informix Connect


I was doing about step by step

1. php-5.2.3.tar.gz / PDO_INFORMIX-1.1.0.tgz / clientsdk.
2.90.FC4R1.LINUX.tar I was download everyone to the /tmp directory

2. #tar zxf PDO_INFORMIX-1.1.0.tgz and #tar zxf php-5.2.3.tar.gz by
root

3. groupadd informix and useradd -g informix -p xxxx -d /dev/null
informix But that give error :
[root@local tmp]# useradd -g informix -p xxxx -d /dev/null informix
useradd: warning: the home directory already exists.
Not copying any file from skel directory into it.

4. mkdir /opt/informix and chown informix.informix /opt/informix (by
root because dont permission informix)

5. cp clientsdk.2.90.FC4R1.LINUX.tar /opt/informix

6. tar -xvf clientsdk.2.90.FC4R1.LINUX.tar (by root because dont
permission informix)

7. ./installclientsdk and started Initializing InstallShield
Wizard........ and give this error
Verifying JVM.Exception in thread "main"
java.lang.NoClassDefFoundError: version
at gnu.java.lang.MainThread.run(libgcj.so.7rh)
Caused by: java.lang.ClassNotFoundException: version not found in
gnu.gcj.runtime.SystemClassLoader{urls=[file:./],
parent=gnu.gcj.runtime.ExtensionClassLoader{urls=[], parent=null}}

8. Installing steps
/opt/informix
with the following features:
Client
Messages
GLS
for a total size:
85,9 MB
and Installing IBM Informix Client-SDK. Please wait...
Installing SDK GLS Files by RPM

9. and give this error:
/bin/sh: /opt/informix/etc/make_lvers: Böyle bir dosya ya da dizin
yok (english mean there arent directory and files)
Branding Files ...
Please read the information below.

***** Error occurred during installation. Please refer to log file
for details.
*****


And Press 3 stop installing

Error Files

rpmsdk.err
[package csdk-2.90.FC4R1-1 is intended for a x86_64 architecture]

rpmmsg.err
[package msgclient-2006.12-1 is intended for a x86_64 architecture]


What i should doing now?
I was download Linux for System x 86Series
Informix Downloads (Informix Client Software Development Kit (CSDK)
(Trial Version) for Linux (x86) RHEL 3, 64bit)
My operating system Linux Fedora Core 6 (FC-6-i386)
interested it this error?


Thankyou
Khan, Erdem KOC

Khan
Guest
 
Posts: n/a
#10: Jul 6 '07

re: Php Informix Connect


On 6 Temmuz, 09:35, Khan <erd...@gmail.comwrote:
Quote:
I was doing about step by step
>
1. php-5.2.3.tar.gz / PDO_INFORMIX-1.1.0.tgz / clientsdk.
2.90.FC4R1.LINUX.tar I was download everyone to the /tmp directory
>
2. #tar zxf PDO_INFORMIX-1.1.0.tgz and #tar zxf php-5.2.3.tar.gz by
root
>
3. groupadd informix and useradd -g informix -p xxxx -d /dev/null
informix But that give error :
[root@local tmp]# useradd -g informix -p xxxx -d /dev/null informix
useradd: warning: the home directory already exists.
Not copying any file from skel directory into it.
>
4. mkdir /opt/informix and chown informix.informix /opt/informix (by
root because dont permission informix)
>
5. cp clientsdk.2.90.FC4R1.LINUX.tar /opt/informix
>
6. tar -xvf clientsdk.2.90.FC4R1.LINUX.tar (by root because dont
permission informix)
>
7. ./installclientsdk and started Initializing InstallShield
Wizard........ and give this error
Verifying JVM.Exception in thread "main"
java.lang.NoClassDefFoundError: version
at gnu.java.lang.MainThread.run(libgcj.so.7rh)
Caused by: java.lang.ClassNotFoundException: version not found in
gnu.gcj.runtime.SystemClassLoader{urls=[file:./],
parent=gnu.gcj.runtime.ExtensionClassLoader{urls=[], parent=null}}
>
8. Installing steps
/opt/informix
with the following features:
Client
Messages
GLS
for a total size:
85,9 MB
and Installing IBM Informix Client-SDK. Please wait...
Installing SDK GLS Files by RPM
>
9. and give this error:
/bin/sh: /opt/informix/etc/make_lvers: Böyle bir dosya ya da dizin
yok (english mean there arent directory and files)
Branding Files ...
Please read the information below.
>
***** Error occurred during installation. Please refer to log file
for details.
*****
>
And Press 3 stop installing
>
Error Files
>
rpmsdk.err
[package csdk-2.90.FC4R1-1 is intended for a x86_64 architecture]
>
rpmmsg.err
[package msgclient-2006.12-1 is intended for a x86_64 architecture]
>
What i should doing now?
I was download Linux for System x 86Series
Informix Downloads (Informix Client Software Development Kit (CSDK)
(Trial Version) for Linux (x86) RHEL 3, 64bit)
My operating system Linux Fedora Core 6 (FC-6-i386)
interested it this error?
>
Thankyou
Khan, Erdem KOC
I think this problem 32 Bit/64 Bit so i setup Informix CSDK 32 bit and
configure Php and PDO informix
then make and make install

After

I was trying sample code
Give me this error

Fatal error: Uncaught exception 'PDOException' with message 'could not
find driver' in /home/ozcan/public_html/wurth/deneme.php:4 Stack
trace: #0 /home/ozcan/public_html/wurth/deneme.php(4): PDO-
Quote:
>__construct('informix:host=1...', 'informix', 'informix') #1 {main}
thrown in /home/ozcan/public_html/wurth/deneme.php on line 4

:(

Fernando Nunes
Guest
 
Posts: n/a
#11: Jul 6 '07

re: Php Informix Connect


Khan wrote:
Quote:
3. groupadd informix and useradd -g informix -p xxxx -d /dev/null
informix But that give error :
[root@local tmp]# useradd -g informix -p xxxx -d /dev/null informix
useradd: warning: the home directory already exists.
Not copying any file from skel directory into it.
Why give Informix /dev/null as it's HOME dir? I doubt you will be able to logon
with it...
Quote:
Wizard........ and give this error
Verifying JVM.Exception in thread "main"
java.lang.NoClassDefFoundError: version
at gnu.java.lang.MainThread.run(libgcj.so.7rh)
Caused by: java.lang.ClassNotFoundException: version not found in
gnu.gcj.runtime.SystemClassLoader{urls=[file:./],
parent=gnu.gcj.runtime.ExtensionClassLoader{urls=[], parent=null}}
Apparently you're using GNU Java. I'm not sure if it's supported.

Quote:
8. Installing steps
/opt/informix
with the following features:
Client
Messages
GLS
for a total size:
85,9 MB
and Installing IBM Informix Client-SDK. Please wait...
Installing SDK GLS Files by RPM
>
9. and give this error:
/bin/sh: /opt/informix/etc/make_lvers: Böyle bir dosya ya da dizin
yok (english mean there arent directory and files)
Branding Files ...
Please read the information below.
>
***** Error occurred during installation. Please refer to log file
for details.
*****
>
>
And Press 3 stop installing
>
Error Files
>
rpmsdk.err
[package csdk-2.90.FC4R1-1 is intended for a x86_64 architecture]
>
rpmmsg.err
[package msgclient-2006.12-1 is intended for a x86_64 architecture]
>
>
What i should doing now?
I was download Linux for System x 86Series
Informix Downloads (Informix Client Software Development Kit (CSDK)
(Trial Version) for Linux (x86) RHEL 3, 64bit)
My operating system Linux Fedora Core 6 (FC-6-i386)
interested it this error?
>
You downloaded a 64 bit version. Are you using a 64bit architecture? If not,
use 2.90 Uc4 instead of 2.90 Fc4.
That's probably your problem....

Regards,

--
Fernando Nunes
Portugal

http://informix-technology.blogspot.com
My email works... but I don't check it frequently...
Khan
Guest
 
Posts: n/a
#12: Jul 6 '07

re: Php Informix Connect


On 6 Temmuz, 12:49, Fernando Nunes <s...@domus.online.ptwrote:
Quote:
Khan wrote:
Quote:
3. groupadd informix and useradd -g informix -p xxxx -d /dev/null
informix But that give error :
[root@local tmp]# useradd -g informix -p xxxx -d /dev/null informix
useradd: warning: the home directory already exists.
Not copying any file from skel directory into it.
>
Why give Informix /dev/null as it's HOME dir? I doubt you will be able tologon
with it...
>
Quote:
Wizard........ and give this error
Verifying JVM.Exception in thread "main"
java.lang.NoClassDefFoundError: version
at gnu.java.lang.MainThread.run(libgcj.so.7rh)
Caused by: java.lang.ClassNotFoundException: version not found in
gnu.gcj.runtime.SystemClassLoader{urls=[file:./],
parent=gnu.gcj.runtime.ExtensionClassLoader{urls=[], parent=null}}
>
Apparently you're using GNU Java. I'm not sure if it's supported.
>
>
>
>
>
Quote:
8. Installing steps
/opt/informix
with the following features:
Client
Messages
GLS
for a total size:
85,9 MB
and Installing IBM Informix Client-SDK. Please wait...
Installing SDK GLS Files by RPM
>
Quote:
9. and give this error:
/bin/sh: /opt/informix/etc/make_lvers: Böyle bir dosya ya da dizin
yok (english mean there arent directory and files)
Branding Files ...
Please read the information below.
>
Quote:
***** Error occurred during installation. Please refer to log file
for details.
*****
>
Quote:
And Press 3 stop installing
>
Quote:
Error Files
>
Quote:
rpmsdk.err
[package csdk-2.90.FC4R1-1 is intended for a x86_64 architecture]
>
Quote:
rpmmsg.err
[package msgclient-2006.12-1 is intended for a x86_64 architecture]
>
Quote:
What i should doing now?
I was download Linux for System x 86Series
Informix Downloads (Informix Client Software Development Kit (CSDK)
(Trial Version) for Linux (x86) RHEL 3, 64bit)
My operating system Linux Fedora Core 6 (FC-6-i386)
interested it this error?
>
You downloaded a 64 bit version. Are you using a 64bit architecture? If not,
use 2.90 Uc4 instead of 2.90 Fc4.
That's probably your problem....
>
Regards,
>
--
Fernando Nunes
Portugal
>
http://informix-technology.blogspot.com
My email works... but I don't check it frequently...- Al nt y gizle -
>
- Al nt y göster -
I was passed this step download and setup Informix CSDK 32bit 2.90 Uc4
and install, /opt/informix directory. It's success.

I have been configure php then make and make install
copy pdo.so and pdo_informix.so /usr/lib/php/modules directory
and restart apache

enter php -m command
~~~~~~~~~~~~~~~~~~~~~
PDO
pdo_informix
pdo_sqlite


But if i try this code on my intranet server
<?php
foreach(PDO::getAvailableDrivers() as $driver)
{
echo $driver.'<br />';
}
?>
return :
mysql
sqlite

Why it's not unsuccesful
Thank a lot for your helpful

Khan
Guest
 
Posts: n/a
#13: Jul 6 '07

re: Php Informix Connect


On 6 Temmuz, 16:13, Aleksander Kamenik <aleksan...@krediidiinfo.ee>
wrote:
Quote:
Khan wrote:
Quote:
On 6 Temmuz, 12:49, Fernando Nunes <s...@domus.online.ptwrote:
Quote:
Khan wrote:
>3. groupaddinformixand useradd -ginformix-p xxxx -d /dev/null
>>informixBut that give error :
> [root@local tmp]# useradd -ginformix-p xxxx -d /dev/nullinformix
> useradd: warning: the home directory already exists.
> Not copying any file from skel directory into it.
Why giveInformix/dev/null as it's HOME dir? I doubt you will be able to logon
with it...
>
Quote:
Quote:
>Wizard........ and give this error
> Verifying JVM.Exception in thread "main"
>java.lang.NoClassDefFoundError: version
> at gnu.java.lang.MainThread.run(libgcj.so.7rh)
> Caused by: java.lang.ClassNotFoundException: version not found in
>gnu.gcj.runtime.SystemClassLoader{urls=[file:./],
> parent=gnu.gcj.runtime.ExtensionClassLoader{urls=[], parent=null}}
Apparently you're using GNU Java. I'm not sure if it's supported.
>
Quote:
Quote:
>8. Installing steps
> /opt/informix
> with the following features:
> Client
> Messages
> GLS
> for a total size:
> 85,9 MB
>and Installing IBMInformixClient-SDK. Please wait...
>Installing SDK GLS Files by RPM
>9. and give this error:
> /bin/sh: /opt/informix/etc/make_lvers: Böyle bir dosya ya da dizin
>yok (english mean there arent directory and files)
> Branding Files ...
> Please read the information below.
> ***** Error occurred during installation. Please refer to log file
>for details.
> *****
>And Press 3 stop installing
>Error Files
>rpmsdk.err
>[package csdk-2.90.FC4R1-1 is intended for a x86_64 architecture]
>rpmmsg.err
>[package msgclient-2006.12-1 is intended for a x86_64 architecture]
>What i should doing now?
>I was download Linux for System x 86Series
>>InformixDownloads (InformixClient Software Development Kit (CSDK)
>(Trial Version) for Linux (x86) RHEL 3, 64bit)
>My operating system Linux Fedora Core 6 (FC-6-i386)
>interested it this error?
You downloaded a 64 bit version. Are you using a 64bit architecture? If not,
use 2.90 Uc4 instead of 2.90 Fc4.
That's probably your problem....
>
Quote:
Quote:
Regards,
>
Quote:
Quote:
--
Fernando Nunes
Portugal
>
Quote:
Quote:
>http://informix-technology.blogspot.com
My email works... but I don't check it frequently...- Al nt y gizle -
>
Quote:
Quote:
- Al nt y göster -
>
Quote:
I was passed this step download and setupInformixCSDK 32bit 2.90 Uc4
and install, /opt/informixdirectory. It's success.
>
Quote:
I have been configure php then make and make install
copypdo.so and pdo_informix.so /usr/lib/php/modules directory
and restart apache
>
Quote:
enter php -m command
~~~~~~~~~~~~~~~~~~~~~
PDO
pdo_informix
pdo_sqlite
>
Quote:
But if i try this code on my intranet server
<?php
foreach(PDO::getAvailableDrivers() as $driver)
{
echo $driver.'<br />';
}
?>
return :
mysql
sqlite
>
Quote:
Why it's not unsuccesful
Thank a lot for your helpful
>
Create a phpinfo.php file with the following contents:
<?php
phpinfo();
?>
>
Using this you'll see some more detail.
>
Next, to check that pdo_mysql is installed you don't have to restart
apache, php -m will show it right away.
>
Execute:
>
php fileinfo.php
>
from the commandline, it will give you errors if it has problems loading
pdo_informix.
>
If it doesn't and pdo_informix is not mentioned in the output of
phpinfo(), then you haven't configured php to use it. Most probably you
haven't added
>
extension=pdo_infomix.so
>
to your effective php.ini.
>
HTH,
>
--
Aleksander Kamenik
system administrator
+372 6659 649
aleksan...@krediidiinfo.ee
>
Krediidiinfo AShttp://www.krediidiinfo.ee/- Al nt y gizle -
>
- Al nt y göster -
Yes i try that (php info.php) and give me some information about for
informix
Forexample:
INFORMIXDIR =/opt/informix
_SERVER["INFORMIXDIR"] =/opt/informix
_SERVER["PATH"] =/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/
sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin:/opt/
informix/bin:/opt/informix/bin

php -m result
PDO
pdo_informix
pdo_sqlite

I thinking informix has been installed. But Apache dont sense ? could
it be imposseble?
# service httpd restart
httpd stopped: [ OK ]
httpd started: [ OK ]

I try retery it's not success.
http://localhost/info.php result
PDO drivers mysql, sqlite

I havent got configure apache

Khan
Guest
 
Posts: n/a
#14: Jul 6 '07

re: Php Informix Connect


On 6 Temmuz, 16:46, Khan <erd...@gmail.comwrote:
Quote:
On 6 Temmuz, 16:13, Aleksander Kamenik <aleksan...@krediidiinfo.ee>
wrote:
>
>
>
>
>
Quote:
Khan wrote:
Quote:
On 6 Temmuz, 12:49, Fernando Nunes <s...@domus.online.ptwrote:
>Khan wrote:
>>3. groupaddinformixand useradd -ginformix-p xxxx -d /dev/null
>>>informixBut that give error :
>> [root@local tmp]# useradd -ginformix-p xxxx -d /dev/nullinformix
>> useradd: warning: the home directory already exists.
>> Not copying any file from skel directory into it.
>Why giveInformix/dev/null as it's HOME dir? I doubt you will be ableto logon
>with it...
>
Quote:
Quote:
>>Wizard........ and give this error
>> Verifying JVM.Exception in thread "main"
>>java.lang.NoClassDefFoundError: version
>> at gnu.java.lang.MainThread.run(libgcj.so.7rh)
>> Caused by: java.lang.ClassNotFoundException: version not found in
>>gnu.gcj.runtime.SystemClassLoader{urls=[file:./],
>> parent=gnu.gcj.runtime.ExtensionClassLoader{urls=[], parent=null}}
>Apparently you're using GNU Java. I'm not sure if it's supported.
>
Quote:
Quote:
>>8. Installing steps
>> /opt/informix
>> with the following features:
>> Client
>> Messages
>> GLS
>> for a total size:
>> 85,9 MB
>>and Installing IBMInformixClient-SDK. Please wait...
>>Installing SDK GLS Files by RPM
>>9. and give this error:
>> /bin/sh: /opt/informix/etc/make_lvers: Böyle bir dosya ya da dizin
>>yok (english mean there arent directory and files)
>> Branding Files ...
>> Please read the information below.
>> ***** Error occurred during installation. Please refer to log file
>>for details.
>> *****
>>And Press 3 stop installing
>>Error Files
>>rpmsdk.err
>>[package csdk-2.90.FC4R1-1 is intended for a x86_64 architecture]
>>rpmmsg.err
>>[package msgclient-2006.12-1 is intended for a x86_64 architecture]
>>What i should doing now?
>>I was download Linux for System x 86Series
>>>InformixDownloads (InformixClient Software Development Kit (CSDK)
>>(Trial Version) for Linux (x86) RHEL 3, 64bit)
>>My operating system Linux Fedora Core 6 (FC-6-i386)
>>interested it this error?
>You downloaded a 64 bit version. Are you using a 64bit architecture?If not,
>use 2.90 Uc4 instead of 2.90 Fc4.
>That's probably your problem....
>
Quote:
Quote:
>Regards,
>
Quote:
Quote:
>--
>Fernando Nunes
>Portugal
>
Quote:
Quote:
>>http://informix-technology.blogspot.com
>My email works... but I don't check it frequently...- Al nt y gizle-
>
Quote:
Quote:
>- Al nt y göster -
>
Quote:
Quote:
I was passed this step download and setupInformixCSDK 32bit 2.90 Uc4
and install, /opt/informixdirectory. It's success.
>
Quote:
Quote:
I have been configure php then make and make install
copypdo.so and pdo_informix.so /usr/lib/php/modules directory
and restart apache
>
Quote:
Quote:
enter php -m command
~~~~~~~~~~~~~~~~~~~~~
>PDO
pdo_informix
pdo_sqlite
>
Quote:
Quote:
But if i try this code on my intranet server
<?php
foreach(PDO::getAvailableDrivers() as $driver)
{
echo $driver.'<br />';
}
?>
return :
mysql
sqlite
>
Quote:
Quote:
Why it's not unsuccesful
Thank a lot for your helpful
>
Quote:
Create a phpinfo.php file with the following contents:
<?php
phpinfo();
?>
>
Quote:
Using this you'll see some more detail.
>
Quote:
Next, to check that pdo_mysql is installed you don't have to restart
apache, php -m will show it right away.
>
Quote:
Execute:
>
Quote:
php fileinfo.php
>
Quote:
from the commandline, it will give you errors if it has problems loading
pdo_informix.
>
Quote:
If it doesn't and pdo_informix is not mentioned in the output of
phpinfo(), then you haven't configured php to use it. Most probably you
haven't added
>
Quote:
extension=pdo_infomix.so
>
Quote:
to your effective php.ini.
>
Quote:
HTH,
>
Quote:
--
Aleksander Kamenik
system administrator
+372 6659 649
aleksan...@krediidiinfo.ee
>
Quote:
Krediidiinfo AShttp://www.krediidiinfo.ee/-Al nt y gizle -
>
Quote:
- Al nt y göster -
>
Yes i try that (php info.php) and give me some information about for
informix
Forexample:
INFORMIXDIR =/opt/informix
_SERVER["INFORMIXDIR"] =/opt/informix
_SERVER["PATH"] =/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/
sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin:/opt/
informix/bin:/opt/informix/bin
>
php -m result
PDO
pdo_informix
pdo_sqlite
>
I thinking informix has been installed. But Apache dont sense ? could
it be imposseble?
# service httpd restart
httpd stopped: [ OK ]
httpd started: [ OK ]
>
I try retery it's not success.http://localhost/info.phpresult
PDO drivers mysql, sqlite
>
I havent got configure apache- Al nt y gizle -
>
- Al nt y göster -
Yes it's true
Im trying this code on ssh command line (example:#php test.php)
$db = new PDO("informix:host=192.20.20.100; service=1536;
database=data; server=mspa-server_se_tcp; protocol=onsoctcp;",
"informix", "informix");
$stmt = $db->query("select * from art");
$res = $stmt->fetch( PDO::FETCH_BOTH );
$rows = $res[0];
echo "Table contents: $rows.\n";

that give me this error code:
Fatal error: Uncaught exception 'PDOException' with message
'SQLSTATE=01S00, SQLDriverConnect: -11005 [Informix][Informix ODBC
Driver]Invalid connection string attribute.' in /home/ozcan/
public_html/wurth/test.php:10
Stack trace:
#0 /home/ozcan/public_html/wurth/test.php(10): PDO-
Quote:
>__construct('informix:host=1...', 'informix', 'informix')
#1 {main}
thrown in /home/ozcan/public_html/wurth/test.php on line 10

It's true? Can i connect ?
If i restart this server, pdo_informix run by apache?

Please help me :)

VG
Guest
 
Posts: n/a
#15: Jul 6 '07

re: Php Informix Connect


On Jul 6, 9:03 am, Khan <erd...@gmail.comwrote:
Quote:
On 6 Temmuz, 16:46, Khan <erd...@gmail.comwrote:
>
>
>
>
>
Quote:
On 6 Temmuz, 16:13, Aleksander Kamenik <aleksan...@krediidiinfo.ee>
wrote:
>
Quote:
Quote:
Khan wrote:
On 6 Temmuz, 12:49, Fernando Nunes <s...@domus.online.ptwrote:
Khan wrote:
>3. groupaddinformixand useradd -ginformix-p xxxx -d /dev/null
>>informixBut that give error :
> [root@local tmp]# useradd -ginformix-p xxxx -d /dev/nullinformix
> useradd: warning: the home directory already exists.
> Not copying any file from skel directory into it.
Why giveInformix/dev/null as it's HOME dir? I doubt you will be able to logon
with it...
>
Quote:
Quote:
>Wizard........ and give this error
> Verifying JVM.Exception in thread "main"
>java.lang.NoClassDefFoundError: version
> at gnu.java.lang.MainThread.run(libgcj.so.7rh)
> Caused by: java.lang.ClassNotFoundException: version not found in
>gnu.gcj.runtime.SystemClassLoader{urls=[file:./],
> parent=gnu.gcj.runtime.ExtensionClassLoader{urls=[], parent=null}}
Apparently you're using GNU Java. I'm not sure if it's supported.
>
Quote:
Quote:
>8. Installing steps
> /opt/informix
> with the following features:
> Client
> Messages
> GLS
> for a total size:
> 85,9 MB
>and Installing IBMInformixClient-SDK. Please wait...
>Installing SDK GLS Files by RPM
>9. and give this error:
> /bin/sh: /opt/informix/etc/make_lvers: Böyle bir dosya ya da dizin
>yok (english mean there arent directory and files)
> Branding Files ...
> Please read the information below.
> ***** Error occurred during installation. Please refer to log file
>for details.
> *****
>And Press 3 stop installing
>Error Files
>rpmsdk.err
>[package csdk-2.90.FC4R1-1 is intended for a x86_64 architecture]
>rpmmsg.err
>[package msgclient-2006.12-1 is intended for a x86_64 architecture]
>What i should doing now?
>I was download Linux for System x 86Series
>>InformixDownloads (InformixClient Software Development Kit (CSDK)
>(Trial Version) for Linux (x86) RHEL 3, 64bit)
>My operating system Linux Fedora Core 6 (FC-6-i386)
>interested it this error?
You downloaded a 64 bit version. Are you using a 64bit architecture? If not,
use 2.90 Uc4 instead of 2.90 Fc4.
That's probably your problem....
>
Quote:
Quote:
Regards,
>
Quote:
Quote:
--
Fernando Nunes
Portugal
>
Quote:
Quote:
>http://informix-technology.blogspot.com
My email works... but I don't check it frequently...- Al nt y gizle -
>
Quote:
Quote:
- Al nt y göster -
>
Quote:
Quote:
I was passed this step download and setupInformixCSDK 32bit 2.90 Uc4
and install, /opt/informixdirectory. It's success.
>
Quote:
Quote:
I have been configure php then make and make install
copypdo.so and pdo_informix.so /usr/lib/php/modules directory
and restart apache
>
Quote:
Quote:
enter php -m command
~~~~~~~~~~~~~~~~~~~~~
PDO
pdo_informix
pdo_sqlite
>
Quote:
Quote:
But if i try this code on my intranet server
<?php
foreach(PDO::getAvailableDrivers() as $driver)
{
echo $driver.'<br />';
}
?>
return :
mysql
sqlite
>
Quote:
Quote:
Why it's not unsuccesful
Thank a lot for your helpful
>
Quote:
Quote:
Create a phpinfo.php file with the following contents:
<?php
phpinfo();
?>
>
Quote:
Quote:
Using this you'll see some more detail.
>
Quote:
Quote:
Next, to check that pdo_mysql is installed you don't have to restart
apache, php -m will show it right away.
>
Quote:
Quote:
Execute:
>
Quote:
Quote:
php fileinfo.php
>
Quote:
Quote:
from the commandline, it will give you errors if it has problems loading
pdo_informix.
>
Quote:
Quote:
If it doesn't and pdo_informix is not mentioned in the output of
phpinfo(), then you haven't configured php to use it. Most probably you
haven't added
>
Quote:
Quote:
extension=pdo_infomix.so
>
Quote:
Quote:
to your effective php.ini.
>
Quote:
Quote:
HTH,
>
Quote:
Quote:
--
Aleksander Kamenik
system administrator
+372 6659 649
aleksan...@krediidiinfo.ee
>
Quote:
Quote:
Krediidiinfo AShttp://www.krediidiinfo.ee/-Alnt y gizle -
>
Quote:
Quote:
- Al nt y göster -
>
Quote:
Yes i try that (php info.php) and give me some information about for
informix
Forexample:
INFORMIXDIR =/opt/informix
_SERVER["INFORMIXDIR"] =/opt/informix
_SERVER["PATH"] =/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/
sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin:/opt/
informix/bin:/opt/informix/bin
>
Quote:
php -m result
PDO
pdo_informix
pdo_sqlite
>
Quote:
I thinking informix has been installed. But Apache dont sense ? could
it be imposseble?
# service httpd restart
httpd stopped: [ OK ]
httpd started: [ OK ]
>
Quote:
I try retery it's not success.http://localhost/info.phpresult
PDO drivers mysql, sqlite
>
Quote:
I havent got configure apache- Al nt y gizle -
>
Quote:
- Al nt y göster -
>
Yes it's true
Im trying this code on ssh command line (example:#php test.php)
$db = new PDO("informix:host=192.20.20.100; service=1536;
database=data; server=mspa-server_se_tcp; protocol=onsoctcp;",
"informix", "informix");
$stmt = $db->query("select * from art");
$res = $stmt->fetch( PDO::FETCH_BOTH );
$rows = $res[0];
echo "Table contents: $rows.\n";
>
that give me this error code:
Fatal error: Uncaught exception 'PDOException' with message
'SQLSTATE=01S00, SQLDriverConnect: -11005 [Informix][Informix ODBC
Driver]Invalid connection string attribute.' in /home/ozcan/
public_html/wurth/test.php:10
Stack trace:
#0 /home/ozcan/public_html/wurth/test.php(10): PDO->__construct('informix:host=1...', 'informix', 'informix')
>
#1 {main}
thrown in /home/ozcan/public_html/wurth/test.php on line 10
>
It's true? Can i connect ?
If i restart this server, pdo_informix run by apache?
>
Please help me :)- Hide quoted text -
>
- Show quoted text -
Need some more information - I assume you are trying to connect to
Standard Engine, correct?

Also, the SQL Code is -11005. I looked it up and it states:

For SQLDriverConnect(), the function returned SQL_SUCCESS_WITH_INFO,
which means that the function completed successfully, and that a
nonfatal error occurred. The nonfatal error occurred because the
connection string contains an invalid attribute keyword, but IBM
Informix CLI connected to the data source anyway. For more
information, call SQLError().

Was the connection successful at all? Put a dummy try catch block
around the connection and let us know what happens.

Please give us details on the server version you are trying to connect
to and we will take a look.

Thanks,
VG

Closed Thread