2014-12-22 GnuCash IRC logs
00:51:56 *** cartsoftware has joined #gnucash
01:13:33 *** MechtiIde has joined #gnucash
01:38:37 *** cartsoftware has quit IRC
01:45:32 *** O01eg has quit IRC
02:03:36 *** cartsoftware has joined #gnucash
02:18:56 *** MechtiIde has quit IRC
02:22:09 *** cartsoftware has quit IRC
02:23:00 *** cartsoftware has joined #gnucash
02:29:08 *** uXus has quit IRC
02:32:51 *** uXus has joined #gnucash
02:43:09 *** wol has joined #gnucash
03:27:37 *** gour has joined #gnucash
03:27:45 <gour> morning
03:29:01 <gour> i'm running 2.6.4 on suse and since some recent version i noticed that GC does not render dates properly, iow. the first digit in date column is not visible until one clicks the cell
03:30:37 *** cartsoftware1 has joined #gnucash
03:31:40 <gour> here is the shot: http://paste.opensuse.org/42075681 showing the issue
03:31:41 <gour> any idea?
03:32:44 *** gjanssens has joined #gnucash
03:32:45 *** gncbot sets mode: +o gjanssens
03:37:17 *** cartsoftware has quit IRC
03:37:21 <gour> as you can see i'm using eu date format, but it's same with us as well as with 24hrs format off/on
03:51:25 *** cartsoftware has joined #gnucash
03:51:26 *** cartsoftware1 has quit IRC
03:59:41 *** wol1 has joined #gnucash
04:01:12 *** wol has quit IRC
04:07:53 <gjanssens> gour: that's likely a font size problem combined with the fact that gnucash stores custom column widths
04:07:54 *** cartsoftware has quit IRC
04:08:08 <gjanssens> Did you change your system's default font recently ?
04:08:34 *** cartsoftware has joined #gnucash
04:12:43 <gour> gjanssens: well, i recently switched from debian (sid) to suse where i run gnome3 now, but i was present on debian as well
04:12:55 <gour> any workaround/fix?
04:17:41 *** cartsoftware has quit IRC
04:31:47 *** pppp2 has joined #gnucash
04:45:19 <gjanssens> gour: not from the gui currently
04:45:44 <gjanssens> The column widths are stored in the meta file that accompanies your gnucash book
04:45:58 <gour> it does not matter as long as it's fixable :-)
04:46:01 <gjanssens> You can find them in $HOME/.gnucash/books
04:46:46 *** wol1 has quit IRC
04:47:15 <gjanssens> Look for "date_width" entries in "Register ..." blocks
04:47:29 <gour> yeah, i'm looking at
04:47:47 <gjanssens> If you remove those the register should use the default width for a date which is calculated based on the chosen font and date format
04:48:24 <gour> does '#' serve as comment?
04:51:51 <gour> gjanssens: fixed. thank you!
05:01:06 <gjanssens> gour: you're welcome
05:01:19 <gjanssens> I am not sure about the comment marker
05:01:26 <gjanssens> It could also be ';'
05:05:31 <gour> '#' worked
05:07:49 <gjanssens> Ok, good to know
05:08:36 *** Krzysiek_K has joined #gnucash
05:37:10 *** pppp2 has quit IRC
06:04:42 *** GabrieleV_ has joined #gnucash
06:04:42 *** GabrieleV has quit IRC
06:04:42 *** GabrieleV_ is now known as GabrieleV
06:25:20 *** aqua___ has joined #gnucash
06:28:33 *** aqua___ has quit IRC
06:51:41 *** Krzysiek_K has left #gnucash
07:27:30 *** himaxx has joined #gnucash
07:28:41 *** himaxx has quit IRC
07:30:47 *** kim27 has quit IRC
07:33:56 *** kim27 has joined #gnucash
07:37:37 *** kim27 has quit IRC
07:38:18 *** kim27 has joined #gnucash
07:49:26 *** andy has quit IRC
07:49:56 *** rickoehn has joined #gnucash
07:58:31 *** cartsoftware has joined #gnucash
08:01:32 *** andy has joined #gnucash
08:01:32 *** cartsoftware has quit IRC
08:01:39 *** cartsoftware has joined #gnucash
08:10:56 *** himaxx has joined #gnucash
08:14:59 *** cartsoftware has quit IRC
08:16:51 *** aqua___ has joined #gnucash
08:29:26 *** Jimraehl1 has left #gnucash
08:30:23 *** Jimraehl1 has joined #gnucash
08:42:22 *** aqua___ has quit IRC
09:05:11 *** wol has joined #gnucash
09:08:14 *** GabrieleV_ has joined #gnucash
09:08:51 *** GabrieleV has quit IRC
09:08:52 *** GabrieleV_ is now known as GabrieleV
09:21:36 *** lmat has joined #gnucash
09:34:59 *** wol has quit IRC
09:46:00 *** ErKa has joined #gnucash
10:03:16 *** aqua___ has joined #gnucash
10:25:13 *** rubdos has joined #gnucash
10:35:18 <gjanssens> jralls: that was indeed an oops in environment.in
10:36:07 <gjanssens> I never noticed because I'm not overriding the GUILE_LOAD_*_PATH variables on linux and Windows doesn't use GUILE_LOAD_COMPILED_PATH
10:36:13 <gjanssens> Good you figured it out
10:36:30 <gjanssens> Your commit message is slightly confusing though:
10:39:57 <gjanssens> I mean it got *me* confused
10:40:28 <gjanssens> I first thought you were referring to where the gnucash compiled scheme files are stored (given you are modifying the gnucash repository)
10:41:06 <gjanssens> but then finally it occurred to me you were instead referring to the compiled scheme files that ship with guile
10:41:22 <gjanssens> Anyway, glad it's sorted
10:48:04 *** lmat has quit IRC
11:03:45 *** aqua___ has quit IRC
11:12:52 *** lmat has joined #gnucash
11:14:44 *** wol has joined #gnucash
11:17:20 *** wol has quit IRC
11:22:30 *** lmat has quit IRC
11:37:30 *** wol has joined #gnucash
11:38:55 *** O01eg has joined #gnucash
11:41:25 *** O01eg has quit IRC
12:00:35 *** O01eg has joined #gnucash
12:18:45 *** wol has quit IRC
12:31:41 *** gjanssens is now known as gjanssens_
12:32:02 <jralls> gjanssens_: That part of the change *does* apply to the guile precompiled files. The guile ccache is in lib, the sources are in share, so there needs to be a separate variable for each.
12:38:00 *** tcastleman has joined #gnucash
12:42:33 <tcastleman> Hi all, I need MySQL support on MacOS (Yosemite). I have spent an entire day trying to get the libdbi drivers compiled without success. Yes I have read the wiki at length and various threads.
12:42:52 <gjanssens_> jralls: I did understand finally :)
12:43:00 <gjanssens_> (got to leave now)
12:43:44 <tcastleman> I am looking for someone who may have compiled libdbimysql.so library which I can drop in. I would be prepared to Donate / Pay for this!
12:54:32 <jralls> tcastleman: That person will need the exact version of mysql that you have in order for it to drop in.
12:54:57 <jralls> tcastleman: What's failing when you try to build it yourself?
12:56:57 <tcastleman> jralls: It was a few weeks back, but I actually succeeded in compiling the .so library, however it was 64 bit. Then I finally gave up when the 32 bit mysql5 packages I needed from macports was broken.
12:57:21 *** MechtiIde has joined #gnucash
12:59:04 <jralls> tcastleman: If you can't get a 32-bit mysql then you'll have to rebuild all of GnuCash for 64-bits or build MySql from source for 32-bits. To get 32-bits, add `-arch i386` to $CFLAGS and $CXXFLAGS.
13:00:09 <tcastleman> jralls: Yea, I really don't have the time or expertise to be building everything. Long and short of it I would be prepared to pay to get this done.
13:00:34 <jralls> tcastleman: OK.
13:01:20 <tcastleman> jralls: At the moment I have xrdp onto an Ubuntu machine and it's far from ideal!
13:01:22 <jralls> tcastleman: I don't know of anyone here who takes consulting clients like that. Your best bet might be your local Mac users group.
13:01:59 <tcastleman> jralls: Hmm.. OK do you have a price though?
13:02:09 <jralls> What do you mean?
13:02:46 <tcastleman> jralls: well, I believe you are responsible for writing the docs on how to do this, and well, it would follow that in theory this is something you could do.
13:03:23 <jralls> It's certainly something I can do, but I don't take clients.
13:03:51 <tcastleman> jralls: right ok.
13:06:08 <tcastleman> jralls: so to cut to the chase, is there any way I could persuade you to do this, either for a donation or a gift if not a fee?
13:06:20 <jralls> No.
13:06:32 *** KaiForce has joined #gnucash
13:11:19 <tcastleman> jralls: OK. I respect your position. So what do you suggest is the best way for me to get this done?
13:12:28 <jralls> I told you: Look for a mac programming consultant. A local users group is a good place to start.
13:13:21 <tcastleman> jralls: OK. Can I ask why the MySQL driver isn't bundled with the Mac package when it is included with Windows?
13:14:18 <jralls> Windows has a different model of linking libraries so that it's feasible to bundle the dbi without also bundling all of MySql and Postgres. That's unfortunately not the case with Macs.
13:15:38 <jralls> Sorry, I meant "all of the MySql and Postgres clients". No need for the server, obviously.
13:17:48 <tcastleman> jralls: Understood, thanks for the insight.
13:19:02 <tcastleman> jralls: So if taking on this job for a price is not something you are interested in, would you be interested in talking me through doing it myself?
13:21:44 <jralls> OK. Do you still have your gtk-osx build environment?
13:22:32 <tcastleman> No.. I just have the latest packaged Mac version of GNUCash 2.6.5 installed.
13:22:45 <tcastleman> It is possible to only build the libdbi mysql driver without having to build all of GNUCash
13:22:48 <tcastleman> ?
13:32:50 <jralls> Yes, but you need to also build the mysql client for the driver to link to. Gtk-osx provides a nice build environment and a very simple procedure for building each, though I haven't tested the mysql build in a long time.
13:33:15 <jralls> Do you have Xcode installed?
13:33:22 <tcastleman> Yes I have XCode.
13:35:10 <jralls> OK. What about MacPorts? Do you have their /opt/local tree?
13:35:21 <tcastleman> yes
13:36:09 <jralls> Then you'll need a clean environment. The easiest way to get one is to create a new user and switch to it.
13:36:35 <tcastleman> OK
13:37:04 <jralls> Then go to https://wiki.gnome.org/Projects/GTK%2B/OSX/Building and follow the procedure up through running jhbuild bootstrap.
13:39:11 <tcastleman> OK.. will do this and brb
13:39:35 <jralls> Wait, there's a couple more steps:
13:39:50 <tcastleman> OK
13:39:51 <jralls> git clone git@github.com:jralls/gnucash-on-osx.git
13:40:50 <jralls> jhbuild --moduleset=gnucash-on-osx/modules/gnucash.modules jhbuild mysql
13:42:45 <jralls> If that all works, you just need to build libdbi-drivers, but there's a tweak to gnucash.modules first. Go ahead and try mysql.
13:44:18 <tcastleman> OK, thanks. Really appreciate this. I'll just swtich and try that.
13:57:53 *** tcastleman_dev has joined #gnucash
14:04:16 <tcastleman_dev> jralls: jhbuild bootstrap completed successfully.
14:04:29 <tcastleman_dev> jhbuild --moduleset=gnucash-on-osx/modulesets/gnucash.modules jhbuild mysql
14:04:30 <tcastleman_dev> jhbuild jhbuild: no such command (did you mean "jhbuild run jhbuild"?)
14:04:32 <jralls> Good.
14:04:51 <jralls> No, `jhbuild build mysql`
14:05:06 <tcastleman_dev> ahhh 2 separate commands! I see
14:05:32 <jralls> But with the --moduleset= bit/
14:05:58 <tcastleman_dev> got it.
14:06:00 *** cartsoftware has joined #gnucash
14:07:56 <tcastleman_dev> jralls: OK all that worked.
14:10:02 <jralls> Yay. I don't remember offhand the name of the library mysql makes, but we need to double-check and make sure it's 32-bit. So do `ls gtk/inst/lib/` to find the name of a likely name (should end in .dylib) and run `file` on that.
14:10:45 <tcastleman_dev> libmysql.16.0.0.dylib
14:10:46 <tcastleman_dev> libmysql.16.dylib
14:10:48 <tcastleman_dev> libmysql.dylib
14:10:50 <tcastleman_dev> libmysqlclient.a
14:10:51 <tcastleman_dev> libmysqlclient.dylib
14:10:52 <tcastleman_dev> libmysqlclient_r.dylib
14:11:15 <jralls> Any one of those will work.
14:11:34 <jralls> `file gtk/inst/lib/libmysql.dylib`
14:11:58 <tcastleman_dev> gtk/inst/lib/libmysql.dylib: Mach-O 64-bit dynamically linked shared library x86_64
14:12:32 *** mlncn-agaric has joined #gnucash
14:14:54 <jralls> Rats. Edit ~/.jhbuildrc-custom and at line 125 change _default_arch to i386
14:16:34 <jralls> Then run the build command over as jhbuild --moduleset=gnucash-on-osx/modules/gnucash.modules jhbuild --force --clean mysql
14:17:30 <jralls> Oy, that should be 'i386', the quotes are important.
14:18:12 *** mlncn has quit IRC
14:21:51 <tcastleman_dev> gtk/inst/lib/libmysql.dylib: Mach-O dynamically linked shared library i386
14:21:58 <tcastleman_dev> :D
14:23:22 <jralls> Good. Now edit gnucash-on-osx/modulesets/gnucash.modules.
14:23:50 <tcastleman_dev> ok
14:27:29 <jralls> At line 178 you need to change the autogenargs to --with-mysql --disable-docs --with-mysql-incdir="$PREFIX/include" --with-mysql-libdir="$PREFIX/lib" Be sure to leave the single quotes wrapping the whole thing.
14:28:11 <jralls> Then run jhbuild --moduleset=gnucash-on-osx/modules/gnucash.modules jhbuild libdbi-drivers
14:30:53 <tcastleman_dev> configure: error: Invalid libdbi directory - include files not found.
14:30:55 <tcastleman_dev> *** Error during phase configure of libdbi-drivers: ########## Error running ./configure --prefix /Users/dev/gtk/inst --libdir '/Users/dev/gtk/inst/lib' --with-mysql --disable-docs --with-mysql-incdir="$PREFIX/include" --with-mysql-libdir="$PREFIX/lib" *** [2/2]
14:32:01 <jralls> Odd. ls gtk/inst/include/mysql?
14:33:01 <tcastleman_dev> that is a directory full of .h files.
14:39:09 <jralls> Good. Look at gtk/src/libdbi-drivers-0.8.3-1/config.log and scroll down to the error. See if you can figure out why it didn't find what it's looking for.
14:42:42 <tcastleman_dev> possibly here:
14:42:43 <tcastleman_dev> conftest.c:11:10: fatal error: 'ac_nonexistent.h' file not found
14:42:45 <tcastleman_dev> #include <ac_nonexistent.h>
14:42:46 <tcastleman_dev> ^
14:43:36 <jralls> Keep going. That's checking to make sure that the compiler errors out when it doesn't find a required include.
14:44:11 <tcastleman_dev> configure:12137: checking for libdbi framework
14:44:12 <tcastleman_dev> configure:12161: result: no
14:44:13 <tcastleman_dev> configure:12163: error: Invalid libdbi directory - include files not found.
14:44:20 *** MechtiIde has quit IRC
14:44:45 *** aqua___ has joined #gnucash
14:46:42 <jralls> Ah, so it needs --with-dbi-incdir="$PREFIX/include" --with-dbi-libdir="$PREFIX/lib" as well. Is that the last error?
14:47:51 <tcastleman_dev> yes
14:48:12 <jralls> Maybe better check that they're there: ls gtk/inst/include/dbi
14:49:03 <tcastleman_dev> yes they are there
14:50:56 <tcastleman_dev> OK edited and rebuilding
14:51:30 <tcastleman_dev> OK I think that worked
14:53:04 <tcastleman_dev> I now have gtk/inst/lib/dbd/libdbdmysql.so
14:57:43 <jralls> Good. Now run otool -L gkt/inst/lib/dbd/libdbdmysql.so. That will list dependencies. You need to copy all of the ones that start with gkt/inst/lib to Gnucash.app/Contents/Resources/lib
14:58:19 <jralls> And copy gtk/inst/lib/dbd/libdbdmysql.so to Gnucash.app/Contents/Resources/lib/dbd
14:59:19 <jralls> And remove Gnucash.app/Contents/__CodeSignature
14:59:42 <jralls> Which is a directory, so rm -rf.
15:04:19 <jralls> One last step: For each of those dependencies you need to run install_name_tool -change /Users/tcastleman_dev/gtk/inst/lib/foo.dylib @executive_path/../Resources/lib/foo.dylib Gnucash.app/Contents/Resources/lib/dbd/libdbdmysql.so
15:05:11 <jralls> You'll need to repeat that process for each of the other libs you copied into Gnucash.app.
15:09:05 *** O01eg has quit IRC
15:09:11 *** gour has quit IRC
15:10:07 <tcastleman> jralls: these are the dependancies
15:10:11 <tcastleman> gtk/inst/lib/dbd/libdbdmysql.so:
15:10:13 <tcastleman> libmysql.16.dylib (compatibility version 16.0.0, current version 16.0.0)
15:10:14 <tcastleman> /Users/dev/gtk/inst/lib/libdbi.1.dylib (compatibility version 2.0.0, current version 2.0.0)
15:10:24 <tcastleman> is it only libdbi.1.dylib I need to copy?
15:11:03 <tcastleman> or libmysql.16.dylib as well?
15:12:25 <jralls> libdbi.1.dylib is already there. You need libmysql.16.dylib, but run otool -L on it as well to make sure it doesn't need anything.
15:17:39 *** O01eg has joined #gnucash
15:26:25 *** KaiForce has quit IRC
15:31:07 <tcastleman> jralls: OK so I have copied everything into place.
15:31:24 <tcastleman> Unfortunately mysql doesn't show up in the open dialog :s
15:31:56 <tcastleman> jralls: what troubleshooting steps would you suggest?
15:33:13 <jralls> First look at the tracefile (run sudo find /var/folders -name gnucash.trace -exec less {} \;) and see if there are any error messages.
15:35:19 <tcastleman> * 20:30:26 WARN <gnc.backend.dbi> [gnc_module_init_backend_dbi()] No DBD drivers found
15:37:17 <tcastleman> I notice this:
15:37:20 <tcastleman> otool -L Gnucash.app/Contents/Resources/lib/libdbi.1.dylib
15:37:22 <tcastleman> Gnucash.app/Contents/Resources/lib/libdbi.1.dylib:
15:37:23 <tcastleman> /Users/john/Development/Gnucash-Build/Gnucash-2.6-Leopard/inst/lib/libdbi.1.dylib (compatibility version 2.0.0, current version 2.0.0)
15:37:25 <tcastleman> /usr/lib/libSystem.B.dylib (compatibility version 1.0.0, current version 111.1.4)
15:37:26 <tcastleman> /usr/lib/libgcc_s.1.dylib (compatibility version 1.0.0, current version 1.0.0)
15:37:28 <tcastleman> Is that a problem?
15:38:23 <tcastleman> You see the sqllite doesn't show up either.
15:39:04 <warlord> that error means that DBI isn't finding the DBD libs where it expects to find them
15:42:45 <jralls> tcastleman: No, that's the id. That part is OK. Run otool -L on dbd/libdbdsqlite3.so
15:43:19 <tcastleman> otool -L Gnucash.app/Contents/Resources/lib/dbd/libdbdsqlite3.so
15:43:21 <tcastleman> Gnucash.app/Contents/Resources/lib/dbd/libdbdsqlite3.so:
15:43:22 <tcastleman> /usr/lib/libsqlite3.0.dylib (compatibility version 9.0.0, current version 9.6.0)
15:43:24 <tcastleman> @executable_path/../Resources/lib/libdbi.1.dylib (compatibility version 2.0.0, current version 2.0.0)
15:43:25 <tcastleman> /usr/lib/libgcc_s.1.dylib (compatibility version 1.0.0, current version 1.0.0)
15:43:27 <tcastleman> /usr/lib/libSystem.B.dylib (compatibility version 1.0.0, current version 111.1.4)
15:47:39 <jralls> OK. Make sure that /usr/lib/libsqlite3.0.dylib is there.
15:48:52 <jralls> Move libdbdmysql.so somewhere else and relaunch GnuCash to see if having it there is messing up recognizing libdbdsqlite3.
15:53:25 <tcastleman> /usr/lib/libsqlite3.0.dylib is there
15:53:55 <tcastleman> and moving libdbdmysql.so out of dbd makes no difference
15:54:04 <tcastleman> Same warning in the trace
15:54:29 <tcastleman> Should SQLLite show in the "Data Format" drop down?
16:00:23 <jralls> It should in File>Save As, but not in File>Open.
16:00:48 <tcastleman> OK.. sqllite isn't in there either
16:00:54 <jralls> File>Open uses "File" for both XML and SQLite3.
16:01:08 <tcastleman> which makes sense given the trace Warning about No DBD drivers
16:01:46 *** ErKa has quit IRC
16:03:26 <jralls> Dang. You're right. Doesn't show up for me either with the latest build.
16:04:56 <tcastleman> Eek
16:07:43 <jralls> Crap. Libdbi isn't in the bundle.
16:09:17 <tcastleman> Just heading home, I'll be back in a bit :-)
16:09:59 <jralls> I'm going to have to leave in a bit too, and may not be back today.
16:19:22 *** tcastleman has quit IRC
16:19:57 *** tcastleman_dev has quit IRC
16:44:15 *** rubdos has quit IRC
16:51:38 <jralls> @tell tcastleman I found the problem, and it's easily fixed. Edit Gnucash.app/Contents/Resources/etc/gnucash/environment and delete the line GNC_DBD_DIR=...
16:51:38 <gncbot> jralls: The operation succeeded.
17:08:50 <warlord> jralls: do you think it might be confusing that the intel and ppc bundles are different dash-levels?
17:09:27 <jralls> Not really. It's happened before and no-one seemed to care.
17:13:41 *** tcastleman has joined #gnucash
17:14:06 <tcastleman> jralls: I'm back now.
17:14:07 <gncbot> tcastleman: Sent 22 minutes ago: <jralls> I found the problem, and it's easily fixed. Edit Gnucash.app/Contents/Resources/etc/gnucash/environment and delete the line GNC_DBD_DIR=...
17:14:11 *** tcastleman_dev has joined #gnucash
17:14:39 *** gjanssens_ has quit IRC
17:18:25 <tcastleman> jralls: excellent. problem solved and mysql working fine! Many thanks for your help on this.
17:18:43 <jralls> Huzzah, and you're welcome.
17:23:02 <tcastleman> I really appreciate your help.
17:23:08 <tcastleman> :D
17:34:24 *** tcastleman_dev has quit IRC
17:34:44 *** ErKa has joined #gnucash
17:38:00 *** tcastleman has quit IRC
17:49:21 <jralls> Gotta go now.
17:49:29 *** jralls is now known as jralls_afk
18:06:48 *** rickoehn has quit IRC
18:10:21 *** tcastleman has joined #gnucash
18:11:40 <tcastleman> On MacOSX the default GTK theme which ships with gnucash looks rather dated. Is there a way to use a more modern "yosemite" style theme?
18:20:49 *** aqua___ has quit IRC
18:44:53 *** tcastleman has quit IRC
19:30:15 *** LucP has joined #gnucash
19:30:54 *** LucP has left #gnucash
19:47:27 *** StuM has joined #gnucash
19:49:43 *** ErKa has quit IRC
20:08:50 *** jchonig_ has quit IRC
20:28:41 *** jchonig has joined #gnucash
21:21:15 *** GabrieleV_ has joined #gnucash
21:21:16 *** GabrieleV has quit IRC
21:21:16 *** GabrieleV_ is now known as GabrieleV
22:26:48 *** GabrieleV_ has joined #gnucash
22:27:08 *** GabrieleV has quit IRC
22:27:09 *** GabrieleV_ is now known as GabrieleV
23:19:32 *** cartsoftware has quit IRC
23:21:49 *** GabrieleV_ has joined #gnucash
23:21:52 *** GabrieleV has quit IRC
23:21:52 *** GabrieleV_ is now known as GabrieleV