I am using ubuntu 14.04 on a VPS server & Asterisk 11.20 On 10/20/15, Maxim Solodovnik <solomax...@gmail.com> 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 <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 >
-- Thanks & Regards Jibon Lawrence Costa
