Re: [OpenSIPS-Users] About STUN server configuration

2010-01-15 Thread Koichi Yagishita

Hi Bogdan,

Thank you for your response. The following is output of /var/log/messages and 
ifconfig.

[/var/log/messages]
Jan 16 09:21:41 jrc opensips: WARNING:core:fix_socket_list: could not rev. 
resolve 192.168.1.1 
Jan 16 09:21:41 jrc opensips: WARNING:core:fix_socket_list: could not rev. 
resolve 192.168.100.1 
Jan 16 09:21:41 jrc opensips: WARNING:core:fix_socket_list: could not rev. 
resolve 192.168.1.1 
Jan 16 09:21:41 jrc opensips: WARNING:core:fix_socket_list: could not rev. 
resolve 192.168.100.1 
Jan 16 09:21:41 jrc opensips: INFO:core:init_tcp: using epoll_lt as the TCP io 
watch method (auto detected) 
Jan 16 09:21:41 jrc /usr/local/sbin/opensips[4991]: NOTICE:core:main: version: 
opensips 1.6.0-tls (i386/linux) 
Jan 16 09:21:41 jrc /usr/local/sbin/opensips[4991]: INFO:core:main: using 32 Mb 
shared memory 
Jan 16 09:21:41 jrc /usr/local/sbin/opensips[4991]: INFO:core:main: using 1 Mb 
private memory per process 
Jan 16 09:21:41 jrc /usr/local/sbin/opensips[4991]: NOTICE:signaling:mod_init: 
initializing module ... 
Jan 16 09:21:41 jrc /usr/local/sbin/opensips[4991]: INFO:sl:mod_init: 
Initializing StateLess engine 
Jan 16 09:21:41 jrc /usr/local/sbin/opensips[4991]: INFO:tm:mod_init: TM - 
initializing... 
Jan 16 09:21:41 jrc /usr/local/sbin/opensips[4991]: INFO:maxfwd:mod_init: 
initializing... 
Jan 16 09:21:41 jrc /usr/local/sbin/opensips[4991]: INFO:usrloc:ul_init_locks: 
locks array size 512 
Jan 16 09:21:41 jrc /usr/local/sbin/opensips[4991]: INFO:registrar:mod_init: 
initializing... 
Jan 16 09:21:41 jrc /usr/local/sbin/opensips[4991]: INFO:textops:mod_init: 
initializing... 
Jan 16 09:21:41 jrc /usr/local/sbin/opensips[4991]: INFO:xlog:mod_init: 
initializing... 
Jan 16 09:21:41 jrc /usr/local/sbin/opensips[4991]: INFO:acc:mod_init: 
initializing... 
Jan 16 09:21:41 jrc /usr/local/sbin/opensips[4991]: INFO:auth:mod_init: 
initializing... 
Jan 16 09:21:41 jrc /usr/local/sbin/opensips[4991]: INFO:auth_db:mod_init: 
initializing... 
Jan 16 09:21:41 jrc /usr/local/sbin/opensips[4991]: 
INFO:core:probe_max_receive_buffer: using a UDP receive buffer of 255 kb 
Jan 16 09:21:41 jrc last message repeated 2 times
Jan 16 09:21:41 jrc /usr/local/sbin/opensips[4991]: ERROR:core:tcp_init: 
bind(a, 0x81ca8b4, 16) on 127.0.0.1:5060 : Address already in use 

[ifconfig]
eth0  Link encap:Ethernet  HWaddr 00:25:64:EB:13:33  
  inet addr:192.168.100.1  Bcast:192.168.100.255  Mask:255.255.255.0
  inet6 addr: fe80::225:64ff:feeb:1333/64 Scope:Link
  UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
  RX packets:400 errors:0 dropped:0 overruns:0 frame:0
  TX packets:134 errors:0 dropped:0 overruns:0 carrier:0
  collisions:0 txqueuelen:1000 
  RX bytes:59253 (57.8 KiB)  TX bytes:32835 (32.0 KiB)
  Memory:fe6e-fe70 

eth0:1Link encap:Ethernet  HWaddr 00:25:64:EB:13:33  
  inet addr:192.168.1.1  Bcast:192.168.1.255  Mask:255.255.255.0
  UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
  Memory:fe6e-fe70 

loLink encap:Local Loopback  
  inet addr:127.0.0.1  Mask:255.0.0.0
  inet6 addr: ::1/128 Scope:Host
  UP LOOPBACK RUNNING  MTU:16436  Metric:1
  RX packets:1660 errors:0 dropped:0 overruns:0 frame:0
  TX packets:1660 errors:0 dropped:0 overruns:0 carrier:0
  collisions:0 txqueuelen:0 
  RX bytes:2581132 (2.4 MiB)  TX bytes:2581132 (2.4 MiB)

Regards,
Yagishita

___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users


Re: [OpenSIPS-Users] mi_xmlrpc - Display name in From header

2010-01-15 Thread Chris Maciejewski
Hi Bogdan,

Thanks for your help.

XML MI command attached.

Please let me know if I can help somehow in fixing this issue (testing
patches etc.)

Best regards,
Chris

2010/1/15 Bogdan-Andrei Iancu 
>
> Hi Chris,
>
> It seams that the t_uac MI function fails to properly detect the display
> name and adds an extra pare of angle brackets...Could you send the
> complete MI command you are using - I will try to reproduce and debug this.
>
> Thanks & Regards,
> Bogdan
>
> Chris Maciejewski wrote:
> > Hi,
> >
> > I am trying to include "display name" in a From header (ie. 'From:
> > "Test User" '), when sending local messages with
> > mi_xmlrpc (openSIPs 1.5.3).
> >
> > Already tried many options, but I always end up with 'From: <"Test
> > User" >' which obviously fails.
> >
> > My XML headers parameter:
> > ...
> >  
> >   
> >    From: Test User 
To:
> > 
Content-Type: text/html;
> > charset=utf-8

> >   
> >  
> > 
> >
> > Results in the following SIP packet:
> >
> > MESSAGE sip:10...@example.com SIP/2.0.
> > Via: SIP/2.0/UDP 10.10.10.1:5065;branch=z9hG4bK40b7.e646756.0.
> > To: .
> > From:  > >;tag=a6eba7f2b7ff5072ce4465fa3b4415e6-e309.
> > 
> >
> > Any suggestions how to solve this issue very much appreciated.
> >
> > Kind regards,
> > Chris
> >
> > ___
> > Users mailing list
> > Users@lists.opensips.org
> > http://lists.opensips.org/cgi-bin/mailman/listinfo/users
> >
> >
>
>
> --
> Bogdan-Andrei Iancu
> www.voice-system.ro
>
>
> ___
> Users mailing list
> Users@lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users


t_uac_dlg

 
  
   MESSAGE
  
 
 
  
   sip:10...@example.com
  
 
 
  
   .
  
 
 
  
   .
  
 
 
  
   From: Test User 
To: 
Content-Type: text/html; charset=utf-8

  
 
 
  
   test message
  
 


___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users


Re: [OpenSIPS-Users] DRouting Help

2010-01-15 Thread duane . larson

Rajib,

I found this post on Nabble,
http://n2.nabble.com/DRouting-Sample-Config-td2735149.html#a2735179

So it looks like everyone is still going to say read the drouting module  
doc. I can speak from experience that sometimes it helps to search through  
nabbles OpenSIPS-Users section for any bit of opensips config code that  
could shed some light

http://n2.nabble.com/OpenSIPS-Users-f1449235.html
Perhaps you could search on Nabble for one of the Drouting "exported  
functions". So if you did a search for do_routing or use_next_gateway you  
might find some examples or code.


Hope that helps.


On Jan 15, 2010 1:06pm, rajib deka  wrote:

Hello all,


I am a newbie to OpenSIPS. I have worked a lot with load_balancer and  
dispatcher module, also I know how to work with it little bit. I have  
gone through the DR module documentation but I couldnot understand it  
thoroughly. It will be helpful for me if someone can help me by providing  
DRouting tutorial script (routing script). So that I can use it for my  
proxy setup.





Thanks and Regards
Rajib




___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users


[OpenSIPS-Users] DRouting Help

2010-01-15 Thread rajib deka
Hello all,

I am a newbie to OpenSIPS. I have worked a lot with load_balancer and
dispatcher module, also I know how to work with it little bit. I have gone
through the DR module documentation but I couldnot understand it thoroughly.
It will be helpful for me if someone can help me by providing DRouting
tutorial script (routing script). So that I can use it for my proxy setup.

Thanks and Regards
Rajib
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users


Re: [OpenSIPS-Users] my problems getting dialplan to work

2010-01-15 Thread Wesley Volcov

Hello Bogdan,

I made the exemple you wrote above.

My script:
$var(x) = "sip:06";
dp_translate("1", "$var(x)/$var(tmp)");
xlog("-$var(tmp)\n");

My database:
mysql> select * from dialplan;
++--++--++---++---+---+
| id | dpid | pr | match_op | match_exp  | match_len | subst_exp  | repl_exp
  
| attrs |
++--++--++---++---+---+
|  1 |1 |  0 |1 | (sip:06.+) | 0 | (sip:06.+) |
wes...@voicetechnology.com.br | 0 | 
++--++--++---++---+---+
1 row in set (0.00 sec)

My log file:
Jan 15 15:30:11 localhost opensips[22981]: -0 

I have no log of dialplan module. Is there some configuration to active this
module debug ?

Regards,

Wesley.




Bogdan-Andrei Iancu wrote:
> 
> Hi Todd,
> 
> There is the ChangeLog coming together with all releases (major or minor):
> 
> http://opensips.org/pub/opensips/1.5.1/src/ChangeLog
> 
> Regards,
> Bogdan
> 
> Bradley, Todd wrote:
>> Hi Bogdan.  Someone else on my team replicated the problem with the
>> 1.5.1 release.  He updated to the latest code from SVN and the problem
>> is fixed there.  So that pretty much proves this was a bug that was
>> fixed, but not until after the 1.5.1 release. 
>>
>> In the future, for similar situations, is there a bug database for
>> OpenSIPS where we should be looking for these kind of details?
>>
>>
>> Thanks for the help,
>> Todd.
>>
>>
>>   
>>> -Original Message-
>>> From: users-boun...@lists.opensips.org 
>>> [mailto:users-boun...@lists.opensips.org] On Behalf Of 
>>> Bogdan-Andrei Iancu
>>> Sent: Friday, June 19, 2009 4:35 PM
>>> To: Bradley, Todd
>>> Cc: users@lists.opensips.org
>>> Subject: Re: [OpenSIPS-Users] my problems getting dialplan to work
>>>
>>> Todd,
>>>
>>> could you please update from SVN, from branch 1.5 - I 
>>> remember a fix related to and I'm not sure if you have it or not.
>>>
>>> Regards,
>>> Bogdan
>>>
>>> Bradley, Todd wrote:
>>> 
 [r...@test7 ~]# opensips -V
 version: opensips 1.5.1-notls (i386/linux)
 flags: STATS: Off, USE_IPV6, USE_TCP, DISABLE_NAGLE, USE_MCAST, 
 SHM_MEM, SHM_MMAP, PKG_MALLOC, F_MALLOC, FAST_LOCK-ADAPTIVE_WAIT 
 ADAPTIVE_WAIT_LOOPS=1024, MAX_RECV_BUFFER_SIZE 262144, 
   
>>> MAX_LISTEN 16, 
>>> 
 MAX_URI_SIZE 1024, BUF_SIZE 65535 poll method support: 
   
>>> poll, epoll_lt, 
>>> 
 epoll_et, sigio_rt, select.
 svnrevision: unknown
 @(#) $Id: main.c 5469 2009-03-18 12:43:10Z bogdan_iancu $ main.c 
 compiled on 11:54:04 Jun 10 2009 with gcc 4.1.2
  

   
   
> -Original Message-
> From: users-boun...@lists.opensips.org 
> [mailto:users-boun...@lists.opensips.org] On Behalf Of 
> 
>>> Bogdan-Andrei 
>>> 
> Iancu
> Sent: Thursday, June 18, 2009 6:36 PM
> To: Bradley, Todd
> Cc: users@lists.opensips.org
> Subject: Re: [OpenSIPS-Users] my problems getting dialplan to work
>
> Hi Todd,
>
> What version of opensips are you using ? Could you pass me 
> 
>>> the output 
>>> 
> of "opensips -V" ?
>
> Regards,
> Bogdan
>
> Bradley, Todd wrote:
> 
> 
>> I'm running on GNU/Linux FC7.  I know that's pretty old, but it's 
>> updated with all the latest package updates.  I built 
>> opensips-1.5.1-tls from source.
>>
>>
>> Todd.
>>
>>
>>   
>>   
>>   
>>> -Original Message-
>>> From: users-boun...@lists.opensips.org 
>>> [mailto:users-boun...@lists.opensips.org] On Behalf Of
>>> 
>>> 
> Bogdan-Andrei
> 
> 
>>> Iancu
>>> Sent: Tuesday, June 16, 2009 11:15 AM
>>> To: Bradley, Todd
>>> Cc: users@lists.opensips.org
>>> Subject: Re: [OpenSIPS-Users] my problems getting 
>>> 
>>> dialplan to work
>>> 
>>> Todd, this sounds like twilightzone :)...what OS are you using ?
>>>
>>> regards,
>>> Bogdan
>>>
>>> Bradley, Todd wrote:
>>> 
>>> 
>>> 
 This is really baffling.  I updated my DB table to look
   
   
   
>>> nearly exactly
>>> 
>>> 
>>> 
 like yours and even changed my script to look almost 
   
>>> exactly like 
>>> 
 yours, and still it doesn't work.

 Here's the output that was logged:

 Jun 16 10:35:12 [27383] DBG:dialplan:dp_get_ivalue: integer
   
   
   
>>> value Jun
>>> 
>>> 

Re: [OpenSIPS-Users] TLS errors

2010-01-15 Thread nir elkayam
hi,

i follow the script on :
http://www.opensips.org/html/docs/tutorials/tls-1.4.x.html

mainly, generated root certificate with:
opensipsctl tls rootCA
and then generate user (i.e. sip server) certificate with:
 opensipsctl tls userCERT user

about the file ca_list, the wiki say:

To add more CAs to your list, just do:

   -

   cat add_cacert.pem >> calist.pem

but not sure about that, doesn't the last command  should have updated the
ca list? i see that the file isn't empty..

nir



On Fri, Jan 15, 2010 at 6:35 PM, Bogdan-Andrei Iancu  wrote:

> Hi Nir,
>
> I see you manage to start opensips with TLS - what was your error?
>
> for _tls_read -> that is very funny: SSL_read return err 5
> (SSL_ERROR_SYSCALL) which means to look at error stack/return
> value/errno for the real error (the error was geerated somewhere deep in
> the SSL underlayers), but the errno is Success and stack is empty
> :P. Looks like a ghost error...
>
> for tls_accept -> the error is in the stack, and after googling a bit ->
> "obviously the CA that signed your clients is not known to the server.
> Take a look at"
>
>http://www.modssl.org/docs/2.8/ssl_howto.html#ToC6
>http://www.modssl.org/docs/2.8/ssl_reference.html#ToC14
>
>
> Regards,
> Bogdan
>
> nir elkayam wrote:
> > hi,
> >
> > i am using opensips/TLS,
> >
> > i get the following error
> > Jan 14 22:53:54 [19740] ERROR:core:_tls_read: SYSCALL error -> (0)
> > 
> > Jan 14 22:53:54 [19740] ERROR:core:_tls_read: something wrong in SSL: 5
> > Jan 14 22:53:54 [19740] ERROR:core:tcp_read_req: failed to read
> > Jan 14 22:54:46 [19740] ERROR:core:tls_accept: some error in SSL
> > (ret=0, err=1, errno=0/Success):
> > Jan 14 22:54:46 [19740] ERROR:core:tls_print_errstack:
> > error:14094418:SSL routines:SSL3_READ_BYTES:tlsv1 alert unknown ca
> >
> > any hinst about these?
> > actually the client works but error in encryption process is not good,
> > i think
> >
> > thanks
> > 
> >
> > ___
> > Users mailing list
> > Users@lists.opensips.org
> > http://lists.opensips.org/cgi-bin/mailman/listinfo/users
> >
>
>
> --
> Bogdan-Andrei Iancu
> www.voice-system.ro
>
>
> ___
> Users mailing list
> Users@lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>



-- 
ניר אלקיים
טל: 050-3930056
nir.elka...@gmail.com
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users


Re: [OpenSIPS-Users] Error in module permission with db_text

2010-01-15 Thread Bogdan-Andrei Iancu
Ok, I will investigate to come up with an official fix.

Thanks and regards,
Bogdan

Леонид Наседкин wrote:
> Hi Bogdan
> Thank you. Its working now.
>
> 2010/1/15 Bogdan-Andrei Iancu  >
>
> Hi Leonid,
>
> Looks like there is a compatibility bug between permission and
> db_text modules when comes to DB data typesGive me couple of
> days to sort this out.
>
> In the mean while, if you want to use db_text for permissions,
> please use the attached patch.
>
> Thanks and regards,
> Bogdan
>
>
> Леонид Наседкин wrote:
>
> Hi there.
> I'm trying to use permission module with db_text, and it's not
> working, and I can't understand what's wrong.
> Opensips 1.6.1 svnrevision: 2:6509
>
> In opensips.cfg:
> loadmodule "db_text.so"
> modparam("db_text", "db_mode", 0)
> loadmodule "permissions.so"
> modparam("permissions","db_url", "text:///etc/opensips/dbtext")
>
> In /etc/opensips/dbtext/address:
> id(int,auto) grp(int) ip(str) mask(int) port(int) proto(str)
> pattern(str,null) context_info(str,null)
> 10:1:10.100.0.0:23:5060:udp::
> 20:1:10.110.0.0:23:5060:udp::
> 30:1:10.120.0.0:23:5060:udp::
>
> LOG:
>
> DBG:core:init_mod: initializing module permissions
> DBG:permissions:mod_init: initializing...
> WARNING:permissions:parse_config_file: file not found:
> /etc/opensips/permissions.allow
> WARNING:permissions:mod_init: default allow file
> (/etc/opensips/permissions.allow) not found => empty rule set
> WARNING:permissions:parse_config_file: file not found:
> /etc/opensips/permissions.deny
> WARNING:permissions:mod_init: default deny file
> (/etc/opensips/permissions.deny) not found => empty rule set
> DBG:core:find_mod_export: found  in module
> db_text [/usr/lib/opensips/modules/]
> DBG:core:db_bind_mod: using db bind api for db_text
> INFO:db_text:dbt_init: using database at: /etc/opensips/dbtext/
> DBG:db_text:dbt_cache_get_db: looking for db
> /etc/opensips/dbtext/!
> DBG:db_text:dbt_cache_get_db: new db!
> DBG:db_text:dbt_load_file: request for table [version]
> DBG:db_text:dbt_load_file: db is [/etc/opensips/dbtext/]
> DBG:db_text:dbt_load_file: loading file
> [/etc/opensips/dbtext//version]
> DBG:db_text:dbt_table_new: mtime is 1263556066
> DBG:db_text:dbt_load_file: column[0] is STR!
> DBG:db_text:dbt_load_file: column[1] is INT!
> DBG:db_text:dbt_query: new res with 1 cols
> DBG:db_text:dbt_result_new: new res with 1 cols
> DBG:core:db_new_result: allocate 28 bytes for result set at
> 0x816b044
> DBG:core:db_allocate_columns: allocate 16 bytes for result
> columns at 0x816aedc
> DBG:core:db_allocate_rows: allocate 28 bytes for result rows
> and values at 0x816b090
> DBG:core:db_free_columns: freeing result columns at 0x816aedc
> DBG:core:db_free_rows: freeing 1 rows
> DBG:core:db_free_row: freeing row values at 0x816b098
> DBG:core:db_free_rows: freeing rows at 0x816b090
> DBG:core:db_free_result: freeing result set at 0x816b044
> DBG:db_text:dbt_load_file: request for table [address]
> DBG:db_text:dbt_load_file: db is [/etc/opensips/dbtext/]
> DBG:db_text:dbt_load_file: loading file
> [/etc/opensips/dbtext//address]
> DBG:db_text:dbt_table_new: mtime is 1263558311
> DBG:db_text:dbt_load_file: column[0] is INT!
> DBG:db_text:dbt_load_file: column[1] is INT!
> DBG:db_text:dbt_load_file: column[2] is STR!
> DBG:db_text:dbt_load_file: column[3] is INT!
> DBG:db_text:dbt_load_file: column[4] is INT!
> DBG:db_text:dbt_load_file: column[5] is STR!
> DBG:db_text:dbt_load_file: column[6] is STR!
> DBG:db_text:dbt_load_file: column[7] is STR!
> DBG:db_text:dbt_query: new res with 8 cols
> DBG:db_text:dbt_result_new: new res with 8 cols
> DBG:core:db_new_result: allocate 28 bytes for result set at
> 0x816b004
> DBG:core:db_allocate_columns: allocate 128 bytes for result
> columns at 0x8186b68
> DBG:core:db_allocate_rows: allocate 504 bytes for result rows
> and values at 0x8186bf4
> DBG:permissions:reload_address_table: number of rows in
> address table: 3
> ERROR:permissions:reload_address_table: database problem
> DBG:core:db_free_columns: freeing result columns at 0x8186b68
> DBG:core:db_free_rows: freeing 3 rows
> DBG:core:db_free_row: freeing row values at 0x8186c0c
> DBG:core:db_free_row: freeing row values at 0x8186cac
> DBG:core:db_free_row: freeing row values at 0x8186d4c
> DBG:core:db_

Re: [OpenSIPS-Users] To header : modification when using Dynamic Routing

2010-01-15 Thread Bogdan-Andrei Iancu
Hi Julien,

OpenSIPS 1.6.1 has the uac_replace_to() function - 
http://www.opensips.org/html/docs/modules/devel/uac.html#id22858

So, you can do it in the nice, official way :)

Regards,
Bogda

Julien Chavanton wrote:
> Hi, I have found this, looks like it could work, I will probably test 
> it only with the partner having this specific requirement for now.
>  
> subst('/^To:.*(.*)$/To: "$rU" 
> \1/');
>  
>  
>
> 
> *From:* users-boun...@lists.opensips.org on behalf of Julien Chavanton
> *Sent:* Mon 11/01/2010 5:08 PM
> *To:* users@lists.opensips.org
> *Subject:* [OpenSIPS-Users] To header : modification when using 
> Dynamic Routing
>
> Hi, when using Dynamic Routing, I would like to modify the SIP "To 
> header" field to be like the target URI.
>  
> I know the SIP RFC state that a SIP proxy should not alter the "To 
> header" field, but this is not a problem in this case.
>  
> The "To header" field contains prefix that have no meaning for the 
> destination, we want to modify it to look like a normal ITU 
> internationnal dialing plan.
>  
> What is the recommend way of doing it ?
>  
> TEXTOPS
> 
>
> ___
> Users mailing list
> Users@lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>   


-- 
Bogdan-Andrei Iancu
www.voice-system.ro


___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users


Re: [OpenSIPS-Users] Error in module permission with db_text

2010-01-15 Thread Леонид Наседкин
Hi Bogdan
Thank you. Its working now.

2010/1/15 Bogdan-Andrei Iancu 

> Hi Leonid,
>
> Looks like there is a compatibility bug between permission and db_text
> modules when comes to DB data typesGive me couple of days to sort this
> out.
>
> In the mean while, if you want to use db_text for permissions, please use
> the attached patch.
>
> Thanks and regards,
> Bogdan
>
>
> Леонид Наседкин wrote:
>
>> Hi there.
>> I'm trying to use permission module with db_text, and it's not working,
>> and I can't understand what's wrong.
>> Opensips 1.6.1 svnrevision: 2:6509
>>
>> In opensips.cfg:
>> loadmodule "db_text.so"
>> modparam("db_text", "db_mode", 0)
>> loadmodule "permissions.so"
>> modparam("permissions","db_url", "text:///etc/opensips/dbtext")
>>
>> In /etc/opensips/dbtext/address:
>> id(int,auto) grp(int) ip(str) mask(int) port(int) proto(str)
>> pattern(str,null) context_info(str,null)
>> 10:1:10.100.0.0:23:5060:udp::
>> 20:1:10.110.0.0:23:5060:udp::
>> 30:1:10.120.0.0:23:5060:udp::
>>
>> LOG:
>>
>> DBG:core:init_mod: initializing module permissions
>> DBG:permissions:mod_init: initializing...
>> WARNING:permissions:parse_config_file: file not found:
>> /etc/opensips/permissions.allow
>> WARNING:permissions:mod_init: default allow file
>> (/etc/opensips/permissions.allow) not found => empty rule set
>> WARNING:permissions:parse_config_file: file not found:
>> /etc/opensips/permissions.deny
>> WARNING:permissions:mod_init: default deny file
>> (/etc/opensips/permissions.deny) not found => empty rule set
>> DBG:core:find_mod_export: found  in module db_text
>> [/usr/lib/opensips/modules/]
>> DBG:core:db_bind_mod: using db bind api for db_text
>> INFO:db_text:dbt_init: using database at: /etc/opensips/dbtext/
>> DBG:db_text:dbt_cache_get_db: looking for db /etc/opensips/dbtext/!
>> DBG:db_text:dbt_cache_get_db: new db!
>> DBG:db_text:dbt_load_file: request for table [version]
>> DBG:db_text:dbt_load_file: db is [/etc/opensips/dbtext/]
>> DBG:db_text:dbt_load_file: loading file [/etc/opensips/dbtext//version]
>> DBG:db_text:dbt_table_new: mtime is 1263556066
>> DBG:db_text:dbt_load_file: column[0] is STR!
>> DBG:db_text:dbt_load_file: column[1] is INT!
>> DBG:db_text:dbt_query: new res with 1 cols
>> DBG:db_text:dbt_result_new: new res with 1 cols
>> DBG:core:db_new_result: allocate 28 bytes for result set at 0x816b044
>> DBG:core:db_allocate_columns: allocate 16 bytes for result columns at
>> 0x816aedc
>> DBG:core:db_allocate_rows: allocate 28 bytes for result rows and values at
>> 0x816b090
>> DBG:core:db_free_columns: freeing result columns at 0x816aedc
>> DBG:core:db_free_rows: freeing 1 rows
>> DBG:core:db_free_row: freeing row values at 0x816b098
>> DBG:core:db_free_rows: freeing rows at 0x816b090
>> DBG:core:db_free_result: freeing result set at 0x816b044
>> DBG:db_text:dbt_load_file: request for table [address]
>> DBG:db_text:dbt_load_file: db is [/etc/opensips/dbtext/]
>> DBG:db_text:dbt_load_file: loading file [/etc/opensips/dbtext//address]
>> DBG:db_text:dbt_table_new: mtime is 1263558311
>> DBG:db_text:dbt_load_file: column[0] is INT!
>> DBG:db_text:dbt_load_file: column[1] is INT!
>> DBG:db_text:dbt_load_file: column[2] is STR!
>> DBG:db_text:dbt_load_file: column[3] is INT!
>> DBG:db_text:dbt_load_file: column[4] is INT!
>> DBG:db_text:dbt_load_file: column[5] is STR!
>> DBG:db_text:dbt_load_file: column[6] is STR!
>> DBG:db_text:dbt_load_file: column[7] is STR!
>> DBG:db_text:dbt_query: new res with 8 cols
>> DBG:db_text:dbt_result_new: new res with 8 cols
>> DBG:core:db_new_result: allocate 28 bytes for result set at 0x816b004
>> DBG:core:db_allocate_columns: allocate 128 bytes for result columns at
>> 0x8186b68
>> DBG:core:db_allocate_rows: allocate 504 bytes for result rows and values
>> at 0x8186bf4
>> DBG:permissions:reload_address_table: number of rows in address table: 3
>> ERROR:permissions:reload_address_table: database problem
>> DBG:core:db_free_columns: freeing result columns at 0x8186b68
>> DBG:core:db_free_rows: freeing 3 rows
>> DBG:core:db_free_row: freeing row values at 0x8186c0c
>> DBG:core:db_free_row: freeing row values at 0x8186cac
>> DBG:core:db_free_row: freeing row values at 0x8186d4c
>> DBG:core:db_free_rows: freeing rows at 0x8186bf4
>> DBG:core:db_free_result: freeing result set at 0x816b004
>> CRITICAL:permissions:init_address: reload of address table failed
>> ERROR:permissions:mod_init: failed to initialize the allow_address
>> function
>> ERROR:core:init_mod: failed to initialize module permissions
>> ERROR:core:main: error while initializing modules
>> DBG:db_text:destroy: destroy ...
>>
>>
>> --
>> WBR, Leonid Nasedkin
>> icq: 256816
>> skype: leonidnasedkin
>> 
>>
>> ___
>> Users mailing list
>> Users@lists.opensips.org
>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>
>>
>
>
> --
> Bogdan-Andrei Iancu
> www.voice-system.ro
>
>

Re: [OpenSIPS-Users] mi_xmlrpc - Display name in From header

2010-01-15 Thread Bogdan-Andrei Iancu
Hi Chris,

It seams that the t_uac MI function fails to properly detect the display 
name and adds an extra pare of angle brackets...Could you send the 
complete MI command you are using - I will try to reproduce and debug this.

Thanks & Regards,
Bogdan

Chris Maciejewski wrote:
> Hi,
>
> I am trying to include "display name" in a From header (ie. 'From:
> "Test User" '), when sending local messages with
> mi_xmlrpc (openSIPs 1.5.3).
>
> Already tried many options, but I always end up with 'From: <"Test
> User" >' which obviously fails.
>
> My XML headers parameter:
> ...
>  
>   
>From: Test User 
To:
> 
Content-Type: text/html;
> charset=utf-8

>   
>  
> 
>
> Results in the following SIP packet:
>
> MESSAGE sip:10...@example.com SIP/2.0.
> Via: SIP/2.0/UDP 10.10.10.1:5065;branch=z9hG4bK40b7.e646756.0.
> To: .
> From:  >;tag=a6eba7f2b7ff5072ce4465fa3b4415e6-e309.
> 
>
> Any suggestions how to solve this issue very much appreciated.
>
> Kind regards,
> Chris
>
> ___
> Users mailing list
> Users@lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>   


-- 
Bogdan-Andrei Iancu
www.voice-system.ro


___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users


Re: [OpenSIPS-Users] TLS errors

2010-01-15 Thread nir elkayam
hi,

i have recompite/reinstall 1.6.1 (i used 1.6.0 before) and all went smooth
and ok.
i'll check the links u send and validate the error,
for now i have a problem with the TLS client and can't seem to make it work
with eyebeam (certificate issue related).
i'll keep the list updated..

thanks for all the help,
nir

On Fri, Jan 15, 2010 at 6:35 PM, Bogdan-Andrei Iancu  wrote:

> Hi Nir,
>
> I see you manage to start opensips with TLS - what was your error?
>
> for _tls_read -> that is very funny: SSL_read return err 5
> (SSL_ERROR_SYSCALL) which means to look at error stack/return
> value/errno for the real error (the error was geerated somewhere deep in
> the SSL underlayers), but the errno is Success and stack is empty
> :P. Looks like a ghost error...
>
> for tls_accept -> the error is in the stack, and after googling a bit ->
> "obviously the CA that signed your clients is not known to the server.
> Take a look at"
>
>http://www.modssl.org/docs/2.8/ssl_howto.html#ToC6
>http://www.modssl.org/docs/2.8/ssl_reference.html#ToC14
>
>
> Regards,
> Bogdan
>
> nir elkayam wrote:
> > hi,
> >
> > i am using opensips/TLS,
> >
> > i get the following error
> > Jan 14 22:53:54 [19740] ERROR:core:_tls_read: SYSCALL error -> (0)
> > 
> > Jan 14 22:53:54 [19740] ERROR:core:_tls_read: something wrong in SSL: 5
> > Jan 14 22:53:54 [19740] ERROR:core:tcp_read_req: failed to read
> > Jan 14 22:54:46 [19740] ERROR:core:tls_accept: some error in SSL
> > (ret=0, err=1, errno=0/Success):
> > Jan 14 22:54:46 [19740] ERROR:core:tls_print_errstack:
> > error:14094418:SSL routines:SSL3_READ_BYTES:tlsv1 alert unknown ca
> >
> > any hinst about these?
> > actually the client works but error in encryption process is not good,
> > i think
> >
> > thanks
> > 
> >
> > ___
> > Users mailing list
> > Users@lists.opensips.org
> > http://lists.opensips.org/cgi-bin/mailman/listinfo/users
> >
>
>
> --
> Bogdan-Andrei Iancu
> www.voice-system.ro
>
>
> ___
> Users mailing list
> Users@lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>



-- 
ניר אלקיים
טל: 050-3930056
nir.elka...@gmail.com
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users


Re: [OpenSIPS-Users] TLS errors

2010-01-15 Thread Bogdan-Andrei Iancu
Hi Nir,

I see you manage to start opensips with TLS - what was your error?

for _tls_read -> that is very funny: SSL_read return err 5 
(SSL_ERROR_SYSCALL) which means to look at error stack/return 
value/errno for the real error (the error was geerated somewhere deep in 
the SSL underlayers), but the errno is Success and stack is empty 
:P. Looks like a ghost error...

for tls_accept -> the error is in the stack, and after googling a bit -> 
"obviously the CA that signed your clients is not known to the server. 
Take a look at"

http://www.modssl.org/docs/2.8/ssl_howto.html#ToC6
http://www.modssl.org/docs/2.8/ssl_reference.html#ToC14


Regards,
Bogdan

nir elkayam wrote:
> hi,
>
> i am using opensips/TLS,
>
> i get the following error
> Jan 14 22:53:54 [19740] ERROR:core:_tls_read: SYSCALL error -> (0) 
> 
> Jan 14 22:53:54 [19740] ERROR:core:_tls_read: something wrong in SSL: 5
> Jan 14 22:53:54 [19740] ERROR:core:tcp_read_req: failed to read
> Jan 14 22:54:46 [19740] ERROR:core:tls_accept: some error in SSL 
> (ret=0, err=1, errno=0/Success):
> Jan 14 22:54:46 [19740] ERROR:core:tls_print_errstack: 
> error:14094418:SSL routines:SSL3_READ_BYTES:tlsv1 alert unknown ca
>
> any hinst about these?
> actually the client works but error in encryption process is not good, 
> i think
>
> thanks
> 
>
> ___
> Users mailing list
> Users@lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>   


-- 
Bogdan-Andrei Iancu
www.voice-system.ro


___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users


Re: [OpenSIPS-Users] Is RPID being cached?

2010-01-15 Thread Bogdan-Andrei Iancu
Hi Alan,

rpid is in subscriber table and should have nothing to do with usrloc 
(and db_mode).

How do you load the rpid and where do you store it (what kind of variable) ?

Regards,
Bogdan

Alan Frisch wrote:
> I was using memory only for usrloc.  I played around with the
> different modes, then switched back to memory only.  Noticed that the
> RPID would cache when I was testing in non-forked mode, but works as
> expected when forked mode.
>
> Thanks for the help.
>
> On Thu, Jan 14, 2010 at 3:13 PM, Alex Balashov
>  wrote:
>   
>> Depends on your db_mode for the registrar.
>>
>> On 01/14/2010 03:07 PM, Alan Frisch wrote:
>>
>> 
>>> Using OpenSIPs 1.6.1 and have noticed a peculiar issue.
>>>
>>> If a subscriber has a value in the RPID column, then that value is
>>> changed to NULL it seems that OpenSIPs still retains the previous
>>> number.
>>>
>>> For example:
>>>
>>> If RPID column is NULL (initially) --->  if ($avp(s:rpid))) returns FALSE
>>> If RPID column is changed to eg. 1234567890 --->  if ($avp(s:rpid))
>>> returns TRUE and is 1234567890
>>> If RPID column is then changed back to NULL --->  if ($avp(s:rpid))
>>> returns TRUE and is 1234567890
>>>
>>> Is this a bug or a feature?  In either case, is there a way to get
>>> OpenSIPs to only use the current DB value?
>>>
>>> Thanks!
>>>
>>> ___
>>> Users mailing list
>>> Users@lists.opensips.org
>>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>>   
>> --
>> Alex Balashov - Principal
>> Evariste Systems
>> Web : http://www.evaristesys.com/
>> Tel : (+1) (678) 954-0670
>> Direct  : (+1) (678) 954-0671
>>
>> ___
>> Users mailing list
>> Users@lists.opensips.org
>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>
>> 
>
> ___
> Users mailing list
> Users@lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>   


-- 
Bogdan-Andrei Iancu
www.voice-system.ro


___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users


Re: [OpenSIPS-Users] About STUN server configuration

2010-01-15 Thread Bogdan-Andrei Iancu
Hi Yagishita,

What is the error indicated in the logs 
(http://www.opensips.org/Resources/DocsTsStart) ?

Regards,
Bogdan

Koichi Yagishita wrote:
> Dear all,
>
> After configuring the following related to stun in opensips.cfg for my 
> opensips1.6.0, start-up of the opensips failed.
> What else should I configure to work STUN server?
>
> [opensips.cfg]
>
> ### Modules Section 
>
> loadmodule "stun.so"
>
>
> # - stun params -
>
> modparam("stun", "primary_ip", "192.168.100.1")
> modparam("stun", "primary_port", "5060")
> modparam("stun", "alternate_ip", "192.168.1.1")
> modparam("stun", "alternate_port", "3479")
>
>
> Regards,
> Yagishita
>
> ___
> Users mailing list
> Users@lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>   


-- 
Bogdan-Andrei Iancu
www.voice-system.ro


___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users


Re: [OpenSIPS-Users] Error in module permission with db_text

2010-01-15 Thread Bogdan-Andrei Iancu

Hi Leonid,

Looks like there is a compatibility bug between permission and db_text 
modules when comes to DB data typesGive me couple of days to sort 
this out.


In the mean while, if you want to use db_text for permissions, please 
use the attached patch.


Thanks and regards,
Bogdan


Леонид Наседкин wrote:

Hi there.
I'm trying to use permission module with db_text, and it's not 
working, and I can't understand what's wrong.

Opensips 1.6.1 svnrevision: 2:6509

In opensips.cfg:
loadmodule "db_text.so"
modparam("db_text", "db_mode", 0)
loadmodule "permissions.so"
modparam("permissions","db_url", "text:///etc/opensips/dbtext")

In /etc/opensips/dbtext/address:
id(int,auto) grp(int) ip(str) mask(int) port(int) proto(str) 
pattern(str,null) context_info(str,null)

10:1:10.100.0.0:23:5060:udp::
20:1:10.110.0.0:23:5060:udp::
30:1:10.120.0.0:23:5060:udp::

LOG:

DBG:core:init_mod: initializing module permissions
DBG:permissions:mod_init: initializing...
WARNING:permissions:parse_config_file: file not found: 
/etc/opensips/permissions.allow
WARNING:permissions:mod_init: default allow file 
(/etc/opensips/permissions.allow) not found => empty rule set
WARNING:permissions:parse_config_file: file not found: 
/etc/opensips/permissions.deny
WARNING:permissions:mod_init: default deny file 
(/etc/opensips/permissions.deny) not found => empty rule set
DBG:core:find_mod_export: found  in module db_text 
[/usr/lib/opensips/modules/]

DBG:core:db_bind_mod: using db bind api for db_text
INFO:db_text:dbt_init: using database at: /etc/opensips/dbtext/
DBG:db_text:dbt_cache_get_db: looking for db /etc/opensips/dbtext/!
DBG:db_text:dbt_cache_get_db: new db!
DBG:db_text:dbt_load_file: request for table [version]
DBG:db_text:dbt_load_file: db is [/etc/opensips/dbtext/]
DBG:db_text:dbt_load_file: loading file [/etc/opensips/dbtext//version]
DBG:db_text:dbt_table_new: mtime is 1263556066
DBG:db_text:dbt_load_file: column[0] is STR!
DBG:db_text:dbt_load_file: column[1] is INT!
DBG:db_text:dbt_query: new res with 1 cols
DBG:db_text:dbt_result_new: new res with 1 cols
DBG:core:db_new_result: allocate 28 bytes for result set at 0x816b044
DBG:core:db_allocate_columns: allocate 16 bytes for result columns at 
0x816aedc
DBG:core:db_allocate_rows: allocate 28 bytes for result rows and 
values at 0x816b090

DBG:core:db_free_columns: freeing result columns at 0x816aedc
DBG:core:db_free_rows: freeing 1 rows
DBG:core:db_free_row: freeing row values at 0x816b098
DBG:core:db_free_rows: freeing rows at 0x816b090
DBG:core:db_free_result: freeing result set at 0x816b044
DBG:db_text:dbt_load_file: request for table [address]
DBG:db_text:dbt_load_file: db is [/etc/opensips/dbtext/]
DBG:db_text:dbt_load_file: loading file [/etc/opensips/dbtext//address]
DBG:db_text:dbt_table_new: mtime is 1263558311
DBG:db_text:dbt_load_file: column[0] is INT!
DBG:db_text:dbt_load_file: column[1] is INT!
DBG:db_text:dbt_load_file: column[2] is STR!
DBG:db_text:dbt_load_file: column[3] is INT!
DBG:db_text:dbt_load_file: column[4] is INT!
DBG:db_text:dbt_load_file: column[5] is STR!
DBG:db_text:dbt_load_file: column[6] is STR!
DBG:db_text:dbt_load_file: column[7] is STR!
DBG:db_text:dbt_query: new res with 8 cols
DBG:db_text:dbt_result_new: new res with 8 cols
DBG:core:db_new_result: allocate 28 bytes for result set at 0x816b004
DBG:core:db_allocate_columns: allocate 128 bytes for result columns at 
0x8186b68
DBG:core:db_allocate_rows: allocate 504 bytes for result rows and 
values at 0x8186bf4

DBG:permissions:reload_address_table: number of rows in address table: 3
ERROR:permissions:reload_address_table: database problem
DBG:core:db_free_columns: freeing result columns at 0x8186b68
DBG:core:db_free_rows: freeing 3 rows
DBG:core:db_free_row: freeing row values at 0x8186c0c
DBG:core:db_free_row: freeing row values at 0x8186cac
DBG:core:db_free_row: freeing row values at 0x8186d4c
DBG:core:db_free_rows: freeing rows at 0x8186bf4
DBG:core:db_free_result: freeing result set at 0x816b004
CRITICAL:permissions:init_address: reload of address table failed
ERROR:permissions:mod_init: failed to initialize the allow_address 
function

ERROR:core:init_mod: failed to initialize module permissions
ERROR:core:main: error while initializing modules
DBG:db_text:destroy: destroy ...


--
WBR, Leonid Nasedkin
icq: 256816
skype: leonidnasedkin


___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
  



--
Bogdan-Andrei Iancu
www.voice-system.ro

Index: modules/permissions/address.c
===
--- modules/permissions/address.c	(revision 6510)
+++ modules/permissions/address.c	(working copy)
@@ -140,18 +140,18 @@
 		val = ROW_VALUES(row + i);
 
 	if ((ROW_N(row + i) == 8) &&
-			VAL_TYPE(val) == DB_STRING && !VAL_NULL(val) &&
+			VAL_TYPE(val) == DB_STR && !

[OpenSIPS-Users] Error in module permission with db_text

2010-01-15 Thread Леонид Наседкин
Hi there.
I'm trying to use permission module with db_text, and it's not working, and
I can't understand what's wrong.
Opensips 1.6.1 svnrevision: 2:6509

In opensips.cfg:
  loadmodule "db_text.so"
  modparam("db_text", "db_mode", 0)
  loadmodule "permissions.so"
  modparam("permissions","db_url", "text:///etc/opensips/dbtext")

In /etc/opensips/dbtext/address:
  id(int,auto) grp(int) ip(str) mask(int) port(int) proto(str)
pattern(str,null) context_info(str,null)
  10:1:10.100.0.0:23:5060:udp::
  20:1:10.110.0.0:23:5060:udp::
  30:1:10.120.0.0:23:5060:udp::

LOG:

DBG:core:init_mod: initializing module permissions
DBG:permissions:mod_init: initializing...
WARNING:permissions:parse_config_file: file not found:
/etc/opensips/permissions.allow
WARNING:permissions:mod_init: default allow file
(/etc/opensips/permissions.allow) not found => empty rule set
WARNING:permissions:parse_config_file: file not found:
/etc/opensips/permissions.deny
WARNING:permissions:mod_init: default deny file
(/etc/opensips/permissions.deny) not found => empty rule set
DBG:core:find_mod_export: found  in module db_text
[/usr/lib/opensips/modules/]
DBG:core:db_bind_mod: using db bind api for db_text
INFO:db_text:dbt_init: using database at: /etc/opensips/dbtext/
DBG:db_text:dbt_cache_get_db: looking for db /etc/opensips/dbtext/!
DBG:db_text:dbt_cache_get_db: new db!
DBG:db_text:dbt_load_file: request for table [version]
DBG:db_text:dbt_load_file: db is [/etc/opensips/dbtext/]
DBG:db_text:dbt_load_file: loading file [/etc/opensips/dbtext//version]
DBG:db_text:dbt_table_new: mtime is 1263556066
DBG:db_text:dbt_load_file: column[0] is STR!
DBG:db_text:dbt_load_file: column[1] is INT!
DBG:db_text:dbt_query: new res with 1 cols
DBG:db_text:dbt_result_new: new res with 1 cols
DBG:core:db_new_result: allocate 28 bytes for result set at 0x816b044
DBG:core:db_allocate_columns: allocate 16 bytes for result columns at
0x816aedc
DBG:core:db_allocate_rows: allocate 28 bytes for result rows and values at
0x816b090
DBG:core:db_free_columns: freeing result columns at 0x816aedc
DBG:core:db_free_rows: freeing 1 rows
DBG:core:db_free_row: freeing row values at 0x816b098
DBG:core:db_free_rows: freeing rows at 0x816b090
DBG:core:db_free_result: freeing result set at 0x816b044
DBG:db_text:dbt_load_file: request for table [address]
DBG:db_text:dbt_load_file: db is [/etc/opensips/dbtext/]
DBG:db_text:dbt_load_file: loading file [/etc/opensips/dbtext//address]
DBG:db_text:dbt_table_new: mtime is 1263558311
DBG:db_text:dbt_load_file: column[0] is INT!
DBG:db_text:dbt_load_file: column[1] is INT!
DBG:db_text:dbt_load_file: column[2] is STR!
DBG:db_text:dbt_load_file: column[3] is INT!
DBG:db_text:dbt_load_file: column[4] is INT!
DBG:db_text:dbt_load_file: column[5] is STR!
DBG:db_text:dbt_load_file: column[6] is STR!
DBG:db_text:dbt_load_file: column[7] is STR!
DBG:db_text:dbt_query: new res with 8 cols
DBG:db_text:dbt_result_new: new res with 8 cols
DBG:core:db_new_result: allocate 28 bytes for result set at 0x816b004
DBG:core:db_allocate_columns: allocate 128 bytes for result columns at
0x8186b68
DBG:core:db_allocate_rows: allocate 504 bytes for result rows and values at
0x8186bf4
DBG:permissions:reload_address_table: number of rows in address table: 3
ERROR:permissions:reload_address_table: database problem
DBG:core:db_free_columns: freeing result columns at 0x8186b68
DBG:core:db_free_rows: freeing 3 rows
DBG:core:db_free_row: freeing row values at 0x8186c0c
DBG:core:db_free_row: freeing row values at 0x8186cac
DBG:core:db_free_row: freeing row values at 0x8186d4c
DBG:core:db_free_rows: freeing rows at 0x8186bf4
DBG:core:db_free_result: freeing result set at 0x816b004
CRITICAL:permissions:init_address: reload of address table failed
ERROR:permissions:mod_init: failed to initialize the allow_address function
ERROR:core:init_mod: failed to initialize module permissions
ERROR:core:main: error while initializing modules
DBG:db_text:destroy: destroy ...


-- 
WBR, Leonid Nasedkin
icq: 256816
skype: leonidnasedkin
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users


[OpenSIPS-Users] cdrtool always returning postpaid

2010-01-15 Thread Nguyen Quang Tri
Hello , i have prolem like this.

This is my log file

" call-control[18241]: Call id 
OTZmMTRlZTlkY2MyNjRhOThhMDQwNjcwYjg5MGU0Nzk. of 1...@x to 
sip:18005558...@xx:5065 is postpaid not limited"


Here ,This is my tables

mysql> select * from prepaid;
++-+-+--+-+-+-+--+
| id | reseller_id | account | balance  | 
change_date | active_sessions | session_counter | max_sessions |
++-+-+--+-+-+-+--+
|  2 |   0 | 1...@xxx   | 100. | -00-00 00:00:00 
| |   1 |1 |
++-+-+--+-+-+-+--+

mysql> select * from billing_customers;
++-+-+++---+---+---+---++
| id | reseller_id | gateway | domain | subscriber | 
profile_name1 | profile_name1_alt | profile_name2 | profile_name2_alt | 
timezone   |
++-+-+++---+---+---+---++
|  3 |   0 | |  
|| carina|   |   
|   | Asia/HoChiMinh |
++-+-+++---+---+---+---++

select * from billing_profiles;
++-+++---++---++---++---+
| id | reseller_id | name   | rate_name1 | hour1 | rate_name2 | hour2 | 
rate_name3 | hour3 | rate_name4 | hour4 |
++-+++---++---++---++---+
|  3 |   0   | carina | carina |18 |
| 0 || 0 || 0 |
++-+++---++---++---++---+

select * from billing_rates ;

++-++-+-+-+--+---++
| id | reseller_id | name   | destination | application | connectCost | 
durationRate | connectCostIn | durationRateIn |
++-++-+-+-+--+---++
|  5|   0 | carina | 1   | audio   | 
0   | 150  |   | 150|
++-++-+-+-+--+---++

select * from destinations;
++-+-+++-+---+---+--+--+---+
| id | reseller_id | gateway | domain | subscriber | dest_id 
| dest_name | increment | min_duration | max_duration | max_price |
++-+-+++-+---+---+--+--+---+
|  2 |   0  | | xx || 
1   | USA   | 0 |0 |0 |   |
++-+-+++-+---+---+--+--+---+


I have changed E164 class to E164_US in file global .inc

Pls help me fix it.Thank you.



___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users