[Asterisk-Users] REGISTER Problems With Realtime

Michael Shuler mike at bwsys.net
Thu Jan 13 18:05:02 MST 2005


Why is the SELECT statement below putting a "?" in for the username?  I am
using today's CVS.

Jan 13 18:48:41 WARNING[7570]: res_config_odbc.c:105 realtime_odbc: SQL
Execute error!
[SELECT * FROM sip_buddies WHERE name = ?]



Full dump:

Sip read: 
REGISTER sip:198.88.216.85 SIP/2.0
Via: SIP/2.0/UDP 192.168.1.2:5060;branch=z9hG4bK-ffmzndpfrao2;rport
From: "Mike's Peoria Snom"
<sip:MikePeoriaSnom___1 at 198.88.216.85>;tag=ljql3vjulo
To: "Mike's Peoria Snom" <sip:MikePeoriaSnom___1 at 198.88.216.85>
Call-ID: 3c4c743d4841-8oaq4jsghi78 at 192-168-1-2
CSeq: 106321 REGISTER
Max-Forwards: 70
Contact: <sip:MikePeoriaSnom___1 at 192.168.1.2:5060;line=d313mbjt>;q=1.0
User-Agent: snom200-3.56m
P-NAT-Refresh: 15
Supported: gruu
Allow-Events: dialog
X-Real-IP: 192.168.1.2
WWW-Contact: <http://192.168.1.2:80>
WWW-Contact: <https://192.168.1.2:443>
Expires: 60
Content-Length: 0


17 headers, 0 lines
Using latest request as basis request
Sending to 192.168.1.2 : 5060 (NAT)
Jan 13 18:48:41 WARNING[7570]: res_config_odbc.c:105 realtime_odbc: SQL
Execute error!
[SELECT * FROM sip_buddies WHERE name = ?]

Transmitting (NAT):
SIP/2.0 403 Forbidden
Via: SIP/2.0/UDP
192.168.1.2:5060;branch=z9hG4bK-ffmzndpfrao2;received=206.222.58.98;rport=32
777
From: "Mike's Peoria Snom"
<sip:MikePeoriaSnom___1 at 198.88.216.85>;tag=ljql3vjulo
To: "Mike's Peoria Snom"
<sip:MikePeoriaSnom___1 at 198.88.216.85>;tag=as01156a34
Call-ID: 3c4c743d4841-8oaq4jsghi78 at 192-168-1-2
CSeq: 106321 REGISTER
User-Agent: Asterisk PBX
Allow: INVITE, ACK, CANCEL, OPTIONS, BYE, REFER
Contact: <sip:MikePeoriaSnom___1 at 198.88.216.85>
Content-Length: 0


 to 206.222.58.98:32777
Jan 13 18:48:41 NOTICE[7570]: chan_sip.c:8036 handle_request: Registration
from '"Mike's Peoria Snom" <sip:MikePeoriaSnom___1 at 198.88.216.85>' failed
for '206.222.58.98'
Scheduling destruction of call '3c4c743d4841-8oaq4jsghi78 at 192-168-1-2' in
15000 ms

----------------------------------------

Mike




More information about the asterisk-users mailing list