Skip to Content.
Sympa Menu

freetds - Re: [freetds] Hello! Free Six-Pack for FreeTDS Help.

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Robert Gonzalez <robert AT robert-gonzalez.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Hello! Free Six-Pack for FreeTDS Help.
  • Date: Mon, 27 Jul 2009 11:14:41 -0700

You need to set some environment variables into the apache environment
variables list (on Ubuntu it's at /etc/apache2/envvars). I wrote up how I
got all my stuff working on Ubuntu here:
http://www.robert-gonzalez.com/2009/02/18/building-the-php-ms-sql-server-extension-from-source-on-ubuntu-810/

I know the OSes are different, but maybe it will help you get this thing
rolling.

Oh yeah, and don't forget to restart apache after changing the envvars file.
;)

On Sun, Jul 26, 2009 at 8:17 PM, Joshua <joshuajoe AT gmail.com> wrote:

> After recompiling on the newest version of FreeTDS (8.3) it seems my
> command line php user can access the database, and the webserver user
> cannot:
>
> <?php
> var_dump(mssql_connect('BLKDB04.weblinkconnect.com:1433
> ','WLafINhaanmcRO','---snip---'));
> var_dump(mssql_select_db('WLafayetteINCOC'));
> ?>
>
> Returns the following baffling results:
>
> command line: php -f ~/data/testmssql.php
> -> resource(4) of type (mssql link)
> -> bool(true)
>
> http://n2.greaterlafayettecommerce.com/testmssql.php
> -> bool(false)
> -> bool(false)
>
> Upon further investigation, on the good connection, FreeTDS is
> recieving all of the correct credentials. On the webserver side, it is
> searching for "SYBASE" -- which means it's defaulting, I think.
>
> Ideas?
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>



--

Robert Gonzalez
http://www.robert-gonzalez.com




Archive powered by MHonArc 2.6.24.

Top of Page