Re: [GNC] Balance Sheet Issue

[John Ralls]

> On Sep 4, 2018, at 4:05 PM, Stephen M. Butler  wrote:
> 
> On 09/04/2018 02:53 PM, Paul Schwartz wrote:
>> If I want to reproduce the Balance Sheet Report I get from version 2.6.12
>> in version 2.6.19, are there files that I can othe copy from one to the
>> other?
>> 
>> Paul
> I forgot which OS you have.  On Ubuntu (local build) they are in
> /usr/local/share/gnucash/scm/gnucash/report/standard-reports
> 
> I think it is one file (if you are talking about the non-eguile one): 
> balance_sheet.scm  (try searching your installed software location).
> 
> The eguile version is up one level from there.

You may also want files from .../report/report-system, in particular 
commodity-utilities.scm.

Regards,
John Ralls
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Balance Sheet Issue

[Stephen M. Butler]

On 09/04/2018 02:53 PM, Paul Schwartz wrote:
> If I want to reproduce the Balance Sheet Report I get from version 2.6.12
> in version 2.6.19, are there files that I can othe copy from one to the
> other?
>
> Paul
I forgot which OS you have.  On Ubuntu (local build) they are in
/usr/local/share/gnucash/scm/gnucash/report/standard-reports

I think it is one file (if you are talking about the non-eguile one): 
balance_sheet.scm  (try searching your installed software location).

The eguile version is up one level from there.


-- 
Stephen M Butler, PMP, PSM
stephen.m.butle...@gmail.com
kg...@arrl.net
253-350-0166
---
GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] GNC] Chart of Accounts sort order in v3.2 - Help

[Stan Brown]

I can confirm that the change did NOT happen between 2.x and 3.2.  I
have 2.6.19, and when I click on Amount Name, in the Accounts tab, I get
only the choice of alphabetical and reverse alphabetical. GTK3 has
seemed like a step backwards in user convenience, in several matters,
but this is not one of them. (I don't blame the GC developers for
keeping current with GTK; I blame the GTK developers.)

I understand, Alan, that you don't want to spend time entering account
codes. But it would not be just for the sorting of the Accounts view.
You can also use the account code, just like the name, when entering
transactions in the registers. (That's true in 2.6.19; I haven't tried
3.x because so many problems have been reported with that version and
Windows operating system. Hopefully they'll be fixed in 3.3.)

-- 
Regards,
Stan Brown
Tompkins County, New York, USA
http://BrownMath.com
http://OakRoadSystems.com

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Balance Sheet Issue

[Paul Schwartz]

If I want to reproduce the Balance Sheet Report I get from version 2.6.12
in version 2.6.19, are there files that I can othe copy from one to the
other?

Paul
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Finance Quotes Using Yahoo json

[Dan Nelms]

Thanks Michael for your comments about using Yahoo_json for some of your
security quotes. My needs are also very mild, but they number more than 4.

I am running GnuCash version 3.2, Finance::Quote 1.47 (Strawberry) on a
Windows 10 machine.

I tried using Yahoo_json with the GnuCash security editor and each time
I get the "could not get quotes for the following" message. I tried
2 mutual funds, 2 NYSE stocks and 1 NASDAQ stock. They all failed. I
tried closing and restarting Gnucash just to be the changes in the
security editor got loaded, still all failures. Yahoo_json is either not
working for me or I am doing something wrong. Damn, I was hoping for an
easy solution.

Alphavantage works fine but only for the first 4 securities.

Dan


On 9/3/2018 6:59 AM, Fross, Michael wrote:
> Hello Dan,
>
> My needs are fairly mild, but yes I currently use Yahoo_JSON for all
> of my quotes.  Most of my investments are in US mutual funds although
> I do have several individual stocks.  
>
> I simply use "*Single: Yahoo as JSON"* in the security editor.  I had
> switched to AlphaVantage when everyone else did and it worked most of
> the time, although it was very slow.  I think it's worse now so I'm
> happy Yahoo_JSON continues to work...at least for the time being.  I
> pull down 37 quotes, so not that many but if Alphavantage allows 5
> quotes / min, it would take me 7+ minutes do download those.
>
> Now I don't believe it will handle currencies and I'm not sure about
> non-US exchanges, but this does work for me.  You can always do the
> ones it supports via Yahoo_JSON and just the others via AlphaVantage
> depending on your situation.
>
> Michael
>
> On Sun, Sep 2, 2018 at 8:10 PM, Frank H. Ellenberger
> mailto:frank.h.ellenber...@gmail.com>>
> wrote:
>
> Hi Dan,
>
> Am 03.09.2018 um 00:10 schrieb Dan Nelms:
> > Micheal, I noticed in one of your replies to a user having
> Finance:Quote
> > problems that are still getting quotes from Yahoo_json for most
> of your
> > quotes. Are you doing that through the GnuCash Security setup? If so
> > what button do you use, ie Single, Multiple or Unknown? I would
> like to
> > try it. Thanks. Dan
>
> RTFM:
> 
> https://code.gnucash.org/docs/C/gnucash-help/fq-sources.html#idm139753655191424
> 
> 
> ;-)
>
> Frank
>
>

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Chart of Accounts sort order in v3.2 - Help

[Alan Maddocks]

Hi David,

Thank you once again for your help with this.

Using your link, I have downloaded GnuCash v2.6.6, sorted the Accounts in the 
original order and added in the  Account Code data.  The EDIT – Renumber sub 
accounts menu option does add sequential numbers to the sub accounts, but based 
on the alphabetic order instead of the original order, so I had to adjust 
these.  It really didn’t take very long and I am all set up now for version 3.2.

Thanks again.

Kind regards,

Alan.

From: David T. [mailto:sunfis...@yahoo.com]
Sent: 04 September 2018 14:43
To: Alan Maddocks 
Cc: Gnucash Users 
Subject: Re: [GNC] Chart of Accounts sort order in v3.2 - Help

Alan,


On Sep 4, 2018, at 9:05 AM, Alan Maddocks 
mailto:alan.maddo...@hotmail.co.uk>> wrote:

Hi David,

Thank you for your prompt reply to my query.

I can add account codes and sort on them.  However, that involves a certain 
amount of additional work which wasn’t necessary previously.

I just don't understand why I am now (with version 3.2) unable to retain the 
sort order in which the Accounts were originally entered (as I could previously 
using version 2.6.6).

I am no expert, and I am not a developer, but if I had to guess, I would guess 
that the change from GTK2 to GTK3 forced this change. While the impact in this 
specific case may have been unintentional, the overall change was necessary to 
keep GnuCash in sync with the underlying GTK platform that GnuCash uses. 
Personally, it only took me at most an hour or two to encode my file, with 
perhaps about 100 accounts in it.



Is this a bug or has the functionality been changed deliberately?  Also, is it 
possible to download a version of GnuCash where the accounts can be listed in 
the original order.
e.g. version 2.6.6

https://sourceforge.net/projects/gnucash/files/gnucash%20%28stable%29/2.6.6/

I believe that there is a feature that will auto number your accounts for you; 
you might downgrade to 2.6.6, get the sort you want, run that feature to get 
your accounts numbered in your preferred order, and then upgrade. Your accounts 
can then be sorted by ACCTNum.

HTH,
David



Thank you for your help,

Alan.

-Original Message-
From: D [mailto:sunfis...@yahoo.com]
Sent: 04 September 2018 00:27
To: Alan Maddocks 
mailto:alan.maddo...@hotmail.co.uk>>; Gnucash 
Users mailto:gnucash-user@gnucash.org>>
Subject: Re: [GNC] Chart of Accounts sort order in v3.2

I'd suggest using account codes to set your account order, and then add that 
column to your COA and support on it.

HTH,
David

On September 3, 2018, at 6:25 PM, Alan Maddocks 
mailto:alan.maddo...@hotmail.co.uk>> wrote:

Hi,

I have been using GnuCash version 2.6.6, and in the Chart of Accounts view, 
when clicking in the 'Account Name' column heading it was possible to choose 
one of three sort orders for the Accounts:


1.   Alphabetic ascending

2.   Alphabetic descending

3.   The order in which the Accounts were originally entered

I have always used no 3. The order in which the Accounts were originally entered


I have recently purchased a new laptop and have downloaded GnuCash version 3.2. 
 It seems that there are now only two sort order options, Alphabetic ascending 
and descending.

Please would you let me know if it's possible to sort and display the Accounts 
in the order in which they were originally entered.  Alternatively, is it 
possible to download a version of GnuCash where this is possible?

I am sorry to have to contact you about this but I have searched for a solution 
but have not been successful,

Many thanks,

Alan Maddocks

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-userdata=02%7C01%7C%7Ced4f579cf24b48467b4108d611f55858%7C84df9e7fe9f640afb435%7C1%7C0%7C636716142775287009sdata=xdM5R4EvPHuAwu7t0cqZ83fFFDEBSI%2B%2FmqJR%2FpDI8eU%3Dreserved=0
If you are using Nabble or Gmane, please see 
https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwiki.gnucash.org%2Fwiki%2FMailing_Listsdata=02%7C01%7C%7Ced4f579cf24b48467b4108d611f55858%7C84df9e7fe9f640afb435%7C1%7C0%7C636716142775287009sdata=38ueaDFulE4y7c02jmziU4jpsvSrCux13l2sJq4fnWA%3Dreserved=0
 for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences 

[GNC] UK Shares and Yahoo as JSON

[Eric Coates]

Hi

Context: I’m running GnuCash 2.16.7 on Ubuntu 1604 with Finance-Quote 1.47.

Like many others I have been using AlphaVantage as the source for my 
online share price retrievals and been experiencing difficulties. 
Following up on hints in the mailing list I have tried using 
Single/Yahoo as JSON as an alternative source.


Having set the source as Single/Yahoo as JSON for all my shares and 
clicking Get Quotes I got very rich! Unfortunately, a quick 
investigation revealed that, although my European shares had received 
(what looked like) good quotes, the prices received for my UK shares 
come back 100 times too big.


As I have relatively few shares and usually only update the prices at 
the end of the month it is not totally ridiculous to input UK share 
prices by hand. But it would be so much nicer to be able to do it 
automatically.


Assuming that others are having the same problem with UK shares and 
Yahoo as JSON (are they?), is there a known (and hopefully simple) way 
to correct the Yahoo prices?


I wonder if there is a possible alternative: It has been hinted here 
that GnuCash 3 has a much improved CSV importer and (if I understand 
properly) it is possible to input share prices using it. It would be 
possible to get the list of shares and their prices from my broker 
account. Is the GnuCash 3 importer documented (I can't find anything) so 
as to make the import easy? (But that means upgrading and, again, my 
ignorance means I need simple instructions.)


As always, my thanks to the developers and the documentation team and 
other users of this list for their time and efforts


Best wishes

Eric

PS: Please forgive this aside:

On the Securities Editor page, for me, it is not possible to un-tick the 
box in the Get Quote column. Should it be?


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Compiling 2.6.12

[Paul Schwartz]

Thanks! You made me a fisherman. ./configure has now completed. The cmake
instructions talked about optional switches like python. I didn't see
anything like that mentioned in the output from configure. have I missed
something?

On Mon, Sep 3, 2018 at 11:57 PM Geert Janssens 
wrote:

> Op maandag 3 september 2018 22:41:50 CEST schreef Paul Schwartz:
> > Thanks for the suggestion. I have been working through ./configure adding
> > new packages as it complains [including -dev ones]. I have now hit this
> >
> > checking for webkit-1.0 >= "1.2"... no
> > Package webkit-1.0 was not found in the pkg-config search path. Perhaps
> you
> > should add the directory containing `webkit-1.0.pc' to the
> PKG_CONFIG_PATH
> > environment variable No package 'webkit-1.0' found
> > configure: error: Library requirements (webkit-1.0 >= "1.2") not met;
> > consider adjusting the PKG_CONFIG_PATH environment variable if your
> > libraries are in a nonstandard prefix so pkg-config can find them.
> >
> > There is a libwebkitgtk-1.0 installed in my system. My package manager
> > doesn't show webkit-1.0 and a web search didn't show anything promising.
> > Looking for more help.
> >
> As with the previous ones the problem is that while libwebkitgtk-1.0 is
> installed the corresponding -dev package is not. For building you also
> need
> the -dev package. Unfortunately Ubuntu (and probably debian as well) uses
> a
> naming scheme for the -dev package that's not simply
> -dev.
>
> As Ubuntu is not my primary system I don't know the proper commands on
> that OS
> to figure it out directly.
>
> So what I do instead is go to https://packages.ubuntu.com/ and use that
> site
> to find which package provides the missing *.pc file the build system
> complains about ("webkit-1.0.pc), and then install the missing package.
> This
> has worked for my answer to you previous questions. I'll make it an
> exercise
> for the reader to try it for the currently missing package :)
>
> Regards,
>
> Geert
>
>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] compiling 3.2 stops at core-utils.go ( non-urgent -- can use debian package 2.6.15-1

[John Griessen]

On 09/02/2018 10:40 AM, Colin Law wrote:

Don't try and install to the source or build directory, if that is
what you are trying to do.


No, they were not the same dir.  This is not urgent now, but a mystery.
I have started using 2.6.15-1 gnucash successfully, so not urgent.

Today I also tried from scratch from git and same result almost:

cd /moresource
git clone https://github.com/Gnucash/gnucash.git gnucash
git checkout -b gnucash3.2 3.2
cmake -D CMAKE_INSTALL_PREFIX=$HOME/.local /moresource/gnucash
make


.
.
.
[ 28%] Building C object 
libgnucash/app-utils/CMakeFiles/gncmod-app-utils.dir/guile-util.c.o
[ 28%] Building C object 
libgnucash/app-utils/CMakeFiles/gncmod-app-utils.dir/option-util.c.o
[ 28%] Building C object 
libgnucash/app-utils/CMakeFiles/gncmod-app-utils.dir/swig-app-utils-guile.c.o
[ 28%] Linking C shared library ../../lib/gnucash/libgncmod-app-utils.so
[ 28%] Built target gncmod-app-utils
Scanning dependencies of target swig-app-utils-python
[ 28%] Generating swig-app-utils-python.c, sw_app_utils.py
[ 28%] Built target swig-app-utils-python
Scanning dependencies of target scm-gnc-module
[ 28%] Generating ../../lib/gnucash/scm/ccache/2.2/gnucash/gnc-module.go
wrote `/mosource/gnucash/build/lib/gnucash/scm/ccache/2.2/gnucash/gnc-module.go'
[ 28%] Built target scm-gnc-module
Scanning dependencies of target scm-core-utils
[ 28%] Generating ../../lib/gnucash/scm/ccache/2.2/gnucash/core-utils.go
Backtrace:
In /usr/bin/guild:
72:17 19 (main _)
In srfi/srfi-1.scm:
640:9 18 (for-each # …)
In scripts/compile.scm:
   259:26 17 (_ _)
In system/base/target.scm:
 57:6 16 (with-target _ _)
In system/base/compile.scm:
152:6 15 (compile-file _ #:output-file _ #:from _ #:to _ #:env _ …)
 43:4 14 (call-once _)
In ice-9/boot-9.scm:
841:4 13 (with-throw-handler _ _ _)
In system/base/compile.scm:
59:11 12 (_)
   155:11 11 (_ #)
   235:18 10 (read-and-compile # #:from _ # …)
   183:32  9 (compile-fold (#) …)
In ice-9/boot-9.scm:
   2312:4  8 (save-module-excursion #)
In language/scheme/compile-tree-il.scm:
31:15  7 (_)
In ice-9/psyntax.scm:
  1235:36  6 (expand-top-sequence ((re-export #)) _ _ #f c (# load …) …)
  1182:24  5 (parse _ (("placeholder" placeholder)) ((top) #(# # …)) …)
   285:10  4 (parse _ (("placeholder" placeholder)) (()) _ c (# #) #)
In ice-9/boot-9.scm:
  2071:24  3 (call-with-deferred-observers #)
   260:13  2 (for-each # …)
In unknown file:
   1 (scm-error misc-error #f "~A ~S" ("Undefined variab…" …) …)
In ice-9/boot-9.scm:
   752:25  0 (dispatch-exception _ _ _)

ice-9/boot-9.scm:752:25: In procedure dispatch-exception:
Undefined variable: gnc-build-userdata-path
make[2]: *** [libgnucash/core-utils/CMakeFiles/scm-core-utils.dir/build.make:62: lib/gnucash/scm/ccache/2.2/gnucash/core-utils.go] 
Error 1

make[1]: *** [CMakeFiles/Makefile2:4053: 
libgnucash/core-utils/CMakeFiles/scm-core-utils.dir/all] Error 2
make: *** [Makefile:163: all] Error 2

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Gnucash Flatpak 3.2 Mysql issue

[Colin Law]

I also notice that the docs are not included. Help shows the not found error.

Colin
On Tue, 4 Sep 2018 at 09:36, Geert Janssens  wrote:
>
> Op dinsdag 4 september 2018 10:19:09 CEST schreef Colin Law:
> > On Tue, 4 Sep 2018 at 08:47, Geert Janssens 
> wrote:
> > > Op dinsdag 4 september 2018 09:41:46 CEST schreef Colin Law:
> > > > On Tue, 4 Sep 2018 at 08:35, Geert Janssens 
> > >
> > > wrote:
> > > > > ...
> > > > > Ok, and how about
> > > > > --filesystem=/var/lib/mysql
> > > >
> > > > No joy there either I am afraid.
> > > >
> > > > Colin
> > >
> > > Hmm, that was on the assumption the mysql unix socket would live there.
> > > Can
> > > you verify this on your system ?
> > >
> > > And if it doesn't work, what errors do you see in your trace file ? (You
> > > may have to re-add your --filesystem=/tmp parameter to get a trace file)
> > I am not particularly knowledgeable on unix sockets but I think it is
> > /var/run/mysqld/mysqld.sock (which does exist) so tried
> > /var/run/mysqld but to no avail.
> >
> > In the trace file I see
> > CRIT  [GncDbiBackend::session_begin()] Unable
> > to connect to database 'gnucash'
> > as before.
> >
> > Colin
>
> Ok, thanks. Unfortunately that's a very vague error message :(
> This will need more experimentation then. But we have a viable workaround for
> now so getting localhost with Unix socket working is less urgent.
>
> Geert
>
>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Negative assets!

[John Ralls]

> On Sep 4, 2018, at 3:12 AM, Muhammad Bashir Al-Noimi  
> wrote:
> 
>   Hi,
>   After deleting some sub accounts under "Assets" I get negative value in
>   "Current Assets". I manually look for any transaction(s) related to
>   "Current Assets" but I failed to find any transaction related to it.
>   How can I fix negative assets?
>   NOTES:
> * I use multi-currencies.
> * I'm unable to see any negative values under "Current Assets" sub
>   accounts.
> * All "Current Assets" sub accounts defined as "Asset" account type.
> 

When you deleted the accounts, what did you tell GnuCash to do with the 
transactions?

Do you have any Imbalance-XXX accounts?

Regards,
John Ralls


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Gnucash Flatpak 3.2 Mysql issue

[John Ralls]

> On Sep 4, 2018, at 12:38 AM, Colin Law  wrote:
> 
> On Tue, 4 Sep 2018 at 08:29, Geert Janssens  > wrote:
>> 
>> Op dinsdag 4 september 2018 09:19:40 CEST schreef Colin Law:
>>> Excellent, thanks for working that out.  Specifying 127.0.0.1 works
>>> for me too.  I have updated the issue [1].
>>> That means that for me the flatpak is a working solution.  However,
>>> given the fact there has been absolutely no feedback from the
>>> maintainer on any of this I am not particularly hopeful that the
>>> flatpak will be kept up to date, any more than the snap package has
>>> been.
>>> 
>> I am considering taking over maintenance of the flatpak manifest. That's also
>> how flathub envisions it should be. And it would allow us to make nightly
>> flatpaks in addition to release versions.
>> 
>> Colin, do you use online quote sources for prices ? I believe the
>> Finance::Quote module is also missing from flatpak.
> 
> That would be great.  For Ubuntu the snap package would be preferable
> but one can't have everything.
> No I don't use Finance::Quote.  On startup I see
> WARN  Could not spawn perl: Failed to execute child
> process “perl” (No such file or directory)
> I thought that perl was only used for F::Q but I don't know much about
> it.  Is there anything you would like me to try?

We do use perl only for F::Q, and that check is the first part of seeing if 
F::Q is available. We should probably reduce it to a PINFO, it confuses a lot 
of users.

Regards,
John Ralls

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Chart of Accounts sort order in v3.2 - Help

[David T. via gnucash-user]

Alan,

> On Sep 4, 2018, at 9:05 AM, Alan Maddocks  wrote:
> 
> Hi David,
> 
> Thank you for your prompt reply to my query.  
> 
> I can add account codes and sort on them.  However, that involves a certain 
> amount of additional work which wasn’t necessary previously.
> 
> I just don't understand why I am now (with version 3.2) unable to retain the 
> sort order in which the Accounts were originally entered (as I could 
> previously using version 2.6.6).

I am no expert, and I am not a developer, but if I had to guess, I would guess 
that the change from GTK2 to GTK3 forced this change. While the impact in this 
specific case may have been unintentional, the overall change was necessary to 
keep GnuCash in sync with the underlying GTK platform that GnuCash uses. 
Personally, it only took me at most an hour or two to encode my file, with 
perhaps about 100 accounts in it. 

> 
> Is this a bug or has the functionality been changed deliberately?  Also, is 
> it possible to download a version of GnuCash where the accounts can be listed 
> in the original order.
> e.g. version 2.6.6

https://sourceforge.net/projects/gnucash/files/gnucash%20%28stable%29/2.6.6/ 


I believe that there is a feature that will auto number your accounts for you; 
you might downgrade to 2.6.6, get the sort you want, run that feature to get 
your accounts numbered in your preferred order, and then upgrade. Your accounts 
can then be sorted by ACCTNum.

HTH,
David

> 
> Thank you for your help,
> 
> Alan.
> 
> -Original Message-
> From: D [mailto:sunfis...@yahoo.com] 
> Sent: 04 September 2018 00:27
> To: Alan Maddocks ; Gnucash Users 
> 
> Subject: Re: [GNC] Chart of Accounts sort order in v3.2
> 
> I'd suggest using account codes to set your account order, and then add that 
> column to your COA and support on it.
> 
> HTH,
> David
> 
> On September 3, 2018, at 6:25 PM, Alan Maddocks  
> wrote:
> 
> Hi,
> 
> I have been using GnuCash version 2.6.6, and in the Chart of Accounts view, 
> when clicking in the 'Account Name' column heading it was possible to choose 
> one of three sort orders for the Accounts:
> 
> 
> 1.   Alphabetic ascending
> 
> 2.   Alphabetic descending
> 
> 3.   The order in which the Accounts were originally entered
> 
> I have always used no 3. The order in which the Accounts were originally 
> entered
> 
> 
> I have recently purchased a new laptop and have downloaded GnuCash version 
> 3.2.  It seems that there are now only two sort order options, Alphabetic 
> ascending and descending.
> 
> Please would you let me know if it's possible to sort and display the 
> Accounts in the order in which they were originally entered.  Alternatively, 
> is it possible to download a version of GnuCash where this is possible?
> 
> I am sorry to have to contact you about this but I have searched for a 
> solution but have not been successful,
> 
> Many thanks,
> 
> Alan Maddocks
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-userdata=02%7C01%7C%7Ced4f579cf24b48467b4108d611f55858%7C84df9e7fe9f640afb435%7C1%7C0%7C636716142775287009sdata=xdM5R4EvPHuAwu7t0cqZ83fFFDEBSI%2B%2FmqJR%2FpDI8eU%3Dreserved=0
> If you are using Nabble or Gmane, please see 
> https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwiki.gnucash.org%2Fwiki%2FMailing_Listsdata=02%7C01%7C%7Ced4f579cf24b48467b4108d611f55858%7C84df9e7fe9f640afb435%7C1%7C0%7C636716142775287009sdata=38ueaDFulE4y7c02jmziU4jpsvSrCux13l2sJq4fnWA%3Dreserved=0
>  for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] GC 3.2 Import Price File CSV

[Geert Janssens]

Op dinsdag 4 september 2018 14:20:24 CEST schreef David T.:
> Geert,
> 
> Thanks for looking into this and coming up with a fix.
> 
> Just out of curiosity, what is the fix that you’ve put in?

Before trying to parse a csv file, make sure all possible line endings to "LF" 
(internally).

So regardless of what line endings the file has, our parser will only see 
"LF", the "unix" format or what C++ libraries expect by default.


Geert

> 
> Cheers,
> David
> 
> > On Sep 4, 2018, at 5:34 AM, Geert Janssens 
> > wrote:> 
> > Op dinsdag 4 september 2018 10:36:11 CEST schreef Andy Brown via gnucash-
user:
> >> Tried TextEdit.  It does have a UTF-8 option but it won't correct the EOL
> >> character, (as far as I can make out from a one file test).  I will try
> >> and
> >> find a hex editor and investigate the exact source of the problem when I
> >> have time.
> >> 
> >> Andy
> > 
> > Thanks for the feedback. The exact source of the problem is in the
> > difference in line-endings. GnuCash currently expects "LF" (the C++
> > default), but some files can have "CRLF" (Windows) or "CR" (Macos) as
> > line ending.
> > 
> > I have made changes to the code to fix this for gnucash 3.3.
> > 
> > Geert
> > 
> > 
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see
> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.




___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Chart of Accounts sort order in v3.2 - Help

[Alan Maddocks]

Hi David,

Thank you for your prompt reply to my query.  

I can add account codes and sort on them.  However, that involves a certain 
amount of additional work which wasn’t necessary previously.

I just don't understand why I am now (with version 3.2) unable to retain the 
sort order in which the Accounts were originally entered (as I could previously 
using version 2.6.6).

Is this a bug or has the functionality been changed deliberately?  Also, is it 
possible to download a version of GnuCash where the accounts can be listed in 
the original order.
e.g. version 2.6.6

Thank you for your help,

Alan.

-Original Message-
From: D [mailto:sunfis...@yahoo.com] 
Sent: 04 September 2018 00:27
To: Alan Maddocks ; Gnucash Users 

Subject: Re: [GNC] Chart of Accounts sort order in v3.2

I'd suggest using account codes to set your account order, and then add that 
column to your COA and support on it.

HTH,
David

On September 3, 2018, at 6:25 PM, Alan Maddocks  
wrote:

Hi,

I have been using GnuCash version 2.6.6, and in the Chart of Accounts view, 
when clicking in the 'Account Name' column heading it was possible to choose 
one of three sort orders for the Accounts:


1.   Alphabetic ascending

2.   Alphabetic descending

3.   The order in which the Accounts were originally entered

I have always used no 3. The order in which the Accounts were originally entered


I have recently purchased a new laptop and have downloaded GnuCash version 3.2. 
 It seems that there are now only two sort order options, Alphabetic ascending 
and descending.

Please would you let me know if it's possible to sort and display the Accounts 
in the order in which they were originally entered.  Alternatively, is it 
possible to download a version of GnuCash where this is possible?

I am sorry to have to contact you about this but I have searched for a solution 
but have not been successful,

Many thanks,

Alan Maddocks

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-userdata=02%7C01%7C%7Ced4f579cf24b48467b4108d611f55858%7C84df9e7fe9f640afb435%7C1%7C0%7C636716142775287009sdata=xdM5R4EvPHuAwu7t0cqZ83fFFDEBSI%2B%2FmqJR%2FpDI8eU%3Dreserved=0
If you are using Nabble or Gmane, please see 
https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwiki.gnucash.org%2Fwiki%2FMailing_Listsdata=02%7C01%7C%7Ced4f579cf24b48467b4108d611f55858%7C84df9e7fe9f640afb435%7C1%7C0%7C636716142775287009sdata=38ueaDFulE4y7c02jmziU4jpsvSrCux13l2sJq4fnWA%3Dreserved=0
 for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] GC 3.2 Import Price File CSV

[David T. via gnucash-user]

Geert,

Thanks for looking into this and coming up with a fix. 

Just out of curiosity, what is the fix that you’ve put in?

Cheers,
David

> On Sep 4, 2018, at 5:34 AM, Geert Janssens  wrote:
> 
> Op dinsdag 4 september 2018 10:36:11 CEST schreef Andy Brown via gnucash-user:
>> Tried TextEdit.  It does have a UTF-8 option but it won't correct the EOL
>> character, (as far as I can make out from a one file test).  I will try and
>> find a hex editor and investigate the exact source of the problem when I
>> have time.
>> 
>> Andy
> 
> Thanks for the feedback. The exact source of the problem is in the difference 
> in line-endings. GnuCash currently expects "LF" (the C++ default), but some 
> files can have "CRLF" (Windows) or "CR" (Macos) as line ending.
> 
> I have made changes to the code to fix this for gnucash 3.3.
> 
> Geert
> 
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] GC 3.2: Trial Balance Report

[Alex via gnucash-user]

The file html-utilities.scm worked a treat, thanks.

I've also cloned the gnucash git repository and compiled. The scroll 
bars seem to be behaving a lot better than in 3.2. I'll give it a proper 
test early next week.


Alex


On 03/09/18 20:31, John Ralls wrote:

If you're using Microsoft Windows, no building required, just download the 
latest installer from https://code.gnucash.org/builds/win32/maint.

Otherwise you'd ordinarily have to build from git, but in this case you can 
simply retrieve 
https://raw.githubusercontent.com/Gnucash/gnucash/maint/gnucash/report/report-system/html-utilities.scm,
 find it in your installation (it's in share/gnucash/scm) and replace it with 
the newly downloaded one.

Regards,
John Ralls



On Sep 3, 2018, at 11:03 AM, Alex via gnucash-user  
wrote:

If i go down the nightly build route. Where are they?


On 03/09/18 18:47, Alex via gnucash-user wrote:

Thanks Chris.

Looks very similar to the problem I'm seeing.

I assume what John  mentioned about the trace file is what I've quoted 
immediately below?


In unknown file:
?: 19 [apply-smob/1 #]
In c-interface.scm:
   22: 18 [gnc:call-with-error-handling "(gnc:report-run 0)" ()]
In ice-9/boot-9.scm:
  157: 17 [catch #t # ..]
In c-interface.scm:
   29: 16 [#]
In unknown file:
?: 15 [eval-string "(gnc:report-run 0)" #]
?: 14 [call-with-input-string "(gnc:report-run 0)" ...]
In ice-9/boot-9.scm:
2401: 13 [save-module-excursion #]
In ice-9/eval-string.scm:
   44: 12 [read-and-eval # #:lang ...]
   37: 11 [lp (gnc:report-run 0)]
In report.scm:
  833: 10 [gnc:report-run 0]
In c-interface.scm:
   70: 9 [gnc:backtrace-if-exception #]
   22: 8 [gnc:call-with-error-handling # ...]
In ice-9/boot-9.scm:
  157: 7 [catch #t # ..]
In c-interface.scm:
   27: 6 [#]
In report.scm:
  837: 5 [#]
  808: 4 [gnc:report-render-html # #t]
In trial-balance.scm:
  828: 3 [trial-balance-renderer # #f #f]
  451: 2 [add-line # # ...]
In html-acct-table.scm:
1114: 1 [gnc:html-table-add-labeled-amount-line! # 3 "primary-subheading" ...]
In unknown file:
?: 0 [make-list -1/2 #f]

ERROR: Wrong type (expecting exact integer): -1/2

So either -

1. wait for 3.3
2. or build from nightlies as a one off, only need the report once a year

Alex



On 03/09/18 18:29, Christopher Lam wrote:

I'm afraid it's still https://bugs.gnucash.org/show_bug.cgi?id=796696 and has 
already been fixed in the nightlies.


On 04/09/18 00:55, John Ralls wrote:

On Sep 3, 2018, at 9:35 AM, Alex via gnucash-user  
wrote:

I'm getting an error whilst running the Trial Balance report

Reports -> Income & Expense -> Trial Balance

The error message is


   Report error

An error occurred while running the report.


has anyone else encountered this?

Look in the trace file [1] for the actual error. I fixed a couple of 
divide-by-zero problems in the asset value code last week, so it might be from 
one of those.

Regards,
John Ralls

[1] https://wiki.gnucash.org/wiki/Tracefile 


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.




___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you 

[GNC] Negative assets!

[Muhammad Bashir Al-Noimi]

   Hi,
   After deleting some sub accounts under "Assets" I get negative value in
   "Current Assets". I manually look for any transaction(s) related to
   "Current Assets" but I failed to find any transaction related to it.
   How can I fix negative assets?
   NOTES:
 * I use multi-currencies.
 * I'm unable to see any negative values under "Current Assets" sub
   accounts.
 * All "Current Assets" sub accounts defined as "Asset" account type.

--
Best Regards,
Muhammad Bashir Al-Noimi
Skype+Telegram+GMail: mbnoimi
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] GC 3.2 Import Price File CSV

[Geert Janssens]

Op dinsdag 4 september 2018 10:36:11 CEST schreef Andy Brown via gnucash-user:
> Tried TextEdit.  It does have a UTF-8 option but it won't correct the EOL
> character, (as far as I can make out from a one file test).  I will try and
> find a hex editor and investigate the exact source of the problem when I
> have time.
> 
> Andy

Thanks for the feedback. The exact source of the problem is in the difference 
in line-endings. GnuCash currently expects "LF" (the C++ default), but some 
files can have "CRLF" (Windows) or "CR" (Macos) as line ending.

I have made changes to the code to fix this for gnucash 3.3.

Geert


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Gnucash Flatpak 3.2 Mysql issue

[Geert Janssens]

Op dinsdag 4 september 2018 10:19:09 CEST schreef Colin Law:
> On Tue, 4 Sep 2018 at 08:47, Geert Janssens  
wrote:
> > Op dinsdag 4 september 2018 09:41:46 CEST schreef Colin Law:
> > > On Tue, 4 Sep 2018 at 08:35, Geert Janssens 
> > 
> > wrote:
> > > > ...
> > > > Ok, and how about
> > > > --filesystem=/var/lib/mysql
> > > 
> > > No joy there either I am afraid.
> > > 
> > > Colin
> > 
> > Hmm, that was on the assumption the mysql unix socket would live there.
> > Can
> > you verify this on your system ?
> > 
> > And if it doesn't work, what errors do you see in your trace file ? (You
> > may have to re-add your --filesystem=/tmp parameter to get a trace file)
> I am not particularly knowledgeable on unix sockets but I think it is
> /var/run/mysqld/mysqld.sock (which does exist) so tried
> /var/run/mysqld but to no avail.
> 
> In the trace file I see
> CRIT  [GncDbiBackend::session_begin()] Unable
> to connect to database 'gnucash'
> as before.
> 
> Colin

Ok, thanks. Unfortunately that's a very vague error message :(
This will need more experimentation then. But we have a viable workaround for 
now so getting localhost with Unix socket working is less urgent.

Geert



___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] GC 3.2 Import Price File CSV

[Andy Brown via gnucash-user]

Tried TextEdit.  It does have a UTF-8 option but it won't correct the EOL
character, (as far as I can make out from a one file test).  I will try and
find a hex editor and investigate the exact source of the problem when I
have time.

Andy



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Gnucash Flatpak 3.2 Mysql issue

[Colin Law]

On Tue, 4 Sep 2018 at 08:47, Geert Janssens  wrote:
>
> Op dinsdag 4 september 2018 09:41:46 CEST schreef Colin Law:
> > On Tue, 4 Sep 2018 at 08:35, Geert Janssens 
> wrote:
> > > ...
> > > Ok, and how about
> > > --filesystem=/var/lib/mysql
> >
> > No joy there either I am afraid.
> >
> > Colin
>
> Hmm, that was on the assumption the mysql unix socket would live there. Can
> you verify this on your system ?
>
> And if it doesn't work, what errors do you see in your trace file ? (You may
> have to re-add your --filesystem=/tmp parameter to get a trace file)

I am not particularly knowledgeable on unix sockets but I think it is
/var/run/mysqld/mysqld.sock (which does exist) so tried
/var/run/mysqld but to no avail.

In the trace file I see
CRIT  [GncDbiBackend::session_begin()] Unable
to connect to database 'gnucash'
as before.

Colin
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Gnucash Flatpak 3.2 Mysql issue

[Geert Janssens]

Op dinsdag 4 september 2018 09:41:46 CEST schreef Colin Law:
> On Tue, 4 Sep 2018 at 08:35, Geert Janssens  
wrote:
> > ...
> > Ok, and how about
> > --filesystem=/var/lib/mysql
> 
> No joy there either I am afraid.
> 
> Colin

Hmm, that was on the assumption the mysql unix socket would live there. Can 
you verify this on your system ?

And if it doesn't work, what errors do you see in your trace file ? (You may 
have to re-add your --filesystem=/tmp parameter to get a trace file)

Geert


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Gnucash Flatpak 3.2 Mysql issue

[Colin Law]

On Tue, 4 Sep 2018 at 08:35, Geert Janssens  wrote:
> ...
> Ok, and how about
> --filesystem=/var/lib/mysql

No joy there either I am afraid.

Colin
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Gnucash Flatpak 3.2 Mysql issue

[Colin Law]

On Tue, 4 Sep 2018 at 08:29, Geert Janssens  wrote:
>
> Op dinsdag 4 september 2018 09:19:40 CEST schreef Colin Law:
> > Excellent, thanks for working that out.  Specifying 127.0.0.1 works
> > for me too.  I have updated the issue [1].
> > That means that for me the flatpak is a working solution.  However,
> > given the fact there has been absolutely no feedback from the
> > maintainer on any of this I am not particularly hopeful that the
> > flatpak will be kept up to date, any more than the snap package has
> > been.
> >
> I am considering taking over maintenance of the flatpak manifest. That's also
> how flathub envisions it should be. And it would allow us to make nightly
> flatpaks in addition to release versions.
>
> Colin, do you use online quote sources for prices ? I believe the
> Finance::Quote module is also missing from flatpak.

That would be great.  For Ubuntu the snap package would be preferable
but one can't have everything.
No I don't use Finance::Quote.  On startup I see
WARN  Could not spawn perl: Failed to execute child
process “perl” (No such file or directory)
I thought that perl was only used for F::Q but I don't know much about
it.  Is there anything you would like me to try?

Colin
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Gnucash Flatpak 3.2 Mysql issue

[Geert Janssens]

Op dinsdag 4 september 2018 09:31:19 CEST schreef Colin Law:
> On Tue, 4 Sep 2018 at 08:15, Geert Janssens  
wrote:
> > Op dinsdag 4 september 2018 08:35:08 CEST schreef Adrien Monteleone:
> > > While --share=network should give you access to unix-sockets, I don’t
> > > think
> > > that includes access to ‘/etc/hosts’ which lies outside of the sandbox
> > > therefore, I’d suspect the reference to ‘localhost’ is not resolving, so
> > > only the actual IP address will work.
> > > 
> > > Regards,
> > > Adrien
> > 
> > An interesting observation. This can be tested by adding
> > --filesystem=/etc/
> > hosts:ro to the flatpak invocation.
> 
> I have tried
> sudo flatpak override org.gnucash.GnuCash --filesystem=/etc/hosts:ro
> but that does not fix it.
> 
> Colin

Ok, and how about
--filesystem=/var/lib/mysql

Geert



___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Gnucash Flatpak 3.2 Mysql issue

[Colin Law]

On Tue, 4 Sep 2018 at 08:15, Geert Janssens  wrote:
>
> Op dinsdag 4 september 2018 08:35:08 CEST schreef Adrien Monteleone:
> > While --share=network should give you access to unix-sockets, I don’t think
> > that includes access to ‘/etc/hosts’ which lies outside of the sandbox
> > therefore, I’d suspect the reference to ‘localhost’ is not resolving, so
> > only the actual IP address will work.
> >
> > Regards,
> > Adrien
> >
> An interesting observation. This can be tested by adding --filesystem=/etc/
> hosts:ro to the flatpak invocation.

I have tried
sudo flatpak override org.gnucash.GnuCash --filesystem=/etc/hosts:ro
but that does not fix it.

Colin
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Gnucash Flatpak 3.2 Mysql issue

[Geert Janssens]

Op dinsdag 4 september 2018 09:19:40 CEST schreef Colin Law:
> Excellent, thanks for working that out.  Specifying 127.0.0.1 works
> for me too.  I have updated the issue [1].
> That means that for me the flatpak is a working solution.  However,
> given the fact there has been absolutely no feedback from the
> maintainer on any of this I am not particularly hopeful that the
> flatpak will be kept up to date, any more than the snap package has
> been.
> 
I am considering taking over maintenance of the flatpak manifest. That's also 
how flathub envisions it should be. And it would allow us to make nightly 
flatpaks in addition to release versions.

Colin, do you use online quote sources for prices ? I believe the 
Finance::Quote module is also missing from flatpak.

Geert


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Gnucash Flatpak 3.2 Mysql issue

[Colin Law]

Excellent, thanks for working that out.  Specifying 127.0.0.1 works
for me too.  I have updated the issue [1].
That means that for me the flatpak is a working solution.  However,
given the fact there has been absolutely no feedback from the
maintainer on any of this I am not particularly hopeful that the
flatpak will be kept up to date, any more than the snap package has
been.

Colin

[1] https://github.com/flathub/org.gnucash.GnuCash/issues/17
On Tue, 4 Sep 2018 at 05:03, Plutocrat  wrote:
>
> Well I was bored at work (which isn't to say I didn't have any to do ...), so 
> I thought I'd fiddle around with the gnucash flatpak I had installed on my 
> laptop to see if I could figure out what was going on.
>
> I personally use the XML file, so I installed mysql-server, struggled to 
> reset the root password and then created a gnucash user and database. Tried 
> to save to host=localhost, db=gnucash, user=gnucash, password=xx and 
> experienced the same problem as previously detailed on this list.
>
> Cue an hour of digging through documentation on flatpak,
> http://docs.flatpak.org/en/latest/sandbox-permissions-reference.html
>
> This looked promising, but didn't work, throwing an error.
> flatpak permission-show org.gnucash.GnuCash
>
> This flag looked like it might work, but made no difference.
> --share=network  (Giving network access also grants access to all host 
> services listening on abstract Unix sockets (due to how network namespaces 
> work)
>
> Eventually I found the manifest.json file in /usr/lib/flatpak/blah/blah and 
> determined that it did actually have network access anyway. And /home/user/ 
> directory access, for the record.
>
> I was poring through mysql logs, and I saw 'Listening on 127.0.0.1', so I 
> thought I'd give that a try on the off-chance ... and it worked! Database 
> saved OK, and I could work off that one.
>
> So, apparently changing hostname from localhost to 127.0.0.1 was the magic 
> charm. Anyone else want to give it a try and report back?
>
> P.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Gnucash Flatpak 3.2 Mysql issue

[Geert Janssens]

Op dinsdag 4 september 2018 08:35:08 CEST schreef Adrien Monteleone:
> While --share=network should give you access to unix-sockets, I don’t think
> that includes access to ‘/etc/hosts’ which lies outside of the sandbox
> therefore, I’d suspect the reference to ‘localhost’ is not resolving, so
> only the actual IP address will work.
> 
> Regards,
> Adrien
> 
An interesting observation. This can be tested by adding --filesystem=/etc/
hosts:ro to the flatpak invocation.

My guess was the unix socket would not be available to the flatpak. Reading 
the footnote on the flatpak Sandbox Permissions page http://docs.flatpak.org/
en/latest/sandbox-permissions-reference.html#f2 on the other hand suggests 
what you also indicate: --share=network should give access to unix-sockets 
(I'm not sure why flatpak makes that "abstract" Unix sockets though).

Geert


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Gnucash Flatpak 3.2 Mysql issue

[Adrien Monteleone]

While --share=network should give you access to unix-sockets, I don’t think 
that includes access to ‘/etc/hosts’ which lies outside of the sandbox 
therefore, I’d suspect the reference to ‘localhost’ is not resolving, so only 
the actual IP address will work.

Regards,
Adrien

> On Sep 3, 2018, at 11:00 PM, Plutocrat  wrote:
> 
> Well I was bored at work (which isn't to say I didn't have any to do ...), so 
> I thought I'd fiddle around with the gnucash flatpak I had installed on my 
> laptop to see if I could figure out what was going on. 
> 
> I personally use the XML file, so I installed mysql-server, struggled to 
> reset the root password and then created a gnucash user and database. Tried 
> to save to host=localhost, db=gnucash, user=gnucash, password=xx and 
> experienced the same problem as previously detailed on this list. 
> 
> Cue an hour of digging through documentation on flatpak, 
> http://docs.flatpak.org/en/latest/sandbox-permissions-reference.html
> 
> This looked promising, but didn't work, throwing an error. 
> flatpak permission-show org.gnucash.GnuCash
> 
> This flag looked like it might work, but made no difference. 
> --share=network  (Giving network access also grants access to all host 
> services listening on abstract Unix sockets (due to how network namespaces 
> work)
> 
> Eventually I found the manifest.json file in /usr/lib/flatpak/blah/blah and 
> determined that it did actually have network access anyway. And /home/user/ 
> directory access, for the record. 
> 
> I was poring through mysql logs, and I saw 'Listening on 127.0.0.1', so I 
> thought I'd give that a try on the off-chance ... and it worked! Database 
> saved OK, and I could work off that one. 
> 
> So, apparently changing hostname from localhost to 127.0.0.1 was the magic 
> charm. Anyone else want to give it a try and report back?
> 
> P.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
> 


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.