Opened 8 years ago

Closed 8 years ago

#1861 closed task (fixed)

get a backup of the openlayers blog

Reported by: bartvde Owned by: sac@…
Priority: normal Milestone:
Component: SysAdmin Keywords:
Cc: ahocevar, martin

Description

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

Change History (11)

comment:1 by strk, 8 years ago

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

comment:2 by strk, 8 years ago

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 ?

comment:3 by bartvde, 8 years ago

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

comment:4 by bartvde, 8 years ago

Cc: ahocevar added

comment:5 by ahocevar, 8 years ago

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.

comment:6 by strk, 8 years ago

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 ?

comment:7 by strk, 8 years ago

NOTE: the dump is from September 1st 2010.

comment:8 by strk, 8 years ago

Cc: martin added

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.

comment:9 by neteler, 8 years ago

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

comment:10 by strk, 8 years ago

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.

comment:11 by strk, 8 years ago

Resolution: fixed
Status: newclosed

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

Note: See TracTickets for help on using tickets.