Kitz ADSL Broadband Information
adsl spacer  
Support this site
Home Broadband ISPs Tech Routers Wiki Forum
 
     
   Compare ISP   Rate your ISP
 
Please login or register.

Login with username, password and session length
Advanced search  

News:

Pages: 1 [2]

Author Topic: MS server 2008 R2 PHP connecting to SQL2000  (Read 1965 times)

chenks

  • Reg Member
  • ***
  • Posts: 132
Re: MS server 2008 R2 PHP connecting to SQL2000
« Reply #15 on: January 23, 2018, 07:50:08 AM »

the version of php currently running on the old windows server is 5.3.8.
the version of php being used isn't important as long as a connection to the SQL server can still be made once migrated to the 2008 R2 server.
Logged

jelv

  • Helpful
  • Reg Member
  • *
  • Posts: 808
Re: MS server 2008 R2 PHP connecting to SQL2000
« Reply #16 on: January 23, 2018, 09:04:09 AM »

Support for php 5.x ends 31 December 2018 (active support has already ended and it is now on security support only).  You look to be spending a lot of effort coming up with a solution which is not sustainable going forward.

There comes a point where you have to take a pragmatic decision as to whether the long term best solution is to do a full upgrade to current versions.

You said "don't fix what isn't broken" - I'd suggest it is broken.
« Last Edit: January 23, 2018, 09:06:51 AM by jelv »
Logged
Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. Rick Cook, The Wizardry Compiled

watcher

  • Reg Member
  • ***
  • Posts: 140
Re: MS server 2008 R2 PHP connecting to SQL2000
« Reply #17 on: January 23, 2018, 11:32:06 AM »

Updating PHP from 5.3.8 to 5.3.29 to sustain this particular database software/server software combination is not really an issue unless the server is connected to the internet and is serving up web pages. Then there might then be a concern about security, depending on the risks that might or might not remain in PHP 5.3.29 which dates from August 2014. However the announcement of PHP 5.3.29 does say that it contains about 25 potentially security related fixes backported from PHP 5.4 and 5.5.

The need to sustain older combinations of software is I suspect a reality of life in many commercial and public organisations. Updating is not as straight forward as it might seem. Microsoft's updating process for SQL Server, also known as Discontinued Database Engine Functionality in SQL Server 2xxx, does include the renaming and/or removal of features as well as the addition of them, creating the risk of the need to substantially rewrite any existing code base.
Logged

chenks

  • Reg Member
  • ***
  • Posts: 132
Re: MS server 2008 R2 PHP connecting to SQL2000
« Reply #18 on: January 23, 2018, 03:15:30 PM »

Support for php 5.x ends 31 December 2018 (active support has already ended and it is now on security support only).  You look to be spending a lot of effort coming up with a solution which is not sustainable going forward.

There comes a point where you have to take a pragmatic decision as to whether the long term best solution is to do a full upgrade to current versions.

You said "don't fix what isn't broken" - I'd suggest it is broken.

it's not broken though.
the SQL 2000 is rock solid and there is solely to be the backend for a specific application. that isn't broken and doesn't need touched.

the virtual web server is running on a piece of hardware that is being replaced and as such windows 2008 R2 will be the OS for the virtual servers running on that hardware - that is the sole reason for the change of the webserver.

Updating PHP from 5.3.8 to 5.3.29 to sustain this particular database software/server software combination is not really an issue unless the server is connected to the internet and is serving up web pages. Then there might then be a concern about security, depending on the risks that might or might not remain in PHP 5.3.29 which dates from August 2014. However the announcement of PHP 5.3.29 does say that it contains about 25 potentially security related fixes backported from PHP 5.4 and 5.5.

The need to sustain older combinations of software is I suspect a reality of life in many commercial and public organisations. Updating is not as straight forward as it might seem. Microsoft's updating process for SQL Server, also known as Discontinued Database Engine Functionality in SQL Server 2xxx, does include the renaming and/or removal of features as well as the addition of them, creating the risk of the need to substantially rewrite any existing code base.

almost all of the web stuff uses ASP and there is no issue with changing the OS there. only a small part uses PHP.
the web server is public facing and on the "internet". the SQL server is not public facing.

indeed, the need for touching the SQL server simply isn't there.

too many peope think that upgrading is a simple process, but it really isn't when you have to consider business continuity and the risks involved.
Logged

jelv

  • Helpful
  • Reg Member
  • *
  • Posts: 808
Re: MS server 2008 R2 PHP connecting to SQL2000
« Reply #19 on: January 23, 2018, 04:06:24 PM »

the virtual web server is running on a piece of hardware that is being replaced and as such windows 2008 R2 will be the OS for the virtual servers running on that hardware - that is the sole reason for the change of the webserver.

Words fail me! A piece of hardware that is being replaced by a virtual server running a version of windows server that is even further past end of life than php!
Logged
Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. Rick Cook, The Wizardry Compiled

chenks

  • Reg Member
  • ***
  • Posts: 132
Re: MS server 2008 R2 PHP connecting to SQL2000
« Reply #20 on: January 24, 2018, 07:46:42 AM »

Words fail me! A piece of hardware that is being replaced by a virtual server running a version of windows server that is even further past end of life than php!

if words are failing you then feel free to not particpate any further in the thread.
you don't seem to be offering much anyway.
Logged
Pages: 1 [2]
 

anything