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 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 # www.oninit.com #