[OpenSIPS-Users] Problem Getting started with Load Balancing

John S. Robinson js.robinson at comcast.net
Sun Jul 12 16:39:35 CEST 2009 

Hello, all --

I am new to openSIPs, but experienced at sip, and some proficiency in 
MySQL, and some proficiency in Linux

I have successfully compiled, but have problem getting started.  My 
error log is below.   It looks like I am successfully starting and 
connecting to mysql, but mysql is not finding a table named 'version'.  

Is there somewhere a list of tables that I must create and populate 
before starting up?  Where do I find it? Or what am I missing?  

Thanks in advance,

John

Jul 12 09:26:06 [17262] DBG:core:yyparse: loading module 
//lib/opensips/modules/maxfwd.so
Jul 12 09:26:07 [17262] DBG:core:yyparse: loading module 
//lib/opensips/modules/sl.so
Jul 12 09:26:07 [17262] DBG:core:yyparse: loading module 
//lib/opensips/modules/db_mysql.so
Jul 12 09:26:07 [17262] DBG:core:yyparse: loading module 
//lib/opensips/modules/tm.so
Jul 12 09:26:07 [17262] DBG:core:register_module: register_pv: tm
Jul 12 09:26:07 [17262] DBG:core:pv_add_extra: extra items list is not 
initialized
Jul 12 09:26:07 [17262] DBG:core:yyparse: loading module 
//lib/opensips/modules/rr.so
Jul 12 09:26:07 [17262] DBG:core:register_module: register_pv: rr
Jul 12 09:26:07 [17262] DBG:core:yyparse: loading module 
//lib/opensips/modules/xlog.so
Jul 12 09:26:07 [17262] DBG:core:register_module: register_pv: xlog
Jul 12 09:26:07 [17262] DBG:core:yyparse: loading module 
//lib/opensips/modules/uri.so
Jul 12 09:26:07 [17262] DBG:core:yyparse: loading module 
//lib/opensips/modules/dialog.so
Jul 12 09:26:07 [17262] DBG:core:register_module: register_pv: dialog
Jul 12 09:26:07 [17262] DBG:core:yyparse: loading module 
//lib/opensips/modules/mi_fifo.so
Jul 12 09:26:07 [17262] DBG:core:yyparse: loading module 
//lib/opensips/modules/signaling.so
Jul 12 09:26:07 [17262] DBG:core:yyparse: loading module 
//lib/opensips/modules/textops.so
Jul 12 09:26:07 [17262] DBG:core:yyparse: loading module 
//lib/opensips/modules/load_balancer.so
Jul 12 09:26:07 [17262] DBG:core:yyparse: loading module 
//lib/opensips/modules/usrloc.so
Jul 12 09:26:07 [17262] DBG:core:yyparse: loading module 
//lib/opensips/modules/registrar.so
Jul 12 09:26:07 [17262] DBG:core:yyparse: loading module 
//lib/opensips/modules/uri_db.so
Jul 12 09:26:07 [17262] DBG:core:yyparse: loading module 
//lib/opensips/modules/acc.so
Jul 12 09:26:07 [17262] DBG:core:set_mod_param_regex: mi_fifo matches 
module mi_fifo
Jul 12 09:26:07 [17262] DBG:core:set_mod_param_regex: found <fifo_name> 
in module mi_fifo [//lib/opensips/modules/]
Jul 12 09:26:07 [17262] DBG:core:set_mod_param_regex: dialog matches 
module dialog
Jul 12 09:26:07 [17262] DBG:core:set_mod_param_regex: found <dlg_flag> 
in module dialog [//lib/opensips/modules/]
Jul 12 09:26:07 [17262] DBG:core:set_mod_param_regex: dialog matches 
module dialog
Jul 12 09:26:07 [17262] DBG:core:set_mod_param_regex: found <db_mode> in 
module dialog [//lib/opensips/modules/]
Jul 12 09:26:07 [17262] DBG:core:set_mod_param_regex: dialog matches 
module dialog
Jul 12 09:26:07 [17262] DBG:core:set_mod_param_regex: found <db_url> in 
module dialog [//lib/opensips/modules/]
Jul 12 09:26:07 [17262] DBG:core:set_mod_param_regex: rr matches module rr
Jul 12 09:26:07 [17262] DBG:core:set_mod_param_regex: found 
<enable_full_lr> in module rr [//lib/opensips/modules/]
Jul 12 09:26:07 [17262] DBG:core:set_mod_param_regex: rr matches module rr
Jul 12 09:26:07 [17262] DBG:core:set_mod_param_regex: found 
<append_fromtag> in module rr [//lib/opensips/modules/]
Jul 12 09:26:07 [17262] DBG:core:set_mod_param_regex: rr matches module rr
Jul 12 09:26:07 [17262] DBG:core:set_mod_param_regex: found 
<enable_double_rr> in module rr [//lib/opensips/modules/]
Jul 12 09:26:07 [17262] DBG:core:set_mod_param_regex: registrar matches 
module registrar
Jul 12 09:26:07 [17262] DBG:core:set_mod_param_regex: found 
<method_filtering> in module registrar [//lib/opensips/modules/]
Jul 12 09:26:07 [17262] DBG:core:set_mod_param_regex: usrloc matches 
module usrloc
Jul 12 09:26:07 [17262] DBG:core:set_mod_param_regex: found <db_mode> in 
module usrloc [//lib/opensips/modules/]
Jul 12 09:26:07 [17262] DBG:core:set_mod_param_regex: uri_db matches 
module uri_db
Jul 12 09:26:07 [17262] DBG:core:set_mod_param_regex: found 
<use_uri_table> in module uri_db [//lib/opensips/modules/]
Jul 12 09:26:07 [17262] DBG:core:set_mod_param_regex: uri_db matches 
module uri_db
Jul 12 09:26:07 [17262] DBG:core:set_mod_param_regex: found <db_url> in 
module uri_db [//lib/opensips/modules/]
Jul 12 09:26:07 [17262] DBG:core:set_mod_param_regex: acc matches module acc
Jul 12 09:26:07 [17262] DBG:core:set_mod_param_regex: found 
<early_media> in module acc [//lib/opensips/modules/]
Jul 12 09:26:07 [17262] DBG:core:set_mod_param_regex: acc matches module acc
Jul 12 09:26:07 [17262] DBG:core:set_mod_param_regex: found <report_ack> 
in module acc [//lib/opensips/modules/]
Jul 12 09:26:07 [17262] DBG:core:set_mod_param_regex: acc matches module acc
Jul 12 09:26:07 [17262] DBG:core:set_mod_param_regex: found 
<report_cancels> in module acc [//lib/opensips/modules/]
Jul 12 09:26:07 [17262] DBG:core:set_mod_param_regex: acc matches module acc
Jul 12 09:26:07 [17262] DBG:core:set_mod_param_regex: found 
<detect_direction> in module acc [//lib/opensips/modules/]
Jul 12 09:26:07 [17262] DBG:core:set_mod_param_regex: acc matches module acc
Jul 12 09:26:07 [17262] DBG:core:set_mod_param_regex: found 
<failed_transaction_flag> in module acc [//lib/opensips/modules/]
Jul 12 09:26:07 [17262] DBG:core:set_mod_param_regex: acc matches module acc
Jul 12 09:26:07 [17262] DBG:core:set_mod_param_regex: found <log_flag> 
in module acc [//lib/opensips/modules/]
Jul 12 09:26:07 [17262] DBG:core:set_mod_param_regex: acc matches module acc
Jul 12 09:26:07 [17262] DBG:core:set_mod_param_regex: found 
<log_missed_flag> in module acc [//lib/opensips/modules/]
Jul 12 09:26:07 [17262] DBG:core:set_mod_param_regex: acc matches module acc
Jul 12 09:26:07 [17262] DBG:core:set_mod_param_regex: found <db_flag> in 
module acc [//lib/opensips/modules/]
Jul 12 09:26:07 [17262] DBG:core:set_mod_param_regex: acc matches module acc
Jul 12 09:26:07 [17262] DBG:core:set_mod_param_regex: found 
<db_missed_flag> in module acc [//lib/opensips/modules/]
Jul 12 09:26:07 [17262] DBG:core:find_cmd_export_t: found 
<mf_process_maxfwd_header>(1) in module maxfwd [//lib/opensips/modules/]
Jul 12 09:26:07 [17262] DBG:core:find_cmd_export_t: found 
<sl_send_reply>(2) in module sl [//lib/opensips/modules/]
Jul 12 09:26:07 [17262] DBG:core:find_cmd_export_t: found <has_totag>(0) 
in module uri [//lib/opensips/modules/]
Jul 12 09:26:07 [17262] DBG:core:find_cmd_export_t: found 
<loose_route>(0) in module rr [//lib/opensips/modules/]
Jul 12 09:26:07 [17262] DBG:core:find_cmd_export_t: found <is_method>(1) 
in module textops [//lib/opensips/modules/]
Jul 12 09:26:07 [17262] DBG:core:find_cmd_export_t: found <is_method>(1) 
in module textops [//lib/opensips/modules/]
Jul 12 09:26:07 [17262] DBG:core:find_cmd_export_t: found 
<record_route>(0) in module rr [//lib/opensips/modules/]
Jul 12 09:26:07 [17262] DBG:core:find_cmd_export_t: found <is_method>(1) 
in module textops [//lib/opensips/modules/]
Jul 12 09:26:07 [17262] DBG:core:find_cmd_export_t: found 
<t_check_trans>(0) in module tm [//lib/opensips/modules/]
Jul 12 09:26:07 [17262] DBG:core:find_cmd_export_t: found <t_relay>(0) 
in module tm [//lib/opensips/modules/]
Jul 12 09:26:07 [17262] DBG:core:find_cmd_export_t: found 
<sl_send_reply>(2) in module sl [//lib/opensips/modules/]
Jul 12 09:26:07 [17262] DBG:core:find_cmd_export_t: found <is_method>(1) 
in module textops [//lib/opensips/modules/]
Jul 12 09:26:07 [17262] DBG:core:find_cmd_export_t: found 
<t_check_trans>(0) in module tm [//lib/opensips/modules/]
Jul 12 09:26:07 [17262] DBG:core:find_cmd_export_t: found <t_relay>(0) 
in module tm [//lib/opensips/modules/]
Jul 12 09:26:07 [17262] DBG:core:find_cmd_export_t: found 
<t_check_trans>(0) in module tm [//lib/opensips/modules/]
Jul 12 09:26:07 [17262] DBG:core:find_cmd_export_t: found 
<loose_route>(0) in module rr [//lib/opensips/modules/]
Jul 12 09:26:07 [17262] DBG:core:find_cmd_export_t: found <xlog>(2) in 
module xlog [//lib/opensips/modules/]
Jul 12 09:26:07 [17262] DBG:core:find_cmd_export_t: found <is_method>(1) 
in module textops [//lib/opensips/modules/]
Jul 12 09:26:07 [17262] DBG:core:find_cmd_export_t: found 
<sl_send_reply>(2) in module sl [//lib/opensips/modules/]
Jul 12 09:26:07 [17262] DBG:core:find_cmd_export_t: found <is_method>(1) 
in module textops [//lib/opensips/modules/]
Jul 12 09:26:07 [17262] DBG:core:find_cmd_export_t: found 
<record_route>(0) in module rr [//lib/opensips/modules/]
Jul 12 09:26:07 [17262] DBG:core:find_cmd_export_t: found <is_method>(1) 
in module textops [//lib/opensips/modules/]
Jul 12 09:26:07 [17262] DBG:core:find_cmd_export_t: found <append_hf>(1) 
in module textops [//lib/opensips/modules/]
Jul 12 09:26:07 [17262] DBG:core:find_cmd_export_t: found <is_method>(1) 
in module textops [//lib/opensips/modules/]
Jul 12 09:26:07 [17262] DBG:core:find_cmd_export_t: found 
<sl_send_reply>(2) in module sl [//lib/opensips/modules/]
Jul 12 09:26:07 [17262] DBG:core:find_cmd_export_t: found <is_method>(1) 
in module textops [//lib/opensips/modules/]
Jul 12 09:26:07 [17262] DBG:core:find_cmd_export_t: found <save>(1) in 
module registrar [//lib/opensips/modules/]
Jul 12 09:26:07 [17262] DBG:core:find_cmd_export_t: found 
<sl_reply_error>(0) in module sl [//lib/opensips/modules/]
Jul 12 09:26:07 [17262] DBG:core:find_cmd_export_t: found 
<sl_send_reply>(2) in module sl [//lib/opensips/modules/]
Jul 12 09:26:07 [17262] DBG:core:find_cmd_export_t: found <lookup>(1) in 
module registrar [//lib/opensips/modules/]
Jul 12 09:26:07 [17262] DBG:core:find_cmd_export_t: found <t_newtran>(0) 
in module tm [//lib/opensips/modules/]
Jul 12 09:26:07 [17262] DBG:core:find_cmd_export_t: found <t_reply>(2) 
in module tm [//lib/opensips/modules/]
Jul 12 09:26:07 [17262] DBG:core:find_cmd_export_t: found 
<sl_send_reply>(2) in module sl [//lib/opensips/modules/]
Jul 12 09:26:07 [17262] DBG:core:find_cmd_export_t: found <is_method>(1) 
in module textops [//lib/opensips/modules/]
Jul 12 09:26:07 [17262] DBG:core:find_cmd_export_t: found 
<t_on_branch>(1) in module tm [//lib/opensips/modules/]
Jul 12 09:26:07 [17262] DBG:core:find_cmd_export_t: found 
<t_on_reply>(1) in module tm [//lib/opensips/modules/]
Jul 12 09:26:07 [17262] DBG:core:find_cmd_export_t: found 
<t_on_failure>(1) in module tm [//lib/opensips/modules/]
Jul 12 09:26:07 [17262] DBG:core:find_cmd_export_t: found <t_relay>(0) 
in module tm [//lib/opensips/modules/]
Jul 12 09:26:07 [17262] DBG:core:find_cmd_export_t: found 
<sl_reply_error>(0) in module sl [//lib/opensips/modules/]
Jul 12 09:26:07 [17262] DBG:core:find_cmd_export_t: found <xlog>(1) in 
module xlog [//lib/opensips/modules/]
Jul 12 09:26:07 [17262] DBG:core:find_cmd_export_t: found <xlog>(1) in 
module xlog [//lib/opensips/modules/]
Jul 12 09:26:07 [17262] DBG:core:find_cmd_export_t: found 
<t_was_cancelled>(0) in module tm [//lib/opensips/modules/]
Jul 12 09:26:07 [17262] DBG:core:socket2str: <udp:192.168.10.22:5060>



Listening on
             udp: 192.168.10.22 [192.168.10.22]:5060
Aliases:

Jul 12 09:26:07 [17262] WARNING:core:main: no fork mode
Jul 12 09:26:07 [17262] DBG:core:fm_malloc_init: F_OPTIMIZE=16384, 
/ROUNDTO=2048
Jul 12 09:26:07 [17262] DBG:core:fm_malloc_init: F_HASH_SIZE=2067, 
fm_block size=16560
Jul 12 09:26:07 [17262] DBG:core:fm_malloc_init: params (0xb5f63000, 
33554432), start=0xb5f63000
Jul 12 09:26:07 [17262] DBG:core:shm_mem_init_mallocs: success
Jul 12 09:26:07 [17262] DBG:core:set_core_dump: core dump limits set to 
4294967295
Jul 12 09:26:07 [17262] NOTICE:core:main: version: opensips 1.5.1-notls 
(i386/linux)
Jul 12 09:26:07 [17262] INFO:core:main: using 32 Mb shared memory
Jul 12 09:26:07 [17262] INFO:core:main: using 1 Mb private memory per 
process
Jul 12 09:26:07 [17262] DBG:core:add_avp_galias: registering 
<serial_branch> for avp id <16725044>
Jul 12 09:26:07 [17262] DBG:core:init_stats_collector: statistics 
manager successfully initialized
Jul 12 09:26:07 [17262] DBG:core:init_mod: initializing module maxfwd
Jul 12 09:26:07 [17262] INFO:maxfwd:mod_init: initializing...
Jul 12 09:26:07 [17262] DBG:core:init_mod: initializing module sl
Jul 12 09:26:07 [17262] INFO:sl:mod_init: Initializing StateLess engine
Jul 12 09:26:07 [17262] DBG:core:MD5StringArray: MD5 calculated: 
cbf60515e4b4c510d0c3e50f8e40bfd7
Jul 12 09:26:07 [17262] DBG:core:init_mod: registering stats for sl
Jul 12 09:26:07 [17262] DBG:core:init_mod: initializing module db_mysql
Jul 12 09:26:07 [17262] DBG:db_mysql:mysql_mod_init: mysql: MySQL client 
version is 5.0.45
Jul 12 09:26:07 [17262] DBG:core:init_mod: initializing module tm
Jul 12 09:26:07 [17262] INFO:tm:mod_init: TM - initializing...
Jul 12 09:26:07 [17262] DBG:tm:init_callid: Call-ID initialization: 
'7b91fbe7'
Jul 12 09:26:07 [17262] DBG:tm:lock_initialize: lock initialization started
Jul 12 09:26:07 [17262] DBG:core:MD5StringArray: MD5 calculated: 
a53d9e054dbf216e7e3eb5c061c23488
Jul 12 09:26:07 [17262] DBG:core:MD5StringArray: MD5 calculated: 
9aca73a5eb3df44ceaa7d83a3ab9af2d
Jul 12 09:26:07 [17262] DBG:core:init_mod: registering stats for tm
Jul 12 09:26:07 [17262] DBG:core:init_mod: register MI for tm
Jul 12 09:26:07 [17262] DBG:core:init_mod: initializing module rr
Jul 12 09:26:07 [17262] DBG:rr:mod_init: rr - initializing
Jul 12 09:26:07 [17262] DBG:core:init_mod: initializing module xlog
Jul 12 09:26:07 [17262] INFO:xlog:mod_init: initializing...
Jul 12 09:26:07 [17262] DBG:core:init_mod: initializing module dialog
Jul 12 09:26:07 [17262] INFO:dialog:mod_init: Dialog module - initializing
Jul 12 09:26:07 [17262] DBG:core:find_cmd_export_t: found <load_tm>(0) 
in module tm [//lib/opensips/modules/]
Jul 12 09:26:07 [17262] DBG:core:find_cmd_export_t: found <load_rr>(0) 
in module rr [//lib/opensips/modules/]
Jul 12 09:26:07 [17262] DBG:core:find_mod_export: found <db_bind_api> in 
module db_mysql [//lib/opensips/modules/]
Jul 12 09:26:07 [17262] DBG:core:db_bind_mod: using db bind api for db_mysql
Jul 12 09:26:07 [17262] DBG:core:db_do_init: connection 0x81ad040 not 
found in pool
Jul 12 09:26:07 [17262] DBG:db_mysql:db_mysql_new_connection: opening 
connection: mysql://xxxx:xxxx@localhost/opensips
Jul 12 09:26:07 [17262] DBG:db_mysql:db_mysql_new_connection: connection 
type is Localhost via UNIX socket
Jul 12 09:26:07 [17262] DBG:db_mysql:db_mysql_new_connection: protocol 
version is 10
Jul 12 09:26:07 [17262] DBG:db_mysql:db_mysql_new_connection: server 
version is 5.0.45
Jul 12 09:26:07 [17262] ERROR:db_mysql:db_mysql_submit_query: driver 
error on query: SELECT command denied to user 'opensips'@'localhost' for 
table 'version'
Jul 12 09:26:07 [17262] ERROR:core:db_do_query: error while submitting query
Jul 12 09:26:07 [17262] ERROR:core:db_table_version: error in db_query
Jul 12 09:26:07 [17262] ERROR:core:db_check_table_version: querying 
version for table dialog
Jul 12 09:26:07 [17262] ERROR:dialog:init_dlg_db: error during table 
version check.
Jul 12 09:26:07 [17262] ERROR:dialog:mod_init: failed to initialize the 
DB support
Jul 12 09:26:07 [17262] ERROR:core:init_mod: failed to initialize module 
dialog
Jul 12 09:26:07 [17262] ERROR:core:main: error while initializing modules
Jul 12 09:26:07 [17262] DBG:xlog:destroy: destroy module...
Jul 12 09:26:07 [17262] DBG:tm:tm_shutdown: tm_shutdown : start
Jul 12 09:26:07 [17262] DBG:tm:unlink_timer_lists: emptying DELETE list
Jul 12 09:26:07 [17262] DBG:tm:tm_shutdown: emptying hash table
Jul 12 09:26:07 [17262] DBG:tm:tm_shutdown: releasing timers
Jul 12 09:26:07 [17262] DBG:tm:tm_shutdown: removing semaphores
Jul 12 09:26:07 [17262] DBG:tm:tm_shutdown: destroying callback lists
Jul 12 09:26:07 [17262] DBG:tm:tm_shutdown: tm_shutdown : done
Jul 12 09:26:07 [17262] DBG:core:shm_mem_destroy:
Jul 12 09:26:07 [17262] DBG:core:shm_mem_destroy: destroying the shared 
memory lock

More information about the Users mailing list