2018-03-19 GnuCash IRC logs
00:03:14 *** mipesom has quit IRC
00:04:13 *** mipesom has joined #gnucash
00:26:27 *** kael has quit IRC
01:04:31 *** darshan has joined #gnucash
01:14:12 *** Robert1 has quit IRC
01:15:13 *** Robert has joined #gnucash
01:17:22 *** Robert has left #gnucash
01:50:10 *** storyjesse has quit IRC
02:04:30 *** Mechtilde has joined #gnucash
02:09:20 *** Mechtilde has quit IRC
02:16:30 *** Mechtilde has joined #gnucash
02:17:42 <Mechtilde> .
02:30:16 *** fell_afk is now known as fell
02:31:41 <fell> Moin
02:43:52 *** fell has quit IRC
02:45:03 *** fell has joined #gnucash
02:47:56 *** darshan has quit IRC
02:52:22 *** Mechtilde has quit IRC
03:03:37 *** gncbot sets mode: +o fell
03:06:24 *** mipesom has quit IRC
03:23:19 *** mipesom has joined #gnucash
03:28:12 *** fekepp has quit IRC
04:31:42 *** fabior has joined #gnucash
04:58:14 *** pilotauto has quit IRC
05:56:37 *** fekepp has joined #gnucash
06:00:43 *** fekepp has quit IRC
06:02:19 *** fekepp has joined #gnucash
06:03:21 *** fabior has quit IRC
06:16:07 *** kus has joined #gnucash
06:17:36 *** fabior has joined #gnucash
06:22:58 *** fabior has quit IRC
06:33:51 *** jwngfu has joined #gnucash
06:35:21 *** fekepp has quit IRC
06:35:22 *** fekepp has joined #gnucash
07:00:57 *** g5pw has quit IRC
07:01:12 *** g5pw has joined #gnucash
07:07:08 *** fabior has joined #gnucash
07:14:17 *** chris has joined #gnucash
07:35:08 *** fabior has quit IRC
07:38:03 *** chris has quit IRC
07:51:23 *** darshan has joined #gnucash
07:57:47 *** warlord has quit IRC
08:04:22 *** PaulW2U has joined #gnucash
08:05:15 *** chris has joined #gnucash
08:07:30 *** chris has quit IRC
08:10:26 *** kus has quit IRC
08:12:15 *** chris has joined #gnucash
08:36:07 *** warlord has joined #gnucash
08:49:16 *** darshan has quit IRC
08:55:27 <lmat> jralls: Glad you found the problem! That sounds like it may be easy enough to correct.
08:56:15 <lmat> And I see that a release notice went out for 2.7.7.
08:57:31 <lmat> For stable releases within the v3.x path, do we have 8 chances to patch, or 9? (3.1 is the first stable patch to 3.0... 3.8 is the eighth stable patch. Is 3.9 the ninth stable patch? Is it possible to make a tenth stable patch?)
09:10:31 *** fekepp has quit IRC
09:10:33 *** fekepp has joined #gnucash
09:13:37 *** fekepp has quit IRC
09:21:37 *** hke has quit IRC
09:23:09 *** darshan has joined #gnucash
09:23:47 *** darshan has quit IRC
09:24:02 *** darshan has joined #gnucash
09:46:10 *** fekepp has joined #gnucash
09:58:46 *** fekepp has quit IRC
09:58:47 *** fekepp has joined #gnucash
10:10:48 *** ncv has joined #gnucash
10:17:24 *** fabior has joined #gnucash
10:25:25 *** fekepp has quit IRC
10:40:15 *** fabior has quit IRC
11:09:47 *** ArtGravity has joined #gnucash
11:23:09 *** kus has joined #gnucash
11:29:13 *** kael has joined #gnucash
11:30:30 *** hoijui has joined #gnucash
11:41:26 *** kael1 has joined #gnucash
11:42:01 *** kael has quit IRC
11:42:02 *** kael1 is now known as kael
11:46:03 *** fabior has joined #gnucash
11:47:47 *** harshitaneja has joined #gnucash
11:52:16 *** kael1 has joined #gnucash
11:52:48 *** kael has quit IRC
11:52:48 *** kael1 is now known as kael
11:53:29 *** fabior has quit IRC
11:53:54 *** Mechtilde has joined #gnucash
12:01:39 *** kael1 has joined #gnucash
12:02:06 *** kael has quit IRC
12:02:06 *** kael1 is now known as kael
12:04:53 *** darshan has joined #gnucash
12:08:54 *** Mechtilde has quit IRC
12:10:13 *** kus has quit IRC
12:13:47 *** kael1 has joined #gnucash
12:14:22 *** kael has quit IRC
12:14:23 *** kael1 is now known as kael
12:19:53 *** kus has joined #gnucash
12:19:55 *** Mechtilde has joined #gnucash
12:23:15 *** kael1 has joined #gnucash
12:23:53 *** kael has quit IRC
12:23:54 *** kael1 is now known as kael
12:26:17 *** fabior has joined #gnucash
12:31:17 *** kael1 has joined #gnucash
12:31:54 *** kael has quit IRC
12:31:57 *** kael1 is now known as kael
12:32:58 *** Mechtilde has quit IRC
12:35:03 *** kael has quit IRC
12:51:06 *** fabior has quit IRC
12:52:20 *** darshan has quit IRC
12:59:20 <jralls> lmat: Depending on bugs we may do monthly patches through July, but we'll settle into quarterly as we've done with 2.6. The target for 4.0 is no later than December 2020, meaning we'll probably have around 14 releases. The pre-4.0 releases will start with 3.900 so there's plenty of room for numbers.
12:59:48 *** fabior has joined #gnucash
13:05:08 *** fabior has quit IRC
13:13:59 *** fabior has joined #gnucash
13:38:16 *** oozer has joined #gnucash
13:45:35 *** fabior has quit IRC
13:50:15 *** Mechtilde has joined #gnucash
14:00:36 *** PaulW2U has quit IRC
14:24:41 *** fabior has joined #gnucash
14:29:48 *** RandomGuyOnIrc has joined #gnucash
14:30:18 <RandomGuyOnIrc> Hi. I am new to GnuCash. Do people chat much here?
14:31:27 <jralls> Depends on what you mean by chat. You can read the logs to get a sample.
14:32:18 *** kael has joined #gnucash
14:39:05 <RandomGuyOnIrc> Thanks
14:39:22 <warlord> RandomGuyOnIrc: depends on time of day, day of week.
14:39:22 <gncbot> warlord: Sent 19 hours and 50 minutes ago: <jralls> Changing my permissions on gnucash-announce doesn't seem to have had any effect. The 2.7.7 announcement is held on both gnucash-announce and gnucash-devel because Message has implicit destination .
14:42:21 <warlord> jralls: ahh, yeah, it probably does not like implicit destinations at all.
14:44:11 <jralls> OK. So next weekend I'll try sending to announce, ccing users and devel, and setting reply-to to users and we'll see how that works.
14:45:11 <jralls> Though anyone who does "reply all" will reply to all three. That might get annoying.
14:45:20 <warlord> That should work -- none of the lists set a Reply-To
14:53:59 *** kael has quit IRC
14:55:18 *** fekepp has joined #gnucash
14:55:45 *** ncv has quit IRC
15:21:04 *** kael has joined #gnucash
15:38:06 *** Mechtilde has quit IRC
15:43:24 *** bob_ has joined #gnucash
15:44:39 *** kael has quit IRC
15:48:36 *** kael has joined #gnucash
15:50:28 *** fabior has quit IRC
15:53:36 *** frakturfreak has joined #gnucash
16:01:58 *** kael has quit IRC
16:39:40 *** oozer_ has joined #gnucash
16:39:42 *** oozer has quit IRC
16:49:22 *** harshitaneja has quit IRC
16:52:08 <RandomGuyOnIrc> I just set up an "account" which I would describe as a group of accounts. When I try to save, my only option is xml, but I want to save as mysql. How do I do that?
16:53:31 <RandomGuyOnIrc> maybe this is the answer http://www.howtodoityourself.org/set-mysql-gnucash-backend.html
16:58:22 *** jwngfu has quit IRC
17:07:18 <warlord> RandomGuyOnIrc: what OS/Distro are you using?
17:09:36 <RandomGuyOnIrc> Ubuntu
17:10:02 <RandomGuyOnIrc> I got to the point where I can do file save as, choose mysql
17:10:09 <RandomGuyOnIrc> I set up the database
17:10:25 <RandomGuyOnIrc> But when I try to save, I get this error: The server at URL mysql://Acumen@localhost/gnucash experienced an error or encountered bad or corrupt data.
17:10:42 <RandomGuyOnIrc> I created user Acumen
17:10:47 <RandomGuyOnIrc> set his password
17:11:04 <RandomGuyOnIrc> and used that same password in the file save dialogue
17:12:28 <jralls> RandomGuyOnIrc: You need to grant Acumen create database and create table.
17:13:09 <RandomGuyOnIrc> Ohhh ok thanks
17:13:40 <jralls> RandomGuyOnIrc: The rule for using a server backend is that you must either be an expert DBA on that server or employ someone who is. We can't remotely begin to teach DBA skills.
17:14:19 <jralls> Or teach them remotely, for that matter.
17:25:02 <RandomGuyOnIrc> I have used mysql for a long time
17:25:15 <RandomGuyOnIrc> I just forgot to do that
17:26:05 *** hoijui has quit IRC
17:27:15 <jralls> OK, I just had to give you the standard disclaimer. ;-)
17:28:04 <RandomGuyOnIrc> I still get the same error
17:28:42 <RandomGuyOnIrc> Do I need to create database Gnucash first?
17:29:05 <RandomGuyOnIrc> ooops typo, mybad
17:32:24 <jralls> Ot
17:32:38 <jralls> It's easier if you let GnuCash create the DB.
17:33:33 <jralls> There are some defaults buried in the code that GnuCash needs for the DB to work correctly.
17:40:46 <RandomGuyOnIrc> OK
17:42:00 <RandomGuyOnIrc> So I created a user Acumen, granted him all privileges, logged in as that user, created a database, dropped that same database, and quit
17:42:21 <RandomGuyOnIrc> when I try the file save as from Gnucash, I get the same error
17:42:45 <RandomGuyOnIrc> Do I need to exit gnucash? Does it somehow remember?
17:45:03 <jralls> It shouldn't remember anything until you've successfully created a db. Check your MySQL logs for clues. You can also quit GnuCash and restart it from the command line with --log gnc.backend.dbi=debug and it will put all sorts of gory details into the trace file.
17:46:58 *** pilotauto has joined #gnucash
17:47:33 <RandomGuyOnIrc> slightly different error
17:47:34 <RandomGuyOnIrc> The server at URL mysql://Acumen@localhost/gnucash experienced an error or encountered bad or corrupt data.
17:47:41 <RandomGuyOnIrc> it does create the database
17:47:46 <RandomGuyOnIrc> will check logs
17:47:48 <RandomGuyOnIrc> thanks
17:47:54 *** frakturfreak has quit IRC
17:48:01 <RandomGuyOnIrc> time to go cook dinner, will fix this later
17:48:12 <RandomGuyOnIrc> thanks again, you guys are great
17:48:42 <jralls> You're welcome.
18:05:59 *** bob_ has quit IRC
18:40:03 *** warlord has quit IRC
18:43:30 *** fekepp has quit IRC
18:43:33 *** fekepp has joined #gnucash
18:46:16 *** fekepp has quit IRC
18:49:24 *** fekepp has joined #gnucash
19:24:14 *** fekepp1 has joined #gnucash
19:24:52 *** fekepp has quit IRC
19:24:52 *** fekepp1 is now known as fekepp
19:28:57 *** chris has quit IRC
20:07:13 *** kus_ has joined #gnucash
20:50:45 *** ArtGravity has quit IRC
21:16:08 *** oozer_ has quit IRC
21:32:21 *** RandomGuyOnIrc has quit IRC
21:47:27 *** warlord has joined #gnucash
22:00:37 *** RandomGuyOnIrc has joined #gnucash
22:01:49 <RandomGuyOnIrc> I am not having any luck saving a database to mysql, I keep getting the error: The server at URL mysql://Acumen@localhost/gnucash experienced an error or encountered bad or corrupt data.
22:02:17 <RandomGuyOnIrc> after I create it, I can see the database from the mysql commandline
22:02:47 <RandomGuyOnIrc> there is nothing in the /var/log/mysql/error.log
22:03:15 <RandomGuyOnIrc> I tried running with debugging, "gnucash --debug -extra"
22:03:29 <RandomGuyOnIrc> but there is nothing useful
22:04:08 <RandomGuyOnIrc> Any suggestions?
22:05:19 <RandomGuyOnIrc> oh nevermind
22:05:22 <RandomGuyOnIrc> time for bed
22:05:27 <RandomGuyOnIrc> will be back tomorrow
22:05:29 <RandomGuyOnIrc> good night
22:06:01 *** RandomGuyOnIrc has quit IRC
22:31:46 *** pilotauto has quit IRC
22:48:40 *** storyjesse has joined #gnucash
23:27:56 <warlord> @tell RandomGuyOnIrc If you can't wait around for more than 4 minutes there's no chance you'll get an answer. Having said that -- try using XML if you can't use MySQL. We are not DB Admins here. Sounds like a permission problem with your user/database. Or you're using a "too new" mariadb which isn't properly supported by your version of gnucash+DBI.
23:27:56 <gncbot> warlord: The operation succeeded.
23:30:40 *** storyjesse has quit IRC