[asterisk-users] asterisk realtime SIP configuration

[Murali Vasu]

Hi All,


     I am trying to configure asterisk realtime. But i am unable to get the
extensions listed successfully when i type "sip show peers" in the asterisk
CLI . i am unable to see any failure logs when i do a reload

     i can able to connect to the data source through "odbc show" in the
CLI, Any hep in this regard is highly appreciated. Following is the
configuration and specification.

     *Server Specification:*

        1) asterisk-1.6.2.6
        2) CentOS- 5.2 (64-bit)
        3) Postgresql- 8.1

     *Configuration:*

    * odbc.ini*

     [PostgreSQL]
Description         = Test to Postgres
Driver              = PostgreSQL
Trace               = Yes
TraceFile           = /tmp/sql.log
Database            = bedrock
Servername          = localhost
UserName            =
Password            =
Port                = 5432
Protocol            = 6.4
ReadOnly            = No
RowVersioning       = No
ShowSystemTables    = No
ShowOidColumn       = No
FakeOidIndex        = No
ConnSettings        =

     *odbcinst.ini*

[PostgreSQL]
Description     = ODBC for PostgreSQL
Driver          = /usr/lib64/libodbcpsql.so
Setup           = /usr/lib64/libodbcpsqlS.so
FileUsage       = 1

   * res_odbc.conf*

[postgres]
enabled => yes
dsn => PostgreSQL
username =>postgres
password =>postgres
pre-connect => yes


    *Database table in postgres "sip" :*

     Column     |          Type          |                    Modifiers
----------------+------------------------+--------------------------------------------------
 id             | integer                | not null default
nextval('sip_id_seq'::regclass)
 name           | character varying(80)  | not null
 accountcode    | character varying(20)  |
 amaflags       | character varying(7)   |
 callgroup      | character varying(10)  |
 callerid       | character varying(80)  |
 directmedia    | character varying(3)   | default 'yes'::character varying
 context        | character varying(80)  | default 'default'::character
varying
 defaultip      | character varying(15)  |
 dtmfmode       | character varying(7)   |
 fromuser       | character varying(80)  |
 fromdomain     | character varying(80)  |
 host           | character varying(31)  | not null default
'dynamic'::character varying
 insecure       | character varying(4)   |
 language       | character varying(2)   |
 mailbox        | character varying(50)  |
 md5secret      | character varying(80)  |
 nat            | character varying(5)   | not null default 'no'::character
varying
 permit         | character varying(95)  |
 deny           | character varying(95)  |
 mask           | character varying(95)  |
 pickupgroup    | character varying(10)  |
 port           | character varying(5)   |
 qualify        | character varying(3)   |
 restrictcid    | character varying(1)   |
 rtptimeout     | character varying(3)   |
 rtpholdtimeout | character varying(3)   |
 secret         | character varying(80)  |
 type           | character varying      | not null default
'friend'::character varying
 username       | character varying(80)  |
 disallow       | character varying(100) | default 'all'::character varying
 allow          | character varying(100) | default 'alaw,ulaw'::character
varying
 musiconhold    | character varying(100) |
 regseconds     | integer                | not null default 0
 ipaddr         | character varying(15)  |
 regexten       | character varying(80)  |
 cancallforward | character varying(3)   | default 'yes'::character varying
 lastms         | character varying(80)  |
 useragent      | character varying(100) |
 defaultuser    | character varying(100) |
 fullcontact    | character varying(100) |
 regserver      | character varying(100) |
Indexes:
    "sip_conf_pkey" PRIMARY KEY, btree (id)
    "name" UNIQUE, btree (name)

    *extconfig.conf*

sipusers => odbc,postgres,sip
sippeers => odbc,postgres,sip


Thanks & Regards

Murali Vasu








-- 
Smile is the only priceless gift you can give without a price.........
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20100721/366b6843/attachment-0001.htm