Its trying to prepare a statement. What database are you using? -Matthew
----- Original Message ----- From: "Michael Shuler" <[EMAIL PROTECTED]> To: "'Asterisk Users Mailing List - Non-Commercial Discussion'" <[email protected]> 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:[EMAIL PROTECTED]>;tag=ljql3vjulo To: "Mike's Peoria Snom" <sip:[EMAIL PROTECTED]> Call-ID: [EMAIL PROTECTED] CSeq: 106321 REGISTER Max-Forwards: 70 Contact: <sip:[EMAIL PROTECTED]: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:[EMAIL PROTECTED]>;tag=ljql3vjulo To: "Mike's Peoria Snom" <sip:[EMAIL PROTECTED]>;tag=as01156a34 Call-ID: [EMAIL PROTECTED] CSeq: 106321 REGISTER User-Agent: Asterisk PBX Allow: INVITE, ACK, CANCEL, OPTIONS, BYE, REFER Contact: <sip:[EMAIL PROTECTED]> 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:[EMAIL PROTECTED]>' failed for '206.222.58.98' Scheduling destruction of call '[EMAIL PROTECTED]' in 15000 ms ---------------------------------------- Mike _______________________________________________ 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 _______________________________________________ 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
