I have no idea how ODBC converts a prepared statement to MySQL when only up until 4.1 did mysql support them. Have you tried using res_config_mysql inside asterisk-addons?
-Matthew ----- Original Message ----- From: "Michael Shuler" <[EMAIL PROTECTED]> To: "'Asterisk Users Mailing List - Non-Commercial Discussion'" <[email protected]> Sent: Friday, January 14, 2005 12:24 PM Subject: RE: [Asterisk-Users] REGISTER Problems With Realtime > 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 _______________________________________________ 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
