You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@openmeetings.apache.org by Alexei Fedotov <al...@gmail.com> on 2013/07/11 17:46:44 UTC
Re: [ANNOUNCE] SIP in Openmeetings is changed
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 <so...@gmail.com> 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 <so...@gmail.com>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 <re...@yahoo.com> 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 <so...@gmail.com> 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 <re...@yahoo.com>
>>> > 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
Re: [ANNOUNCE] SIP in Openmeetings is changed
Posted by Artyom Horuzhenko <ak...@gmail.com>.
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 <al...@gmail.com>
> 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
> <al...@gmail.com> 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 <so...@gmail.com>
> 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 <solomax666@gmail.com
> >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 <re...@yahoo.com> 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 <so...@gmail.com> 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 <re...@yahoo.com>
> >>>> > 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
>
Re: [ANNOUNCE] SIP in Openmeetings is changed
Posted by Alexei Fedotov <al...@gmail.com>.
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
<al...@gmail.com> 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 <so...@gmail.com> 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 <so...@gmail.com>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 <re...@yahoo.com> 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 <so...@gmail.com> 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 <re...@yahoo.com>
>>>> > 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