[Asterisk-Users] REGISTER Problems With Realtime

Matthew Boehm mboehm at cytelcom.com
Fri Jan 14 12:04:35 MST 2005


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




More information about the asterisk-users mailing list