Apache Front end for Tomcat

2019-04-18 Thread Aaron Hepp
Finally putting an Apache front end on this install and was following 
the directions on DO for this


https://www.digitalocean.com/community/tutorials/how-to-encrypt-tomcat-8-connections-with-apache-or-nginx-on-ubuntu-16-04

They use mod_jk module to connect Apache to Tomcat.  In their 
documentation it has a setting for where the Tomcat home directory is 
located.


Inside, find the |workers.tomcat_home| directive. Set this to your 
Tomcat installation home directory. For our Tomcat installation, that 
would be |/opt/tomcat|:

/etc/libapache2-mod-jk/workers.properties

|workers.tomcat_home=/opt/tomcat (their example) In an OM4 install where 
is that home directory located? I pointed it to /opt/om4 (my directory 
name) as well as /opt/om4/conf as well as /opt/om4/webapps but none of 
these seem to work. Am I missing something here? |




Re: Apache Front end for Tomcat

2019-04-18 Thread Maxim Solodovnik
I would recommend to check this answer:
https://stackoverflow.com/questions/51721771/apache-openmeetings-4-0-4-csrf-attack-when-using-apache2-as-proxypass

On Fri, 19 Apr 2019 at 05:21, Aaron Hepp  wrote:
>
> Finally putting an Apache front end on this install and was following the 
> directions on DO for this
>
> https://www.digitalocean.com/community/tutorials/how-to-encrypt-tomcat-8-connections-with-apache-or-nginx-on-ubuntu-16-04
>
> They use mod_jk module to connect Apache to Tomcat.  In their documentation 
> it has a setting for where the Tomcat home directory is located.
>
> Inside, find the workers.tomcat_home directive. Set this to your Tomcat 
> installation home directory. For our Tomcat installation, that would be 
> /opt/tomcat:
> /etc/libapache2-mod-jk/workers.properties
>
> workers.tomcat_home=/opt/tomcat (their example)
>
>
> In an OM4 install where is that home directory located?
>
> I pointed it to /opt/om4 (my directory name) as well as /opt/om4/conf as well 
> as /opt/om4/webapps but none of these seem
> to work.  Am I missing something here?
>
>


-- 
WBR
Maxim aka solomax


Re: Apache Front end for Tomcat

2019-04-18 Thread Aaron Hepp
I did try that at 1st and there is some syntax that your config in there 
its does not like.


root@traderoom:/etc/apache2/sites-available# sudo apache2ctl configtest
AH00526: Syntax error on line 37 of 
/etc/apache2/sites-enabled/000-default-le-ssl.conf:
Invalid command 'ProxyPreserveHost', perhaps misspelled or defined by a 
module not included in the server configuration

Action 'configtest' failed.

###  OpenMeetings    ###
## Custom fragment
RewriteEngine On
RewriteCond %{HTTP:Connection} Upgrade [NC]
RewriteCond %{HTTP:Upgrade} websocket [NC]
RewriteRule /(.*) ws://localhost:5080/$1 [P,L]
RedirectMatch ^/$ https://traderoom.amhcapitalgroup.com/trade-group
*_ProxyPreserveHost On_*


I can comment out that line then it does not like:

root@traderoom:/etc/apache2/sites-available# sudo apache2ctl configtest
AH00526: Syntax error on line 41 of 
/etc/apache2/sites-enabled/000-default-le-ssl.conf:
Invalid command 'ProxyPass', perhaps misspelled or defined by a module 
not included in the server configuration

Action 'configtest' failed.


  Require all granted
*_ProxyPass http://localhost:5080/trade-group_*
_*  ProxyPassReverse http://localhost:5080/trade-group*_
  RewriteEngine On
  RewriteRule ^/(.*) http://localhost:5080/$1 [P]


you comment out that and it does not like the next line neither 
(ProxyPassReverse).  Each line after gives the same errors. Maybe you 
can shed some light on that as the site is up and working without errors.


root@traderoom:/etc/apache2/sites-available# curl 
http://localhost:5080/trade-group

root@traderoom:/etc/apache2/sites-available#


On 4/18/19 8:37 PM, Maxim Solodovnik wrote:

I would recommend to check this answer:
https://stackoverflow.com/questions/51721771/apache-openmeetings-4-0-4-csrf-attack-when-using-apache2-as-proxypass

On Fri, 19 Apr 2019 at 05:21, Aaron Hepp  wrote:

Finally putting an Apache front end on this install and was following the 
directions on DO for this

https://www.digitalocean.com/community/tutorials/how-to-encrypt-tomcat-8-connections-with-apache-or-nginx-on-ubuntu-16-04

They use mod_jk module to connect Apache to Tomcat.  In their documentation it 
has a setting for where the Tomcat home directory is located.

Inside, find the workers.tomcat_home directive. Set this to your Tomcat 
installation home directory. For our Tomcat installation, that would be 
/opt/tomcat:
/etc/libapache2-mod-jk/workers.properties

workers.tomcat_home=/opt/tomcat (their example)


In an OM4 install where is that home directory located?

I pointed it to /opt/om4 (my directory name) as well as /opt/om4/conf as well 
as /opt/om4/webapps but none of these seem
to work.  Am I missing something here?








Re: Apache Front end for Tomcat

2019-04-18 Thread Aaron Hepp
so looks like the errors were cause by proxy_module had not loaded.  So 
I loaded the need module (list of modules talked about in the article)


root@traderoom:~# sudo apache2ctl -M
Loaded Modules:
  proxy_module (shared)
 proxy_http_module (shared)
 proxy_wstunnel_module (shared)
 rewrite_module (shared)

And now no errors when running configtest.  But also does not look like 
it is doing any redirection.  you go to the page and you just get the 
default apache page.  Never does forward you into the OM install.


You can access it if you go straight to it using :5080, so looks like 
I'm missing a step somewhere




On 4/18/19 8:37 PM, Maxim Solodovnik wrote:

I would recommend to check this answer:
https://stackoverflow.com/questions/51721771/apache-openmeetings-4-0-4-csrf-attack-when-using-apache2-as-proxypass

On Fri, 19 Apr 2019 at 05:21, Aaron Hepp  wrote:

Finally putting an Apache front end on this install and was following the 
directions on DO for this

https://www.digitalocean.com/community/tutorials/how-to-encrypt-tomcat-8-connections-with-apache-or-nginx-on-ubuntu-16-04

They use mod_jk module to connect Apache to Tomcat.  In their documentation it 
has a setting for where the Tomcat home directory is located.

Inside, find the workers.tomcat_home directive. Set this to your Tomcat 
installation home directory. For our Tomcat installation, that would be 
/opt/tomcat:
/etc/libapache2-mod-jk/workers.properties

workers.tomcat_home=/opt/tomcat (their example)


In an OM4 install where is that home directory located?

I pointed it to /opt/om4 (my directory name) as well as /opt/om4/conf as well 
as /opt/om4/webapps but none of these seem
to work.  Am I missing something here?








Re: Apache Front end for Tomcat

2019-04-18 Thread Maxim Solodovnik
What version of OM do you have?

On Fri, 19 Apr 2019 at 09:12, Aaron Hepp  wrote:
>
> so looks like the errors were cause by proxy_module had not loaded.  So I 
> loaded the need module (list of modules talked about in the article)
>
> root@traderoom:~# sudo apache2ctl -M
> Loaded Modules:
>   proxy_module (shared)
>  proxy_http_module (shared)
>  proxy_wstunnel_module (shared)
>  rewrite_module (shared)
>
> And now no errors when running configtest.  But also does not look like it is 
> doing any redirection.  you go to the page and you just get the default 
> apache page.  Never does forward you into the OM install.
>
> You can access it if you go straight to it using :5080, so looks like I'm 
> missing a step somewhere
>
>
>
> On 4/18/19 8:37 PM, Maxim Solodovnik wrote:
>
> I would recommend to check this answer:
> https://stackoverflow.com/questions/51721771/apache-openmeetings-4-0-4-csrf-attack-when-using-apache2-as-proxypass
>
> On Fri, 19 Apr 2019 at 05:21, Aaron Hepp  wrote:
>
> Finally putting an Apache front end on this install and was following the 
> directions on DO for this
>
> https://www.digitalocean.com/community/tutorials/how-to-encrypt-tomcat-8-connections-with-apache-or-nginx-on-ubuntu-16-04
>
> They use mod_jk module to connect Apache to Tomcat.  In their documentation 
> it has a setting for where the Tomcat home directory is located.
>
> Inside, find the workers.tomcat_home directive. Set this to your Tomcat 
> installation home directory. For our Tomcat installation, that would be 
> /opt/tomcat:
> /etc/libapache2-mod-jk/workers.properties
>
> workers.tomcat_home=/opt/tomcat (their example)
>
>
> In an OM4 install where is that home directory located?
>
> I pointed it to /opt/om4 (my directory name) as well as /opt/om4/conf as well 
> as /opt/om4/webapps but none of these seem
> to work.  Am I missing something here?
>
>
>
>


-- 
WBR
Maxim aka solomax


Re: Asterisk Integration

2019-04-18 Thread Siovel Rodriguez
Hi Maxim, I'm still trying to integrate OM with Asterisk. I have some
doubts. I installed the Zoiper application to perform the tests, I logged
in with the user red5sip_user in the Zoiper application and wanted to know
if after logging in I should see that user (red5sip_user) inside a room in
OM to be able to make the video conference. If you could comment a bit on
the mechanism of operation I would appreciate it because it is not entirely
clear to me.

Regards

El mié., 17 abr. 2019 a las 10:34, Siovel Rodriguez ()
escribió:

> Hi Maxim, I'm still trying to integrate OM with Asterisk. I have some
> doubts. I installed the Zoiper application to perform the tests, I logged
> in with the user red5sip_user in the Zoiper application and wanted to know
> if after logging in I should see that user (red5sip_user) inside a room in
> OM to be able to make the video conference. If you could comment a bit on
> the mechanism of operation I would appreciate it because it is not entirely
> clear to me.
>
> Regards
>
> El jue., 11 abr. 2019 a las 21:12, Maxim Solodovnik ()
> escribió:
>
>> Just have opened old database with working integration
>> There is no `asterisk` table
>>
>> Will try to find time and double-check steps
>>
>> On Fri, 12 Apr 2019 at 01:03, Siovel Rodriguez 
>> wrote:
>>
>>> Yes Maxim, I did everything exactly as it says in the site. Even with
>>> the asterisk version, the asterisk-13.17.0
>>>
>>> El jue., 11 abr. 2019 a las 12:44, Maxim Solodovnik (<
>>> solomax...@gmail.com>) escribió:
>>>
 I have configured Asterisk several years ago
 If I do remember correctly steps listed at site are complete

 Not sure when I'll be able to double check everything :(
 Can you check you are using same version and follow the instruction
 step-by-step?

 On Thu, 11 Apr 2019 at 23:13, Siovel Rodriguez 
 wrote:

> I changed by now I have this in the Asterisk logs
>
> [Apr 11 11:54:05] WARNING[1326] res_config_mysql.c: MySQL RealTime:
> Failed to query database: Table 'open404.asterisk' doesn't exist
>
> Should be create an Asterisk table in open404 data base?
> What should I do?
>
> El jue., 11 abr. 2019 a las 11:35, Maxim Solodovnik (<
> solomax...@gmail.com>) escribió:
>
>> This section describes OM database
>>
>> On Thu, 11 Apr 2019 at 22:10, Siovel Rodriguez 
>> wrote:
>>
>>> Hello Maxim and other members of the OM community, I am trying to
>>> integrate om4.04 with Asterisk. I followed the steps of this link
>>> https://openmeetings.apache.org/voip-sip-integration.html but I
>>> have left the doubt with the following configuration
>>>
>>> Configure MySQL module:
>>>
>>> Set valid data for MySQL in /etc/asterisk/res_config_mysql.conf:
>>> Example
>>>
>>>
>>> [general]
>>> dbhost = 127.0.0.1
>>> dbname = openmeetings
>>> dbuser = root
>>> dbpass =
>>> dbport = 3306
>>> dbsock = /var/lib/mysql/mysql.sock
>>> dbcharset = utf8
>>> requirements = warn
>>>
>>> The database openmeetings is the database of the installation of
>>> OM4.04 or is that of Asterisk?. In that case that database is not
>>> created and the following error appears in the Asterisk logs.
>>> Apr 11 10:40:20] ERROR [1315] res_config_mysql.c: MySQL RealTime:
>>> Failed to connect database server openmeetings on 127.0.0.1 (err 1049). 
>>> Check
>>> debug for more info.
>>>
>>> Please, I would appreciate your help
>>>
>>> Greetings
>>>
>>
>>
>> --
>> WBR
>> Maxim aka solomax
>>
>

 --
 WBR
 Maxim aka solomax

>>>
>>
>> --
>> WBR
>> Maxim aka solomax
>>
>


Re: Asterisk Integration

2019-04-18 Thread Maxim Solodovnik
Hello Siovel,
I'm reading your emails
And i have this task in my TODO list

thanks for pinging me :)

On Fri, 19 Apr 2019 at 10:36, Siovel Rodriguez  wrote:
>
> Hi Maxim, I'm still trying to integrate OM with Asterisk. I have some doubts. 
> I installed the Zoiper application to perform the tests, I logged in with the 
> user red5sip_user in the Zoiper application and wanted to know if after 
> logging in I should see that user (red5sip_user) inside a room in OM to be 
> able to make the video conference. If you could comment a bit on the 
> mechanism of operation I would appreciate it because it is not entirely clear 
> to me.
>
> Regards
>
> El mié., 17 abr. 2019 a las 10:34, Siovel Rodriguez () 
> escribió:
>>
>> Hi Maxim, I'm still trying to integrate OM with Asterisk. I have some 
>> doubts. I installed the Zoiper application to perform the tests, I logged in 
>> with the user red5sip_user in the Zoiper application and wanted to know if 
>> after logging in I should see that user (red5sip_user) inside a room in OM 
>> to be able to make the video conference. If you could comment a bit on the 
>> mechanism of operation I would appreciate it because it is not entirely 
>> clear to me.
>>
>> Regards
>>
>> El jue., 11 abr. 2019 a las 21:12, Maxim Solodovnik () 
>> escribió:
>>>
>>> Just have opened old database with working integration
>>> There is no `asterisk` table
>>>
>>> Will try to find time and double-check steps
>>>
>>> On Fri, 12 Apr 2019 at 01:03, Siovel Rodriguez  wrote:

 Yes Maxim, I did everything exactly as it says in the site. Even with the 
 asterisk version, the asterisk-13.17.0

 El jue., 11 abr. 2019 a las 12:44, Maxim Solodovnik 
 () escribió:
>
> I have configured Asterisk several years ago
> If I do remember correctly steps listed at site are complete
>
> Not sure when I'll be able to double check everything :(
> Can you check you are using same version and follow the instruction 
> step-by-step?
>
> On Thu, 11 Apr 2019 at 23:13, Siovel Rodriguez  wrote:
>>
>> I changed by now I have this in the Asterisk logs
>>
>> [Apr 11 11:54:05] WARNING[1326] res_config_mysql.c: MySQL RealTime: 
>> Failed to query database: Table 'open404.asterisk' doesn't exist
>>
>> Should be create an Asterisk table in open404 data base?
>> What should I do?
>>
>> El jue., 11 abr. 2019 a las 11:35, Maxim Solodovnik 
>> () escribió:
>>>
>>> This section describes OM database
>>>
>>> On Thu, 11 Apr 2019 at 22:10, Siovel Rodriguez  
>>> wrote:

 Hello Maxim and other members of the OM community, I am trying to 
 integrate om4.04 with Asterisk. I followed the steps of this link 
 https://openmeetings.apache.org/voip-sip-integration.html but I have 
 left the doubt with the following configuration

 Configure MySQL module:

 Set valid data for MySQL in /etc/asterisk/res_config_mysql.conf:
 Example


 [general]
 dbhost = 127.0.0.1
 dbname = openmeetings
 dbuser = root
 dbpass =
 dbport = 3306
 dbsock = /var/lib/mysql/mysql.sock
 dbcharset = utf8
 requirements = warn

 The database openmeetings is the database of the installation of 
 OM4.04 or is that of Asterisk?. In that case that database is not 
 created and the following error appears in the Asterisk logs.
 Apr 11 10:40:20] ERROR [1315] res_config_mysql.c: MySQL RealTime: 
 Failed to connect database server openmeetings on 127.0.0.1 (err 
 1049). Check debug for more info.

 Please, I would appreciate your help

 Greetings
>>>
>>>
>>>
>>> --
>>> WBR
>>> Maxim aka solomax
>
>
>
> --
> WBR
> Maxim aka solomax
>>>
>>>
>>>
>>> --
>>> WBR
>>> Maxim aka solomax



-- 
WBR
Maxim aka solomax


Re: Asterisk Integration

2019-04-18 Thread Siovel Rodriguez
Thanks Maxim. I'll be waiting for your help. Very thankful

El jue., 18 abr. 2019 a las 23:42, Maxim Solodovnik ()
escribió:

> Hello Siovel,
> I'm reading your emails
> And i have this task in my TODO list
>
> thanks for pinging me :)
>
> On Fri, 19 Apr 2019 at 10:36, Siovel Rodriguez  wrote:
> >
> > Hi Maxim, I'm still trying to integrate OM with Asterisk. I have some
> doubts. I installed the Zoiper application to perform the tests, I logged
> in with the user red5sip_user in the Zoiper application and wanted to know
> if after logging in I should see that user (red5sip_user) inside a room in
> OM to be able to make the video conference. If you could comment a bit on
> the mechanism of operation I would appreciate it because it is not entirely
> clear to me.
> >
> > Regards
> >
> > El mié., 17 abr. 2019 a las 10:34, Siovel Rodriguez ()
> escribió:
> >>
> >> Hi Maxim, I'm still trying to integrate OM with Asterisk. I have some
> doubts. I installed the Zoiper application to perform the tests, I logged
> in with the user red5sip_user in the Zoiper application and wanted to know
> if after logging in I should see that user (red5sip_user) inside a room in
> OM to be able to make the video conference. If you could comment a bit on
> the mechanism of operation I would appreciate it because it is not entirely
> clear to me.
> >>
> >> Regards
> >>
> >> El jue., 11 abr. 2019 a las 21:12, Maxim Solodovnik (<
> solomax...@gmail.com>) escribió:
> >>>
> >>> Just have opened old database with working integration
> >>> There is no `asterisk` table
> >>>
> >>> Will try to find time and double-check steps
> >>>
> >>> On Fri, 12 Apr 2019 at 01:03, Siovel Rodriguez 
> wrote:
> 
>  Yes Maxim, I did everything exactly as it says in the site. Even with
> the asterisk version, the asterisk-13.17.0
> 
>  El jue., 11 abr. 2019 a las 12:44, Maxim Solodovnik (<
> solomax...@gmail.com>) escribió:
> >
> > I have configured Asterisk several years ago
> > If I do remember correctly steps listed at site are complete
> >
> > Not sure when I'll be able to double check everything :(
> > Can you check you are using same version and follow the instruction
> step-by-step?
> >
> > On Thu, 11 Apr 2019 at 23:13, Siovel Rodriguez 
> wrote:
> >>
> >> I changed by now I have this in the Asterisk logs
> >>
> >> [Apr 11 11:54:05] WARNING[1326] res_config_mysql.c: MySQL RealTime:
> Failed to query database: Table 'open404.asterisk' doesn't exist
> >>
> >> Should be create an Asterisk table in open404 data base?
> >> What should I do?
> >>
> >> El jue., 11 abr. 2019 a las 11:35, Maxim Solodovnik (<
> solomax...@gmail.com>) escribió:
> >>>
> >>> This section describes OM database
> >>>
> >>> On Thu, 11 Apr 2019 at 22:10, Siovel Rodriguez 
> wrote:
> 
>  Hello Maxim and other members of the OM community, I am trying to
> integrate om4.04 with Asterisk. I followed the steps of this link
> https://openmeetings.apache.org/voip-sip-integration.html but I have left
> the doubt with the following configuration
> 
>  Configure MySQL module:
> 
>  Set valid data for MySQL in /etc/asterisk/res_config_mysql.conf:
>  Example
> 
> 
>  [general]
>  dbhost = 127.0.0.1
>  dbname = openmeetings
>  dbuser = root
>  dbpass =
>  dbport = 3306
>  dbsock = /var/lib/mysql/mysql.sock
>  dbcharset = utf8
>  requirements = warn
> 
>  The database openmeetings is the database of the installation of
> OM4.04 or is that of Asterisk?. In that case that database is not created
> and the following error appears in the Asterisk logs.
>  Apr 11 10:40:20] ERROR [1315] res_config_mysql.c: MySQL RealTime:
> Failed to connect database server openmeetings on 127.0.0.1 (err 1049).
> Check debug for more info.
> 
>  Please, I would appreciate your help
> 
>  Greetings
> >>>
> >>>
> >>>
> >>> --
> >>> WBR
> >>> Maxim aka solomax
> >
> >
> >
> > --
> > WBR
> > Maxim aka solomax
> >>>
> >>>
> >>>
> >>> --
> >>> WBR
> >>> Maxim aka solomax
>
>
>
> --
> WBR
> Maxim aka solomax
>