Re: gnustep.org has been down for the past few days
Just fyi. I am going to work on a way to automatically publish artifacts to ftp from GitHub when we do releases as I believe this will streamline the process. On Sun, Jun 4, 2023 at 21:09 Gregory Casamento wrote: > Awesome, thanks for the update! I apologize for the negative tone of my > previous email. I fully realize that all of us are busy. Thank you so > much for your efforts in getting this sorted out. > > On Sun, Jun 4, 2023 at 13:38 Ivan Vučica wrote: > >> To provide an update on the mailing list as well: >> >> - ftp.gnustep.org has been serving for a while already over anonymous >> FTP. >> - Earlier this week, I fixed issues that blocked maintainers from >> using SFTP to upload new releases. >> - Today, I set up ftp.gnustep.org to be served over HTTP as well, >> fixing some broken web links. >> - Maintainers should now have a way to update the www.gnustep.org >> website, and not just gnustep.github.io. There will be further work to >> merge these two forks of the website into one. >> >> There are other changes behind the scenes, and I am looking forward to >> enabling HTTPS, to migrating MediaWiki as well, as well as figuring >> out what to do with other deployed software that used databases on the >> old hosting provider. >> >> On Thu, Sep 29, 2022 at 7:07 AM Josh Freeman >> wrote: >> > >> > Oops, didn't realize the latest tarballs are available on github >> (under the Releases section on the right-hand side of each project's page). >> > >> > The Fedora scripts for building & installing PikoPixel & ReDoomEd >> (+ GNUstep) have been updated: >> > http://twilightedge.com/gnustep/pikopixel/fedora_install_script.html >> > http://twilightedge.com/gnustep/redoomed/fedora_install_script.html >> > >> > Cheers, >> > >> > Josh >> > >> > >> > On 9/26/22 3:11 PM, Josh Freeman wrote: >> > > Thank you Greg & Ivan for your work migrating the website! >> > > >> > > The source tarballs are currently unavailable (ftp.gnustep.org & >> ftpmain.gnustep.org are both down). >> > > >> > > Are the source archives moving? (I'm currently updating the >> PikoPixel & ReDoomEd install scripts for Fedora; Fedora doesn't have distro >> packages for GNUstep GUI & Back, so the install scripts build them locally >> by downloading the latest source releases). >> > > >> > > Thanks, >> > > >> > > Josh >> > > >> > > >> > > On 8/29/22 4:09 PM, Ivan Vučica wrote: >> > >> I've synced the latest backups I have to the server, I've picked up >> > >> new ones from our host, and I'm looking at setting up basic services. >> > >> >> > >> I've stopped now as I got tired, and will resume tomorrow. >> > >> >> > >> In the meantime, I've left www.gnustep.org pointing to the temporary >> > >> redirect, but I have set up A records and CNAMEs pointing to the >> > >> existing, deprecated oxymium host: >> > >> >> > >> - ftp.gnustep.org >> > >> - ftpmain.gnustep.org >> > >> - wwwmain.gnustep.org >> > >> - mediawiki.gnustep.org >> > >> >> > >> Please note: our current host has kindly done another, *final* export >> > >> of MySQL databases. Any future changes will *not* be reflected when I >> > >> bring up the services on the new host. I will *not* ask our current >> > >> host for a new database export. >> > >> >> > >> Please also avoid making changes to the site whether via CVS or FTP. >> > >> If you do make an upload to FTP (such as a new release), please >> notify >> > >> me explicitly and directly, and ensure you get an acknowledgement >> from >> > >> me. >> > >> >> > >> Please also note: at least initially (and possibly permanently) the >> > >> CVS website edits will not be fetched in the new setup. Likely we'll >> > >> switch over to Git. Some services like /softwareindex/ may move to a >> > >> subdomain, so we change what portion of our setup depends on PHP. >> > >> >> > >> >> > >> On Sun, Aug 28, 2022 at 10:43 AM Gregory Casamento >> > >> wrote: >> > >>> >> > >>> We have a backup of the wiki data. I am more concerned about just >> getting the actual site up for now. >> > >>> >> > >>> On Sat, Aug 27, 2022 at 4:45 PM Marco Cawthorne >> wrote: >> > >> > On 2022-08-27 13:20:04 -0700 Gregory Casamento >> > wrote: >> > >> > > We were being hosted by oxmium, but I believe they took it down. >> I >> > > am in >> > > the process of redirecting the site to github.io on a temporary >> basis >> > > until >> > > we devise a more permanent solution. >> > > >> > > GC >> > >> > Thanks for the quick response Gregory. >> > I hope the data is still going to be accessible. I've been using >> the >> > Wayback Machine for the time being, but it is spotty and things >> like >> > the Wiki are not all captured. >> > >> > Marco Cawthorne >> > >> > >>> >> > >>> >> > >>> -- >> > >>> Gregory Casamento >> > >>> GNUstep Lead Developer / OLC, Principal Consultant >> > >>> http://www.gnustep.org - http://heronsperch.blogspot.com >> > >>>
Re: gnustep.org has been down for the past few days
Awesome, thanks for the update! I apologize for the negative tone of my previous email. I fully realize that all of us are busy. Thank you so much for your efforts in getting this sorted out. On Sun, Jun 4, 2023 at 13:38 Ivan Vučica wrote: > To provide an update on the mailing list as well: > > - ftp.gnustep.org has been serving for a while already over anonymous FTP. > - Earlier this week, I fixed issues that blocked maintainers from > using SFTP to upload new releases. > - Today, I set up ftp.gnustep.org to be served over HTTP as well, > fixing some broken web links. > - Maintainers should now have a way to update the www.gnustep.org > website, and not just gnustep.github.io. There will be further work to > merge these two forks of the website into one. > > There are other changes behind the scenes, and I am looking forward to > enabling HTTPS, to migrating MediaWiki as well, as well as figuring > out what to do with other deployed software that used databases on the > old hosting provider. > > On Thu, Sep 29, 2022 at 7:07 AM Josh Freeman > wrote: > > > > Oops, didn't realize the latest tarballs are available on github > (under the Releases section on the right-hand side of each project's page). > > > > The Fedora scripts for building & installing PikoPixel & ReDoomEd (+ > GNUstep) have been updated: > > http://twilightedge.com/gnustep/pikopixel/fedora_install_script.html > > http://twilightedge.com/gnustep/redoomed/fedora_install_script.html > > > > Cheers, > > > > Josh > > > > > > On 9/26/22 3:11 PM, Josh Freeman wrote: > > > Thank you Greg & Ivan for your work migrating the website! > > > > > > The source tarballs are currently unavailable (ftp.gnustep.org & > ftpmain.gnustep.org are both down). > > > > > > Are the source archives moving? (I'm currently updating the > PikoPixel & ReDoomEd install scripts for Fedora; Fedora doesn't have distro > packages for GNUstep GUI & Back, so the install scripts build them locally > by downloading the latest source releases). > > > > > > Thanks, > > > > > > Josh > > > > > > > > > On 8/29/22 4:09 PM, Ivan Vučica wrote: > > >> I've synced the latest backups I have to the server, I've picked up > > >> new ones from our host, and I'm looking at setting up basic services. > > >> > > >> I've stopped now as I got tired, and will resume tomorrow. > > >> > > >> In the meantime, I've left www.gnustep.org pointing to the temporary > > >> redirect, but I have set up A records and CNAMEs pointing to the > > >> existing, deprecated oxymium host: > > >> > > >> - ftp.gnustep.org > > >> - ftpmain.gnustep.org > > >> - wwwmain.gnustep.org > > >> - mediawiki.gnustep.org > > >> > > >> Please note: our current host has kindly done another, *final* export > > >> of MySQL databases. Any future changes will *not* be reflected when I > > >> bring up the services on the new host. I will *not* ask our current > > >> host for a new database export. > > >> > > >> Please also avoid making changes to the site whether via CVS or FTP. > > >> If you do make an upload to FTP (such as a new release), please notify > > >> me explicitly and directly, and ensure you get an acknowledgement from > > >> me. > > >> > > >> Please also note: at least initially (and possibly permanently) the > > >> CVS website edits will not be fetched in the new setup. Likely we'll > > >> switch over to Git. Some services like /softwareindex/ may move to a > > >> subdomain, so we change what portion of our setup depends on PHP. > > >> > > >> > > >> On Sun, Aug 28, 2022 at 10:43 AM Gregory Casamento > > >> wrote: > > >>> > > >>> We have a backup of the wiki data. I am more concerned about just > getting the actual site up for now. > > >>> > > >>> On Sat, Aug 27, 2022 at 4:45 PM Marco Cawthorne > wrote: > > > > On 2022-08-27 13:20:04 -0700 Gregory Casamento > > wrote: > > > > > We were being hosted by oxmium, but I believe they took it down. I > > > am in > > > the process of redirecting the site to github.io on a temporary > basis > > > until > > > we devise a more permanent solution. > > > > > > GC > > > > Thanks for the quick response Gregory. > > I hope the data is still going to be accessible. I've been using the > > Wayback Machine for the time being, but it is spotty and things like > > the Wiki are not all captured. > > > > Marco Cawthorne > > > > >>> > > >>> > > >>> -- > > >>> Gregory Casamento > > >>> GNUstep Lead Developer / OLC, Principal Consultant > > >>> http://www.gnustep.org - http://heronsperch.blogspot.com > > >>> https://www.patreon.com/bePatron?u=352392 - Become a Patron > > >>> https://gf.me/u/x8m3sx - My GNUstep GoFundMe > > >>> https://teespring.com/stores/gnustep - Store > > >> > > > > -- Gregory Casamento GNUstep Lead Developer / OLC, Principal Consultant http://www.gnustep.org - http://heronsperch.blogspot.com https://www.patreon.com/bePatron?u=352392 - Become a Patron
Re: gnustep.org has been down for the past few days
To provide an update on the mailing list as well: - ftp.gnustep.org has been serving for a while already over anonymous FTP. - Earlier this week, I fixed issues that blocked maintainers from using SFTP to upload new releases. - Today, I set up ftp.gnustep.org to be served over HTTP as well, fixing some broken web links. - Maintainers should now have a way to update the www.gnustep.org website, and not just gnustep.github.io. There will be further work to merge these two forks of the website into one. There are other changes behind the scenes, and I am looking forward to enabling HTTPS, to migrating MediaWiki as well, as well as figuring out what to do with other deployed software that used databases on the old hosting provider. On Thu, Sep 29, 2022 at 7:07 AM Josh Freeman wrote: > > Oops, didn't realize the latest tarballs are available on github (under > the Releases section on the right-hand side of each project's page). > > The Fedora scripts for building & installing PikoPixel & ReDoomEd (+ > GNUstep) have been updated: > http://twilightedge.com/gnustep/pikopixel/fedora_install_script.html > http://twilightedge.com/gnustep/redoomed/fedora_install_script.html > > Cheers, > > Josh > > > On 9/26/22 3:11 PM, Josh Freeman wrote: > > Thank you Greg & Ivan for your work migrating the website! > > > > The source tarballs are currently unavailable (ftp.gnustep.org & > > ftpmain.gnustep.org are both down). > > > > Are the source archives moving? (I'm currently updating the PikoPixel & > > ReDoomEd install scripts for Fedora; Fedora doesn't have distro packages > > for GNUstep GUI & Back, so the install scripts build them locally by > > downloading the latest source releases). > > > > Thanks, > > > > Josh > > > > > > On 8/29/22 4:09 PM, Ivan Vučica wrote: > >> I've synced the latest backups I have to the server, I've picked up > >> new ones from our host, and I'm looking at setting up basic services. > >> > >> I've stopped now as I got tired, and will resume tomorrow. > >> > >> In the meantime, I've left www.gnustep.org pointing to the temporary > >> redirect, but I have set up A records and CNAMEs pointing to the > >> existing, deprecated oxymium host: > >> > >> - ftp.gnustep.org > >> - ftpmain.gnustep.org > >> - wwwmain.gnustep.org > >> - mediawiki.gnustep.org > >> > >> Please note: our current host has kindly done another, *final* export > >> of MySQL databases. Any future changes will *not* be reflected when I > >> bring up the services on the new host. I will *not* ask our current > >> host for a new database export. > >> > >> Please also avoid making changes to the site whether via CVS or FTP. > >> If you do make an upload to FTP (such as a new release), please notify > >> me explicitly and directly, and ensure you get an acknowledgement from > >> me. > >> > >> Please also note: at least initially (and possibly permanently) the > >> CVS website edits will not be fetched in the new setup. Likely we'll > >> switch over to Git. Some services like /softwareindex/ may move to a > >> subdomain, so we change what portion of our setup depends on PHP. > >> > >> > >> On Sun, Aug 28, 2022 at 10:43 AM Gregory Casamento > >> wrote: > >>> > >>> We have a backup of the wiki data. I am more concerned about just > >>> getting the actual site up for now. > >>> > >>> On Sat, Aug 27, 2022 at 4:45 PM Marco Cawthorne wrote: > > On 2022-08-27 13:20:04 -0700 Gregory Casamento > wrote: > > > We were being hosted by oxmium, but I believe they took it down. I > > am in > > the process of redirecting the site to github.io on a temporary basis > > until > > we devise a more permanent solution. > > > > GC > > Thanks for the quick response Gregory. > I hope the data is still going to be accessible. I've been using the > Wayback Machine for the time being, but it is spotty and things like > the Wiki are not all captured. > > Marco Cawthorne > > >>> > >>> > >>> -- > >>> Gregory Casamento > >>> GNUstep Lead Developer / OLC, Principal Consultant > >>> http://www.gnustep.org - http://heronsperch.blogspot.com > >>> https://www.patreon.com/bePatron?u=352392 - Become a Patron > >>> https://gf.me/u/x8m3sx - My GNUstep GoFundMe > >>> https://teespring.com/stores/gnustep - Store > >> > >
Re: gnustep.org has been down for the past few days
Oops, didn't realize the latest tarballs are available on github (under the Releases section on the right-hand side of each project's page). The Fedora scripts for building & installing PikoPixel & ReDoomEd (+ GNUstep) have been updated: http://twilightedge.com/gnustep/pikopixel/fedora_install_script.html http://twilightedge.com/gnustep/redoomed/fedora_install_script.html Cheers, Josh On 9/26/22 3:11 PM, Josh Freeman wrote: Thank you Greg & Ivan for your work migrating the website! The source tarballs are currently unavailable (ftp.gnustep.org & ftpmain.gnustep.org are both down). Are the source archives moving? (I'm currently updating the PikoPixel & ReDoomEd install scripts for Fedora; Fedora doesn't have distro packages for GNUstep GUI & Back, so the install scripts build them locally by downloading the latest source releases). Thanks, Josh On 8/29/22 4:09 PM, Ivan Vučica wrote: I've synced the latest backups I have to the server, I've picked up new ones from our host, and I'm looking at setting up basic services. I've stopped now as I got tired, and will resume tomorrow. In the meantime, I've left www.gnustep.org pointing to the temporary redirect, but I have set up A records and CNAMEs pointing to the existing, deprecated oxymium host: - ftp.gnustep.org - ftpmain.gnustep.org - wwwmain.gnustep.org - mediawiki.gnustep.org Please note: our current host has kindly done another, *final* export of MySQL databases. Any future changes will *not* be reflected when I bring up the services on the new host. I will *not* ask our current host for a new database export. Please also avoid making changes to the site whether via CVS or FTP. If you do make an upload to FTP (such as a new release), please notify me explicitly and directly, and ensure you get an acknowledgement from me. Please also note: at least initially (and possibly permanently) the CVS website edits will not be fetched in the new setup. Likely we'll switch over to Git. Some services like /softwareindex/ may move to a subdomain, so we change what portion of our setup depends on PHP. On Sun, Aug 28, 2022 at 10:43 AM Gregory Casamento wrote: We have a backup of the wiki data. I am more concerned about just getting the actual site up for now. On Sat, Aug 27, 2022 at 4:45 PM Marco Cawthorne wrote: On 2022-08-27 13:20:04 -0700 Gregory Casamento wrote: We were being hosted by oxmium, but I believe they took it down. I am in the process of redirecting the site to github.io on a temporary basis until we devise a more permanent solution. GC Thanks for the quick response Gregory. I hope the data is still going to be accessible. I've been using the Wayback Machine for the time being, but it is spotty and things like the Wiki are not all captured. Marco Cawthorne -- Gregory Casamento GNUstep Lead Developer / OLC, Principal Consultant http://www.gnustep.org - http://heronsperch.blogspot.com https://www.patreon.com/bePatron?u=352392 - Become a Patron https://gf.me/u/x8m3sx - My GNUstep GoFundMe https://teespring.com/stores/gnustep - Store
Re: gnustep.org has been down for the past few days
Thank you Greg & Ivan for your work migrating the website! The source tarballs are currently unavailable (ftp.gnustep.org & ftpmain.gnustep.org are both down). Are the source archives moving? (I'm currently updating the PikoPixel & ReDoomEd install scripts for Fedora; Fedora doesn't have distro packages for GNUstep GUI & Back, so the install scripts build them locally by downloading the latest source releases). Thanks, Josh On 8/29/22 4:09 PM, Ivan Vučica wrote: I've synced the latest backups I have to the server, I've picked up new ones from our host, and I'm looking at setting up basic services. I've stopped now as I got tired, and will resume tomorrow. In the meantime, I've left www.gnustep.org pointing to the temporary redirect, but I have set up A records and CNAMEs pointing to the existing, deprecated oxymium host: - ftp.gnustep.org - ftpmain.gnustep.org - wwwmain.gnustep.org - mediawiki.gnustep.org Please note: our current host has kindly done another, *final* export of MySQL databases. Any future changes will *not* be reflected when I bring up the services on the new host. I will *not* ask our current host for a new database export. Please also avoid making changes to the site whether via CVS or FTP. If you do make an upload to FTP (such as a new release), please notify me explicitly and directly, and ensure you get an acknowledgement from me. Please also note: at least initially (and possibly permanently) the CVS website edits will not be fetched in the new setup. Likely we'll switch over to Git. Some services like /softwareindex/ may move to a subdomain, so we change what portion of our setup depends on PHP. On Sun, Aug 28, 2022 at 10:43 AM Gregory Casamento wrote: We have a backup of the wiki data. I am more concerned about just getting the actual site up for now. On Sat, Aug 27, 2022 at 4:45 PM Marco Cawthorne wrote: On 2022-08-27 13:20:04 -0700 Gregory Casamento wrote: We were being hosted by oxmium, but I believe they took it down. I am in the process of redirecting the site to github.io on a temporary basis until we devise a more permanent solution. GC Thanks for the quick response Gregory. I hope the data is still going to be accessible. I've been using the Wayback Machine for the time being, but it is spotty and things like the Wiki are not all captured. Marco Cawthorne -- Gregory Casamento GNUstep Lead Developer / OLC, Principal Consultant http://www.gnustep.org - http://heronsperch.blogspot.com https://www.patreon.com/bePatron?u=352392 - Become a Patron https://gf.me/u/x8m3sx - My GNUstep GoFundMe https://teespring.com/stores/gnustep - Store
Re: gnustep.org has been down for the past few days
It should hopefully really be a one-step upgrade, if the documentation is right, but you never know with software seemingly released in 2004/2005... sent from phone On Tue, Sep 13, 2022, 07:53 Riccardo Mottola wrote: > Hi Ivan > > Ivan Vučica wrote: > > We have a problem. All the PHP software, including the old MediaWiki, > > is so old that it's still using numerous deprecated functions such as > > the old mysql_*() functions that have been removed from PHP in 2015. > > > > I'll proceed with importing the converted data into MariaDB, but > > existing software won't function unless we get a dead pre-7.0 version > > of PHP running (for things like Software Index), or upgrade.third > > party software (such as MediaWiki). > > If the new MediaWiki opens/converts the old tables and works, that's > fine, we can live without SoftwareIndex and then upgrade it. > But if we loose the wiki, we need probably to think a two-step upgrade. > Make an older (how old?) virtual machine, get things working and then > upgrade MediaWiki. > Keep us updated. > > Riccardo > >
Re: gnustep.org has been down for the past few days
Hi Ivan Ivan Vučica wrote: > We have a problem. All the PHP software, including the old MediaWiki, > is so old that it's still using numerous deprecated functions such as > the old mysql_*() functions that have been removed from PHP in 2015. > > I'll proceed with importing the converted data into MariaDB, but > existing software won't function unless we get a dead pre-7.0 version > of PHP running (for things like Software Index), or upgrade.third > party software (such as MediaWiki). If the new MediaWiki opens/converts the old tables and works, that's fine, we can live without SoftwareIndex and then upgrade it. But if we loose the wiki, we need probably to think a two-step upgrade. Make an older (how old?) virtual machine, get things working and then upgrade MediaWiki. Keep us updated. Riccardo
Re: gnustep.org has been down for the past few days
We have a problem. All the PHP software, including the old MediaWiki, is so old that it's still using numerous deprecated functions such as the old mysql_*() functions that have been removed from PHP in 2015. I'll proceed with importing the converted data into MariaDB, but existing software won't function unless we get a dead pre-7.0 version of PHP running (for things like Software Index), or upgrade.third party software (such as MediaWiki). On Sun, Sep 4, 2022 at 7:39 PM Ivan Vučica wrote: > > I got all 4 .sql files to load on my local MariaDB. > > Continuing tomorrow. > > On Sun, Sep 4, 2022 at 7:17 PM Ivan Vučica wrote: > > > > I'm doing the barest minimum of the changes. If the original machine > > had MyISAM, I'm using MyISAM. If the installed software was using > > MyISAM, I don't want to find out the hard way that the schemas were > > mis-defined (given that MyISAM has, particularly back in that era, > > been much more liberal with basic concepts such as foreign keys). > > > > I want to minimize the amount of fronts I have to fight MySQL on. I'm > > even thinking of dropping down to latin1 and figuring out what to do > > later. > > > > I would not choose to start with MyISAM (and where possible I'd also > > use Postgres rather than MySQL/MariaDB). > > > > > > > > On Sun, Sep 4, 2022 at 7:13 PM Andreas Fink wrote: > > > > > > why you dont use innodb as engine? much less troubles in case of crashes > > > and reboots > > > > > > > > > > > > On Sonntag, Sept. 04, 2022 at 8:02 PM, Ivan Vučica > > > wrote: > > > 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 > > > wrote: > > > > > > > > > On 2022-08-30 14:28:54 -0700 Ivan Vučica 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 > > > > > >
Re: gnustep.org has been down for the past few days
I got all 4 .sql files to load on my local MariaDB. Continuing tomorrow. On Sun, Sep 4, 2022 at 7:17 PM Ivan Vučica wrote: > > I'm doing the barest minimum of the changes. If the original machine > had MyISAM, I'm using MyISAM. If the installed software was using > MyISAM, I don't want to find out the hard way that the schemas were > mis-defined (given that MyISAM has, particularly back in that era, > been much more liberal with basic concepts such as foreign keys). > > I want to minimize the amount of fronts I have to fight MySQL on. I'm > even thinking of dropping down to latin1 and figuring out what to do > later. > > I would not choose to start with MyISAM (and where possible I'd also > use Postgres rather than MySQL/MariaDB). > > > > On Sun, Sep 4, 2022 at 7:13 PM Andreas Fink wrote: > > > > why you dont use innodb as engine? much less troubles in case of crashes > > and reboots > > > > > > > > On Sonntag, Sept. 04, 2022 at 8:02 PM, Ivan Vučica wrote: > > 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 wrote: > > > > > > On 2022-08-30 14:28:54 -0700 Ivan Vučica 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 > > > >
Re: gnustep.org has been down for the past few days
I'm doing the barest minimum of the changes. If the original machine had MyISAM, I'm using MyISAM. If the installed software was using MyISAM, I don't want to find out the hard way that the schemas were mis-defined (given that MyISAM has, particularly back in that era, been much more liberal with basic concepts such as foreign keys). I want to minimize the amount of fronts I have to fight MySQL on. I'm even thinking of dropping down to latin1 and figuring out what to do later. I would not choose to start with MyISAM (and where possible I'd also use Postgres rather than MySQL/MariaDB). On Sun, Sep 4, 2022 at 7:13 PM Andreas Fink wrote: > > why you dont use innodb as engine? much less troubles in case of crashes and > reboots > > > > On Sonntag, Sept. 04, 2022 at 8:02 PM, Ivan Vučica wrote: > 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 wrote: > > > On 2022-08-30 14:28:54 -0700 Ivan Vučica 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 > >
Re: gnustep.org has been down for the past few days
why you dont use innodb as engine? much less troubles in case of crashes and reboots > On Sonntag, Sept. 04, 2022 at 8:02 PM, Ivan Vučica (mailto:i...@vucica.net)> wrote: > 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 wrote: > > > > On 2022-08-30 14:28:54 -0700 Ivan Vučica 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 > > >
Re: gnustep.org has been down for the past few days
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 wrote: > > On 2022-08-30 14:28:54 -0700 Ivan Vučica 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 >
Re: gnustep.org has been down for the past few days
On 2022-08-30 14:28:54 -0700 Ivan Vučica 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
Re: gnustep.org has been down for the past few days
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. On Mon, Aug 29, 2022 at 9:09 PM Ivan Vučica wrote: > > I've synced the latest backups I have to the server, I've picked up > new ones from our host, and I'm looking at setting up basic services. > > I've stopped now as I got tired, and will resume tomorrow. > > In the meantime, I've left www.gnustep.org pointing to the temporary > redirect, but I have set up A records and CNAMEs pointing to the > existing, deprecated oxymium host: > > - ftp.gnustep.org > - ftpmain.gnustep.org > - wwwmain.gnustep.org > - mediawiki.gnustep.org > > Please note: our current host has kindly done another, *final* export > of MySQL databases. Any future changes will *not* be reflected when I > bring up the services on the new host. I will *not* ask our current > host for a new database export. > > Please also avoid making changes to the site whether via CVS or FTP. > If you do make an upload to FTP (such as a new release), please notify > me explicitly and directly, and ensure you get an acknowledgement from > me. > > Please also note: at least initially (and possibly permanently) the > CVS website edits will not be fetched in the new setup. Likely we'll > switch over to Git. Some services like /softwareindex/ may move to a > subdomain, so we change what portion of our setup depends on PHP. > > > On Sun, Aug 28, 2022 at 10:43 AM Gregory Casamento > wrote: > > > > We have a backup of the wiki data. I am more concerned about just getting > > the actual site up for now. > > > > On Sat, Aug 27, 2022 at 4:45 PM Marco Cawthorne wrote: > >> > >> On 2022-08-27 13:20:04 -0700 Gregory Casamento > >> wrote: > >> > >> > We were being hosted by oxmium, but I believe they took it down. I > >> > am in > >> > the process of redirecting the site to github.io on a temporary basis > >> > until > >> > we devise a more permanent solution. > >> > > >> > GC > >> > >> Thanks for the quick response Gregory. > >> I hope the data is still going to be accessible. I've been using the > >> Wayback Machine for the time being, but it is spotty and things like > >> the Wiki are not all captured. > >> > >> Marco Cawthorne > >> > > > > > > -- > > Gregory Casamento > > GNUstep Lead Developer / OLC, Principal Consultant > > http://www.gnustep.org - http://heronsperch.blogspot.com > > https://www.patreon.com/bePatron?u=352392 - Become a Patron > > https://gf.me/u/x8m3sx - My GNUstep GoFundMe > > https://teespring.com/stores/gnustep - Store
Re: gnustep.org has been down for the past few days
I've synced the latest backups I have to the server, I've picked up new ones from our host, and I'm looking at setting up basic services. I've stopped now as I got tired, and will resume tomorrow. In the meantime, I've left www.gnustep.org pointing to the temporary redirect, but I have set up A records and CNAMEs pointing to the existing, deprecated oxymium host: - ftp.gnustep.org - ftpmain.gnustep.org - wwwmain.gnustep.org - mediawiki.gnustep.org Please note: our current host has kindly done another, *final* export of MySQL databases. Any future changes will *not* be reflected when I bring up the services on the new host. I will *not* ask our current host for a new database export. Please also avoid making changes to the site whether via CVS or FTP. If you do make an upload to FTP (such as a new release), please notify me explicitly and directly, and ensure you get an acknowledgement from me. Please also note: at least initially (and possibly permanently) the CVS website edits will not be fetched in the new setup. Likely we'll switch over to Git. Some services like /softwareindex/ may move to a subdomain, so we change what portion of our setup depends on PHP. On Sun, Aug 28, 2022 at 10:43 AM Gregory Casamento wrote: > > We have a backup of the wiki data. I am more concerned about just getting > the actual site up for now. > > On Sat, Aug 27, 2022 at 4:45 PM Marco Cawthorne wrote: >> >> On 2022-08-27 13:20:04 -0700 Gregory Casamento >> wrote: >> >> > We were being hosted by oxmium, but I believe they took it down. I >> > am in >> > the process of redirecting the site to github.io on a temporary basis >> > until >> > we devise a more permanent solution. >> > >> > GC >> >> Thanks for the quick response Gregory. >> I hope the data is still going to be accessible. I've been using the >> Wayback Machine for the time being, but it is spotty and things like >> the Wiki are not all captured. >> >> Marco Cawthorne >> > > > -- > Gregory Casamento > GNUstep Lead Developer / OLC, Principal Consultant > http://www.gnustep.org - http://heronsperch.blogspot.com > https://www.patreon.com/bePatron?u=352392 - Become a Patron > https://gf.me/u/x8m3sx - My GNUstep GoFundMe > https://teespring.com/stores/gnustep - Store
Re: gnustep.org has been down for the past few days
We have a backup of the wiki data. I am more concerned about just getting the actual site up for now. On Sat, Aug 27, 2022 at 4:45 PM Marco Cawthorne wrote: > On 2022-08-27 13:20:04 -0700 Gregory Casamento > wrote: > > > We were being hosted by oxmium, but I believe they took it down. I > > am in > > the process of redirecting the site to github.io on a temporary basis > > until > > we devise a more permanent solution. > > > > GC > > Thanks for the quick response Gregory. > I hope the data is still going to be accessible. I've been using the > Wayback Machine for the time being, but it is spotty and things like > the Wiki are not all captured. > > Marco Cawthorne > > -- Gregory Casamento GNUstep Lead Developer / OLC, Principal Consultant http://www.gnustep.org - http://heronsperch.blogspot.com https://www.patreon.com/bePatron?u=352392 - Become a Patron https://gf.me/u/x8m3sx - My GNUstep GoFundMe https://teespring.com/stores/gnustep - Store
Re: gnustep.org has been down for the past few days
On 2022-08-27 13:20:04 -0700 Gregory Casamento wrote: We were being hosted by oxmium, but I believe they took it down. I am in the process of redirecting the site to github.io on a temporary basis until we devise a more permanent solution. GC Thanks for the quick response Gregory. I hope the data is still going to be accessible. I've been using the Wayback Machine for the time being, but it is spotty and things like the Wiki are not all captured. Marco Cawthorne
Re: gnustep.org has been down for the past few days
We were being hosted by oxmium, but I believe they took it down. I am in the process of redirecting the site to github.io on a temporary basis until we devise a more permanent solution. GC On Sat, Aug 27, 2022 at 3:22 PM Marco Cawthorne wrote: > I hope everyone is well, > gnustep.org, which includes the wiki and documentation has been down > since Thursday. > > Is this a planned migration that I somehow missed or has something > gone wrong? > > Thanks, > Marco Cawthorne > > > -- Gregory Casamento GNUstep Lead Developer / OLC, Principal Consultant http://www.gnustep.org - http://heronsperch.blogspot.com https://www.patreon.com/bePatron?u=352392 - Become a Patron https://gf.me/u/x8m3sx - My GNUstep GoFundMe https://teespring.com/stores/gnustep - Store
gnustep.org has been down for the past few days
I hope everyone is well, gnustep.org, which includes the wiki and documentation has been down since Thursday. Is this a planned migration that I somehow missed or has something gone wrong? Thanks, Marco Cawthorne
