Call Log "doesn't exist"

[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.

[williamconley]

Delete the "test" Database. You're using the "asterisk" database. Or don't check ALL DATABASES, only check the asterisk database.

[bursogee]

Thanks williamconley, how am I going to do that? Sorry but still a newbie here.

[chornyi_taras]

try "mysqlcheck asterisk --auto-repair --user=cron -p1234"

[bursogee]

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.

[chornyi_taras]

did you change server IP?
if yes run this script

Code: Select all

/usr/share/astguiclient/ADMIN_update_server_ip.pl