ID: 17826
Comment by: hola at yahoo dot com
Reported By: jan at penninkhof dot com
Status: Closed
Bug Type: Apache2 related
Operating System: Win32
PHP Version: 4.2.1
Assigned To: edink
New Comment:
Red Hat 9.0 Freetds 0.62.3 Apache 2.0.49 PHP 5.0.ORC3
Instucction, that premit connect a server Linux with a server Windows
2000 Server with SQL Server.
INSTALLING FREETDS
1-. Download freetds -> www.freetds.org
2-. tar -zxvf freetds-stable-tgz
3-. cd freetds-0.62.3
4-. ./configure --prefix=/usr/local/freetds --with-tdsver=8.0
--enable-msdblib --enable-dbmfix --with-gnu-ld
Note: tdsver=8.0 if you use SQL 2000, tdsver=7.0 if you use SQL 7.0
5-. make
6-. make install
7-. /usr/local/freetds/bin/tsql -S <ip of the server> -U <User SQL>
Note: For default User SQL is sa and the it have not password
For example: /usr/local/freetds/bin/tsql -S 198.168.100.2 -U sa
8-. Add the next text in freetds.conf ( /usr/local/freetds/etc )
[TDS]
host = <ip of the Server with Sql>
port = 1433
tds version = 8.0
Note: If you use SQL 2000 then tds version = 8.0
if you use SQL 7.0 then tds version = 7.0
9-. Add the next text in the file /etc/ld.so.conf
/usr/local/freetds/lib
INSTALLING APACHE
1-. Download apache www.apache.org
2-. tar -zxvf httpd-2.0.49.tar.gz
3-. cd httpd-2.0.49
4-. ./configure --prefix=/etc/httpd --enable-so
5-. make
6-. make install
7-. Configure the file -> httpd.conf ( /etc/httpd/conf/httpd.conf )
8-. Probe the apache: /etc/httpd/bin/apachectl start
/etc/httpd/bin/apachectl stop
INSTALLING PHP
1-. Download the PHP in this site (www.php.net)
2-. tar -zxvf php-5.0-ORC3.tar.gz
3-. cd php-5.0-ORC3
4-. ./configure --with-apxs2=/etc/httpd/bin/apxs --enable-versioning
--with-mssql=/usr/local/freetds --disable-libxml
5-. make
6-. make install
7-. cp php.ini-DIST /usr/local/lib
8-. Add the next line in /etc/httpd/conf/httpd.conf
AddType application/x-httpd-php .php
TESTING
<html>
<body>
<?php
$con = mssql_connect ("<ip of the server SQL>", "sa", "");
mssql_select_db ("<Data Base>", $con);
$sql= "SELECT * FROM <Table>";
$rs= mssql_query ($sql, $con);
echo "The field number one is: ";
echo mssql_result ($rs, 0, 0);
mssql_close ($con);
?>
</body>
</html>
Previous Comments:
------------------------------------------------------------------------
[2002-12-29 11:50:16] kemalcelayir at hotmail dot com
Apache 2.0.43 and PHP Version 4.3.1-dev work together. Most problems
are because of PHP version.
http://snaps.php.net/win32/php4-win32-latest.zip
LoadModule php4_module c:/php/sapi/php4apache2.dll
AddType application/x-httpd-php .php .php3 .php4 .phtml
That's all.
------------------------------------------------------------------------
[2002-12-22 11:16:04] bodewes_NO_SPAM_ at fmf dot nl
Finaly!!!
I got i fixed!
I downloaded the latest from the website (rc4) from:
http://snaps.php.net/~edink/php-4.3.0RC4-Win32.zip
Just unzipped it and named it c:/php/
edited the http.conf in the way mentioned above
and edited the php.ini in the windows folder
And that only after 3 hours :P
------------------------------------------------------------------------
[2002-12-13 07:46:57] vince at alkinos dot com
OK,
corrected thanks to Edin:
# There is link on the front page:
#
# http://snaps.php.net/~edink/php-4.3.0RC3-Win32.zip
#
# Edin
Vince
------------------------------------------------------------------------
[2002-12-13 05:18:29] vince at alkinos dot com
Hi,
Despite having done exactly what is explained in "[23 Oct 8:52pm]
[EMAIL PROTECTED]" in this bug list, I still have "cannot load
php4apache2.dll into server - The specified procedure cannot be found".
Versions of apache and php are the same. The only thing is that I'm
using Windows XP Pro SP1 with all windows updates... Download of
php4-win32-STABLE-latest.zip
was made today (buggy version?)
What's wrong???
Do I have to put php4ts.dll into the register datas???
DO I miss any specific XP Pro procedure?
I spent 3 hours on this and it still doesn't work.
Urgent help needed plz.
Thanks in advance.
Vince
------------------------------------------------------------------------
[2002-12-07 11:18:22] cis at cis dot net
When I use the SAPI DLL for PHP on W2K and Apache 2.0.43, I get
nothing. :(
No errors anywhere I can see, but also no php processing. I know it's
'supposed' to be buggy, but I get nothing - not even an error.
I can load a .php page, but everything between the <?php and ?> shows
up in
the page source.
If I use php-cgi.exe instead of php4apache2.dll, my pages work. But I
have
an urgent need for the virtual() function and this only works in the
dll
version of php.
Using apache -k start there are no errors. There are also no errors in
error.log. I've set php.ini to report errors, but there aren't ever
any.
Anyone got an idea? My httpd.conf contains:
# PHP
LoadModule php4_module c:/php/sapi/php4apache2.dll
#AddModule mod_php4.c
AddType application/x-httpd-php .phtml .php .php3 .php4 .html
I've commented out the AddModule line for 2 reasons. One is that I have
no
module called mod_php4.c - the other reason is that the docs say that
it's
not required in the newer versions of Apache, especially Apache 2.
Bob Kramer
------------------------------------------------------------------------
The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
http://bugs.php.net/17826
--
Edit this bug report at http://bugs.php.net/?id=17826&edit=1
