Web Server connecting to Informix Server

[Wilson, John]

I am running an OLTP system with Informix 7.3 IDS on HPUX. We are considering writing some web interfaces to connect to the database. At first we mirrored the database tables to a web server so that no one was ever touching live data. This was relatively easy, just do a nightly export/import to the web server.

However, we now wish to create some "updating" web pages that will connect back to the server. On the web server I am using PHP/MySQL/Apache for web development with the Slackware Linux v 9.0 (Linux 2.4.7) distrobution.

I have tried multiple times to install the Linux Client-SDK hoping that somehow I could make a ODBC connection back to the Informix server. I have not yet been successful. I found a company that makes an Informix ODBC driver. I was unsucessful at getting it licensed for a 30-day trial. I tried compiling informix libraries into PHP, but ESQL doesn't seem to be compatible with gcc.

What is the best way to connect the Linux web server to the HPUX Informix server? Can anyone point me to documentation on how to do this? I would RTM if I could find one. Any tips, links, articles, etc would be appreciated.


John Wilson
Administrative Systems Specialist
Troy School District Information Systems


sending to informix-list

[Wilson, John]

I am running an OLTP system with Informix 7.3 IDS on HPUX. We are considering writing some web interfaces to connect to the database. At first we mirrored the database tables to a web server so that no one was ever touching live data. This was relatively easy, just do a nightly export/import to the web server.

However, we now wish to create some "updating" web pages that will connect back to the server. On the web server I am using PHP/MySQL/Apache for web development with the Slackware Linux v 9.0 (Linux 2.4.7) distrobution.

I have tried multiple times to install the Linux Client-SDK hoping that somehow I could make a ODBC connection back to the Informix server. I have not yet been successful. I found a company that makes an Informix ODBC driver. I was unsucessful at getting it licensed for a 30-day trial. I tried compiling informix libraries into PHP, but ESQL doesn't seem to be compatible with gcc.

What is the best way to connect the Linux web server to the HPUX Informix server? Can anyone point me to documentation on how to do this? I would RTM if I could find one. Any tips, links, articles, etc would be appreciated.


John Wilson
Administrative Systems Specialist
Troy School District Information Systems


sending to informix-list
sending to informix-list

[Paul Watson]

This should work fine, do the esql demo programs compile OK, if they
do then the following scripts should give you a fully working
apache/ssl/php installation, or at least it does on our Sun servers

#! /bin/ksh

APACHEDIR=apache_1.3.27
MODSSLDIR=mod_ssl-2.8.14-1.3.27
OPENSSLDIR=openssl-0.9.7b
PHPHOME=/usr/local/php
WEBHOME=/usr/local/apache

cd ${APACHDIR}
../configure --prefix=$WEBHOME --enable-module=so
if [ $? != 0 ]
then
echo "Whoops: Apache"
exit
fi

cd ../${OPENSSLDIR}
sh config -fPIC
if [ $? != 0 ]
then
echo "Whoops: openssl"
exit
fi
make
if [ $? != 0 ]
then
echo "Whoops: openssl make"
exit
fi

cd ../${MODSSLDIR}
../configure \
--with-apache=../${APACHEDIR} \
--with-crt=${WEBHOME}/conf/ssl.crt/server.crt \
--with-key=${WEBHOME}/conf/ssl.key/server.key

cd ../${APACHEDIR}
SSL_BASE=../${OPENSSLDIR} \
../configure \
--enable-module=ssl \
--enable-module=so \
--prefix=${WEBHOME}

make
make install

cd ../${PHPDIR}

INCL=/usr/local/include ./configure \
--enable-track-vars \
--with-informix \
--with-openssl=shared,/usr/local/ssl \
--with-imap \
--with-imap-ssl=shared,/usr/local/ssl \
--enable-safe-mode \
--prefix=${PHPHOME} \
--with-apxs=${WEBHOME}/bin/apxs \
--enable-trans-sid \
--enable-inline-optimization

make
make install



"Wilson, John" wrote:

>
> I am running an OLTP system with Informix 7.3 IDS on HPUX. We are considering writing some web interfaces to connect to the database. At first we mirrored the database tables to a web server so that no one was ever touching live data. This was relatively easy, just do a nightly export/import to the web server.
>
> However, we now wish to create some "updating" web pages that will connect back to the server. On the web server I am using PHP/MySQL/Apache for web development with the Slackware Linux v 9.0 (Linux 2.4.7) distrobution.
>
> I have tried multiple times to install the Linux Client-SDK hoping that somehow I could make a ODBC connection back to the Informix server. I have not yet been successful. I found a company that makes an Informix ODBC driver. I was unsucessful at getting it licensed for a 30-day trial. I tried compiling informix libraries into PHP, but ESQL doesn't seem to be compatible with gcc.
>
> What is the best way to connect the Linux web server to the HPUX Informix server? Can anyone point me to documentation on how to do this? I would RTM if I could find one. Any tips, links, articles, etc would be appreciated.
>
> John Wilson
> Administrative Systems Specialist
> Troy School District Information Systems
>
> sending to informix-list

--
Paul Watson #
Oninit Ltd # Growing old is mandatory
Tel: +44 1436 672201 # Growing up is optional
Fax: +44 1436 678693 #
Mob: +44 7818 003457 #
[url]www.oninit.com[/url] #

[preetinder dhaliwal]

One easy way is to use java to connect ( java driver for informix is
free - ifxjdbc.jar ).

If you want, you can get the relevant information here -
[url]http://www-3.ibm.com/software/data/informix/pubs/library/[/url]

Rgds
Preetinder

Wilson, John wrote:

>I am running an OLTP system with Informix 7.3 IDS on HPUX. We are considering writing some web interfaces to connect to the database. At first we mirrored the database tables to a web server so that no one was ever touching live data. This was relatively easy, just do a nightly export/import to the web server.
>
>However, we now wish to create some "updating" web pages that will connect back to the server. On the web server I am using PHP/MySQL/Apache for web development with the Slackware Linux v 9.0 (Linux 2.4.7) distrobution.
>
>I have tried multiple times to install the Linux Client-SDK hoping that somehow I could make a ODBC connection back to the Informix server. I have not yet been successful. I found a company that makes an Informix ODBC driver. I was unsucessful at getting it licensed for a 30-day trial. I tried compiling informix libraries into PHP, but ESQL doesn't seem to be compatible with gcc.
>
>What is the best way to connect the Linux web server to the HPUX Informix server? Can anyone point me to documentation on how to do this? I would RTM if I could find one. Any tips, links, articles, etc would be appreciated.
>
>
>John Wilson
>Administrative Systems Specialist
>Troy School District Information Systems
>
>
>sending to informix-list
>
>

sending to informix-list

[Simmons, Keith]

John

Assuming you have IDS running on your web server you don't need anything
else to communicate between the two engines apart from setting up the
sqlhosts, /etc/services and .rhosts (/etc/hosts.equiv) files. You can then
update any tables from either engine. (Both databases need to have the same
logging state).
To make names easier you might want to use synonyms or views.

Keith

-> -----Original Message-----
-> From: Wilson, John [mailto:JWilson3@troy.k12.mi.us]
-> Sent: Wednesday, September 03, 2003 5:31 PM
-> To: [email]informix-list@iiug.org[/email]
-> Subject: Web Server connecting to Informix Server
->
->
->
-> I am running an OLTP system with Informix 7.3 IDS on HPUX.
-> We are considering writing some web interfaces to connect to
-> the database. At first we mirrored the database tables to a
-> web server so that no one was ever touching live data. This
-> was relatively easy, just do a nightly export/import to the
-> web server.
->
-> However, we now wish to create some "updating" web pages
-> that will connect back to the server. On the web server I
-> am using PHP/MySQL/Apache for web development with the
-> Slackware Linux v 9.0 (Linux 2.4.7) distrobution.
->
-> I have tried multiple times to install the Linux Client-SDK
-> hoping that somehow I could make a ODBC connection back to
-> the Informix server. I have not yet been successful. I
-> found a company that makes an Informix ODBC driver. I was
-> unsucessful at getting it licensed for a 30-day trial. I
-> tried compiling informix libraries into PHP, but ESQL
-> doesn't seem to be compatible with gcc.
->
-> What is the best way to connect the Linux web server to the
-> HPUX Informix server? Can anyone point me to documentation
-> on how to do this? I would RTM if I could find one. Any
-> tips, links, articles, etc would be appreciated.
->
->
-> John Wilson
-> Administrative Systems Specialist
-> Troy School District Information Systems
->
->
-> sending to informix-list
->

************************************************** ********************************
This message is sent in strict confidence for the addressee only. It may
contain legally privileged information. The contents are not to be disclosed
to anyone other than the addressee. Unauthorised recipients are requested
to preserve this confidentiality and to advise the sender immediately of any
error in transmission.
This footnote also confirms that this email message has been swept for the
presence of computer viruses, however we cannot guarantee that this message
is free from such problems.
************************************************** ********************************
sending to informix-list