Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 7 of 7
  1. #1
    New to the CF scene
    Join Date
    Aug 2009
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    application pool on Apache

    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/l...85(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!
    Last edited by johnyjj2; 08-12-2009 at 10:36 AM.

  • #2
    Regular Coder noneforit's Avatar
    Join Date
    Apr 2009
    Location
    England
    Posts
    268
    Thanks
    10
    Thanked 20 Times in 20 Posts
    There is a specific forum called Apache Configuration....would likely get a better response in there

  • #3
    Rockstar Coder
    Join Date
    Jun 2002
    Location
    USA
    Posts
    9,074
    Thanks
    1
    Thanked 328 Times in 324 Posts
    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.
    OracleGuy

  • #4
    New to the CF scene
    Join Date
    Aug 2009
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts
    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!

  • #5
    New Coder
    Join Date
    Jul 2009
    Posts
    91
    Thanks
    5
    Thanked 6 Times in 6 Posts
    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....

  • #6
    New to the CF scene
    Join Date
    Aug 2009
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks for your answer :-).

    JavaScript, PHP, SQL are used.

    Greetings!

  • #7
    New Coder
    Join Date
    Jul 2009
    Posts
    91
    Thanks
    5
    Thanked 6 Times in 6 Posts
    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 :-)


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •