[Asterisk-Users] Realtime sipbuddies table structure why?????

[Brian Wilkins]

I also have additional columns in my MySQL sip_buddies table with no problems. 
If there is a problem updating, selecting, or inserting into your table then 
you should check your MySQL Configuration or verifiy that it is working 
properly.

On Thursday 23 December 2004 05:10 pm, Matthew Boehm wrote:
> > Dec 23 09:24:57 NOTICE[12406]: chan_sip.c:7742 handle_request:
> > Registration from '<sip:52221 at 192.168.70.2>' failed for '192.168.70.26'
> >
> > happens with app_realtime, doesn't happen without realtime
> >
> > there are previous posts identifying issues with this.
>
>     All I can say on this is that I am using todays CVS and I've got no
> problems with phones registering using RealTime.
>
> > for example, host, secret, context, ipaddr, port, regseconds
> > should not be column names, they should be data points with an
> > associated column to contain the related value(s)
>
>     Why? How is that an optimization when the data is specific to each row?
> Out of personal curiosity can you give me a sample schema?
>
> >  From what I can see, i can't add a column say musicclass = something,
> > or pedantic = yes like I could in the conf file and have it mean
> > anything.
>
>     Yes you can. If you wanted to add the following in the flat file:
>
> [sipname]
> mycustomkeya = valuea
> mycustomkeyb = valueb
>
>  all you have to do is add 2 columns, mycustomkeya and mycustomkeyb. I've
> added 4 custom columns to my sip table. No problems. Granted they have
> nothing to do with SIP itself..
>
> -Matthew
>
> _______________________________________________
> Asterisk-Users mailing list
> Asterisk-Users at lists.digium.com
> http://lists.digium.com/mailman/listinfo/asterisk-users
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-users

-- 
Brian Wilkins
Software Engineer
brian at hcc.net

Heritage Communications Corporation
  Melbourne, FL     USA     32935
321.308.4000 x33
http://www.hcc.net