For some reason these two modparams are always ignored. The table name used is always acc which is default name. How can I change the table name? loadmodule "acc.so" modparam("acc", "db_table_acc", "*acc_$time(year)_$time(mon)*") modparam("acc", "db_table_missed_calls", "*acc_$time(year)_$time(mon)*") Accounting works as expected otherwise. Appreciate any help. Thanks.
Hello,
what version of kamailio are you using (kamailio -v)?
Cheers, Daniel
On 14.03.19 18:04, Z wrote:
For some reason these two modparams are always ignored. The table name used is always acc which is default name. How can I change the table name? loadmodule "acc.so" modparam("acc", "db_table_acc", "*acc_$time(year)_$time(mon)*") modparam("acc", "db_table_missed_calls", "*acc_$time(year)_$time(mon)*") Accounting works as expected otherwise. Appreciate any help. Thanks.
Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Hi Daniel,
The version is 4.2 on Debian stretch.
However, I was able to get it to work using !#define DBURL.
Also I use updates using sqlops. For which I created a variable var(x) at each block {route, reply etc...} for the table name.
Appreciate your help.
Z
On Fri, Mar 15, 2019 at 1:40 AM Daniel-Constantin Mierla miconda@gmail.com wrote:
Hello,
what version of kamailio are you using (kamailio -v)?
Cheers, Daniel On 14.03.19 18:04, Z wrote:
For some reason these two modparams are always ignored. The table name used is always acc which is default name. How can I change the table name? loadmodule "acc.so" modparam("acc", "db_table_acc", "*acc_$time(year)_$time(mon)*") modparam("acc", "db_table_missed_calls", "*acc_$time(year)_$time(mon)*") Accounting works as expected otherwise. Appreciate any help. Thanks.
Kamailio (SER) - Users Mailing Listsr-users@lists.kamailio.orghttps://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
-- Daniel-Constantin Mierla -- www.asipto.comwww.twitter.com/miconda -- www.linkedin.com/in/miconda Kamailio World Conference - May 6-8, 2019 -- www.kamailioworld.com Kamailio Advanced Training - Mar 25-27, 2019, in Washington, DC, USA -- www.asipto.com
Hi Daniel,
The version is 4.2 on Debian stretch.
Please advise how one can ignore/skip/remove *from_tag* and *to_tag* in *acc_db_request* from *acc module* in Kamailio.cfg.
Appreciate your help.
Z
Am Dienstag, 19. März 2019, 06:20:43 CET schrieb Z:
The version is 4.2 on Debian stretch.
Please advise how one can ignore/skip/remove *from_tag* and *to_tag* in *acc_db_request* from *acc module* in Kamailio.cfg.
Appreciate your help.
Hello Z,
please don't address individual persons if you write to this list, there are many people subscribed. :-)
The two tags are output important, as the acc module does not write complete dialogs, only SIP transactions. You'll probably need them to do proper accounting.
Maybe you can explain what do you want to achieve?
Best regards,
Henning
Hi,
I am using acc module for mainly duration. However, from_user, to_user, xcarrier etc are also important here. Was just curios if we can remove unnecessary columns someway since first insert is coming from acc_db_request. Alternatively, I can use sqlops. Please let me know.
Appreciate you help.
Z
On Wed, Mar 20, 2019 at 12:20 PM Henning Westerholt hw@kamailio.org wrote:
Am Dienstag, 19. März 2019, 06:20:43 CET schrieb Z:
The version is 4.2 on Debian stretch.
Please advise how one can ignore/skip/remove *from_tag* and *to_tag* in *acc_db_request* from *acc module* in Kamailio.cfg.
Appreciate your help.
Hello Z,
please don't address individual persons if you write to this list, there are many people subscribed. :-)
The two tags are output important, as the acc module does not write complete dialogs, only SIP transactions. You'll probably need them to do proper accounting.
Maybe you can explain what do you want to achieve?
Best regards,
Henning
-- Henning Westerholt - https://skalatan.de/blog/ Kamailio services - https://skalatan.de/services
Hello,
from_tag and to_tag are actually crucial to match the invite and the bye records. call-id is usually unique per call, but by SIP RFC, a dialog is identified by (call-id, from-tag, to-tag) you have to use all three for matching.
Back to the question, I don't think at this moment is any option to disable storing those values, c coding would be needed to make that optional.
Cheers, Daniel
On 20.03.19 22:49, Z wrote:
Hi,
I am using acc module for mainly duration. However, from_user, to_user, xcarrier etc are also important here. Was just curios if we can remove unnecessary columns someway since first insert is coming from acc_db_request. Alternatively, I can use sqlops. Please let me know.
Appreciate you help.
Z
On Wed, Mar 20, 2019 at 12:20 PM Henning Westerholt <hw@kamailio.org mailto:hw@kamailio.org> wrote:
Am Dienstag, 19. März 2019, 06:20:43 CET schrieb Z: > The version is 4.2 on Debian stretch. > > Please advise how one can ignore/skip/remove *from_tag* and *to_tag* in > *acc_db_request* from *acc module* in Kamailio.cfg. > > Appreciate your help. Hello Z, please don't address individual persons if you write to this list, there are many people subscribed. :-) The two tags are output important, as the acc module does not write complete dialogs, only SIP transactions. You'll probably need them to do proper accounting. Maybe you can explain what do you want to achieve? Best regards, Henning -- Henning Westerholt - https://skalatan.de/blog/ Kamailio services - https://skalatan.de/services
Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
-
Daniel-Constantin Mierla -
Henning Westerholt -
Z