Martijn van Oosterhout wrote:
On Wed, Mar 16, 2005 at 03:25:17PM +0800, Ronald Wiplinger wrote:
Mar 16 15:13:45 DEBUG[29502]: Raw Hangup 69.73.19.178:4569, src=14, dst=1259
Mar 16 15:13:45 DEBUG[29502]: MySQL RealTime: Update SQL: UPDATE sip_buddies SET name = '621' WHERE allow = 'g729'
Mar 16 15:13:45 DEBUG[29502]: MySQL RealTime: Everything is fine.
Mar 16 15:13:45 DEBUG[29502]: MySQL RealTime: Updated 0 rows on table: sip_buddies
*ALARM* Where is that query fron? It's totally wrong! It just changed the name of anyone who is allowed to use g729.
Looks like Realtime is not quite there yet for production...
Have a nice day,
vpbx*CLI> help realtime update
Usage: realtime update <family> <colmatch> <value>
Update a single variable using the RealTime driver.(I guess Matthew typed to fast to give me the hint, ...)
Thanks for pointing it out, it should therefore be:
vpbx*CLI> realtime update sippeers name 621 allow ulaw,alaw
However, it shows:
vpbx*CLI> realtime load sippeers name 621
Column Name Column Value -------------------- -------------------- id 1 name 621 callerid "Demo",<621> canreinvite yes context inhouse dtmfmode rfc2833 host dynamic mailbox [EMAIL PROTECTED] nat yes pickupgroup 1 qualify 999 secret Morgen621 type friend username 621 allow ulaw,alaw disallow all regseconds 0 cancallforward yes
... so it has updated it!!!
... but:
vpbx*CLI> sip show peer 621 vpbx*CLI>
* Name : 621 Secret : <Set> MD5Secret : <Not set> Context : inhouse Language : AMA flags : Unknown CallingPres : Presentation Allowed, Not Screened Callgroup : Pickupgroup : 1, 33 Mailbox : [EMAIL PROTECTED] LastMsgsSent : 2 Inc. limit : 0 Outg. limit : 0 Dynamic : Yes Callerid : "Demo" <621> Expire : 140506 Expiry : 900 Insecure : no Nat : Always ACL : No CanReinvite : Yes PromiscRedir : No User=Phone : No DTMFmode : rfc2833 LastMsg : 0 ToHost : Addr->IP : 192.168.250.114 Port 5060 Defaddr->IP : 0.0.0.0 Port 5060 Def. Username: 621 Codecs : 0x0 (nothing) Codec Order : (none) Status : OK (5 ms) Useragent : Grandstream BT100 1.0.5.18 Full Contact : sip:[EMAIL PROTECTED]:64655
so, two different ways of the same query gives two different results!
I agree with you, ... there is something not completely working ;-)
bye
Ronald
-- Ronald Wiplinger (CEO of ELMIT) http://www.elmit.com +886 (0) 939--77-55-16 or FWD 511208 - I'm a SpamCon Foundation Member, #694, Verify it at http://www.spamcon.org
PS: Spam prevention!
Our system is protected with a spam prevention program. If you send us an e-mail, our system will send you a confirmation message back. Just reply to this confirmation message please. After receiving this confirmation message, our system will send the hold message (one) and all future messages (after the received confirmation message) to me without asking you again.
_______________________________________________ Asterisk-Users mailing list Asterisk-Users@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
