GnuCash doesn't support HBCI

Thank you for your bugreport. I noticed that to latest version of gnucash failed to build anyway, so we first have to investigate that failure. From the buildlogs, it looks like problems in packages, gnucash is dependend on.

In order to get your particular problem with hbci fixed, I'd suggest to ping the debian maintainer again and ask for a status update. In the meantime, we try to get the package built on all architectures.

Debian won't include GnuCash HBCI because of the linked openssl (in gwenhywfar). There are unofficial packages available for unstable. If Ubuntu doesn't have the same problems with openssl as Debian (Gnutls is not yet as popular as openssl), please include the hbci-aware package in Ubuntu.
http://people.debian.org/~tviehmann/debian/

Quoting From: Thomas Bushnell BSG <email address hidden>:
I'm afraid I have to ask you not to do this.

It is not that the package isn't DFSG, it's that it is *illegal* for
*anyone* to distribute it. Anyone. Anyone at all. You *cannot*
distribute it, because it is *not* in compliance with the GPL.

Please remove the packages ASAP.

-----

I'm afraid that he is right. The other possibility would be to ask the Gwenhywfar authors to explicitly allow redistribution of binaries of their software against openssl. AFAIU they licenced their software under plain gpl, which prohibits distribution of binaries linked against openssl. Sorry.

gnucash needs to be ported to use gnutls instead of openssl first. See the debian bugreport for this

The above statemant is wrong. In discussion with jsled, and warlord, 2 of the major developers of GnuCash, the following is the case:

Quote from README from AqBanking where he specifically allows linking against OpenSSL.
AqBanking is licensed under the GPL (see below).

If you want to use AqBanking in non-GPL software you can get an individual
license from the author (<email address hidden>).
As the copyright holder of AqBanking, Martin Preuss grants the following
license exception:
Martin Preuss explicitly allows the compilation and distribution of
AqBanking with the OpenSSL Toolkit.
No developer is required to provide this exception in a derived work.

So there shouldn't be any bug about it. Please reopen if you still belive it is wrong, and have other info on it.

Sorry, was a little bit too fast, it is still a bug that it is not shipped, so it shouldn't be closed until gnucash-hbci is shipped. But read on the above that it's not the license issue..

It would be great if the gnucash 2.0 packages could be build with aqbanking support now that 2.0 was released.

so? when will hbci be enabled in gnucash now?

As soon as are legally allowed to do this. AFAIU, libgwenhywfar needs to be ported to GnuTLS. Until then, you need to recompile yourself.

As interim workaround, try this:

cat <<EOM | sudo tee -a /etc/apt/sources.list
deb http://ppa.dogfood.launchpad.net/siretart/ubuntu/ gutsy main universe
deb-src http://ppa.dogfood.launchpad.net/siretart/ubuntu/ gutsy main universe
EOM

sudo apt-get update
sudo apt-get install gnucash-hbci

Packages are based on http://aqbanking.alioth.debian.org/ and rebuilt against gutsy.

I was told by the maintainer of aqbanking in Debian (Micha Lenk) that aqbanking was ported to GnuTLS and this version currently in beta. This means we might get a HBCI-enabled Gnucash in Gutsy+1.

Oh and by the way, Reinhard: I thought the same about putting it onto ppa. I'm grateful that you've done it but I was personally very vary about whether we are allowed to upload packages with OpenSSL linkage problems (there are more of them, like vpnc).

Latest libaqbanking 3.0.1-1 release is in experimental debian repositories. According to http://wiki.gnucash.org/wiki/AqBanking3_Porting, there's still some work to do before Gnucash can compile with this library.

Hi,

Saïvann Carignan schrieb:
> Latest libaqbanking 3.0.1-1 release is in experimental debian
> repositories.

No, libaqbanking 3.0.1-1 is in unstable and will progress to Debian
Lenny within the next week or so. AqBanking 2.x should be considered
obsolete and will not be shipped with Debian Lenny.

Regards
  Micha

Is this bug ready for closing with libaqhbci13 being in hardy?

Hi Rolf,

Rolf Leggewie schrieb:
> Is this bug ready for closing with libaqhbci13 being in hardy?

No, Gnucash is yet not ready to be built with the most recent version
(>= 3.x) of AqBanking. It still needs AqBbanking 2.x, which causes these
ugly license problems.

Gnucash needs to be ported to AqBanking 3.x first. This is work in
progress, but yet not finished. See [1] for further details.

1. http://wiki.gnucash.org/wiki/AqBanking3_Porting

Regards
  Micha

Updated packages are available at https://launchpad.net/~gnucash/+archive. The name seems to suggest there is a version of gnucash 2.2.4 with hbci support available. But the relevant menu entries are missing. I compiled gnucash on my own and can happily report that hbci is working rather nicely with aqbanking3. We should be seeing some progress here, soon.

Thanks, Micha.

Hi,

I tried the PPA packages and I now got the Online actions and can start the aqbanking wizard. Unfortunately, it doesn't work so far - it says Timeout instantly. Guess this is a bug in the timeout settings? Do you know, if I can change this somewhere?

12:58:14
AqHBCI gestartet
12:58:14
Mit Bank verbinden...
12:58:14
Ermittle Adresse von "hbci-pintan-by.s-hbci.de" ...
12:58:14
Ermittelte IP Adresse ist 195.140.107.125
12:58:14
Selecting iTAN mode "iTAN"
12:58:14
Aufträge werden kodiert
12:58:17
Aufträge werden gesendet
12:58:17
Mit Bank verbinden...
12:58:19
Verbunden.
12:58:19
Warte auf Antwort
12:58:19
Keine Antwort (Timeout)
12:58:19
AqHBCI abgeschlossen.
12:58:19
Abgeschlossen. Sie können dieses Fenster nun schließen.

Rolf, you need to have the package gnucash-hbci installed in order to get the Online Banking menu entries.

Bastian: Do you have the package libaqbanking-plugins-libgwenhywfar47 installed?

Am Freitag, den 20.06.2008, 11:24 +0000 schrieb Micha Lenk:

> Rolf, you need to have the package gnucash-hbci installed in order to
> get the Online Banking menu entries.
>
> Bastian: Do you have the package libaqbanking-plugins-libgwenhywfar47
> installed?
>

Yes, I have installed the following package:

$ apt-cache showpkg libaqbanking-plugins-libgwenhywfar47
Package: libaqbanking-plugins-libgwenhywfar47
Versions:
3.3.0+dfsg-1build1
(/var/lib/apt/lists/ppa.launchpad.net_gnucash_ubuntu_dists_hardy_main_binary-i386_Packages) (/var/lib/dpkg/status)
 Description Language:

File: /var/lib/apt/lists/ppa.launchpad.net_gnucash_ubuntu_dists_hardy_main_binary-i386_Packages
                  MD5: b02281bffdd5ed04e67c29999c223b59

3.3.0+dfsg-1
(/var/lib/apt/lists/archive.ubuntu.com_ubuntu_dists_hardy_universe_binary-i386_Packages)
 Description Language:

File: /var/lib/apt/lists/archive.ubuntu.com_ubuntu_dists_hardy_universe_binary-i386_Packages
                  MD5: b02281bffdd5ed04e67c29999c223b59

Reverse Depends:
  libaqbanking20,libaqbanking-plugins-libgwenhywfar47
  libaqbanking20,libaqbanking-plugins-libgwenhywfar47
Dependencies:
3.3.0+dfsg-1build1 - libaqbanking20 (0 (null)) libc6 (2 2.7-1)
libgwenhywfar47 (0 (null))
3.3.0+dfsg-1 - libaqbanking20 (0 (null)) libc6 (2 2.4) libgwenhywfar47
(0 (null))
Provides:
3.3.0+dfsg-1build1 - libaqbanking-plugins-libgwenhywfar
3.3.0+dfsg-1 - libaqbanking-plugins-libgwenhywfar
Reverse Provides:

Thanks for the hint, Micha. There is no gnucash-hbci package anywhere. But it looks like Bastian's comment proves that it can be done somehow.

If you add the ppa to your sources it should turn up. My sources looks like this:

$ cat /etc/apt/sources.list | grep ppa
deb http://ppa.launchpad.net/gnucash/ubuntu hardy main

Attached you find a screenshot showing the entries in synaptic.

Thanks, Bastian. It's pretty strange, "apt-cache policy gnucash-hbci" knows about the package, but aptitude itself still does not. Well, I installed the package now and will give it a spin.

This bug has been fixed in Debian, we could now merge it.

I suggest we wait just a few more days until 2.2.6 is out.

This bug was fixed in the package gnucash - 2.2.6-1ubuntu1

---------------
gnucash (2.2.6-1ubuntu1) intrepid; urgency=low

  * Merge from Debian unstable. (LP: #252099) Remaining Ubuntu changes:
    + debian/control: build-dep change from libungif4-dev to libgif-dev
    + debian/rules:
      - Don't ignore make clean errors, instead check if a Makefile exists, if
        not, don't call make clean
    + debian/control:
      - Change maintainer to MOTU.
  * new version support HBCI properly (LP: #5973, finally!)
  * Build dependencies have been cleaned up in debian (LP: #178811)
  * No longer crashes when selecting selecting SKR04 (LP: #218723)

gnucash (2.2.6-1) unstable; urgency=low

  * New upstream release. (Closes: #492706, #492711, #492705, #492707,
    #492708, #491843, #473657, #481290).
  * debian/rules (configure): Add --enable-python-bindings and
    --enable-locale-specific-tax.
  * debian/control (Build-Depends): Remove build dependencies no longer
    needed (libltd3-dev, liborbit-dev, libungif4-dev), or which are
    indirect (libjpeg62-dev, libbonobo2-dev, libgnomevfs2-dev,
    libgnomevfs2-extra, imagemagick, libart-2.0-dev).

  * src/import-export/aqbanking/gnc-ab-utils.c (gnc_ab_get_remote_name):
    Actually get remote name, not purpose. Patch thanks to Micha Lenk.
    (Closes: #492799).

gnucash (2.2.4-2) unstable; urgency=low

  * Apply Micha Lenk patch to turn on aqbanking. (Closes: 303234)
  * debian/rules (configure): Specify --enable-aqbanking and --enable-hbci.
  * debian/control (gnucash): Mention HBCI support.
    (Build-Depends): Require libaqbanking20-dev.
  * debian/README.debian: Drop apology for HBCI non-support.

  * debian/rules (configure): Don't print out config.log on failure anymore.

 -- Reinhard Tartler <email address hidden> Sun, 03 Aug 2008 09:31:17 +0200

Wow. That looks like quite a lot of work... Thanks for doing it. Is there a change to have a package for hardy in the ppa? Or is it too complicated/too much work to backport it?

Thanks again for your work!

Bastian Doetsch : Indeed. We're already discussing about the hardy backport. The bug report is here : bug 243436 .

https://launchpad.net/~gnucash/+archive

the gnucash packaging team has provided hbci-enabled packages for 2.2.4 for some time now. another option.

I just asked saivann privately via email to upload gnucash 2.2.6 and libaqbanking 3.5 packages to the ~gnucash PPA. Stay tuned!

Wow, great. Just saw that

gnucash-common_2.2.6-1ubuntu1~hardy1_all.deb
and
gnucash_2.2.6-1ubuntu1~hardy1_*.deb
are in the PPA.

Is the gnucash-hbci package still in the queue or is it not needed anymore because its included in the gnucash package now?

Thanks a lot for the good work!

-Marc

Marc: There is no separate gnucash-hbci package any more. The functionality previously provided by gnucash-hbci is now integrated into the package gnucash.

Regards
  Micha

I've just tried the new PPA packages - and still get the timeout message (see https://bugs.launchpad.net/ubuntu/+source/gnucash/+bug/5973/comments/18)

Marc Schiffbauer : Thanks! I actually did a very little part of this huge job :)

Bastian Doetsch : I suspect that this is due to current libaqbanking version in Hardy. That's why Reinhard Tartler suggested that it would be interesting to backport libaqbanking to hardy-backports too. If everything works well, libaqbanking should get in the PPA during the day so you can look if it works better for you. Thanks for your feedback!

Bastian Doetsch: Please provide the output generated in the shell when you start Gnucash from the command line.

Am Dienstag, den 05.08.2008, 17:30 +0000 schrieb Micha Lenk:

> Bastian Doetsch: Please provide the output generated in the shell when
> you start Gnucash from the command line.
>

Micha: Here's the output. If I should enable some sort of debug-setting,
just tell me where and how and I'll test again :-).

$ gnucash
gnc.bin-Message: main: binreloc relocation support was disabled at
configure time.

Found Finance::Quote version 1.13
gwenhywfar-INFO: plugin.c: 567: Plugin type "ct" unregistered
gwenhywfar-INFO: plugin.c: 567: Plugin type "dbio" unregistered

Thanks for taking the time to lend a hand to the problems. You guys are
doing an awesome job.

Bastian: Uhm, yes, this was the boring part of the output. I'm interested in the output produced during you're trying online actions. Aren't there any?

Regards
  Micha

Am Dienstag, den 05.08.2008, 20:45 +0000 schrieb Micha Lenk:

> Bastian: Uhm, yes, this was the boring part of the output. I'm
> interested in the output produced during you're trying online actions.
> Aren't there any?
>
> Regards
> Micha
>

Micha: Exactly, there isn't any more output, that's why I asked for how
to enable debug settings. I tried to get my account balance via online
actions, so there should have been something?!

Regards,
Bastian

Bastian: You can run gnucash with debugging enabled by running the following command:

gnucash --logto stderr --log gnc.import.aqbanking=debug

Here's the output:

$ gnucash --logto stderr --log gnc.import.aqbanking=debug
gnc.bin-Message: main: binreloc relocation support was disabled at configure time.

* 08:03:33 WARN <gnc.app-util> /home/bastian/.gnucash/config-1.8.auto:7:15: While evaluating arguments to gnc:lookup-option in expression (gnc:lookup-option gnc:*options-entries* "Register" ...):
/home/bastian/.gnucash/config-1.8.auto:7:15: Unbound variable: gnc:*options-entries*
In /home/bastian/.gnucash/config-1.8.auto:
   7: 0* (let ((option #)) ((lambda # #) option))
   7: 1* [gnc:lookup-option ...
Found Finance::Quote version 1.13
* 08:03:35 DEBUG <gnc.import.aqbanking> [enter gnc-plugin-aqbanking.c:gnc_plugin_ab_main_window_page_added()] main window 0x81dc000, page 0x8074978
* 08:03:35 DEBUG <gnc.import.aqbanking> [gnc_plugin_ab_main_window_page_added] account tree page, adding signal
* 08:03:35 DEBUG <gnc.import.aqbanking> [leave gnc_plugin_ab_main_window_page_added()]
* 08:03:35 DEBUG <gnc.import.aqbanking> [enter gnc-plugin-aqbanking.c:gnc_plugin_ab_main_window_page_added()] main window 0x81dc000, page 0x860bc50
* 08:03:35 DEBUG <gnc.import.aqbanking> [leave gnc_plugin_ab_main_window_page_added()]
* 08:03:35 DEBUG <gnc.import.aqbanking> [enter gnc-plugin-aqbanking.c:gnc_plugin_ab_main_window_page_added()] main window 0x81dc000, page 0x860bf48
* 08:03:35 DEBUG <gnc.import.aqbanking> [leave gnc_plugin_ab_main_window_page_added()]
* 08:03:35 DEBUG <gnc.import.aqbanking> [enter gnc-plugin-aqbanking.c:gnc_plugin_ab_main_window_page_added()] main window 0x81dc000, page 0x861a1e0
* 08:03:35 DEBUG <gnc.import.aqbanking> [leave gnc_plugin_ab_main_window_page_added()]
* 08:03:41 DEBUG <gnc.import.aqbanking> [enter gnc-plugin-aqbanking.c:gnc_plugin_ab_main_window_page_added()] main window 0x81dc000, page 0x82640f0
* 08:03:41 DEBUG <gnc.import.aqbanking> [leave gnc_plugin_ab_main_window_page_added()]
* 08:03:41 DEBUG <gnc.import.aqbanking> [enter gnc-plugin-aqbanking.c:gnc_plugin_ab_main_window_page_added()] main window 0x81dc000, page 0x8a933b0
* 08:03:41 DEBUG <gnc.import.aqbanking> [leave gnc_plugin_ab_main_window_page_added()]
* 08:03:45 DEBUG <gnc.import.aqbanking> [enter gnc-plugin-aqbanking.c:gnc_plugin_ab_cmd_get_transactions()] action 0x82d12d8, main window data 0x8404dd8
* 08:03:45 DEBUG <gnc.import.aqbanking> [enter gnc-plugin-aqbanking.c:main_window_to_account()] main window 0x81dc000
* 08:03:45 DEBUG <gnc.import.aqbanking> [main_window_to_account] account tree page
* 08:03:45 DEBUG <gnc.import.aqbanking> [leave main_window_to_account()] account DKB Cash(0x86ff910)
* 08:03:50 DEBUG <gnc.import.aqbanking> [enter gnc-gwen-gui.c:gnc_GWEN_Gui_get()] parent=0x81dc000
* 08:03:50 DEBUG <gnc.import.aqbanking> [enter gnc-gwen-gui.c:setup_dialog()] gui=0x8d98340
* 08:03:50 DEBUG <gnc.import.aqbanking> [enter gnc-gwen-gui.c:reset_dialog()] gui=0x8d98340
* 08:03:50 DEBUG <gnc.import.aqbanking> [leave reset_dialog()]
* 08:03:50 DEBUG <gnc.import.aqbanking> [leave setup_dialog()]
* 08:03:50 DEBUG <gnc.import.aqbanking> [enter gnc-gwen-gui.c:register_callbacks()] gui=0x8d98340
* 08:03:50 DEBUG <gnc.imp...

The interesting part might be this message:
* 08:03:56 CRIT <gwenhywfar> io_tls.c: 939: gnutls_record_recv: -9 (A TLS packet with unexpected length was received.) [decoding 1024 bytes]

Please try aqbanking version in deb http://ppa.launchpad.net/gnucash/ubuntu hardy main

Bastian: You're right, this is the interesting part:
* 08:03:56 CRIT <gwenhywfar> io_tls.c: 939: gnutls_record_recv: -9 (A TLS packet with unexpected length was received.)

This message indicates that your problem might be fixed by checking the "Force SSLv3" (or in German "SSLv3 erzwingen") checkbox in the online banking settings of your HBCI account.

Am Mittwoch, den 06.08.2008, 12:15 +0000 schrieb Micha Lenk:
> Bastian: You're right, this is the interesting part:
> * 08:03:56 CRIT <gwenhywfar> io_tls.c: 939: gnutls_record_recv: -9 (A TLS packet with unexpected length was received.)
>
> This message indicates that your problem might be fixed by checking the
> "Force SSLv3" (or in German "SSLv3 erzwingen") checkbox in the online
> banking settings of your HBCI account.
>

Doesn't work (used the latest aqbanking debs from the ppa). I've tried
several options as you can see:

$ gnucash --logto stderr --log gnc.import.aqbanking=debug
gnc.bin-Message: main: binreloc relocation support was disabled at
configure time.

* 18:55:01 WARN
<gnc.app-util> /home/bastian/.gnucash/config-1.8.auto:7:15: While
evaluating arguments to gnc:lookup-option in expression
(gnc:lookup-option gnc:*options-entries* "Register" ...):
/home/bastian/.gnucash/config-1.8.auto:7:15: Unbound variable:
gnc:*options-entries*
In /home/bastian/.gnucash/config-1.8.auto:
   7: 0* (let ((option #)) ((lambda # #) option))
   7: 1* [gnc:lookup-option ...
Found Finance::Quote version 1.13
* 18:55:03 DEBUG <gnc.import.aqbanking> [enter
gnc-plugin-aqbanking.c:gnc_plugin_ab_main_window_page_added()] main
window 0x81dc000, page 0x8074978
* 18:55:03 DEBUG <gnc.import.aqbanking>
[gnc_plugin_ab_main_window_page_added] account tree page, adding signal
* 18:55:03 DEBUG <gnc.import.aqbanking> [leave
gnc_plugin_ab_main_window_page_added()]
* 18:55:03 DEBUG <gnc.import.aqbanking> [enter
gnc-plugin-aqbanking.c:gnc_plugin_ab_main_window_page_added()] main
window 0x81dc000, page 0x860ac50
* 18:55:03 DEBUG <gnc.import.aqbanking> [leave
gnc_plugin_ab_main_window_page_added()]
* 18:55:03 DEBUG <gnc.import.aqbanking> [enter
gnc-plugin-aqbanking.c:gnc_plugin_ab_main_window_page_added()] main
window 0x81dc000, page 0x860af48
* 18:55:03 DEBUG <gnc.import.aqbanking> [leave
gnc_plugin_ab_main_window_page_added()]
* 18:55:04 DEBUG <gnc.import.aqbanking> [enter
gnc-plugin-aqbanking.c:gnc_plugin_ab_main_window_page_added()] main
window 0x81dc000, page 0x861a1e0
* 18:55:04 DEBUG <gnc.import.aqbanking> [leave
gnc_plugin_ab_main_window_page_added()]
* 18:55:09 DEBUG <gnc.import.aqbanking> [enter
gnc-plugin-aqbanking.c:gnc_plugin_ab_main_window_page_added()] main
window 0x81dc000, page 0x82640f0
* 18:55:09 DEBUG <gnc.import.aqbanking> [leave
gnc_plugin_ab_main_window_page_added()]
* 18:55:09 DEBUG <gnc.import.aqbanking> [enter
gnc-plugin-aqbanking.c:gnc_plugin_ab_main_window_page_added()] main
window 0x81dc000, page 0x8a8e3b0
* 18:55:09 DEBUG <gnc.import.aqbanking> [leave
gnc_plugin_ab_main_window_page_added()]
* 18:55:14 DEBUG <gnc.import.aqbanking> [enter
gnc-plugin-aqbanking.c:gnc_plugin_ab_cmd_setup()] action 0x81e72d0, main
window data 0x8414618
* 18:55:14 DEBUG <gnc.import.aqbanking> [leave
gnc_plugin_ab_cmd_setup()]
* 18:55:16 WARN <aqhbci> hbci-updates.c: 51: Updating user from
3.3.0.0
* 18:55:16 WARN <aqhbci> hbci-updates.c: 51: Updating user from
3.3.0.0
* 18:55:16 WARN <aqhbci> hbci-updates.c: 51: Updating user from
3.3.0.0
* 18:55:16 WARN <aqhbci> hbci-updates.c: 127: Updating account from
3.3.0.0
* 18:55:16 WARN <aqhbci> h...

Mmh, I don't really know what we should do about it, or even if it's a gnucash or libaqbanking bug. At least we have good debugging informations. Perhaps that you could open a bug in gnucash upstream bug tracking system (and/or libaqbanking if this project have a bug tracking system).

Am Samstag, den 09.08.2008, 06:52 +0000 schrieb Saïvann Carignan:

> Mmh, I don't really know what we should do about it, or even if it's a
> gnucash or libaqbanking bug. At least we have good debugging
> informations. Perhaps that you could open a bug in gnucash upstream bug
> tracking system (and/or libaqbanking if this project have a bug tracking
> system).
>

Hm. I'll probably try to file this for aqbanking as this is where it
fails... Thanks for your help, though.

Bastian

Patches to improve HBCI support has been added to gnucash svn tree. I opened a new bug report for current HBCI issues in gnucash : bug 269686 .

If there are volunteer people to test new patches, most probably that feedback will be needed soon (once that 2.2.7 gets released, or once a patched package is built)

Hi,

the timeout problem persists :-(. I've now filed bug reports at:

https://bugs.launchpad.net/ubuntu/+source/libaqbanking/+bug/277567 (against AqBanking source pkg)

and

https://devel.aqbanking.de/trac/aqbanking/ticket/32 (AqBanking upstream).

Bastian

setting SSLv3 in HBCI Options worked, so for me HBCI is now usable.