[Spce-user] Voicemail issue
Deon Vermeulen
vermeulen.deon at gmail.com
Tue Jan 11 02:58:35 EST 2011
Anyone else able to assist?
Need some guidance/assistance pleeeeeease.....
Thank you
Kind Regards
Deon
On Jan 10, 2011, at 3:52 PM, Deon Vermeulen wrote:
> 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