[OpenSIPS-Users] Write acc_extra data to separate table

Mark Farmer farmorg at gmail.com
Thu Jun 11 11:07:12 EST 2020


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


More information about the Users mailing list