[GNC] Where are GC log files located on Mac with remote database server?

[john]

There's a preference for how long to retain them but I'm not convinced that it works for server-sql backends. Mind, I'm not convinced that it doesn't, either, I just don't know where exactly it's invoked. You might want to set up logrotate (you'll have to get it from Homebrew or build it yourself) to clean out the old logs. There's no other config for that system that I'm aware of.

Note that those transaction logs log only GnuCash transactions, not everything GnuCash does. You've got much better and more complete logs available from your MySQL/MariaDB or PostgresQL server.

Regards,
John Ralls


> On Sep 11, 2023, at 17:40, Jediator <jediator at artemisspace.com> wrote:
> 
> I am glad you pointed out the difference btw trace and transaction logs.  Is there anyway to configure the transaction logging?  I'd like to dump the transaction logs to a different directory and back them up as part of regular backup process.  I'd also want to remove the old log files automatically.  Thanks!
> 
> On 9/11/23 4:25 PM, John Ralls wrote:
>> Yes, log.conf is a user-created file, there is no default. Note that that's about the tracefile (https://wiki.gnucash.org/wiki/Tracefile), not the transaction logs.
>> 
>> Regards,
>> John Ralls
>> 
>> 
>>> On Sep 11, 2023, at 12:46 PM, Jediator <jediator at artemisspace.com> wrote:
>>> 
>>> Thanks John!  Apparently in version 5.3 on Mac, the data directory and config directory of GC is the same on Mac at /Users/username/Library/Application Support/GnuCash, and the log files are in the translog directory underneath.  However, the log.conf file is nowhere to find (supposed to be located at GNC_CONFIG_HOME <https://wiki.gnucash.org/wiki/Configuration_Locations#GNC_CONFIG_HOME>/log.conf according to https://wiki.gnucash.org/wiki/Logging).
>>> 
>>> Should I create a log file manually if the I want to use a non-default configuration?  Thanks!
>>> -- JC
>>> 
>>> 
>>> On 9/11/23 12:30 PM, john wrote:
>>>> The MySQL and PostgresQL backends write the transaction logs to GNC_CONFIG_DIR/translog. Seehttps://wiki.gnucash.org/wiki/Configuration_Locations  to see where GNC_CONFIG_DIR is on your OS.
>>>> 
>>>> Regards,
>>>> John Ralls
>>>> 
>>>> 
>>>>> On Sep 11, 2023, at 06:56, Adrien Monteleone<adrien.monteleone at lusfiber.net>  wrote:
>>>>> 
>>>>> I'm using sqlite on Mac and I have log files. Though I don't see them generated often. I'm not sure if that is because I rarely close the app except for updates.
>>>>> 
>>>>> Regards,
>>>>> Adrien
>>>>> 
>>>>> On 9/11/23 4:15 AM, sunfish62--- via gnucash-user wrote:
>>>>>> Others will correct me, but my understanding is that the log files are not used with the database backend, since the changes are committed immediately.
>>>>> _______________________________________________
>>>>> gnucash-user mailing list
>>>>> gnucash-user at gnucash.org
>>>>> To update your subscription preferences or to unsubscribe:
>>>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>>>> -----
>>>>> 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 at gnucash.org
>>>> To update your subscription preferences or to unsubscribe:
>>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>>> -----
>>>> 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 at gnucash.org
>>> To update your subscription preferences or to unsubscribe:
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>> -----
>>> Please remember to CC this list on all your replies.
>>> You can do this by using Reply-To-List or Reply-All.
>