2015-08-27 GnuCash IRC logs

00:02:35 *** O01eg has quit IRC
00:32:10 *** storyjesse has quit IRC
01:24:11 *** dgtlmoon has joined #gnucash
01:47:43 *** fell_ has joined #gnucash
01:49:56 *** fell has quit IRC
01:59:02 *** mlncn has joined #gnucash
02:13:41 *** uXus has quit IRC
02:15:37 *** nomeata has joined #gnucash
02:44:18 *** uXus has joined #gnucash
03:00:25 *** uXus has quit IRC
03:00:56 *** uXus has joined #gnucash
03:22:51 *** fabior has joined #gnucash
03:35:19 *** nomeata has quit IRC
03:54:10 *** nomeata has joined #gnucash
04:26:37 *** jralls has quit IRC
05:30:16 *** Jimraehl1 has left #gnucash
05:34:03 *** Jimraehl1 has joined #gnucash
06:12:10 *** fabior has quit IRC
06:13:21 *** nomeata has quit IRC
06:20:40 *** mlncn has quit IRC
06:21:16 *** mlncn has joined #gnucash
06:28:34 *** himaxx has joined #gnucash
06:36:26 *** himaxx has quit IRC
06:44:09 *** nomeata has joined #gnucash
07:32:51 *** fabior has joined #gnucash
07:48:30 *** frozenjim has quit IRC
07:56:45 *** fabior has quit IRC
07:58:11 *** fabior has joined #gnucash
08:26:47 *** uXus has quit IRC
08:29:42 *** uXus has joined #gnucash
08:44:20 *** jralls has joined #gnucash
08:49:53 *** mlncn has quit IRC
08:52:10 *** gjanssens has joined #gnucash
08:52:10 *** ChanServ sets mode: +o gjanssens
09:07:02 *** mlncn has joined #gnucash
09:29:38 *** shivatma has joined #gnucash
09:29:47 <shivatma> Hello all!
09:30:34 <shivatma> A small question about gnucash arithmetics
09:31:23 <shivatma> how can I create a transaction which value is = (previous_account_balance - 10) ?
09:31:44 <shivatma> is there a shortcut for current value of account ?
09:31:55 *** frozenjim has joined #gnucash
09:44:48 <warlord> shivatma: alas, no
09:45:04 <shivatma> why ? why not =B-10
09:45:53 <warlord> Patches always welcome.
09:46:23 <warlord> (why? because nobody has implemented it.. You're welcome to do so)
09:48:49 *** neko has joined #gnucash
09:48:58 <neko> Hi All
09:49:41 *** nomeata has quit IRC
10:22:03 *** mlncn has quit IRC
10:22:29 <neko> I have a question..
10:23:09 <neko> About "GnuCash could not complete a critical test for the presence of a bug in the "libdbi" library. This may be caused by a permissions misconfiguration of your SQL database. Please see https://bugzilla.gnome.org/show_bug.cgi?id=645216 for more information."
10:26:36 <neko> Nearly, I had been upgrade Gnucash(via remote DB)/libdbi/MySQL(server/client: 5.6.26) to latest version.
10:27:21 <neko> but got the error message and forbid to access my data.
10:30:27 <neko> Reference link in message is old bug(2011-03-19)
10:31:00 <neko> So I confusing.
10:31:54 <warlord> neko: Are you sure your MySQL user has full permissons on the database?
10:32:11 <neko> In google, I didn't find about how to avoid/shoot/fix the problem.
10:32:15 <neko> Hi
10:33:14 <neko> Hi warlord, maybe not full permissions.
10:33:31 <neko> I will check it.
10:33:33 <neko> :D
10:34:13 <warlord> Also, what version of GnuCash are you using? And What OS/Distro?
10:35:03 <neko> GnuCash: 2.6.7 FreeBSD 10.2 & Windows
10:35:19 <warlord> This same error happens on both freebsd and windows?
10:35:52 <neko> DB: MySQL 5.6.26 @ FreeBSD 10.2-RELEASE i386
10:35:59 <neko> Yes.
10:36:12 *** mlncn has joined #gnucash
10:36:18 <neko> Upgrade MySQL cause the problem maybe
10:36:26 <warlord> If you get the same error from both systems.... Then yes, your issue is MySQL
10:36:35 <neko> Thanks you :D
10:37:02 <neko> The error message let me confuse.
10:38:04 <warlord> Not sure what's confusing about it.. "This may be caused by a permssions problem"
10:40:34 <neko> Haha "GnuCash could not complete a critical test for the presence of a bug in the "libdbi" library" <- confuse point
10:40:40 *** O01eg has joined #gnucash
10:43:08 <neko> About full permissions, Prior versions MySQL doesn't the problem.
10:43:59 <warlord> What's so confusing about that? That makes perfect sense. GnuCash was running a test for a critical bug in libdbi, and could not complete the test.
10:45:00 <neko> Sorry , poor English...
10:46:37 <neko> Yes, I think the problem point is "libdbi"
10:47:00 <warlord> I dont. I thnk the problem point is your MySQL
10:47:20 <warlord> ... because as you say you get the same error on both FreeBSD and Windows..
10:47:36 <neko> Yes, Thanks you a lot :D
10:49:58 <neko> Almost all of permissions, except GRANT
10:52:53 <neko> Data: SELECT/INSERT/UPDATE/DELETE
10:52:54 <neko> Struct: CREATE/ALTER/INDEX/DROP/CREATE TEMPORARY TABLES/SHOW VIEW/CREATE ROUTINE/ALTER ROUTINE/EXECUTE/CREATE VIEW/EVENT/TRIGGER
10:52:54 <neko> Manage: LOCK TABLES/REFERENCES
10:53:02 <neko> :)
10:55:27 <warlord> I dont know what permissions you need. /me doesn't use MySQL backedn
10:56:07 *** mib_39d926 has joined #gnucash
10:58:13 <neko> Thanks, I will search about permissions in GnuCash site.
11:07:06 *** mib_39d926 has quit IRC
11:14:53 <warlord> Try "all" ? :)
11:17:06 <neko> I had been open all permission, but same problem...
11:17:08 <neko> :p
11:18:57 <neko> Restart MySQL also
11:19:48 <warlord> And when you run gnucash on freebsd it gives you this error..?? and when you run gnucash on windows it gives you this same error??
11:22:09 <warlord> I ask this because we know the version of libdbi on windows is okay..
11:22:55 <neko> Yes, FreeBSD/Windows got same error...
11:23:27 <warlord> Then the issue is definitely on your MySQL side.
11:23:40 <warlord> Take a look at your GnuCash Tracefile -- it might provide more details.
11:23:44 <warlord> E.g. /tmp/gnucash.trace
11:24:06 <warlord> (on freebsd)
11:26:31 <neko> warlord: Oh I don't know about "/tmp/gnucash.trace" before
11:27:07 <neko> I checked it
11:27:31 <warlord> and..??
11:27:49 <neko> Before, I had been check source code...But don't know issue point
11:27:51 <neko> * 00:35:29 WARN <gnc.backend.dbi> [conn_test_dbi_library()] Test_DBI_Library: Create table failed
11:27:51 <neko> * 00:35:30 CRIT <gnc.backend.dbi> gnc_dbi_unlock: assertion 'dbi_conn_error( dcon, NULL ) == 0' failed
11:28:06 <warlord> Well, there you go!
11:28:25 *** MechtiIde has joined #gnucash
11:28:37 <warlord> So why did it fail to create table?
11:29:06 <neko> I confuse now, Take All permission open.
11:30:02 <warlord> Well, try it by hand using the mysql clienbt logged in using the same username/password.
11:30:15 <warlord> but this is clearly a mysql issue.
11:30:25 <warlord> You'll have to track it down. We're not MySQL experts here.
11:30:29 <neko> Yes, Thanks you very much :D
11:30:56 <warlord> good luck
11:31:27 <neko> :D
11:34:35 <neko> Current GnuCach & prior MySQL work fine..
11:35:12 <warlord> Which implies even more that it's 100% a MySQL issue
11:35:44 <neko> Maybe... :p
11:36:00 <neko> Thanks you :D
11:36:52 <warlord> You're welcome
11:39:12 <neko> In source code, GnuCash attempt creat a temporary table numtest.
11:39:31 <warlord> yes
11:39:49 <warlord> and that appears to be failing.
11:40:14 <neko> But CREAT permission existed from first GnuCash install.
11:40:39 <warlord> neko: what happens when you run that 'create' command by hand against the 'new' mysql?
11:41:45 <neko> Do CREAT by hand?
11:44:28 <warlord> yes, try the create table by hand to see if it works and, if not, what error you get from mysql
11:47:20 <neko> :D
11:50:36 <neko> Result: The table 'numtest' is full
11:52:26 <warlord> umm... did the table already exist?
11:53:09 <warlord> maybe it failed to properly drop the table at the end?
11:53:22 <neko> The table exist in system database possible.
11:53:34 <warlord> (I'm not sure what "The table 'numtest' is full" means
11:55:07 <neko> I don't know also :p but it exist look like.
11:55:25 <warlord> okay, try "drop table numtest" ?
11:58:17 *** shivatma has quit IRC
11:58:22 <neko> The table doesn't exist in gnucash's database, so I got "Unknown table 'gnucash.numtest'" :p
11:58:32 <neko> may system database.
12:00:27 <warlord> So... create table *is* failing...
12:00:39 <warlord> Is your MySQL server disk/partition full?
12:01:17 <warlord> neko: c.f. https://dev.mysql.com/doc/refman/5.0/en/full-table.html
12:01:47 <neko> It create in /tmp possible...
12:03:04 <neko> Oh work!!
12:03:43 <neko> because /tmp is TMPFS (in memory), so capacity limit exist...:0
12:04:05 <neko> previous: 128kB
12:04:10 <neko> Now, 1mB
12:04:13 <neko> :D
12:04:19 <neko> Thanks you very much !!
12:05:26 <warlord> Why are you using /tmp for gnucash storage? That's not very reliable???
12:06:26 <neko> No, MySQL use /tmp for temporary table
12:06:50 <neko> GnuCash's database on HDD :p
12:14:42 <warlord> hm. ok.
12:18:57 <neko> :D:D:D
12:20:41 *** mlncn has quit IRC
12:23:10 <neko> Today, Thanks you very much help to debug.
12:24:53 <warlord> you're welcome.
12:24:55 <warlord> glad it's working now.
12:25:08 <neko> :D :D :D
12:37:17 <neko> Sorry, Taiwan is AM 2 o'clock...
12:37:24 <neko> Good night :D
12:38:45 *** mlncn_ has joined #gnucash
12:43:49 <warlord> good night.
13:01:38 *** shivatma has joined #gnucash
13:08:02 *** shivatma has quit IRC
13:09:56 *** neko has quit IRC
13:25:45 *** MechtiIde has quit IRC
13:36:21 *** fabior has quit IRC
15:16:29 *** jralls has quit IRC
15:16:49 *** jralls has joined #gnucash
15:41:13 <frozenjim> Sorry for silly question, but cannot find an answer in docs or Google: I am importing my bank transactions and see that about 30% are green "New, transfer $XXX to (auto) Imbalance-CAD. These I understand and can reassign manually. Then there are maybe 35% more that are orange and say "New, Unbalanced (need acct to transfer $XX.XX)!" I have no idea what this means and would probably just import them anyhow and treat them exactly the same as the gre
15:41:13 <frozenjim> en ones. But there are also four RED entries "Do not import (no action selected)". These four appear to be normal transactions just like all of the others but I fear they will NOT be imported so I wont be able to assign them the right accounts. Can someone give me a quick tutorial on what these three import status mean and confirm I am handling things correctly (AND... what do I do with the RED ones?).
15:59:47 <frozenjim> YELLOW: Means "no idea which account to post to". There is no first split so it cannot even post to Imbalance-$$$. GOT IT! :-) Now I just need to understand the RED ones....
16:15:47 <warlord> frozenjim: the red ones mean the importer thinks they are duplicates
16:22:24 <frozenjim> OK, that makes sense. So, they are NOT duplicates, but I'm guessing that the algorithm prefers to err on the side of caution(?). They are all repeating payments with the same totals, so I can understand it. Can you confirm that RED items are frequently NOT duplicates?
16:27:03 <frozenjim> Six transactions in a row and of them, four are RED but none are actually duplicates of anything either in my books or elsewhere in the batch. do you think it safe to presume that this is some oddness in the RBC Bank's exporting function?
17:17:30 *** Jimraehl1 has quit IRC
17:19:22 *** mlncn_ has quit IRC
17:20:56 *** gjanssens has quit IRC
18:41:51 <warlord> frozenjim: I dont know. Possibly. But if you have multple transactons with similar description for the same amount the importer might decide they are dups..
19:13:24 <frozenjim> OK, I think I have it under control then. It's better that it errs on the side of caution. I realize that I can change them to "A" (Add) once I am certain that they are not duplicates. Not so scary once it all clicks. Thx.
19:15:11 <warlord> you're welcome
19:19:54 *** frozenjim has quit IRC
19:28:02 *** fell_ has quit IRC
19:43:53 *** mlncn_ has joined #gnucash
19:56:33 *** mlncn_ has quit IRC