<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Hello,<br>
<br>
if you had siremis installed, it created some stored procedures
during installation wizard -- you will have to create them on the
new database system as well. There is a sql file inside
siremis/modules/ser/.<br>
<br>
Cheers,<br>
Daniel<br>
<br>
<div class="moz-cite-prefix">On 18/06/14 17:09, Joel White wrote:<br>
</div>
<blockquote
cite="mid:CAK0YwN=9cnmh8BmbW+zZO9eB=pXg74H1xoXWYkB606Srm=kAvg@mail.gmail.com"
type="cite">
<div dir="ltr">
<div>
<div>I made a significant change to the way the system I am
building is designed. I removed the Database to a redundant
cluster and not on the same server as the kamailio install.<br>
<br>
</div>
I changed all references to the DBURL to reflect the IP of the
new cluster.<br>
<br>
</div>
I also changed the SQLOPS statement for CDRs to reflect the new
IP<br>
<br>
<pre class="">modparam<span class="">(</span><span class="">"sqlops"</span><span class="">,</span> <span class="">"sqlcon"</span><span class="">,</span> <span class="">"cb=>mysql://<a moz-do-not-send="true" href="http://kamailio:kamailiorw@10.11.12.5/kamailio">kamailio:kamailiorw@10.11.12.5/kamailio</a>"</span><span class="">)
</span></pre>
<pre class=""><span class=""><span style="font-family:arial,helvetica,sans-serif">All ACC transactions are being recorded to the new DB and the configuration is running well with the exception of CDRs.
</span></span></pre>
<pre class=""><span class=""><span style="font-family:arial,helvetica,sans-serif">What am I missing that would prevent writing of CDRs to the DB?
</span></span></pre>
<pre class=""><span class=""><span style="font-family:arial,helvetica,sans-serif">I did check connectivity from the Kamailio server to the DB server as well as access to the cdrs table
</span></span></pre>
<pre class=""><span class="">
</span></pre>
<br>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a>
<a class="moz-txt-link-freetext" href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a>
</pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Daniel-Constantin Mierla - <a class="moz-txt-link-freetext" href="http://www.asipto.com">http://www.asipto.com</a>
<a class="moz-txt-link-freetext" href="http://twitter.com/#!/miconda">http://twitter.com/#!/miconda</a> - <a class="moz-txt-link-freetext" href="http://www.linkedin.com/in/miconda">http://www.linkedin.com/in/miconda</a></pre>
</body>
</html>