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
