Alexei, what exectly doesn't work? I got this message many times, but there were no problems with it. Insecure option was not changed by me.
2013/7/11 Alexei Fedotov <[email protected]> > I've noticed someone (Artyom?) changed > > /etc/asterisk/sip.conf.bak:;insecure=invite > to > /etc/asterisk/sip.conf:insecure=very > > on our production server. We get the following problem in the log: > > [Jul 7 22:34:29] WARNING[29149] chan_sip.c: Unknown insecure mode > 'very' on line 1173 > > > > -- > With best regards / с наилучшими пожеланиями, > Alexei Fedotov / Алексей Федотов, > http://dataved.ru/ > +7 916 562 8095 > > [1] Start using Apache Openmeetings today, http://openmeetings.apache.org/ > [2] Join Alexei Fedotov @linkedin, http://ru.linkedin.com/in/dataved/ > [3] Join Alexei Fedotov @facebook, http://www.facebook.com/openmeetings > > > On Thu, Jul 11, 2013 at 7:46 PM, Alexei Fedotov > <[email protected]> wrote: > > I get the following error in the log. Does anyone know what happens? > > > > [Jul 11 19:39:50] WARNING[15754][C-00000060] res_odbc.c: SQL Execute > > returned an error -1: 42S22: [MySQL][ODBC 3.51 > > Driver][mysqld-5.1.41-3ubuntu12.10]Unknown column 'insecure' in 'where > > clause' (96) > > [Jul 11 19:39:50] WARNING[15754][C-00000060] res_odbc.c: SQL Execute > > error -1! Verifying connection to asterisk [asterisk-connector]... > > [Jul 11 19:39:50] WARNING[15754][C-00000060] res_odbc.c: Connection is > > down attempting to reconnect... > > [Jul 11 19:39:50] NOTICE[15754][C-00000060] res_odbc.c: Connecting > asterisk > > > > > > -- > > With best regards / с наилучшими пожеланиями, > > Alexei Fedotov / Алексей Федотов, > > http://dataved.ru/ > > +7 916 562 8095 > > > > [1] Start using Apache Openmeetings today, > http://openmeetings.apache.org/ > > [2] Join Alexei Fedotov @linkedin, http://ru.linkedin.com/in/dataved/ > > [3] Join Alexei Fedotov @facebook, http://www.facebook.com/openmeetings > > > > > > On Tue, Mar 5, 2013 at 8:08 AM, Maxim Solodovnik <[email protected]> > wrote: > >> I have updated fields in java class > >> Unfortunately OpenJPA creates these 2 columns as > >> > >> | port | int(11) | NO | | NULL | > | > >> | type | varchar(6) | NO | | NULL | > | > >> > >> it seems there is nothing I can do with this > >> > >> > >> > >> > >> On Mon, Mar 4, 2013 at 7:29 PM, Maxim Solodovnik <[email protected] > >wrote: > >> > >>> I'm not sure enum is supported by multiple databases .... > >>> I can check port (should investigate how to support smallint) > >>> > >>> > >>> On Mon, Mar 4, 2013 at 7:24 PM, Vieri <[email protected]> wrote: > >>> > >>>> Hi, > >>>> > >>>> my conf: > >>>> `port` mediumint(8) unsigned NOT NULL DEFAULT '0', > >>>> > >>>> OM default: > >>>> port is varchar(5) > >>>> > >>>> Since port is always a number, wouldn't it be better if it were > defined > >>>> as an int instead of a varchar? Does OM need it declared as text > sonehow? > >>>> > >>>> My conf: > >>>> `type` enum('user','peer','friend') NOT NULL DEFAULT 'friend', > >>>> > >>>> OM default: > >>>> type is varchar(6) > >>>> > >>>> Is it safe OM-wise for me to change field type to enum? > >>>> Or maybe OM could also use enum by default? > >>>> > >>>> Thanks, > >>>> > >>>> Vieri > >>>> > >>>> --- On Mon, 3/4/13, Maxim Solodovnik <[email protected]> wrote: > >>>> > >>>> > you can add columns you need to this > >>>> > table (I did it with no issues) > >>>> > We have all required columns in our table > >>>> > I'm not sure having 2 tables is possible (you better try > >>>> > it) > >>>> > > >>>> > > >>>> > On Mon, Mar 4, 2013 at 5:50 PM, Vieri <[email protected]> > >>>> > wrote: > >>>> > > >>>> > > Hi, > >>>> > > > >>>> > > OM uses a limited set of fields for the "sipusers". I'm > >>>> > wondering if it's > >>>> > > any problem adding as many fields as possible even if > >>>> > OM doesn't use them? > >>>> > > I'd like to co-populate the sipusers table with my own > >>>> > values, not just > >>>> > > OM's. > >>>> > > > >>>> > > Ideally, I wish Asterisk RT could allow specifying more > >>>> > than 1 sipusers > >>>> > > tables so all the data would be combined and seem as > >>>> > just one source (eg. 2 > >>>> > > sipusers tables into 1). This way I'd use 1 sipusers > >>>> > table within > >>>> > > openmeetings DB for OM's exclusive use and use another > >>>> > sipusers table > >>>> > > within "asterisk" DB for Asterisk's exclusive use. > >>>> > However, Asterisk would > >>>> > > be able to merge both tables for SIP user lookups. I > >>>> > don't think Asterisk > >>>> > > supports this. > >>>> > > > >>>> > > Here's the table I use in Asterisk 11: > >>>> > > > >>>> > > CREATE TABLE IF NOT EXISTS `sipusers` ( > >>>> > > `id` int(11) NOT NULL AUTO_INCREMENT, > >>>> > > `name` varchar(80) NOT NULL DEFAULT > >>>> > '', > >>>> > > `fullname` varchar(150) DEFAULT NULL, > >>>> > > `host` varchar(31) NOT NULL DEFAULT > >>>> > '', > >>>> > > `nat` varchar(5) NOT NULL DEFAULT > >>>> > 'no', > >>>> > > `type` enum('user','peer','friend') > >>>> > NOT NULL DEFAULT 'friend', > >>>> > > `accountcode` varchar(20) DEFAULT > >>>> > NULL, > >>>> > > `amaflags` varchar(13) DEFAULT NULL, > >>>> > > `call-limit` smallint(5) unsigned > >>>> > DEFAULT NULL, > >>>> > > `callgroup` varchar(10) DEFAULT NULL, > >>>> > > `callerid` varchar(80) DEFAULT NULL, > >>>> > > `cid_number` varchar(40) DEFAULT > >>>> > NULL, > >>>> > > `trunkname` varchar(40) DEFAULT NULL, > >>>> > > `vmexten` varchar(40) DEFAULT NULL, > >>>> > > `mohinterpret` varchar(40) DEFAULT > >>>> > NULL, > >>>> > > `mohsuggest` varchar(40) DEFAULT > >>>> > NULL, > >>>> > > `parkinglot` varchar(40) DEFAULT > >>>> > NULL, > >>>> > > `auth` varchar(40) DEFAULT NULL, > >>>> > > `cancallforward` char(3) DEFAULT > >>>> > 'yes', > >>>> > > `canreinvite` char(3) DEFAULT 'yes', > >>>> > > `context` varchar(80) DEFAULT NULL, > >>>> > > `defaultip` varchar(15) DEFAULT > >>>> > '0.0.0.0', > >>>> > > `dtmfmode` varchar(7) DEFAULT NULL, > >>>> > > `fromuser` varchar(80) DEFAULT NULL, > >>>> > > `fromdomain` varchar(80) DEFAULT > >>>> > NULL, > >>>> > > `insecure` varchar(4) DEFAULT NULL, > >>>> > > `language` char(2) DEFAULT NULL, > >>>> > > `mailbox` varchar(50) DEFAULT NULL, > >>>> > > `md5secret` varchar(80) DEFAULT NULL, > >>>> > > `remotesecret` varchar(250) DEFAULT > >>>> > NULL, > >>>> > > `transport` > >>>> > enum('tcp','udp','tcp,udp') DEFAULT NULL, > >>>> > > `callingpres` > >>>> > > > >>>> > > >>>> > enum('allowed_not_screened','allowed_passed_screen','allowed_failed_screen','allowed','prohib_not_screened','prohib_passed_screen','prohib_failed_screen','prohib','unavailable') > >>>> > > DEFAULT 'allowed_not_screened', > >>>> > > `deny` varchar(95) DEFAULT NULL, > >>>> > > `permit` varchar(95) DEFAULT NULL, > >>>> > > `mask` varchar(95) DEFAULT NULL, > >>>> > > `musiconhold` varchar(100) DEFAULT > >>>> > NULL, > >>>> > > `pickupgroup` varchar(10) DEFAULT > >>>> > NULL, > >>>> > > `qualify` char(3) DEFAULT NULL, > >>>> > > `regexten` varchar(80) DEFAULT NULL, > >>>> > > `restrictcid` char(3) DEFAULT NULL, > >>>> > > `rtptimeout` char(3) DEFAULT NULL, > >>>> > > `rtpholdtimeout` char(3) DEFAULT > >>>> > NULL, > >>>> > > `secret` varchar(80) DEFAULT NULL, > >>>> > > `setvar` varchar(100) DEFAULT NULL, > >>>> > > `disallow` varchar(100) DEFAULT > >>>> > 'all', > >>>> > > `allow` varchar(100) DEFAULT > >>>> > 'gsm;ulaw;alaw', > >>>> > > `fullcontact` varchar(80) NOT NULL > >>>> > DEFAULT '', > >>>> > > `ipaddr` varchar(45) NOT NULL DEFAULT > >>>> > '', > >>>> > > `port` mediumint(8) unsigned NOT NULL > >>>> > DEFAULT '0', > >>>> > > `regserver` varchar(100) NOT NULL > >>>> > DEFAULT '', > >>>> > > `regseconds` int(11) NOT NULL DEFAULT > >>>> > '0', > >>>> > > `lastms` int(11) NOT NULL DEFAULT > >>>> > '0', > >>>> > > `username` varchar(80) NOT NULL > >>>> > DEFAULT '', > >>>> > > `defaultuser` varchar(80) NOT NULL > >>>> > DEFAULT '', > >>>> > > `subscribecontext` varchar(80) DEFAULT > >>>> > NULL, > >>>> > > `autoframing` enum('yes','no') DEFAULT > >>>> > NULL, > >>>> > > `directmedia` enum('yes','no') DEFAULT > >>>> > NULL, > >>>> > > `constantssrc` enum('yes','no') > >>>> > DEFAULT NULL, > >>>> > > `usereqphone` enum('yes','no') DEFAULT > >>>> > NULL, > >>>> > > `trustrpid` enum('yes','no') DEFAULT > >>>> > NULL, > >>>> > > `sendrpid` enum('yes','no') DEFAULT > >>>> > NULL, > >>>> > > `g726nonstandard` enum('yes','no') > >>>> > DEFAULT NULL, > >>>> > > `subscribewmi` enum('yes','no') > >>>> > DEFAULT NULL, > >>>> > > `progressinband` > >>>> > enum('never','yes','no') DEFAULT NULL, > >>>> > > `promiscredir` enum('yes','no') > >>>> > DEFAULT NULL, > >>>> > > `useclientcode` enum('yes','no') > >>>> > DEFAULT NULL, > >>>> > > `callcounter` enum('yes','no') DEFAULT > >>>> > NULL, > >>>> > > `busylevel` int(10) unsigned DEFAULT > >>>> > NULL, > >>>> > > `faxdetect` enum('yes','no') DEFAULT > >>>> > NULL, > >>>> > > `allowoverlap` enum('yes','no') > >>>> > DEFAULT 'yes', > >>>> > > `allowsubscribe` enum('yes','no') > >>>> > DEFAULT 'yes', > >>>> > > `allowtransfer` enum('yes','no') > >>>> > DEFAULT 'yes', > >>>> > > `ignoresdpversion` enum('yes','no') > >>>> > DEFAULT 'no', > >>>> > > `template` varchar(100) DEFAULT NULL, > >>>> > > `videosupport` > >>>> > enum('yes','no','always') DEFAULT 'no', > >>>> > > `textsupport` enum('yes','no') DEFAULT > >>>> > NULL, > >>>> > > `buggymwi` enum('yes','no') DEFAULT > >>>> > NULL, > >>>> > > `maxcallbitrate` int(10) unsigned > >>>> > DEFAULT NULL, > >>>> > > `rfc2833compensate` enum('yes','no') > >>>> > DEFAULT 'yes', > >>>> > > `rtpkeepalive` int(11) DEFAULT NULL, > >>>> > > `session-timers` > >>>> > enum('originate','accept','refuse') DEFAULT 'accept', > >>>> > > `session-expires` int(5) unsigned > >>>> > DEFAULT '1800', > >>>> > > `session-minse` int(5) unsigned > >>>> > DEFAULT '90', > >>>> > > `session-refresher` enum('uac','uas') > >>>> > DEFAULT 'uas', > >>>> > > `t38pt_usertpsource` enum('yes','no') > >>>> > DEFAULT NULL, > >>>> > > `dynamic` enum('yes','no') DEFAULT > >>>> > NULL, > >>>> > > `outboundproxy` varchar(250) DEFAULT > >>>> > NULL, > >>>> > > `callbackextension` varchar(250) > >>>> > DEFAULT NULL, > >>>> > > `registertrying` enum('yes','no') > >>>> > DEFAULT 'yes', > >>>> > > `hasvoicemail` enum('yes','no') > >>>> > DEFAULT NULL, > >>>> > > `timert1` int(5) unsigned DEFAULT > >>>> > '500', > >>>> > > `timerb` int(8) unsigned DEFAULT > >>>> > NULL, > >>>> > > `qualifyfreq` int(5) unsigned DEFAULT > >>>> > '120', > >>>> > > `contactpermit` varchar(250) DEFAULT > >>>> > NULL, > >>>> > > `contactdeny` varchar(250) DEFAULT > >>>> > NULL, > >>>> > > `useragent` varchar(50) NOT NULL > >>>> > DEFAULT '', > >>>> > > `sippasswd` varchar(80) DEFAULT NULL, > >>>> > > PRIMARY KEY (`id`), > >>>> > > UNIQUE KEY `name` (`name`), > >>>> > > KEY `ipaddr` (`ipaddr`,`port`), > >>>> > > KEY `host` (`host`,`port`) > >>>> > > ) ENGINE=MyISAM DEFAULT CHARSET=latin1 > >>>> > ROW_FORMAT=DYNAMIC > >>>> > > AUTO_INCREMENT=183 ; > >>>> > > > >>>> > > Thanks, > >>>> > > > >>>> > > Vieri > >>>> > > > >>>> > > > >>>> > > >>>> > > >>>> > -- > >>>> > WBR > >>>> > Maxim aka solomax > >>>> > > >>>> > >>> > >>> > >>> > >>> -- > >>> WBR > >>> Maxim aka solomax > >>> > >> > >> > >> > >> -- > >> WBR > >> Maxim aka solomax >
