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: "Mittel, Alexander" <Alexander.Mittel AT siemens.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] PHP Mssql Connection Error: Permissions?
  • Date: Wed, 7 Sep 2011 16:08:31 +0200

maybe the httpd is started with different environment then apache-bash (PATH,
LD_LIBRARY_PATH, etc.)


Mfg Alexander Mittel

Tel.: +49 (30) 386-25510
mailto:alexander.mittel AT siemens.com
https://intranet.w1.siemens.com/CMS/PD-DE/DE/HOME/FACHCENTER/EHS/Seiten/EHS.aspx


-----Ursprüngliche Nachricht-----
Von: freetds-bounces AT lists.ibiblio.org
[mailto:freetds-bounces AT lists.ibiblio.org] Im Auftrag von Derrick Betts
Gesendet: Mittwoch, 7. September 2011 15:59
An: 'FreeTDS Development Group'
Betreff: Re: [freetds] PHP Mssql Connection Error: Permissions?

My apologies, I should have included that earlier. It's not very helpful
however, the error from the browser is:

SQLSTATE[HY000] Unable to connect: Adaptive Server is unavailable or does
not exist (severity 9)

-----Original Message-----
From: Armando Ortiz [mailto:Armando.Ortiz AT cppcorp.com]
Sent: Wednesday, September 07, 2011 7:58 AM
To: derrick AT blueaxis.com; FreeTDS Development Group
Subject: RE: [freetds] PHP Mssql Connection Error: Permissions?

What does your PHP error log show when you run that script from the browser?


-----Original Message-----
From: freetds-bounces AT lists.ibiblio.org
[mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of Derrick Betts
Sent: Wednesday, September 07, 2011 6:51 AM
To: 'FreeTDS Development Group'
Subject: Re: [freetds] PHP Mssql Connection Error: Permissions?

Thank you very much for your input.
I don't think that's the issue because I can run the PHP command as apache
and have the script execute from the command line like so:

-bash-3.2$ PHP /var/www/html/axis/public/test.php

If PHP wasn't compiled properly, then that script would fail, but it doesn't
fail, it pulls all the data from the DB just fine. This script only fails
when it is executed from the browser.

Any other ideas?

-----Original Message-----
From: Armando Ortiz [mailto:Armando.Ortiz AT cppcorp.com]
Sent: Wednesday, September 07, 2011 7:50 AM
To: derrick AT blueaxis.com; FreeTDS Development Group
Subject: RE: [freetds] PHP Mssql Connection Error: Permissions?

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: freetds-bounces AT lists.ibiblio.org
[mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of Derrick Betts
Sent: Tuesday, September 06, 2011 4:50 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

---------------
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.

_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
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.

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




Archive powered by MHonArc 2.6.24.

Top of Page