2020-09-21 GnuCash IRC logs

01:14:25 *** fell has quit IRC
01:15:45 *** fell has joined #gnucash
01:15:45 *** ChanServ sets mode: +o fell
01:16:36 *** o01eg has quit IRC
01:29:57 *** sbluhm has joined #gnucash
01:38:43 *** bertbob has quit IRC
01:42:13 *** bertbob has joined #gnucash
01:42:14 *** ChanServ sets mode: +v bertbob
01:58:04 *** bertbob has quit IRC
01:59:42 *** bertbob has joined #gnucash
01:59:43 *** ChanServ sets mode: +v bertbob
02:00:11 *** geo has joined #gnucash
02:02:02 *** JayC has quit IRC
02:24:22 *** bertbob has quit IRC
02:25:34 *** bertbob has joined #gnucash
02:25:35 *** ChanServ sets mode: +v bertbob
02:32:49 *** puck has quit IRC
02:40:00 *** puck has joined #gnucash
03:16:34 *** Mechtilde has joined #gnucash
03:42:42 *** hussam has quit IRC
04:05:53 *** gjanssens has joined #gnucash
04:05:53 *** gncbot sets mode: +o gjanssens
04:05:53 *** ChanServ sets mode: +o gjanssens
04:14:35 *** jw4 has quit IRC
04:15:19 *** jw4 has joined #gnucash
04:15:19 *** ChanServ sets mode: +v jw4
04:41:44 *** Aussie_matt has quit IRC
04:47:52 *** Mechtilde has quit IRC
04:55:31 *** Mechtilde has joined #gnucash
05:11:31 *** andreas^ has joined #gnucash
05:11:31 *** ChanServ sets mode: +v andreas^
05:12:12 <andreas^> hello.
05:18:04 *** storyjesse has joined #gnucash
05:24:22 <andreas^> I'm interested in joining this project.
05:24:39 <andreas^> I'm reading the wiki right now.
06:08:32 *** User has joined #gnucash
06:08:57 *** Aussie_matt has joined #gnucash
06:39:41 *** storyjesse has quit IRC
07:05:46 *** hussam has joined #gnucash
07:05:46 *** ChanServ sets mode: +v hussam
07:15:52 *** ramontjunior has joined #gnucash
07:47:15 <warlord> andreas^, welcome aboard.
07:47:33 <andreas^> hi warlord.
07:47:48 <andreas^> I'm not quite sure what project to join yet but this is a candidate.
07:50:18 <warlord> there is a huge learning curve; GnuCash is a huge project with a lot of code (and a lot of technical debt which makes the code harder to parse)
07:52:07 *** JayC has joined #gnucash
07:52:07 *** ChanServ sets mode: +v JayC
07:55:16 <andreas^> warlord: can you explain more about that?
07:56:30 <warlord> what do you need explained?
07:57:09 <andreas^> warlord: that about the learning curve. what I could expect.
07:57:44 <warlord> Depends how well you know C, C++, Gtk, Scheme, etc.
07:57:46 <andreas^> I have background in C and JS but I haven't done coding for a larger project yet.
07:58:52 <warlord> JS wont help you; it's not something we use.
07:58:58 <warlord> The majority of the code is C and C++
07:59:30 <andreas^> warlord: do you use Qt?
08:00:01 <warlord> no, we use Gtk
08:00:36 <andreas^> warlord: do you require me to run non free JS? for instance github.
08:01:02 <warlord> I dont understand the question
08:01:15 <warlord> We don't use JavaScript
08:01:35 <andreas^> warlord: do you use a site for important things which run non free JS?
08:02:35 <andreas^> I mean if there are tools you have to use which run non free JS.
08:03:04 <warlord> MOST of the stuff we run is self-hosted, however we do use GitHub for public code contributions (although you're welcome to submit patches via Bugzilla instead of a GitHub PR)
08:03:25 <warlord> .. however the current devs prefer a github PR
08:03:46 <andreas^> just to let you know I don't run non free JS.
08:03:54 <andreas^> just making clear if that's a problem.
08:04:05 <warlord> It may turn into a problem for you.
08:04:36 <warlord> patches sent in via bugzilla get lower priority than PRs, only because conversations around the proposed patches are harder to do.
08:06:43 <warlord> You do need to git clone out of github.
08:07:05 <warlord> (only authorized devs have access to the master git repo)
08:08:21 <andreas^> I will have to send in via bugzilla.
08:08:49 <andreas^> A git clone is possible without accessing the web site in a web browser.
08:09:02 <andreas^> don't see how that would be a problem.
08:13:22 <warlord> once jralls wakes up, or if gjanssens is around, they can answer you more definitively.
08:16:03 <andreas^> ok.
08:16:07 <andreas^> thanks.
08:19:17 *** andreas^ has quit IRC
08:19:34 *** andreas^ has joined #gnucash
08:19:34 *** ChanServ sets mode: +v andreas^
09:12:01 *** fell has quit IRC
09:12:04 *** fell_laptop has joined #gnucash
09:12:04 *** ChanServ sets mode: +o fell_laptop
09:41:04 *** fell_laptop has quit IRC
10:12:17 *** Aussie_matt has quit IRC
10:15:28 *** clawson has joined #gnucash
10:16:03 *** clawson has quit IRC
10:16:34 *** fell_laptop has joined #gnucash
10:16:34 *** ChanServ sets mode: +o fell_laptop
10:18:29 *** Agfarmer18 has joined #gnucash
10:26:21 *** fell_laptop is now known as fell
10:29:17 *** Mechtilde has quit IRC
10:32:11 *** Agfarmer18 has quit IRC
10:32:24 *** Agfarmer18 has joined #gnucash
10:43:48 *** andreas^ has quit IRC
10:45:04 *** andreas^ has joined #gnucash
10:45:04 *** ChanServ sets mode: +v andreas^
10:45:08 <andreas^> hello.
10:45:41 <andreas^> I wonder where to start to code on this program.
10:54:42 *** sbluhm has quit IRC
10:57:29 *** geo has quit IRC
11:04:57 *** michaelheuss has joined #gnucash
11:05:28 *** michaelheuss has left #gnucash
11:05:39 <warlord> andreas^, first place to start is to clone the sources and build it.
11:06:07 *** wondernewbie has joined #gnucash
11:10:25 <wondernewbie> I've got a question. I am using Mac. I want to use gnucash with a mysql back end. I see a guide for Linux on how to install drivers and set it up - having trouble locating the same type of thing for mac.I do have mysql up and running, a user with correct permissions and a blank target DB - but attempting to get this going complains about corrupt data. Any suggestions/guidance you can give me?
11:11:57 *** sbluhm has joined #gnucash
11:11:57 *** ChanServ sets mode: +v sbluhm
11:17:49 <warlord> wondernewbie, you need to build the libdbi mysql driver (libdbd-mysql) and install it. Most people use something like MacPorts or Brew to get that driver built.
11:20:12 *** sbluhm has quit IRC
11:44:39 *** TownsendHardware has joined #gnucash
11:45:24 *** guak has joined #gnucash
11:56:55 <wondernewbie> Thank you, warlord. I think I am good to go
11:56:57 *** wondernewbie has quit IRC
12:00:50 *** o01eg has joined #gnucash
12:32:39 *** Agfarmer18 has quit IRC
12:38:42 *** sbluhm has joined #gnucash
12:38:42 *** ChanServ sets mode: +v sbluhm
12:43:11 *** sbluhm has quit IRC
12:49:53 *** jw4 has quit IRC
12:52:08 *** andreas^ has quit IRC
12:53:04 *** jw4 has joined #gnucash
12:53:04 *** ChanServ sets mode: +v jw4
12:59:01 *** ArtGravity has joined #gnucash
12:59:01 *** ChanServ sets mode: +v ArtGravity
13:00:56 *** guak has quit IRC
13:01:58 *** guak has joined #gnucash
13:04:56 <ArtGravity> @jralls Thanks for the reply to my mysql character set question on Friday. My database was created a long time ago, when mysql still defaulted to latin1 encoding.
13:04:56 <gncbot> ArtGravity: Error: "jralls" is not a valid command.
13:04:57 <gncbot> ArtGravity: Sent 2 days, 19 hours, and 59 minutes ago: <jralls> It should be utf8 (meaning utf8mb3) already. The only way it would be Latin1 would be if you created it by hand and pointed GnuCash at it afterwards.
13:05:31 <jralls> ArtGravity, I'm on a zoom right now, I'll be with you in a bit.
13:05:42 <ArtGravity> NP & TY
13:26:19 *** sbluhm has joined #gnucash
13:26:19 *** ChanServ sets mode: +v sbluhm
13:26:21 *** Hamaryns has joined #gnucash
13:26:21 *** ChanServ sets mode: +v Hamaryns
13:32:59 *** jervin has joined #gnucash
13:37:41 *** keiffer has joined #gnucash
13:43:47 <jralls> ArtGravity, doesn't matter how old it is. GnuCash has *always* done the CREATE DATABASE with CHARACTER SET utf8. If it's really latin1 then you did something wrong.
13:45:51 <ArtGravity> Fair enough. It was created around 7 years ago, which makes it difficult to recall what I did, although I expect that I used phpmyadmin to create an empty DB and user and then pointed gnucash at it.
13:46:50 <ArtGravity> Is it possible to save the data in another format from gnucash and reload an empty database from gnucash using Save As?
13:48:58 <jralls> You could actually just load your db and then do a save as with a different db name, but that will get you utf8mb3. I suppose that you want mb4 so that you can put emojis in the text fields.
13:49:40 <jralls> https://stackoverflow.com/questions/6115612/how-to-convert-an-entire-mysql-database-characterset-and-collation-to-utf-8 tells you how to convert the existing database.
13:49:50 <ArtGravity> I don't care so much about emojis, but MySQL 8.0 uses utf8mb4 as its new default, and I would like to upgrade from 5.7
13:50:53 <jralls> The default doesn't really matter and if you don't use any non-ascii it *really* doesn't matter.
13:53:19 <ArtGravity> I'm mostly concerned about the possible impact of smaller character length limits on certain field types caused by utf8mb4
13:53:35 *** guak has quit IRC
14:13:21 <jralls> The issue would be exceeding the overall record size of 64K (which is also the max VARCHAR size). The largest fields are 2K characters (8K bytes), but they're VARCHARS so the actual value decides how much space it takes. 2k characters is a *lot*. I doubt very much that you have anything to worry about.
14:20:39 *** jervin has quit IRC
14:29:02 <jralls> The other thing to remember is that utf8 is itself a variable length encoding: ASCII encodes in 1 byte and all western languages in 2 bytes. Doesn't matter if the encoding is utf8mb3 or utf8mb4; the only thing the latter changes is that it's able to handle the supplementary multilingual plane whose primary use to normal people is emoji.
14:31:23 *** Mechtilde has joined #gnucash
14:33:37 <jralls> The only change in stored string length will happen if you have actually managed to store some accented French/German/Spanish characters in Latin1. Those characters, and *only* those characters, will change to 2 bytes.
14:42:26 *** frakturfreak has joined #gnucash
14:42:26 *** ChanServ sets mode: +v frakturfreak
14:47:37 *** frakturfreak has quit IRC
14:55:20 *** Mechtilde has quit IRC
15:03:04 *** frakturfreak has joined #gnucash
15:03:04 *** ChanServ sets mode: +v frakturfreak
15:22:06 <ArtGravity> Thanks @jralls. That is quite helpful. I'll be sure to run backups using mysqldump before updating the charset/collation settings and then testing on MySQL 5.7 before running another set of backups and performing the upgrade to MySQL 8.0.
15:22:25 *** iduno8912 has joined #gnucash
15:22:25 *** ChanServ sets mode: +v iduno8912
15:23:35 <iduno8912> is there a way to make the lines of a report alternating fill colors so it is easier to read? I've poured over the report settings with no luck.
15:24:23 *** frakturfreak has quit IRC
15:25:32 *** Joe has joined #gnucash
15:27:06 <jralls> iduno8912 https://www.w3.org/Style/Examples/007/evenodd.en.html I think you'll need the css-based stylesheet to make that work.
15:28:58 <Joe> I'm having trouble connecting to a postgresql databases. I was able to connect to a local running instance but I can't get it to work with a remote host. (I'm running postgresql + pgadmin in a docker container). The trace log only shows:
15:29:01 <Joe> ```* 13:22:36 ERROR <gnc.backend.dbi> [GncDbiBackend<Type>::session_begin()] Unable to connect to database 'gnucash'
15:29:02 <Joe> * 13:22:50 ERROR <gnc.engine.sx> gnc_sx_get_sxes_referencing_account: assertion 'sxactions != NULL' faile```
15:29:20 <Joe> And the postgresql log doesn't report any connection attempt
15:31:09 <jralls> Joe: Not real familiar with dockers but I think that they're sandboxed. You need to configure them to be able to talk to the outside world. You'll probably get further using the pgsql command-line tool to connect to the server.
15:32:33 <Joe> Yeah I connect to it using psql
15:32:52 <Joe> So it should be okay with incoming connections from the outside
15:33:42 <jralls> Is gnucash in the docker or is the pgsql server?
15:34:52 <Joe> The postgres database is hosted using the docker container
15:35:03 <Joe> gnucash is running locally
15:35:27 <jralls> And psql is also running locally?
15:35:57 <Joe> Yes
15:37:18 <jralls> Try running gnucash with --log gnc.backend.dbi=debug for more messages about connection progress.
15:37:42 *** guak has joined #gnucash
15:43:24 <iduno8912> jralls thanks for the link. Is there any plan to make reports configurable to be more human readable without CSS?
15:44:07 <jralls> iduno8912 No.
15:44:11 *** frakturfreak has joined #gnucash
15:44:11 *** ChanServ sets mode: +v frakturfreak
15:45:35 <iduno8912> bummer
15:46:15 *** Hamaryns has quit IRC
15:46:32 <Joe> Uploaded file: https://uploads.kiwiirc.com/files/175612f2df6901fab64931213cefbf0b/pasted.txt
15:46:55 <Joe> ^ trace files with additional log files
15:50:31 <jralls> does the roll you're supplying have CREATE ALL on the server?
15:51:43 <jralls> s/roll/role/
15:54:31 <jralls> Joe^
15:57:38 <Joe> Yeah it does. I'm able to manage the server and access the database using pgadmin hosted in a linked container
15:58:20 <Joe> The user is a superuser
16:01:48 *** ramontjunior has quit IRC
16:06:23 <jralls> What is the uri you're passing to psql? Is it the same as the one to gnucash?
16:06:48 <jralls> Maybe the other way around would be more useful...
16:11:11 *** User has quit IRC
16:17:23 *** gjanssens has quit IRC
16:20:00 *** PowaBanga has quit IRC
16:22:55 *** PowaBanga has joined #gnucash
16:22:57 <Joe> I'm so sorry, I'm so dumb. I forgot that it was running on a different port to avoid conflict with the local posgres instance
16:23:30 <jralls> That will do it. ;-)
16:24:59 <Joe> Thanks for your help though!
16:42:11 *** angel has joined #gnucash
16:55:03 *** Robert847 has joined #gnucash
17:01:33 *** sbluhm has quit IRC
17:01:41 *** Robert847 has left #gnucash
17:01:57 *** Robert847 has joined #gnucash
17:02:30 *** Robert847 has left #gnucash
17:03:11 *** Robert847 has joined #gnucash
17:04:03 *** Robert847 has left #gnucash
17:04:36 *** frakturfreak has quit IRC
17:06:06 *** Robert847 has joined #gnucash
17:08:36 *** David has quit IRC
17:08:41 *** David has joined #gnucash
17:08:51 <Robert847> Am I able to talk?
17:09:25 *** angel has quit IRC
17:14:09 <Robert847> I need some advice about getting the price of the NYSE stock LUMN(Lumen Technologies, Inc.), which used to be known as CTL(CenturyLink, Inc.) until last Friday. It seems that Yahoo is confused too. Do I haveto create a new security and go through a Sell>Buy routine, or can I just change the name in my data file?
17:16:19 *** chautelly has joined #gnucash
17:16:19 *** ChanServ sets mode: +v chautelly
17:17:01 *** Joe has quit IRC
17:27:27 <jralls> Robert847, change the symbol in Tools>Security Editor.
17:28:41 <jralls> Robert847, if they changed the number of shares you can use the Stock Split assistant to make the adjustment.
17:29:57 *** David has quit IRC
17:30:02 *** David has joined #gnucash
18:06:29 <Robert847> We shall see if Yahoo as JSON can provide the price tonight when I try to retrieve prices.
19:03:04 *** chautelly has quit IRC
19:06:43 *** Aussie_matt has joined #gnucash
19:15:53 *** chautelly has joined #gnucash
19:18:13 *** jervin has joined #gnucash
19:56:15 *** ArtGravity has quit IRC
20:37:06 *** guak has quit IRC
22:11:17 *** jervin has quit IRC
22:57:17 *** jervin has joined #gnucash
22:59:08 *** jervin has quit IRC
23:07:04 *** iduno8912 has left #gnucash
23:21:33 *** chautelly has quit IRC
23:40:41 *** bertbob has quit IRC
23:42:19 *** bertbob has joined #gnucash
23:42:20 *** ChanServ sets mode: +v bertbob
23:55:58 <Robert847> For the record, with the name changed in Tools>Security Editor GnuCash was able to download the September 21 price. Also, Yahoo is still fixing things. Now the price es for September 18 ad 21 can be found under both tickers CTL and LUMN. Some history is starting to appear under LUMN.
23:59:07 *** Robert847 has left #gnucash