asterisk users - Oct 2004 - BUG? no output from 'sip show users|inuse|active|subscriptions' when using MySQL auth

I'm authenticating against sipfriends in MySQL, and have just noticed 
that none of the below commands return any output:

sip show users
sip show inuse
sip show active
sip show subscriptions


Is this a bug or something wrong on my side?
I'm using the stable 1.0 cvs

Vahan

> -----Original Message-----
> From: Vahan Yerkanian [mailto:vahan@arminco.com] 
> Sent: Friday, October 01, 2004 2:42 PM
> To: Asterisk Users Mailing List - Non-Commercial Discussion
> Subject: [Asterisk-Users] BUG? no output from 'sip show 
> users|inuse|active|subscriptions' when using MySQL auth
> 
> 
> I'm authenticating against sipfriends in MySQL, and have just noticed 
> that none of the below commands return any output:
> 
> sip show users
> sip show inuse
> sip show active
> sip show subscriptions
> 
> 
> Is this a bug or something wrong on my side?
> I'm using the stable 1.0 cvs
> 
It is niether.  Since the sip users/peers are looked up everytime
you access them, they are not contained in the in-memory structures
which are the basis for those commands.  This is just an inherant
difference in structure.  The only way to get that information would
be to query it everytime, unless it is loaded up into memory. (Which
makes a reload necessary to see changes)

Another thing that you will notice that will not work is voicemail
waiting indicator.  You can still receive e-mails when a voicemail is
left, but you can't get the indicator light to work on the phone.

For an alternative to the dynamic loading of config info take a look
at res_config_odbc which will allow you to load it up from the DB 
into the normal memory structures.

Robert Jackson