Storing Cookies (See : http://ec.europa.eu/ipg/basics/legal/cookies/index_en.htm ) help us to bring you our services at overunity.com . If you use this website and our services you declare yourself okay with using cookies .More Infos here:
https://overunity.com/5553/privacy-policy/
If you do not agree with storing cookies, please LEAVE this website now. From the 25th of May 2018, every existing user has to accept the GDPR agreement at first login. If a user is unwilling to accept the GDPR, he should email us and request to erase his account. Many thanks for your understanding

User Menu

Custom Search

Author Topic: Downtime 29th and 30th of September 2008  (Read 18437 times)

hartiberlin

  • Administrator
  • Hero Member
  • *****
  • Posts: 8154
    • free energy research OverUnity.com
Downtime 29th and 30th of September 2008
« on: October 01, 2008, 09:21:17 PM »
Hi All,
I wanted to upgrade the forum software to the latest TinyPortal 1.05 Beta  Version,
but that did not work out, as it still has too many bugs and there were
errors inside the block codes.

As this also changed the MySQL database, I had the problem, that the changed
Database was not compatible anymore with the now used TinyPortal 0.983 version.

Luckily I had a backup of the database still in old format.
But as the database was 205 Mbytes big it took
ages to reimport into a new MySQL database server.

I am also thinking about moving the OverUnity.com site to the
new SMF 2.04 Beta software with a different portal PortaMX.com
but I still have to test it all, how stable it all is.
Also this could run on SQlite and does not need MySQL servers...

But I have first to test this all on a non-live forum version, to
be sure it all works out.

So now I know, that Murphy´s law has again truth...
Never change a running system..

Regards, Stefan.

broli

  • Hero Member
  • *****
  • Posts: 2245
Re: Downtime 29th and 30th of September 2008
« Reply #1 on: October 01, 2008, 09:23:39 PM »
Are you still with servage?

I'm also happy the forum got back up. Got kind of bored for a while there  :P.

FreeEnergy

  • Hero Member
  • *****
  • Posts: 2014
    • The Freedom Cell Network
Re: Downtime 29th and 30th of September 2008
« Reply #2 on: October 01, 2008, 10:03:07 PM »
i recommend not to use any type of beta upgrades even if it seems like everything works. just wait for stable version, then upgrade :)


hartiberlin

  • Administrator
  • Hero Member
  • *****
  • Posts: 8154
    • free energy research OverUnity.com
Re: Downtime 29th and 30th of September 2008
« Reply #3 on: October 01, 2008, 10:39:09 PM »
i recommend not to use any type of beta upgrades even if it seems like everything works. just wait for stable version, then upgrade :)



Very true.
Yes,I am still on servage.

Have not decided yet, where else to go for hosting.

As the hosting runs okay in this moment on Servage,
there is no fast need to change.
Also I am looking into SQLite database solutions, so we will
not be limited to the MySQL database access.

I am not sure, if the current SMF 1.1.6 version runs on a SQLite
setup, but the new SMF2.04B runs on SQLite, I just tested it last night.

But I would have to change many things in the template, cause the Azure template
is not yet available for SMF 2.x and I would like to keep this.

Also the PortaMX.com portal is also still Beta and it does not have a download
section like Tinyportal has, so I would have to move the files
from the Tinyportal Download area to somewhere else and
this has to be linked then again to some forum pages, so it is a lot of work
to do this all... So I decided to keep the current software and
better work on the upcoming Video Portal and article website.


Regards, Stefan.

FreeEnergy

  • Hero Member
  • *****
  • Posts: 2014
    • The Freedom Cell Network
Re: Downtime 29th and 30th of September 2008
« Reply #4 on: October 01, 2008, 10:57:51 PM »
ever thought about owning your own server?
i think in the long run you will be saving a lot of money and you would be in total control.
use ubuntu as the server, then install apache :) then use www.opendns.com or some kind of www.no-ip.com service.

you would have to leave your server computer on 24/7 but still i think in the long run you would save a lot more money. no?

poynt99

  • TPU-Elite
  • Hero Member
  • *******
  • Posts: 3582
Re: Downtime 29th and 30th of September 2008
« Reply #5 on: October 01, 2008, 11:35:15 PM »
Stefan, a suggestion:

Go back to SMF 1.1.4 and get rid of the fancy gum-ball look. The forum will probably run 10 times faster with much fewer problems. As a minimum, lose the fancy graphics.

btw, the site isn't running that great right now. Some pages take 30 seconds or more to load, and some don't load at all unless you hit refresh.

hartiberlin

  • Administrator
  • Hero Member
  • *****
  • Posts: 8154
    • free energy research OverUnity.com
Re: Downtime 29th and 30th of September 2008
« Reply #6 on: October 02, 2008, 01:50:10 AM »
Well,  SMF 1.1.4 is old and has security problems.
The actual version is 1.1.6 which I am running here.

To have my own server is the goal, but that would cost about 50 to100 US$ per month,
much more than the Servage account right now.
It must be in a good datacenter and I would need to take care of a lot more things like
security updates and other server maintenance stuff, which I right now
don´t have the time for.

Also I want to build up my Newman scooter,
which I did not yet have time for.

Well, the database is located now on a different SQL server, which seems
to be slower.
I guess I will change this again and try to upload the current database to the faster
one which I was before the downtime.

I have to ask Servage, what their fastest SQL is right now.

The one we are currently on is probably a bit overcrowded.

Has anyone of you got any experience with SMF 1.1.6 on SQLite ?

http://www.sqlite.org

is a SQL less database solution using only one file, so
no database servers needed...

Regards, Stefan.

orbs

  • Guest
Re: Downtime 29th and 30th of September 2008
« Reply #7 on: October 02, 2008, 01:52:48 AM »
Die Umlaute scheinen noch nicht wieder ganz da zu sein. Dem Symptom nach sieht es so aus, als ob ein Teil der Daten in der Datenbank als CP1252 ("Windows-1252", Obermenge von ISO-8859-1) oder ISO-8859-15 kodiert abgelegt sind und nun als UTF-8 ausgelesen werden.

X00013

  • Hero Member
  • *****
  • Posts: 679
Re: Downtime 29th and 30th of September 2008
« Reply #8 on: October 02, 2008, 01:57:04 AM »
Whatever u do, come jan 1st 2009, you should be able to find a good host from Brazil. That way u got no spooks.

X00013

  • Hero Member
  • *****
  • Posts: 679
Re: Downtime 29th and 30th of September 2008
« Reply #9 on: October 02, 2008, 02:08:02 AM »
@ Stef, do not worry about cost of running this site on a fast server. Keep it simple. Let everyone view the sight at no cost. If you want to post, u must join 4 a fee, and that fee will be what ever amount you feel as thou will justify your post/ou hosting. Put up a link ( paypal would b good ), and i will donate.

hartiberlin

  • Administrator
  • Hero Member
  • *****
  • Posts: 8154
    • free energy research OverUnity.com
Re: Downtime 29th and 30th of September 2008
« Reply #10 on: October 02, 2008, 02:11:55 AM »
Die Umlaute scheinen noch nicht wieder ganz da zu sein. Dem Symptom nach sieht es so aus, als ob ein Teil der Daten in der Datenbank als CP1252 ("Windows-1252", Obermenge von ISO-8859-1) oder ISO-8859-15 kodiert abgelegt sind und nun als UTF-8 ausgelesen werden.


Yes, I tried to convert the database from ISO to UTF-8 format,
but it ran not through completely... also some quircks I still have to fix...

Many thanks for this hint.

Where does it show ?

Vielen Dank für den Hinweis,
wo tauchen genau die Fehler auf ? URL ?
Gruss, Stefan.

X00013

  • Hero Member
  • *****
  • Posts: 679

Nostradamus2

  • Newbie
  • *
  • Posts: 27
Re: Downtime 29th and 30th of September 2008
« Reply #12 on: October 02, 2008, 03:12:42 AM »
Has anyone of you got any experience with SMF 1.1.6 on SQLite ?

http://www.sqlite.org

is a SQL less database solution using only one file, so
no database servers needed...

Regards, Stefan.


Don't use SQLite with forum like this one, because it lacks many features and uses very simple multi transaction handling, SQLlite uses simple file lock to insert/update data, better use MySQL or Postgresql

winner

  • Jr. Member
  • **
  • Posts: 61
    • World Community Grid
Re: Downtime 29th and 30th of September 2008
« Reply #13 on: October 02, 2008, 03:15:25 AM »
Thanks for the update, Stefan!

Glad you were able to get things back as quickly as you did; I know that these things can sometimes take many, many hours to repair!

hartiberlin

  • Administrator
  • Hero Member
  • *****
  • Posts: 8154
    • free energy research OverUnity.com
Re: Downtime 29th and 30th of September 2008
« Reply #14 on: October 02, 2008, 03:24:29 AM »
Don't use SQLite with forum like this one, because it lacks many features and uses very simple multi transaction handling, SQLlite uses simple file lock to insert/update data, better use MySQL or Postgresql

Yes,I heard this too from a friend, that a 200 Mbyte database file is too big for SQLite...

Or maybe running it totally in the RAM inside the server ?
Would this help ?

I will probably run my upcoming article site
free-energy.tk
on SQLite though, as this will be no forum
but just the summary of many threads of the forum..
So the forum over here will be for discussion
and the free-energy.tk website will be for
summary articles.

I think this is the best way, not to censor anything over here,
but just only copy the technical stuff from over here to
the new free-energy.tk site for a quick read.

Over here there will stay the discussion and posting
of new stuff and I will summarize and convert it into
fast readable pages at free-energy.tk

Regards, Stefan.