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
[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 reloadIf 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 >