Re: Clustering issue
On Tuesday 20 October 2015 08:37 PM, Maxim Solodovnik wrote: The issue is here: according to the comments serverId is the DB ID of the server So you need to 1) install OM on single machine 2) go to admin 3) create 2 servers (ID will be 1 and 2 on clean machine) 4) perform set up of cluster You mean, in this case, I will need 3 systems to perform clustering ? So, I am going to try following. I will have 3 system, say A (10.1.2.1), B (10.1.2.2), C (10.1.2.3). 1. Install database on machine A (whose IP is 10.1.2.1) 2. Install OM on machine A. 3. Will go to admin of A and create 2 servers(whose id will be 1 n 2 respectively. and their IPs will 10.1.2.2, 10.1.2.3 respectively). 4. Will extract OM on system B and C. 5. Will modify the files persistence.xml and openmeetings-applicationContext.xml of B and C as per the documentation. 1. On system B 2. On system C 6. Will ran ./red5.sh on system B n C and complete installation. Please tell me if this approach is correct or not and thanks for your guidance. On Mon, Oct 19, 2015 at 2:13 PM, Bhushan Patil mailto:thebhushanpa...@gmail.com>> wrote: I want to do clustering on OpenMeeting-3.0.7. I have two machines(10.1.2.2 and 10.1.2.3). 10.1.2.2 have database Postgres installed on it. I did the following 1. Extracted apache-openmeetings-3.0.7.tar.gz on 10.1.2.2. 2. Changed following properties in persistence.xml and openmeetings-applicationContext.xml respectively. 3. Ran ./red5.sh and installed OpenMeetings successfully. 4. Extracted apache-openmeetings-3.0.7.tar.gz on 10.1.2.3. 5. Changed following properties in persistence.xml and openmeetings-applicationContext.xml respectively. 6. Now when I ran ./red5.sh, i got following error. Installation is failed org.springframework.dao.DataIntegrityViolationException: The transaction has been rolled back. See the nested exceptions for details on the errors that occurred.; nested exception is org.apache.openjpa.persistence.EntityExistsException: The transaction has been rolled back. See the nested exceptions for details on the errors that occurred. FailedObject: org.apache.openmeetings.db.entity.basic.Configuration@3d65f054 at org.springframework.orm.jpa.EntityManagerFactoryUtils.convertJpaAccessExceptionIfPossible(EntityManagerFactoryUtils.java:407) at org.springframework.orm.jpa.DefaultJpaDialect.translateExceptionIfPossible(DefaultJpaDialect.java:122) at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:521) at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:757) at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:726) at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:521) at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:291) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:653) at org.apache.openmeetings.db.dao.basic.ConfigurationDao$$EnhancerBySpringCGLIB$$2b956ef0.add() at org.apache.openmeetings.installation.ImportInitvalues.loadConfiguration(ImportInitvalues.java:283) at org.apache.openmeetings.installation.ImportInitvalues.loadSystem(ImportInitvalues.java:714) at org.apache.openmeetings.installation.ImportInitvalues.loadAll(ImportInitvalues.java:726) at org.apache.openmeetings.web.pages.install.InstallWizard$InstallProcess.run(InstallWizard.java:616) at java.lang.Thread.run(Thread.java:745) Caused by: org.apache.openjpa.persistence.EntityExistsException: The transaction has been rolled back. See the nested exceptions for details on the errors that occurred. FailedObject: org.apache.openmeetings.db.entity.basic.Configuration@3d65f054 at org.apache.openjpa.kernel.BrokerImpl.newFlushException(BrokerImpl.java:2368) at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:2205) at org.apache.openjpa.kernel.BrokerImpl
Re: SIP Help !!
You will update PHP API? Or where I will check?
On 10/21/15, Maxim Solodovnik wrote:
> OK
> will try to check it tonight
>
> On Wed, Oct 21, 2015 at 5:42 PM, Jibon L. Costa
> wrote:
>
>> Version 3.0.8-SNAPSHOT
>> Revision1709531
>> Build date 20-October-2015
>>
>> On 10/21/15, Jibon L. Costa wrote:
>> > I am using: 3.0.8-SNAPSHOT
>> >
>> > On 10/21/15, Jibon L. Costa wrote:
>> >> I am using your PHP api here.
>> >>
>> >> require_once("openmeetings_gateway.php");
>> >> $options = array(
>> >> "protocol" => "http",
>> >> "port" => 5080,
>> >> "host" => "HOST",
>> >> "webappname" => "openmeetings",
>> >> "adminUser" => "ADMIN",
>> >> "adminPass" =>"admin",
>> >> );
>> >>
>> >> $access = new openmeetings_gateway($options);
>> >> $access->loginuser();
>> >> $hash = $access->setUserObjectAndGenerateRoomHash("", "jibon Costa",
>> >> "", "", "", "unique", "joomla", 4, 1, 1);
>> >>
>> >> echo $hash."";
>> >> print_r($access->getRooms());
>> >>
>> >> & output:
>> >> Your call to OpenMeetings Web Services returned an unexpected HTTP
>> >> status of: 500 Request
>> >>
>> http://HOST:5080/openmeetings/services/RoomService/getRoomsWithCurrentUsers?SID=456d4b3fb452e2498e4ace9c0029a7ef&start=1&max=100&orderby=name&asc=1
>> >>
>> >> On 10/21/15, Maxim Solodovnik wrote:
>> >>> Yes this might be an issue
>> >>> could you please provide repo steps for this?
>> >>>
>> >>> On Wed, Oct 21, 2015 at 5:30 PM, Jibon L. Costa <
>> jiboncost...@gmail.com>
>> >>> wrote:
>> >>>
>> Was the SOAP/REST API changed? I am getting error like this:
>>
>> Exception occurred while trying to invoke service method
>> getRoomsWithCurrentUsers
>>
>>
>>
>> HOST:5080/openmeetings/services/RoomService/getRoomsWithCurrentUsers?SID=456d4b3fb452e2498e4ace9c0029a7ef&start=1&max=100&orderby=name&asc=1
>>
>> On 10/21/15, Maxim Solodovnik wrote:
>> > It is possible but extremely unstable
>> >
>> > On Wed, Oct 21, 2015 at 4:15 PM, Jibon L. Costa
>> >
>> > wrote:
>> >
>> >> 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 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
>> >> > > >> >
>> >> > wrote:
>> >> >
>> >> >> I am using ubuntu 14.04 on a VPS server & Asterisk 11.20
>> >> >>
>> >> >> On 10/20/15, Maxim Solodovnik 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
>> >> >> > > >> >> >
>> >> >> > 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-0081]: 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-0081]: res_odbc.c:1529
>> >> >> >> odbc_obj_connect: Connecting asterisk
>> >> >> >> [Oct 19 14:13:46] NOTICE[5837][C-0081]: res_odbc.c:1568
>> >> >> >> odbc_obj_connect: res_odbc: Connected to asterisk
>> >> [asterisk-connector]
>> >> >> >> [Oct 19 14:13:46] WARNING[5837][C-0081]: 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-0081]: 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-0081]: res_odbc.c:757
>> >> >> >> ast_odbc_sanity_check: Connection is down attempting to
>> >> >> >> reconnect...
>> >> >> >> == Manager 'openmeetings' logged on from 127.0.0.1
>> >
Re: SIP Help !!
OK
will try to check it tonight
On Wed, Oct 21, 2015 at 5:42 PM, Jibon L. Costa
wrote:
> Version 3.0.8-SNAPSHOT
> Revision1709531
> Build date 20-October-2015
>
> On 10/21/15, Jibon L. Costa wrote:
> > I am using: 3.0.8-SNAPSHOT
> >
> > On 10/21/15, Jibon L. Costa wrote:
> >> I am using your PHP api here.
> >>
> >> require_once("openmeetings_gateway.php");
> >> $options = array(
> >> "protocol" => "http",
> >> "port" => 5080,
> >> "host" => "HOST",
> >> "webappname" => "openmeetings",
> >> "adminUser" => "ADMIN",
> >> "adminPass" =>"admin",
> >> );
> >>
> >> $access = new openmeetings_gateway($options);
> >> $access->loginuser();
> >> $hash = $access->setUserObjectAndGenerateRoomHash("", "jibon Costa",
> >> "", "", "", "unique", "joomla", 4, 1, 1);
> >>
> >> echo $hash."";
> >> print_r($access->getRooms());
> >>
> >> & output:
> >> Your call to OpenMeetings Web Services returned an unexpected HTTP
> >> status of: 500 Request
> >>
> http://HOST:5080/openmeetings/services/RoomService/getRoomsWithCurrentUsers?SID=456d4b3fb452e2498e4ace9c0029a7ef&start=1&max=100&orderby=name&asc=1
> >>
> >> On 10/21/15, Maxim Solodovnik wrote:
> >>> Yes this might be an issue
> >>> could you please provide repo steps for this?
> >>>
> >>> On Wed, Oct 21, 2015 at 5:30 PM, Jibon L. Costa <
> jiboncost...@gmail.com>
> >>> wrote:
> >>>
> Was the SOAP/REST API changed? I am getting error like this:
>
> Exception occurred while trying to invoke service method
> getRoomsWithCurrentUsers
>
>
>
> HOST:5080/openmeetings/services/RoomService/getRoomsWithCurrentUsers?SID=456d4b3fb452e2498e4ace9c0029a7ef&start=1&max=100&orderby=name&asc=1
>
> On 10/21/15, Maxim Solodovnik wrote:
> > It is possible but extremely unstable
> >
> > On Wed, Oct 21, 2015 at 4:15 PM, Jibon L. Costa
> >
> > wrote:
> >
> >> 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 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
> >> > >> >
> >> > wrote:
> >> >
> >> >> I am using ubuntu 14.04 on a VPS server & Asterisk 11.20
> >> >>
> >> >> On 10/20/15, Maxim Solodovnik 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
> >> >> > >> >> >
> >> >> > 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-0081]: 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-0081]: res_odbc.c:1529
> >> >> >> odbc_obj_connect: Connecting asterisk
> >> >> >> [Oct 19 14:13:46] NOTICE[5837][C-0081]: res_odbc.c:1568
> >> >> >> odbc_obj_connect: res_odbc: Connected to asterisk
> >> [asterisk-connector]
> >> >> >> [Oct 19 14:13:46] WARNING[5837][C-0081]: 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-0081]: 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-0081]: 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-0081]:
Re: SIP Help !!
Version 3.0.8-SNAPSHOT
Revision1709531
Build date 20-October-2015
On 10/21/15, Jibon L. Costa wrote:
> I am using: 3.0.8-SNAPSHOT
>
> On 10/21/15, Jibon L. Costa wrote:
>> I am using your PHP api here.
>>
>> require_once("openmeetings_gateway.php");
>> $options = array(
>> "protocol" => "http",
>> "port" => 5080,
>> "host" => "HOST",
>> "webappname" => "openmeetings",
>> "adminUser" => "ADMIN",
>> "adminPass" =>"admin",
>> );
>>
>> $access = new openmeetings_gateway($options);
>> $access->loginuser();
>> $hash = $access->setUserObjectAndGenerateRoomHash("", "jibon Costa",
>> "", "", "", "unique", "joomla", 4, 1, 1);
>>
>> echo $hash."";
>> print_r($access->getRooms());
>>
>> & output:
>> Your call to OpenMeetings Web Services returned an unexpected HTTP
>> status of: 500 Request
>> http://HOST:5080/openmeetings/services/RoomService/getRoomsWithCurrentUsers?SID=456d4b3fb452e2498e4ace9c0029a7ef&start=1&max=100&orderby=name&asc=1
>>
>> On 10/21/15, Maxim Solodovnik wrote:
>>> Yes this might be an issue
>>> could you please provide repo steps for this?
>>>
>>> On Wed, Oct 21, 2015 at 5:30 PM, Jibon L. Costa
>>> wrote:
>>>
Was the SOAP/REST API changed? I am getting error like this:
Exception occurred while trying to invoke service method
getRoomsWithCurrentUsers
HOST:5080/openmeetings/services/RoomService/getRoomsWithCurrentUsers?SID=456d4b3fb452e2498e4ace9c0029a7ef&start=1&max=100&orderby=name&asc=1
On 10/21/15, Maxim Solodovnik wrote:
> It is possible but extremely unstable
>
> On Wed, Oct 21, 2015 at 4:15 PM, Jibon L. Costa
>
> wrote:
>
>> 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 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
>> > >>> >> >
>> > wrote:
>> >
>> >> I am using ubuntu 14.04 on a VPS server & Asterisk 11.20
>> >>
>> >> On 10/20/15, Maxim Solodovnik 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
>> >> > >>> >> >> >
>> >> > 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-0081]: 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-0081]: res_odbc.c:1529
>> >> >> odbc_obj_connect: Connecting asterisk
>> >> >> [Oct 19 14:13:46] NOTICE[5837][C-0081]: res_odbc.c:1568
>> >> >> odbc_obj_connect: res_odbc: Connected to asterisk
>> [asterisk-connector]
>> >> >> [Oct 19 14:13:46] WARNING[5837][C-0081]: 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-0081]: 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-0081]: 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-0081]: res_odbc.c:1529
>> >> >> odbc_obj_connect: Connecting asterisk
>> >> >> [Oct 19 14:13:51] NOTICE[5837][C-0081]: 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:
Re: SIP Help !!
I am using: 3.0.8-SNAPSHOT
On 10/21/15, Jibon L. Costa wrote:
> I am using your PHP api here.
>
> require_once("openmeetings_gateway.php");
> $options = array(
> "protocol" => "http",
> "port" => 5080,
> "host" => "HOST",
> "webappname" => "openmeetings",
> "adminUser" => "ADMIN",
> "adminPass" =>"admin",
> );
>
> $access = new openmeetings_gateway($options);
> $access->loginuser();
> $hash = $access->setUserObjectAndGenerateRoomHash("", "jibon Costa",
> "", "", "", "unique", "joomla", 4, 1, 1);
>
> echo $hash."";
> print_r($access->getRooms());
>
> & output:
> Your call to OpenMeetings Web Services returned an unexpected HTTP
> status of: 500 Request
> http://HOST:5080/openmeetings/services/RoomService/getRoomsWithCurrentUsers?SID=456d4b3fb452e2498e4ace9c0029a7ef&start=1&max=100&orderby=name&asc=1
>
> On 10/21/15, Maxim Solodovnik wrote:
>> Yes this might be an issue
>> could you please provide repo steps for this?
>>
>> On Wed, Oct 21, 2015 at 5:30 PM, Jibon L. Costa
>> wrote:
>>
>>> Was the SOAP/REST API changed? I am getting error like this:
>>>
>>> Exception occurred while trying to invoke service method
>>> getRoomsWithCurrentUsers
>>>
>>>
>>> HOST:5080/openmeetings/services/RoomService/getRoomsWithCurrentUsers?SID=456d4b3fb452e2498e4ace9c0029a7ef&start=1&max=100&orderby=name&asc=1
>>>
>>> On 10/21/15, Maxim Solodovnik wrote:
>>> > It is possible but extremely unstable
>>> >
>>> > On Wed, Oct 21, 2015 at 4:15 PM, Jibon L. Costa
>>> >
>>> > wrote:
>>> >
>>> >> 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 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
>>> >> > >> >> >
>>> >> > wrote:
>>> >> >
>>> >> >> I am using ubuntu 14.04 on a VPS server & Asterisk 11.20
>>> >> >>
>>> >> >> On 10/20/15, Maxim Solodovnik 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
>>> >> >> > >> >> >> >
>>> >> >> > 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-0081]: 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-0081]: res_odbc.c:1529
>>> >> >> >> odbc_obj_connect: Connecting asterisk
>>> >> >> >> [Oct 19 14:13:46] NOTICE[5837][C-0081]: res_odbc.c:1568
>>> >> >> >> odbc_obj_connect: res_odbc: Connected to asterisk
>>> >> [asterisk-connector]
>>> >> >> >> [Oct 19 14:13:46] WARNING[5837][C-0081]: 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-0081]: 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-0081]: 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-0081]: res_odbc.c:1529
>>> >> >> >> odbc_obj_connect: Connecting asterisk
>>> >> >> >> [Oct 19 14:13:51] NOTICE[5837][C-0081]: 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-0081]: 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
>
Re: SIP Help !!
I am using your PHP api here.
require_once("openmeetings_gateway.php");
$options = array(
"protocol" => "http",
"port" => 5080,
"host" => "HOST",
"webappname" => "openmeetings",
"adminUser" => "ADMIN",
"adminPass" =>"admin",
);
$access = new openmeetings_gateway($options);
$access->loginuser();
$hash = $access->setUserObjectAndGenerateRoomHash("", "jibon Costa",
"", "", "", "unique", "joomla", 4, 1, 1);
echo $hash."";
print_r($access->getRooms());
& output:
Your call to OpenMeetings Web Services returned an unexpected HTTP
status of: 500 Request
http://HOST:5080/openmeetings/services/RoomService/getRoomsWithCurrentUsers?SID=456d4b3fb452e2498e4ace9c0029a7ef&start=1&max=100&orderby=name&asc=1
On 10/21/15, Maxim Solodovnik wrote:
> Yes this might be an issue
> could you please provide repo steps for this?
>
> On Wed, Oct 21, 2015 at 5:30 PM, Jibon L. Costa
> wrote:
>
>> Was the SOAP/REST API changed? I am getting error like this:
>>
>> Exception occurred while trying to invoke service method
>> getRoomsWithCurrentUsers
>>
>>
>> HOST:5080/openmeetings/services/RoomService/getRoomsWithCurrentUsers?SID=456d4b3fb452e2498e4ace9c0029a7ef&start=1&max=100&orderby=name&asc=1
>>
>> On 10/21/15, Maxim Solodovnik wrote:
>> > It is possible but extremely unstable
>> >
>> > On Wed, Oct 21, 2015 at 4:15 PM, Jibon L. Costa
>> >
>> > wrote:
>> >
>> >> 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 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
>> >> > > >> >
>> >> > wrote:
>> >> >
>> >> >> I am using ubuntu 14.04 on a VPS server & Asterisk 11.20
>> >> >>
>> >> >> On 10/20/15, Maxim Solodovnik 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
>> >> >> > > >> >> >
>> >> >> > 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-0081]: 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-0081]: res_odbc.c:1529
>> >> >> >> odbc_obj_connect: Connecting asterisk
>> >> >> >> [Oct 19 14:13:46] NOTICE[5837][C-0081]: res_odbc.c:1568
>> >> >> >> odbc_obj_connect: res_odbc: Connected to asterisk
>> >> [asterisk-connector]
>> >> >> >> [Oct 19 14:13:46] WARNING[5837][C-0081]: 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-0081]: 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-0081]: 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-0081]: res_odbc.c:1529
>> >> >> >> odbc_obj_connect: Connecting asterisk
>> >> >> >> [Oct 19 14:13:51] NOTICE[5837][C-0081]: 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-0081]: 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-0081]: res_odbc.c:653
>> >> >> >> ast_odbc_prepare_and_execute: SQL Execute error -1! Verifying
>> >
Re: SIP Help !!
Yes this might be an issue could you please provide repo steps for this? On Wed, Oct 21, 2015 at 5:30 PM, Jibon L. Costa wrote: > Was the SOAP/REST API changed? I am getting error like this: > > Exception occurred while trying to invoke service method > getRoomsWithCurrentUsers > > > HOST:5080/openmeetings/services/RoomService/getRoomsWithCurrentUsers?SID=456d4b3fb452e2498e4ace9c0029a7ef&start=1&max=100&orderby=name&asc=1 > > On 10/21/15, Maxim Solodovnik wrote: > > It is possible but extremely unstable > > > > On Wed, Oct 21, 2015 at 4:15 PM, Jibon L. Costa > > wrote: > > > >> 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 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 > >> > >> > > >> > wrote: > >> > > >> >> I am using ubuntu 14.04 on a VPS server & Asterisk 11.20 > >> >> > >> >> On 10/20/15, Maxim Solodovnik 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 > >> >> > >> >> > > >> >> > 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-0081]: 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-0081]: res_odbc.c:1529 > >> >> >> odbc_obj_connect: Connecting asterisk > >> >> >> [Oct 19 14:13:46] NOTICE[5837][C-0081]: res_odbc.c:1568 > >> >> >> odbc_obj_connect: res_odbc: Connected to asterisk > >> [asterisk-connector] > >> >> >> [Oct 19 14:13:46] WARNING[5837][C-0081]: 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-0081]: 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-0081]: 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-0081]: res_odbc.c:1529 > >> >> >> odbc_obj_connect: Connecting asterisk > >> >> >> [Oct 19 14:13:51] NOTICE[5837][C-0081]: 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-0081]: 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-0081]: 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-0081]: res_odbc.c:757 > >> >> >> ast_odbc_sanity_check: Connection is down attempting to > >> >> >> reconnect... > >> >> >> > >> >> >> On 10/20/15, Maxim Solodovnik 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 > >> >> >> > >> >> >> > > >> >> >> > 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/buil
Re: SIP Help !!
Was the SOAP/REST API changed? I am getting error like this: Exception occurred while trying to invoke service method getRoomsWithCurrentUsers HOST:5080/openmeetings/services/RoomService/getRoomsWithCurrentUsers?SID=456d4b3fb452e2498e4ace9c0029a7ef&start=1&max=100&orderby=name&asc=1 On 10/21/15, Maxim Solodovnik wrote: > It is possible but extremely unstable > > On Wed, Oct 21, 2015 at 4:15 PM, Jibon L. Costa > wrote: > >> 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 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 >> > > > >> > wrote: >> > >> >> I am using ubuntu 14.04 on a VPS server & Asterisk 11.20 >> >> >> >> On 10/20/15, Maxim Solodovnik 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 >> >> > > >> > >> >> > 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-0081]: 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-0081]: res_odbc.c:1529 >> >> >> odbc_obj_connect: Connecting asterisk >> >> >> [Oct 19 14:13:46] NOTICE[5837][C-0081]: res_odbc.c:1568 >> >> >> odbc_obj_connect: res_odbc: Connected to asterisk >> [asterisk-connector] >> >> >> [Oct 19 14:13:46] WARNING[5837][C-0081]: 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-0081]: 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-0081]: 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-0081]: res_odbc.c:1529 >> >> >> odbc_obj_connect: Connecting asterisk >> >> >> [Oct 19 14:13:51] NOTICE[5837][C-0081]: 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-0081]: 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-0081]: 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-0081]: res_odbc.c:757 >> >> >> ast_odbc_sanity_check: Connection is down attempting to >> >> >> reconnect... >> >> >> >> >> >> On 10/20/15, Maxim Solodovnik 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 >> >> >> > > >> >> > >> >> >> > 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] Compi
Re: SIP Help !!
It is possible but extremely unstable On Wed, Oct 21, 2015 at 4:15 PM, Jibon L. Costa wrote: > 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 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 > > > wrote: > > > >> I am using ubuntu 14.04 on a VPS server & Asterisk 11.20 > >> > >> On 10/20/15, Maxim Solodovnik 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 > >> > >> > > >> > 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-0081]: 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-0081]: res_odbc.c:1529 > >> >> odbc_obj_connect: Connecting asterisk > >> >> [Oct 19 14:13:46] NOTICE[5837][C-0081]: res_odbc.c:1568 > >> >> odbc_obj_connect: res_odbc: Connected to asterisk > [asterisk-connector] > >> >> [Oct 19 14:13:46] WARNING[5837][C-0081]: 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-0081]: 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-0081]: 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-0081]: res_odbc.c:1529 > >> >> odbc_obj_connect: Connecting asterisk > >> >> [Oct 19 14:13:51] NOTICE[5837][C-0081]: 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-0081]: 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-0081]: 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-0081]: res_odbc.c:757 > >> >> ast_odbc_sanity_check: Connection is down attempting to reconnect... > >> >> > >> >> On 10/20/15, Maxim Solodovnik 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 > >> >> > >> >> > > >> >> > 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]
Re: SIP Help !!
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 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 > wrote: > >> I am using ubuntu 14.04 on a VPS server & Asterisk 11.20 >> >> On 10/20/15, Maxim Solodovnik 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 >> > > > >> > 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-0081]: 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-0081]: res_odbc.c:1529 >> >> odbc_obj_connect: Connecting asterisk >> >> [Oct 19 14:13:46] NOTICE[5837][C-0081]: res_odbc.c:1568 >> >> odbc_obj_connect: res_odbc: Connected to asterisk [asterisk-connector] >> >> [Oct 19 14:13:46] WARNING[5837][C-0081]: 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-0081]: 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-0081]: 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-0081]: res_odbc.c:1529 >> >> odbc_obj_connect: Connecting asterisk >> >> [Oct 19 14:13:51] NOTICE[5837][C-0081]: 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-0081]: 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-0081]: 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-0081]: res_odbc.c:757 >> >> ast_odbc_sanity_check: Connection is down attempting to reconnect... >> >> >> >> On 10/20/15, Maxim Solodovnik 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 >> >> > > >> > >> >> > 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]
