/etc/my.cnf [mysqld] datadir=/var/lib/mysql socket=/tmp/mysql.sock
[mysql.server] user=mysql ;basedir=/var/lib basedir=/usr/local/mysql
[safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid
but it is still looking '/var/lib/mysql/mysql.sock'
textops - initializing 0(0) DEBUG: init_mod: uri_db 0(0) uri_db - initializing 0(0) find_mod_export: found <db_use_table> in module mysql [/usr/local/lib/ser/modules/mysql.so] 0(0) find_mod_export: found <db_init> in module mysql [/usr/local/lib/ser/modules/mysql.so] 0(0) find_mod_export: found <db_close> in module mysql [/usr/local/lib/ser/modules/mysql.so] 0(0) find_mod_export: found <db_query> in module mysql [/usr/local/lib/ser/modules/mysql.so] 0(0) find_mod_export: found <db_raw_query> in module mysql [/usr/local/lib/ser/modules/mysql.so] 0(0) find_mod_export: found <db_free_result> in module mysql [/usr/local/lib/ser/modules/mysql.so] 0(0) find_mod_export: found <db_insert> in module mysql [/usr/local/lib/ser/modules/mysql.so] 0(0) find_mod_export: found <db_delete> in module mysql [/usr/local/lib/ser/modules/mysql.so] 0(0) find_mod_export: found <db_update> in module mysql [/usr/local/lib/ser/modules/mysql.so] 0(0) get_connection(): Connection not found in the pool 0(0) new_connection(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) 0(0) db_init(): Could not create a connection 0(0) ERROR: uridb_db_ver: unable to open database connection 0(0) ERROR: uri_db:mod_init(): Error while querying table version 0(0) init_mod(): Error while initializing module uri_db ERROR: error while initializing modules 0(0) XLOG: destroy module ... 0(0) DEBUG: tm_shutdown : start 0(0) DEBUG: unlink_timer_lists : emptying DELETE list 0(0) DEBUG: tm_shutdown : emptying hash table 0(0) DEBUG: tm_shutdown : releasing timers 0(0) DEBUG: tm_shutdown : removing semaphores 0(0) DEBUG: tm_shutdown : destroying tmcb lists 0(0) DEBUG: tm_shutdown : done 0(5133) shm_mem_destroy 0(5133) destroying the shared memory lock -..............................................
--- "Greger V. Teigre" greger@teigre.com wrote:
You define the mysql socket in /etc/my.cnf g-) Kamran Ahmad wrote:
when i am starting ser it is not working. how to
set
mysql socket to /tmp/mysql.sock
/var/log/messages
------------------------------------------------------
Apr 14 05:13:47 achieva ser: WARNING:
fix_socket_list:
could not rev. resolve 202.42.132.133 Apr 14 05:13:57 achieva ser: WARNING:
fix_socket_list:
could not rev. resolve 202.42.132.133 Apr 14 05:13:57 achieva ser[16717]: Maxfwd module- initializing Apr 14 05:13:57 achieva ser[16717]:
new_connection():
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) Apr 14 05:13:57 achieva ser[16717]: db_init():
Could
not create a connection Apr 14 05:13:57 achieva ser[16717]: ERROR: uridb_db_ver: unable to open database connection Apr 14 05:13:57 achieva ser[16717]: ERROR: uri_db:mod_init(): Error while querying table
version
Apr 14 05:13:57 achieva ser[16717]: init_mod():
Error
while initializing module uri_db Apr 14 05:14:22 achieva cups: cupsd shutdown
succeeded
Apr 14 05:14:25 achieva cups: cupsd startup
succeeded
Apr 14 05:14:25 achieva logrotate: ALERT exited abnormally with [1]
-------------------------------------------------------
--- "Greger V. Teigre" greger@teigre.com wrote:
Kamran, The make_and_install script saves all output to make_and_install_output.txt in the source root directory. Search for errors
in
that file (or mysql) and you will see what happened. If you don't get a mysql.so at all, most
likely
you have not installed the mysql-devel package (so mysql header file is missing). g-) Kamran Ahmad wrote:
hello
while i am trying to compile mysql module for
ser but
it is not working. i am using ser-0.9.0.
I HAVE TRIED ./make_and_install sql but unable to compile mysql and i also used changed Makefile then make; make install but still unable to compile mysql.so
any one gone through this.
Kamran
Do you Yahoo!? Yahoo! Small Business - Try our new resources
site!
http://smallbusiness.yahoo.com/resources/
Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
Do you Yahoo!? Yahoo! Small Business - Try our new resources
site!
__________________________________ Do you Yahoo!? Yahoo! Small Business - Try our new resources site! http://smallbusiness.yahoo.com/resources/
I was more thinking of changing /etc/my.cnf to '/var/lib/mysql/mysql.sock'. AFAIK, /tmp/mysql.sock was the old location of the socket. The /tmp directory is no place for a socket... g-)
Kamran Ahmad wrote:
/etc/my.cnf [mysqld] datadir=/var/lib/mysql socket=/tmp/mysql.sock
[mysql.server] user=mysql ;basedir=/var/lib basedir=/usr/local/mysql
[safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid
but it is still looking '/var/lib/mysql/mysql.sock'
textops - initializing 0(0) DEBUG: init_mod: uri_db 0(0) uri_db - initializing 0(0) find_mod_export: found <db_use_table> in module mysql [/usr/local/lib/ser/modules/mysql.so] 0(0) find_mod_export: found <db_init> in module mysql [/usr/local/lib/ser/modules/mysql.so] 0(0) find_mod_export: found <db_close> in module mysql [/usr/local/lib/ser/modules/mysql.so] 0(0) find_mod_export: found <db_query> in module mysql [/usr/local/lib/ser/modules/mysql.so] 0(0) find_mod_export: found <db_raw_query> in module mysql [/usr/local/lib/ser/modules/mysql.so] 0(0) find_mod_export: found <db_free_result> in module mysql [/usr/local/lib/ser/modules/mysql.so] 0(0) find_mod_export: found <db_insert> in module mysql [/usr/local/lib/ser/modules/mysql.so] 0(0) find_mod_export: found <db_delete> in module mysql [/usr/local/lib/ser/modules/mysql.so] 0(0) find_mod_export: found <db_update> in module mysql [/usr/local/lib/ser/modules/mysql.so] 0(0) get_connection(): Connection not found in the pool 0(0) new_connection(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) 0(0) db_init(): Could not create a connection 0(0) ERROR: uridb_db_ver: unable to open database connection 0(0) ERROR: uri_db:mod_init(): Error while querying table version 0(0) init_mod(): Error while initializing module uri_db ERROR: error while initializing modules 0(0) XLOG: destroy module ... 0(0) DEBUG: tm_shutdown : start 0(0) DEBUG: unlink_timer_lists : emptying DELETE list 0(0) DEBUG: tm_shutdown : emptying hash table 0(0) DEBUG: tm_shutdown : releasing timers 0(0) DEBUG: tm_shutdown : removing semaphores 0(0) DEBUG: tm_shutdown : destroying tmcb lists 0(0) DEBUG: tm_shutdown : done 0(5133) shm_mem_destroy 0(5133) destroying the shared memory lock -..............................................
--- "Greger V. Teigre" greger@teigre.com wrote:
You define the mysql socket in /etc/my.cnf g-) Kamran Ahmad wrote:
when i am starting ser it is not working. how to set mysql socket to /tmp/mysql.sock
/var/log/messages
Apr 14 05:13:47 achieva ser: WARNING: fix_socket_list: could not rev. resolve 202.42.132.133 Apr 14 05:13:57 achieva ser: WARNING: fix_socket_list: could not rev. resolve 202.42.132.133 Apr 14 05:13:57 achieva ser[16717]: Maxfwd module- initializing Apr 14 05:13:57 achieva ser[16717]: new_connection(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) Apr 14 05:13:57 achieva ser[16717]: db_init(): Could not create a connection Apr 14 05:13:57 achieva ser[16717]: ERROR: uridb_db_ver: unable to open database connection Apr 14 05:13:57 achieva ser[16717]: ERROR: uri_db:mod_init(): Error while querying table version Apr 14 05:13:57 achieva ser[16717]: init_mod(): Error while initializing module uri_db Apr 14 05:14:22 achieva cups: cupsd shutdown succeeded Apr 14 05:14:25 achieva cups: cupsd startup succeeded Apr 14 05:14:25 achieva logrotate: ALERT exited abnormally with [1]
--- "Greger V. Teigre" greger@teigre.com wrote:
Kamran, The make_and_install script saves all output to make_and_install_output.txt in the source root directory. Search for errors in that file (or mysql) and you will see what happened. If you don't get a mysql.so at all, most likely you have not installed the mysql-devel package (so mysql header file is missing). g-) Kamran Ahmad wrote:
hello
while i am trying to compile mysql module for ser but it is not working. i am using ser-0.9.0.
I HAVE TRIED ./make_and_install sql but unable to compile mysql and i also used changed Makefile then make; make install but still unable to compile mysql.so
any one gone through this.
Kamran
Do you Yahoo!? Yahoo! Small Business - Try our new resources site! http://smallbusiness.yahoo.com/resources/
Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
Do you Yahoo!? Yahoo! Small Business - Try our new resources site! http://smallbusiness.yahoo.com/resources/
Do you Yahoo!? Yahoo! Small Business - Try our new resources site! http://smallbusiness.yahoo.com/resources/
hello
i am getting radius accounting Failed two times. like
Fri Apr 15 04:04:28 2005 Acct-Status-Type = Failed Service-Type = Sip-Session Fri Apr 15 04:04:36 2005 Acct-Status-Type = Start Fri Apr 15 04:04:36 2005 Acct-Status-Type = Start Service-Type = Sip-Session Fri Apr 15 04:07:56 2005 Acct-Status-Type = Failed
ser.cfg ----------------------------
debug=3 fork=yes log_stderror=no
dns=no rev_dns=no fifo="/tmp/ser_fifo"
#fifo_db_url="mysql://ser:heslo@localhost/ser"
loadmodule "/usr/local/lib/ser/modules/mysql.so" loadmodule "/usr/local/lib/ser/modules/sl.so" loadmodule "/usr/local/lib/ser/modules/tm.so" loadmodule "/usr/local/lib/ser/modules/rr.so" loadmodule "/usr/local/lib/ser/modules/maxfwd.so" loadmodule "/usr/local/lib/ser/modules/usrloc.so" loadmodule "/usr/local/lib/ser/modules/registrar.so" loadmodule "/usr/local/lib/ser/modules/xlog.so"
#radius configuration loadmodule "/usr/local/lib/ser/modules/auth.so" loadmodule "/usr/local/lib/ser/modules/auth_radius.so" loadmodule "/usr/local/lib/ser/modules/acc.so"
loadmodule "/usr/local/lib/ser/modules/exec.so"
loadmodule "/usr/local/lib/ser/modules/uri.so" #loadmodule "/usr/local/lib/ser/modules/domain.so" loadmodule "/usr/local/lib/ser/modules/nathelper.so" loadmodule "/usr/local/lib/ser/modules/textops.so" #loadmodule "/usr/local/lib/ser/modules/uri_db.so" #loadmodule "/usr/local/lib/ser/modules/uri_radius.so" #loadmodule "/usr/local/lib/ser/modules/auth_db.so"
#modparam("auth_db|uri_db|usrloc","db_url","mysql://ser:heslo@localhost/ser")
modparam("nathelper", "natping_interval", 30) modparam("nathelper", "ping_nated_only", 1) modparam("nathelper", "rtpproxy_sock","unix:/var/run/rtpproxy.sock") modparam("usrloc", "db_mode", 0) modparam("registrar", "nat_flag", 6) modparam("rr", "enable_full_lr", 1)
#radius config modparam("auth_radius","radius_config","/usr/local/etc/radiusclient/radiusclient.conf") modparam("auth_radius","service_type",15)
modparam("acc","radius_config","/usr/local/etc/radiusclient/radiusclient.conf") modparam("acc","log_level",1) modparam("acc", "radius_missed_flag", 2) modparam("acc","log_flag",1) modparam("acc","radius_flag",1) #radius config
route {
#----------------------------------------------------------------- # Sanity Check Section #-----------------------------------------------------------------
if (!mf_process_maxfwd_header("10")) { sl_send_reply("483", "Too Many Hops"); break; };
if (msg:len > max_len) { sl_send_reply("513", "Message Overflow"); break; };
#----------------------------------------------------------------- # Record Route Section #-----------------------------------------------------------------
if (method!="REGISTER") { record_route(); };
if (method=="BYE" || method=="CANCEL") { unforce_rtp_proxy(); }
#Stop radius accounting if (method=="BYE") { acc_rad_request("Stop"); }; #Stop radius accounting #----------------------------------------------------------------- # Loose Route Section #-----------------------------------------------------------------
if (loose_route()) {
if (has_totag() && method=="INVITE") { if (nat_uac_test("19")) { setflag(6); force_rport(); fix_nated_contact(); };
force_rtp_proxy("l"); }; route(1); break; }; #----------------------------------------------------------------- # Call Type Processing Section #----------------------------------------------------------------- if (uri==myself) { if (method=="INVITE") { route(3); break; } else if (method=="REGISTER") { route(2); break; };
if (!lookup("location")) { sl_send_reply("404", "User Not Found"); break; }; route(1); }; }
route[1] { #----------------------------------------------------------------- # Default Message Handler #----------------------------------------------------------------- t_on_reply("1"); if (!t_relay()) { if (method=="INVITE" && isflagset(6)) { unforce_rtp_proxy(); }; sl_reply_error(); }; }
route[2] { #----------------------------------------------------------------- # REGISTER Message Handler #---------------------------------------------------------------- if (!search("^Contact: *") && nat_uac_test("19")) { setflag(6); fix_nated_register(); # fix_nated_contact(); force_rport(); }; sl_send_reply("100", "Trying");
#radius config if (!radius_www_authorize("")) { www_challenge("","0"); break; }; exec_msg("cat >> /tmp/reg.log");
#end of radius config
if (!save("location")) { sl_reply_error(); }; }
route[3] { #----------------------------------------------------------------- # INVITE Message Handler #----------------------------------------------------------------- if (!radius_www_authorize("")) { www_challenge("","0"); break; };
if (nat_uac_test("19")) { setflag(6); }
if (uri=~"^sip:9[0-9]*@ser") { strip(1); rewritehostport("gwip:port"); #t_relay(); force_rport(); fix_nated_contact(); force_rtp_proxy();
t_relay();
#start accounting setflag(1); acc_rad_request("Start");
break; }
if (!lookup("location")) { sl_send_reply("404", "User Not Found"); break; };
#consume_credentials();
#call now start radius accounting setflag(1); acc_rad_request("Start");
#call start radius accounting if (isflagset(6)) {
force_rport(); # xlog("L_DBG","going for fixnated and forcertp%fu"); #log("hello"); fix_nated_contact(); force_rtp_proxy(); };
t_on_reply("1");
if (!t_relay()) {
if(isflagset(6)) { unforce_rtp_proxy(); }
sl_reply_error(); }; }
onreply_route[1] {
if (isflagset(6) && status=~"(180)|(183)|2[0-9][0-9]") {
fix_nated_contact();
if (!search("^Content-Length:\ 0")) { force_rtp_proxy(); }; } else if (nat_uac_test("1")) { fix_nated_contact(); }; }
__________________________________ Do you Yahoo!? Yahoo! Small Business - Try our new resources site! http://smallbusiness.yahoo.com/resources/
-
Greger V. Teigre -
Kamran Ahmad