[asterisk-bugs] [Asterisk 0012576]: PgSQL Search on SIP table for SIP Channel

[noreply at bugs.digium.com]

The following issue has been SUBMITTED. 
====================================================================== 
http://bugs.digium.com/view.php?id=12576 
====================================================================== 
Reported By:                elbriga
Assigned To:                
====================================================================== 
Project:                    Asterisk
Issue ID:                   12576
Category:                   Resources/res_config_pgsql
Reproducibility:            always
Severity:                   minor
Priority:                   normal
Status:                     new
Asterisk Version:           1.4.19 
SVN Branch (only for SVN checkouts, not tarball releases): N/A 
SVN Revision (number only!):  
Disclaimer on File?:        N/A 
Request Review:              
====================================================================== 
Date Submitted:             05-02-2008 20:32 CDT
Last Modified:              05-02-2008 20:32 CDT
====================================================================== 
Summary:                    PgSQL Search on SIP table for SIP Channel
Description: 
My Asterisk 1.4.19 instalation is using teh PostgreSQL RealTime, and it
tries to do a select on the SIP table looking for a SIP channel. I
remebmber have seen this issue on the MySQL driver some time ago.

Is this a bug?

With debug on it shows:
SELECT * FROM sip WHERE name = 'cac01-0827e8d0' AND host = 'dynamic'

It happens after I register the "cac01" account and call the "6000"
extension, (statically) configured for playing MOH.
====================================================================== 

Issue History 
Date Modified   Username       Field                    Change               
====================================================================== 
05-02-08 20:33  elbriga        Asterisk Version          => 1.4.19          
05-02-08 20:33  elbriga        SVN Branch (only for SVN checkou => N/A          
  
======================================================================