Opened 7 years ago

Closed 7 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


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, 7 years ago

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

comment:2 by strk, 7 years ago

I found, on the "projects" VM:

 Aug 12  2014
 Oct 19  2012
 Jul 28  2015

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

comment:3 by bartvde, 7 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, 7 years ago

Cc: ahocevar added

comment:5 by ahocevar, 7 years ago

The url of the blog was, 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 subdomains now.

comment:6 by strk, 7 years ago

There is no blog/ subdir in the 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: 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, 7 years ago

NOTE: the dump is from September 1st 2010.

comment:8 by strk, 7 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 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, 7 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, 7 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 ?

I sent a download link to Andreas and Bart.

comment:11 by strk, 7 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.