db_mysql_submit_query(): driver error on query: Table 'homer_data.sip_capture_call_20151203' doesn't exist about homer-api HOT 5 CLOSED

rotation script.

https://github.com/sipcapture/homer/wiki/Quick-Install#mysql

Wbr,
Alexandr

On 3 December 2015 at 10:39, yuvalcnaan [email protected] wrote:

After few days kamailio can't write to mysql....why ? who is creating new
table every day?

mysql> show tables;
+-----------------------------------+
| Tables_in_homer_data |
+-----------------------------------+
| logs_capture |
| report_capture |
| rtcp_capture |
| sip_capture_call_20151129 |
| sip_capture_call_20151130 |
| sip_capture_call_20151201 |
| sip_capture_registration_20151129 |
| sip_capture_registration_20151130 |
| sip_capture_registration_20151201 |
| sip_capture_rest_20151129 |
| sip_capture_rest_20151130 |
| sip_capture_rest_20151201 |
+-----------------------------------+

Thanks!

Yuval Cnaan

—
Reply to this email directly or view it on GitHub
https://github.com/sipcapture/homer-api/issues/61.

from homer-api.

homer 5 as well ?

from homer-api.

yes, the scripts should be installed in both versions.

Wbr,
Alexandr

On 3 December 2015 at 10:47, yuvalcnaan [email protected] wrote:

homer 5 as well ?

—
Reply to this email directly or view it on GitHub
https://github.com/sipcapture/homer-api/issues/61#issuecomment-161570326
.

from homer-api.

Thanks! i run it manually
/usr/bin/homer_rotate .....
in
/etc/cron.d/sipcapture

Centos 7

Thanks!

from homer-api.

you are welcome

from homer-api.