Its trying to prepare a statement. What database are you using?
-Matthew
----- Original Message -----
From: "Michael Shuler" <mike@bwsys.net>
To: "'Asterisk Users Mailing List - Non-Commercial
Discussion'"
<asterisk-users@lists.digium.com>
Sent: Thursday, January 13, 2005 7:05 PM
Subject: [Asterisk-Users] REGISTER Problems With Realtime
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@198.88.216.85>;tag=ljql3vjulo
To: "Mike's Peoria Snom"
<sip:MikePeoriaSnom___1@198.88.216.85>
Call-ID: 3c4c743d4841-8oaq4jsghi78@192-168-1-2
CSeq: 106321 REGISTER
Max-Forwards: 70
Contact: <sip:MikePeoriaSnom___1@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@198.88.216.85>;tag=ljql3vjulo
To: "Mike's Peoria Snom"
<sip:MikePeoriaSnom___1@198.88.216.85>;tag=as01156a34
Call-ID: 3c4c743d4841-8oaq4jsghi78@192-168-1-2
CSeq: 106321 REGISTER
User-Agent: Asterisk PBX
Allow: INVITE, ACK, CANCEL, OPTIONS, BYE, REFER
Contact: <sip:MikePeoriaSnom___1@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@198.88.216.85>' failed
for '206.222.58.98'
Scheduling destruction of call '3c4c743d4841-8oaq4jsghi78@192-168-1-2'
in
15000 ms
----------------------------------------
Mike
_______________________________________________
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