Re: PHP Mssql Connection Error: Permissions?
Armando Ortiz <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <[email protected]> |
My guess is that the PHP you're using isn't compiled with MSSQL support, which is typical of most distributions and their default PHP package. It would be simpler for you to use the FreeTDS ODBC driver along with UnixODBC and a DB abstraction layer like ADODB, which is all kinds of WONDERFUL. -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Derrick Betts Sent: Tuesday, September 06, 2011 4:50 PM To: [email protected] 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 [email protected] http://lists.ibiblio.org/mailman/listinfo/freetds --------------- CONFIDENTIALITY WARNING: This email may contain privileged or confidential information and is for the sole use of the intended recipients. Unauthorized disclosure or use of this communication is prohibited. If you believe that you have received this email in error, please notify the sender immediately and delete it from your system. EXPORT WARNING: These commodities, technical data or software may be subject to the export control of either the International Traffic in Arms Regulations (ITAR) or the Export Administration Regulations (EAR) and may not be exported without the authorization of either the Department of State or the Department of Commerce prior to export. Export includes disclosure and or access to Commodities, technical data or software by foreign nationals whether located in the United States or Abroad. This requirement applies equally to foreign national employees of U.S. Companies and their foreign subsidiaries.