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
