<div dir="ltr"><div><div>Yeah, this is the message I get in syslog.<br><br><br>Jun 19 07:41:37 VoIP-Platform-Primary /usr/local/sbin/kamailio[1682]: ERROR: db_mysql [km_dbase.c:122]: db_mysql_submit_query(): driver error on query: The user specified as a definer ('kamailio'@'localhost') does not exist<br>
Jun 19 07:41:37 VoIP-Platform-Primary /usr/local/sbin/kamailio[1682]: ERROR: <core> [db_query.c:181]: db_do_raw_query(): error while submitting query<br>Jun 19 07:41:37 VoIP-Platform-Primary /usr/local/sbin/kamailio[1682]: ERROR: sqlops [sql_api.c:264]: sql_do_query(): cannot do the query<br>
Jun 19 07:41:37 VoIP-Platform-Primary /usr/local/sbin/kamailio[1682]: ERROR: db_mysql [km_dbase.c:122]: db_mysql_submit_query(): driver error on query: The user specified as a definer ('kamailio'@'localhost') does not exist<br>
Jun 19 07:41:37 VoIP-Platform-Primary /usr/local/sbin/kamailio[1682]: ERROR: <core> [db_query.c:181]: db_do_raw_query(): error while submitting query<br>Jun 19 07:41:37 VoIP-Platform-Primary /usr/local/sbin/kamailio[1682]: ERROR: sqlops [sql_api.c:264]: sql_do_query(): cannot do the query<br>
<br><br></div>I had removed any reference to localhost in my kamailio config<br><br></div>Not sure where it is still pulling localhost from<br><div><div><br></div></div></div><div class="gmail_extra"><br><br><div class="gmail_quote">
On Thu, Jun 19, 2014 at 2:07 AM, Daniel-Constantin Mierla <span dir="ltr"><<a href="mailto:miconda@gmail.com" target="_blank">miconda@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div 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<div><div class="h5"><br>
<br>
<div>On 18/06/14 17:09, Joel White wrote:<br>
</div>
</div></div><blockquote type="cite"><div><div class="h5">
<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>modparam<span>(</span><span>"sqlops"</span><span>,</span> <span>"sqlcon"</span><span>,</span> <span>"cb=>mysql://<a href="http://kamailio:kamailiorw@10.11.12.5/kamailio" target="_blank">kamailio:kamailiorw@10.11.12.5/kamailio</a>"</span><span>)
</span></pre>
<pre><span><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><span><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><span><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><span>
</span></pre>
<br>
</div>
<br>
<fieldset></fieldset>
<br>
</div></div><pre>_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
<a href="mailto:sr-users@lists.sip-router.org" target="_blank">sr-users@lists.sip-router.org</a>
<a href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users" target="_blank">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a><span class="HOEnZb"><font color="#888888">
</font></span></pre><span class="HOEnZb"><font color="#888888">
</font></span></blockquote><span class="HOEnZb"><font color="#888888">
<br>
<pre cols="72">--
Daniel-Constantin Mierla - <a href="http://www.asipto.com" target="_blank">http://www.asipto.com</a>
<a href="http://twitter.com/#!/miconda" target="_blank">http://twitter.com/#!/miconda</a> - <a href="http://www.linkedin.com/in/miconda" target="_blank">http://www.linkedin.com/in/miconda</a></pre>
</font></span></div>
<br>_______________________________________________<br>
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list<br>
<a href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a><br>
<a href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users" target="_blank">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a><br>
<br></blockquote></div><br></div>