[Home]

Summary:ASTERISK-17071: Realtime for ODBC & Mysql is diffrent
Reporter:Maziar navahan (maziar)Labels:
Date Opened:2010-12-05 23:24:54.000-0600Date Closed:
Priority:MajorRegression?No
Status:Open/NewComponents:Channels/chan_sip/DatabaseSupport
Versions:Frequency of
Occurrence
Related
Issues:
Environment:Attachments:
Description:i use asterisk realtime with postgresql via ODBC

in asterisk source\contrib in postgresql folder & mysql folder seems table name & number of fields for same work (sip) is totaly diffrent and seems mysql tabel field is more complete

for example i need "subscribecontext" av. in mysql but not avalibale in postgresql

****** ADDITIONAL INFORMATION ******

//inmysql    
CREATE TABLE `sipfriends` (
     `name` varchar(40) NOT NULL default '',
     `type` varchar(10) NOT NULL default '',
     `username` varchar(40),
     `fromuser` varchar(40),
     `fromdomain` varchar(40),
     `secret` varchar(40),
     `md5secret` varchar(40),
     `auth` varchar(10),
     `mailbox` varchar(20),
     `subscribemwi` varchar(10), -- yes/no
     `vmexten` varchar(20),
     `callerid` varchar(40),
     `cid_number` varchar(40),
     `callingpres` varchar(20),
     `usereqphone` varchar(10),
     `language` varchar(10),
     `incominglimit` varchar(10),
     `context` varchar(40) NOT NULL default '',
     `subscribecontext` varchar(40),
     `amaflags` varchar(20),
     `accountcode` varchar(20),
     `musicclass` varchar(20),
     `mohsuggest` varchar(20),
     `allowtransfer` varchar(20),
     `callgroup` varchar(20),
     `pickupgroup` varchar(20),
     `autoframing` varchar(10), -- yes/no
     `disallow` varchar(20) default 'all',
     `allow` varchar(20),
     `maxcallbitrate` varchar(15),
     `host` varchar(40) default 'dynamic',
     `outboundproxy` varchar(40),
     `ipaddr` varchar(40) NOT NULL default '',
     `defaultip` varchar(20),
     `port` int(6) NOT NULL default '0',
     `fullcontact` varchar(40),
     `insecure` varchar(20),
     `qualify` varchar(15),
     `regseconds` int(11) NOT NULL default '0',
     `regexten` varchar(20),
     `regserver` varchar(20),
     `rtptimeout` varchar(15),
     `rtpholdtimeout` varchar(15),
     `rtpkeepalive` varchar(15),
     `lastms` int(11) NOT NULL default '-1',
     `setvar` varchar(200),
     PRIMARY KEY  (`name`),
     INDEX host (host, port),
     INDEX ipaddr (ipaddr, port),
   ) TYPE=MyISAM;


//postgresql
   CREATE TABLE sip_conf (
   id serial NOT NULL,
   name character varying(80) DEFAULT '' NOT NULL,
   accountcode character varying(20),
   amaflags character varying(7),
   callgroup character varying(10),
   callerid character varying(80),
   canreinvite character varying(3) DEFAULT 'yes',
   context character varying(80),
   defaultip character varying(15),
   dtmfmode character varying(7),
   fromuser character varying(80),
   fromdomain character varying(80),
   host character varying(31) DEFAULT '' NOT NULL,
   insecure character varying(4),
   "language" character varying(2),
   mailbox character varying(50),
   md5secret character varying(80),
   nat character varying(5) DEFAULT 'no' NOT NULL,
   permit character varying(95),
   deny character varying(95),
   mask character varying(95),
   pickupgroup character varying(10),
   port character varying(5) DEFAULT '' NOT NULL,
   qualify character varying(3),
   restrictcid character varying(1),
   rtptimeout character varying(3),
   rtpholdtimeout character varying(3),
   secret character varying(80),
   "type" character varying DEFAULT 'friend' NOT NULL,
   username character varying(80) DEFAULT '' NOT NULL,
   disallow character varying(100) DEFAULT 'all',
   allow character varying(100) DEFAULT 'g729;ilbc;gsm;ulaw;alaw',
   musiconhold character varying(100),
   regseconds bigint DEFAULT 0::bigint NOT NULL,
   ipaddr character varying(40) DEFAULT '' NOT NULL,
   regexten character varying(80) DEFAULT '' NOT NULL,
   cancallforward character varying(3) DEFAULT 'yes',
   lastms integer DEFAULT -1 NOT NULL
   );
Comments: