[Devel] Trying Oracle module - debug mode output

Juan Carlos Castro y Castro jcastro at instant.com.br
Tue Oct 11 21:23:30 CEST 2005


The two lines below intrigue me:
----------------------------------------------------------------------
 0(0) db_query
 0(0) select table_version from version where table_name=:a
----------------------------------------------------------------------


[root at asterisk1 openser-0.9.5]# openser
 0(10018) loading module /usr/local/openser/lib/openser/modules/oracle.so
 0(10018) loading module /usr/local/openser/lib/openser/modules/sl.so
 0(10018) loading module /usr/local/openser/lib/openser/modules/tm.so
 0(10018) loading module /usr/local/openser/lib/openser/modules/rr.so
 0(10018) loading module /usr/local/openser/lib/openser/modules/maxfwd.so
 0(10018) loading module /usr/local/openser/lib/openser/modules/usrloc.so
 0(10018) loading module /usr/local/openser/lib/openser/modules/registrar.so
 0(10018) loading module /usr/local/openser/lib/openser/modules/textops.so
 0(10018) loading module /usr/local/openser/lib/openser/modules/exec.so
 0(10018) loading module /usr/local/openser/lib/openser/modules/auth.so
 0(10018) loading module /usr/local/openser/lib/openser/modules/auth_db.so
 0(10018) set_mod_param_regex: usrloc matches module usrloc
 0(10018) set_mod_param_regex: found <db_url> in module usrloc 
[/usr/local/openser/lib/openser/modules/usrloc.so]
 0(10018) set_mod_param_regex: auth_db matches module auth_db
 0(10018) set_mod_param_regex: found <db_url> in module auth_db 
[/usr/local/openser/lib/openser/modules/auth_db.so]
 0(10018) set_mod_param_regex: usrloc matches module usrloc
 0(10018) set_mod_param_regex: found <db_mode> in module usrloc 
[/usr/local/openser/lib/openser/modules/usrloc.so]
 0(10018) set_mod_param_regex: auth_db matches module auth_db
 0(10018) set_mod_param_regex: found <calculate_ha1> in module auth_db 
[/usr/local/openser/lib/openser/modules/auth_db.so]
 0(10018) set_mod_param_regex: auth_db matches module auth_db
 0(10018) set_mod_param_regex: found <calculate_ha1> in module auth_db 
[/usr/local/openser/lib/openser/modules/auth_db.so]
 0(10018) set_mod_param_regex: auth_db matches module auth_db
 0(10018) set_mod_param_regex: found <password_column> in module auth_db 
[/usr/local/openser/lib/openser/modules/auth_db.so]
 0(10018) set_mod_param_regex: auth_db matches module auth_db
 0(10018) set_mod_param_regex: found <user_column> in module auth_db 
[/usr/local/openser/lib/openser/modules/auth_db.so]
 0(10018) set_mod_param_regex: auth_db matches module auth_db
 0(10018) set_mod_param_regex: found <domain_column> in module auth_db 
[/usr/local/openser/lib/openser/modules/auth_db.so]
 0(10018) set_mod_param_regex: rr matches module rr
 0(10018) set_mod_param_regex: found <enable_full_lr> in module rr 
[/usr/local/openser/lib/openser/modules/rr.so]
 0(10018) find_export: found <mf_process_maxfwd_header> in module maxfwd 
[/usr/local/openser/lib/openser/modules/maxfwd.so]
 0(10018) find_export: found <sl_send_reply> in module sl_module 
[/usr/local/openser/lib/openser/modules/sl.so]
 0(10018) find_export: found <sl_send_reply> in module sl_module 
[/usr/local/openser/lib/openser/modules/sl.so]
 0(10018) find_export: found <record_route> in module rr 
[/usr/local/openser/lib/openser/modules/rr.so]
 0(10018) find_export: found <loose_route> in module rr 
[/usr/local/openser/lib/openser/modules/rr.so]
 0(10018) find_export: found <append_hf> in module textops 
[/usr/local/openser/lib/openser/modules/textops.so]
 0(10018) find_export: found <append_hf> in module textops 
[/usr/local/openser/lib/openser/modules/textops.so]
 0(10018) find_export: found <www_authorize> in module auth_db 
[/usr/local/openser/lib/openser/modules/auth_db.so]
 0(10018) find_export: found <www_challenge> in module auth 
[/usr/local/openser/lib/openser/modules/auth.so]
 0(10018) find_export: found <save> in module registrar 
[/usr/local/openser/lib/openser/modules/registrar.so]
 0(10018) find_export: found <lookup> in module registrar 
[/usr/local/openser/lib/openser/modules/registrar.so]
 0(10018) find_export: found <append_hf> in module textops 
[/usr/local/openser/lib/openser/modules/textops.so]
 0(10018) find_export: found <lookup> in module registrar 
[/usr/local/openser/lib/openser/modules/registrar.so]
 0(10018) find_export: found <sl_send_reply> in module sl_module 
[/usr/local/openser/lib/openser/modules/sl.so]
 0(10018) find_export: found <append_hf> in module textops 
[/usr/local/openser/lib/openser/modules/textops.so]
 0(10018) find_export: found <exec_dset> in module exec 
[/usr/local/openser/lib/openser/modules/exec.so]
 0(10018) find_export: found <t_relay> in module tm 
[/usr/local/openser/lib/openser/modules/tm.so]
 0(10018) find_export: found <sl_reply_error> in module sl_module 
[/usr/local/openser/lib/openser/modules/sl.so]
 0(10018) routing table 0:
 0(10018) if ( 0(10018) NOT(  0(10018)  external_module_call( 0(10018) 
f_ptr<0xf5feadb0> 0(10018) , "10" 0(10018) );  0(10018)  
external_module_call( 0(10018) f_ptr<0xf5feadb0> 0(10018) , "10" 
0(10018) );  0(10018)  ) 0(10018) ) { 0(10018)  external_module_call( 
0(10018) f_ptr<0xf603b790> 0(10018) , "483" 0(10018) , "Too Many Hops" 
0(10018) );  0(10018) drop( 0(10018) type<0> 0(10018) );  0(10018) } 
else { 0(10018) };  0(10018) if ( 0(10018) UNKNOWN 0(10018) <UNKNOWN> 
0(10018) 2048 0(10018) ) { 0(10018)  external_module_call( 0(10018) 
f_ptr<0xf603b790> 0(10018) , "513" 0(10018) , "Message too big" 0(10018) 
);  0(10018) drop( 0(10018) type<0> 0(10018) );  0(10018) } else { 
0(10018) };  0(10018) forward( 0(10018) 10.141.1.115 0(10018) , 6060 
0(10018) );  0(10018) drop( 0(10018) type<0> 0(10018) );  0(10018)  
external_module_call( 0(10018) f_ptr<0xf5ff0900> 0(10018) );  0(10018) 
if ( 0(10018)  external_module_call( 0(10018) f_ptr<0xf5feedd0> 0(10018) 
);  0(10018)  external_module_call( 0(10018) f_ptr<0xf5feedd0> 0(10018) 
);  0(10018) ) { 0(10018)  external_module_call( 0(10018) 
f_ptr<0xf5fcb6d0> 0(10018) , "P-hint: rr-enforced
" 0(10018) );  0(10018) route( 0(10018) 1 0(10018) );  0(10018) drop( 
0(10018) type<0> 0(10018) );  0(10018) } else { 0(10018) };  0(10018) if 
( 0(10018) NOT(  0(10018) uri 0(10018) == 0(10018) _myself_ 0(10018)  ) 
0(10018) ) { 0(10018)  external_module_call( 0(10018) f_ptr<0xf5fcb6d0> 
0(10018) , "P-hint: outbound
" 0(10018) );  0(10018) route( 0(10018) 1 0(10018) );  0(10018) drop( 
0(10018) type<0> 0(10018) );  0(10018) } else { 0(10018) };  0(10018) if 
( 0(10018) uri 0(10018) == 0(10018) _myself_ 0(10018) ) { 0(10018) if ( 
0(10018) method 0(10018) == 0(10018) "REGISTER" 0(10018) ) { 0(10018) if 
( 0(10018) NOT(  0(10018)  external_module_call( 0(10018) 
f_ptr<0xf5fb7780> 0(10018) , "asterisk1" 0(10018) , "subscriber" 
0(10018) );  0(10018)  external_module_call( 0(10018) f_ptr<0xf5fb7780> 
0(10018) , "asterisk1" 0(10018) , "subscriber" 0(10018) );  0(10018)  ) 
0(10018) ) { 0(10018)  external_module_call( 0(10018) f_ptr<0xf5fbdc90> 
0(10018) , "asterisk1" 0(10018) , "0" 0(10018) );  0(10018) drop( 
0(10018) type<0> 0(10018) );  0(10018) } else { 0(10018) };  0(10018)  
external_module_call( 0(10018) f_ptr<0xf5fd3770> 0(10018) , "location" 
0(10018) );  0(10018) drop( 0(10018) type<0> 0(10018) );  0(10018) } 
else { 0(10018) };  0(10018)  external_module_call( 0(10018) 
f_ptr<0xf5fcffa0> 0(10018) , "aliases" 0(10018) );  0(10018) if ( 
0(10018) NOT(  0(10018) uri 0(10018) == 0(10018) _myself_ 0(10018)  ) 
0(10018) ) { 0(10018)  external_module_call( 0(10018) f_ptr<0xf5fcb6d0> 
0(10018) , "P-hint: outbound alias
" 0(10018) );  0(10018) route( 0(10018) 1 0(10018) );  0(10018) drop( 
0(10018) type<0> 0(10018) );  0(10018) } else { 0(10018) };  0(10018) if 
( 0(10018) NOT(  0(10018)  external_module_call( 0(10018) 
f_ptr<0xf5fcffa0> 0(10018) , "location" 0(10018) );  0(10018)  
external_module_call( 0(10018) f_ptr<0xf5fcffa0> 0(10018) , "location" 
0(10018) );  0(10018)  ) 0(10018) ) { 0(10018)  external_module_call( 
0(10018) f_ptr<0xf603b790> 0(10018) , "404" 0(10018) , "Not Found" 
0(10018) );  0(10018) drop( 0(10018) type<0> 0(10018) );  0(10018) } 
else { 0(10018) };  0(10018) } else { 0(10018) };  0(10018)  
external_module_call( 0(10018) f_ptr<0xf5fcb6d0> 0(10018) , "P-hint: 
usrloc applied
" 0(10018) );  0(10018) route( 0(10018) 1 0(10018) );  0(10018) if ( 
0(10018) UNKNOWN 0(10018) <UNKNOWN> 0(10018) 2048 0(10018) ) { 0(10018)  
external_module_call( 0(10018) f_ptr<0xf603b790> 0(10018) , "513" 
0(10018) , "Message too big" 0(10018) );  0(10018) drop( 0(10018) 
type<0> 0(10018) );  0(10018) } else { 0(10018) };  0(10018) forward( 
0(10018) 10.141.1.115 0(10018) , 6060 0(10018) );  0(10018) drop( 
0(10018) type<0> 0(10018) );  0(10018)  external_module_call( 0(10018) 
f_ptr<0xf5ff0900> 0(10018) );  0(10018) if ( 0(10018)  
external_module_call( 0(10018) f_ptr<0xf5feedd0> 0(10018) );  0(10018)  
external_module_call( 0(10018) f_ptr<0xf5feedd0> 0(10018) );  0(10018) ) 
{ 0(10018)  external_module_call( 0(10018) f_ptr<0xf5fcb6d0> 0(10018) , 
"P-hint: rr-enforced
" 0(10018) );  0(10018) route( 0(10018) 1 0(10018) );  0(10018) drop( 
0(10018) type<0> 0(10018) );  0(10018) } else { 0(10018) };  0(10018) if 
( 0(10018) NOT(  0(10018) uri 0(10018) == 0(10018) _myself_ 0(10018)  ) 
0(10018) ) { 0(10018)  external_module_call( 0(10018) f_ptr<0xf5fcb6d0> 
0(10018) , "P-hint: outbound
" 0(10018) );  0(10018) route( 0(10018) 1 0(10018) );  0(10018) drop( 
0(10018) type<0> 0(10018) );  0(10018) } else { 0(10018) };  0(10018) if 
( 0(10018) uri 0(10018) == 0(10018) _myself_ 0(10018) ) { 0(10018) if ( 
0(10018) method 0(10018) == 0(10018) "REGISTER" 0(10018) ) { 0(10018) if 
( 0(10018) NOT(  0(10018)  external_module_call( 0(10018) 
f_ptr<0xf5fb7780> 0(10018) , "asterisk1" 0(10018) , "subscriber" 
0(10018) );  0(10018)  external_module_call( 0(10018) f_ptr<0xf5fb7780> 
0(10018) , "asterisk1" 0(10018) , "subscriber" 0(10018) );  0(10018)  ) 
0(10018) ) { 0(10018)  external_module_call( 0(10018) f_ptr<0xf5fbdc90> 
0(10018) , "asterisk1" 0(10018) , "0" 0(10018) );  0(10018) drop( 
0(10018) type<0> 0(10018) );  0(10018) } else { 0(10018) };  0(10018)  
external_module_call( 0(10018) f_ptr<0xf5fd3770> 0(10018) , "location" 
0(10018) );  0(10018) drop( 0(10018) type<0> 0(10018) );  0(10018) } 
else { 0(10018) };  0(10018)  external_module_call( 0(10018) 
f_ptr<0xf5fcffa0> 0(10018) , "aliases" 0(10018) );  0(10018) if ( 
0(10018) NOT(  0(10018) uri 0(10018) == 0(10018) _myself_ 0(10018)  ) 
0(10018) ) { 0(10018)  external_module_call( 0(10018) f_ptr<0xf5fcb6d0> 
0(10018) , "P-hint: outbound alias
" 0(10018) );  0(10018) route( 0(10018) 1 0(10018) );  0(10018) drop( 
0(10018) type<0> 0(10018) );  0(10018) } else { 0(10018) };  0(10018) if 
( 0(10018) NOT(  0(10018)  external_module_call( 0(10018) 
f_ptr<0xf5fcffa0> 0(10018) , "location" 0(10018) );  0(10018)  
external_module_call( 0(10018) f_ptr<0xf5fcffa0> 0(10018) , "location" 
0(10018) );  0(10018)  ) 0(10018) ) { 0(10018)  external_module_call( 
0(10018) f_ptr<0xf603b790> 0(10018) , "404" 0(10018) , "Not Found" 
0(10018) );  0(10018) drop( 0(10018) type<0> 0(10018) );  0(10018) } 
else { 0(10018) };  0(10018) } else { 0(10018) };  0(10018)  
external_module_call( 0(10018) f_ptr<0xf5fcb6d0> 0(10018) , "P-hint: 
usrloc applied
" 0(10018) );  0(10018) route( 0(10018) 1 0(10018) );  0(10018) forward( 
0(10018) 10.141.1.115 0(10018) , 6060 0(10018) );  0(10018) drop( 
0(10018) type<0> 0(10018) );  0(10018)  external_module_call( 0(10018) 
f_ptr<0xf5ff0900> 0(10018) );  0(10018) if ( 0(10018)  
external_module_call( 0(10018) f_ptr<0xf5feedd0> 0(10018) );  0(10018)  
external_module_call( 0(10018) f_ptr<0xf5feedd0> 0(10018) );  0(10018) ) 
{ 0(10018)  external_module_call( 0(10018) f_ptr<0xf5fcb6d0> 0(10018) , 
"P-hint: rr-enforced
" 0(10018) );  0(10018) route( 0(10018) 1 0(10018) );  0(10018) drop( 
0(10018) type<0> 0(10018) );  0(10018) } else { 0(10018) };  0(10018) if 
( 0(10018) NOT(  0(10018) uri 0(10018) == 0(10018) _myself_ 0(10018)  ) 
0(10018) ) { 0(10018)  external_module_call( 0(10018) f_ptr<0xf5fcb6d0> 
0(10018) , "P-hint: outbound
" 0(10018) );  0(10018) route( 0(10018) 1 0(10018) );  0(10018) drop( 
0(10018) type<0> 0(10018) );  0(10018) } else { 0(10018) };  0(10018) if 
( 0(10018) uri 0(10018) == 0(10018) _myself_ 0(10018) ) { 0(10018) if ( 
0(10018) method 0(10018) == 0(10018) "REGISTER" 0(10018) ) { 0(10018) if 
( 0(10018) NOT(  0(10018)  external_module_call( 0(10018) 
f_ptr<0xf5fb7780> 0(10018) , "asterisk1" 0(10018) , "subscriber" 
0(10018) );  0(10018)  external_module_call( 0(10018) f_ptr<0xf5fb7780> 
0(10018) , "asterisk1" 0(10018) , "subscriber" 0(10018) );  0(10018)  ) 
0(10018) ) { 0(10018)  external_module_call( 0(10018) f_ptr<0xf5fbdc90> 
0(10018) , "asterisk1" 0(10018) , "0" 0(10018) );  0(10018) drop( 
0(10018) type<0> 0(10018) );  0(10018) } else { 0(10018) };  0(10018)  
external_module_call( 0(10018) f_ptr<0xf5fd3770> 0(10018) , "location" 
0(10018) );  0(10018) drop( 0(10018) type<0> 0(10018) );  0(10018) } 
else { 0(10018) };  0(10018)  external_module_call( 0(10018) 
f_ptr<0xf5fcffa0> 0(10018) , "aliases" 0(10018) );  0(10018) if ( 
0(10018) NOT(  0(10018) uri 0(10018) == 0(10018) _myself_ 0(10018)  ) 
0(10018) ) { 0(10018)  external_module_call( 0(10018) f_ptr<0xf5fcb6d0> 
0(10018) , "P-hint: outbound alias
" 0(10018) );  0(10018) route( 0(10018) 1 0(10018) );  0(10018) drop( 
0(10018) type<0> 0(10018) );  0(10018) } else { 0(10018) };  0(10018) if 
( 0(10018) NOT(  0(10018)  external_module_call( 0(10018) 
f_ptr<0xf5fcffa0> 0(10018) , "location" 0(10018) );  0(10018)  
external_module_call( 0(10018) f_ptr<0xf5fcffa0> 0(10018) , "location" 
0(10018) );  0(10018)  ) 0(10018) ) { 0(10018)  external_module_call( 
0(10018) f_ptr<0xf603b790> 0(10018) , "404" 0(10018) , "Not Found" 
0(10018) );  0(10018) drop( 0(10018) type<0> 0(10018) );  0(10018) } 
else { 0(10018) };  0(10018) } else { 0(10018) };  0(10018)  
external_module_call( 0(10018) f_ptr<0xf5fcb6d0> 0(10018) , "P-hint: 
usrloc applied
" 0(10018) );  0(10018) route( 0(10018) 1 0(10018) );  0(10018) drop( 
0(10018) type<0> 0(10018) );  0(10018)  external_module_call( 0(10018) 
f_ptr<0xf5ff0900> 0(10018) );  0(10018) if ( 0(10018)  
external_module_call( 0(10018) f_ptr<0xf5feedd0> 0(10018) );  0(10018)  
external_module_call( 0(10018) f_ptr<0xf5feedd0> 0(10018) );  0(10018) ) 
{ 0(10018)  external_module_call( 0(10018) f_ptr<0xf5fcb6d0> 0(10018) , 
"P-hint: rr-enforced
" 0(10018) );  0(10018) route( 0(10018) 1 0(10018) );  0(10018) drop( 
0(10018) type<0> 0(10018) );  0(10018) } else { 0(10018) };  0(10018) if 
( 0(10018) NOT(  0(10018) uri 0(10018) == 0(10018) _myself_ 0(10018)  ) 
0(10018) ) { 0(10018)  external_module_call( 0(10018) f_ptr<0xf5fcb6d0> 
0(10018) , "P-hint: outbound
" 0(10018) );  0(10018) route( 0(10018) 1 0(10018) );  0(10018) drop( 
0(10018) type<0> 0(10018) );  0(10018) } else { 0(10018) };  0(10018) if 
( 0(10018) uri 0(10018) == 0(10018) _myself_ 0(10018) ) { 0(10018) if ( 
0(10018) method 0(10018) == 0(10018) "REGISTER" 0(10018) ) { 0(10018) if 
( 0(10018) NOT(  0(10018)  external_module_call( 0(10018) 
f_ptr<0xf5fb7780> 0(10018) , "asterisk1" 0(10018) , "subscriber" 
0(10018) );  0(10018)  external_module_call( 0(10018) f_ptr<0xf5fb7780> 
0(10018) , "asterisk1" 0(10018) , "subscriber" 0(10018) );  0(10018)  ) 
0(10018) ) { 0(10018)  external_module_call( 0(10018) f_ptr<0xf5fbdc90> 
0(10018) , "asterisk1" 0(10018) , "0" 0(10018) );  0(10018) drop( 
0(10018) type<0> 0(10018) );  0(10018) } else { 0(10018) };  0(10018)  
external_module_call( 0(10018) f_ptr<0xf5fd3770> 0(10018) , "location" 
0(10018) );  0(10018) drop( 0(10018) type<0> 0(10018) );  0(10018) } 
else { 0(10018) };  0(10018)  external_module_call( 0(10018) 
f_ptr<0xf5fcffa0> 0(10018) , "aliases" 0(10018) );  0(10018) if ( 
0(10018) NOT(  0(10018) uri 0(10018) == 0(10018) _myself_ 0(10018)  ) 
0(10018) ) { 0(10018)  external_module_call( 0(10018) f_ptr<0xf5fcb6d0> 
0(10018) , "P-hint: outbound alias
" 0(10018) );  0(10018) route( 0(10018) 1 0(10018) );  0(10018) drop( 
0(10018) type<0> 0(10018) );  0(10018) } else { 0(10018) };  0(10018) if 
( 0(10018) NOT(  0(10018)  external_module_call( 0(10018) 
f_ptr<0xf5fcffa0> 0(10018) , "location" 0(10018) );  0(10018)  
external_module_call( 0(10018) f_ptr<0xf5fcffa0> 0(10018) , "location" 
0(10018) );  0(10018)  ) 0(10018) ) { 0(10018)  external_module_call( 
0(10018) f_ptr<0xf603b790> 0(10018) , "404" 0(10018) , "Not Found" 
0(10018) );  0(10018) drop( 0(10018) type<0> 0(10018) );  0(10018) } 
else { 0(10018) };  0(10018) } else { 0(10018) };  0(10018)  
external_module_call( 0(10018) f_ptr<0xf5fcb6d0> 0(10018) , "P-hint: 
usrloc applied
" 0(10018) );  0(10018) route( 0(10018) 1 0(10018) );  0(10018)  
external_module_call( 0(10018) f_ptr<0xf5ff0900> 0(10018) );  0(10018) 
if ( 0(10018)  external_module_call( 0(10018) f_ptr<0xf5feedd0> 0(10018) 
);  0(10018)  external_module_call( 0(10018) f_ptr<0xf5feedd0> 0(10018) 
);  0(10018) ) { 0(10018)  external_module_call( 0(10018) 
f_ptr<0xf5fcb6d0> 0(10018) , "P-hint: rr-enforced
" 0(10018) );  0(10018) route( 0(10018) 1 0(10018) );  0(10018) drop( 
0(10018) type<0> 0(10018) );  0(10018) } else { 0(10018) };  0(10018) if 
( 0(10018) NOT(  0(10018) uri 0(10018) == 0(10018) _myself_ 0(10018)  ) 
0(10018) ) { 0(10018)  external_module_call( 0(10018) f_ptr<0xf5fcb6d0> 
0(10018) , "P-hint: outbound
" 0(10018) );  0(10018) route( 0(10018) 1 0(10018) );  0(10018) drop( 
0(10018) type<0> 0(10018) );  0(10018) } else { 0(10018) };  0(10018) if 
( 0(10018) uri 0(10018) == 0(10018) _myself_ 0(10018) ) { 0(10018) if ( 
0(10018) method 0(10018) == 0(10018) "REGISTER" 0(10018) ) { 0(10018) if 
( 0(10018) NOT(  0(10018)  external_module_call( 0(10018) 
f_ptr<0xf5fb7780> 0(10018) , "asterisk1" 0(10018) , "subscriber" 
0(10018) );  0(10018)  external_module_call( 0(10018) f_ptr<0xf5fb7780> 
0(10018) , "asterisk1" 0(10018) , "subscriber" 0(10018) );  0(10018)  ) 
0(10018) ) { 0(10018)  external_module_call( 0(10018) f_ptr<0xf5fbdc90> 
0(10018) , "asterisk1" 0(10018) , "0" 0(10018) );  0(10018) drop( 
0(10018) type<0> 0(10018) );  0(10018) } else { 0(10018) };  0(10018)  
external_module_call( 0(10018) f_ptr<0xf5fd3770> 0(10018) , "location" 
0(10018) );  0(10018) drop( 0(10018) type<0> 0(10018) );  0(10018) } 
else { 0(10018) };  0(10018)  external_module_call( 0(10018) 
f_ptr<0xf5fcffa0> 0(10018) , "aliases" 0(10018) );  0(10018) if ( 
0(10018) NOT(  0(10018) uri 0(10018) == 0(10018) _myself_ 0(10018)  ) 
0(10018) ) { 0(10018)  external_module_call( 0(10018) f_ptr<0xf5fcb6d0> 
0(10018) , "P-hint: outbound alias
" 0(10018) );  0(10018) route( 0(10018) 1 0(10018) );  0(10018) drop( 
0(10018) type<0> 0(10018) );  0(10018) } else { 0(10018) };  0(10018) if 
( 0(10018) NOT(  0(10018)  external_module_call( 0(10018) 
f_ptr<0xf5fcffa0> 0(10018) , "location" 0(10018) );  0(10018)  
external_module_call( 0(10018) f_ptr<0xf5fcffa0> 0(10018) , "location" 
0(10018) );  0(10018)  ) 0(10018) ) { 0(10018)  external_module_call( 
0(10018) f_ptr<0xf603b790> 0(10018) , "404" 0(10018) , "Not Found" 
0(10018) );  0(10018) drop( 0(10018) type<0> 0(10018) );  0(10018) } 
else { 0(10018) };  0(10018) } else { 0(10018) };  0(10018)  
external_module_call( 0(10018) f_ptr<0xf5fcb6d0> 0(10018) , "P-hint: 
usrloc applied
" 0(10018) );  0(10018) route( 0(10018) 1 0(10018) );  0(10018) if ( 
0(10018)  external_module_call( 0(10018) f_ptr<0xf5feedd0> 0(10018) );  
0(10018)  external_module_call( 0(10018) f_ptr<0xf5feedd0> 0(10018) );  
0(10018) ) { 0(10018)  external_module_call( 0(10018) f_ptr<0xf5fcb6d0> 
0(10018) , "P-hint: rr-enforced
" 0(10018) );  0(10018) route( 0(10018) 1 0(10018) );  0(10018) drop( 
0(10018) type<0> 0(10018) );  0(10018) } else { 0(10018) };  0(10018) if 
( 0(10018) NOT(  0(10018) uri 0(10018) == 0(10018) _myself_ 0(10018)  ) 
0(10018) ) { 0(10018)  external_module_call( 0(10018) f_ptr<0xf5fcb6d0> 
0(10018) , "P-hint: outbound
" 0(10018) );  0(10018) route( 0(10018) 1 0(10018) );  0(10018) drop( 
0(10018) type<0> 0(10018) );  0(10018) } else { 0(10018) };  0(10018) if 
( 0(10018) uri 0(10018) == 0(10018) _myself_ 0(10018) ) { 0(10018) if ( 
0(10018) method 0(10018) == 0(10018) "REGISTER" 0(10018) ) { 0(10018) if 
( 0(10018) NOT(  0(10018)  external_module_call( 0(10018) 
f_ptr<0xf5fb7780> 0(10018) , "asterisk1" 0(10018) , "subscriber" 
0(10018) );  0(10018)  external_module_call( 0(10018) f_ptr<0xf5fb7780> 
0(10018) , "asterisk1" 0(10018) , "subscriber" 0(10018) );  0(10018)  ) 
0(10018) ) { 0(10018)  external_module_call( 0(10018) f_ptr<0xf5fbdc90> 
0(10018) , "asterisk1" 0(10018) , "0" 0(10018) );  0(10018) drop( 
0(10018) type<0> 0(10018) );  0(10018) } else { 0(10018) };  0(10018)  
external_module_call( 0(10018) f_ptr<0xf5fd3770> 0(10018) , "location" 
0(10018) );  0(10018) drop( 0(10018) type<0> 0(10018) );  0(10018) } 
else { 0(10018) };  0(10018)  external_module_call( 0(10018) 
f_ptr<0xf5fcffa0> 0(10018) , "aliases" 0(10018) );  0(10018) if ( 
0(10018) NOT(  0(10018) uri 0(10018) == 0(10018) _myself_ 0(10018)  ) 
0(10018) ) { 0(10018)  external_module_call( 0(10018) f_ptr<0xf5fcb6d0> 
0(10018) , "P-hint: outbound alias
" 0(10018) );  0(10018) route( 0(10018) 1 0(10018) );  0(10018) drop( 
0(10018) type<0> 0(10018) );  0(10018) } else { 0(10018) };  0(10018) if 
( 0(10018) NOT(  0(10018)  external_module_call( 0(10018) 
f_ptr<0xf5fcffa0> 0(10018) , "location" 0(10018) );  0(10018)  
external_module_call( 0(10018) f_ptr<0xf5fcffa0> 0(10018) , "location" 
0(10018) );  0(10018)  ) 0(10018) ) { 0(10018)  external_module_call( 
0(10018) f_ptr<0xf603b790> 0(10018) , "404" 0(10018) , "Not Found" 
0(10018) );  0(10018) drop( 0(10018) type<0> 0(10018) );  0(10018) } 
else { 0(10018) };  0(10018) } else { 0(10018) };  0(10018)  
external_module_call( 0(10018) f_ptr<0xf5fcb6d0> 0(10018) , "P-hint: 
usrloc applied
" 0(10018) );  0(10018) route( 0(10018) 1 0(10018) );  0(10018) if ( 
0(10018) NOT(  0(10018) uri 0(10018) == 0(10018) _myself_ 0(10018)  ) 
0(10018) ) { 0(10018)  external_module_call( 0(10018) f_ptr<0xf5fcb6d0> 
0(10018) , "P-hint: outbound
" 0(10018) );  0(10018) route( 0(10018) 1 0(10018) );  0(10018) drop( 
0(10018) type<0> 0(10018) );  0(10018) } else { 0(10018) };  0(10018) if 
( 0(10018) uri 0(10018) == 0(10018) _myself_ 0(10018) ) { 0(10018) if ( 
0(10018) method 0(10018) == 0(10018) "REGISTER" 0(10018) ) { 0(10018) if 
( 0(10018) NOT(  0(10018)  external_module_call( 0(10018) 
f_ptr<0xf5fb7780> 0(10018) , "asterisk1" 0(10018) , "subscriber" 
0(10018) );  0(10018)  external_module_call( 0(10018) f_ptr<0xf5fb7780> 
0(10018) , "asterisk1" 0(10018) , "subscriber" 0(10018) );  0(10018)  ) 
0(10018) ) { 0(10018)  external_module_call( 0(10018) f_ptr<0xf5fbdc90> 
0(10018) , "asterisk1" 0(10018) , "0" 0(10018) );  0(10018) drop( 
0(10018) type<0> 0(10018) );  0(10018) } else { 0(10018) };  0(10018)  
external_module_call( 0(10018) f_ptr<0xf5fd3770> 0(10018) , "location" 
0(10018) );  0(10018) drop( 0(10018) type<0> 0(10018) );  0(10018) } 
else { 0(10018) };  0(10018)  external_module_call( 0(10018) 
f_ptr<0xf5fcffa0> 0(10018) , "aliases" 0(10018) );  0(10018) if ( 
0(10018) NOT(  0(10018) uri 0(10018) == 0(10018) _myself_ 0(10018)  ) 
0(10018) ) { 0(10018)  external_module_call( 0(10018) f_ptr<0xf5fcb6d0> 
0(10018) , "P-hint: outbound alias
" 0(10018) );  0(10018) route( 0(10018) 1 0(10018) );  0(10018) drop( 
0(10018) type<0> 0(10018) );  0(10018) } else { 0(10018) };  0(10018) if 
( 0(10018) NOT(  0(10018)  external_module_call( 0(10018) 
f_ptr<0xf5fcffa0> 0(10018) , "location" 0(10018) );  0(10018)  
external_module_call( 0(10018) f_ptr<0xf5fcffa0> 0(10018) , "location" 
0(10018) );  0(10018)  ) 0(10018) ) { 0(10018)  external_module_call( 
0(10018) f_ptr<0xf603b790> 0(10018) , "404" 0(10018) , "Not Found" 
0(10018) );  0(10018) drop( 0(10018) type<0> 0(10018) );  0(10018) } 
else { 0(10018) };  0(10018) } else { 0(10018) };  0(10018)  
external_module_call( 0(10018) f_ptr<0xf5fcb6d0> 0(10018) , "P-hint: 
usrloc applied
" 0(10018) );  0(10018) route( 0(10018) 1 0(10018) );  0(10018) if ( 
0(10018) uri 0(10018) == 0(10018) _myself_ 0(10018) ) { 0(10018) if ( 
0(10018) method 0(10018) == 0(10018) "REGISTER" 0(10018) ) { 0(10018) if 
( 0(10018) NOT(  0(10018)  external_module_call( 0(10018) 
f_ptr<0xf5fb7780> 0(10018) , "asterisk1" 0(10018) , "subscriber" 
0(10018) );  0(10018)  external_module_call( 0(10018) f_ptr<0xf5fb7780> 
0(10018) , "asterisk1" 0(10018) , "subscriber" 0(10018) );  0(10018)  ) 
0(10018) ) { 0(10018)  external_module_call( 0(10018) f_ptr<0xf5fbdc90> 
0(10018) , "asterisk1" 0(10018) , "0" 0(10018) );  0(10018) drop( 
0(10018) type<0> 0(10018) );  0(10018) } else { 0(10018) };  0(10018)  
external_module_call( 0(10018) f_ptr<0xf5fd3770> 0(10018) , "location" 
0(10018) );  0(10018) drop( 0(10018) type<0> 0(10018) );  0(10018) } 
else { 0(10018) };  0(10018) external_module_call( 0(10018) 
f_ptr<0xf5fcffa0> 0(10018) , "aliases" 0(10018) );  0(10018) if ( 
0(10018) NOT(  0(10018) uri 0(10018) == 0(10018) _myself_ 0(10018)  ) 
0(10018) ) { 0(10018)  external_module_call( 0(10018) f_ptr<0xf5fcb6d0> 
0(10018) , "P-hint: outbound alias
" 0(10018) );  0(10018) route( 0(10018) 1 0(10018) );  0(10018) drop( 
0(10018) type<0> 0(10018) );  0(10018) } else { 0(10018) };  0(10018) if 
( 0(10018) NOT(  0(10018)  external_module_call( 0(10018) 
f_ptr<0xf5fcffa0> 0(10018) , "location" 0(10018) );  0(10018)  
external_module_call( 0(10018) f_ptr<0xf5fcffa0> 0(10018) , "location" 
0(10018) );  0(10018)  ) 0(10018) ) { 0(10018)  external_module_call( 
0(10018) f_ptr<0xf603b790> 0(10018) , "404" 0(10018) , "Not Found" 
0(10018) );  0(10018) drop( 0(10018) type<0> 0(10018) );  0(10018) } 
else { 0(10018) };  0(10018) } else { 0(10018) };  0(10018)  
external_module_call( 0(10018) f_ptr<0xf5fcb6d0> 0(10018) , "P-hint: 
usrloc applied
" 0(10018) );  0(10018) route( 0(10018) 1 0(10018) );  0(10018)  
external_module_call( 0(10018) f_ptr<0xf5fcb6d0> 0(10018) , "P-hint: 
usrloc applied
" 0(10018) );  0(10018) route( 0(10018) 1 0(10018) );  0(10018) route( 
0(10018) 1 0(10018) );  0(10018)
 0(10018) routing table 1:
 0(10018)  external_module_call( 0(10018) f_ptr<0xf5fc5ff0> 0(10018) , 
"/usr/local/openser/sbin/dacpool" 0(10018) );  0(10018) if ( 0(10018) 
NOT(  0(10018)  external_module_call( 0(10018) f_ptr<0xf6011190> 
0(10018) );  0(10018)  external_module_call( 0(10018) f_ptr<0xf6011190> 
0(10018) );  0(10018)  ) 0(10018) ) { 0(10018)  external_module_call( 
0(10018) f_ptr<0xf603b7d0> 0(10018) );  0(10018) } else { 0(10018) };  
0(10018) if ( 0(10018) NOT(  0(10018)  external_module_call( 0(10018) 
f_ptr<0xf6011190> 0(10018) );  0(10018)  external_module_call( 0(10018) 
f_ptr<0xf6011190> 0(10018) );  0(10018)  ) 0(10018) ) { 0(10018)  
external_module_call( 0(10018) f_ptr<0xf603b7d0> 0(10018) );  0(10018) } 
else { 0(10018) };  0(10018)
Listening on
             udp: 127.0.0.1 [127.0.0.1]:5060
             udp: 10.141.1.115 [10.141.1.115]:5060
             tcp: 127.0.0.1 [127.0.0.1]:5060
             tcp: 10.141.1.115 [10.141.1.115]:5060
Aliases:
             tcp: asterisk1:5060
             tcp: localhost:5060
             tcp: localhost.localdomain:5060
             udp: asterisk1:5060
             udp: localhost:5060
             udp: localhost.localdomain:5060

WARNING: no fork mode  and more than one listen address found(will use 
only the the first one)
 0(10018) shm_mem_init: success
 0(0) core dump limits set to 4294967295
 0(0) DEBUG: init_mod: sl_module
stateless - initializing
 0(0) DEBUG: register_fifo_cmd: new command (sl_stats) registered
 0(0) unixsock_register_cmd: New command (sl_stats) registered
 0(0) DEBUG: MD5 calculated: 329cfeaa6ded039da25ff8cbb8668bd2
 0(0) DEBUG: init_mod: tm
 0(0) TM - (size of cell=2780, sip_msg=760) initializing...
 0(0) Call-ID initialization: '6ddcfcf6'
 0(0) DEBUG: register_fifo_cmd: new command (t_uac_dlg) registered
 0(0) DEBUG: register_fifo_cmd: new command (t_uac_cancel) registered
 0(0) DEBUG: register_fifo_cmd: new command (t_hash) registered
 0(0) DEBUG: register_fifo_cmd: new command (t_reply) registered
 0(0) unixsock_register_cmd: New command (t_uac_dlg) registered
 0(0) unixsock_register_cmd: New command (t_uac_cancel) registered
 0(0) unixsock_register_cmd: New command (t_hash) registered
 0(0) unixsock_register_cmd: New command (t_reply) registered
 0(0) DEBUG: lock_initialize: lock initialization started
 0(0) DEBUG: register_fifo_cmd: new command (t_stats) registered
 0(0) unixsock_register_cmd: New command (t_stats) registered
 0(0) DEBUG: MD5 calculated: 533cb9e91f4b999cf76861cbb9ed54ed
 0(0) DEBUG: MD5 calculated: a6a1c5f60faecf035a1ae5b6e96e979a
 0(0) DEBUG: init_mod: rr
 0(0) rr - initializing
 0(0) DEBUG: init_mod: maxfwd
 0(0) Maxfwd module- initializing
 0(0) DEBUG: init_mod: usrloc
 0(0) usrloc - initializing
 0(0) DEBUG: register_fifo_cmd: new command (ul_stats) registered
 0(0) DEBUG: register_fifo_cmd: new command (ul_rm) registered
 0(0) DEBUG: register_fifo_cmd: new command (ul_rm_contact) registered
 0(0) DEBUG: register_fifo_cmd: new command (ul_dump) registered
 0(0) DEBUG: register_fifo_cmd: new command (ul_flush) registered
 0(0) DEBUG: register_fifo_cmd: new command (ul_add) registered
 0(0) DEBUG: register_fifo_cmd: new command (ul_show_contact) registered
 0(0) unixsock_register_cmd: New command (ul_stats) registered
 0(0) unixsock_register_cmd: New command (ul_rm) registered
 0(0) unixsock_register_cmd: New command (ul_rm_contact) registered
 0(0) unixsock_register_cmd: New command (ul_dump) registered
 0(0) unixsock_register_cmd: New command (ul_flush) registered
 0(0) unixsock_register_cmd: New command (ul_add) registered
 0(0) unixsock_register_cmd: New command (ul_show_contact) registered
 0(0) find_mod_export: found <db_use_table> in module oracle 
[/usr/local/openser/lib/openser/modules/oracle.so]
 0(0) find_mod_export: found <db_init> in module oracle 
[/usr/local/openser/lib/openser/modules/oracle.so]
 0(0) find_mod_export: found <db_close> in module oracle 
[/usr/local/openser/lib/openser/modules/oracle.so]
 0(0) find_mod_export: found <db_query> in module oracle 
[/usr/local/openser/lib/openser/modules/oracle.so]
 0(0) find_mod_export: found <db_raw_query> in module oracle 
[/usr/local/openser/lib/openser/modules/oracle.so]
 0(0) find_mod_export: found <db_free_result> in module oracle 
[/usr/local/openser/lib/openser/modules/oracle.so]
 0(0) find_mod_export: found <db_insert> in module oracle 
[/usr/local/openser/lib/openser/modules/oracle.so]
 0(0) find_mod_export: found <db_delete> in module oracle 
[/usr/local/openser/lib/openser/modules/oracle.so]
 0(0) find_mod_export: found <db_update> in module oracle 
[/usr/local/openser/lib/openser/modules/oracle.so]
 0(0) DEBUG: init_mod: registrar
 0(0) registrar - initializing
 0(0) find_export: found <sl_send_reply> in module sl_module 
[/usr/local/openser/lib/openser/modules/sl.so]
 0(0) find_export: found <ul_bind_usrloc> in module usrloc 
[/usr/local/openser/lib/openser/modules/usrloc.so]
 0(0) find_export: found <ul_register_udomain> in module usrloc 
[/usr/local/openser/lib/openser/modules/usrloc.so]
 0(0) find_export: found <ul_get_all_ucontacts> in module usrloc 
[/usr/local/openser/lib/openser/modules/usrloc.so]
 0(0) find_export: found <ul_insert_urecord> in module usrloc 
[/usr/local/openser/lib/openser/modules/usrloc.so]
 0(0) find_export: found <ul_delete_urecord> in module usrloc 
[/usr/local/openser/lib/openser/modules/usrloc.so]
 0(0) find_export: found <ul_get_urecord> in module usrloc 
[/usr/local/openser/lib/openser/modules/usrloc.so]
 0(0) find_export: found <ul_lock_udomain> in module usrloc 
[/usr/local/openser/lib/openser/modules/usrloc.so]
 0(0) find_export: found <ul_unlock_udomain> in module usrloc 
[/usr/local/openser/lib/openser/modules/usrloc.so]
 0(0) find_export: found <ul_release_urecord> in module usrloc 
[/usr/local/openser/lib/openser/modules/usrloc.so]
 0(0) find_export: found <ul_insert_ucontact> in module usrloc 
[/usr/local/openser/lib/openser/modules/usrloc.so]
 0(0) find_export: found <ul_delete_ucontact> in module usrloc 
[/usr/local/openser/lib/openser/modules/usrloc.so]
 0(0) find_export: found <ul_get_ucontact> in module usrloc 
[/usr/local/openser/lib/openser/modules/usrloc.so]
 0(0) find_export: found <ul_update_ucontact> in module usrloc 
[/usr/local/openser/lib/openser/modules/usrloc.so]
 0(0) find_export: found <ul_register_watcher> in module usrloc 
[/usr/local/openser/lib/openser/modules/usrloc.so]
 0(0) find_export: found <ul_unregister_watcher> in module usrloc 
[/usr/local/openser/lib/openser/modules/usrloc.so]
 0(0) find_export: found <ul_register_ulcb> in module usrloc 
[/usr/local/openser/lib/openser/modules/usrloc.so]
 0(0) DEBUG: init_mod: textops
textops - initializing
 0(0) DEBUG: init_mod: exec
exec - initializing
 0(0) DEBUG: init_mod: auth
 0(0) AUTH module - initializing
 0(0) find_export: found <sl_send_reply> in module sl_module 
[/usr/local/openser/lib/openser/modules/sl.so]
 0(0) DEBUG: init_mod: auth_db
 0(0) AUTH_DB module - initializing
 0(0) find_mod_export: found <db_use_table> in module oracle 
[/usr/local/openser/lib/openser/modules/oracle.so]
 0(0) find_mod_export: found <db_init> in module oracle 
[/usr/local/openser/lib/openser/modules/oracle.so]
 0(0) find_mod_export: found <db_close> in module oracle 
[/usr/local/openser/lib/openser/modules/oracle.so]
 0(0) find_mod_export: found <db_query> in module oracle 
[/usr/local/openser/lib/openser/modules/oracle.so]
 0(0) find_mod_export: found <db_raw_query> in module oracle 
[/usr/local/openser/lib/openser/modules/oracle.so]
 0(0) find_mod_export: found <db_free_result> in module oracle 
[/usr/local/openser/lib/openser/modules/oracle.so]
 0(0) find_mod_export: found <db_insert> in module oracle 
[/usr/local/openser/lib/openser/modules/oracle.so]
 0(0) find_mod_export: found <db_delete> in module oracle 
[/usr/local/openser/lib/openser/modules/oracle.so]
 0(0) find_mod_export: found <db_update> in module oracle 
[/usr/local/openser/lib/openser/modules/oracle.so]
 0(0) find_export: found <bind_auth> in module auth 
[/usr/local/openser/lib/openser/modules/auth.so]
 0(0) find_export: found <sl_send_reply> in module sl_module 
[/usr/local/openser/lib/openser/modules/sl.so]
 0(0) fixing /usr/local/openser/lib/openser/modules/maxfwd.so 
mf_process_maxfwd_header
 0(0) fixing /usr/local/openser/lib/openser/modules/sl.so sl_send_reply
 0(0) fixing /usr/local/openser/lib/openser/modules/sl.so sl_send_reply
 0(0) DEBUG: mk_proxy: doing DNS lookup...
 0(0) fixing /usr/local/openser/lib/openser/modules/rr.so record_route
 0(0) fixing /usr/local/openser/lib/openser/modules/rr.so loose_route
 0(0) fixing /usr/local/openser/lib/openser/modules/textops.so append_hf
 0(0) fixing /usr/local/openser/lib/openser/modules/textops.so append_hf
 0(0) fixing /usr/local/openser/lib/openser/modules/auth_db.so www_authorize
 0(0) WARNING! This module is experimental and may crash SER or create 
unexpected results. You use the module at your own risk. Please submit 
bugs at http://bugs.sip-router.org/ 0(0) 
db_init(oracle://openser:MYPASSWORD@/astoracle)
 0(0) db_use_table(version)
 0(0) db_query
 0(0) select table_version from version where table_name=:a
 0(0) oci_prepare
 0(0) bind_values: DB_STR - subscriber
 0(0) oci_execute
 0(0) map_int_param_type_and_size_to_ext: Oracle type SQLT_NUM
 0(0) map_int_param_type_and_size_to_ext: SQLT_NUM precision 38, scale 0
 0(0) map_int_param_type_and_size_to_ext: External type SQLT_FLT, size 8
 0(0) ORA-24334. Not an error probably.
 0(0) define_params: ora_params_num = 1
 0(0) convert_row: params_num = 1, _r = 0xf6ff330c
 0(0) SQLT_FLT: 5.000000e+00
 0(0) db_free_result
 0(0) free_params
 0(0) free_params: 1 parameter(s) freed
 0(0) db_free_result: row memory released
 0(0) db_free_result: rows memory released
 0(0) db_free_result: types memory released
 0(0) db_free_result: names memory released
 0(0) db_close
 0(0) auth_db:str_fixup: Invalid 'subscriber' table version 0 - should 
be 3 (use ser_mysql.sh reinstall)
 0(0) ERROR: fix_expr : fix_actions error
ERROR: error -1 while trying to fix configuration
 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(10018) shm_mem_destroy
 0(10018) destroying the shared memory lock




More information about the Devel mailing list