[Spce-user] Voicemail issue
Deon Vermeulen
vermeulen.deon at gmail.com
Mon Jan 10 08:52:47 EST 2011
Hi Andreas
Looks like my problem with MySQL is resolved.
The problem was mysql not listening on any interface.
skip_networking is in the default script, so I changed it as below:
#skip_networking
bind-address=localhost
I restarted mysql and then I could see mysql listening:
netstat -tldp
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
tcp 0 0 *:8000 *:* LISTEN 4609/kamailio
tcp 0 0 localhost:mysql *:* LISTEN 2403/mysqld
tcp 0 0 *:41839 *:* LISTEN 1838/rpc.statd
tcp 0 0 *:sunrpc *:* LISTEN 1827/portmap
tcp 0 0 *:ssh *:* LISTEN 2095/sshd
tcp 0 0 localhost:smtp *:* LISTEN 2762/exim4
tcp 0 0 *:8090 *:* LISTEN 2854/sems
tcp6 0 0 [::]:2443 [::]:* LISTEN 3001/apache2
tcp6 0 0 [::]:www [::]:* LISTEN 3001/apache2
tcp6 0 0 [::]:ssh [::]:* LISTEN 2095/sshd
tcp6 0 0 [::]:4443 [::]:* LISTEN 3001/apache2
tcp6 0 0 [::]:https [::]:* LISTEN 3001/apache2
sce01:~#
I then updated /etc/ngcp-config/templates/etc/mysql/my.cnf.tt2 and did ngcpcfg apply, and it was still listening as above.
I am still getting the below errors, but from posts on the NET this does not stop MySQL from working:
/var/log/mysql/mysqld.err
110110 15:38:56 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
110110 15:38:56 [Warning] '--default-character-set' is deprecated and will be removed in a future release. Please use '--character-set-server' instead.
110110 15:38:56 [Warning] '--default-collation' is deprecated and will be removed in a future release. Please use '--collation-server' instead.
110110 15:38:56 [Warning] '--log_slow_queries' is deprecated and will be removed in a future release. Please use ''--slow_query_log'/'--slow_query_log_file'' instead.
110110 15:38:56 [Warning] '--log-long-format' is deprecated and will be removed in a future release. Please use '--log-short-format' instead.
110110 15:38:56 [Note] Flashcache bypass: disabled
110110 15:38:56 [Note] Flashcache setup error is : ioctl failed
110110 15:38:56 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use GCC atomic builtins
InnoDB: Compressed tables use zlib 1.2.3.3
110110 15:38:56 InnoDB: highest supported file format is Barracuda.
110110 15:38:57 Percona XtraDB (http://www.percona.com) 1.0.13-12.4 started; log sequence number 969190
110110 15:38:57 [Warning] 'user' entry 'root at XXXXX' ignored in --skip-name-resolve mode.
110110 15:38:57 [Note] Event Scheduler: Loaded 0 events
110110 15:38:57 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.53-rel12.4-log' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Percona Server (GPL), 12.4 , Revision 181)
I can also see that Kamailio and Asterisk is listening:
netstat -na | grep 5060
udp 0 0 127.0.0.1:5060 0.0.0.0:*
udp 0 0 41.218.70.246:5060 0.0.0.0:*
sce01:~# netstat -na | grep 5070
udp 0 0 41.218.70.246:5070 0.0.0.0:*
I restarted the server, but still no luck in getting the rest of my issues/errors resolved.
I still get errors as below:
/var/log/ngcp/kamailio.log
/usr/sbin/kamailio[4580]: WARNING: permissions [parse_config.c:251]: file not found: /etc/kamailio/permissions.allow
/usr/sbin/kamailio[4580]: WARNING: permissions [permissions.c:604]: default allow file (/etc/kamailio/permissions.allow) not found => empty rule set
/usr/sbin/kamailio[4580]: WARNING: permissions [parse_config.c:251]: file not found: /etc/kamailio/permissions.deny
/usr/sbin/kamailio[4580]: WARNING: permissions [permissions.c:613]: default deny file (/etc/kamailio/permissions.deny) not found => empty rule set
/usr/sbin/kamailio[4580]: WARNING: dialplan [dp_db.c:238]: no data in the db
/var/log/ngcp/sems.log
sems[2797]: WARNING: [7f26668a36f0] sig_usr_un (sems.cpp:92): Signal 15 received.
/var/log/ngcp/voicemail
asterisk[2483]: WARNING[2483]: res_features.c:2851 in load_config: Could not load features.conf
asterisk[2483]: NOTICE[2483]: res_smdi.c:862 in smdi_load: Unable to load config smdi.conf: SMDI disabled
asterisk[2483]: WARNING[2483]: res_smdi.c:1337 in load_module: No SMDI interfaces are available to listen on, not starting SMDI listener.
asterisk[2483]: WARNING[2483]: cdr_odbc.c:268 in odbc_load_module: cdr_odbc: Unable to load config for ODBC CDR's: cdr_odbc.conf
asterisk[2483]: WARNING[2483]: app_voicemail.c:8482 in load_config: maxsilence should be less than minmessage or you may get empty messages
asterisk[2483]: NOTICE[2483]: manager.c:2958 in init_manager: Unable to open management configuration manager.conf. Call management disabled.
I've been looking all over the NET since my original post, but still can't find any info to help me resolve the above issues.
Maybe I'm not searching correctly....?
Thank you in advance for your help and guidance.
Kind Regards
Deon
On Jan 10, 2011, at 12:43 PM, Deon Vermeulen wrote:
> Hi Andreas
>
> Oops, my bad. SEMS does the conferencing, not the voicemail.
>
> I've been all over the logs and I downloaded the VirtualBox image to verify my configs, but I have no idea what the problem could be or how to fix the issues showing in the error logs.
>
> Here are the Error/Warning outputs from the respective log files:
>
>
> /etc/var/log/ngcp/kamailio.log:
> /usr/sbin/kamailio[11147]: WARNING: permissions [permissions.c:604]: default allow file (/etc/kamailio/permissions.allow) not found => empty rule set
> /usr/sbin/kamailio[11147]: WARNING: permissions [parse_config.c:251]: file not found: /etc/kamailio/permissions.deny
> /usr/sbin/kamailio[11147]: WARNING: permissions [permissions.c:613]: default deny file (/etc/kamailio/permissions.deny) not found => empty rule set
> /usr/sbin/kamailio[11147]: WARNING: dialplan [dp_db.c:238]: no data in the db
>
>
> /etc/var/log/ngcp/sems.log:
> sems[2846]: WARNING: [7f544ccc36f0] sig_usr_un (sems.cpp:92): Signal 15 received.
>
>
> /etc/var/log/ngcp/voicemail.log:
> asterisk[2466]: NOTICE[2466]: loader.c:874 in load_modules: 2 modules will be loaded.
> asterisk[2466]: NOTICE[2466]: res_odbc.c:537 in odbc_obj_connect: Connecting asterisk
> asterisk[2466]: NOTICE[2466]: res_odbc.c:565 in odbc_obj_connect: res_odbc: Connected to asterisk [asterisk]
> asterisk[2466]: NOTICE[2466]: res_odbc.c:320 in load_odbc_config: Registered ODBC class 'asterisk' dsn->[asterisk]
> asterisk[2466]: NOTICE[2466]: res_odbc.c:737 in load_module: res_odbc loaded.
> asterisk[2466]: NOTICE[2466]: config.c:1276 in ast_config_engine_register: Registered Config Engine odbc
> asterisk[2466]: NOTICE[2466]: cdr.c:1419 in do_reload: CDR simple logging enabled.
> asterisk[2466]: NOTICE[2466]: loader.c:874 in load_modules: 28 modules will be loaded.
> asterisk[2466]: WARNING[2466]: res_features.c:2851 in load_config: Could not load features.conf
> asterisk[2466]: NOTICE[2466]: res_smdi.c:862 in smdi_load: Unable to load config smdi.conf: SMDI disabled
> asterisk[2466]: WARNING[2466]: res_smdi.c:1337 in load_module: No SMDI interfaces are available to listen on, not starting SMDI listener.
> asterisk[2466]: WARNING[2466]: cdr_odbc.c:268 in odbc_load_module: cdr_odbc: Unable to load config for ODBC CDR's: cdr_odbc.conf
> asterisk[2466]: WARNING[2466]: app_voicemail.c:8482 in load_config: maxsilence should be less than minmessage or you may get empty messages
> asterisk[2466]: NOTICE[2466]: manager.c:2958 in init_manager: Unable to open management configuration manager.conf. Call management disabled.
>
>
> /var/log/mysql/mysql.err:
> 110110 12:02:10 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
> 110110 12:02:13 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
> 110110 12:02:13 [Warning] '--default-character-set' is deprecated and will be removed in a future release. Please use '--character-set-server' instead.
> 110110 12:02:13 [Warning] '--default-collation' is deprecated and will be removed in a future release. Please use '--collation-server' instead.
> 110110 12:02:13 [Warning] '--log_slow_queries' is deprecated and will be removed in a future release. Please use ''--slow_query_log'/'--slow_query_log_file'' instead.
> 110110 12:02:13 [Warning] '--log-long-format' is deprecated and will be removed in a future release. Please use '--log-short-format' instead.
> 110110 12:02:13 [Note] Flashcache bypass: disabled
> 110110 12:02:13 [Note] Flashcache setup error is : ioctl failed
>
> 110110 12:02:13 [Note] Plugin 'FEDERATED' is disabled.
> InnoDB: The InnoDB memory heap is disabled
> InnoDB: Mutexes and rw_locks use GCC atomic builtins
> InnoDB: Compressed tables use zlib 1.2.3.3
> 110110 12:02:13 InnoDB: highest supported file format is Barracuda.
> 110110 12:02:13 Percona XtraDB (http://www.percona.com) 1.0.13-12.4 started; log sequence number 964909
> 110110 12:02:13 [Warning] 'user' entry 'root at sce01' ignored in --skip-name-resolve mode.
> 110110 12:02:13 [Note] Event Scheduler: Loaded 0 events
> 110110 12:02:13 [Note] /usr/sbin/mysqld: ready for connections.
> Version: '5.1.53-rel12.4-log' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Percona Server (GPL), 12.4 , Revision 181)
>
>
> netstat -tldp
> Active Internet connections (only servers)
> Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
> tcp 0 0 *:8000 *:* LISTEN 11177/kamailio (Is this correct?, shouldn't it be sip/5060?)
> tcp 0 0 *:47073 *:* LISTEN 1845/rpc.statd
> tcp 0 0 *:sunrpc *:* LISTEN 1824/portmap
> tcp 0 0 *:ssh *:* LISTEN 2082/sshd
> tcp 0 0 localhost:smtp *:* LISTEN 2754/exim4
> tcp 0 0 *:8090 *:* LISTEN 2852/sems
> tcp6 0 0 [::]:2443 [::]:* LISTEN 2988/apache2
> tcp6 0 0 [::]:www [::]:* LISTEN 2988/apache2
> tcp6 0 0 [::]:ssh [::]:* LISTEN 2082/sshd
> tcp6 0 0 [::]:1443 [::]:* LISTEN 2988/apache2
> tcp6 0 0 [::]:https [::]:* LISTEN 2988/apache2
>
> I don't see mysql/3306 or asterisk/5070 in the above output?
>
>
> netstat -a | grep kam
> <shows no information>
>
>
> netstat -a | grep mysql
> unix 2 [ ACC ] STREAM LISTENING 115349 /var/run/mysqld/mysqld.sock
> unix 3 [ ] STREAM CONNECTED 133184 /var/run/mysqld/mysqld.sock
> unix 3 [ ] STREAM CONNECTED 115357 /var/run/mysqld/mysqld.sock
> unix 3 [ ] STREAM CONNECTED 115355 /var/run/mysqld/mysqld.sock
> unix 3 [ ] STREAM CONNECTED 115353 /var/run/mysqld/mysqld.sock
>
>
> netstat -a | grep asterisk
> unix 2 [ ACC ] STREAM LISTENING 5675 /var/run/asterisk.ctl
> sce01:/etc/ngcp-config/templates/etc# /etc/init.d/asterisk start
> Starting Asterisk PBX: asterisk/usr/sbin/asterisk already running.
>
>
> Thanks for helping. Really appreciate.
>
> Regards
> Deon
>
>
> On Jan 9, 2011, at 5:38 PM, Andreas Granig wrote:
>
>> Hi,
>>
>>> For some reason I get " Internal error, please try again later. " in the CSC Self-Administration Interface.
>>
>> Could you please check the /var/log/ngcp/oss.log for any errors
>> (probably sending me the whole thing in private would be helpful if you
>> can't spot the error).
>>
>>> I don't know SEMS and it would be greate if someone could give me some guidance as to what I should look at?
>>
>> Shouldn't have to do anything with SEMS, rather than a provisioning
>> issue in the database.
>>
>> Andreas
>>
>> _______________________________________________
>> Spce-user mailing list
>> Spce-user at lists.sipwise.com
>> http://lists.sipwise.com/listinfo/spce-user
>
More information about the Spce-user
mailing list