I'm trying to set things up so that PHP on a Linux box I have access to will be able to make calls to a remote Informix database.
I don't have much experience installing software on Linux. The box isn't really mine. It's a box at my day-job that I've been given SysAdmin rights to. It's one Linux box among a great many Windows boxes. We've got one educational app running on it so far.
So, I did a lot of googling and it appeared to me that I needed to install the Informix SDK on the box. I did this. I then recompiled Apache and PHP... so that PHP now has its Informix module installed.
At this point, I'm now tackling altering the /etc/hosts, /etc/services, and $INFORMIXDIR/etc/sqlhosts files to match what I THINK they should be set to... based on some parameters given to me by the people here who connect to that Informix box over Windows.
One thing that disturbs me is that I saw some info suggesting I had to alter an /opt/informix/onconfig file. I do not have such a file out there.
Do I have to install the actual Informix Database Server on this box, even if I have no intention of ever using / needing such a database on this box... and I just want to connect to a REMOTE Informix database?
I guess I'll start off with that as my question and add more as they come up. Trying to do this all between my usual tasks at my day-job.
ACD_DB has been set up properly in the /etc/hosts file
xinetd has been cycled, as has Apache
script (with correct username and password removed here for security reasons -- grin! ):
if (!($db = ifx_connect("odba_views@online","<username>", "<password>")))
print("Failed to connect to database!<BR>\n");
Script fails with:
Warning: ifx_connect : E [SQLSTATE=IX 000 SQLCODE=-25596] in /usr/local/apache/htdocs/abandon/work.php on line 13
Failed to connect to database!
I can telnet to the Hostname and port. I got the port number from a Windows-based doc that was sent to me by someone who is somewhat familiar with the Informix side of things (in a more executive than technical role).