Page 1 of 1

PHP and Oracle

Posted: Tue Jan 11, 2005 12:00 pm
by fangorn
I'm running php4 and IIS5 with Oracle 9 on Win2k server.

PHP is not able to login to Oracle when SQLNET.AUTHENTICATION_SERVICES= (NTS). I've read that this must be set to NONE for PHP to work and I've verified that this is the case. But my customer has a corporate requirement that the setting be NTS or they have to hardcode passwords in other scripts they run and that's against their policy.

My first question would be does PHP just not support NTS authentication? But then I looked at 2 machines that I'm running that have Apache and PHP4 and the Oracle login works. Is this an IIS contention? My customer is pointing their finger at PHP as the issue.

Does anyone have experience with this?

Posted: Tue Jan 11, 2005 3:22 pm
by hedge
I think you'd have to run the IIS server as a user that has domain rights, the default install creates a local machine user that iis runs as.

Posted: Wed Jan 12, 2005 7:28 am
by fangorn
I'm a programmer, not IT, but does that just mean that I need to give the IUSR and IWAM accounts domain rights? Or literally give the web server new domain level accounts and not use IUSR and IWAM altogether?

Posted: Wed Jan 12, 2005 8:34 am
by hedge
I need to preface this by saying that I've never tried to run it this way, this is just my guess but it seems to make sence to me.

You'd have to run it as a 'domain' user, just modify the services to run as a domain user. The rest of the network doesn't know anything about those 'local' IUSR_* accounts.

Posted: Wed Jan 12, 2005 8:36 am
by fangorn
Ok, thanks hedge. I'll try that out and report what I find.