[SR-Users] Possible Oversight, but CDRs are not being written

[Joel White]

I will need to take a look at this after hours.  I did installed siremis
4.0 and then 4.1 on the localhost before moving the DB.  I also did copy
the sql backups to the new server.

Thank you


On Thu, Jun 19, 2014 at 7:48 AM, Joel White <joelewhite at gmail.com> wrote:

> Yeah, this is the message I get in syslog.
>
>
> 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
> 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
> 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
> 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
> 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
> 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
>
>
> I had removed any reference to localhost in my kamailio config
>
> Not sure where it is still pulling localhost from
>
>
>
> On Thu, Jun 19, 2014 at 2:07 AM, Daniel-Constantin Mierla <
> miconda at gmail.com> wrote:
>
>>  Hello,
>>
>> 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/.
>>
>> Cheers,
>> Daniel
>>
>>
>> On 18/06/14 17:09, Joel White wrote:
>>
>>  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.
>>
>>  I changed all references to the DBURL to reflect the IP of the new
>> cluster.
>>
>>  I also changed the SQLOPS statement for CDRs to reflect the new IP
>>
>> modparam("sqlops", "sqlcon", "cb=>mysql://kamailio:kamailiorw@10.11.12.5/kamailio")
>>
>>
>>
>> All ACC transactions are being recorded to the new DB and the configuration is running well with the exception of CDRs.
>>
>>
>>
>> What am I missing that would prevent writing of CDRs to the DB?
>>
>>
>> I did check connectivity from the Kamailio server to the DB server as well as access to the cdrs table
>>
>>
>>
>>
>>
>>
>>
>>
>> _______________________________________________
>> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing listsr-users at lists.sip-router.orghttp://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>>
>>
>> --
>> Daniel-Constantin Mierla - http://www.asipto.comhttp://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
>>
>>
>> _______________________________________________
>> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
>> sr-users at lists.sip-router.org
>> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20140619/48cdec83/attachment.html>