18 Jun
2014
18 Jun
'14
6:09 p.m.
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
19 Jun
19 Jun
9:07 a.m.
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
<http://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 list
sr-users(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
--
Daniel-Constantin Mierla - http://www.asipto.com
http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
2:48 p.m.
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(a)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@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(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
3:06 p.m.
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(a)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(a)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@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(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
3812
days inactive
3813
days old
3 comments
2 participants
participants (2)
-
Daniel-Constantin Mierla -
Joel White