Re: gnustep.org has been down for the past few days

[Ivan Vučica]

Update:
- I added wiki.gnustep.org to DNS as well -- it was an omission not to
add it. Please REFRAIN FROM EDITS until further notice as YOUR EDITS
WILL NOT BE MIGRATED.
- I am still fighting MySQL/MariaDB:
  - the previous server has an unknown default character set/collation
(latin1 and not utf8, likely, as I managed to import _gsweb with it)
  - aside from timezone precision of "14" not meaning what the authors
of schemas meant, it's also deprecated (this was the quickest of the
fixes, just replace timestamp(14) with new maximum timestamp(6)
  - second fastest fix was TYPE=MyISAM changing into ENGINE=MyISAM
  - the previous server has an unknown timezone configured, and even
worse, it is unclear what timezone the dates in the dump are in
    - specifically, some of the dates are failing to be inserted as
they appear to be happening during nonexistent hours during March
timezone switches
  - entertaining thing: varchar(255) is fine as primary key fitting
inside MyISAM's 1000 bytes maximum .... as long as utf8mb4 is not the
character set in use
    - 4 * 255 = 1020
    - even though I suspect the old default was latin1, I am using
utf8 which still fits inside 1000 bytes

Now, after a few hours of fighting this, I've only completed the first
out of five databases (gnustep_gsweb.sql, which might not even be in
use).

The next one, gnustep_mediawiki, is already being painful.

I am unlikely to be done today.

On Tue, Aug 30, 2022 at 10:59 PM Marco Cawthorne <marco@icculus.org> wrote:
>
> On 2022-08-30 14:28:54 -0700 Ivan Vučica <ivan@vucica.net> wrote:
>
> > I've spent some time today on playing with Ansible thinking it may be
> > better to do it sooner rather than later. I'll leave that aside for
> > now.
> >
> > By the time I got to look at restoring MySQL databases, it simply got
> > late. Turns out that the database dumps need to be manually fixed
> > before they can be imported: schemas have changed between the version
> > on the old server and MariaDB 10.x that I have on the new one. It
> > should be relatively easy, if possibly labor intensive.
> >
> > I'll leave it for tomorrow.
>
> Thank you for all the work you do and for keeping us updated.
> And thanks to Gregory for the quick redirects. At last we can browse most of 
> the documentation again.
>
> Marco Cawthorne
>