I am having a problem using PHP with Ingres. Specifically connecting to an Ingres database using ingres_connect.
I am hoping that somebody might be able to help me with this problem.
I have searched the web and found several references to the problem I am having but never any answers/solutions.
I would greatly appreciate any help with this problem.
Below is specific information on my setup and the specific problem/error messages I am getting.
I am running into a problem running Apache 2.0.46 and PHP 4.3.2 with Ingres 2.5. I configured PHP as follows:
./configure --with-apxs2=/usr/freeware/apache2/sbin/apxs
--with-ingres=/usr/people/ingres
--with-pdflib=/usr/freeware/lib32
--with-pgsql=/usr/freeware/pgsql
I am able to use php with postgresql without any problems. I am also able to connect to the ingres database on the SGI machine using command line sql on the SGI box and I can also connect to the ingres database on the SGI machine using Visual DBA from a PC machine.
These are the messages I am getting when I try to connect to the ingres database using:
line 36 = $link = ingres_connect("$host" . "::" . "$database", "$user", "$password")
line 37 = or trigger_error("Could not connect to Ingres database '" . $database . "'",E_USER_ERROR);
Warning: ingres_connect(): Ingres II: Server or API error : Unable to authenticate client's user ID. in /usr/freeware/apache2/htdocs/ing/ingpgtableinfo.php
on line 36
Warning: ingres_connect(): Ingres II: SQLSTATE : 08004 in /usr/freeware/apache2/htdocs/ing/ingpgtableinfo.php on line 36
Warning: ingres_connect(): Ingres II: Unable to connect to database (192.168.1.103::arsr4) in /usr/freeware/apache2/htdocs/ing/ingpgtableinfo.php on line
36
Fatal error: Could not connect to Ingres database 'arsr4' in /usr/freeware/apache2/htdocs/ing/ingpgtableinfo.php on line 37
