[GNC] GnuCash Software Update

[Don Earnhardt]

I have seen information about overwriting the current version of GnuCash
(version 2.6.3) on my Windows PC with the latest version.  However, I am
extremely nervous about doing so. I can back up the data, so that doesn't
bother me. I have configured my software with many customized reports and
style sheets and I would be very unhappy to lose any of them.  Is there
ANYTHING that I might lose by installing a new version over my old one?  I
have been using this software quite happily (with one exception) since the
beginning of 2014 and I don't want to have to re-create anything that I have
customized during that time.



--
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] How to use Reminders?

[Stan Brown]

No piece of software can be all things to all people, Fran. Some
"software suites" try to do it, and in the trying they earn a reputation
for being bloated, slow, and buggy. I would deplore anything that moved
GnuCash in that direction.

All due respect, I think you're swimming upstream on this one. In the
long run, it will take you less time to pick and use a calendaring
application that's designed for what you want to do, instead of trying
to force GnuCash to do things it's not meant to do.

-- 
Stan Brown
Tehachapi, CA, USA
https://BrownMath.com
https://OakRoadSystems.com

On 2020-12-09 12:03, Fran_3 via gnucash-user wrote:
>  Please, wake up and smell the real world small business day old burnt coffee 
> at the end of a 12 hour day when you are trying to do the bookkeeping and 
> still get home for a few hours sleep before it all starts over again...
___
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] Saving to MySQL

[Ira Fuchs]

Problem resolved. I was able to login to mysql using the mysql command but was 
not able to login using dbeaver. dbeaver gave an error message about 
sha2_caching_password. To fix that, I reinstalled mysql and specified legacy 
authentication. With that change dbeaver was able to connect and Gnucash is 
able to save to MySQL Perhaps there is a way to do this without reinstalling 
MySql (I tried creating a .cnf file to load the native password plugin but when 
I went to alter user root to use that, the command failed).

Thanks for your help.

> On Dec 10, 2020, at 9:51 AM, Derek Atkins  wrote:
> 
> Hi,
> 
> On Thu, December 10, 2020 9:27 am, Ira Fuchs wrote:
>> (Found mysql in /usr/local/mysql/bin)
>> I can get to the mysql prompt but how to get Gnucash to be able to save?
>> 
> 
> Is the server running?
> Can you actually get to the server via the command-line?
> What do you get from "show databases;" from the command-line prompt?
> 
> IF you can connect and "show databases" works, then you just need to give
> GnuCash the same connection information.   Oh, and you need to have all
> permissions to create the gnucash database.
> 
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
> 
> -derek
> -- 
>   Derek Atkins 617-623-3745
>   de...@ihtfp.com www.ihtfp.com
>   Computer and Internet Security Consultant
> 

___
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] Saving to MySQL

[Derek Atkins]

Hi,

On Thu, December 10, 2020 9:27 am, Ira Fuchs wrote:
> (Found mysql in /usr/local/mysql/bin)
> I can get to the mysql prompt but how to get Gnucash to be able to save?
>

Is the server running?
Can you actually get to the server via the command-line?
What do you get from "show databases;" from the command-line prompt?

IF you can connect and "show databases" works, then you just need to give
GnuCash the same connection information.   Oh, and you need to have all
permissions to create the gnucash database.

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek
-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant

___
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] Saving to MySQL

[Ira Fuchs]

(Found mysql in /usr/local/mysql/bin)
I can get to the mysql prompt but how to get Gnucash to be able to save?


> On Dec 10, 2020, at 9:16 AM, Peter West  > wrote:
> 
> The user id running the server is usually _mysql (note the underscore). I 
> assume you specified root as the mysql users (given the URL you are using.)
> 
> Can you open a terminal (search terminal in spotlight)? Try typing
> mysql -u root
> 
> It should start mysql and ask for a password for root, provided you specified 
> one.
> 
> Peter
> 
> --
> Peter West
> p...@pbw.id.au 
> “Behold, I am the servant of the Lord; let it be to me according to your 
> word.”
> 
>> On 10 Dec 2020, at 4:47 am, Ira Fuchs > > wrote:
>> 
>> I have installed MySQL 8.0.22 on a Mac running Mojave (v10.14.6) with no 
>> changes to any configuration file. I would like to save my GnuCash file to 
>> this server but I am getting an error:
>> 
>> The server at URL mysql://root@localhost/gnucash 
>>  > > experienced an error or encountered bad or 
>> corrupt data.
>> 
>> What to do?
>> ___
>> 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] Saving to MySQL

[Peter West]

The user id running the server is usually _mysql (note the underscore). I 
assume you specified root as the mysql users (given the URL you are using.)

Can you open a terminal (search terminal in spotlight)? Try typing
mysql -u root

It should start mysql and ask for a password for root, provided you specified 
one.

Peter

--
Peter West
p...@pbw.id.au
“Behold, I am the servant of the Lord; let it be to me according to your word.”

> On 10 Dec 2020, at 4:47 am, Ira Fuchs  wrote:
> 
> I have installed MySQL 8.0.22 on a Mac running Mojave (v10.14.6) with no 
> changes to any configuration file. I would like to save my GnuCash file to 
> this server but I am getting an error:
> 
> The server at URL mysql://root@localhost/gnucash 
>  experienced an error or encountered bad or 
> corrupt data.
> 
> What to do?
> ___
> 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] Charts not showing up correctly for multicolumn view

[Christos Delivorias]

I’m not sure if this has been sent to the list but wanted to send again
just in case anyone has seen something similar and can help.
Thanks.

On Sun, 6 Dec 2020 at 15:59, Christos Delivorias 
wrote:

> Hello all,
>
> I've been using Gnucash for a few years now, but I've never been able to
> use the different stylesheets as it always messed up my line/bar/charts.
> Only the default one was able to plot them in the right aspect ratio.
> I took the plunge and upgraded from 3.5 to 4.2 on win10 yesterday and all
> my multicolumn dashboards are not non-visible even with the default
> stelysheet.
> The Default with show like this, overextending the columns:
> [image: image.png]
>
>
> While the Easy will look like this:
> [image: image.png]
>
> Any ideas what I might be doing wrong or how to fix this? Don't have this
> issue if I run it via ubuntu on wsl2, but I can't upgrade to 4.2 on it.
> I've spent a lot of time building these dashboards and i'd like to get
> them back to being functional.
>
> Thank a lot,
> Christos
>
> --
Sent from my phone
___
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.