| 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 | |
Generated by irclog2html.py 2.17.3 by Marius Gedminas - find it at https://mg.pov.lt/irclog2html/!