Did you use opensipsdbctl to create mysql user and tables? On Sunday, July 12, 2009, John S. Robinson <[email protected]> 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:x...@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 > [email protected] > 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/ _______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
