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 <rdboisv...@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 <saigauravmehr...@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 <rdboisv...@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 < >>> saigauravmehr...@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 <rdboisv...@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 < >>>>> saigauravmehr...@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 < >>>>>> rdboisv...@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 < >>>>>>> saigauravmehr...@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 < >>>>>>>> rdboisv...@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 < >>>>>>>>> saigauravmehr...@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@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@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@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@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@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@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@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@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@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@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@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users