Forum PHP Romania - Discutii despre PHP, MySQL, Javascript, AJAX, etc

[Amazing Science]

Am o intrebare. O aplicatie scrisa in php (este o simpla vizualizare dintr-o baza de date) se foloseste in interiorul companiei noastre, fiecare utilizator fiind logat pe calculator cu userul de domeniu.

Imi puteti spune va rog cum pot afla, prin php, userul de domeniu logat pe calculator, pentru a-i da drepturi in functie de acest lucru.

Ideea e ca in baza de date, la fiecare inregistrare am un camp in care este userul de domeniu. Vreau ca atunci cand un user deschide pagina php (fara a trebui sa se logheze) sa-i afiseze doar acele informatii care au in acel camp userul care este logat pe calculator.

select * from tabel where user=$user_de_domeniu_logat_pe_calculator

Pe scurt, cum pot pune in $user_de_domeniu_logat_pe_calculator valoare userului de domeniu?

Multumesc anticipat.

[kleampa]

activezi mod_auth_sspi in apache
daca n-ai cum sa instalezi/activezi modulul asta, n-ai cum cu PHP

dupa activare, poti prelua useru cu $_SERVER["LOGON_USER"];

[ShD]

edit: kleama had it first.

[Amazing Science]

eu folosesc wamp5.

cum activez mod_auth_sspi ?

multumesc.

[ShD]

in httpd.conf (directorul apache) cauti si decomentezi (stergi # din fata)
Cod: #LoadModule sspi_auth_module modules/mod_auth_sspi.so

Dai restart la apache et voila.

[Birkoff]

din cate vad nu e in lista de module la wamp, va trebui sa il instalezi manual... sa descarci de pe net fisierul mod_auth_sspi.so sa il copiezi in bin/apache/modules/ si sa modifici httpd.conf

[Amazing Science]

Birkoff > am downloadat de aici: http://sourceforge.net/project/showfiles.php?group_id=162518&package_id=183452&release_id=417573

am copiat mod_auth_sspi.so, am modificat in httpd.conf

continutul fisierul auth.php pentru verificare este:

<?php
$user=$_SERVER["LOGON_USER"];
echo "<p>AAA=".$user;
?>

cand accesez http://localhost/auth/auth.php imi afiseaza:

AAA=

Cum pot verifica ce nu e ok?

[Birkoff]

Eu nu am folosit niciodata acest modul, si din cate vad pe net si altii au probleme asemanatoare cu ce ai tu, poate te lamureste cineva care chiar a folosit acest modul si stie ceva ce noi nu stim...
Vezi in logul de erori de la apache daca scrie ceva, poate ca nu functioneaza acel modul pe versiunea ta de apache si atunci te lamuresti din erori...

[Amazing Science]

in logul de apache imi scrie asa:

Citat: [Thu Sep 11 16:58:13 2008] [notice] Parent: Received shutdown signal -- Shutting down the server.
[Thu Sep 11 16:58:13 2008] [notice] Child 11836: Exit event signaled. Child process is ending.
[Thu Sep 11 16:58:14 2008] [notice] Child 11836: Released the start mutex
[Thu Sep 11 16:58:15 2008] [notice] Child 11836: Waiting for 250 worker threads to exit.
[Thu Sep 11 16:58:15 2008] [notice] Child 11836: All worker threads have exited.
[Thu Sep 11 16:58:15 2008] [notice] Child 11836: Child process is exiting
[Thu Sep 11 16:58:15 2008] [notice] Parent: Child process exited successfully.
[Thu Sep 11 16:58:18 2008] [notice] Apache/2.2.6 (Win32) PHP/5.2.5 configured -- resuming normal operations
[Thu Sep 11 16:58:18 2008] [notice] Server built: Sep 5 2007 08:58:56
[Thu Sep 11 16:58:18 2008] [notice] Parent: Created child process 8492
[Thu Sep 11 16:58:18 2008] [notice] Child 8492: Child process is running
[Thu Sep 11 16:58:18 2008] [notice] Child 8492: Acquired the start mutex.
[Thu Sep 11 16:58:18 2008] [notice] Child 8492: Starting 250 worker threads.
[Thu Sep 11 16:58:18 2008] [notice] Child 8492: Starting thread to listen on port 80.
[Thu Sep 11 16:58:59 2008] [notice] Parent: Received shutdown signal -- Shutting down the server.
[Thu Sep 11 16:58:59 2008] [notice] Child 8492: Exit event signaled. Child process is ending.
[Thu Sep 11 16:59:00 2008] [notice] Child 8492: Released the start mutex
[Thu Sep 11 16:59:01 2008] [notice] Child 8492: Waiting for 250 worker threads to exit.
[Thu Sep 11 16:59:01 2008] [notice] Child 8492: All worker threads have exited.
[Thu Sep 11 16:59:01 2008] [notice] Child 8492: Child process is exiting
[Thu Sep 11 16:59:01 2008] [notice] Parent: Child process exited successfully.
[Thu Sep 11 16:59:05 2008] [notice] Apache/2.2.6 (Win32) PHP/5.2.5 mod_auth_sspi/1.0.4 configured -- resuming normal operations
[Thu Sep 11 16:59:05 2008] [notice] Server built: Sep 5 2007 08:58:56
[Thu Sep 11 16:59:05 2008] [notice] Parent: Created child process 10696
[Thu Sep 11 16:59:05 2008] [notice] Child 10696: Child process is running
[Thu Sep 11 16:59:05 2008] [notice] Child 10696: Acquired the start mutex.
[Thu Sep 11 16:59:05 2008] [notice] Child 10696: Starting 250 worker threads.
[Thu Sep 11 16:59:05 2008] [notice] Child 10696: Starting thread to listen on port 80.

[kleampa]

da un print_r($_SERVER) si vezi daca apare sub un alt nume de variabila

[Amazing Science]

kleampa, asta-mi afiseaza:

Array ( [HTTP_ACCEPT] => */* [HTTP_ACCEPT_LANGUAGE] => en-us [HTTP_UA_CPU] => x86 [HTTP_ACCEPT_ENCODING] => gzip, deflate [HTTP_USER_AGENT] => Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; SLCC1; .NET CLR 2.0.50727; .NET CLR 3.0.04506; .NET CLR 1.1.4322; InfoPath.2) [HTTP_HOST] => localhost [HTTP_CONNECTION] => Keep-Alive [PATH] => C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;c:\Program Files\Common Files\Roxio Shared\DLLShared\;c:\Program Files\Common Files\Roxio Shared\9.0\DLLShared\;c:\Program Files\Microsoft SQL Server\90\Tools\binn\;C:\Program Files\Windows Imaging\;C:\Program Files\Rational\common [SystemRoot] => C:\Windows [COMSPEC] => C:\Windows\system32\cmd.exe [PATHEXT] => .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC [WINDIR] => C:\Windows [SERVER_SIGNATURE] => [SERVER_SOFTWARE] => Apache/2.2.6 (Win32) PHP/5.2.5 mod_auth_sspi/1.0.4 [SERVER_NAME] => localhost [SERVER_ADDR] => 127.0.0.1 [SERVER_PORT] => 80 [REMOTE_ADDR] => 127.0.0.1 [DOCUMENT_ROOT] => C:/wamp/www/ [SERVER_ADMIN] => webmaster@localhost [SCRIPT_FILENAME] => C:/wamp/www/auth/auth.php [REMOTE_PORT] => 53590 [GATEWAY_INTERFACE] => CGI/1.1 [SERVER_PROTOCOL] => HTTP/1.1 [REQUEST_METHOD] => GET [QUERY_STRING] => [REQUEST_URI] => /auth/auth.php [SCRIPT_NAME] => /auth/auth.php [PHP_SELF] => /auth/auth.php [REQUEST_TIME] => 1221201184 )

[kleampa]

probabil e incompabilitate intre modulul instalat de tine si versiunea ta de apache
vezi ce se mai discuta pe forumurile din afara cu cateva cautari pe G

[Amazing Science]

kleampa > tu ai folosit acest modul?

pe ce modul si ce versiune de apache stii ca functioneaza?

mersi.

[Amazing Science]

nimeni, nici o alta idee? :(

[PHPRomania Bot]