application pool on Apache

[johnyjj2]

Hello!

I've got web application to be installed on the server. The server contains MySQL & Apache. Unfortunately web application was created for MSSQL 2005 and IIS 6.0 or 7.0. (By the way. I've got Windows XP Prof on server but I'd like to ask because of my curiosity - is it possible to run MSSQL applications on Linux servers?). I tried to run MSSQL on MySQL - without success (Console Terminal, MS Query Browser, DBConvert). I decided to install MSSQL Server 2008 in order to run .sql script files which are responsible for creating new database.

But my question is somehow different. The other thing required for installation is to "create application pool". I found http://technet.microsoft.com/en-us/library/cc786585(WS.10).aspx but it is about configuring it for IIS. My question is - how to do it for Apache?

And about MSSQL. I just installed it. I run:
C:\Documents and Settings\useruser>osql -Usa -Ppassword -i "F:\Data\MyApplication\Scripts\CreateDb.sql"
[SQL Server Native Client 10.0]Named Pipes Provider: Could not open a connection to SQL Server [2].
[SQL Server Native Client 10.0]Login timeout expired
[SQL Server Native Client 10.0]A network-related or instance-specific error has occured while establishing a connection to SQL Server. Server is not found of not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.

Greetings!

[noneforit]

There is a specific forum called Apache Configuration (http://www.codingforums.com/forumdisplay.php?f=69)....would likely get a better response in there :thumbsup:

[oracleguy]

I'll move the thread over there. As for using MsSQL on Linux, you can't run the actual server obviously, you'll need to run that on a Windows server. However you probably can connect to it via ODBC.

[johnyjj2]

Thanks! Do you know what I should do to execute this sql file and get rid of those errors? The link which I gave is for Server 2005, I've got Server 2008 and because of this thing I cannot follow first step in that instruction.
Greetings!

[clunk.werclick]

Before you go down the road of migrating it to Apache, is the application written in ASP, PERL, PHP or some other language? That will be the starting point.

But to add my 20 pence worth of post filler:
Application pools are native to IIS and not available on Apache at this time. You could emulate similar behaviour by running a dedicated httpd process for each 'application', and then combine them, if needed, using a standard reverse proxy configuration.

It's not something I've done myself. From my days with IIS it was useful to keep some sites with 'flaky' code in their own pools so they did not mess with others sites written by better developers.

Apache on Linux is multi process, so my guess is even if you managed to hang one process - the impact on other running processes would not raise much of an eyebrow.

Slowloris is about the only thing I've seen recently that would take Apache down completely - but now I'm drifting off on a tangent....

[johnyjj2]

Thanks for your answer :-).

JavaScript, PHP, SQL are used.

Greetings!

[clunk.werclick]

That's good. So you have a couple of choices.

1. The ugly way would be to dump the data from the Microsoft Database and migrate it all to Mysql, rewrite the code, deal with any stored procedures or differences (that does not get my vote)

2. Follow Oracleguy's excellent advice and make use of ODBC. This would require that you maintain a separate Microsoft SQL server, and reference it. There will probably be some rewriting of the PHP to do this. This gives some general advice and examples: http://www.w3schools.com/PHP/php_db_odbc.asp

Good luck :-)