2013-03-18 GnuCash IRC logs
00:40:38 *** nodje has joined #gnucash
00:44:36 *** nodje has quit IRC
00:45:22 *** nodje has joined #gnucash
01:48:45 *** fell has joined #gnucash
01:48:46 *** gncbot sets mode: +o fell
02:18:07 *** Haricophile has joined #gnucash
02:41:04 *** Haricophile has quit IRC
02:47:00 *** ecocode has joined #gnucash
02:57:08 *** ecocode has quit IRC
03:49:27 *** ecocode has joined #gnucash
04:12:14 *** Arafangion has joined #gnucash
04:14:17 *** Arafangion has quit IRC
04:22:46 *** Krzysiek_K has joined #gnucash
04:23:21 *** Krzysiek_K has left #gnucash
04:26:16 *** Krzysiek_K has joined #gnucash
04:27:35 *** nodje has quit IRC
04:27:35 *** Krzysiek_K has joined #gnucash
04:28:11 *** Krzysiek_K has quit IRC
04:33:46 *** nodje has joined #gnucash
05:11:32 *** aqua___ has joined #gnucash
05:22:18 *** aqua___ has quit IRC
05:30:57 *** aqua___ has joined #gnucash
05:40:37 *** fabior has joined #gnucash
05:43:16 *** aqua___ has quit IRC
05:52:56 *** aqua___ has joined #gnucash
06:53:07 *** aqua___ has quit IRC
06:59:35 *** aqua___ has joined #gnucash
07:25:18 *** Jimraehl has joined #gnucash
07:26:01 *** calbasi has joined #gnucash
07:55:59 *** jonathan has joined #gnucash
09:27:04 *** Topcat has joined #gnucash
10:15:14 *** joslwah_free has quit IRC
10:18:45 *** Topcat has quit IRC
10:25:36 *** ErKa has joined #gnucash
10:41:03 *** aqua___ has quit IRC
10:52:20 *** aqua___ has joined #gnucash
12:03:07 *** aqua___ has quit IRC
12:08:04 *** ecocode has quit IRC
12:17:24 *** fabior has quit IRC
12:35:12 *** Topcat has joined #gnucash
12:41:36 *** shanny has joined #gnucash
13:03:20 *** calbasi has left #gnucash
13:13:00 *** linas_ has joined #gnucash
13:13:00 *** linas__ has quit IRC
13:32:52 *** Topcat has quit IRC
13:33:15 *** Topcat has joined #gnucash
13:43:32 *** shanny has quit IRC
13:45:21 *** jmd has joined #gnucash
13:53:36 *** Topcat has quit IRC
13:53:58 *** Topcat has joined #gnucash
14:10:28 *** shanny has joined #gnucash
14:18:57 *** ErKa has quit IRC
14:19:39 *** Topcat has quit IRC
14:56:03 *** ErKa has joined #gnucash
15:47:09 *** aqua___ has joined #gnucash
15:58:05 *** benoitg has joined #gnucash
16:39:46 *** Krzysiek_K has joined #gnucash
17:05:48 *** aqua___ has quit IRC
17:20:00 *** clive has joined #gnucash
17:21:17 <clive> Good morning/afternoon/evening
17:21:52 <clive> I would appreciate some assistance if anyone can offer guidance related to a question on sharing a single gnucash database between 2 discrete clients.
17:22:09 <clive> One is running 32-bit Mint Linux, the other 64-bit Mint.
17:22:31 <clive> Access is fine from the 64-bit system, but upon attempting to connect from the 32-bit client I get a consistent error message...
17:23:52 <clive> The specific wording of the error message is "No suitable backend found for file { my GNUcash data file }.
17:25:10 <clive> I see exactly the same issue reported between 32-bit and 64-bit editions of ubuntu 12.04 on the same [corresponding] hardware [perhaps unsurprising given Mint is an ubuntu derivative].
17:27:02 <clive> I am wondering if there could be anything captured in the GNUcash data files which hints at the system architecture that created those files...
17:27:50 *** Krzysiek_K has left #gnucash
17:33:19 <warlord> clive: first, you wont be able to use both systems simultaneously.
17:33:53 <warlord> clive: second, it sounds like one of the systems is missing the appropriate DBI DBD backend for whatever SQL system you are using (SqLite, MySQL, or PG)
17:34:11 <clive> Hi...
17:34:30 <clive> Thank you; I am sorry, I should have said that I am not and will not try to access simultaneously
17:35:39 <clive> I did find a hint relating to the backend driver on a Fedora site
17:36:16 <clive> a post there suggested that the missing library was libdbi-dbd-sqlite
17:36:46 <clive> I used the Fedora on-line resources, and found a list of the .so files that are provided by that specific Fedora rpm package
17:37:05 <clive> I then checked my local Mint [14.0] build and confirmed that the existed.
17:37:20 <clive> and around that time I started to hit the limit of my knowledge
17:37:21 <clive> :(
17:38:17 <clive> I wonder... is there a simple way that I can check my local machine to determine which SQL system is being used by my distro please?
17:39:34 <warlord> clive: it's a question of how you configured your dataset.
17:39:48 <warlord> When you did File -> Save (As), what did you choose?
17:40:46 <clive> warlord: that's a very good question, and I am afraid I don't recall. I have been using this set of files without difficulty [on my 64-bit system] since 2010...
17:40:59 <clive> I wonder if I can tell from say my savedir contents?
17:41:23 <warlord> Sure, run: file /path/to/your/data/file.gnucash
17:41:44 <clive> Got it...
17:42:50 <clive> OK, I get "Finances.gnucash: gzip compressed data, from Unix
17:43:17 *** arrainey has joined #gnucash
17:53:30 <clive> I am sorry - I guess one more relevant piece of information I should have offered up: Mint 14.0 is using GnuCash 2.4.11, built from r22264M on Sep 20th, 2012
17:55:32 <warlord> And what's the other version?
17:56:01 <warlord> Hmm, gzip implies it's XML. What do you get from: zcat Finances.gnucash | head -2
17:57:14 <clive> <?xml version="1.0" encoding="utf-8" ?>
17:57:16 <clive> <gnc-v2
17:57:51 <clive> Checking the 32-bit version for you now...
17:59:02 <clive> The 32-bit version claims to be exactly the same in origin as the 64-bit
18:01:10 *** jmd has quit IRC
18:02:02 <clive> I've just double checked the binary on my 32-bit system [/usr/bin/gnucash] and I see the following:-
18:02:22 <clive> ELF 32-bit LSB executable, Intel 80386 version 1 (SYSV)
18:02:33 <clive> dynamically linked (uses shared libs)
18:02:41 <clive> for GNU/Linux 2.6.24
18:03:01 <clive> BuildID [... a SHA1 has... ], stripped
18:03:18 <clive> ...
18:03:32 <clive> The 64-bit system has pretty much the same, except of course stipulates x86-64
18:04:12 *** arrainey has quit IRC
18:10:17 <warlord> Check the data file -- make sure you're using the same data file on both versions
18:13:01 <clive> In this case, yes... that is true. What I have done is to place the data files on my NAS box. The idea is that I wanted to be able to boot either my 64-bit "main" machine, or my 32-bit Atom-powered Shuttle and access my GNUcash files... Short answer being that both instances of GNUcash are trying to access the same file...
18:13:42 <clive> In this case, I've just done a fresh installation of Mint 32-bit to the Shuttle [completely clean], installed GNUcash, launched, asked to "open" a file and then pointed it to the NAS copy of my data.
18:13:50 <clive> That's when I see the "backend" error message.
18:14:50 <clive> [ FWIW, the 64-bit Mint is also a brand new build, and I aligned it with the data files exactly the same way, but it worked first time... ]
18:16:28 <clive> ...
18:16:36 <clive> OK, I have just had a completely silly idea
18:16:45 <clive> Suppose I go to the 32-bit system
18:16:57 <clive> Launch GNUcash, and ask it to create me a brand new set of accounts
18:17:03 <clive> Call them "Test" or some such
18:17:41 <clive> Open an account and put a couple of transactions in... but then close out the 32-bit program, switch to the 64-bit system and try to access this new Test file.
18:18:19 <clive> If I am able to access the new file from either 32-bit or 64-bit hosts, then perhaps I have a hint that there is an issue within the XML structure of my existing account data?
18:22:32 <warlord> could be. The XML backend is pretty stable, and it shouldnt really hvae this kind of issue.
18:23:03 <clive> OK, let's give it a go
18:23:39 <warlord> what happens if you just copy the data file to the 32-bit machine?
18:23:57 <warlord> Is there anything else printed on the terminal on the atom? or in /tmp/gnucash.trace?
18:24:09 <clive> I'll try that first
18:24:29 <clive> Will copying just the one file be sufficient, or do I need to take any of the log files with me too>
18:24:30 <clive> ?
18:26:10 <clive> Ooh...
18:26:15 <clive> Now that's interesting
18:26:44 <clive> I dropped a copy of the full account file into my home directory on the 32-bit Atom system, and the file opened without issue...
18:27:39 <clive> The reason I say, "That's interesting" is because I am using the same /etc/fstab mount statement on both 32-bit and 64-bit systems...
18:28:28 <clive> /192.168.1.41/Public /media/nas cifs defaults,rw,username={my_user_id},password={my_password},file_mode=0777,dir_mode=0777
18:28:57 <clive> [Sorry, the IRC protocol stripped off the very first leading forward slash... ]
18:33:34 <warlord> oh... CIFS...
18:33:45 <warlord> When you said NAS I thought you meant NFS
18:34:26 <clive> Ah, again, sorry for the lack of clarity on my part.
18:34:56 <clive> This is a QNAP TS-459 Pro II... and I did initially have it running over NFS with an earlier release of ubuntu
18:35:23 <clive> Then I discovered that each time Canonical released a new version of ubuntu, it would break the NFS mounts and I would lose connection with the NAS
18:35:42 <clive> For 12.04 I went back to CIFS and it worked like a charm - I rather just stuck with it
18:35:47 <clive> ...
18:36:04 <clive> however, your exclamation of surprise would suggest that I might want to reconsider that decision?
18:40:08 <warlord> well, cifs kinda has some locking issues that gnucash doesn't necessarily like.
18:41:11 <clive> Aha!
18:41:20 <clive> So now I feel that I may be getting closer to the truth
18:41:58 <clive> I do not have a "known good" NFS connection string for Mint 14.0 to the current Firmware running on my QNAP - I've updated the NAS at least a couple of times since I've been running CIFS.
18:42:15 <clive> So how about I say "Thank you!" here, for the time being, and leave you in peace...
18:42:30 <clive> I shall go away and get a working NFS connection string from Mint 14.0 to the QNAP
18:42:44 <clive> Then re-try both 64-bit and 32-bit connections to see if this resolves the issue
18:42:48 <warlord> good luck!
18:43:09 <clive> Either way, as a courtesy, I shall come back and share the results. [ If it works, it might be a useful confirmation for others... ]
18:43:19 <clive> I am *really* grateful for your patience and advice.
18:43:21 <clive> Thank you
18:43:49 <warlord> you are welcome.
18:44:44 <clive> Good morning/afternoon/evening all...
18:44:45 <clive> TTFM
18:44:49 <clive> N...
18:44:50 *** clive has quit IRC
18:45:46 *** jonathan has quit IRC
18:58:16 *** arrainey has joined #gnucash
18:58:21 *** shanny has quit IRC
19:01:04 *** fell_ has joined #gnucash
19:01:05 *** gncbot sets mode: +o fell_
19:06:14 *** fell has quit IRC
19:18:36 *** arrainey has quit IRC
19:51:27 *** arrainey has joined #gnucash
20:01:34 *** arrainey has quit IRC
20:02:06 *** arrainey has joined #gnucash
20:07:09 *** arrainey has quit IRC
20:07:44 *** arrainey has joined #gnucash
20:17:50 *** arrainey has quit IRC
20:18:24 *** arrainey has joined #gnucash
20:23:26 *** arrainey has quit IRC
20:23:58 *** arrainey has joined #gnucash
20:31:50 *** ErKa has quit IRC
20:34:22 *** arrainey has quit IRC
20:39:03 *** arrainey has joined #gnucash
20:43:42 *** fell_ has quit IRC
20:44:53 *** fell_ has joined #gnucash
20:44:53 *** gncbot sets mode: +o fell_
20:54:53 *** arrainey has quit IRC
20:55:26 *** arrainey has joined #gnucash
21:17:57 *** ErKa has joined #gnucash
21:28:24 *** arrainey has quit IRC
21:45:23 *** Jimraehl has quit IRC
21:46:07 *** arrainey has joined #gnucash
21:57:52 *** kpreid has quit IRC
21:58:17 *** kpreid has joined #gnucash
22:06:31 *** arrainey has quit IRC
22:07:04 *** arrainey has joined #gnucash
22:12:11 *** arrainey has quit IRC
22:12:43 *** arrainey has joined #gnucash
22:17:46 *** arrainey has quit IRC
22:18:22 *** arrainey has joined #gnucash
22:23:26 *** arrainey has quit IRC
22:24:01 *** arrainey has joined #gnucash
22:29:03 *** arrainey has quit IRC
22:29:36 *** arrainey has joined #gnucash
22:34:39 *** arrainey has quit IRC
22:35:10 *** arrainey has joined #gnucash
22:40:12 *** arrainey has quit IRC
22:40:45 *** arrainey has joined #gnucash
22:50:51 *** arrainey has quit IRC
22:51:25 *** arrainey has joined #gnucash
22:56:28 *** arrainey has quit IRC
22:57:00 *** arrainey has joined #gnucash
23:02:04 *** arrainey has quit IRC
23:02:37 *** arrainey has joined #gnucash
23:07:42 *** arrainey has quit IRC
23:08:15 *** arrainey has joined #gnucash
23:13:17 *** arrainey has quit IRC
23:13:50 *** arrainey has joined #gnucash
23:18:53 *** arrainey has quit IRC
23:19:26 *** arrainey has joined #gnucash
23:29:37 *** arrainey has quit IRC
23:30:19 *** arrainey has joined #gnucash
23:34:54 *** arrainey has quit IRC