#1861: get a backup of the openlayers blog
---------------------------+-------------------
Reporter: bartvde | Owner: sac@…
Type: task | Status: new
Priority: normal | Milestone:
Component: Systems Admin | Keywords:
---------------------------+-------------------
The openlayers blog disappeared without any notice about a year ago, when
OSGeo migrated servers. Can we please have a backup of it?
--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/1861>
OSGeo <http://www.osgeo.org/>
OSGeo committee and general foundation issue tracker.
#1861: get a backup of the openlayers blog
---------------------------+--------------------
Reporter: bartvde | Owner: sac@…
Type: task | Status: new
Priority: normal | Milestone:
Component: Systems Admin | Resolution:
Keywords: |
---------------------------+--------------------
Comment (by strk):
Do you remember who did set up the blog ? Or, more specifically, on which
machine it was ?
--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/1861#comment:1>
OSGeo <http://www.osgeo.org/>
OSGeo committee and general foundation issue tracker.
#1861: get a backup of the openlayers blog
---------------------------+--------------------
Reporter: bartvde | Owner: sac@…
Type: task | Status: new
Priority: normal | Milestone:
Component: Systems Admin | Resolution:
Keywords: |
---------------------------+--------------------
Comment (by 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 ?
--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/1861#comment:2>
OSGeo <http://www.osgeo.org/>
OSGeo committee and general foundation issue tracker.
#1861: get a backup of the openlayers blog
---------------------------+--------------------
Reporter: bartvde | Owner: sac@…
Type: task | Status: new
Priority: normal | Milestone:
Component: Systems Admin | Resolution:
Keywords: |
---------------------------+--------------------
Comment (by bartvde):
I don't recall, but you can try searching for Schladming where we had a
codesprint and a blog post about it
--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/1861#comment:3>
OSGeo <http://www.osgeo.org/>
OSGeo committee and general foundation issue tracker.
#1861: get a backup of the openlayers blog
---------------------------+--------------------
Reporter: bartvde | Owner: sac@…
Type: task | Status: new
Priority: normal | Milestone:
Component: Systems Admin | Resolution:
Keywords: |
---------------------------+--------------------
Changes (by bartvde):
* cc: ahocevar (added)
--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/1861#comment:4>
OSGeo <http://www.osgeo.org/>
OSGeo committee and general foundation issue tracker.
#1861: get a backup of the openlayers blog
---------------------------+--------------------
Reporter: bartvde | Owner: sac@…
Type: task | Status: new
Priority: normal | Milestone:
Component: Systems Admin | Resolution:
Keywords: |
---------------------------+--------------------
Comment (by 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.
--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/1861#comment:5>
OSGeo <http://www.osgeo.org/>
OSGeo committee and general foundation issue tracker.
#1861: get a backup of the openlayers blog
---------------------------+--------------------
Reporter: bartvde | Owner: sac@…
Type: task | Status: new
Priority: normal | Milestone:
Component: Systems Admin | Resolution:
Keywords: |
---------------------------+--------------------
Comment (by 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 ?
--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/1861#comment:6>
OSGeo <http://www.osgeo.org/>
OSGeo committee and general foundation issue tracker.
#1861: get a backup of the openlayers blog
---------------------------+--------------------
Reporter: bartvde | Owner: sac@…
Type: task | Status: new
Priority: normal | Milestone:
Component: Systems Admin | Resolution:
Keywords: |
---------------------------+--------------------
Comment (by strk):
NOTE: the dump is from September 1st 2010.
--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/1861#comment:7>
OSGeo <http://www.osgeo.org/>
OSGeo committee and general foundation issue tracker.
#1861: get a backup of the openlayers blog
---------------------------+--------------------
Reporter: bartvde | Owner: sac@…
Type: task | Status: new
Priority: normal | Milestone:
Component: Systems Admin | Resolution:
Keywords: |
---------------------------+--------------------
Changes (by strk):
* cc: martin (added)
Comment:
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.
--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/1861#comment:8>
OSGeo <http://www.osgeo.org/>
OSGeo committee and general foundation issue tracker.
#1861: get a backup of the openlayers blog
---------------------------+--------------------
Reporter: bartvde | Owner: sac@…
Type: task | Status: new
Priority: normal | Milestone:
Component: Systems Admin | Resolution:
Keywords: |
---------------------------+--------------------
Comment (by 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
}}}
--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/1861#comment:9>
OSGeo <http://www.osgeo.org/>
OSGeo committee and general foundation issue tracker.
#1861: get a backup of the openlayers blog
---------------------------+--------------------
Reporter: bartvde | Owner: sac@…
Type: task | Status: new
Priority: normal | Milestone:
Component: Systems Admin | Resolution:
Keywords: |
---------------------------+--------------------
Comment (by 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.
--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/1861#comment:10>
OSGeo <http://www.osgeo.org/>
OSGeo committee and general foundation issue tracker.
#1861: get a backup of the openlayers blog
---------------------------+---------------------
Reporter: bartvde | Owner: sac@…
Type: task | Status: closed
Priority: normal | Milestone:
Component: Systems Admin | Resolution: fixed
Keywords: |
---------------------------+---------------------
Changes (by strk):
* status: new => closed
* resolution: => fixed
Comment:
I'll close this to assume fixed. Please reopen if you need more.
--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/1861#comment:11>
OSGeo <http://www.osgeo.org/>
OSGeo committee and general foundation issue tracker.