[Asterisk-Users] REGISTER Problems With Realtime

Fri Jan 14 21:42:24 MST 2005

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: mike at bwsys.net
Customer Service: (877) 976-0711 

> -----Original Message-----
> From: asterisk-users-bounces at lists.digium.com 
> [mailto:asterisk-users-bounces at lists.digium.com] 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" <mike at bwsys.net>
> To: "'Asterisk Users Mailing List - Non-Commercial Discussion'"
> <asterisk-users at lists.digium.com>
> 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: mike at bwsys.net
> > Customer Service: (877) 976-0711
> >
> > > -----Original Message-----
> > > From: asterisk-users-bounces at lists.digium.com
> > > [mailto:asterisk-users-bounces at lists.digium.com] 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" <mike at bwsys.net>
> > > To: "'Asterisk Users Mailing List - Non-Commercial Discussion'"
> > > <asterisk-users at 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 at 198.88.216.85>;tag=ljql3vjulo
> > > To: "Mike's Peoria Snom" <sip:MikePeoriaSnom___1 at 198.88.216.85>
> > > Call-ID: 3c4c743d4841-8oaq4jsghi78 at 192-168-1-2
> > > CSeq: 106321 REGISTER
> > > Max-Forwards: 70
> > > Contact: 
> <sip:MikePeoriaSnom___1 at 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 at 198.88.216.85>;tag=ljql3vjulo
> > > To: "Mike's Peoria Snom"
> > > <sip:MikePeoriaSnom___1 at 198.88.216.85>;tag=as01156a34
> > > Call-ID: 3c4c743d4841-8oaq4jsghi78 at 192-168-1-2
> > > CSeq: 106321 REGISTER
> > > User-Agent: Asterisk PBX
> > > Allow: INVITE, ACK, CANCEL, OPTIONS, BYE, REFER
> > > Contact: <sip:MikePeoriaSnom___1 at 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 at 198.88.216.85>' failed
> > > for '206.222.58.98'
> > > Scheduling destruction of call
> > > '3c4c743d4841-8oaq4jsghi78 at 192-168-1-2' in
> > > 15000 ms
> > >
> > > ----------------------------------------
> > >
> > > Mike
> > >
> > > _______________________________________________
> > > Asterisk-Users mailing list
> > > Asterisk-Users at 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
> > >
> > > _______________________________________________
> > > Asterisk-Users mailing list
> > > Asterisk-Users at 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
> > >
> >
> > _______________________________________________
> > Asterisk-Users mailing list
> > Asterisk-Users at 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
> 
> _______________________________________________
> Asterisk-Users mailing list
> Asterisk-Users at 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
> 