[asterisk-users] asterisk realtime SIP configuration

[Jonathan Thurman]

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
>