Page 1 of 1

Call Log "doesn't exist"

PostPosted: Thu Jun 16, 2016 4:32 pm
by bursogee
Hi all,

Good day.
I got this server (dialer) from another Call Center Office. It was already set-up VERSION: 2.12-517a. Since it was from another office so I changed the server IP and then after that I dropped "mysqlcheck --all-databases --auto-repair --user=cron -p1234" to repair tables and the result was:
Error : Table 'test.call_log' doesn't exist
status : Operation failed

I'm a newbie, please help.

Thank you.

Re: Call Log "doesn't exist"

PostPosted: Thu Jun 16, 2016 5:06 pm
by williamconley
Delete the "test" Database. You're using the "asterisk" database. Or don't check ALL DATABASES, only check the asterisk database.

Re: Call Log "doesn't exist"

PostPosted: Fri Jun 17, 2016 8:27 am
by bursogee
Thanks williamconley, how am I going to do that? Sorry but still a newbie here.

Re: Call Log "doesn't exist"

PostPosted: Fri Jun 17, 2016 8:42 am
by chornyi_taras
try "mysqlcheck asterisk --auto-repair --user=cron -p1234"

Re: Call Log "doesn't exist"

PostPosted: Fri Jun 17, 2016 9:12 am
by bursogee
chornyi_taras wrote:try "mysqlcheck asterisk --auto-repair --user=cron -p1234"


Did that Chornyi, but still no calls coming in. It says "Serious Network Trouble; __sip_xmit returns error for pkt data"

Thanks.

Re: Call Log "doesn't exist"

PostPosted: Fri Jun 17, 2016 9:38 am
by chornyi_taras
did you change server IP?
if yes run this script
Code: Select all
/usr/share/astguiclient/ADMIN_update_server_ip.pl