[prev in list] [next in list] [prev in thread] [next in thread] 

List:       php-windows
Subject:    [PHP-WIN] Re: PHP, MySQL and Active Directory
From:       62.255.248.4
Date:       2005-08-25 14:49:28
Message-ID: B2.A4.28235.B7ADD034 () pb1 ! pair ! com
[Download RAW message or body]

> I've got PHP 4 set up on Server 2003. My LAN is running active directory.
>
> Whenever I try to a mysql_connect, something (PHP I assume) tacks on a
> hostname of the local computer.
>
> $link = mysql_connect('myserver', 'user', 'password');
>
> Besides the old password authentication password problem (which is not
what
> this post is about)
>
> I get errors saying that access is denied for user@WORKSTATION.
>
> First off, there is no user@WORKSTATION because I don't use local user
> accounts with active directory running. So why is the NetBIOS name of my
> workstation being attached to my username?
>
> Even if I put in my hostname...
>
> $link = mysql_connect('myserver', 'user@mydomain.com', 'password');
>
> Then it complains about user@mydomain.com@WORKSTATION.
>
> If I try running the page on the server, then it tacks the entire fully
> qualified domain name of the computer :
> user@mydomain.com@myserver.mylan.mydomain.com.
>

mySQL provides the facility for users to log in from different machines. So
you can have a user account, and within that, various accounts which are
essentially the same but apply to specific machines: user@localhost,
user@10.10.1.2  and so on. This feature is therefore not part of PHP, byt
mySQL. I'm not entirely sure what the purpose of this is, but perhaps it is
to stop someone stealing your login and using it to log in from a different
machine.



> I don't have to explain to you guys that an active directory account is
the
> same account regardless of what computer I log onto and (apparently) PHP
has
> absolutely no regard for this. It seems to think that any user on any
> computer needs a specific user and hostname....
>
> Very frustrating! Anyone deal with this before?

-- 
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[prev in list] [next in list] [prev in thread] [next in thread]