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

2023-09-11 Thread 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  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  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 
>>> /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  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@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@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@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@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.

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

2023-09-11 Thread Jediator 
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  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 
/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  
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@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@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@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@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.

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

2023-09-11 Thread John Ralls 
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  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 
> /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  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@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@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@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@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.

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

2023-09-11 Thread Jediator 
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 
/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  
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@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@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@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.

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

2023-09-11 Thread Michael or Penny Novack 

On 9/11/2023 12:30 PM, john wrote:

The MySQL and PostgresQL backends write the transaction logs to 
GNC_CONFIG_DIR/translog. See 
https://wiki.gnucash.org/wiki/Configuration_Locations to see where 
GNC_CONFIG_DIR is on your OS.

Regards,
John Ralls


Or . use the search tools of your OS (to find a file or directory 
when you know part of its name)



Michael D Novack


___
gnucash-user mailing list
gnucash-user@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.

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

2023-09-11 Thread john 
The MySQL and PostgresQL backends write the transaction logs to 
GNC_CONFIG_DIR/translog. See 
https://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  
> 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@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@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.

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

2023-09-11 Thread Adrien Monteleone 
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@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.

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

2023-09-11 Thread sunfish62--- via gnucash-user 
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. 

⁣David T.​

On Sep 11, 2023, 9:03 AM, at 9:03 AM, Jediator  
wrote:
>Hi GC users, I am using GC (version 5.3) on Mac.  I noticed that the
>log 
>files are generated in the same directory of the GC data file 
>(sqlite3).  But I couldn't find the log files after switching to a 
>remote database server.  The info on the GC wiki on logging seems to be
>
>outdated, as I can't find the logs nor the log.conf file on my Mac 
>following the wiki instructions.  Thanks in advance! -- JC
>___
>gnucash-user mailing list
>gnucash-user@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@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.