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:[EMAIL PROTECTED]>' 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 > [email protected] > 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 [EMAIL PROTECTED] Heritage Communications Corporation Melbourne, FL USA 32935 321.308.4000 x33 http://www.hcc.net _______________________________________________ Asterisk-Users mailing list [email protected] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
