thr3ads.net - asterisk users - [asterisk-users] asterisk realtime SIP configuration [Jul 2010]

If this information is useful, please help other people find it:
Share via:

Murali Vasu

2010-Jul-21 10:09 UTC

[asterisk-users] asterisk realtime SIP configuration

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

Jonathan Thurman

2010-Jul-21 14:54 UTC

head link

[asterisk-users] asterisk realtime SIP configuration

On Wed, Jul 21, 2010 at 3:09 AM, Murali Vasu <vimurli.ace at gmail.com>
wrote:>
> 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
If you want to see the peers on the CLI, then you have to enable
caching of the peers.  Add this to your sip.conf file:

[general]
rtcachefriends=yes


-Jonathan

> ???? 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.........
>
> --
> _____________________________________________________________________
> -- Bandwidth and Colocation Provided by http://www.api-digital.com --
> New to Asterisk? Join us for a live introductory webinar every Thurs:
> ? ? ? ? ? ? ? http://www.asterisk.org/hello
>
> asterisk-users mailing list
> To UNSUBSCRIBE or update options visit:
> ? http://lists.digium.com/mailman/listinfo/asterisk-users
>

Reasonably Related Threads

Search for more maybe matching threads

asterisk users - Jul 2010 - asterisk realtime SIP configuration

[asterisk-users] asterisk realtime SIP configuration

[asterisk-users] asterisk realtime SIP configuration

Reasonably Related Threads