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
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
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You're welcome.
ASKER