Skip to Content.
Sympa Menu

freetds - Re: [freetds] PHP Mssql Connection Error: Permissions?

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Thomas, Christopher (LLU)" <cwthomas AT llu.edu>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] PHP Mssql Connection Error: Permissions?
  • Date: Tue, 6 Sep 2011 22:24:22 -0700

When you say the script fails, what do you mean by that? Do you get any error
msgs? If so what are they?

Chris

________________________________

From: freetds-bounces AT lists.ibiblio.org on behalf of Derrick Betts
Sent: Tue 9/6/2011 4:49 PM
To: freetds AT lists.ibiblio.org
Subject: [freetds] PHP Mssql Connection Error: Permissions?



I have a PHP script that makes a connection to SQL Server.

>From the command line as root: tsql -H hostname -U username connects just
great and I can run queries.



I have a PHP script in /var/www/html/axis/public/test.php

When I: sudo -u apache -s (change the user from root to apache) and then run
my PHP script from the command line, it connects just great.

But, from the web browser, it fails. The web browser is able to connect
everywhere it is supposed to and renders all the web pages that don't need
an SQL connection.



apache is the user that is running httpd. I've confirmed this via: ps aux |
grep apache



Any ideas as to why apache can run the PHP script and connect just fine from
the command line, but when the browser attempts to connect to the very same
script, it fails?



Thanks,

Derrick

_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds


<<winmail.dat>>




Archive powered by MHonArc 2.6.24.

Top of Page