MS SQL Server, Apache and PHP HOW-TO

[jacekosuchowski]

These are the steps I used to install Apache Web Server (Secure) with PHP3 with MSSQL support. (PHP4 did not work correctly - some functions were messed up)

1. Install RH6.1 - GNOME Workstation.

2. Install Apache Server RPMs:
secureweb-3.1-1
secureweb-devel-3.1-1

3. Install Sybase RPMs:
sybase-ase-11_0_3_3-6_i386.rpm
sybase-ossd-10_0_4-6_i386.rpm

4. Configure Sybase:
run '/opt/sybase/install/sybinstall.sh'
add SQL server name to the '/etc/hosts' file
run '/opt/sybase/install/sybinit' to create 'interfaces' file
select opt 2 - "Edit / View Interfaces File"
select opt 1 - "Add a new entry"
select opt 1 - "Server name"
- enter the SQL server name you have entered into the '/etc/hosts' file
Ctrl-A to accept
select opt 3 - "Add a new listener service"
select opt 1 - "Hostname/Address"
- enter the SQL server name you have entered into the '/etc/hosts' file
select opt 2 - "Port"
- enter '1433'
Ctrl-A to accept , confirm if correct
Ctrl-A to accept , confirm to write to interfaces file
Ctrl-A twice to exit the program

test your SQL connection by running '/opt/sybase/bin/isql'

5. Get PHP3 tar 'php-3.0.16.tar' and extract it.
Configure and compile PHP:
run 'configure --with-apxs --with-sybase=/opt/sybase'
run 'make'
run 'make install'

6. Modify your Apache config files:
In 'httpd.conf' file:
modify 'LoadModule php3_module' to point to correct path

[mangeli]

Why wouldn't you use PHP4?

Just curious.
http://www.devshed.com/Server_Side/PHP/SoothinglySeamless

------------------
http://www.tinyminds.f2s.com
SlackHacks Forums (http://www.slackhacks.f2s.com/cgi-bin/ikonboard.cgi)

[jacekosuchowski]

PHP4 (at least the version 4.0.2) has a problem with function mssql_num_rows() or mssql_query(). Also I forgot to mention the above solution works with SQL 6.5. As far as I know there are some problems with SQL 7.0. I read somewhere you must have at least SP1 on SQL 7.0 but I did not work with it yet. ( Got some other priorities now)

[Sweede]

ok, 3 things i see wrong here.

1. Apache from RPMs.
thats bad..

2. Sybase.

3. php3

use, always use, never even think about anything else, but apache from source.

instead of sybase, use MySQL or postgres (written to keep klamath happy http://www.linuxnewbie.org/ubb/smile.gif)

php3.0.16 is old, unsupported, bug-ridden and has secuity holes that were patched in 4.0.x

php 4.0.3pl1 is released and should be used.

there is plenty of help on how to configure all this, except for the ssl part, but if you read the readme that comes with mod_ssl , you should have no problems.

[mangeli]

Originally posted by jacekosuchowski:
PHP4 (at least the version 4.0.2) has a problem with function mssql_num_rows() or mssql_query(). Also I forgot to mention the above solution works with SQL 6.5. As far as I know there are some problems with SQL 7.0. I read somewhere you must have at least SP1 on SQL 7.0 but I did not work with it yet. ( Got some other priorities now)

Haven't had a problem with it. I do have to agree with sweede though, use apache from source, MySQL and the newest release of PHP.

If you build it the way the instructions on that web site I posted above.

Haven't had any problems.

check it out http://www.seiz.com