Re: Php Informix Connect
A user trying to get PHP talking to a remote Informix server via PDO_INFORMIX on Fedora Core 6 hit a chain of problems. The CSDK install failed with 'make_lvers not found' and RPM errors saying the packages were for x86_64 — Fernando Nunes spotted he'd downloaded the 64-bit FC4 build and advised the 32-bit UC4 CSDK, which installed fine. Next, pdo_informix showed in 'php -m' but not in the Apache phpinfo() driver list; advice was to check phpinfo/effective php.ini and add extension=pdo_informix.so. A final CLI test then failed with 'SQLDriverConnect: -11005 ... Invalid connection string attribute'. The thread ends with questions about the connection string (SE server) and no recorded resolution.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
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? > 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 ==================
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
On 6 Temmuz, 09:35, Khan <erd...@gmail.com> wrote:
> 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-
>__construct('informix:host=1...', 'informix', 'informix') #1 {main}
thrown in /home/ozcan/public_html/wurth/deneme.php on line 4
:(
Khan wrote: > 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... > 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. > 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...
On 6 Temmuz, 12:49, Fernando Nunes <s...@domus.online.pt> wrote: > Khan wrote: > > 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... > > > 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. > > > > > > > 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...- 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 wrote: > On 6 Temmuz, 12:49, Fernando Nunes <s...@domus.online.pt> wrote: >> Khan wrote: >>> 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... >> >>> 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. >> >> >> >> >> >>> 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...- 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 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 aleksander@krediidiinfo.ee Krediidiinfo AS http://www.krediidiinfo.ee/
On 6 Temmuz, 16:13, Aleksander Kamenik <aleksan...@krediidiinfo.ee> wrote: > Khan wrote: > > On 6 Temmuz, 12:49, Fernando Nunes <s...@domus.online.pt> wrote: > >> 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... > > >>> 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. > > >>> 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.... > > >> 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 setupInformixCSDK 32bit 2.90 Uc4 > > and install, /opt/informixdirectory. It's success. > > > I have been configure php then make and make install > > copypdo.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 > > 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
On 6 Temmuz, 16:46, Khan <erd...@gmail.com> wrote:
> On 6 Temmuz, 16:13, Aleksander Kamenik <aleksan...@krediidiinfo.ee>
> wrote:
>
>
>
>
>
> > Khan wrote:
> > > On 6 Temmuz, 12:49, Fernando Nunes <s...@domus.online.pt> wrote:
> > >> 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...
>
> > >>> 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.
>
> > >>> 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....
>
> > >> 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 setupInformixCSDK 32bit 2.90 Uc4
> > > and install, /opt/informixdirectory. It's success.
>
> > > I have been configure php then make and make install
> > > copypdo.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
>
> > 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.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 ODBCDriver]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 :)
On Jul 6, 9:03 am, Khan <erd...@gmail.com> wrote:
> On 6 Temmuz, 16:46, Khan <erd...@gmail.com> wrote:
>
>
>
>
>
> > On 6 Temmuz, 16:13, Aleksander Kamenik <aleksan...@krediidiinfo.ee>
> > wrote:
>
> > > Khan wrote:
> > > > On 6 Temmuz, 12:49, Fernando Nunes <s...@domus.online.pt> wrote:
> > > >> 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...
>
> > > >>> 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.
>
> > > >>> 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....
>
> > > >> 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 setupInformixCSDK 32bit 2.90 Uc4
> > > > and install, /opt/informixdirectory. It's success.
>
> > > > I have been configure php then make and make install
> > > > copypdo.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
>
> > > 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/-Alnt 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.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->__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