Server Maint news

Joe · 10-31-2004, 02:16 AM

Well hand in hand with the server upgrade of the OS that happened this week, this weekend I have upgraded 2 of the 3 main services that I plan on upgrading.

We went form MySQL 3.23.58 to 4.1.17 and PHP 4.32 to 5.01 Both of which are fairly complex.

We have run into some issues wiht some code used on the ProCooling and MWL pages (and many other vbb modders will see the same soon when they go to v5 PHP) with some forum interface code that uses the forums formatting system. I am going to work on this Sunday night to fix, as I know how I can fix 99% of the scripts rapdly.

At least were still online!

hehe

Apache was slated to be upgraded tonight also, but I dont have balls that big after seeing both SQL and PHP almost blow sky high themselves.

pHaestus · 10-31-2004, 09:47 AM

wait so there is more to this site than the forums?

mastermind2004 · 10-31-2004, 02:35 PM

Hmm, I think I'll stick with PHP 4.3.9 and MySQL 4.0.2 for a while then.

jaydee · 10-31-2004, 02:40 PM

Why not edit the php ini's files so php4 is handled by php4 and php5 is handled by php5? Probably to late now anyway...

nikhsub1 · 10-31-2004, 02:48 PM

Quote:

Originally Posted by Joe

We went form MySQL 3.23.58 to 4.1.17 and PHP 4.32 to 5.01 Both of which are fairly complex. .

Wow you were running old versions... the latest stable builds of php is 4.39 IIRC and mysql is 4.0.22 I guess you are going with the beta's then? You are braver than I.

mastermind2004 · 10-31-2004, 03:24 PM

Indeed. I've got about 100 sites to worry about when I upgrade, so it may take me an awful long time to do the upgrade. I'll wait until cPanel decides they are stable, and then make sure everything still works.

Joe · 10-31-2004, 05:47 PM

Umm current builds for MySQL are 4.17 and PHP is above 5.02.

And this isnt an issue with PHP, this is all a problem with some shoddy code that was in some scripts.

cPanel sucks btw, and for that matter so does Ensim (which is on this server) and Plesk. Most all the managment apps are VERY sub par and far too tied to the services on the machine.

jaydee · 10-31-2004, 06:19 PM

Quote:

Originally Posted by Joe

Umm current builds for MySQL are 4.17 and PHP is above 5.02.

And this isnt an issue with PHP, this is all a problem with some shoddy code that was in some scripts.

cPanel sucks btw, and for that matter so does Ensim (which is on this server) and Plesk. Most all the managment apps are VERY sub par and far too tied to the services on the machine.

CPanel is what I got on my server now. I agree. I also got the CPanel web host manager and it is for shit to. I had Ensim before that and it sucked to. To many god damn bugs and updates/pathces/new versions (whatever the hell they call it to make them sleep better at night).

Many people have had older php scrips go to shit because they were not up to php5 standards and a few hosts have made the mod to run php4 and php5 together. Luckily my host still uses php4 as my forums on a few sites would die.

Hope some decent work around is in place if they go to php5. They said they will not untill it is stable with all the scripts they offer in CPanel. Heh.....

Anyway, looking forward to the new homepage as I understand there was one before?

mastermind2004 · 10-31-2004, 06:28 PM

I use them mainly as they make handling things much easier. Being born and bred with Windows, Linux Terminal is like a foreign language. cPanel at least adds a GUI, even if I still have to dig into the terminal now and again. I'm still figuring out some of the stuff, especially working with vi.
:shrug:

jaydee · 10-31-2004, 07:19 PM

Front page is back.

Joe · 10-31-2004, 07:32 PM

Yeh its not working all that hot, its more of a bandaid, I just removed most of the forum formatting tie-ins or commented them out.

testing some real fixes now.

Joe · 10-31-2004, 07:57 PM

After reading that few if anyone has found ways to fix this completely. There are some hack fixes, but none that do everything. I am going to fix this myself. by writing my own string analysis and replacement engine to read the formatting codes from the vbb database and on its own substitute the proper items. Also data restrictions content length. It will take me a week or so to get it done (maybe longer) so the front page will look like it does for a bit longer. (just the site news looks a lil funky and the recent articles and recent reviews arent hyperlinked.

pHaestus · 11-01-2004, 09:08 AM

what a pita. Thanks for messing with it Joe.

Joe · 11-01-2004, 10:08 AM

Well it had to be done though. THe old ass versions of PHP and MySQL not only had known exploits but were also slowing the server down. MySQL and PHP5 have been a kick in the ass for performance on the server. I just got done turning on all the features of SQL4.1's caching and query speed is up 50% from what it was!

I also adjusted priorities for a few of the other systems on the server (the mailscanner portion mainly since its a CPU hog) to make it so SQL and HTTPD have full speed when they need it.

Tonight I am going to start looking at what needs to be done to get the re-write action going on for the vbb stuff... Its something I havent looked at before, so its going to be a learning experience.

Joe · 11-01-2004, 10:11 AM

Uhh there seems to be an issue now with vbbs re-direction on the DB, I need to check it. Some of the settings just enabled could not be vbb friendly, but I cant think which it would be. Looking at error logs now.

Administrator · 11-01-2004, 10:14 AM

Fixed, there was a corrupt entry in a table that vbb was able to find and fix.

Joe · 11-03-2004, 01:32 PM

Sorry for the DB downtime, seems when the monkeys at the data center went to take the old HD out of the server they crashed MySqlD today.

Its back up and online now.

pHaestus · 11-03-2004, 01:47 PM

werd (10chars)

Joe · 11-17-2004, 04:46 PM

I am going to be working tonight on getting the code to work on the front page again, TOnight is one of those rare nights I am not going out drinking, not racing R/C, not LAN'n, not sleeping, etc... So I am going to sit down and geek out and hopefully get this thing to work

pHaestus · 11-17-2004, 04:47 PM

Not playing Halflife2?

Joe · 11-17-2004, 05:01 PM

Blah I have no plan on playing it any time soon. I got other stuff to do. I'll play HL2 in the summer

10-31-2004, 02:16 AM	#1
Joe The Pro/Life Support System Join Date: Dec 1999 Location: Denver, CO Posts: 4,041	Server Maint news Well hand in hand with the server upgrade of the OS that happened this week, this weekend I have upgraded 2 of the 3 main services that I plan on upgrading. We went form MySQL 3.23.58 to 4.1.17 and PHP 4.32 to 5.01 Both of which are fairly complex. We have run into some issues wiht some code used on the ProCooling and MWL pages (and many other vbb modders will see the same soon when they go to v5 PHP) with some forum interface code that uses the forums formatting system. I am going to work on this Sunday night to fix, as I know how I can fix 99% of the scripts rapdly. At least were still online! hehe Apache was slated to be upgraded tonight also, but I dont have balls that big after seeing both SQL and PHP almost blow sky high themselves. __________________ Joe - I only take this hat off for one thing... ProCooling archive curator and dusty skeleton.

10-31-2004, 05:47 PM	#7
Joe The Pro/Life Support System Join Date: Dec 1999 Location: Denver, CO Posts: 4,041	Umm current builds for MySQL are 4.17 and PHP is above 5.02. And this isnt an issue with PHP, this is all a problem with some shoddy code that was in some scripts. cPanel sucks btw, and for that matter so does Ensim (which is on this server) and Plesk. Most all the managment apps are VERY sub par and far too tied to the services on the machine. __________________ Joe - I only take this hat off for one thing... ProCooling archive curator and dusty skeleton.

10-31-2004, 07:32 PM	#11
Joe The Pro/Life Support System Join Date: Dec 1999 Location: Denver, CO Posts: 4,041	Yeh its not working all that hot, its more of a bandaid, I just removed most of the forum formatting tie-ins or commented them out. testing some real fixes now. __________________ Joe - I only take this hat off for one thing... ProCooling archive curator and dusty skeleton.

10-31-2004, 07:57 PM	#12
Joe The Pro/Life Support System Join Date: Dec 1999 Location: Denver, CO Posts: 4,041	After reading that few if anyone has found ways to fix this completely. There are some hack fixes, but none that do everything. I am going to fix this myself. by writing my own string analysis and replacement engine to read the formatting codes from the vbb database and on its own substitute the proper items. Also data restrictions content length. It will take me a week or so to get it done (maybe longer) so the front page will look like it does for a bit longer. (just the site news looks a lil funky and the recent articles and recent reviews arent hyperlinked. __________________ Joe - I only take this hat off for one thing... ProCooling archive curator and dusty skeleton.

11-01-2004, 10:08 AM	#14
Joe The Pro/Life Support System Join Date: Dec 1999 Location: Denver, CO Posts: 4,041	Well it had to be done though. THe old ass versions of PHP and MySQL not only had known exploits but were also slowing the server down. MySQL and PHP5 have been a kick in the ass for performance on the server. I just got done turning on all the features of SQL4.1's caching and query speed is up 50% from what it was! I also adjusted priorities for a few of the other systems on the server (the mailscanner portion mainly since its a CPU hog) to make it so SQL and HTTPD have full speed when they need it. Tonight I am going to start looking at what needs to be done to get the re-write action going on for the vbb stuff... Its something I havent looked at before, so its going to be a learning experience. __________________ Joe - I only take this hat off for one thing... ProCooling archive curator and dusty skeleton.

10-31-2004, 09:47 AM	#2
pHaestus Big Player Making Big Money Join Date: Aug 2001 Location: irc.lostgeek.com #procooling.com Posts: 4,782	wait so there is more to this site than the forums?

10-31-2004, 02:35 PM	#3
mastermind2004 Cooling Neophyte Join Date: Aug 2003 Location: MIT Posts: 78	Hmm, I think I'll stick with PHP 4.3.9 and MySQL 4.0.2 for a while then.

10-31-2004, 02:40 PM	#4
jaydee Put up or Shut Up Join Date: Dec 2001 Location: Spokane WA Posts: 6,506	Why not edit the php ini's files so php4 is handled by php4 and php5 is handled by php5? Probably to late now anyway...

10-31-2004, 03:24 PM	#6
mastermind2004 Cooling Neophyte Join Date: Aug 2003 Location: MIT Posts: 78	Indeed. I've got about 100 sites to worry about when I upgrade, so it may take me an awful long time to do the upgrade. I'll wait until cPanel decides they are stable, and then make sure everything still works.

10-31-2004, 06:28 PM	#9
mastermind2004 Cooling Neophyte Join Date: Aug 2003 Location: MIT Posts: 78	I use them mainly as they make handling things much easier. Being born and bred with Windows, Linux Terminal is like a foreign language. cPanel at least adds a GUI, even if I still have to dig into the terminal now and again. I'm still figuring out some of the stuff, especially working with vi. :shrug:

10-31-2004, 07:19 PM	#10
jaydee Put up or Shut Up Join Date: Dec 2001 Location: Spokane WA Posts: 6,506	Front page is back.

11-01-2004, 09:08 AM	#13
pHaestus Big Player Making Big Money Join Date: Aug 2001 Location: irc.lostgeek.com #procooling.com Posts: 4,782	what a pita. Thanks for messing with it Joe.

11-01-2004, 10:11 AM	#15
Joe The Pro/Life Support System Join Date: Dec 1999 Location: Denver, CO Posts: 4,041	Uhh there seems to be an issue now with vbbs re-direction on the DB, I need to check it. Some of the settings just enabled could not be vbb friendly, but I cant think which it would be. Looking at error logs now. __________________ Joe - I only take this hat off for one thing... ProCooling archive curator and dusty skeleton.

11-01-2004, 10:14 AM	#16
Administrator The Man Join Date: Dec 1969 Posts: 65,544	Fixed, there was a corrupt entry in a table that vbb was able to find and fix.

11-03-2004, 01:32 PM	#17
Joe The Pro/Life Support System Join Date: Dec 1999 Location: Denver, CO Posts: 4,041	Sorry for the DB downtime, seems when the monkeys at the data center went to take the old HD out of the server they crashed MySqlD today. Its back up and online now. __________________ Joe - I only take this hat off for one thing... ProCooling archive curator and dusty skeleton.

11-03-2004, 01:47 PM	#18
pHaestus Big Player Making Big Money Join Date: Aug 2001 Location: irc.lostgeek.com #procooling.com Posts: 4,782	werd (10chars)

11-17-2004, 04:46 PM	#19
Joe The Pro/Life Support System Join Date: Dec 1999 Location: Denver, CO Posts: 4,041	I am going to be working tonight on getting the code to work on the front page again, TOnight is one of those rare nights I am not going out drinking, not racing R/C, not LAN'n, not sleeping, etc... So I am going to sit down and geek out and hopefully get this thing to work __________________ Joe - I only take this hat off for one thing... ProCooling archive curator and dusty skeleton.

11-17-2004, 04:47 PM	#20
pHaestus Big Player Making Big Money Join Date: Aug 2001 Location: irc.lostgeek.com #procooling.com Posts: 4,782	Not playing Halflife2?

11-17-2004, 05:01 PM	#21
Joe The Pro/Life Support System Join Date: Dec 1999 Location: Denver, CO Posts: 4,041	Blah I have no plan on playing it any time soon. I got other stuff to do. I'll play HL2 in the summer __________________ Joe - I only take this hat off for one thing... ProCooling archive curator and dusty skeleton.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)