It was a very misleading error. I had the DB name spelled wrong in my /etc/odbc.ini... You would think it would give a more intuitive error than that.
---------------------------------------- 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 1:05 PM > To: Asterisk Users Mailing List - Non-Commercial Discussion > Subject: Re: [Asterisk-Users] REGISTER Problems With Realtime > > > 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 > _______________________________________________ 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
