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@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:5060Jul 22 01:32:32 bmotra kamailio[12604]: udp: 192.168.1.103:5060 http://192.168.1.103:5060Jul 22 01:32:32 bmotra kamailio[12604]: tcp: 127.0.0.1:5060 http://127.0.0.1:5060Jul 22 01:32:32 bmotra kamailio[12604]: tcp: 192.168.1.103:5060 http://192.168.1.103:5060Jul 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@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.d...
On Thu, Jul 21, 2016 at 3:23 PM, Gaurav Bmotra < saigauravmehra91@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@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@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@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@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@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@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