[SR-Users] music on hold configuration

Robert Boisvert rdboisvert at gmail.com
Thu Jul 21 22:27:14 CEST 2016


Did you use kamdbctl to create the tables?
https://www.kamailio.org/wiki/install/4.3.x/git#create_mysql_database

On Thu, Jul 21, 2016 at 4:05 PM, Gaurav Bmotra <saigauravmehra91 at gmail.com>
wrote:

> hi Robert
>
> this is my kamailio config entries for MOH
> ---------------------------------------------------------
> #--------------------MOH---------------
> modparam ("mohqueue", "db_url", "mysql://kamailio:kamailiorw@localhost
> /kamailio")
> modparam ("mohqueue", "db_qtable", "mqueues")
> modparam ("mohqueue", "db_ctable", "mcalls")
> modparam ("mohqueue", "mohdir", "/var/kamailio/MOH")
>
> and i have also created the tables in database *mqueues* and *mcalls*
>
> *BUT NOW I M HETING THIS ERROR*
>
> *---------------------------------------------------------------------------------*
>
>
>
> *Jul 22 01:32:32 bmotra kamailio[12604]: INFO: <core> [sctp_core.c:74]:
> sctp_core_check_support(): SCTP API not enabled - if you want to use it,
> load sJul 22 01:32:32 bmotra kamailio[12604]: WARNING: <core>
> [socket_info.c:1371]: fix_hostname(): could not rev. resolve
> 192.168.1.103Jul 22 01:32:32 bmotra kamailio[12604]: WARNING: <core>
> [socket_info.c:1371]: fix_hostname(): could not rev. resolve
> 192.168.1.103Jul 22 01:32:32 bmotra kamailio[12604]: INFO: <core>
> [tcp_main.c:4656]: init_tcp(): using epoll_lt as the io watch method (auto
> detected)Jul 22 01:32:32 bmotra kamailio[12604]: loading modules under
> config path: /usr/lib/x86_64-linux-gnu/kamailio/modules/Jul 22 01:32:32
> bmotra kamailio[12604]: Listening onJul 22 01:32:32 bmotra kamailio[12604]:
>              udp: 127.0.0.1:5060 <http://127.0.0.1:5060>Jul 22 01:32:32
> bmotra kamailio[12604]:              udp: 192.168.1.103:5060
> <http://192.168.1.103:5060>Jul 22 01:32:32 bmotra kamailio[12604]:
>      tcp: 127.0.0.1:5060 <http://127.0.0.1:5060>Jul 22 01:32:32 bmotra
> kamailio[12604]:              tcp: 192.168.1.103:5060
> <http://192.168.1.103:5060>Jul 22 01:32:32 bmotra kamailio[12604]:
> Aliases:Jul 22 01:32:32 bmotra kamailio[12604]:              tcp:
> localhost:5060Jul 22 01:32:32 bmotra kamailio[12604]:              udp:
> localhost:5060Jul 22 01:32:32 bmotra /usr/sbin/kamailio[12607]: INFO: rr
> [../outbound/api.h:54]: ob_load_api(): Failed to import bind_obJul 22
> 01:32:32 bmotra /usr/sbin/kamailio[12607]: INFO: rr [rr_mod.c:174]:
> mod_init(): outbound module not availableJul 22 01:32:32 bmotra
> /usr/sbin/kamailio[12607]: INFO: usrloc [hslot.c:51]: ul_init_locks():
> locks array size 1024Jul 22 01:32:32 bmotra /usr/sbin/kamailio[12607]:
> ERROR: <core> [db.c:439]: db_check_table_version(): invalid version 0 for
> table mcalls found, expectJul 22 01:32:32 bmotra /usr/sbin/kamailio[12607]:
> ERROR: mohqueue [mohq.c:257]: init_db(): mcalls table in DB
> mysql://kamailio:kamailiorw@localhost/kaJul 22 01:32:32 bmotra
> /usr/sbin/kamailio[12607]: ERROR: <core> [sr_module.c:961]: init_mod():
> Error while initializing module mohqueue (/usr/lib/x86_Jul 22 01:32:32
> bmotra /usr/sbin/kamailio[12607]: INFO: <core> [sctp_core.c:53]:
> sctp_core_destroy(): SCTP API not initializedJul 22 01:32:32 bmotra
> systemd[1]: kamailio.service: Control process exited, code=exited
> status=255Jul 22 01:32:32 bmotra systemd[1]: Failed to start Kamailio
> (OpenSER) - the Open Source SIP Server.-- Subject: Unit kamailio.service
> has failed-- Defined-By: systemd*
>
>
>
>
>
>
>
>
>
>
>
>
> On Fri, Jul 22, 2016 at 1:06 AM, Robert Boisvert <rdboisvert at gmail.com>
> wrote:
>
>> Not unless your configuration contains:
>>
>> modparam ("mohqueue", "db_qtable", "mqueues")
>> modparam ("mohqueue", "db_ctable", "mcalls")
>>
>> And you have populated mqueues with the correct information.
>>
>> See
>> http://www.kamailio.org/docs/modules/devel/modules/mohqueue.html#table.parms and
>>
>> http://www.kamailio.org/docs/modules/devel/modules/mohqueue.html#mohqueues.dbase
>>
>> On Thu, Jul 21, 2016 at 3:23 PM, Gaurav Bmotra <
>> saigauravmehra91 at gmail.com> wrote:
>>
>>> i have created two tables
>>>
>>> mqueues and mcalls
>>>
>>> is that ok
>>>
>>>
>>> On Fri, Jul 22, 2016 at 12:11 AM, Robert Boisvert <rdboisvert at gmail.com>
>>> wrote:
>>>
>>>> This error: db_check_table_version(): invalid version 0 for table
>>>> mohqcalls found, exp
>>>>
>>>> Indicates you didn't create the tables or the user does not have access
>>>> to it.
>>>>
>>>> On Thu, Jul 21, 2016 at 2:31 PM, Gaurav Bmotra <
>>>> saigauravmehra91 at gmail.com> wrote:
>>>>
>>>>> Hi Robert
>>>>>
>>>>> Now it gives the forllowing error
>>>>>
>>>>> --------------------------------------------------------------------------
>>>>>
>>>>> Jul 21 23:48:19 bmotra kamailio[11097]: INFO: <core> [sctp_core.c:74]:
>>>>> sctp_core_check_support(): SCTP API not enabled - if you want to use it,
>>>>> load s
>>>>> Jul 21 23:48:19 bmotra kamailio[11097]: WARNING: <core>
>>>>> [socket_info.c:1371]: fix_hostname(): could not rev. resolve 192.168.1.103
>>>>> Jul 21 23:48:19 bmotra kamailio[11097]: WARNING: <core>
>>>>> [socket_info.c:1371]: fix_hostname(): could not rev. resolve 192.168.1.103
>>>>> Jul 21 23:48:19 bmotra kamailio[11097]: INFO: <core>
>>>>> [tcp_main.c:4656]: init_tcp(): using epoll_lt as the io watch method (auto
>>>>> detected)
>>>>> Jul 21 23:48:19 bmotra kamailio[11097]: loading modules under config
>>>>> path: /usr/lib/x86_64-linux-gnu/kamailio/modules/
>>>>> Jul 21 23:48:19 bmotra kamailio[11097]: Listening on
>>>>> Jul 21 23:48:19 bmotra kamailio[11097]:              udp:
>>>>> 127.0.0.1:5060
>>>>> Jul 21 23:48:19 bmotra kamailio[11097]:              udp:
>>>>> 192.168.1.103:5060
>>>>> Jul 21 23:48:19 bmotra kamailio[11097]:              tcp:
>>>>> 127.0.0.1:5060
>>>>> Jul 21 23:48:19 bmotra kamailio[11097]:              tcp:
>>>>> 192.168.1.103:5060
>>>>> Jul 21 23:48:19 bmotra kamailio[11097]: Aliases:
>>>>> Jul 21 23:48:19 bmotra kamailio[11097]:              tcp:
>>>>> localhost:5060
>>>>> Jul 21 23:48:19 bmotra kamailio[11097]:              udp:
>>>>> localhost:5060
>>>>> Jul 21 23:48:19 bmotra /usr/sbin/kamailio[11100]: INFO: rr
>>>>> [../outbound/api.h:54]: ob_load_api(): Failed to import bind_ob
>>>>> Jul 21 23:48:19 bmotra /usr/sbin/kamailio[11100]: INFO: rr
>>>>> [rr_mod.c:174]: mod_init(): outbound module not available
>>>>> Jul 21 23:48:19 bmotra /usr/sbin/kamailio[11100]: INFO: usrloc
>>>>> [hslot.c:51]: ul_init_locks(): locks array size 1024
>>>>> Jul 21 23:48:20 bmotra /usr/sbin/kamailio[11100]: ERROR: <core>
>>>>> [db.c:439]: db_check_table_version(): invalid version 0 for table mohqcalls
>>>>> found, exp
>>>>> Jul 21 23:48:20 bmotra /usr/sbin/kamailio[11100]: ERROR: mohqueue
>>>>> [mohq.c:257]: init_db(): mohqcalls table in DB
>>>>> mysql://kamailio:kamailiorw@localhost
>>>>> Jul 21 23:48:20 bmotra /usr/sbin/kamailio[11100]: ERROR: <core>
>>>>> [sr_module.c:961]: init_mod(): Error while initializing module mohqueue
>>>>> (/usr/lib/x86_
>>>>> Jul 21 23:48:20 bmotra /usr/sbin/kamailio[11100]: INFO: <core>
>>>>> [sctp_core.c:53]: sctp_core_destroy(): SCTP API not initialized
>>>>> Jul 21 23:48:20 bmotra systemd[1]: kamailio.service: Control process
>>>>> exited, code=exited status=255
>>>>> Jul 21 23:48:20 bmotra systemd[1]: Failed to start Kamailio (OpenSER)
>>>>> - the Open Source SIP Server.
>>>>> -- Subject: Unit kamailio.service has failed
>>>>>
>>>>>
>>>>> On Thu, Jul 21, 2016 at 2:22 AM, Robert Boisvert <rdboisvert at gmail.com
>>>>> > wrote:
>>>>>
>>>>>> Guarav,
>>>>>>
>>>>>> It seems that your kamailio.cfg is not setup to use MySQL. It says,
>>>>>> "db_bind_mod(): Module db_mysql not found".  You might want to review
>>>>>> http://www.kamailio.org/docs/modules/devel/modules/db_mysql.html
>>>>>>
>>>>>> Bob
>>>>>>
>>>>>> On Wed, Jul 20, 2016 at 4:41 PM, Gaurav Bmotra <
>>>>>> saigauravmehra91 at gmail.com> wrote:
>>>>>>
>>>>>>> Hi Robert:
>>>>>>>
>>>>>>> 1. all the MOH uncommented
>>>>>>> 2. mohq_process() set now
>>>>>>> 3. rtpproxy module is loaded
>>>>>>> 4. tables created
>>>>>>> 5. Audio dir is created and Audio file is there
>>>>>>>
>>>>>>> But when srtart the kamailio it gives the error
>>>>>>>
>>>>>>> ------------------------------------------------
>>>>>>> Jul 21 02:09:06 bmotra polkitd(authority=local)[2720]: Operator of
>>>>>>> unix-session:c2 successfully authenticated as unix-user:bmotra to gain
>>>>>>> TEMPORARY au
>>>>>>> Jul 21 02:09:06 bmotra systemd[1]: Starting Kamailio (OpenSER) - the
>>>>>>> Open Source SIP Server...
>>>>>>> -- Subject: Unit kamailio.service has begun start-up
>>>>>>> -- Defined-By: systemd
>>>>>>> -- Support:
>>>>>>> http://lists.freedesktop.org/mailman/listinfo/systemd-devel
>>>>>>> --
>>>>>>> -- Unit kamailio.service has begun starting up.
>>>>>>> Jul 21 02:09:07 bmotra kamailio[12523]: INFO: <core>
>>>>>>> [sctp_core.c:74]: sctp_core_check_support(): SCTP API not enabled - if you
>>>>>>> want to use it, load s
>>>>>>> Jul 21 02:09:07 bmotra kamailio[12523]: WARNING: <core>
>>>>>>> [socket_info.c:1371]: fix_hostname(): could not rev. resolve 192.168.1.103
>>>>>>> Jul 21 02:09:07 bmotra kamailio[12523]: WARNING: <core>
>>>>>>> [socket_info.c:1371]: fix_hostname(): could not rev. resolve 192.168.1.103
>>>>>>> Jul 21 02:09:07 bmotra kamailio[12523]: INFO: <core>
>>>>>>> [tcp_main.c:4656]: init_tcp(): using epoll_lt as the io watch method (auto
>>>>>>> detected)
>>>>>>> Jul 21 02:09:07 bmotra kamailio[12523]: loading modules under config
>>>>>>> path: /usr/lib/x86_64-linux-gnu/kamailio/modules/
>>>>>>> Jul 21 02:09:07 bmotra kamailio[12523]: Listening on
>>>>>>> Jul 21 02:09:07 bmotra kamailio[12523]:              udp:
>>>>>>> 127.0.0.1:5060
>>>>>>> Jul 21 02:09:07 bmotra kamailio[12523]:              udp:
>>>>>>> 192.168.1.103:5060
>>>>>>> Jul 21 02:09:07 bmotra kamailio[12523]:              tcp:
>>>>>>> 127.0.0.1:5060
>>>>>>> Jul 21 02:09:07 bmotra kamailio[12523]:              tcp:
>>>>>>> 192.168.1.103:5060
>>>>>>> Jul 21 02:09:07 bmotra kamailio[12523]: Aliases:
>>>>>>> Jul 21 02:09:07 bmotra kamailio[12523]:              tcp:
>>>>>>> localhost:5060
>>>>>>> Jul 21 02:09:07 bmotra kamailio[12523]:              udp:
>>>>>>> localhost:5060
>>>>>>> Jul 21 02:09:07 bmotra /usr/sbin/kamailio[12526]: INFO: rr
>>>>>>> [../outbound/api.h:54]: ob_load_api(): Failed to import bind_ob
>>>>>>> Jul 21 02:09:07 bmotra /usr/sbin/kamailio[12526]: INFO: rr
>>>>>>> [rr_mod.c:174]: mod_init(): outbound module not available
>>>>>>> Jul 21 02:09:07 bmotra /usr/sbin/kamailio[12526]: INFO: usrloc
>>>>>>> [hslot.c:51]: ul_init_locks(): locks array size 1024
>>>>>>> Jul 21 02:09:07 bmotra /usr/sbin/kamailio[12526]: ERROR: <core>
>>>>>>> [db.c:203]: db_bind_mod(): Module db_mysql not found. Missing loadmodule?
>>>>>>> Jul 21 02:09:07 bmotra /usr/sbin/kamailio[12526]: ERROR: mohqueue
>>>>>>> [mohq.c:235]: init_db(): Unable to bind DB API using
>>>>>>> mysql://kamailio:kamailiorw@loc
>>>>>>> Jul 21 02:09:07 bmotra /usr/sbin/kamailio[12526]: ERROR: <core>
>>>>>>> [sr_module.c:961]: init_mod(): Error while initializing module mohqueue
>>>>>>> (/usr/lib/x86_
>>>>>>> Jul 21 02:09:07 bmotra /usr/sbin/kamailio[12526]: INFO: <core>
>>>>>>> [sctp_core.c:53]: sctp_core_destroy(): SCTP API not initialized
>>>>>>> Jul 21 02:09:07 bmotra systemd[1]: kamailio.service: Control process
>>>>>>> exited, code=exited status=255
>>>>>>> Jul 21 02:09:07 bmotra systemd[1]: Failed to start Kamailio
>>>>>>> (OpenSER) - the Open Source SIP Server.
>>>>>>> -- Subject: Unit kamailio.service has failed
>>>>>>> -- Defined-By: systemd
>>>>>>> -- Support:
>>>>>>> http://lists.freedesktop.org/mailman/listinfo/systemd-devel
>>>>>>> --
>>>>>>> -- Unit kamailio.service has failed.
>>>>>>>
>>>>>>> HARE I HAVE ATACHED MY KAMAILIO CONFIG FILE
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> On Wed, Jul 20, 2016 at 11:19 PM, Robert Boisvert <
>>>>>>> rdboisvert at gmail.com> wrote:
>>>>>>>
>>>>>>>> Gaurav,
>>>>>>>>
>>>>>>>> Your request is a little vague but the following things may be
>>>>>>>> helpful:
>>>>>>>>
>>>>>>>>    1. Your configuration has commented out the module statements
>>>>>>>>    which disables it.
>>>>>>>>       - #loadmodule "mohqueue.so"
>>>>>>>>       - #modparam ("mohqueue", "db_url",
>>>>>>>>       "mysql://kamailio:kamailiorw@localhost/kamailio")
>>>>>>>>       - #modparam ("mohqueue", "mohdir", "/var/kamailio/MOH")
>>>>>>>>    2. There is no mohq_process() or mohq_send() functions in the
>>>>>>>>    main loop to intercept INVITES to the queue.
>>>>>>>>    http://www.kamailio.org/docs/modules/devel/modules/mohqueue.html#proc.func
>>>>>>>>    3. It is not clear if the configuration has loaded the rtpproxy
>>>>>>>>    module.
>>>>>>>>    http://www.kamailio.org/docs/modules/devel/modules/mohqueue.html#mod.depends
>>>>>>>>    4. Have you created and populated the MOHQUEUES and MOHQCALLS
>>>>>>>>    tables in the database?
>>>>>>>>    http://www.kamailio.org/docs/modules/devel/modules/mohqueue.html#database
>>>>>>>>    5. Did you create audio files and put them in the mohdir?
>>>>>>>>    http://www.kamailio.org/docs/modules/devel/modules/mohqueue.html#audiofiles
>>>>>>>>
>>>>>>>> Bob
>>>>>>>>
>>>>>>>> On Wed, Jul 20, 2016 at 1:25 PM, Gaurav Bmotra <
>>>>>>>> saigauravmehra91 at gmail.com> wrote:
>>>>>>>>
>>>>>>>>> hi i m a new user of kamailio
>>>>>>>>> i have sertup kamailio SIP to SIP call going well
>>>>>>>>> but now i m tring to impliment Music On Hold
>>>>>>>>> i m this
>>>>>>>>>
>>>>>>>>> http://www.kamailio.org/docs/modules/devel/modules/mohqueue.html#table.parms
>>>>>>>>> but unable to impliment plz help me
>>>>>>>>>
>>>>>>>>> Hare i attache my kamailio config file
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> --
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> *Regards:*
>>>>>>>>> Gaurav Bmotra
>>>>>>>>> Smith Infotech
>>>>>>>>> E-46, phase 8 , Indus Area S.A.S Nagar Mohali 160071
>>>>>>>>>
>>>>>>>>> _______________________________________________
>>>>>>>>> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing
>>>>>>>>> list
>>>>>>>>> sr-users at lists.sip-router.org
>>>>>>>>> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>>>>>>>>>
>>>>>>>>>
>>>>>>>>
>>>>>>>> _______________________________________________
>>>>>>>> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing
>>>>>>>> list
>>>>>>>> sr-users at lists.sip-router.org
>>>>>>>> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> --
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> *Regards:*
>>>>>>> Gaurav Bmotra
>>>>>>> Smith Infotech
>>>>>>> E-46, phase 8 , Indus Area S.A.S Nagar Mohali 160071
>>>>>>>
>>>>>>> _______________________________________________
>>>>>>> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing
>>>>>>> list
>>>>>>> sr-users at lists.sip-router.org
>>>>>>> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>>>>>>>
>>>>>>>
>>>>>>
>>>>>> _______________________________________________
>>>>>> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing
>>>>>> list
>>>>>> sr-users at lists.sip-router.org
>>>>>> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>> --
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> *Regards:*
>>>>> Gaurav Bmotra
>>>>> Smith Infotech
>>>>> E-46, phase 8 , Indus Area S.A.S Nagar Mohali 160071
>>>>>
>>>>> _______________________________________________
>>>>> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
>>>>> sr-users at lists.sip-router.org
>>>>> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>>>>>
>>>>>
>>>>
>>>> _______________________________________________
>>>> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
>>>> sr-users at lists.sip-router.org
>>>> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>>>>
>>>>
>>>
>>>
>>> --
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>> *Regards:*
>>> Gaurav Bmotra
>>> Smith Infotech
>>> E-46, phase 8 , Indus Area S.A.S Nagar Mohali 160071
>>>
>>> _______________________________________________
>>> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
>>> sr-users at lists.sip-router.org
>>> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>>>
>>>
>>
>> _______________________________________________
>> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
>> sr-users at lists.sip-router.org
>> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>>
>>
>
>
> --
>
>
>
>
>
>
>
>
> *Regards:*
> Gaurav Bmotra
> Smith Infotech
> E-46, phase 8 , Indus Area S.A.S Nagar Mohali 160071
>
> _______________________________________________
> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
> sr-users at lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20160721/76a26a4c/attachment.html>


More information about the sr-users mailing list