2012-07-14 GnuCash IRC logs

00:08:24 *** mendota has joined #gnucash
00:51:12 *** mendota has quit IRC
02:33:10 *** ilisten has joined #gnucash
02:48:33 *** jmd has joined #gnucash
03:04:48 *** Jimraehl1 has quit IRC
05:00:37 *** lorenz571 has quit IRC
05:54:38 *** Fabzgy has joined #gnucash
06:27:33 *** fell_ has joined #gnucash
06:27:33 *** gncbot sets mode: +o fell_
06:28:05 *** fell_ is now known as fell
06:37:42 *** aqua___ has joined #gnucash
06:43:17 *** jmd has quit IRC
07:26:21 *** jmd has joined #gnucash
07:40:04 *** aqua___ has quit IRC
08:23:10 *** Askarii has joined #gnucash
08:24:46 *** Jimraehl1 has joined #gnucash
08:46:12 *** jmd` has joined #gnucash
10:11:59 *** Silly has quit IRC
10:12:21 *** Silly has joined #gnucash
10:36:24 *** Silly has quit IRC
10:36:45 *** Silly has joined #gnucash
11:01:09 *** aqua___ has joined #gnucash
11:04:37 *** kpreid has quit IRC
11:11:47 *** lorenz571 has joined #gnucash
11:36:09 *** Fabzgy has quit IRC
11:36:26 *** Fabzgy has joined #gnucash
11:38:24 *** aqua___ has quit IRC
11:39:32 *** kpreid has joined #gnucash
12:08:33 *** pnema has joined #gnucash
12:11:15 *** Bodhi has joined #gnucash
12:17:26 *** Bodhi has quit IRC
12:17:33 *** Bodhi has joined #gnucash
12:19:59 *** Bodhi has quit IRC
12:20:03 *** Bodhi-Baum has joined #gnucash
12:49:21 *** jmd has quit IRC
12:52:24 *** mendota has joined #gnucash
14:15:48 *** Fabzgy has quit IRC
14:30:20 *** aqua___ has joined #gnucash
14:55:58 *** pnema has quit IRC
15:23:21 *** aqua___ has quit IRC
16:15:32 *** mendota has quit IRC
16:41:08 *** jmd` has quit IRC
17:04:09 *** Bodhi-Baum has quit IRC
17:52:41 *** ilisten has quit IRC
19:01:45 *** lorenz571 has quit IRC
19:11:01 *** john has joined #gnucash
19:11:02 *** gncbot sets mode: +o john
19:12:20 *** Ejdesgaard has joined #gnucash
19:13:29 <Ejdesgaard> Hi, Is it possible to install gnucash on a server and lets say, 3 clients then have the clients connect up to the server ?
19:16:55 <Antisoche> Ejdesgaard: I'm pretty sure the answer to that is no. Gnucash is for personal finances only.
19:18:39 <Ejdesgaard> Antisoche, okay, that's a shame... I'm starting a small business, we are 3 co-owners and are looking for an accounting solution to use
19:19:09 <Ejdesgaard> and it seems to do all the stuff that we need, except what I just asked here
19:19:35 <john> member:identifier:ejdesgaard: Depends on what you mean. If the clients are running X11, then yes, they would be able to connect and display over the network. Remember, though, that you can have only one user in a particular database at a time.
19:20:31 <Antisoche> Ejdesgaard: There is a mysql backend ... I've never used it but if you're _really_ careful you might be able to get away with that. Such as setting a policy of only one writer, but even then your readers are going to get out of sync because I think the Gnucash model is to read everything into memory, just like the XML file.
19:20:37 <Ejdesgaard> I have a debian-6 hosted server and we have a linux, osx and windows client
19:21:54 <Ejdesgaard> Antisoche, a workaround for that could be to limit connections to one via iptables... even tho that would be an ugly workaround
19:22:43 <john> OK. Linux & OSX, no problem. Win32, you'll need to get an X11 server (yeah, that's confusing: the X11 server runs on the box with the display).
19:22:55 <Antisoche> Ejdesgaard: Pretty sure that's a bad idea. If it reads everything at once and then writes everything at once, the connection can go away in between and then you're hosed.
19:23:17 <Ejdesgaard> john, xming :)
19:23:20 <Ejdesgaard> Antisoche, okay:S
19:24:00 <john> Antisoche: The SQL backends enforce the one-user-at-a-time themselves. But yes, that's because there's no provisions at present for concurrency.
19:24:44 <Antisoche> How would the server know if the client went away? Or does it just end up with locked tables until you manually reset it?
19:25:45 <Ejdesgaard> It would be a nice feature to have it centrally :)
19:27:15 <john> Antisoche: You end up with a stale lock that has to be over-ridden at startup, just like with an XML file.
19:28:37 <Antisoche> Yeah, that's what I assumed. So then the 2nd person connecting doesn't know if there's someone else actually there or if a client died. So - it _could_ be used to support multiple users, but they'd have to be careful.
19:31:02 <Antisoche> john: That's also assuming that there's a lock check before writing as well. I doubt that exist for the XML file.
19:32:07 *** Askarii has quit IRC
19:33:01 <Ejdesgaard> so basicly it's not recommended as of 2.4.10?
19:33:06 <john> No, there are no lock checks except at file open time. It is absolutely not supported to have more than one user connected to a database or to have a file open. One of these days, but there's a ton of cleanup and redesign to do first.
19:34:11 <Ejdesgaard> what language is the code written in?
19:34:16 <john> Ejdesguaard: Concurrent users is not supported for any version.
19:35:06 <john> Ejdesgaard: The core is in C with some peripheral bits (reports, mostly, but there are some other pieces here and there) in Guile, a dialect of Scheme.
19:37:36 <Ejdesgaard> okay
19:37:52 <Ejdesgaard> had to google Guile :)
19:52:17 *** aqua___ has joined #gnucash
20:16:43 *** aqua___ has quit IRC
20:36:32 *** fell_ has joined #gnucash
20:36:33 *** gncbot sets mode: +o fell_
20:41:43 *** fell has quit IRC
20:50:24 *** Menuhin_ has joined #gnucash
20:55:35 *** Menuhin has quit IRC
21:26:35 *** lois has quit IRC
21:30:18 *** lois has joined #gnucash
22:52:11 *** Jimraehl1 has quit IRC