Cdr_sqlite3
Hello,
I am using cdr_sqlite3_custom and the file is automatically saved as:
/var/log/asterisk/master.db
how can I change the location ?
If this is not possible to change in the config file, where in the source code would I change that?
I am using asterisk 16.
thanks,
—
5 thoughts on - Cdr_sqlite3
T24gU2F0LCBNYXIgNCwgMjAyMyBhdCAxOjI5IFBNLCBGb3VyaHVuZHJlZCBUaGVjYXQgPDQwMHRo ZWNhdEBnbXguY2g+IHdyb3RlOgoKPiAvdmFyL2xvZy9hc3Rlcmlzay9tYXN0ZXIuZGIKPgo+IGhv dyBjYW4gSSBjaGFuZ2UgdGhlIGxvY2F0aW9uID8KPgo+IElmIHRoaXMgaXMgbm90IHBvc3NpYmxl IHRvIGNoYW5nZSBpbiB0aGUgY29uZmlnIGZpbGUsIHdoZXJlIGluIHRoZQo+IHNvdXJjZSBjb2Rl IHdvdWxkIEkgY2hhbmdlIHRoYXQ/CgpjZHIvY2RyX3NxbGl0ZTNfY3VzdG9tLmMgbGluZSAzMTEK
CktpbmQgcmVnYXJkcywKU2Vhbg=
Or…
In the [directories] section of asterisk.conf, you can set astlogdir which is usually set to /var/log/asterisk/.
If you want to change the actual file name, may the source be with you.
—
Thanks in advance,
————————————————————————-
Steve Edwards sedwards@sedwards.com Voice: +1-760-468-3867 PST
https://www.linkedin.com/in/steve-edwards-4244281
—
> >
> 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 ?
Can this be done easily by patching few lines somewhere?
thanks,
—
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
—
> thank you Sean
that works beautifully
—