On further debugging, I found in Kamailio.cfg,

#!ifdef DB_URL
loadmodule "presence"
#!endif

I had commented DB_URL in scscf.cfg, hence presence module was not being loaded.


My Question is, shall we enable DB_URL.

If so, what DB URL should contains, and what related mysql stuff I need to do ....

Pls clarify.

Thanks
Kamal






On Tue, Oct 28, 2014 at 9:23 PM, Kamal Palei <palei.kamal@gmail.com> wrote:
Hi All
I have followed link http://nil.uniza.sk/book/export/html/617 to install P-CSCF/I-CSCF/S-CSCF.

Though I have some doubts in configuration , still I have put the configuration to best of my knowledge.

When I execute SCSCF, I get below errors.

I see some database related errors.

As per the followed link, I find some DB configurations and I did accordingly.

I do not see any DB configurations for SCSCF, still I see two below lines

# Connection URL for the database:
#!define DB_URL "con1=>mysql://scscf:secret@localhost/scscf"
#!define DB_URL2 "con2=>mysql://scscf:secret@localhost/scscf"

in file scscf.cfg

Is this really required, or can I comment these two lines.


root@Kamal-E5430:/etc/kamailio/scscf#
root@Kamal-E5430:/etc/kamailio/scscf#
root@Kamal-E5430:/etc/kamailio/scscf# ./scscf -f kamailio.cfg -E
loading modules under config path: /usr/local/lib64/kamailio/modules/
Listening on
             udp: 192.168.1.114 [192.168.1.114]:4080
             tcp: 192.168.1.114 [192.168.1.114]:4080
Aliases:
             *: scscf.group4-imslab11.in:*

 0(25982) INFO: <core> [tcp_main.c:4745]: init_tcp(): using epoll_lt as the io watch method (auto detected)
 0(25984) INFO: rr [../outbound/api.h:54]: ob_load_api(): Failed to import bind_ob
 0(25984) INFO: rr [rr_mod.c:160]: mod_init(): outbound module not available
 0(25984) ERROR: db_mysql [km_my_con.c:109]: db_mysql_new_connection(): driver error: Access denied for user 'scscf'@'localhost' (using password: YES)
 0(25984) ERROR: <core> [db.c:322]: db_do_init2(): could not add connection to the pool 0(25984) WARNING: db_cluster [dbcl_data.c:456]: dbcl_init_connections(): cannot connect to database - connection [con2]
 0(25984) ERROR: db_mysql [km_my_con.c:109]: db_mysql_new_connection(): driver error: Access denied for user 'scscf'@'localhost' (using password: YES)
 0(25984) ERROR: <core> [db.c:322]: db_do_init2(): could not add connection to the pool 0(25984) WARNING: db_cluster [dbcl_data.c:473]: dbcl_init_connections(): cannot connect to database - connection [con2]
 0(25984) ERROR: db_mysql [km_my_con.c:109]: db_mysql_new_connection(): driver error: Access denied for user 'scscf'@'localhost' (using password: YES)
 0(25984) ERROR: <core> [db.c:322]: db_do_init2(): could not add connection to the pool 0(25984) WARNING: db_cluster [dbcl_data.c:456]: dbcl_init_connections(): cannot connect to database - connection [con1]
 0(25984) ERROR: db_mysql [km_my_con.c:109]: db_mysql_new_connection(): driver error: Access denied for user 'scscf'@'localhost' (using password: YES)
 0(25984) ERROR: <core> [db.c:322]: db_do_init2(): could not add connection to the pool 0(25984) WARNING: db_cluster [dbcl_data.c:473]: dbcl_init_connections(): cannot connect to database - connection [con1]
 0(25984) ERROR: <core> [db.c:401]: db_table_version(): error in db_query
 0(25984) ERROR: <core> [db.c:440]: db_check_table_version(): querying version for table presentity
 0(25984) ERROR: presence [presence.c:322]: mod_init(): error during table version check
 0(25984) ERROR: <core> [sr_module.c:968]: init_mod(): Error while initializing module presence (/usr/local/lib64/kamailio/modules/presence.so)
ERROR: error while initializing modules
 0(25984) INFO: cdp [mod.c:257]: cdp_exit(): CDiameterPeer child stopping ...
 0(25982) ERROR: <core> [daemonize.c:315]: daemonize(): Main process exited before writing to pipe
root@Kamal-E5430:/etc/kamailio/scscf#
root@Kamal-E5430:/etc/kamailio/scscf#


Best Regards
Kamal