RE: Help to solve a requirement about active connections vs configured connection

2018-11-06 Thread Gabriel Huerta Araujo 

989jloyola  152113795  152113798200013.72.69.118 SAM 
CARRIER   False

990jloyola  1521137998000  15211380313.72.69.118 SAM 
CARRIER   False

991jloyola  1521138046000  152113807800013.72.69.118 SAM 
CARRIER   False

992jloyola  1521138094000  152113812600013.72.69.118 SAM 
CARRIER   False

993jloyola  1521138142000  152113817400013.72.69.118 SAM 
CARRIER   False

994jloyola  152113819  152113822200013.72.69.118 SAM 
CARRIER   False

995jloyola  1521138238000  15211382713.72.69.118 SAM 
CARRIER   False

996jloyola  1521138286000  152113831800013.72.69.118 SAM 
CARRIER   False

997jloyola  1521138334000  152113836600013.72.69.118 SAM 
CARRIER   False

998jloyola  1521138382000  152113841400013.72.69.118 SAM 
CARRIER   False

9991000740  1521133871000  1521138415000   10.105.131.51 RAD 
CNS4 32   False



[1000 rows x 6 columns]





Thanks a lot for your valuable help.



Regards



De: Gabriel Huerta Araujo [mailto:huert...@globalhitss.com]
Enviado el: martes, 06 de noviembre de 2018 04:42 p.m.
Para: 'user@guacamole.apache.org'
Asunto: RE: Help to solve a requirement about active connections vs configured 
connection



Thanks for your valuable help



I made it run, but this error arises



$ python guacamole-cli.py -a

Traceback (most recent call last):

  File "guacamole-cli.py", line 83, in 

myLoginData = login('gabriel','gabriel')

  File "guacamole-cli.py", line 27, in login

loginResponse = urllib2.urlopen(loginRequest)

  File "/usr/lib/python2.7/urllib2.py", line 154, in urlopen

return opener.open(url, data, timeout)

  File "/usr/lib/python2.7/urllib2.py", line 429, in open

response = self._open(req, data)

  File "/usr/lib/python2.7/urllib2.py", line 447, in _open

'_open', req)

  File "/usr/lib/python2.7/urllib2.py", line 407, in _call_chain

result = func(*args)

  File "/usr/lib/python2.7/urllib2.py", line 1228, in http_open

return self.do_open(httplib.HTTPConnection, req)

  File "/usr/lib/python2.7/urllib2.py", line 1198, in do_open

raise URLError(err)

urllib2.URLError: 





And I am using user who I access to web application with







I made these changes



#guacbase = "https://localhost/guacamole;

guacbase =  <http://localhost/ga> http://localhost/ga





# Login

#myLoginData = login('guacuser','guacpass')

myLoginData = login('gabriel','gabriel')



What seems to be the problem?



Regards.







De: Gabriel Huerta Araujo [mailto:huert...@globalhitss.com]
Enviado el: jueves, 01 de noviembre de 2018 07:28 p.m.
Para: user@guacamole.apache.org
Asunto: RE: Help to solve a requirement about active connections vs configured 
connection



Thank you so much Nick



I’ll check it. If I had a doubt I hope I can continue asking about this matter.



Meanwhile have a great night.



Regards



De: Nick Couchman [ <mailto:vn...@apache.org> mailto:vn...@apache.org]
Enviado el: jueves, 01 de noviembre de 2018 06:02 p.m.
Para:  <mailto:user@guacamole.apache.org> user@guacamole.apache.org
Asunto: Re: Help to solve a requirement about active connections vs configured 
connection



I appreciate your soon answer. If I wanted this information in real time? And 
in an automatic way without accessing to Guacamole web application?



The web application is based on a REST API, so retrieving the data displayed on 
this page should be relatively easy.  I don't recall which API endpoint that 
page calls off the top of my head, but it should be pretty easy to track it 
down by watching the calls in one of the browser developer consoles, or by 
digging through the AngularJS code that defines these pages. The data is all 
returned in JSON format so it should be pretty easy to write some coffee to 
retrieve it.



Actually, once upon a time I wrote the beginnings of a Python script that 
handled some of these adminstrative tasks.  Code is in repo below - it is 
probably a little out of date against the current Guacamole code, but should at 
least get you started.



https://github.com/necouchman/guacamole-python





-Nick




 
<http://www.avg.com/email-signature?utm_medium=email_source=link_campaign=sig-email_content=emailclient>

Libre de virus.  
<http://www.avg.com/email-signature?utm_medium=email_source=link_campaign=sig-email_content=emailclient>
 www.avg.com





---
Este correo electrónico ha sido comprobado en busca de virus por AVG.
http://www.avg.com

RE: Help to solve a requirement about active connections vs configured connection

2018-11-06 Thread Gabriel Huerta Araujo 
Thanks for your valuable help



I made it run, but this error arises



$ python guacamole-cli.py -a

Traceback (most recent call last):

  File "guacamole-cli.py", line 83, in 

myLoginData = login('gabriel','gabriel')

  File "guacamole-cli.py", line 27, in login

loginResponse = urllib2.urlopen(loginRequest)

  File "/usr/lib/python2.7/urllib2.py", line 154, in urlopen

return opener.open(url, data, timeout)

  File "/usr/lib/python2.7/urllib2.py", line 429, in open

response = self._open(req, data)

  File "/usr/lib/python2.7/urllib2.py", line 447, in _open

'_open', req)

  File "/usr/lib/python2.7/urllib2.py", line 407, in _call_chain

result = func(*args)

  File "/usr/lib/python2.7/urllib2.py", line 1228, in http_open

return self.do_open(httplib.HTTPConnection, req)

  File "/usr/lib/python2.7/urllib2.py", line 1198, in do_open

raise URLError(err)

urllib2.URLError: 





And I am using user who I access to web application with







I made these changes



#guacbase = "https://localhost/guacamole;

guacbase =  <http://localhost/ga> http://localhost/ga





# Login

#myLoginData = login('guacuser','guacpass')

myLoginData = login('gabriel','gabriel')



What seems to be the problem?



Regards.







De: Gabriel Huerta Araujo [mailto:huert...@globalhitss.com]
Enviado el: jueves, 01 de noviembre de 2018 07:28 p.m.
Para: user@guacamole.apache.org
Asunto: RE: Help to solve a requirement about active connections vs configured 
connection



Thank you so much Nick



I’ll check it. If I had a doubt I hope I can continue asking about this matter.



Meanwhile have a great night.



Regards



De: Nick Couchman [ <mailto:vn...@apache.org> mailto:vn...@apache.org]
Enviado el: jueves, 01 de noviembre de 2018 06:02 p.m.
Para:  <mailto:user@guacamole.apache.org> user@guacamole.apache.org
Asunto: Re: Help to solve a requirement about active connections vs configured 
connection



I appreciate your soon answer. If I wanted this information in real time? And 
in an automatic way without accessing to Guacamole web application?



The web application is based on a REST API, so retrieving the data displayed on 
this page should be relatively easy.  I don't recall which API endpoint that 
page calls off the top of my head, but it should be pretty easy to track it 
down by watching the calls in one of the browser developer consoles, or by 
digging through the AngularJS code that defines these pages. The data is all 
returned in JSON format so it should be pretty easy to write some coffee to 
retrieve it.



Actually, once upon a time I wrote the beginnings of a Python script that 
handled some of these adminstrative tasks.  Code is in repo below - it is 
probably a little out of date against the current Guacamole code, but should at 
least get you started.



https://github.com/necouchman/guacamole-python





-Nick




 
<http://www.avg.com/email-signature?utm_medium=email_source=link_campaign=sig-email_content=emailclient>

Libre de virus.  
<http://www.avg.com/email-signature?utm_medium=email_source=link_campaign=sig-email_content=emailclient>
 www.avg.com





---
Este correo electrónico ha sido comprobado en busca de virus por AVG.
http://www.avg.com

RE: Help to solve a requirement about active connections vs configured connection

2018-11-01 Thread Gabriel Huerta Araujo 
Thank you so much Nick



I’ll check it. If I had a doubt I hope I can continue asking about this matter.



Meanwhile have a great night.



Regards



De: Nick Couchman [mailto:vn...@apache.org]
Enviado el: jueves, 01 de noviembre de 2018 06:02 p.m.
Para: user@guacamole.apache.org
Asunto: Re: Help to solve a requirement about active connections vs configured 
connection



I appreciate your soon answer. If I wanted this information in real time? And 
in an automatic way without accessing to Guacamole web application?



The web application is based on a REST API, so retrieving the data displayed on 
this page should be relatively easy.  I don't recall which API endpoint that 
page calls off the top of my head, but it should be pretty easy to track it 
down by watching the calls in one of the browser developer consoles, or by 
digging through the AngularJS code that defines these pages. The data is all 
returned in JSON format so it should be pretty easy to write some coffee to 
retrieve it.



Actually, once upon a time I wrote the beginnings of a Python script that 
handled some of these adminstrative tasks.  Code is in repo below - it is 
probably a little out of date against the current Guacamole code, but should at 
least get you started.



https://github.com/necouchman/guacamole-python





-Nick



---
Este correo electrónico ha sido comprobado en busca de virus por AVG.
http://www.avg.com

Re: Help to solve a requirement about active connections vs configured connection

2018-11-01 Thread Nick Couchman 
>
> I appreciate your soon answer. If I wanted this information in real time?
> And in an automatic way without accessing to Guacamole web application?
>

The web application is based on a REST API, so retrieving the data
displayed on this page should be relatively easy.  I don't recall which API
endpoint that page calls off the top of my head, but it should be pretty
easy to track it down by watching the calls in one of the browser developer
consoles, or by digging through the AngularJS code that defines these
pages. The data is all returned in JSON format so it should be pretty easy
to write some coffee to retrieve it.

Actually, once upon a time I wrote the beginnings of a Python script that
handled some of these adminstrative tasks.  Code is in repo below - it is
probably a little out of date against the current Guacamole code, but
should at least get you started.

https://github.com/necouchman/guacamole-python


-Nick

RE: Help to solve a requirement about active connections vs configured connection

2018-11-01 Thread Gabriel Huerta Araujo 
Hi Mike



I appreciate your soon answer. If I wanted this information in real time? And 
in an automatic way without accessing to Guacamole web application?



Regards.



De: Mike Jumper [mailto:mjum...@apache.org]
Enviado el: jueves, 01 de noviembre de 2018 11:41 a.m.
Para: user@guacamole.apache.org
Asunto: Re: Help to solve a requirement about active connections vs configured 
connection



You can see which connections are used in the history:



http://guacamole.apache.org/doc/gug/administration.html#connection-history



This exposes all or part of the guacamole_connection_history table (there is an 
upper limit to the number of history entries which will be returned via the web 
UI):



http://guacamole.apache.org/doc/gug/jdbc-auth.html#jdbc-auth-schema-connection-history



Active connections are displayed and manageable through another section of the 
admin interface:



http://guacamole.apache.org/doc/gug/administration.html#session-management



- Mike





On Thu, Nov 1, 2018, 10:36 Gabriel Huerta Araujo http://www.avg.com/internet-security> Logotipo de AVG

Este correo electrónico ha sido comprobado en busca de virus con el software 
antivirus AVG.
www.avg.com <http://www.avg.com/internet-security>







---
Este correo electrónico ha sido comprobado en busca de virus por AVG.
http://www.avg.com

Re: Help to solve a requirement about active connections vs configured connection

2018-11-01 Thread Mike Jumper 
You can see which connections are used in the history:

http://guacamole.apache.org/doc/gug/administration.html#connection-history

This exposes all or part of the guacamole_connection_history table (there
is an upper limit to the number of history entries which will be returned
via the web UI):

http://guacamole.apache.org/doc/gug/jdbc-auth.html#jdbc-auth-schema-connection-history

Active connections are displayed and manageable through another section of
the admin interface:

http://guacamole.apache.org/doc/gug/administration.html#session-management

- Mike


On Thu, Nov 1, 2018, 10:36 Gabriel Huerta Araujo  Hi
>
>
>
> I have a doubt about Guacamole. My question is how can I know active
> sessions and compare them with configured connections in order to know if
> all configured connections are really used. Or where I could find
> information in order to make some implementation which accesses REST
> information related to active connections and compare them against what is
> configured in MySQL database in guacamole_connection_permission table.
>
>
>
> Regards
>
>
> --
> [image: Logotipo de AVG] 
>
> Este correo electrónico ha sido comprobado en busca de virus con el
> software antivirus AVG.
> www.avg.com 
>
>
> <#m_-6276727722064041211_m_-2053675576756352524_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
>

Help to solve a requirement about active connections vs configured connection

2018-11-01 Thread Gabriel Huerta Araujo 
Hi



I have a doubt about Guacamole. My question is how can I know active
sessions and compare them with configured connections in order to know if
all configured connections are really used. Or where I could find
information in order to make some implementation which accesses REST
information related to active connections and compare them against what is
configured in MySQL database in guacamole_connection_permission table.



Regards



---
Este correo electrónico ha sido comprobado en busca de virus por AVG.
http://www.avg.com