Talk:SAC Meeting 2017-11-23

From OSGeo
Revision as of 16:23, 23 November 2017 by Robe (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search


New Website Status Report

As Jody mentioned left over items in contract

 - 3.3.2.19 [https://trac.osgeo.org/osgeo/ticket/2038 Integration existing LDAP registry, installation and
  configuration]
 - 3.3.2.21 Installation and technical support after launching website
 - 3.3.2.22 Monitoring and reporting after launching website


Conclusion - Alex and Jody were not in attendance so punted for this meeting

Gitea / Gogs Upgrade Status

  • strk whitelisted winnie.postgis.net and debbie.postgis.net.
  • robe confirmed she can do an ldap query check on winnie.postgis.net deb9 vm

Transcript

   20:02:29		* cvvergara here
   20:03:44	robe2:	all ready
   20:04:04	robe2:	cvvergara I put on the list about OSGeoLive split in trac
   20:04:28	robe2:	though sadly neither martin nor dbb is around which should be the actors in this drama
   20:05:09	robe2:	I'll start off with new website - which sadly wildintellect isn't here to discuss - https://lists.osgeo.org/pipermail/sac/2017-November/008923.html
   20:05:10	sigabrt:	Title: [SAC] Fwd: component 2 review (at lists.osgeo.org)
   20:05:37	robe2:	presumably there are several thingks left open on the contract with GetInteractive, which to me seem like they should all fall under SAC
   20:05:56	robe2:	so not sure why they are even in the contract and would be holding up anything
   20:06:05	robe2:	strk you know anything about this?
   20:07:00	cvvergara:	Maybe Jody knows, but I don't see him around
   20:07:01	robe2:	last note about it - https://lists.osgeo.org/pipermail/sac/2017-November/008929.html
   20:07:02	sigabrt:	Title: [SAC] Fwd: component 2 review (at lists.osgeo.org)
   20:07:07	robe2:	strk are you away?
   20:07:11	robe2:	awake
   20:07:35	robe2:	cvvergara nah Jody said he had no clue, it was in the contract
   20:07:52	cvvergara:	Who has a copy of the contract?
   20:08:13	robe2:	Jody does, though let me see if he gave me right to it
   20:08:53	robe2:	nah I still don't have rights t the doc he listed -- do you - https://docs.google.com/spreadsheets/d/1RItHzHM4Ltl5UiWSH_LQRPetQdMD4sQa9LX_tYG5IpQ/edit?usp=drive_web
   20:08:54	sigabrt:	Title: Google Sheets - create and edit spreadsheets online, for free. (at docs.google.com)
   20:09:10	robe2:	ping strk
   20:09:35	robe2:	anyway guess, we can revisit that one since no one who knows anything about it is here
   20:10:11	cvvergara:	No I cant access either
   20:11:22	robe2:	next topic OSGeoLive split cvvergara you know where dbb left off on that
   20:12:01	robe2:	last I spoke with him he had the backup of the database, but didn't want to fuss with the trac configs and didn't know if he had rights to. He doesn't have sudo to trac vm
   20:12:24	robe2:	If strk were awake, we could probably have him create the new trac and hand back to Brian (dbb)
   20:12:33	robe2:	but it seems strk is again in never never land
   20:13:14	robe2:	strk fire fire!
   20:13:15	cvvergara:	No, I haven't seen dbb
   20:14:00	robe2:	he's probably celebrating thanks giving. We had thanks giving brunch and then dumped relatives on the plane and said bur bye
   20:14:02	cvvergara:	BTW ... i can connect to staging
   20:14:26	robe2:	https://staging.www.osgeo.org
   20:14:27	sigabrt:	Title: Homepage - OSGeo (at staging.www.osgeo.org)
   20:14:29	cvvergara:	might not be LDAP, because I use a password that I used when the site was on getinteractive
   20:14:34	robe2:	can you log in okay with your web account
   20:14:40	robe2:	no LDAP isn't set up yet
   20:14:58	jef:	isn't thanksgiving a us only thing?
   20:15:35	robe2:	that's one of my ticket items - https://trac.osgeo.org/osgeo/ticket/2038
   20:15:36	sigabrt:	Title: #2038 (LDAP integration in Wordpress for new web site) – OSGeo (at trac.osgeo.org)
   20:16:02	robe2:	jef yah and I was talking to strk a couple of minutes ago so he can't use that as an excuse anyway
   20:16:20	robe2:	but wildintellect can
   20:16:35	robe2:	martin just happened to have a business meeting at same time
   20:17:09	cvvergara:	Q, when people register with LDAP, will they have access to everything? Can de modify anything?
   20:17:17	robe2:	cvvergara can you login with the account getInteractive setup for you. You should
   20:17:32	cvvergara:	I can, and I can see dashboard
   20:18:13	robe2:	cvvergara no we can setup groups and things -- we just have to decide on best plugin to use for wordpress https://wordpress.org/plugins/search/openldap/
   20:18:45	robe2:	as you can see there are several options. the server itself can talk to osgeo ldap since I ssh into the box with my osgeo ldap account
   20:19:16	cvvergara:	I know my son has some experience with wordpress, let me ask him
   20:19:22	robe2:	I got getinteractive to give my account admin rights so I can install and experiment
   20:20:02	robe2:	I know enough to install wordpress and walk away from it :)
   20:20:25	robe2:	and fix broken plugins
   20:22:18	robe2:	next topic is drone and gitea which sadly need strk for that
   20:22:27	strk:	what do you need fire on ?
   20:22:44	cvvergara:	on a turkey ;)
   20:22:48	strk:	I'm here now, but only fun things please, I'm not ready to work yet
   20:22:50	robe2:	on my side I have gitea installed -- https://winnie.postgis.net/gitea for experimentation but got stuck getting LDAP configured
   20:22:53	strk:	no thanksgiving here
   20:23:15	strk:	robe2: I'll give you Gogs admin if you promise not to break things, how do you like that ?
   20:23:22	strk:	then you can check the LDAP configuration there
   20:23:25	cvvergara:	502 bad gateway on that link
   20:23:38	strk:	OR I give you directly the instructions by reading from the Gogs config
   20:23:45	strk:	OR you should have that config in the Gogs DB actually
   20:23:51	strk:	you have a dump of that DB don't you ?
   20:23:54	robe2:	strk yah I did all that
   20:24:02	robe2:	but I think winnie's ip has to be whitelisted somewhere
   20:24:13	strk:	I did that, I though
   20:24:14	robe2:	though it appears I just broke my gitea install somehow
   20:24:23	strk:	do you have ldap client tools installed ?
   20:24:33	strk:	to check if ldap can be queried from commandline (ldapsearch)
   20:24:49	strk:	apt-get install ldapscripts
   20:25:11		* strk didn't understand we were in a meeting
   20:25:19	strk:	is the meeting over already or in progress ?
   20:25:27	cvvergara:	we are in progress
   20:26:04		* strk looks at agenda, where are we ? website status done ?
   20:26:50	robe2:	strk yah website status wildintellect no input
   20:27:09	cvvergara:	yeah, and LDAP connection missing
   20:27:10	robe2:	the issue I raised is there are all these things in contract that seem like SAC responsibility
   20:27:17	robe2:	like configuring LDAP for wordpress
   20:27:33	robe2:	strk meeting in progress
   20:27:44	strk:	is there a ticket for that part already ?
   20:27:48	robe2:	other topic was the OSGeoLive split from osgeo trac
   20:27:58	robe2:	can you set up a skeleton trac for dbb
   20:27:58	strk:	to setup LDAP on wordpress
   20:28:10	robe2:	so he can port over osgeo live tickets to it
   20:28:42	robe2:	strk yah to setup LDAP on word press and we have these options - https://wordpress.org/plugins/search/openldap/
   20:28:44	cvvergara:	trac # 2038
   20:28:46	strk:	ok, I read Discussion tab - those things are pending on Jody and Alex - we should send an email to them, Cc sac, with requesting more
   20:28:47	robe2:	none of which are installed
   20:29:05	strk:	3.3.2.19 seems to suggest it's up to getInteractive to set that up ?
   20:29:05	robe2:	strk it's all already in sac mailing list
   20:29:19	strk:	ok so let's move on, sorry for the redundancy
   20:29:29	robe2:	strk no problem
   20:29:29	strk:	sysadmin contract, same thing ? alex missing ?
   20:29:38	strk:	martin is also missing...
   20:29:40	robe2:	so you have sudo to trac vm right can can spin up a new trac
   20:29:48	strk:	yes can do
   20:30:01	strk:	was there a ticket for that too ?
   20:30:04	robe2:	okay lets start with that so I feel like we have some accomplishments
   20:30:14	robe2:	strk I think so somewhere
   20:30:16	strk:	that part does not need a meeting
   20:30:52	strk:	https://trac.osgeo.org/osgeo/query?status=assigned&status=new&status=reopened&component=Trac&col=id&col=summary&col=status&col=type&col=priority&col=milestone&col=component&order=priority
   20:30:54	sigabrt:	Title: Custom Query – OSGeo (at trac.osgeo.org)
   20:31:01	strk:	no ticket - cvvergara please file a ticket about that
   20:31:20	cvvergara:	OK
   20:31:20	robe2:	strk you are right good call
   20:31:34	strk:	component: trac
   20:31:49	strk:	dbb also not here, while I understand he wanted to do that
   20:32:19	strk:	https://wiki.osgeo.org/wiki/Trac#Creating_a_trac_instance
   20:32:20	sigabrt:	Title: Trac - OSGeo (at wiki.osgeo.org)
   20:33:15	robe2:	strk does one need sudo rights to create a trac instance?
   20:33:30	robe2:	he can log in to the box but neither him nor I have sudo rights to trac
   20:33:37	robe2:	I should have sudo rights shouldn't I?
   20:34:01	robe2:	strk okay my gitea service is back up - https://winnie.postgis.net/gitea/
   20:34:02	sigabrt:	Title: Gitea: Git with a cup of tea (at winnie.postgis.net)
   20:34:09	strk:	probably
   20:34:27	robe2:	so as I was saying I put in the LDAP config copied from gogs database
   20:34:32	strk:	I created trac_osgeolive db and dump/restored trac_osgeo into it
   20:35:10	cvvergara:	Q component trac?
   20:36:03	cvvergara:	https://trac.osgeo.org/osgeo/ticket/2039#ticket
   20:36:05	sigabrt:	Title: #2039 (trac vm right can can spin up a new trac for OSGeoLive) – OSGeo (at trac.osgeo.org)
   20:36:08	strk:	Project Name [My Project]>
   20:36:10	robe2:	but it just hangs and I can't do an ldap query from winnie's deb9 so I think it needs to be whitelisted somewhere - https://trac.osgeo.org/osgeo/ticket/2037
   20:36:11	sigabrt:	Title: #2037 (winnie.postgis.net and postgis.net whitelisted for LDAP) – OSGeo (at trac.osgeo.org)
   20:36:29	robe2:	I know martin did some sort of change on ldap.osgeo.org to allow staging.www.osgeo.org to do ldap queries
   20:36:35	robe2:	but have no idea what he changed
   20:36:46	strk:	I did do the whitelist
   20:36:52	strk:	as mentioned in the corresponding ticket
   20:37:02	robe2:	strk and you were both simultaneously doing it
   20:37:16	robe2:	you and martin I mean strk
   20:38:13	strk:	no trace of martin in that ticket though
   20:38:41	strk:	so cvvergara what should OSGeoLive project name be ? "OSGeoLive" isfine ?
   20:38:46	robe2:	so you want to whitelist winnie and debbie? I don't think I have sudo rights to ldap.osgeo.org
   20:38:55	cvvergara:	Yes that is now the official name of the project
   20:38:56	strk:	I did, supposedly
   20:39:08	robe2:	you did? when?
   20:39:37	robe2:	strk ah sorry didn't see that
   20:39:41	robe2:	okay let me try again
   20:42:15	robe2:	strk okay I think I've got something misconfigured so I'll check later
   20:42:25	robe2:	giving me a different error from what I remember.
   20:43:25	robe2:	oh wait it's working now I think
   20:43:58	robe2:	but I have to check on gitea, so I think that's set since I can do getent passwd martin on winnie's deb9 and see martin's full name
   20:48:02	robe2:	oh strk for doing upgrade of gogs to gitea. I was going to take the current one and all the repos and see if I can resetup up on deb9
   20:48:04	strk:	cvvergara: https://trac.osgeo.org/osgeolive
   20:48:06	sigabrt:	Title: OSGeo (at trac.osgeo.org)
   20:48:21	robe2:	I don't know if I can do a backup of gogs using the gogs backup tool if I don't have sudo rights
   20:48:36	robe2:	I was able to take a backup of the postgresql database fine with my minimal rights on trac
   20:48:49	strk:	cvvergara: I made you an admin, please head to https://trac.osgeo.org/osgeolive/admin/general/perm and tweak them further
   20:49:18	cvvergara:	got it
   20:49:23	cvvergara:	thanks
   20:49:23	robe2:	strk so looks like you took backup of the osgeo one right
   20:49:44	robe2:	so dbb and cvvergara will have to delete all the stuff they don't need right
   20:50:18	cvvergara:	right, I will tell dbb
   20:50:39	strk:	robe2: yes, is a clone of the osgeo trac
   20:50:46	cvvergara:	and in osgeo trac, we can close all the OSGeoLive tickets
   20:51:08	strk:	let's first cleanup the new one, then we cleanup the old one
   20:51:27	cvvergara:	Ok
   20:51:35	strk:	uhm, it doesn'tlook like the repostiory canbe removed, dunno why
   20:51:54	strk:	https://trac.osgeo.org/osgeolive/admin/versioncontrol/repository <-- "default" is not selectable
   20:53:41	robe2:	strk bj0rn[m] is bj0rn[m] kinda stuck without our new osgeo7 setup?
   20:53:54	robe2:	stuck I mean for gitlab
   20:53:58	robe2:	that he's waiting for that
   20:54:30	robe2:	I'm wondering if we were going to configure it as a docker image anyway if we can configure the docker first and then move it on osgeo7 when ready
   20:54:36	strk:	osgeolive discussion moved to #osgeolive
   20:55:48	robe2:	cvvergara isn't even in osgeolive
   20:56:05	robe2:	I just wrote status of what you did there strk
   20:56:37	robe2:	next topic GeoForAll DNS
   20:56:45	robe2:	does anyone know anything about that?
   20:56:53	cvvergara:	I am in osgeolive
   20:57:19	cvvergara:	(in theory I am part of the PSC)
   20:57:38	robe2:	sorry stupid me I was on osgeo-live
   20:57:55	robe2:	and I saw both jmckenna and strk so I thought that was real :(
   20:58:08	robe2:	it's #osgeolive
   20:58:34	jmckenna:	weird, not sure why i was in there :)
   20:58:40	cvvergara:	yes no dash... (I started the standarizng the name)
   20:59:57	strk:	note that the names with dashes are granted special permissions to be owned by the "OSGeo" group now registered on Freenode
   21:00:00	robe2:	yah jmckenna it was all your fault. If I saw no one in the room, I would have known I was in the wrong room
   21:00:11		* cvvergara I just sent a mail to the OSGeoLive team
   21:00:12	jmckenna:	robe2: ha!
   21:00:14	strk:	just in case you'll want to move one day
   21:00:26	strk:	#osgeo-<anything>, that is
   21:00:36	jmckenna:	strk: perfect
   21:02:15		* cvvergara thanks strk for the trac for OSGeoLive
   21:04:08	robe2:	cvvergara let me know if you want to purge stuff from the db for you
   21:04:19	robe2:	or I guess dbb can do that
   21:05:36	cvvergara:	dbb was kind of eager to do it, so I think. So first lets ask him if he wants/can do it otherwise we can step in
   21:06:22	robe2:	cvvergara sounds good to me was thinking that too
   21:07:20	strk:	maybe you can change the logo meanwhile :)
   21:07:26	strk:	and those other estetic things
   21:07:34	strk:	anyway, next agenda item ?
   21:08:58		* cvvergara I am leaving for a conference after this meeting, back on Moday night, but I will
   21:09:12	cvvergara:	*monday
   21:10:57	robe2:	next agendy is the GeoForAll
   21:11:18	robe2:	strk you know anything about that dns transfer
   21:13:40	robe2:	strk GeoForAll have any input on that?
   21:14:17	robe2:	I think that's the last agenda item
   21:14:34	robe2:	other stuff like migrating off old hard-ware probably needs Alex present to discuss
   21:14:54	robe2:	overall a very productive meeting thanks to strk :)
   21:16:54	strk:	no input on GeoForAll
   21:17:06	robe2:	do you have control of our DNS?
   21:17:08	strk:	we need that contract moved
   21:17:25	strk:	I think I connected to the DNS console only once, right after finding the password for it
   21:17:29	strk:	to check it was valid
   21:17:34	robe2:	contract moved?
   21:17:39	strk:	moved on
   21:17:47	strk:	we need a contractor sysadmin to do these things
   21:17:51	strk:	all of them
   21:18:02	strk:	it cannot take so long to close a contract
   21:18:19	robe2:	ah okay so that would be martin I presume which has been passed off to board for approval right
   21:18:47	strk:	I hope so
   21:19:05	strk:	anyway, I'm happy to give you access to the DNS credentials too
   21:19:30	robe2:	actually status says sent up to treasurer, so I presume it is pretty close to being a done deal with martin
   21:19:46	robe2:	strk is that in one of our secure folders
   21:20:12	robe2:	speaking of which I still need to add mysql root password to that once I dig up that email
   21:20:38	robe2:	anyway we'll need more than DNS console for transfer
   21:20:57	jmckenna:	i was also wondering if i have DNS credentials...but that is not related to transfer
   21:21:04	jmckenna:	offtopic :)
   21:21:12	robe2:	will need the registrara access or is that associated with DNS
   21:21:18	robe2:	one and the same you use for both?
   21:22:19	robe2:	jmckenna this GeoForAll are they with a different regist and need to move the domain over to what OSGeo uses as well? so not a simple DNS change
   21:23:01	robe2:	while we are off topic http://2018.foss4g.org where is that being hosted? doesn't have ssl
   21:23:02	sigabrt:	Title: FOSS4G 2018 (at 2018.foss4g.org)
   21:23:08	jmckenna:	right. i was referring to a change needed for the march code sprint, a DNS a record change i believe.
   21:23:25	robe2:	so when I do https://postgis.net (the image causes page to say some content is not secure)
   21:23:26	sigabrt:	Title: PostGIS Spatial and Geographic Objects for PostgreSQL (at postgis.net)
   21:23:57	strk:	robe2: it's in the secure folder, yes
   21:24:04	jmckenna:	i believe 2018 is being hosted by local committee, on their server
   21:24:30	strk:	robe2: ticket that please
   21:24:46	strk:	(ssl missing on 2018.foss4g.org)
   21:25:08	jmckenna:	2018 ticket: https://trac.osgeo.org/osgeo/ticket/1883 refers to external IP
   21:25:09	sigabrt:	Title: #1883 (Request for 2018.foss4g.org) – OSGeo (at trac.osgeo.org)
   21:25:18	robe2:	strk it's already ticketed - https://trac.osgeo.org/osgeo/ticket/2008
   21:25:19	sigabrt:	Title: #2008 (FOSS4G 2018 Registration Page) – OSGeo (at trac.osgeo.org)
   21:27:17	robe2:	strk something bad just happened
   21:27:31	robe2:	all our tickets are gone
   21:27:49	robe2:	you sure osgeolive wasn't still pointing at osgeo
   21:28:35		* cvvergara have to go, they came to pick me up... strk if you can do the DELETE I would appreciate very much
   21:28:50	robe2:	cvvergara so were you deleting anything?
   21:28:58	robe2:	looks like osgeo tickets dissappeared
   21:29:12	robe2:	so I think maybe osgeolive was pointing at same db
   21:31:35	jmckenna:	yikes!
   21:33:22	robe2:	weird the configs look right on both have different databases
   21:33:31	strk:	ops
   21:33:40	strk:	don't touch osgeolive db please
   21:34:08	robe2:	I won't
   21:34:13	robe2:	I see it still has everything
   21:35:43	robe2:	strk well it's good to know that you are fallable :)
   21:36:10	robe2:	fallible
   21:37:50	robe2:	let me know if you need my help
   21:38:58	robe2:	strk speaking of changes, also should add OSGeoLive to this page - https://trac.osgeo.org/
   21:38:59	sigabrt:	Title: OSGeo Trac Instances (at trac.osgeo.org)
   21:39:08	strk:	I restored "ticket" and "tickets_change" tables from trac_osgeolive back to trac_osgeo
   21:39:23	strk:	now to do revisions and repository
   21:39:24	robe2:	I presume that is controlled by that .txt file I can't edit
   21:42:35	strk:	osgeo trac should be back alive
   21:42:42	strk:	any change in this time window was gone though
   21:42:55	strk:	bad failure, told you I shouldn't have been working
   21:43:49	robe2:	I think the only change I did was to https://trac.osgeo.org/osgeo/ticket/2008 which I reput in after you restored
   21:43:50	sigabrt:	Title: #2008 (FOSS4G 2018 Registration Page SSL) – OSGeo (at trac.osgeo.org)
   21:44:03	robe2:	hmm maybe I closed the other ticket. Okay let me check what I did
   21:44:41	robe2:	strk you ready to close this - https://trac.osgeo.org/osgeo/ticket/2039
   21:44:42	sigabrt:	Title: #2039 (trac vm right can can spin up a new trac for OSGeoLive) – OSGeo (at trac.osgeo.org)
   21:46:48	strk:	I'd close only after cleanup is completed
   21:47:01	robe2:	strk I thought you did that already
   21:47:25	robe2:	strk you probably should go to sleep. You've accomplished so much already. Better not jinx it
   21:47:32	robe2:	meeting adjourned
Retrieved from "http://wiki.osgeo.org/w/index.php?title=Talk:SAC_Meeting_2017-11-23&oldid=111152"