MySQL but its using the ODBC driver. ----------------------------------------
Michael Shuler, C.E.O. BitWise Communications, Inc. (CLEC) And BitWise Systems, Inc. (ISP) 682 High Point Lane East Peoria, IL 61611 Office: (217) 585-0357 Cell: (309) 657-6365 Fax: (309) 213-3500 E-Mail: [EMAIL PROTECTED] Customer Service: (877) 976-0711 > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Matthew Boehm > Sent: Friday, January 14, 2005 9:56 AM > To: Asterisk Users Mailing List - Non-Commercial Discussion > Subject: Re: [Asterisk-Users] REGISTER Problems With Realtime > > > 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 > _______________________________________________ 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
