hello
I installed kamailio, and want to use mysql auth,loaded the mysql module, uncomented the lines needed to use mysql in the .cfg file I ran the openser_mysql.sh script, and when I try to started kamailio and this is what I see in the console:
[root@sp1094a sbin]# ./openser_mysql.sh create MySql password for root: Domain (realm) for the default user 'admin': 65.111.185.187
creating database openser ... Install SERWEB tables ?(y/n):n # I tried with and w/o the servweb tables [root@sp1094a sbin]# ./kamctl start database engine 'MYSQL' loaded Control engine 'FIFO' loaded
INFO: Starting Kamailio :
ERROR: PID file /var/run/kamailio.pid does not exist -- Kamailio start failed
in the var/log/message file this is what I see:
Oct 14 21:09:12 sp1094a ./kamailio[29249]: NOTICE:core:main: version: kamailio 1.4.1-notls (i386/linux) Oct 14 21:09:12 sp1094a ./kamailio[29249]: INFO:core:main: using 32 Mb shared memory Oct 14 21:09:12 sp1094a ./kamailio[29249]: INFO:core:main: using 1 Mb private memory per process Oct 14 21:09:12 sp1094a ./kamailio[29249]: INFO:sl:mod_init: Initializing StateLess engine Oct 14 21:09:12 sp1094a ./kamailio[29249]: INFO:tm:mod_init: TM - initializing... Oct 14 21:09:12 sp1094a ./kamailio[29249]: INFO:maxfwd:mod_init: initializing... Oct 14 21:09:12 sp1094a ./kamailio[29249]: INFO:usrloc:ul_init_locks: locks array size 512 Oct 14 21:09:12 sp1094a ./kamailio[29249]: INFO:registrar:mod_init: initializing... Oct 14 21:09:12 sp1094a ./kamailio[29249]: INFO:textops:mod_init: initializing... Oct 14 21:09:12 sp1094a ./kamailio[29249]: INFO:xlog:mod_init: initializing... Oct 14 21:09:12 sp1094a ./kamailio[29249]: INFO:acc:mod_init: initializing... Oct 14 21:09:12 sp1094a ./kamailio[29249]: INFO:auth:mod_init: initializing... Oct 14 21:09:12 sp1094a ./kamailio[29249]: INFO:auth_db:mod_init: initializing... Oct 14 21:09:12 sp1094a ./kamailio[29249]: INFO:core:probe_max_receive_buffer: using a UDP receive buffer of 210 kb Oct 14 21:09:12 sp1094a ./kamailio[29253]: ERROR:db_mysql:db_mysql_submit_query: driver error on query: Unknown column 'cflags' in 'field list' Oct 14 21:09:12 sp1094a ./kamailio[29253]: ERROR:core:db_do_query: error while submitting query Oct 14 21:09:12 sp1094a ./kamailio[29253]: ERROR:usrloc:preload_udomain: db_query (1) failed Oct 14 21:09:12 sp1094a ./kamailio[29253]: ERROR:usrloc:child_init: child(1): failed to preload domain 'location' Oct 14 21:09:12 sp1094a ./kamailio[29253]: ERROR:core:init_mod_child: failed to initializing module usrloc, rank 1 Oct 14 21:09:12 sp1094a ./kamailio[29253]: ERROR:core:main_loop: init_child failed for UDP listener Oct 14 21:09:12 sp1094a ./kamailio[29249]: INFO:core:handle_sigs: child process 29253 exited normally, status=255 Oct 14 21:09:12 sp1094a ./kamailio[29249]: INFO:core:handle_sigs: terminating due to SIGCHLD Oct 14 21:09:12 sp1094a ./kamailio[29264]: INFO:core:sig_usr: signal 15 received Oct 14 21:09:12 sp1094a ./kamailio[29261]: INFO:core:sig_usr: signal 15 received Oct 14 21:09:12 sp1094a ./kamailio[29259]: INFO:core:sig_usr: signal 15 received Oct 14 21:09:12 sp1094a ./kamailio[29257]: INFO:core:sig_usr: signal 15 received Oct 14 21:09:12 sp1094a ./kamailio[29255]: INFO:core:sig_usr: signal 15 received
what can that be?
txs
Fabian
<html><DIV> <DIV> </DIV></DIV></html> _________________________________________________________________ Get more out of the Web. Learn 10 hidden secrets of Windows Live. http://windowslive.com/connect/post/jamiethomson.spaces.live.com-Blog-cns!55...
Do not run openser_mysql.sh! How did you get that exacutable installed? The right tool for creating tables in the db is kamdbctl.
Anyway, the fact that is segv-ing is bad. Can you get a backtrace using gdb?
Regards, Ovidiu Sas
On Tue, Oct 14, 2008 at 8:48 PM, Fabian Borot fborot@hotmail.com wrote:
hello
I installed kamailio, and want to use mysql auth,loaded the mysql module, uncomented the lines needed to use mysql in the .cfg file I ran the openser_mysql.sh script, and when I try to started kamailio and this is what I see in the console:
[root@sp1094a sbin]# ./openser_mysql.sh create MySql password for root: Domain (realm) for the default user 'admin': 65.111.185.187
creating database openser ... Install SERWEB tables ?(y/n):n # I tried with and w/o the servweb tables [root@sp1094a sbin]# ./kamctl start database engine 'MYSQL' loaded Control engine 'FIFO' loaded
INFO: Starting Kamailio :
ERROR: PID file /var/run/kamailio.pid does not exist -- Kamailio start failed
in the var/log/message file this is what I see:
Oct 14 21:09:12 sp1094a ./kamailio[29249]: NOTICE:core:main: version: kamailio 1.4.1-notls (i386/linux) Oct 14 21:09:12 sp1094a ./kamailio[29249]: INFO:core:main: using 32 Mb shared memory Oct 14 21:09:12 sp1094a ./kamailio[29249]: INFO:core:main: using 1 Mb private memory per process Oct 14 21:09:12 sp1094a ./kamailio[29249]: INFO:sl:mod_init: Initializing StateLess engine Oct 14 21:09:12 sp1094a ./kamailio[29249]: INFO:tm:mod_init: TM - initializing... Oct 14 21:09:12 sp1094a ./kamailio[29249]: INFO:maxfwd:mod_init: initializing... Oct 14 21:09:12 sp1094a ./kamailio[29249]: INFO:usrloc:ul_init_locks: locks array size 512 Oct 14 21:09:12 sp1094a ./kamailio[29249]: INFO:registrar:mod_init: initializing... Oct 14 21:09:12 sp1094a ./kamailio[29249]: INFO:textops:mod_init: initializing... Oct 14 21:09:12 sp1094a ./kamailio[29249]: INFO:xlog:mod_init: initializing... Oct 14 21:09:12 sp1094a ./kamailio[29249]: INFO:acc:mod_init: initializing... Oct 14 21:09:12 sp1094a ./kamailio[29249]: INFO:auth:mod_init: initializing... Oct 14 21:09:12 sp1094a ./kamailio[29249]: INFO:auth_db:mod_init: initializing... Oct 14 21:09:12 sp1094a ./kamailio[29249]: INFO:core:probe_max_receive_buffer: using a UDP receive buffer of 210 kb Oct 14 21:09:12 sp1094a ./kamailio[29253]: ERROR:db_mysql:db_mysql_submit_query: driver error on query: Unknown column 'cflags' in 'field list' Oct 14 21:09:12 sp1094a ./kamailio[29253]: ERROR:core:db_do_query: error while submitting query Oct 14 21:09:12 sp1094a ./kamailio[29253]: ERROR:usrloc:preload_udomain: db_query (1) failed Oct 14 21:09:12 sp1094a ./kamailio[29253]: ERROR:usrloc:child_init: child(1): failed to preload domain 'location' Oct 14 21:09:12 sp1094a ./kamailio[29253]: ERROR:core:init_mod_child: failed to initializing module usrloc, rank 1 Oct 14 21:09:12 sp1094a ./kamailio[29253]: ERROR:core:main_loop: init_child failed for UDP listener Oct 14 21:09:12 sp1094a ./kamailio[29249]: INFO:core:handle_sigs: child process 29253 exited normally, status=255 Oct 14 21:09:12 sp1094a ./kamailio[29249]: INFO:core:handle_sigs: terminating due to SIGCHLD Oct 14 21:09:12 sp1094a ./kamailio[29264]: INFO:core:sig_usr: signal 15 received Oct 14 21:09:12 sp1094a ./kamailio[29261]: INFO:core:sig_usr: signal 15 received Oct 14 21:09:12 sp1094a ./kamailio[29259]: INFO:core:sig_usr: signal 15 received Oct 14 21:09:12 sp1094a ./kamailio[29257]: INFO:core:sig_usr: signal 15 received Oct 14 21:09:12 sp1094a ./kamailio[29255]: INFO:core:sig_usr: signal 15 received
what can that be?
txs
Fabian
<html><DIV> <DIV> </DIV></DIV></html> ________________________________ Get more out of the Web. Learn 10 hidden secrets of Windows Live. Learn Now _______________________________________________ Users mailing list Users@lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
txs a lot, it it starts now using the kamdbctl, I did not know about that tool, all the tutorials that I see are for openser and they use the opener_mysql.sh script, I asked for it to a friend of mine who installed openser several months ago [before kamailio was created] and tweaked it to be able to use it [paths, some values live version 6, 1004 etc]
again thank you for the prompt reply
Fabian
<html><DIV> <DIV> </DIV></DIV></html>
Date: Tue, 14 Oct 2008 21:09:44 -0400 From: osas@voipembedded.com To: fborot@hotmail.com Subject: Re: [Kamailio-Users] problem starting kamailio CC: users@lists.kamailio.org
Do not run openser_mysql.sh! How did you get that exacutable installed? The right tool for creating tables in the db is kamdbctl.
Anyway, the fact that is segv-ing is bad. Can you get a backtrace using gdb?
Regards, Ovidiu Sas
On Tue, Oct 14, 2008 at 8:48 PM, Fabian Borot fborot@hotmail.com wrote:
hello
I installed kamailio, and want to use mysql auth,loaded the mysql module, uncomented the lines needed to use mysql in the .cfg file I ran the openser_mysql.sh script, and when I try to started kamailio and this is what I see in the console:
[root@sp1094a sbin]# ./openser_mysql.sh create MySql password for root: Domain (realm) for the default user 'admin': 65.111.185.187
creating database openser ... Install SERWEB tables ?(y/n):n # I tried with and w/o the servweb tables [root@sp1094a sbin]# ./kamctl start database engine 'MYSQL' loaded Control engine 'FIFO' loaded
INFO: Starting Kamailio :
ERROR: PID file /var/run/kamailio.pid does not exist -- Kamailio start failed
in the var/log/message file this is what I see:
Oct 14 21:09:12 sp1094a ./kamailio[29249]: NOTICE:core:main: version: kamailio 1.4.1-notls (i386/linux) Oct 14 21:09:12 sp1094a ./kamailio[29249]: INFO:core:main: using 32 Mb shared memory Oct 14 21:09:12 sp1094a ./kamailio[29249]: INFO:core:main: using 1 Mb private memory per process Oct 14 21:09:12 sp1094a ./kamailio[29249]: INFO:sl:mod_init: Initializing StateLess engine Oct 14 21:09:12 sp1094a ./kamailio[29249]: INFO:tm:mod_init: TM - initializing... Oct 14 21:09:12 sp1094a ./kamailio[29249]: INFO:maxfwd:mod_init: initializing... Oct 14 21:09:12 sp1094a ./kamailio[29249]: INFO:usrloc:ul_init_locks: locks array size 512 Oct 14 21:09:12 sp1094a ./kamailio[29249]: INFO:registrar:mod_init: initializing... Oct 14 21:09:12 sp1094a ./kamailio[29249]: INFO:textops:mod_init: initializing... Oct 14 21:09:12 sp1094a ./kamailio[29249]: INFO:xlog:mod_init: initializing... Oct 14 21:09:12 sp1094a ./kamailio[29249]: INFO:acc:mod_init: initializing... Oct 14 21:09:12 sp1094a ./kamailio[29249]: INFO:auth:mod_init: initializing... Oct 14 21:09:12 sp1094a ./kamailio[29249]: INFO:auth_db:mod_init: initializing... Oct 14 21:09:12 sp1094a ./kamailio[29249]: INFO:core:probe_max_receive_buffer: using a UDP receive buffer of 210 kb Oct 14 21:09:12 sp1094a ./kamailio[29253]: ERROR:db_mysql:db_mysql_submit_query: driver error on query: Unknown column 'cflags' in 'field list' Oct 14 21:09:12 sp1094a ./kamailio[29253]: ERROR:core:db_do_query: error while submitting query Oct 14 21:09:12 sp1094a ./kamailio[29253]: ERROR:usrloc:preload_udomain: db_query (1) failed Oct 14 21:09:12 sp1094a ./kamailio[29253]: ERROR:usrloc:child_init: child(1): failed to preload domain 'location' Oct 14 21:09:12 sp1094a ./kamailio[29253]: ERROR:core:init_mod_child: failed to initializing module usrloc, rank 1 Oct 14 21:09:12 sp1094a ./kamailio[29253]: ERROR:core:main_loop: init_child failed for UDP listener Oct 14 21:09:12 sp1094a ./kamailio[29249]: INFO:core:handle_sigs: child process 29253 exited normally, status=255 Oct 14 21:09:12 sp1094a ./kamailio[29249]: INFO:core:handle_sigs: terminating due to SIGCHLD Oct 14 21:09:12 sp1094a ./kamailio[29264]: INFO:core:sig_usr: signal 15 received Oct 14 21:09:12 sp1094a ./kamailio[29261]: INFO:core:sig_usr: signal 15 received Oct 14 21:09:12 sp1094a ./kamailio[29259]: INFO:core:sig_usr: signal 15 received Oct 14 21:09:12 sp1094a ./kamailio[29257]: INFO:core:sig_usr: signal 15 received Oct 14 21:09:12 sp1094a ./kamailio[29255]: INFO:core:sig_usr: signal 15 received
what can that be?
txs
Fabian
<html><DIV> <DIV> </DIV></DIV></html> ________________________________ Get more out of the Web. Learn 10 hidden secrets of Windows Live. Learn Now _______________________________________________ Users mailing list Users@lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
_________________________________________________________________ See how Windows Mobile brings your life together—at home, work, or on the go. http://clk.atdmt.com/MRT/go/msnnkwxp1020093182mrt/direct/01/
-
Fabian Borot -
Ovidiu Sas