Just solved that :). I did something wrong in asterisk extension configuration :(. Now it's working just great. One small problem Can't user do video call? I can't do video call.
On 10/20/15, Maxim Solodovnik <[email protected]> wrote: > 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 > -- Thanks & Regards Jibon Lawrence Costa
