yes i have use kamdbctl to create database
actualy all is working fine like SIP to SIP call
i just want to impliment the MOH on this but when i impliment all this MOH
configurationd then it give the error during startart the kamailio
if i remove this MOH entryes then it will work fine
but i want to configure the MOH in this ..
On Fri, Jul 22, 2016 at 1:57 AM, Robert Boisvert <rdboisvert(a)gmail.com>
wrote:
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(a)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(a)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.…
>>
>> On Thu, Jul 21, 2016 at 3:23 PM, Gaurav Bmotra <
>> saigauravmehra91(a)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(a)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(a)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(a)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(a)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(a)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(a)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(a)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(a)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(a)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(a)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(a)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(a)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(a)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(a)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(a)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(a)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