[Asterisk-Users] REGISTER Problems With Realtime

[Michael Shuler]

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
>