Topic: SFC2.NET Outage and UPDATE - IMPORTANT (Read 11777 times)

FA Frey XC · « **on:** September 21, 2005, 01:31:22 pm »

SFC2.Net is down right now due to the fact that it's being moved over to the D.Net servers.

Expect it to be down for at least 1 day so we can get everything tested and have SFC2.Net snuggled into it's new home.

Kewl thing? Once this is done you'll be able to access SFC2.Net from:

http://sfc2.net

Neat, huh?

Let's all thank Bozobits for their most excellent service above and beyond the call of duty!

Bonk · « **Reply #1 on:** September 21, 2005, 01:41:59 pm »

Thanks bozobits!

IAF Lyrkiller · « **Reply #2 on:** September 21, 2005, 01:43:05 pm »

Thanks Bozobits.

FPF-Tobin Dax · « **Reply #3 on:** September 21, 2005, 01:47:20 pm »

GDA-S'Cipio · « **Reply #4 on:** September 21, 2005, 02:16:17 pm »

Cool!

And thanks to the CW crew for bozobits for all these years.

-S'Cipio

KBF-Kurok · « **Reply #5 on:** September 21, 2005, 03:57:20 pm »

FA Frey XC · « **Reply #6 on:** September 21, 2005, 06:43:17 pm »

One thing I do want to re-iterate :

There will be no staff changes, etc. etc. Everything is staying as is, SFC2.Net is still a "independent" organization, we're just offering it a new home.

FPF-Tobin Dax · « **Reply #7 on:** September 22, 2005, 05:42:09 am »

Thanks!

Soreyes · « **Reply #8 on:** September 22, 2005, 06:05:38 am »

Thank You Bozobits

Capt Jeff · « **Reply #9 on:** September 22, 2005, 06:13:24 am »

Thanks to BBJones for hosting SFC2.net/bozobits.com at work for all these years well after he himself stopped playing the game. Very generous of him. Through the ups and downs of Canada West and SFC2.Net, this game would of simply not have been the same without the tireless support of BBJ and SnB, and the others that came before myself and TraceyG.

Thanks to Frey for the generous offer to host !

Corbomite · « **Reply #10 on:** September 22, 2005, 10:14:18 am »

Thanks BBJ. You were by far the best server admin we ever had. I wish you would consider coming back and saving us from ourselves.

FA Frey XC · « **Reply #11 on:** September 23, 2005, 02:29:40 am »

Just to update, we're working on getting the MS SQL DB ported over to MySQL.

Bonk is working on it, so you know it'll be done right.

As soon as we're good to go, you'll know.

Regards,

FA Frey XC · « **Reply #12 on:** September 23, 2005, 07:38:54 am »

OKay SFC2.Net is back up - and yes we know about the icons and pics, we're working on it.

http://Http://www.sfc2.net

or just

http://sfc2.net

NICE WORK BONK !!!!

Dizzy · « **Reply #13 on:** September 23, 2005, 08:00:30 am »

I STILL dont have access to the Alliance forum, Hexx.

Dizzy · « **Reply #14 on:** September 23, 2005, 08:01:14 am »

Oh, and wtg, Bonk. I know how difficult that was for ya, took 2 days of work. WTG!

Bonk · « **Reply #15 on:** September 23, 2005, 08:42:54 am »

Thanks guys, its sill not quite done though. I got it updated to the latest version of phpbb (thus the template issues), but have not gotten it converted to MySQL yet. I have gained a huge(er) appreciation for MySQL after working with this MS SQL db. I am committed to getting it converted to MySQL however. Gonna give it another crack today before updating the SGO files. (I had intended to spend this time on the kills pages, oh well...)

GDA-Agave · « **Reply #16 on:** September 23, 2005, 09:01:21 am »

Nice work Bonk. Looks good so far.

And a large well-deserved thanks to BBJones for hosting bozobits.com for us all those many months/years. Thanks a bunch!!

Bruce Agave

C-Los · « **Reply #17 on:** September 23, 2005, 09:27:52 am »

Many Thanks BB Jones for all the years gone by and the servers that gave me Hrs. of relief from RL........

Thanks to Frey for the hosting and to Bonk for all the time and work he's putting in........

Thanks to everyone else from the players to the Admins of the servers we play now, too many to name but we all know who I'm talking about....

Bonk · « **Reply #18 on:** September 23, 2005, 10:31:14 am »

Forums URL now: http://sfc2.net/forums/

FA Frey XC · « **Reply #19 on:** September 23, 2005, 10:43:46 am »

Please excuse the pathetic temporary frontpage.

I am sure the SFC2.Net admin team will get the frontpage and webs back up in no time now

Bonk · « **Reply #20 on:** September 23, 2005, 11:30:42 am »

We seem to have broken the forums since this morning somehow... looking for the cause.

FPF-DieHard · « **Reply #21 on:** September 23, 2005, 11:37:41 am »

Quote from: C-Los on September 23, 2005, 09:27:52 am

Many Thanks BB Jones for all the years gone by and the servers that gave me Hrs. of relief from RL........

Thanks to Frey for the hosting and to Bonk for all the time and work he's putting in........

Thanks to everyone else from the players to the Admins of the servers we play now, too many to name but we all know who I'm talking about....

What he said

el-Karnak · « **Reply #22 on:** September 23, 2005, 12:06:06 pm »

Quote from: Bonk (Lord of the Cluster Flies) on September 23, 2005, 08:42:54 am

Thanks guys, its sill not quite done though. I got it updated to the latest version of phpbb (thus the template issues), but have not gotten it converted to MySQL yet. I have gained a huge(er) appreciation for MySQL after working with this MS SQL db. I am committed to getting it converted to MySQL however. Gonna give it another crack today before updating the SGO files. (I had intended to spend this time on the kills pages, oh well...)

Why don't forum software use Oracle?

BTW, ISC forums have no posts?

Hexx · « **Reply #23 on:** September 23, 2005, 12:08:22 pm »

Quote from: C-Los on September 23, 2005, 09:27:52 am

..but we all know who I'm talking about....

That would be me for those of you who didn't..

Bonk · « **Reply #24 on:** September 23, 2005, 12:16:28 pm »

Its still broken. Going to do it all again. Nobody mess with it please.

Why not Oracle? I have no Idea. Probably an absurd price. The real Question is why MS SQL?

MySQL is sooo straightforward compared to it. (and php is geared for it)

Braxton_RIP · « **Reply #25 on:** September 23, 2005, 12:21:25 pm »

Quote from: Bonk (Lord of the Cluster Flies) on September 23, 2005, 12:16:28 pm

Its still broken. Going to do it all again. Nobody mess with it please.

Why not Oracle? I have no Idea. Probably an absurd price. The real Question is why MS SQL?

MySQL is sooo straightforward compared to it. (and php is geared for it)

MS SQL isn't so bad, as long as it is version 6.5 and your running MS SQL Enterprise Manager to access it. It probably isn't 6.5 though as old as the forums are.

el-Karnak · « **Reply #26 on:** September 23, 2005, 12:23:47 pm »

Quote from: Bonk (Lord of the Cluster Flies) on September 23, 2005, 12:16:28 pm

Its still broken. Going to do it all again. Nobody mess with it please.

Why not Oracle? I have no Idea. Probably an absurd price. The real Question is why MS SQL?

MySQL is sooo straightforward compared to it. (and php is geared for it)

MS SQL Server is the MS Windows version of Sybase. Sybase is a pretty good Database. It's certainly more easier to program PL/SQL entities than in Oracle. If you use a cell phone, chances are one of the switches servicing the market you passed through had a Sybase database to populate its member registry. Still, there are a lot more switches using Oracle than Sybase.

MySQL is not a company standard database and I don't see it happening with many F500 companies. You are much better off learning Oracle and to a lessor extent: Sybase and MS SQL Server.

Bonk · « **Reply #27 on:** September 23, 2005, 12:42:35 pm »

Its MS SQL 2000 we're running, restoring an MS SQL 7.0 db.

I just like MySQL much better, its so much more straightforward, permissions and database management is much simpler, I like the command prompt interface.

A lot of what I imagine is supposed to make MS SQL simpler in fact makes it more cumbersome.

jsp j2ee and oracle, I know, I know that's what the market says it wants, but I can't stand them. Legacy systems in my opinion. They'll die out with the fogeys administering them.

php-mysql is so much more efficient in my opinion. Its populartity continues to grow. apache-php-mysql will rule the web. IIS-MSSQL/Oracle-JSP/ASP has no place in my future... portability is all.

el-Karnak · « **Reply #28 on:** September 23, 2005, 12:49:53 pm »

Quote from: Bonk (Lord of the Cluster Flies) on September 23, 2005, 12:42:35 pm

Its MS SQL 2000 we're running, restoring an MS SQL 7.0 db.

I just like MySQL much better, its so much more straightforward, permissions and database management is much simpler, I like the command prompt interface.

A lot of what I imagine is supposed to make MS SQL simpler in fact makes it more cumbersome.

jsp j2ee and oracle, I know, I know that's what the market says it wants, but I can't stand them. Legacy systems in my opinion. They'll die out with the fogeys administering them.

php-mysql is so much more efficient in my opinion. Its populartity continues to grow. apache-php-mysql will rule the web. IIS-MSSQL/Oracle-JSP/ASP has no place in my future... portability is all.

Oracle is the Unix of Database systems. It'll go when Unix does. JSP is definitely old technology. It's all CFM and JSF now.

Watch out for J2EE EJB 3.0 specs. coming out next year.

Bonk · « **Reply #29 on:** September 23, 2005, 01:24:49 pm »

Quote from: el-Karnak on September 23, 2005, 12:49:53 pm

Watch out for J2EE EJB 3.0 specs. coming out next year.

Oh great. All your java apps are obsolete again.

IAF Lyrkiller · « **Reply #30 on:** September 23, 2005, 03:24:40 pm »

How could you just break it again?

The pain you guys are putting us through.

J/K, just get it fixed Bonk, we do have faith in you.

Bonk · « **Reply #31 on:** September 23, 2005, 03:54:01 pm »

It is running again. Apologies for my crankiness and any inconvenience.

I figured out what had happened. (the forum is allergic to certain manual db edits).

Please do not adjust any settings till I figure out what is different about templates in this version, and exacty how the old template was customised.

Do not post your doctoral thesis either, no guarantees yet. I'd still like to get it moved to MySQL.

I'll leave it be for now. Now Dizzy you have a shiplist and map for me? (shiplist will do...) I'll come back to this later.

FPF-SCM_TraceyG_XC · « **Reply #32 on:** September 24, 2005, 12:27:35 am »

Great work, Bonk! And thankyou Frey for hosting!

Bonk · « **Reply #33 on:** September 24, 2005, 11:16:25 am »

It seems the SFC2.Net forums cannot be updated. All the private forums get broken. Shame, because phpbb 2.0.3 is full of security holes... hopefully it won't get hacked. Its stuck forever... unless I can get it converted to MySQL, it might take an update then... but I have my doubts. (as the MS-DTS cannot export blobs and the MySQL Migration Toolkit fails to find the JRE on our servers, sigh...)

SideSwipe9th · « **Reply #34 on:** September 24, 2005, 11:25:38 am »

their forums are dead again, i keep gettin the error message "This Virtual Directory does not allow contents to be listed."

*edit*
or not, im thinking my pc is gettin a wee bit messed up

Bonk · « **Reply #35 on:** September 24, 2005, 11:31:31 am »

I am currently working on them... unfortunately a link was posted before they were ready.

I will be finished shortly. You will need to logout and clear your cache before using them.

I will post here when they are ready.

(Recall I am on 31.2K dialup and everything is verrry sllloooowwww...)

SideSwipe9th · « **Reply #36 on:** September 24, 2005, 11:43:48 am »

ouchies, the only time i remember being on dial up (6-8 years ago) i pretty much hated it. i could only spend a short time online cause the phone calls were then expensive, it was very very slow (bbc news site took 3 mins to fully load in) and then we just gave up in frustration.

cant you get dsl where ya are bonk?

Bonk · « **Reply #37 on:** September 24, 2005, 11:55:48 am »

There is no cable or DSL in the domain of the cluster fly. (and satellite is just silly)

The SFC2.Net forums are back up, still on MS-SQL and phpbb 2.0.3. Clear your cache and cookies before using it.

Now to try and find the patience to work on the webmap kills pages some more... very bad timing with these two things in conflict, oh well.

I will attempt to convert the SFC2.net db to MySQL and update phpbb at a later date (a few weeks?). I'll do so on a copy of the forums so the current SFC2.Net forums will remain up.

Again, apologies for any inconvenience and thank you for your patience. (I know its been trying mine...lol.)

FPF-SCM_TraceyG_XC · « **Reply #38 on:** September 24, 2005, 01:54:08 pm »

Your efforts are very much appreciated

Bonk · « **Reply #39 on:** September 24, 2005, 02:20:44 pm »

Thanks Tracey.

Lepton · « **Reply #40 on:** September 25, 2005, 12:29:51 am »

I'm not sure what the parameters of the situation are, but if your frustration with the MySQL Migration software has anything to do with converting the sfc2.net forum from MSSQL to MySQL, it would seem that such a conversion on its face is of low priority unless of course there is a substantitive reason for such a conversion.

All that to say, you are doing alot of great work for the community, Bonk. No one expects you to take on everything that "needs" to be done. I am sure any number of things can wait to be done. No one's going anywhere and you are only one person. Do what you enjoy doing and let others pick up the rest.

CaptJosh · « **Reply #41 on:** September 25, 2005, 10:31:43 am »

Lepton, for ease of use and being able to update to a much newer, much more secure version of phpBB, converting to mySQL is clearly a priority. The security holes are part of why the SFC2.net forums got hacked while they were still on bozobits.

All that said, I'm just glad that Bonk fixed the e-mail notification. Now I acually get a link I can use when being notified of a new post in a thread to which I have subscribed, which wasn't happening after the hack on bozobits.

Lepton · « **Reply #42 on:** September 25, 2005, 11:40:27 am »

Ok, I'll buy that, but are the sfc2.net forums essential in any sense? Seems like there is a fully functional forum running right here that might be altered to meet any of the needs that sfc2.net met. I guess my comments should have been restricted to more of a functional priority as opposed to a technical priority. I do appreciate you clearing that up for me.

FA Frey XC · « **Reply #43 on:** September 26, 2005, 03:22:57 pm »

SFC2.Net has been, and will continue to be, the place to be for online campaign coordination and the like.

Lepton, thanks for the suggestions regarding how we utilize and place our resources.

We certainly will take this into consideration.

Bonk · « **Reply #44 on:** October 04, 2005, 10:22:04 pm »

I just managed to get SFC2.Net converted to a MySQL db and updated the phpbb forums software to the latest version. You will need to clear your cache and cookies. Let me know if anything is broken or missing. (Old threads with quotes in them are a bit wonky, but other than that everything looks OK. I'll work on fixing the old quotes)

FPF-SCM_TraceyG_XC · « **Reply #45 on:** October 05, 2005, 12:35:45 am »

Good job Bonk!

KBF-Crim · « **Reply #46 on:** October 05, 2005, 12:43:42 am »

Thanks Bonk..

Bonk · « **Reply #47 on:** October 05, 2005, 06:15:24 am »

I think I have a solution to the quotes issue... working on it now. (or rather wordpad is...)

The forum will give some errors while I replace the db.

Bonk · « **Reply #48 on:** October 05, 2005, 11:09:01 am »

OK, I think I have the quotes issue sorted. There are still a few improperly escaped double quote characters in the db, but I don't think this will be a problem, users can edit them where they see fit. (i.e \" -> ") I think they're just in thread titles that use double quote characters.

Let me know here if anything is badly broken, we can always go back to the old version and the MS-SQL db, but hopefully this will work out.

Remember to clear your cache and cookies before using the new version of SFC2.Net.

Capt Jeff · « **Reply #49 on:** October 05, 2005, 11:48:33 am »

WOW !

DB is down to 54 MB from it's previous size of 240MB.....lol

CaptJosh · « **Reply #50 on:** October 05, 2005, 11:53:36 am »

And this is why Mikrowskwish SQL sucks while MySQL kicks ass...

Bonk · « **Reply #51 on:** October 05, 2005, 11:54:03 am »

Quote from: Capt Jeff on October 05, 2005, 11:48:33 am

WOW !

DB is down to 54 MB from it's previous size of 240MB.....lol

Ya, I think that was a bug in the old version of phpbb, I saw it report absurd values when the old MS-SQL db was actually ~120 MB on disk. The new version of the db in MySQL is actually ~75 MB on disk, so I still don't quite trust the phpbb software in its report on the db size.

FA Frey XC · « **Reply #52 on:** October 21, 2005, 02:01:25 pm »

The original SFC2.Net webs are now back up.

Enjoy !

Bonk · « **Reply #53 on:** October 22, 2005, 06:54:16 am »

Hah! I think I figured out what went wrong with my last attempt to update the forums... nothing! It seems the autopruning feature works now where it did not previously... and most of the forums are set to autoprune posts older than 180 days every day... this is why forums took a long time to load first load and then all the old posts were missing...

I am going to try another update today (on a copy) and then disable autopruning on all the forums before test reading them... So the current forum will still be up and readable, but anything posted in the next few hours will not make the update if it is successful. I will post here when this update attempt is complete/sucessful...

Bonk · « **Reply #54 on:** October 22, 2005, 11:30:18 am »

OK, I think I have it this time, db converted to MySQL, phpbb forums updated to latest version, autopruning disabled on all forums.

(Some topic titles will still show a (\") because of a db conversion glitch, but this is minor...and can be edited where desired by the user.)

Clear your cache and cookies before using the new forums version at SFC2.Net.

Let me know here if there are any dealbreakers or minor issues. (I still have the old version to revert to if needed of course). I'll check back later this afternoon to see how things are.

FA Frey XC · « **Reply #55 on:** October 22, 2005, 01:23:43 pm »

Is Bonk a coding machine or WHAT !!

Nice work man!

FPF-SCM_TraceyG_XC · « **Reply #56 on:** October 22, 2005, 07:22:57 pm »

Great work Bonk!! You're a champ!!

Bonk · « **Reply #57 on:** November 02, 2005, 09:03:49 pm »

After the recent hardware replacement, php and phpbb were updated to latest versions and eacclerator was installed. MySQL update remains. Post feedback here, thanks.

Bonk · « **Reply #58 on:** November 03, 2005, 04:22:03 pm »

SFC2.Net, Dynaverse.net TeamSpeak and Xenocorp.net will be down for a short time while I update MySQL on that server.

Bonk · « **Reply #59 on:** November 03, 2005, 08:44:43 pm »

Update complete! Sorry for the delay, I ran into a snag that took a while to find. Heimdall now updated to the latest mysql, php, eacclerator, and phpbb.

Let me know here if there are any issues, or if anyone needs database access restored or if any of the old databases I did not restore are actually still required.

Dynaverse.net should get this MySQL update soon too, but not tonight... it will take a while as the db is quite large...

Bonk · « **Reply #60 on:** January 01, 2006, 06:44:15 am »

Updating phpbb on SFC2.Net. The forums may look strange for a while until I rework the template again.

Bonk · « **Reply #61 on:** January 01, 2006, 07:43:09 am »

Update complete, let me know if anything is missing or awry.

Lepton · « **Reply #62 on:** January 01, 2006, 11:32:42 am »

At least in my web browser, Firefox, the individual posts in a thread are missing any horizontal border to divide the posts from one another. Makes it hard to read.

Bonk · « **Reply #63 on:** January 01, 2006, 11:35:12 am »

Quote from: Lepton on January 01, 2006, 11:32:42 am

At least in my web browser, Firefox, the individual posts in a thread are missing any horizontal border to divide the posts from one another. Makes it hard to read.

I have noticed that as well. I'll take a look to see if it can be edited in the styles admin.

edit: nope, that cannot be edited in the styles admin, looks like it will take a manual edit to the template or css files which will be overwritten on the next update as well.

edit#2: I added a yellow line to divide the posts in the css file settings, let me know if this works OK.

News:

Topic: SFC2.NET Outage and UPDATE - IMPORTANT (Read 11777 times) var addthis_config = {"data_track_clickback":true};

el-Karnak

el-Karnak

el-Karnak

Topic: SFC2.NET Outage and UPDATE - IMPORTANT (Read 11777 times)