Talk:SAC Meeting 2017-11-23

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