[SAC] mysql admin account on osgeo6

I'm trying to produce a dump of the openlayers_blog mysql database
on osgeo6 but the username/password found in the systemwide configuration
doesn't seem to work. Did anyone change some credentials there or knows
how to win a battle against mysql ? (I try to stay away from it...)

NOTE: this is for https://trac.osgeo.org/osgeo/ticket/1861

--strk;

On Sat, Feb 4, 2017 at 12:27 PM, Sandro Santilli <strk@kbt.io> wrote:

I'm trying to produce a dump of the openlayers_blog mysql database
on osgeo6 but the username/password found in the systemwide configuration
doesn't seem to work. Did anyone change some credentials there or knows
how to win a battle against mysql ? (I try to stay away from it...)

Using the "root" user it worked, at least it exported something. See
in the ticket.

NOTE: this is for https://trac.osgeo.org/osgeo/ticket/1861

Markus

--
Markus Neteler
http://www.mundialis.de - free data with free software
http://grass.osgeo.org
http://courses.neteler.org/blog

On Sat, Feb 04, 2017 at 12:34:34PM +0100, Markus Neteler wrote:

On Sat, Feb 4, 2017 at 12:27 PM, Sandro Santilli <strk@kbt.io> wrote:
> I'm trying to produce a dump of the openlayers_blog mysql database
> on osgeo6 but the username/password found in the systemwide configuration
> doesn't seem to work.

Using the "root" user it worked, at least it exported something.

Yep, looks like working, but... where did you find the password ?
It would be good to document the configuration somewhere, a great
starting point could be https://wiki.osgeo.org/wiki/Osgeo6

I've stubbed a "mysql" section there, if you have any useful info.

BTW: should the table in ProjectsVM also be updated adding
"moved to osgeo6" labels in the "comments" column ?
According to the [Osgeo6 section](https://wiki.osgeo.org/wiki/SAC_Service_Status#osgeo6)
in ServiceStatus page, only "grass.osgeo.org", "grasswiki.osgeo.org"
and "dev.openlayrs.org" were moved. Is that information useful at all ?
Or we could turn that section into a simple link to the dedicated OSgeo page.

--strk;

On Sat, Feb 4, 2017 at 12:57 PM, Sandro Santilli <strk@kbt.io> wrote:

On Sat, Feb 04, 2017 at 12:34:34PM +0100, Markus Neteler wrote:

On Sat, Feb 4, 2017 at 12:27 PM, Sandro Santilli <strk@kbt.io> wrote:
> I'm trying to produce a dump of the openlayers_blog mysql database
> on osgeo6 but the username/password found in the systemwide configuration
> doesn't seem to work.

Using the "root" user it worked, at least it exported something.

Yep, looks like working, but... where did you find the password ?

Well, I/we used it in the past years :slight_smile: because the GRASS GIS Wiki is
also managed on that server in mysql.

It would be good to document the configuration somewhere, a great
starting point could be https://wiki.osgeo.org/wiki/Osgeo6

I've stubbed a "mysql" section there, if you have any useful info.

I didn't really configured it, probably Martin S did so (or Martin L).
But that's up & running since osgeo6 exists.

BTW: should the table in ProjectsVM also be updated adding
"moved to osgeo6" labels in the "comments" column ?
According to the [Osgeo6 section](https://wiki.osgeo.org/wiki/SAC_Service_Status#osgeo6)
in ServiceStatus page, only "grass.osgeo.org", "grasswiki.osgeo.org"
and "dev.openlayrs.org" were moved. Is that information useful at all ?

Not qute, it is rather confusing at time.

Or we could turn that section into a simple link to the dedicated OSgeo page.

+1

Markus

On Sat, Feb 04, 2017 at 03:19:16PM +0100, Markus Neteler wrote:

On Sat, Feb 4, 2017 at 12:57 PM, Sandro Santilli <strk@kbt.io> wrote:

> BTW: should the table in ProjectsVM also be updated adding
> "moved to osgeo6" labels in the "comments" column ?
> According to the [Osgeo6 section](https://wiki.osgeo.org/wiki/SAC_Service_Status#osgeo6)
> in ServiceStatus page, only "grass.osgeo.org", "grasswiki.osgeo.org"
> and "dev.openlayrs.org" were moved. Is that information useful at all ?

Not qute, it is rather confusing at time.

> Or we could turn that section into a simple link to the dedicated OSgeo page.

+1

SAC_Service_Status#osgeo6 turned to a simple link to dedicated Osgeo6 page,
where I've added the missing available services. I guess in the long run
it would be good for each service to have its own page, and have it linked
from the page dedicated to the machine (virtual or real) hosting it.

There's still a lot of confusing/old info in that page, any volunteer to
clean things up more ?

--strk;