asterisk users - Nov 2008 - What are the minimum realtime fields for sipusers?

I'm trying to get sipusers working with a realtime odbc database on  
Asterisk 1.6.  We have sippeers working from the database, but need  
sipusers to be in a separate table for other implementation reasons.

sip show user test load returns results from the database.

CLI> sip show user test load

   * Name       : test
   Secret       : <Set>
   MD5Secret    : <Not set>
   Context      : inbound
   Language     :
   AMA flags    : Unknown
   Transfer mode: open
   MaxCallBR    : 384 kbps
   CallingPres  : Presentation Allowed, Not Screened
   Call limit   : 0
   Callgroup    :
   Pickupgroup  :
   Callerid     : "" <>
   ACL          : No
   Sess-Timers  : Accept
   Sess-Refresh : uas
   Sess-Expires : 1800 secs
   Sess-Min-SE  : 90 secs
   Codec Order  : (none)
   Auto-Framing:  No

But when the user tries to register, the registration fails.

[Nov 12 11:59:18] NOTICE[16779]: chan_sip.c:18293  
handle_request_register: Registration from '<sip:test at
domain.com>'
failed for '10.10.10.10' - No matching peer found

What are the minimum fields required for the sipusers table?

Currently we have:
name        |        secret        | type | nat |  host   |  context    
| qualify | regserver | regseconds

Also is there a way to enable debugging to show the SQL calls being  
made to the database?

--
Eric Chamberlain

To answer my own question after reviewing chan_sip.c.

sipusers has been de-implemented in 1.6.0.1 and doesn't do anything  
anymore other than appear in sip show settings.

On Nov 12, 2008, at 9:04 AM, Eric Chamberlain wrote:
> I'm trying to get sipusers working with a realtime odbc database on
> Asterisk 1.6.  We have sippeers working from the database, but need
> sipusers to be in a separate table for other implementation reasons.
>
> sip show user test load returns results from the database.
>
> CLI> sip show user test load
>
>   * Name       : test
>   Secret       : <Set>
>   MD5Secret    : <Not set>
>   Context      : inbound
>   Language     :
>   AMA flags    : Unknown
>   Transfer mode: open
>   MaxCallBR    : 384 kbps
>   CallingPres  : Presentation Allowed, Not Screened
>   Call limit   : 0
>   Callgroup    :
>   Pickupgroup  :
>   Callerid     : "" <>
>   ACL          : No
>   Sess-Timers  : Accept
>   Sess-Refresh : uas
>   Sess-Expires : 1800 secs
>   Sess-Min-SE  : 90 secs
>   Codec Order  : (none)
>   Auto-Framing:  No
>
> But when the user tries to register, the registration fails.
>
> [Nov 12 11:59:18] NOTICE[16779]: chan_sip.c:18293
> handle_request_register: Registration from '<sip:test at
domain.com>'
> failed for '10.10.10.10' - No matching peer found
>
> What are the minimum fields required for the sipusers table?
>
> Currently we have:
> name        |        secret        | type | nat |  host   |  context
> | qualify | regserver | regseconds
>
> Also is there a way to enable debugging to show the SQL calls being
> made to the database?
>
> --
> Eric Chamberlain
>
>
>
>
>
>
>
> _______________________________________________
> -- Bandwidth and Colocation Provided by http://www.api-digital.com --
>
> asterisk-users mailing list
> To UNSUBSCRIBE or update options visit:
>   http://lists.digium.com/mailman/listinfo/asterisk-users
--
Eric Chamberlain, Founder
RF.com - http://RF.com/