Link to home
Start Free TrialLog in
Avatar of Koolandrew
Koolandrew

asked on

Asterisk will not start, maybe an mysql issue

I am running asterisk as a wholesale gateway and my back up has crashed, thankfully my main server is still running.

i perform asterisk -vvvr and and asterisk -r and i get the following response.

Unable to connect to remote asterisk (does /var/run/asterisk/asterisk.ctl exist?)

This file does exist, and it is setup the same way as the working server.

When i go to var/log/asterisk.log i get the following:

151024 02:32:19 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
151024  2:32:19 [Note] Plugin 'FEDERATED' is disabled.
151024  2:32:19 InnoDB: The InnoDB memory heap is disabled
151024  2:32:19 InnoDB: Mutexes and rw_locks use GCC atomic builtins
151024  2:32:19 InnoDB: Compressed tables use zlib 1.2.3
151024  2:32:19 InnoDB: Using Linux native AIO
151024  2:32:19 InnoDB: Initializing buffer pool, size = 128.0M
151024  2:32:19 InnoDB: Completed initialization of buffer pool
151024  2:32:19 InnoDB: highest supported file format is Barracuda.
151024  2:32:19  InnoDB: Waiting for the background threads to start
151024  2:32:20 InnoDB: 5.5.41 started; log sequence number 1589349
151024  2:32:20 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
151024  2:32:20 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
151024  2:32:20 [Note] Server socket created on IP: '0.0.0.0'.
151024  2:32:20 [Note] Event Scheduler: Loaded 0 events
151024  2:32:20 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.41'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL) by Remi
151024  2:32:25 /usr/libexec/mysqld: Table './asterisk/cdr' is marked as crashed and should be repaired
151024  2:32:30 /usr/libexec/mysqld: Table './asterisk/cdr' is marked as crashed and should be repaired
151024  2:32:34 /usr/libexec/mysqld: Table './asterisk/cdr' is marked as crashed and should be repaired
151024  2:32:39 /usr/libexec/mysqld: Table './asterisk/cdr' is marked as crashed and should be repaired
151024  2:32:43 /usr/libexec/mysqld: Table './asterisk/cdr' is marked as crashed and should be repaired
151024  2:32:47 /usr/libexec/mysqld: Table './asterisk/cdr' is marked as crashed and should be repaired
151024  2:32:52 /usr/libexec/mysqld: Table './asterisk/cdr' is marked as crashed and should be repaired
151024  2:32:56 /usr/libexec/mysqld: Table './asterisk/cdr' is marked as crashed and should be repaired
151024  2:33:01 /usr/libexec/mysqld: Table './asterisk/cdr' is marked as crashed and should be repaired
151024  2:33:02 [Warning] IP address 'our billing server IP address' could not be resolved: Name or service not known

i go to that table usng phpmyadmin, and it is crashed.

1. How do i fix it.
2. How do i restart Asterisk.

Thanks
ASKER CERTIFIED SOLUTION
Avatar of Dan Craciun
Dan Craciun
Flag of Romania image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Koolandrew
Koolandrew

ASKER

I had figured that out, but thanks.
You're welcome.