[Asterisk-Dev] ast_data pgsql

[Rob Gagnon]

:-)  I see the error in the code now.  I am fixing it, and maybe by the time
you get this, it will be available at

http://svn.asteriskdocs.org/res_data

The issue is that the Default SQL I changed code to a little while back has
a SELECT *, but the code to read the fields is positional for that
data_pgsql function

Eventually, it will scan the row for the field name it needs, and this will
make it more able to handle queries of this sort.

Rob

----- Original Message ----- 
From: "Dmitri Pavlenkov" <dmitri at im1.com>
To: <asterisk-dev at lists.digium.com>
Sent: Friday, July 16, 2004 2:57 PM
Subject: [Asterisk-Dev] ast_data pgsql


I think everything's setup correctly, and yet extension lookup is not
working:

iptel1=> \d extensions
                              Table "public.extensions"
   Column    |          Type          |                   Modifiers

-------------+------------------------+---------------------------------
--------------
 context     | character varying(40)  | not null default
'default'::character varying
 extension   | character varying(20)  | not null
 priority    | integer                | not null default 1
 application | character varying(20)  | not null
 args        | character varying(100) | not null default ''::character
varying
Indexes: extensions_pkey primary key btree (context, extension,
priority)

iptel1=> select * from extensions
iptel1-> ;
 context | extension | priority | application |      args
---------+-----------+----------+-------------+-----------------
 dbtest  | s         |        1 | Festival    | test successful
 im1     | 999       |        1 | Goto        | dbtest|s|1
(2 rows)

paska*CLI> show data pgsql status
========================================================================
======
Database: iptel1 at db.x.x:5432
Queries Handled:
     EXTENSION_LOOKUP
ID      In/Out  Reads   Writes  Deletes Status
  1     In           8       0       0  Connected 0 days, 00:03:48
  2     In           0       0       0  Connected 0 days, 00:03:48
  3     In           0       0       0  Connected 0 days, 00:03:48
========================================================================
======

 == Request:
  == ==== Packet Dump ====
  == Query Type: SIP_FIND_USER
  == (100)Name = (STR)"dmitri"
  == ==== End of Packet Dump ====
  == Response:
  == Request:
  == ==== Packet Dump ====
  == Query Type: SIP_FIND_USER
  == (100)Name = (STR)"dmitri"
  == ==== End of Packet Dump ====
  == Response:
  == Request:
  == ==== Packet Dump ====
  == Query Type: SIP_FIND_USER
  == (100)Name = (STR)"dmitri"
  == ==== End of Packet Dump ====
  == Response:
  == Request:
  == ==== Packet Dump ====
  == Query Type: EXTENSION_LOOKUP
  == (114)Extension = (STR)"999"
  == (110)Context = (STR)"im1"
  == (115)Priority = (INT)1
  == (134)Action = (INT)0
  == ==== End of Packet Dump ====
  == Response:
  == ==== Packet Dump ====
  == Query Type: EXTENSION_LOOKUP
  == (20)DataSource = (STR)"pgsql"
  == (10)ErrorNumber = (INT)-9
  == (11)ErrorMessage = (STR)"Not found"
  == ==== End of Packet Dump ====
  == Request:
  == ==== Packet Dump ====
  == Query Type: EXTENSION_LOOKUP
  == (114)Extension = (STR)"999"
  == (110)Context = (STR)"im1"
  == (115)Priority = (INT)1
  == (134)Action = (INT)3
  == ==== End of Packet Dump ====
  == Response:
  == ==== Packet Dump ====
  == Query Type: EXTENSION_LOOKUP
  == (20)DataSource = (STR)"pgsql"
  == (114)Extension = (STR)"im1"
  == (116)Application = (STR)"999"
  == (117)Arguments = (STR)"1"
  == (10)ErrorNumber = (INT)0
  == (11)ErrorMessage = (STR)"OK"
  == ==== End of Packet Dump ====
  == Request:
  == ==== Packet Dump ====
  == Query Type: SIP_FIND_USER
  == (100)Name = (STR)"dmitri"
  == ==== End of Packet Dump ====
  == Response:


Dmitri Pavlenkov
Technical Support
Im1 Web Hosting


_______________________________________________
Asterisk-Dev mailing list
Asterisk-Dev at lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-dev
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-dev