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 s
Jul 22 01:32:32 bmotra kamailio[12604]: WARNING: <core> [socket_info.c:1371]: fix_hostname(): could not rev. resolve 192.168.1.103
Jul 22 01:32:32 bmotra kamailio[12604]: WARNING: <core> [socket_info.c:1371]: fix_hostname(): could not rev. resolve 192.168.1.103
Jul 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 on
Jul 22 01:32:32 bmotra kamailio[12604]:              udp: 127.0.0.1:5060
Jul 22 01:32:32 bmotra kamailio[12604]:              udp: 192.168.1.103:5060
Jul 22 01:32:32 bmotra kamailio[12604]:              tcp: 127.0.0.1:5060
Jul 22 01:32:32 bmotra kamailio[12604]:              tcp: 192.168.1.103:5060
Jul 22 01:32:32 bmotra kamailio[12604]: Aliases:
Jul 22 01:32:32 bmotra kamailio[12604]:              tcp: localhost:5060
Jul 22 01:32:32 bmotra kamailio[12604]:              udp: localhost:5060
Jul 22 01:32:32 bmotra /usr/sbin/kamailio[12607]: INFO: rr [../outbound/api.h:54]: ob_load_api(): Failed to import bind_ob
Jul 22 01:32:32 bmotra /usr/sbin/kamailio[12607]: INFO: rr [rr_mod.c:174]: mod_init(): outbound module not available
Jul 22 01:32:32 bmotra /usr/sbin/kamailio[12607]: INFO: usrloc [hslot.c:51]: ul_init_locks(): locks array size 1024
Jul 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, expect
Jul 22 01:32:32 bmotra /usr/sbin/kamailio[12607]: ERROR: mohqueue [mohq.c:257]: init_db(): mcalls table in DB mysql://kamailio:kamailiorw@localhost/ka
Jul 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 initialized
Jul 22 01:32:32 bmotra systemd[1]: kamailio.service: Control process exited, code=exited status=255
Jul 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.


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
-- 
-- 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
-- 
-- 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 
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