14 Apr
2005
14 Apr
'05
12:35 p.m.
/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(a)teigre.com> wrote:
-------------------------------------------------------
__________________________________
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/
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(a)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(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers
15 Apr
15 Apr
6:49 a.m.
New subject: [Serusers] compiling mysql
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(a)teigre.com> wrote:
-------------------------------------------------------
__________________________________
Do you Yahoo!?
Yahoo! Small Business - Try our new resources site!
http://smallbusiness.yahoo.com/resources/
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(a)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(a)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/
10:40 a.m.
New subject: [Serusers] radius accounting failed
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/
7171
days inactive
7172
days old
2 comments
2 participants
participants (2)
-
Greger V. Teigre -
Kamran Ahmad