On 3/28/2023 4:03 AM, Fourhundred Thecat wrote:> > On 2023-03-04 23:11, Sean Bright wrote:
> >
> > cdr/cdr_sqlite3_custom.c line 311
>
> Hello,
>
> I asked here recently how to change the location where
> "cdr_sqlite3_custom" stores the sqlite database. The default is
location
> is "astlogdir".
>
> I need to change this location without affecting the rest of the
> asterisk logs.
>
> Sean Bright suggested to patch cdr/cdr_sqlite3_custom.c
>
> But I cannot hard-code the path either.
>
> How could I create new custom configuration variable, perhaps
> "cdrlogdir", that I could then assign in asterisk.conf ?
Something like the following:
https://gist.github.com/seanbright/f8331df57aacdd06b6d391dfec2f59c6
This adds a new 'filename' option that you would provide in
/etc/asterisk/cdr_sqlite3_custom.conf like:
[master]
; A non-absolute path will be relative to Asterisk's log
; directory
filename = testing.db
Or:
[master]
filename = /full/path/to/testing.db
This patch does not support module reload, so once the filename is set
you would have to unload and load the module or restart Asterisk if you
wanted to change the path to the database file.
To apply:
$ cd /path/to/source/code/of/asterisk
$ curl
https://gist.githubusercontent.com/seanbright/f8331df57aacdd06b6d391dfec2f59c6/raw/693f7027440b07d1122283d4d750051f8acbbe94/gistfile0.txt
| patch -p1
$ make && sudo make install
Kind regards,
Sean