[OpenSIPS-Users] Problem Getting started with Load Balancing

[Saúl Ibarra]

Did you use opensipsdbctl to create mysql user and tables?

On Sunday, July 12, 2009, John S. Robinson <js.robinson at comcast.net> wrote:
> 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
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>

-- 
Saúl -- "Nunca subestimes el ancho de banda de un camión lleno de disketes."
----------------------------------------------------------------
http://www.saghul.net/