[PHP-INSTALL] Compiling PHP for MS SQL Support

[Mike]

I am new to Linux and have NEVER compiled PHP. I have PHP 5 and need to
compile it with MS SQL support. Per PHP docs, I installed FreeTDS and tested
it and it works. Now I need to (re)compile PHP to get the support I need to
access MS SQL databases. I am on a Ubuntu 6.06 version of Linux.

Again, PLEASE keep in mind that I am new to all of this. I tread VERY softly
doing this! (I am on a VMWare virtual server and have made a clone drive as
a backup.)

Am I correct that my first step is to see what is already compiled into my
version of PHP using php -m? I have that list.

I assume that my next step is to get the PHP source for PHP 5.1.4.  From 
here on I do not understand clearly by reading the docs I have searched for 
on the Internet through Google. Is there a place that has a VERY clear, step 
by step process to compile PHP?

Any and all help is GREATLY appreciated.

TIA.

Mike

Re: [PHP-INSTALL] Compiling PHP for MS SQL Support

[Alf Stockton]

Mike wrote:
> I am new to Linux and have NEVER compiled PHP. I have PHP 5 and need to
> compile it with MS SQL support. Per PHP docs, I installed FreeTDS and tested
> it and it works. Now I need to (re)compile PHP to get the support I need to
> access MS SQL databases. I am on a Ubuntu 6.06 version of Linux.
>
>   
I don't understand why you need to recompile or get a new version of
PHP. My guess is that a minor alteration in php.ini should achieve mssql
support.
The other thing I don't understand from your email is just where PHP
resides. MSSQL can only run on windows, therefore are you trying to
access MSSQL from a PHP application on the Linux box or is the PHP on
the windows box as well?

-- 
Regards,
Alf Stocktonwww.stockton.co.za
 
Writing is easy; all you do is sit staring at the blank sheet of paper until
drops of blood form on your forehead.
-- Gene Fowler
My email disclaimer is available at www.stockton.co.za/disclaimer.html

Re: [PHP-INSTALL] Compiling PHP for MS SQL Support

[Mike]

The PHP version that came with Ubuntu 6.06 Linux does not have MS SQL 
compiled into it. It seems like most PHPs do not by the PHP docs.

PHP is on the Linux machine. MS SQL Server is on a Windows machine within 
the domain. I need to use MS SQL within PHP on the Linux server to access 
the MS SQL machine.





"Alf Stockton" <[EMAIL PROTECTED]> wrote in message 
news:[EMAIL PROTECTED]
> Mike wrote:
>> I am new to Linux and have NEVER compiled PHP. I have PHP 5 and need to
>> compile it with MS SQL support. Per PHP docs, I installed FreeTDS and 
>> tested
>> it and it works. Now I need to (re)compile PHP to get the support I need 
>> to
>> access MS SQL databases. I am on a Ubuntu 6.06 version of Linux.
>>
>>
> I don't understand why you need to recompile or get a new version of
> PHP. My guess is that a minor alteration in php.ini should achieve mssql
> support.
> The other thing I don't understand from your email is just where PHP
> resides. MSSQL can only run on windows, therefore are you trying to
> access MSSQL from a PHP application on the Linux box or is the PHP on
> the windows box as well?
>
> -- 
> Regards,
> Alf Stockton www.stockton.co.za
>
> Writing is easy; all you do is sit staring at the blank sheet of paper 
> until
> drops of blood form on your forehead.
> -- Gene Fowler
> My email disclaimer is available at www.stockton.co.za/disclaimer.html
> 

[PHP-INSTALL] pdo bus error

[Antti Holvikari]

Hi!

I'm getting a Bus error probably with PDO. I don't know exactly what
has caused it. I first had the problem with 5.1.4 stable and after
upgrading to 5.2 snap I still get the error. Could this be same as
this: http://pecl.php.net/bugs/bug.php?id=7433. And if it is, is there
a solution? Here's some backtrace:

Exception:  EXC_BAD_ACCESS (0x0001)
Codes:  KERN_PROTECTION_FAILURE (0x0002) at 0x03a4

Thread 0 Crashed:
0   libmysqlclient.15.dylib 0x0027b57c mysql_more_results + 0
(icplusplus.c:28)
1   libphp5.so  0x0207ab84 free_statement + 184
(pdo_stmt.c:2227)
2   libphp5.so  0x021ed49c
zend_objects_store_free_object_storage + 92 (zend_objects_API.c:80)
3   libphp5.so  0x021c6f20 shutdown_executor + 608
(zend_execute_API.c:284)
4   libphp5.so  0x021d3b3c zend_deactivate + 108 (zend.c:856)
5   libphp5.so  0x02195f80 php_request_shutdown + 428
(main.c:1303)
6   libphp5.so  0x02249ae0 apache_php_module_main +
228 (sapi_apache.c:60)
7   libphp5.so  0x0224a804 send_php + 544 (mod_php5.c:668)
8   libphp5.so  0x0224a860 send_parsed_php + 44 (mod_php5.c:687)
9   httpd   0xdd18 ap_invoke_handler + 232
10  httpd   0x00017dd4 process_request_internal + 640


Thanks!

--
Antti Holvikari 
Zend Certified Engineer (ZCE)

Re: [PHP-INSTALL] Compiling PHP for MS SQL Support

[Barry Smith]

People:

Let's get real here.

M$ is a commercial entity that views most of it's objects 
and interfaces as proprietary product.

Linux, PHP, and almost everything distributed under GPL 
is not a commercial entity, or usually has no cost associated.

I've heard of Ubuntu, but I'm not sure whether it is GPL 
or not... which doesn't matter, because PHP is GPL... and 
in this case, distributed under a possible license with 
Ubuntu.

If I remember enough of the config that you need, MS SQL 
can be accessed for input by ODBC... but I've never 
worked with an PHP/M$ $QL mix.

Good luck.

Suggestion: Hit Google with "PHP MS SQL".
  One of the articles/sites that Google finds should walk you 
through accessing MS SQL from PHP.  I would really think that
the PHP docs should have something about setting up access to 
MS SQL Server.

> The PHP version that came with Ubuntu 6.06 Linux does not have 
> MS SQL compiled into it. It seems like most PHPs do not by the 
> PHP docs. 
> PHP is on the Linux machine. MS SQL Server is on a Windows machine
> within the domain. I need to use MS SQL within PHP on the Linux 
> server to access the MS SQL machine.



__
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

Re: [PHP-INSTALL] Compiling PHP for MS SQL Support

[Peter Hodge]

Hi Mike,

There can be a few gotchas compiling PHP (as in the configure or make commands
will fail with no indication as to why).  I have only ever installed PHP as an
apache module and with command-line support (the default).  The basic procedure
goes like this:

  1. download and unpack the php-5.1.4.tar.gz using

 root> tar -xzf php-5.1.4.tar.gz

  2. Configure PHP somewhat like this:

 root> cd php-5.1.4
 root> ./configure --prefix=/usr/local/php5 --with-apxs --with-mssql

 Because PHP often needs lots of configuration parameters, I prefer to
 put them all in a file called 'configure.txt' and append its contents to
 the end of the command like so:

 root> ./configure `cat configure.txt`

  3. You need to compile PHP:

 root> make

  4. And install it:

 root> make install

  5. And then you just need to restart Apache, although I don't know how
 that is done on any OS other than Mac OS X, but it should be easy to
 find on Google anyways.


That's the simple version of compiling PHP and I hope that procedure works for
you.

regards,
Peter








--- Mike <[EMAIL PROTECTED]> wrote:

> I am new to Linux and have NEVER compiled PHP. I have PHP 5 and need to
> compile it with MS SQL support. Per PHP docs, I installed FreeTDS and tested
> it and it works. Now I need to (re)compile PHP to get the support I need to
> access MS SQL databases. I am on a Ubuntu 6.06 version of Linux.
> 
> Again, PLEASE keep in mind that I am new to all of this. I tread VERY softly
> doing this! (I am on a VMWare virtual server and have made a clone drive as
> a backup.)
> 
> Am I correct that my first step is to see what is already compiled into my
> version of PHP using php -m? I have that list.
> 
> I assume that my next step is to get the PHP source for PHP 5.1.4.  From 
> here on I do not understand clearly by reading the docs I have searched for 
> on the Internet through Google. Is there a place that has a VERY clear, step 
> by step process to compile PHP?
> 
> Any and all help is GREATLY appreciated.
> 
> TIA.
> 
> Mike
> 




 
Do you Yahoo!? 
Yahoo! Personals: It's free to check out our great singles! 
http://au.personals.yahoo.com