get a backup of the openlayers blog

[bartvde]

The openlayers blog disappeared without any notice about a year ago, when OSGeo migrated servers. Can we please have a backup of it?

[strk]

Do you remember who did set up the blog ? Or, more specifically, on which machine it was ?

[strk]

I found, on the "projects" VM:

 Aug 12  2014 dev.openlayers.org
 Oct 19  2012 docs.openlayers.org
 Jul 28  2015 openlayers.org

Could it be any of those ? Do you have any search string that could be used to search for it ?

[bartvde]

I don't recall, but you can try searching for Schladming where we had a codesprint and a blog post about it

[ahocevar]

The url of the blog was ​http://openlayers.org/blog/, so that VM from Jul 28, 2015 could be the right one.

It seems to me that the whole old OSGeo box that hosted all OpenLayers stuff was purged about a year ago. Chris Schmidt had set up the blog along with other things a long time ago. So if there is a backup, it should be from a box that is different from the one that hosts some openlayers.org subdomains now.

[strk]

There is no blog/ subdir in the openlayers.org directory though. There's a download dir with versions from 1.0 to 2.13, an api dir with a subdir for each version.

I've found a /var/lib/wordpress directory which has some files under the wp-content/uploeads and one of these files is a screenshot which does show an OpenLayers based map, so maybe the blog was a wordpress blog. A wordpress configuration does exist referencing openlayers, from 2014: config-blog.openlayers.org.php it contains database access informations but there's no mysql daemon running on that host.

BUT, I found what looks like being a dump of the mysql database in Chris Schmidt home ! ol-blog.sql. 2MB of file. I'll send you a link for a direct download @ahocevar, ok ?

[strk]

NOTE: the dump is from September 1st 2010.

[strk]

So url to both the 2010 dump and the 2013-2015 uploads was sent to Andreas and Bart.

But following ​https://wiki.osgeo.org/wiki/SAC_Service_Status#osgeo6 I found this: osgeo6:/var/lib/mysql/openlayers_blog which has a more recent date (wp_posts.MYD has July 10 2015 as a date, looks promising.

[neteler]

I have created a dump (not sure if the right one but it contains data):

mysqldump --user="root" -p openlayers_blog > /tmp/openlayers_blog-osgeo6-20170204.sql_2

ls -la  /tmp/openlayers_blog-osgeo6-20170204.sql_2
-rw-r--r-- 1 root root 23950679 Feb  4 03:32 /tmp/openlayers_blog-osgeo6-20170204.sql_2

[strk]

Thanks Markus ! I wonder why the user/password in /etc/mysql is not being used. Would you be up to write some info about the mysql isntance on ​https://wiki.osgeo.org/wiki/Osgeo6 ?

I sent a download link to Andreas and Bart.

[strk]

I'll close this to assume fixed. Please reopen if you need more.