[OpenSIPS-Users] Write acc_extra data to separate table

[David Villasmil]

You could use
https://opensips.org/html/docs/modules/1.7.x/avpops.html#id293960
Regards,

David Villasmil
email: david.villasmil.work at gmail.com
phone: +34669448337


On Thu, Jun 11, 2020 at 12:07 PM Mark Farmer <farmorg at gmail.com> wrote:

> Hmm... Doesn't seem to exist in OpenSIPS.
>
> How do others do this kind of thing?
>
>
>
> On Thu, 11 Jun 2020 at 11:58, David Villasmil <
> david.villasmil.work at gmail.com> wrote:
>
>> You’re going to need to use sqlops for that, I think.
>>
>> On Thu, 11 Jun 2020 at 11:39, Mark Farmer <farmorg at gmail.com> wrote:
>>
>>> Thanks for the reply Johan, I'm not sure that's quite what I'm looking
>>> for.
>>> I'd like the usual acc data to be written to the normal acc table but my
>>> extra data written to a different table, preferably in a different database.
>>>
>>> Many thanks
>>> Mark.
>>>
>>>
>>> On Thu, 11 Jun 2020 at 11:32, Johan De Clercq <Johan at democon.be> wrote:
>>>
>>>> If I am not wrong, you can specify the accounting table and db in the
>>>> module params.
>>>> Hence make a copy of the table, insert in a new db, add your extra
>>>> column and adapt the module parameters.
>>>>
>>>> wkr,
>>>>
>>>> Op do 11 jun. 2020 om 12:18 schreef Mark Farmer <farmorg at gmail.com>:
>>>>
>>>>> Hi everyone
>>>>>
>>>>> I have a couple of extra fields in my acc database table which is
>>>>> added by acc_extra. This causes issues when upgrading.
>>>>> I would prefer to have that data stored in a different database/table.
>>>>>
>>>>> Is there a nice way to do that?
>>>>> OpenSIPS 3.0 in this case.
>>>>>
>>>>> Many thanks
>>>>> Mark.
>>>>>
>>>>> _______________________________________________
>>>>> Users mailing list
>>>>> Users at lists.opensips.org
>>>>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>>>>
>>>> _______________________________________________
>>>> Users mailing list
>>>> Users at lists.opensips.org
>>>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>>>
>>>
>>>
>>> --
>>> Mark Farmer
>>> farmorg at gmail.com
>>> _______________________________________________
>>> Users mailing list
>>> Users at lists.opensips.org
>>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>>
>> --
>> Regards,
>>
>> David Villasmil
>> email: david.villasmil.work at gmail.com
>> phone: +34669448337
>> _______________________________________________
>> Users mailing list
>> Users at lists.opensips.org
>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>
>
>
> --
> Mark Farmer
> farmorg at gmail.com
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20200611/5b160fd6/attachment.html>