This is weird :( I have tested configuration instructions on our server using asterisk-11.2.1.tar.gz
On Tue, Oct 20, 2015 at 12:18 AM, Jibon L. Costa <[email protected]> wrote: > I am using ubuntu 14.04 on a VPS server & Asterisk 11.20 > > On 10/20/15, Maxim Solodovnik <[email protected]> wrote: > > The issue seems to be caused by > > "Unknown column 'insecure' in 'where clause' (107)" > > > > What OS and Asterisk are you using? > > > > On Tue, Oct 20, 2015 at 12:12 AM, Jibon L. Costa <[email protected] > > > > wrote: > > > >> Thanks for reply. I just solved that problem. But another problem is > >> red5sip disconnecting continuously after few seconds from the room. > >> > >> [Oct 19 14:13:41] WARNING[5837][C-00000081]: res_odbc.c:757 > >> ast_odbc_sanity_check: Connection is down attempting to reconnect... > >> == Manager 'openmeetings' logged on from 127.0.0.1 > >> == Manager 'openmeetings' logged off from 127.0.0.1 > >> [Oct 19 14:13:46] NOTICE[5837][C-00000081]: res_odbc.c:1529 > >> odbc_obj_connect: Connecting asterisk > >> [Oct 19 14:13:46] NOTICE[5837][C-00000081]: res_odbc.c:1568 > >> odbc_obj_connect: res_odbc: Connected to asterisk [asterisk-connector] > >> [Oct 19 14:13:46] WARNING[5837][C-00000081]: res_odbc.c:641 > >> ast_odbc_prepare_and_execute: SQL Execute returned an error -1: 42S22: > >> [MySQL][ODBC 5.1 > >> Driver][mysqld-5.5.44-MariaDB-1ubuntu0.14.04.1]Unknown column > >> 'insecure' in 'where clause' (107) > >> [Oct 19 14:13:46] WARNING[5837][C-00000081]: res_odbc.c:653 > >> ast_odbc_prepare_and_execute: SQL Execute error -1! Verifying > >> connection to asterisk [asterisk-connector]... > >> [Oct 19 14:13:46] WARNING[5837][C-00000081]: res_odbc.c:757 > >> ast_odbc_sanity_check: Connection is down attempting to reconnect... > >> == Manager 'openmeetings' logged on from 127.0.0.1 > >> == Manager 'openmeetings' logged off from 127.0.0.1 > >> == Manager 'openmeetings' logged on from 127.0.0.1 > >> == Manager 'openmeetings' logged off from 127.0.0.1 > >> [Oct 19 14:13:51] NOTICE[5837][C-00000081]: res_odbc.c:1529 > >> odbc_obj_connect: Connecting asterisk > >> [Oct 19 14:13:51] NOTICE[5837][C-00000081]: res_odbc.c:1568 > >> odbc_obj_connect: res_odbc: Connected to asterisk [asterisk-connector] > >> == Using SIP VIDEO CoS mark 6 > >> == Using SIP RTP CoS mark 5 > >> [Oct 19 14:13:51] WARNING[5837][C-00000081]: res_odbc.c:641 > >> ast_odbc_prepare_and_execute: SQL Execute returned an error -1: 42S22: > >> [MySQL][ODBC 5.1 > >> Driver][mysqld-5.5.44-MariaDB-1ubuntu0.14.04.1]Unknown column > >> 'insecure' in 'where clause' (107) > >> [Oct 19 14:13:51] WARNING[5837][C-00000081]: res_odbc.c:653 > >> ast_odbc_prepare_and_execute: SQL Execute error -1! Verifying > >> connection to asterisk [asterisk-connector]... > >> [Oct 19 14:13:51] WARNING[5837][C-00000081]: res_odbc.c:757 > >> ast_odbc_sanity_check: Connection is down attempting to reconnect... > >> > >> On 10/20/15, Maxim Solodovnik <[email protected]> wrote: > >> > What sources are you using? > >> > Due to googlecode EOL I have moved red5sip to > >> > https://github.com/solomax/red5phone/tree/red5sip_3.0 > >> > I'll update documentation ASAP > >> > > >> > On Sat, Oct 17, 2015 at 11:25 PM, Jibon L. Costa > >> > <[email protected] > >> > > >> > wrote: > >> > > >> >> Hello, > >> >> > >> >> I am trying to connect a separate SIP server with another > openmeetings > >> >> server. Actually I didn't understand what to put in "SIP-Settings" > >> >> during creating a room. Like SIP number, Pin Number etc. > >> >> > >> >> Also during compiling red5sip transport I am getting this error: > >> >> > >> >> Buildfile: /opt/red5sip/build.xml > >> >> > >> >> clean: > >> >> [delete] Deleting directory /opt/red5sip/out/classes > >> >> > >> >> prepare.mkdir: > >> >> [mkdir] Created dir: /opt/red5sip/out/classes > >> >> > >> >> -availability-check: > >> >> > >> >> -retrieve-libs: > >> >> > >> >> compile.only: > >> >> [echo] Compile main to /opt/red5sip/out/classes > >> >> [javac] Compiling 272 source files to /opt/red5sip/out/classes > >> >> [javac] warning: [options] bootstrap class path not set in > >> >> conjunction with -source 1.6 > >> >> [javac] > >> >> /opt/red5sip/src/java/org/red5/codecs/g729/Decoder.java:47: > >> >> error: unmappable character for encoding ASCII > >> >> [javac] // Recebe um array de byte de 20 ou 30 posi??????es > >> >> [javac] ^ > >> >> [javac] > >> >> /opt/red5sip/src/java/org/red5/codecs/g729/Decoder.java:47: > >> >> error: unmappable character for encoding ASCII > >> >> [javac] // Recebe um array de byte de 20 ou 30 posi??????es > >> >> [javac] ^ > >> >> [javac] > >> >> /opt/red5sip/src/java/org/red5/codecs/g729/Decoder.java:47: > >> >> error: unmappable character for encoding ASCII > >> >> [javac] // Recebe um array de byte de 20 ou 30 posi??????es > >> >> [javac] ^ > >> >> [javac] > >> >> /opt/red5sip/src/java/org/red5/codecs/g729/Decoder.java:47: > >> >> error: unmappable character for encoding ASCII > >> >> [javac] // Recebe um array de byte de 20 ou 30 posi??????es > >> >> [javac] ^ > >> >> [javac] > >> >> /opt/red5sip/src/java/org/red5/codecs/g729/Decoder.java:47: > >> >> error: unmappable character for encoding ASCII > >> >> [javac] // Recebe um array de byte de 20 ou 30 posi??????es > >> >> [javac] ^ > >> >> [javac] > >> >> /opt/red5sip/src/java/org/red5/codecs/g729/Decoder.java:47: > >> >> error: unmappable character for encoding ASCII > >> >> [javac] // Recebe um array de byte de 20 ou 30 posi??????es > >> >> [javac] ^ > >> >> [javac] > >> >> /opt/red5sip/src/java/org/red5/codecs/g729/Encoder.java:23: > >> >> error: unmappable character for encoding ASCII > >> >> [javac] // posi??????es > >> >> [javac] ^ > >> >> [javac] > >> >> /opt/red5sip/src/java/org/red5/codecs/g729/Encoder.java:23: > >> >> error: unmappable character for encoding ASCII > >> >> [javac] // posi??????es > >> >> [javac] ^ > >> >> [javac] > >> >> /opt/red5sip/src/java/org/red5/codecs/g729/Encoder.java:23: > >> >> error: unmappable character for encoding ASCII > >> >> [javac] // posi??????es > >> >> [javac] ^ > >> >> [javac] > >> >> /opt/red5sip/src/java/org/red5/codecs/g729/Encoder.java:23: > >> >> error: unmappable character for encoding ASCII > >> >> [javac] // posi??????es > >> >> [javac] ^ > >> >> [javac] > >> >> /opt/red5sip/src/java/org/red5/codecs/g729/Encoder.java:23: > >> >> error: unmappable character for encoding ASCII > >> >> [javac] // posi??????es > >> >> [javac] ^ > >> >> [javac] > >> >> /opt/red5sip/src/java/org/red5/codecs/g729/Encoder.java:23: > >> >> error: unmappable character for encoding ASCII > >> >> [javac] // posi??????es > >> >> [javac] ^ > >> >> [javac] 12 errors > >> >> [javac] 1 warning > >> >> > >> >> BUILD FAILED > >> >> /opt/red5sip/build.xml:80: Compile failed; see the compiler error > >> >> output for details. > >> >> > >> >> Total time: 1 second > >> >> > >> >> In where I am doing wrong? > >> >> > >> >> -- > >> >> Thanks & Regards > >> >> Jibon Lawrence Costa > >> >> > >> > > >> > > >> > > >> > -- > >> > WBR > >> > Maxim aka solomax > >> > > >> > >> > >> -- > >> Thanks & Regards > >> Jibon Lawrence Costa > >> > > > > > > > > -- > > WBR > > Maxim aka solomax > > > > > -- > Thanks & Regards > Jibon Lawrence Costa > -- WBR Maxim aka solomax
