<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<tt>Hi Mark,<br>
<br>
If you want to have full control over the DB usage for the ACC
data, I would suggest to use the event_route module to capture the
ACC_CDR event (produced by the acc module) - this event will
expose all the acc data (extra + legs). In the event route you use
the avp_db_query() function (from the avpops) module to place the
acc fields in whatever tables / DB you want.<br>
<br>
Regards,<br>
</tt>
<pre class="moz-signature" cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a class="moz-txt-link-freetext" href="https://www.opensips-solutions.com">https://www.opensips-solutions.com</a>
</pre>
<div class="moz-cite-prefix">On 6/11/20 1:38 PM, Mark Farmer wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CAOvQDevNeyPyJUJoX7gz+6XR+DN2vcFBkqZgQ4oNu1deqZvEqw@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div dir="ltr">Thanks for the reply Johan, I'm not sure that's
quite what I'm looking for.
<div>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.</div>
<div><br>
</div>
<div>Many thanks</div>
<div>Mark.</div>
<div><br>
</div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Thu, 11 Jun 2020 at 11:32,
Johan De Clercq <<a href="mailto:Johan@democon.be"
moz-do-not-send="true">Johan@democon.be</a>> wrote:<br>
</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px
0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex">
<div dir="ltr">
<div>If I am not wrong, you can specify the accounting table
and db in the module params. <br>
</div>
<div>Hence make a copy of the table, insert in a new db, add
your extra column and adapt the module parameters. <br>
</div>
<div><br>
</div>
<div>wkr, <br>
</div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">Op do 11 jun. 2020 om
12:18 schreef Mark Farmer <<a
href="mailto:farmorg@gmail.com" target="_blank"
moz-do-not-send="true">farmorg@gmail.com</a>>:<br>
</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px
0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex">
<div dir="ltr">Hi everyone<br clear="all">
<div><br>
</div>
<div>I have a couple of extra fields in my acc database
table which is added by acc_extra. This causes issues
when upgrading.</div>
<div>I would prefer to have that data stored in a
different database/table.</div>
<div><br>
</div>
<div>Is there a nice way to do that?</div>
<div>OpenSIPS 3.0 in this case.</div>
<div><br>
</div>
<div>Many thanks</div>
<div>Mark.</div>
<div><br>
</div>
</div>
_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.opensips.org" target="_blank"
moz-do-not-send="true">Users@lists.opensips.org</a><br>
<a
href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users"
rel="noreferrer" target="_blank" moz-do-not-send="true">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
</blockquote>
</div>
_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.opensips.org" target="_blank"
moz-do-not-send="true">Users@lists.opensips.org</a><br>
<a
href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users"
rel="noreferrer" target="_blank" moz-do-not-send="true">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
</blockquote>
</div>
<br clear="all">
<div><br>
</div>
-- <br>
<div dir="ltr" class="gmail_signature">Mark Farmer<br>
<a href="mailto:farmorg@gmail.com" target="_blank"
moz-do-not-send="true">farmorg@gmail.com</a></div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
Users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
<br>
</body>
</html>