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 <jiboncost...@gmail.com> 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 <solomax...@gmail.com> 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 <jiboncost...@gmail.com > > > > 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
