| anthony_p has quit (Ping timeout: 480 seconds) | 04:50 | |
| anthony_p has quit (Ping timeout: 480 seconds) | 06:17 | |
| gabriel_jetro has quit (Read error: Connection reset by peer) | 09:46 | |
| jelkner has quit (Quit: Leaving) | 11:57 | |
| anthony_p has quit (Ping timeout: 480 seconds) | 14:41 | |
| anthony_p | was playing around with trying to connect gnucash to a postgresql database hosted on mayfirst, and i have a successful workaround | 15:48 |
|---|---|---|
| anthony_p | creating an ssh tunnel on the local machine enables an encrypted tunnel from local into the mayfirst network, allowing you to forward port 5432 requests between your local machine and the remote network | 15:49 |
| anthony_p | i successfully connected to it using the gnucash application, then used the psql cli locally to confirm that gnucash created the tables for an initial connection/setup | 15:51 |
| anthony_p | my steps were as follows | 15:56 |
| anthony_p | 1) log in to https://members.mayfirst.org/cp/index.php to enable ssh access | 15:56 |
| anthony_p | 2) create tunnel in terminal: ssh -L 5432:psql002.mayfirst.cx:5432 aphillips@shell.mayfirst.org | 15:56 |
| anthony_p | 3) start gnucash and open a postgresql database connection using Host:localhost | Database: nwd_gnucash | Username: nwd_gnucash | Password: ***** | 15:56 |
| anthony_p | i also put these details in bitwarden | 16:00 |
| jelkner has quit (Quit: Leaving) | 16:56 | |
| anthony_p has quit (Quit: anthony_p) | 17:49 | |
| freena has quit (Quit: Connection closed for inactivity) | 17:57 | |
| dcammue has quit (Read error: Connection reset by peer) | 18:53 | |
| dcammue has quit (Ping timeout: 480 seconds) | 19:10 | |
| thomasboimah | Good afternoon resl, and Good evening dcammue | 19:46 |
| dcammue | Good evening thomasboimah | 19:46 |
| thomasboimah | !agenda | 20:05 |
| Websterss | No active meeting and no meeting ID provided. | 20:05 |
| thomasboimah | !list | 20:05 |
| Websterss | **Scheduled Meetings:** | 20:05 |
| thomasboimah | !agenda t68p | 20:06 |
| Websterss | **Agenda for 'T68P - NWD June 2nd Weekly Meeting'** [⏸ INACTIVE - Use !add T68P <item> to add items] | 20:06 |
| Websterss | 4. [I4] SJC fundraising campaign for cleaning co-op app? (by: jelkner) | 20:06 |
| jelkner | !list | 20:28 |
| Websterss | **Scheduled Meetings:** | 20:28 |
| jelkner | !agenda T68P | 20:28 |
| Websterss | **Agenda for 'T68P - NWD June 2nd Weekly Meeting'** [⏸ INACTIVE - Use !add T68P <item> to add items] | 20:28 |
| Websterss | 4. [I4] SJC fundraising campaign for cleaning co-op app? (by: jelkner) | 20:28 |
| dcammue has quit (Ping timeout: 480 seconds) | 20:52 | |
| thomasboimah | Good afternoon jelkner ! | 20:53 |
| jelkner | Good evening thomasboimah! | 20:56 |
| thomasboimah | Good afternoon anthony_p! | 20:59 |
| anthony_p | good afternoon thomasboimah | 20:59 |
| jelkner | thomasboimah, anthony_p successfully tested connecting to postgres on May First using ssh tunneling | 21:00 |
| anthony_p | resl was able to get in too | 21:01 |
| jelkner | sweet | 21:01 |
| jelkner | anthony_p, my next question would be about how you configured our users | 21:02 |
| jelkner | we found docs that indicated creating a gnucash user with no-login | 21:02 |
| anthony_p | no user configuration, just use the db user | 21:02 |
| jelkner | and then having users you want to access the database inherit the permissions from that user | 21:02 |
| jelkner | the db user? | 21:03 |
| jelkner | i can ask thomasboimah to help with me with this tomorrow | 21:03 |
| thomasboimah | That's good to know, I look into that before but at that time we decided not to transfer our guncash postgres data to mayfirst, it will give a bit of headache to user who don't use to the terminal by establishing the tunneling through the terminal before accessing the database through guncash | 21:03 |
| anthony_p | when you create a database in mayfirst, it creates a user with the same name as the database, and you just use that username to connect | 21:04 |
| thomasboimah | so we decide to just let the setup on webschool.sjcompute.org to be like that instead moving it to mayfirst | 21:04 |
| jelkner | right thomasboimah | 21:04 |
| jelkner | but that was for proof of concept | 21:04 |
| jelkner | now we are looking at going into production | 21:04 |
| jelkner | so we should think about how to do that on may first | 21:05 |
| anthony_p | you don't need to use terminal, putty can create a tunnel as well, and you can export/import putty configurations | 21:05 |
| thomasboimah | Sound good to me | 21:05 |
| thomasboimah | anthony_p, do you have access to the webschool.sjcompute.org server, where the current guncash data is, for the four co-op: jetroweb, novaweb, secosol and sjcompute? Just asking maybe you will want to backup that data's and transfer to the new postgres guncash data on mayfirst. | 21:09 |
| thomasboimah | *database | 21:10 |
| anthony_p | i don't have access | 21:10 |
| thomasboimah | Can can't create unix used for you now to have access if you want.. | 21:11 |
| thomasboimah | *I | 21:11 |
| thomasboimah | I Can create unix used for you now to have access if you want.. | 21:11 |
| thomasboimah | I Can create unix user for you now to have access if you want.. | 21:11 |
| thomasboimah | Sorry for typo ;-( | 21:11 |
| anthony_p | to do a backup and restore of the databases, it's easiest to have root access or access to the account that controls postgresql, to do a full dump and then import that into the new database | 21:12 |
| jelkner | anthony_p, thomasboimah can set you up with an admin user | 21:13 |
| jelkner | and you can do whatever you need to on the machine to access the databases | 21:13 |
| thomasboimah | anthony_p, this is how the current setup look like on webschool: https://codeberg.org/tboimah/Document/src/branch/main/gnucash_postgresql_setup.md | 21:13 |
| anthony_p | root level access makes sure that the dump includes any metadata about databases that a user created for the database doesn't necessarily see | 21:13 |
| thomasboimah | user inherit their permission from the non-login user guncash | 21:14 |
| thomasboimah | If you want i can create both unix user and database user for you.. | 21:14 |
| jelkner | Nice thomasboimah! | 21:14 |
| jelkner | good docs | 21:15 |
| anthony_p | a sudo unix user and a postgresql user would probably be best for doing a backup and restore to a new location | 21:15 |
| dcammue has quit (Ping timeout: 480 seconds) | 21:15 | |
| anthony_p | but i'm not sure that the postgresql user in mayfirst will have all the same permissions, it's definitely not a superuser | 21:16 |
| thomasboimah | nice than like make create that now for, what you will like your username be? | 21:16 |
| thomasboimah | *let | 21:16 |
| thomasboimah | *me | 21:16 |
| anthony_p | they have to limit permissions to make sure users can't mess with other people's databases since its hosted in a shared instance of postgresql | 21:17 |
| thomasboimah | yep! | 21:17 |
| anthony_p | and it looks like there are 4 databases there? each one would have to be it's own instance in mayfirst | 21:18 |
| anthony_p | one for jetroweb, one for sjcompute, and one for secosol | 21:19 |
| thomasboimah | anthony_p, each of this co-op have the own membership on Mayfirst, so we can used them | 21:21 |
| thomasboimah | *their | 21:21 |
| anthony_p | yep | 21:21 |
| anthony_p | if you go to jetro on mayfirst add "aphillips" to hosting order access i should be able to set up and test and move the data | 21:24 |
| anthony_p | after getting access to webschool | 21:26 |
| thomasboimah | sure, what you will like your username to be on webschool? | 21:26 |
| anthony_p | aphillips | 21:26 |
| anthony_p | but just to clarify, you cannot create roles in a mayfirst postgresql database, we don't have access to pg_roles | 21:32 |
| anthony_p | everyone uses the same login information | 21:33 |
| jelkner | i'm wondering if this will meet our collaboration needs | 21:35 |
| jelkner | if dcammue and i want to look over the books together | 21:36 |
| jelkner | can we both access the data at the same time? | 21:36 |
| anthony_p | multiple people can have it open at the same time | 21:36 |
| jelkner | cool | 21:36 |
| anthony_p | i had it open at the same time rachel did | 21:36 |
| anthony_p | but if someone edits it, then everyone has to reload because gnucash doesn't watch for changes | 21:36 |
| anthony_p | basically it just loads the entire database when connecting. if you open it with intention to edit and see someone else has it open, you should open in read only | 21:39 |
| dcammue | And in that way, one person should only has edit permission and the others give themselves read permission | 21:40 |
| anthony_p | but i just checked the nova one and saw all the work resl has been doing today while she's still in there editing it. i refreshed the connection after a few minutes and it updated with all the changes made | 21:40 |
| dcammue | to avoid data conflict | 21:40 |
| anthony_p | that's the problem dcammue, there can only be one user total and there username is the same as the database name | 21:40 |
| anthony_p | there wont be a dcammue user | 21:40 |
| anthony_p | there will be a gnucash or jetro_gnucash user | 21:41 |
| anthony_p | the application will tell you if it's already got a connection open when you try to connect, so you know not to edit | 21:41 |
| dcammue | sure | 21:42 |
| anthony_p | gotta use communication channels to figure out who it is and what they're doing | 21:42 |
| dcammue | sure | 21:43 |
| anthony_p | a web interface allowing for users to log in, and use just a single database user backup would resolve it, but i don't know if gnucash has that intent or how hard it would be to reverse engineer it into a web app | 21:43 |
| jelkner | !help | 21:48 |
| Websterss | Little Webster - Meeting Bot Commands: | 21:48 |
| Websterss | !stop - Deactivate active meeting | 21:48 |
| Websterss | !add [id] <item> - Add agenda item (any meeting) | 21:48 |
| Websterss | !agenda [id] - Show agenda with item IDs and status | 21:48 |
| Websterss | !remove <id> - Remove agenda item by ID (e.g., I1) | 21:48 |
| Websterss | !sethost <nick> - Change meeting host | 21:48 |
| Websterss | !finish - End and delete active meeting | 21:48 |
| Websterss | !delete - Delete any meeting by ID/name | 21:48 |
| Websterss | Type !help <command> for details (e.g., !help add) | 21:48 |
| thomasboimah | anthony_p, please check you private chat | 21:52 |
| thomasboimah | *your | 21:52 |
| klarios | !agenda | 21:54 |
| Websterss | No active meeting and no meeting ID provided. | 21:54 |
| resl | !listmeetings | 21:55 |
| resl | !list | 21:55 |
| Websterss | **Scheduled Meetings:** | 21:55 |
| resl | !agenda T68P | 21:55 |
| Websterss | **Agenda for 'T68P - NWD June 2nd Weekly Meeting'** [⏸ INACTIVE - Use !add T68P <item> to add items] | 21:55 |
| Websterss | 4. [I4] SJC fundraising campaign for cleaning co-op app? (by: jelkner) | 21:55 |
| jelkner | smohamud, where in jitsi too | 21:58 |
| smohamud | ok | 21:58 |
| resl | For who is here, let's do +1 ? | 21:59 |
| jelkner | !start T68P | 21:59 |
| Websterss | Meeting 'T68P - NWD June 2nd Weekly Meeting' is now active! | 21:59 |
| thomasboimah | +1 | 22:00 |
| klarios | +1 | 22:00 |
| resl | +1 | 22:00 |
| jelkner | +1 | 22:00 |
| zOnny | +1 | 22:00 |
| smohamud | +1 | 22:00 |
| anthony_p | +1 | 22:01 |
| smohamud has quit (Remote host closed the connection) | 22:01 | |
| smohamud | dc'd | 22:03 |
| resl | thomasboimah: I really like that we call it "the boot" | 22:04 |
| smohamud has quit (Remote host closed the connection) | 22:04 | |
| smohamud | i can hear now. | 22:07 |
| resl | Notes: report on the problem with SECOSOL's delay in reimbursing Kei for some costs that were fronted to Kei in the meantime from NWD; should be no issues with this soon as SECOSOL takes over its responsibilities to Kei. | 22:12 |
| resl | Tony proposes we discuss basic allocation of resources. | 22:12 |
| smohamud has quit (Remote host closed the connection) | 22:15 | |
| resl | Jeff suggests that Daniel do full time business administration for NWD. Rachel suggests NWD continue getting its books in order and then revisit whether it makes sense for us to offload some of that work to Daniel. In the meantime, Daniel is surely busy getting the books in order for Jetro, so we can co-learn these things and stay in close communication. | 22:16 |
| resl | Rachel notes that Kei has been doing a lot of administrative work to help with the work Rachel is also doing, which includes accounting, but also lots of other work. Kei's 10 hours per week is very precious and Rachel is happy to continue doing the admin work with Kei's help. | 22:17 |
| resl | Jeff reminds us to decide some basic allocation of resources structure. Rachel asks Tony to make a proposal. Tony proposes: Revenue can be split as a baseline, 25% for operations, 75% for developers | 22:19 |
| resl | Question: In the step after the basic allocation, do the circles/teams then divide the work and pay among themselves? Answer: Yep | 22:22 |
| smohamud has quit (Ping timeout: 480 seconds) | 22:23 | |
| resl | Question: Do we need to pay anyone outside of the team? | 22:24 |
| resl | Does it make sense to break down the revenue by proportion after a certain point? For example, if we do a job that makes 200k, would it really make sense to pay 50k to the administration and operations for that work? | 22:26 |
| resl | Answer: It's not that we are paying people outside of the team. It is that we are dividing the work among ourselves, so we want to divide the pay accordingly. | 22:27 |
| smohamud_ | Ok, so why don't we just pay people as they work at rates we agree as non-dev work comes along or is anticipated? I figure we can allocate, but if that means a Dev is working and that allocated money has run out, we would keep the non-dev money frozen? If both types of work are ongoing, do we not dip into one set of funds? I'm trying to understand the actual purpose of splitting it in the first place - I view us all | 22:32 |
| smohamud_ | as just workers/labor. | 22:32 |
| resl | Jeff proposes: Let's reduce the items on the agenda so we can focus on the business planning/financial items this time. | 22:33 |
| resl | Rachel suggests we finish the first proposal and then move on to the next. Jeff suggests we do a reactions round first for this first proposal re: allocation of revenue. | 22:34 |
| smohamud_ | Ok I misunderstood the proposal... I'm good for now. | 22:34 |
| smohamud_ | Won't talk out of turn again. | 22:34 |
| resl | Reactions: This is good! Good start. Rachel thinks it's generous for the admin and still hopefully is good for the developers. Kei agrees and says it had worked relatively well in the past. Sahnun feels like this is a way to protect certain members of the team. But he thinks for now he needs to think on it. | 22:36 |
| resl | Thomas feels like it is a fine proposal (thomasboimah did I hear that correctly?) | 22:36 |
| thomasboimah | +1 | 22:37 |
| klarios | answer from kei to smohamud_ : +1 smohamud_ Ive done it both ways in the coop before (hourly and 25%) the 25% works great to account for hourly costs and also state tax, federal tax, etc. if we account for just hourly, we wont have enough to cover those | 22:37 |
| zOnny | +1 | 22:38 |
| klarios | +1 I consent | 22:38 |
| jelkner | +1 | 22:38 |
| dcammue | +1 | 22:38 |
| smohamud_ | +1 consent | 22:38 |
| thomasboimah | +1 | 22:38 |
| anthony_p | +1 | 22:38 |
| resl | +1 | 22:38 |
| resl | Proposal passes. There is 22 minutes left for the meeting. Jeff's next proposal: let's postpone items 1 and 3 and go to item 4 | 22:39 |
| smohamud_ | thanks Kei | 22:39 |
| klarios | +1 | 22:39 |
| resl | +1 | 22:39 |
| jelkner | +1 | 22:39 |
| smohamud_ | +1 | 22:39 |
| anthony_p | +1 | 22:39 |
| zOnny | +1 | 22:39 |
| resl | Jeff reviews (jelkner, a different?) proposal: There will be funding coming in from a few different sources, including a grant and revenue. Sahnun might get paid for his first 3 months in Kenya. How do we want to launch the business? There is enough revenue for us to develop the application for the cleaning cooperatives. Jeff thinks it is a great opportunity to do things for the solidarity economy. | 22:41 |
| resl | Item 4 on the agenda is: SJC fundraising campaign for cleaning co-op app | 22:42 |
| resl | Rachel asks the question: can we wait to make this decision until we get more organized and clarify things like membership in NWD vs. Jetro, the hours we can have of Zonny's development time, and the hours we can have of Kei's time, for example? | 22:47 |
| resl | Rachel asks: Is Sahnun's pay from Jeff relevant to NWD's resources, in that, is that Sahnun's full time for three months that Jeff is effectively granting to NWD? | 22:48 |
| resl | Tony asks anthony_p - can you write a summary of your question here? | 22:48 |
| resl | Kei asks: Is the proposal that the remaining 5k from SJC is used to support NWD as we as a team build the cleaning cooperative platform? | 22:49 |
| resl | Jeff answers: Regarding the question about Jetro--we can't legally employ Daniel and Thomas. But we treat them as members of our team socially. The financials would be that NWD pays Jetro as contractors when we want their help on work. | 22:50 |
| resl | Sahnun's payment is not going to come out of NWD's checking account, but he will receive a grant from Social Justice Computing and he will be able to do work with NWD if he chooses to do that in that time. | 22:51 |
| anthony_p | It was mentioned that we could use some of the funds about working on the potential cleaning cooperative application, I asked if it we should have a deeper discussion about the cleaning cooperative project before trying to determine how to disburse any funds related to work related to the cleaning cooperative app. | 22:52 |
| resl | Jeff answers a question about freelance saying Yes we will find work (jelkner I'm confused what you are answering here, but noted) | 22:53 |
| smohamud_ | resl: Is this round for QnA only? | 22:53 |
| resl | Tony clarifies that he had said that there are ways to find work from job posting boards and things like that. Jeff says he thinks that sounds good. Tony asks, Do we want someone in admin to do that? | 22:54 |
| resl | smohamud_: yes | 22:54 |
| smohamud_ | +1 | 22:54 |
| resl | Jeff says, Are we ready for that? | 22:54 |
| resl | Rachel says we are almost ready for that! For right now, the work the developers are finding is great because the developers know what they can and want to do, and can therefore sell that to clients. But very soon, folks in admin like Rachel will understand our strengths, availability, and processes well enough to sell our work actively. | 22:56 |
| resl | Jeff notes that this is a big discussion so perhaps we should continue it next week. Jeff can't make the regular scheduled meeting next week but wants to discuss more. | 22:57 |
| resl | Sahnun suggests we have another interim meeting before next week, especially given Jeff will be away in Liberia soon. | 22:57 |
| smohamud_ | +1 | 22:58 |
| klarios | +1 | 22:58 |
| jelkner | +1 | 22:58 |
| anthony_p | +1 | 22:58 |
| resl | +1 | 22:58 |
| resl | Zonny facilitates next meeting | 23:01 |
| jelkner | !help | 23:01 |
| Websterss | Little Webster - Meeting Bot Commands: | 23:01 |
| Websterss | !stop - Deactivate active meeting | 23:01 |
| Websterss | !add [id] <item> - Add agenda item (any meeting) | 23:01 |
| Websterss | !agenda [id] - Show agenda with item IDs and status | 23:01 |
| Websterss | !remove <id> - Remove agenda item by ID (e.g., I1) | 23:01 |
| Websterss | !sethost <nick> - Change meeting host | 23:01 |
| Websterss | !finish - End and delete active meeting | 23:01 |
| Websterss | !delete - Delete any meeting by ID/name | 23:01 |
| jelkner | !stop | 23:01 |
| Websterss | Type !help <command> for details (e.g., !help add) | 23:01 |
| Websterss | Meeting 'T68P' is no longer active. | 23:01 |
| Websterss | Use !start to start it again later. | 23:01 |
| jelkner | !list | 23:01 |
| Websterss | **Scheduled Meetings:** | 23:01 |
| jelkner | !delete T68P | 23:02 |
| Websterss | Meeting 'T68P - NWD June 2nd Weekly Meeting' has been permanently deleted. | 23:02 |
| jelkner | !list | 23:02 |
| Websterss | **Scheduled Meetings:** | 23:02 |
| jelkner | !delete 4P2M | 23:02 |
| Websterss | Only the meeting host (klarios_) or a channel operator can delete this meeting. | 23:02 |
| jelkner | thomasboimah, i can't delete klarios's old meeting | 23:02 |
| jelkner | and forget to ask her about that | 23:03 |
| jelkner | it says a channel opp can do that | 23:03 |
| thomasboimah | Yep, I am working on the permission | 23:03 |
| jelkner | got you | 23:03 |
| jelkner | no rush | 23:03 |
| jelkner | see you tomorrow morning | 23:03 |
| thomasboimah | so the an OP can't any meeting | 23:03 |
| thomasboimah | *that | 23:03 |
| jelkner | nice | 23:03 |
| jelkner | thanks! | 23:03 |
| jelkner has quit (Quit: Leaving) | 23:03 | |
| klarios has quit (Remote host closed the connection) | 23:05 | |
| thomasboimah has quit (Quit: Leaving) | 23:06 | |
| dcammue has quit (Remote host closed the connection) | 23:24 | |
| smohamud_ has quit (Quit: Leaving) | 23:35 | |
Generated by irclog2html.py 2.17.3 by Marius Gedminas - find it at https://mg.pov.lt/irclog2html/!