PHP and Oracle

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
fangorn
Forum Commoner
Posts: 41
Joined: Fri May 21, 2004 9:04 am

PHP and Oracle

Post 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?
hedge
Forum Contributor
Posts: 234
Joined: Fri Aug 30, 2002 10:19 am
Location: Calgary, AB, Canada

Post 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.
fangorn
Forum Commoner
Posts: 41
Joined: Fri May 21, 2004 9:04 am

Post 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?
hedge
Forum Contributor
Posts: 234
Joined: Fri Aug 30, 2002 10:19 am
Location: Calgary, AB, Canada

Post 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.
fangorn
Forum Commoner
Posts: 41
Joined: Fri May 21, 2004 9:04 am

Post by fangorn »

Ok, thanks hedge. I'll try that out and report what I find.
Post Reply