[OpenSIPS-Users] Write acc_extra data to separate table

David Villasmil david.villasmil.work at gmail.com
Thu Jun 11 10:55:52 EST 2020


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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20200611/1457d922/attachment.html>


More information about the Users mailing list