Matthew Boehm wrote:
I tried that:Is there anything I can do to track down the problem? e.g., is there a
command in *CLI to read the database record? push a record, see the
differences, ...
You can try this:
realtime update sippeers allow g729 name 621
That should be the SQL equivalent to "UPDATE TABLE sippeers SET allow = 'g729' WHERE name = '621'
If you type just "realtime update" that will give you some info.
You can also do "realtime load sippeers name 621"
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 Mosaic621 type friend username 621 allow g729,ulaw,alaw disallow all regseconds 0 cancallforward yes
but sip show peer still keeps
Codecs : 0x0 (nothing) Codec Order : (none)
I tried vpbx*CLI> realtime update sippeers allow g729 name 621 Failed to update. Check the debug log for possible SQL related entries. vpbx*CLI>
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
That is a joke ;-) Everything is fine and updated 0 rows!!!
*CLI says still for a call:
Mar 16 15:13:45 NOTICE[29502]: chan_sip.c:2917 process_sdp: No compatible codecs!
vpbx:/etc/asterisk # cat res_mysql.conf ;;; odbc setup file [general] dbhost = 127.0.0.1 dbname = astconf dbuser = root dbpass = MyPassword dbport = 3306 dbsock = =/var/lib/mysql/mysql.sock
[mysql1] dsn => astconf username => root password => MyPassword pre-connect => yes
_______________________________________________ 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
