[web2py] Re: web2py compatibility for python3

[Michael M]

Should this information be updated in "The Book"?

On Tuesday, January 30, 2018 at 8:09:14 AM UTC-8, Anthony wrote:
>
> As of version 2.15, web2py does in fact support Python 3.
>
> On Tuesday, January 30, 2018 at 11:07:51 AM UTC-5, 
> narendr...@routemobile.com  wrote:
>>
>> Hi, 
>>
>> currently web2py did not support python3.
>> Please let me know, when web2py will support python 3?
>>
>> Regards
>> Narendra Kumar
>>
>>

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Docker

[Michael M]

Hello all, I put together a docker build:

https://github.com/preactive/web2py-docker-centos7-nginx-uwsgi

I tested it out on a CentOS7 Azure docker host image. Worked.

Just FYI.  ;-)

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: Web2py Added to Vinta's Awesome-Python

[Michael M]

My change has been merged.

https://github.com/vinta/awesome-python/blob/master/README.md#web-frameworks

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: user name case sensitivity

[Michael M]

That makes complete sense.  ill spin up another app and give it a try. 
 Thank-you for responding to that.  :)

On Friday, August 12, 2016 at 8:36:51 PM UTC-7, Joe Barnhart wrote:
>
> There is one important issue -- the line setting the case sensitivity on 
> auth.settings must occur BEFORE the tables are generated.  If the line 
> occurs after the auth table is generated it has no effect.  At lease this 
> was the case when I first ran afoul of it a year ago.
>
> -- Joe
>
>
> On Tuesday, July 19, 2016 at 4:47:49 PM UTC-7, Michael Messmer wrote:
>>
>> I added it and it still didn't work.  But I am using LDAP-AD login 
>> method. 
>>
>>
>>

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: UWSGI root vs limited user.

[Michael M]

Figured it out:

Niplod you may be proud.  I ran strace in the in the in the service:

[Unit]
Description=uWSGI Emperor Service
After=syslog.target

[Service]
EnvironmentFile=-/etc/sysconfig/uwsgi
ExecStartPre=/bin/mkdir -p /run/uwsgi
ExecStartPre=/bin/chown uwsgi:uwsgi /run/uwsgi
ExecStart=/bin/strace -o /tmp/uwsgi.service /usr/sbin/uwsgi --ini 
/etc/uwsgi.ini
ExecReload=/bin/kill -HUP $MAINPID
KillSignal=SIGINT
Restart=always
Type=notify
StandardError=syslog
NotifyAccess=all

[Install]
WantedBy=multi-user.target



---
Which exposed this as i trolled through tons to find some keywords pop out 
at:

cat /tmp/uwsgi.service |wc -l
15031

cat /tmp/uwsgi.service |grep "Permission denied"
openat(AT_FDCWD, "/opt/www-data/web2py/site-packages", 
O_RDONLY|O_NONBLOCK|O_DIRECTORY|O_CLOEXEC) = -1 EACCES (Permission denied)
openat(AT_FDCWD, "/opt/www-data/web2py/gluon", 
O_RDONLY|O_NONBLOCK|O_DIRECTORY|O_CLOEXEC) = -1 EACCES (Permission denied)
open("/opt/www-data/web2py/VERSION", O_RDONLY) = -1 EACCES (Permission 
denied)

so i: 
chown u+r /opt/www-data/web2py/VERSION
chown u+r /opt/www-data/web2py/site-packages
chown u+r /opt/www-data/web2py/gluon

restarted ( systemctl restart uwsgi.service ) uwsgi

Loaded perfectly.

Web2py now running as limited user "uwsgi" and not root!!!WOOHOO






On Monday, July 18, 2016 at 4:44:57 PM UTC-7, Michael Messmer wrote:
>
> Environment
> nginx & uwsgi
> Rhel7
> web2py: Version 2.14.6-stable+timestamp.2016.05.09.19.18.48
> (Running on Unknown, Python 2.7.5)
>
> ---
> uwsgi.ini file
> ---
> [uwsgi]
> master = true
> processes = 4
> max-requests = 50
>
> enable-threads = true
>
> chdir  = /opt/www-data/web2py
> module = wsgihandler:application
>
> plugin = python
> logto  = /var/log/nginx/uwsgi.log
>
> #gid = uwsgi
> #uid = uwsgi 
>
> socket = /run/uwsgi/web2py.sock
> chown-socket = uwsgi:nginx
> chmod-socket = 666
> vacuum = true
>
>
>
>
>
>
>
> ---
> running as root user & working
> ---
>
> *** Starting uWSGI 2.0.12 (64bit) on [Mon Jul 18 16:38:43 2016] ***
> compiled with version: 4.8.5 20150623 (Red Hat 4.8.5-4) on 02 January 2016 
> 19:52:54
> os: Linux-3.10.0-327.22.2.el7.x86_64 #1 SMP Thu Jun 9 10:09:10 EDT 2016
> nodename: n01
> machine: x86_64
> clock source: unix
> pcre jit disabled
> detected number of CPU cores: 8
> current working directory: /
> detected binary path: /usr/sbin/uwsgi
> chdir() to /opt/www-data/web2py
> your processes number limit is 63467
> your memory page size is 4096 bytes
> detected max file descriptor number: 1024
> lock engine: pthread robust mutexes
> thunder lock: disabled (you can enable it with --thunder-lock)
> uwsgi socket 0 bound to UNIX address /run/uwsgi/web2py.sock fd 4
> uWSGI running as root, you can use --uid/--gid/--chroot options
> *** WARNING: you are running uWSGI as root !!! (use the --uid flag) *** 
> Python version: 2.7.5 (default, Oct 11 2015, 17:47:16)  [GCC 4.8.3 
> 20140911 (Red Hat 4.8.3-9)]
> Python main interpreter initialized at 0xaa8ec0
> python threads support enabled
> your server socket listen backlog is limited to 100 connections
> your mercy for graceful operations on workers is 60 seconds
> mapped 363840 bytes (355 KB) for 4 cores
> *** Operational MODE: preforking ***
> WSGI app 0 (mountpoint='') ready in 0 seconds on interpreter 0xaa8ec0 pid: 
> 7140 (default app)
> *** uWSGI is running in multiple interpreter mode ***
> spawned uWSGI master process (pid: 7140)
> spawned uWSGI worker 1 (pid: 7154, cores: 1)
> spawned uWSGI worker 2 (pid: 7155, cores: 1)
> spawned uWSGI worker 3 (pid: 7156, cores: 1)
> spawned uWSGI worker 4 (pid: 7157, cores: 1)
>
>
>
>
> 
> running as uwsgi user & not working
> 
>
> *** Starting uWSGI 2.0.12 (64bit) on [Mon Jul 18 16:31:51 2016] ***
> compiled with version: 4.8.5 20150623 (Red Hat 4.8.5-4) on 02 January 2016 
> 19:52:54
> os: Linux-3.10.0-327.22.2.el7.x86_64 #1 SMP Thu Jun 9 10:09:10 EDT 2016
> nodename: n01
> machine: x86_64
> clock source: unix
> pcre jit disabled
> detected number of CPU cores: 8
> current working directory: /
> detected binary path: /usr/sbin/uwsgi
> chdir() to /opt/www-data/web2py
> your processes number limit is 63467
> your memory page size is 4096 bytes
> detected max file descriptor number: 1024
> lock engine: pthread robust mutexes
> thunder lock: disabled (you can enable it with --thunder-lock)
> uwsgi socket 0 bound to UNIX address /run/uwsgi/web2py.sock fd 4
> setgid() to 168
> set additional group 169 (nginx)
> setuid() to 168
> Python version: 2.7.5 (default, Oct 11 2015, 17:47:16)  [GCC 4.8.3 
> 20140911 (Red Hat 4.8.3-9)]
> Python main interpreter initialized at 0x1692ef0
> python threads support enabled
> your server socket listen backlog is limited to 100 connections
> your mercy for graceful operations on workers is 60 seconds
> mapped 363840 bytes (355 KB) for 4 cores
> *** Operational MODE: preforking ***
> Traceback (most recent call last):
>   File "./wsgihandler.py", line 37, in 

[web2py] Re: Scheduler as a service RHEL 7

[Michael M]

Sorry Dave, I know how that goes :)

If you find a more elegant solution. I'm open.  

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: Oracle Driver Not Available When web2py run from bash script

[Michael M]

CX_Oracle and instantclient are weird about permissions. 

See where they get installed on your system with command "locate" and report 
back the output of "ls -l" in the directory it was found in.

Also run "ps -aux|grep web2py" and see who the user is running it under the 
different methods you explained.

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: Scheduler as a service RHEL 7

[Michael M]

So some googling later for "Persistant Python script Rhel7 service"
I changed the service to the following and now the service will run.


-
[Unit]
Description=Web2py Scheduler service

[Service]
ExecStart=/usr/bin/python /opt/www-data/web2py/web2py.py -K 
networktools,networktools,networktools
Type=simple

[Install]
WantedBy=multi-user.target
--

On Tuesday, March 15, 2016 at 4:43:23 PM UTC-7, Michael M wrote:
>
> I read though that a ton of times but I believe RHEL 7 retired that method 
> in /etc/init/ and conf files and moved to systemd and services.  
>
> Ill try the sudo in ExecStart.  And report back.
>
> On Tuesday, March 15, 2016 at 3:36:30 PM UTC-7, Dave S wrote:
>>
>> On Tuesday, March 15, 2016 at 2:35:40 PM UTC-7, Michael M wrote:
>>>
>>> I'm not stuck on getting it running as a Service.  
>>>
>>> Just getting it so it runs when the server is power cycled or 
>>> otherwise.  Insuring that the scheduler is running so it can do DB updates 
>>> of flat-files that get dumped on the box daily.
>>>
>>
>> It's not clear whether that runs at an appropriate privilege level.  The 
>> upstart example in the deployment recipes has an explicit sudo in the 
>> invocation.  Do you need a sudo in your ExecStart?
>>
>> > http://web2py.com/books/default/chapter/29/13/deployment-recipes#Start-the-scheduler-as-a-Linux-service--upstart-
>> >
>>
>> /dps
>>
>>

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: Scheduler as a service RHEL 7

[Michael M]

I read though that a ton of times but I believe RHEL 7 retired that method 
in /etc/init/ and conf files and moved to systemd and services.  

Ill try the sudo in ExecStart.  And report back.

On Tuesday, March 15, 2016 at 3:36:30 PM UTC-7, Dave S wrote:
>
> On Tuesday, March 15, 2016 at 2:35:40 PM UTC-7, Michael M wrote:
>>
>> I'm not stuck on getting it running as a Service.  
>>
>> Just getting it so it runs when the server is power cycled or otherwise.  
>> Insuring that the scheduler is running so it can do DB updates of 
>> flat-files that get dumped on the box daily.
>>
>
> It's not clear whether that runs at an appropriate privilege level.  The 
> upstart example in the deployment recipes has an explicit sudo in the 
> invocation.  Do you need a sudo in your ExecStart?
>
>  http://web2py.com/books/default/chapter/29/13/deployment-recipes#Start-the-scheduler-as-a-Linux-service--upstart-
> >
>
> /dps
>
>

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: Scheduler as a service RHEL 7

[Michael M]

I'm not stuck on getting it running as a Service.  

Just getting it so it runs when the server is power cycled or otherwise.  
Insuring that the scheduler is running so it can do DB updates of 
flat-files that get dumped on the box daily.

On Sunday, March 13, 2016 at 7:32:47 PM UTC-7, Michael M wrote:
>
> When I take off the '&' at the end of the command I get the following 
> message:
>
> # systemctl restart web2py-scheduler.service 
> Job for web2py-scheduler.service failed because a fatal signal was 
> delivered to the control process. See "systemctl status 
> web2py-scheduler.service" and "journalctl -xe" for details.
>
>
> On Sunday, March 13, 2016 at 7:27:30 PM UTC-7, Michael M wrote:
>>
>> [root@server~]# systemctl status web2py-scheduler.service -l
>> ● web2py-scheduler.service - Web2py Scheduler service
>>Loaded: loaded (/etc/systemd/system/web2py-scheduler.service; enabled; 
>> vendor preset: disabled)
>>Active: activating (start) since Sun 2016-03-13 19:09:14 PDT; 38s ago
>>  Main PID: 13549 (python)
>>CGroup: /system.slice/web2py-scheduler.service
>>└─13549 /usr/bin/python /opt/www-data/web2py/web2py.py -K 
>> networktools &
>>
>> Mar 13 19:09:14 server systemd[1]: Starting Web2py Scheduler service.
>>
>> On Saturday, March 12, 2016 at 5:20:36 PM UTC-8, Michael M wrote:
>>>
>>> Currently I have "/etc/systemd/system/web2py-scheduler.service":
>>> -
>>> [Unit]
>>> Description=Web2py Scheduler service
>>>
>>> chedulerService]
>>> ExecStart=  /usr/bin/python /opt/www-data/web2py/web2py.py -K 
>>> networktools -Q &
>>> Restart=always
>>> KillSignal=SIGQUIT
>>> Type=notify
>>> NotifyAccess=all
>>>
>>> [Install]
>>> WantedBy=multi-user.target
>>> ---
>>>
>>>
>>> RHEL 7 and Im when i enable and start then get status i get "starting"  
>>> but never fully starts.  Am i calling it wrong or any thoughts?
>>>
>>> Thanks!
>>>
>>

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: Scheduler as a service RHEL 7

[Michael M]

When I take off the '&' at the end of the command I get the following 
message:

# systemctl restart web2py-scheduler.service 
Job for web2py-scheduler.service failed because a fatal signal was 
delivered to the control process. See "systemctl status 
web2py-scheduler.service" and "journalctl -xe" for details.


On Sunday, March 13, 2016 at 7:27:30 PM UTC-7, Michael M wrote:
>
> [root@server~]# systemctl status web2py-scheduler.service -l
> ● web2py-scheduler.service - Web2py Scheduler service
>Loaded: loaded (/etc/systemd/system/web2py-scheduler.service; enabled; 
> vendor preset: disabled)
>Active: activating (start) since Sun 2016-03-13 19:09:14 PDT; 38s ago
>  Main PID: 13549 (python)
>CGroup: /system.slice/web2py-scheduler.service
>└─13549 /usr/bin/python /opt/www-data/web2py/web2py.py -K 
> networktools &
>
> Mar 13 19:09:14 server systemd[1]: Starting Web2py Scheduler service.
>
> On Saturday, March 12, 2016 at 5:20:36 PM UTC-8, Michael M wrote:
>>
>> Currently I have "/etc/systemd/system/web2py-scheduler.service":
>> -
>> [Unit]
>> Description=Web2py Scheduler service
>>
>> chedulerService]
>> ExecStart=  /usr/bin/python /opt/www-data/web2py/web2py.py -K 
>> networktools -Q &
>> Restart=always
>> KillSignal=SIGQUIT
>> Type=notify
>> NotifyAccess=all
>>
>> [Install]
>> WantedBy=multi-user.target
>> ---
>>
>>
>> RHEL 7 and Im when i enable and start then get status i get "starting"  
>> but never fully starts.  Am i calling it wrong or any thoughts?
>>
>> Thanks!
>>
>

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: Scheduler as a service RHEL 7

[Michael M]

[root@server~]# systemctl status web2py-scheduler.service -l
● web2py-scheduler.service - Web2py Scheduler service
   Loaded: loaded (/etc/systemd/system/web2py-scheduler.service; enabled; 
vendor preset: disabled)
   Active: activating (start) since Sun 2016-03-13 19:09:14 PDT; 38s ago
 Main PID: 13549 (python)
   CGroup: /system.slice/web2py-scheduler.service
   └─13549 /usr/bin/python /opt/www-data/web2py/web2py.py -K 
networktools &

Mar 13 19:09:14 server systemd[1]: Starting Web2py Scheduler service.

On Saturday, March 12, 2016 at 5:20:36 PM UTC-8, Michael M wrote:
>
> Currently I have "/etc/systemd/system/web2py-scheduler.service":
> -
> [Unit]
> Description=Web2py Scheduler service
>
> chedulerService]
> ExecStart=  /usr/bin/python /opt/www-data/web2py/web2py.py -K networktools 
> -Q &
> Restart=always
> KillSignal=SIGQUIT
> Type=notify
> NotifyAccess=all
>
> [Install]
> WantedBy=multi-user.target
> ---
>
>
> RHEL 7 and Im when i enable and start then get status i get "starting"  
> but never fully starts.  Am i calling it wrong or any thoughts?
>
> Thanks!
>

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Scheduler as a service RHEL 7

[Michael M]

Currently I have "/etc/systemd/system/web2py-scheduler.service":
-
[Unit]
Description=Web2py Scheduler service

chedulerService]
ExecStart=  /usr/bin/python /opt/www-data/web2py/web2py.py -K networktools 
-Q &
Restart=always
KillSignal=SIGQUIT
Type=notify
NotifyAccess=all

[Install]
WantedBy=multi-user.target
---


RHEL 7 and Im when i enable and start then get status i get "starting"  but 
never fully starts.  Am i calling it wrong or any thoughts?

Thanks!

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Send Mail with AppRelay Server

[Michael M]

Hello,  I was recently instructed to use our internal apprelay server for 
sending email internally.

But one of the quirks of the server is that is does not require username or 
password.  

how do I do I got about doing that because when I comment out in the db.py 
and appconf.ini the lines that refer to login I get the following:


web2py™ Version 2.13.3-stable+timestamp.2015.12.24.08.08.22
Python Python 2.7.5: /usr/bin/uwsgi (prefix: /usr)Traceback

1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.

Traceback (most recent call last):
  File "/opt/www-data/web2py/gluon/main.py", line 450, in wsgibase
serve_controller(request, response, session)
  File "/opt/www-data/web2py/gluon/main.py", line 186, in serve_controller
run_models_in(environment)
  File "/opt/www-data/web2py/gluon/compileapp.py", line 576, in run_models_in
restricted(code, environment, layer=model)
  File "/opt/www-data/web2py/gluon/restricted.py", line 227, in restricted
exec ccode in environment
  File "/opt/www-data/web2py/applications/networktools/models/db.py" 
,
 line 89, in 
mail.settings.login = myconf.take('smtp.login')
  File "/opt/www-data/web2py/gluon/contrib/appconfig.py", line 70, in take
(part, '-->'.join(walking)))
BaseException: login not in config [smtp]


So i figured on the backend its looking for login explicitly.

Anything thought or options.

Otherwise should I just use an external library and doing something like 
the following (but I would like to use the baked in tools) :

# email
import smtplib
from email.MIMEMultipart import MIMEMultipart
from email.MIMEText import MIMEText
from email.Utils import formatdate

try:
s = smtplib.SMTP('server.com')
except:
print "error connecting to email server"
return -1
try:
s.sendmail(m_from,m_to,msg.as_string())
s.quit()
except:
print "error sendmail email report"
s.quit()
return -1

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Send Mail with AppRelay Server

[Michael M]

Hello,  I was recently instructed to use our internal apprelay server for 
sending email internally.

But one of the quirks of the server is that is does not require username or 
password.  

how do I do I got about doing that because when I comment out in the db.py 
and appconf.ini the lines that refer to login I get the following:


web2py™ Version 2.13.3-stable+timestamp.2015.12.24.08.08.22
Python Python 2.7.5: /usr/bin/uwsgi (prefix: /usr)Traceback

1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.

Traceback (most recent call last):
  File "/opt/www-data/web2py/gluon/main.py", line 450, in wsgibase
serve_controller(request, response, session)
  File "/opt/www-data/web2py/gluon/main.py", line 186, in serve_controller
run_models_in(environment)
  File "/opt/www-data/web2py/gluon/compileapp.py", line 576, in run_models_in
restricted(code, environment, layer=model)
  File "/opt/www-data/web2py/gluon/restricted.py", line 227, in restricted
exec ccode in environment
  File "/opt/www-data/web2py/applications/networktools/models/db.py" 
,
 line 89, in 
mail.settings.login = myconf.take('smtp.login')
  File "/opt/www-data/web2py/gluon/contrib/appconfig.py", line 70, in take
(part, '-->'.join(walking)))
BaseException: login not in config [smtp]


So i figured on the backend its looking for login explicitly.

Anything thought or options.

Otherwise should I just use an external library and doing something like 
the following (but I would like to use the baked in tools) :

# email
import smtplib
from email.MIMEMultipart import MIMEMultipart
from email.MIMEText import MIMEText
from email.Utils import formatdate

try:
s = smtplib.SMTP('server.com')
except:
print "error connecting to email server"
return -1
try:
s.sendmail(m_from,m_to,msg.as_string())
s.quit()
except:
print "error sendmail email report"
s.quit()
return -1


-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Send Mail with AppRelay Server

[Michael M]

Hello,  I was recently instructed to use our internal apprelay server for 
sending email internally.

But one of the quirks of the server is that is does not require username or 
password.  

how do I do I got about doing that because when I comment out in the db.py 
and appconf.ini the lines that refer to login I get the following:


web2py™ Version 2.13.3-stable+timestamp.2015.12.24.08.08.22
Python Python 2.7.5: /usr/bin/uwsgi (prefix: /usr)Traceback

1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.

Traceback (most recent call last):
  File "/opt/www-data/web2py/gluon/main.py", line 450, in wsgibase
serve_controller(request, response, session)
  File "/opt/www-data/web2py/gluon/main.py", line 186, in serve_controller
run_models_in(environment)
  File "/opt/www-data/web2py/gluon/compileapp.py", line 576, in run_models_in
restricted(code, environment, layer=model)
  File "/opt/www-data/web2py/gluon/restricted.py", line 227, in restricted
exec ccode in environment
  File "/opt/www-data/web2py/applications/networktools/models/db.py" 
,
 line 89, in 
mail.settings.login = myconf.take('smtp.login')
  File "/opt/www-data/web2py/gluon/contrib/appconfig.py", line 70, in take
(part, '-->'.join(walking)))
BaseException: login not in config [smtp]


So i figured on the backend its looking for login explicitly.

Anything thought or options.

Otherwise should I just use an external library and doing something like 
the following (but I would like to use the baked in tools) :

# email
import smtplib
from email.MIMEMultipart import MIMEMultipart
from email.MIMEText import MIMEText
from email.Utils import formatdate

try:
s = smtplib.SMTP('server.com')
except:
print "error connecting to email server"
return -1
try:
s.sendmail(m_from,m_to,msg.as_string())
s.quit()
except:
print "error sendmail email report"
s.quit()
return -1


-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: Duplicate entries in Auth_user DB table upon sign in

[Michael M]

Ok,  I inadvertently lied.  

Not everything was the same.  Part of my install script is to download the 
source from the internet of web2py.

I switched my DB back to SQLite and and tried a login.  Same deal with 
LDAP/AD login on SQLite was still getting the same issue of two line items 
in 'db.auth_user'

What I did to fix it was.

ldap_auth.py ~line 425 added " 'username': username " to the 
"update_or_insert_values" dictionary 

update_or_insert_values = {'first_name': store_user_firstname,
   'last_name': store_user_lastname,
   'email': store_user_mail,
   'username': username}


ldap_auth.py ~line 429 added " ,'username' " to the fields array

fields = ['first_name', 'last_name', 'email','username']


I dont know what else to link to.  Should I submit a bugfix on Git?


On Friday, January 22, 2016 at 5:36:31 PM UTC-8, Michael M wrote:
>
> I just asked my guys on my DBA team to do a trace.  So they ran the trace 
> while I logged in.
>
> They sent me this:
>
> As discussed, We traced application login activity. Following are the 
> INSERT statements against WEB2PY_OracleProject.AUTH_USER table
>
>
> INSERT INTO auth_user(username,first_name,last_name,registration_id,
> reset_password_key,registration_key,email)
> VALUES
> ('','Michael','Messmer [mmessmer]','','','','mmess...@something.com')
>
>
> INSERT INTO auth_user(username,first_name,last_name,registration_id,
> reset_password_key,registration_key,email)
> VALUES
> ('mmessmer','mmessmer','','','','','')
>
>
> Module - uw...@servername.something.com (TNS V1-V3)
>
> User - WEB2PY_OracleProject
>
>
>
> On Thursday, January 21, 2016 at 5:24:36 PM UTC-8, Michael Messmer wrote:
>>
>> When I use the following on SQLite 
>>
>>manage_groups= True,
>>manage_user = True,
>>
>> 1 entry in would come into db.auth_user
>>
>> When I transferred to Oracle 11g
>> a new user logs in and I get two entries.
>>
>> 42  Mi Me [mme...mme@...NoneNoneNoneNone 
>>None
>> 43  mmeNoneNonemmeNoneNoneNonemme
>>
>> Log out and log in again. 
>> Then I get: 
>>
>> 43  Mi Me [mme...mme@...mmeNoneNone   
>>  Nonemme
>>
>> So row 43 is now getting updated.
>>
>> Any thoughts.  Again the the only thing that chaged was default SQLite to 
>> Oracle 11g  as the main DB
>>
>>
>> See Context below:
>> ---
>>
>> from gluon.tools import Auth, Crud, Service, PluginManager, prettydate
>> auth = Auth(db)
>> crud, service, plugins = Crud(db), Service(), PluginManager()
>>
>>
>> ## create all tables needed by auth if not custom tables
>> auth.define_tables(username=True, signature=False)
>>
>> # all we need is login
>>
>> auth.settings.actions_disabled=['register','change_password','request_reset_password','retrieve_username','profile']
>> #auth.settings.login_onvalidation = []
>> # you don't have to remember me
>> auth.settings.remember_me_form = False
>>
>> #
>> http://www.computerperformance.co.uk/Logon/LDAP_attributes_active_directory.htm
>> # ldap authentication and not save password on web2py
>> from gluon.contrib.login_methods.ldap_auth import ldap_auth
>> auth.settings.login_methods = [ldap_auth(mode='ad',
>>manage_groups= True,
>>db = db,
>>manage_user = True,
>>user_firstname_attrib = 'cn:1',
>>user_lastname_attrib = 'sn',
>>group_member_attrib = 'member',
>>group_filterstr = 'objectClass=Group',
>>server='somethign.com',
>>base_dn='DC=corp,DC=something,DC=com')]
>>
>>
>>
>>

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: Duplicate entries in Auth_user DB table upon sign in

[Michael M]

I just asked my guys on my DBA team to do a trace.  So they ran the trace 
while I logged in.

They sent me this:

As discussed, We traced application login activity. Following are the 
INSERT statements against WEB2PY_OracleProject.AUTH_USER table


INSERT INTO auth_user(username,first_name,last_name,registration_id,
reset_password_key,registration_key,email)
VALUES
('','Michael','Messmer [mmessmer]','','','','mmess...@something.com')


INSERT INTO auth_user(username,first_name,last_name,registration_id,
reset_password_key,registration_key,email)
VALUES
('mmessmer','mmessmer','','','','','')


Module - uw...@servername.something.com (TNS V1-V3)

User - WEB2PY_OracleProject



On Thursday, January 21, 2016 at 5:24:36 PM UTC-8, Michael Messmer wrote:
>
> When I use the following on SQLite 
>
>manage_groups= True,
>manage_user = True,
>
> 1 entry in would come into db.auth_user
>
> When I transferred to Oracle 11g
> a new user logs in and I get two entries.
>
> 42  Mi Me [mme...mme@...NoneNoneNoneNone   
>  None
> 43  mmeNoneNonemmeNoneNoneNonemme
>
> Log out and log in again. 
> Then I get: 
>
> 43  Mi Me [mme...mme@...mmeNoneNone   
>  Nonemme
>
> So row 43 is now getting updated.
>
> Any thoughts.  Again the the only thing that chaged was default SQLite to 
> Oracle 11g  as the main DB
>
>
> See Context below:
> ---
>
> from gluon.tools import Auth, Crud, Service, PluginManager, prettydate
> auth = Auth(db)
> crud, service, plugins = Crud(db), Service(), PluginManager()
>
>
> ## create all tables needed by auth if not custom tables
> auth.define_tables(username=True, signature=False)
>
> # all we need is login
>
> auth.settings.actions_disabled=['register','change_password','request_reset_password','retrieve_username','profile']
> #auth.settings.login_onvalidation = []
> # you don't have to remember me
> auth.settings.remember_me_form = False
>
> #
> http://www.computerperformance.co.uk/Logon/LDAP_attributes_active_directory.htm
> # ldap authentication and not save password on web2py
> from gluon.contrib.login_methods.ldap_auth import ldap_auth
> auth.settings.login_methods = [ldap_auth(mode='ad',
>manage_groups= True,
>db = db,
>manage_user = True,
>user_firstname_attrib = 'cn:1',
>user_lastname_attrib = 'sn',
>group_member_attrib = 'member',
>group_filterstr = 'objectClass=Group',
>server='somethign.com',
>base_dn='DC=corp,DC=something,DC=com')]
>
>
>
>

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: Oracle drivers.

[Michael M]

I have been trying to find good a install script for nginx on rhel/cent 7.

It has been slow going on my part due to my new job. I just joined the ranks of 
Unix OS admins.  Coming from a Windows world my job of getting up to speed has 
been a monumental task. ;-)

If there is an updated nginx and uwsgi or gunicorn scripts for version 7 of 
rhel/cent?

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: Oracle drivers.

[Michael M]

I did.  And still no luck.It Jams me because run web2py from CLI and 
Rocket serves it.  It Oracle works flawlessly with Web2py.

So it maybe just an Apache/Mod_WSGI thing.  


I am trying to get NginX and ( UWSGI or Gunicorn ) to work on my 
environment ( Fedora 22 / RHEL 7 )



On Monday, November 23, 2015 at 8:21:58 AM UTC-8, Cássio Botaro wrote:
>
> Do you already tried 
>
> sudo dnf install python-pip
> sudo pip install cx_Oracle
>
> ?
>

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: Oracle drivers.

[Michael M]

Is it Possible that the DAL is talking Python 3.4 when my driver is Python 
2.7.  So when I call it in Web2py from CLI it works but when the framework 
is running its trying to call 3.4 to talk to cx_Oracle?

See below:
2.12.3-stable+timestamp.2015.08.19.00.18.03
(Running on Apache/2.4.6 (Red Hat Enterprise Linux) OpenSSL/1.0.1e-fips 
mod_wsgi/3.4 Python/2.7.5, Python 2.7.5)

The Running Shows 3.4 Python/2.7.5, Python 2.7.5. could that contribute to 
the issue?  Or am i reading it wrong?

Thanks!


On Thursday, October 22, 2015 at 3:28:31 PM UTC-7, Michael M wrote:
>
> Tried it again.
>
> This time I tried on another RHEL 7 server.
>
> Downloaded Oracle's Instant Client Zips and extracted all of them instead 
> of installing RPMs
> Same with the cx_Oracle Module.  didnt install the RPM got the source and 
> complied.
>
> I set the envoirment variables
>
> export ORACLE_HOME=/usr/include/oracle/11.1
> export LD_LIBRARY_PATH=$ORACLE_HOME/
> export PATH=$ORACLE_HOME/bin:$PATH
>
> Created a symlink: ln -s libclntsh.so.11.1 libclntsh.so
>
> I compiled this time 'cx_Oracle-5.1.2.tar.gz' with python setup.py build 
> && python setup.py install
>
> Still able to launch python from CLI and import cx_Oracle without problems
> Still able to launch Web2py from CLI to see "cx_Oracle" in the Available 
> drivers line.
>
> Still unable to load an application that has the DB pointing to a 
> oracle:// URI without a ticket being auto-generating.
>
> Would finding an older version of Web2py maybe help?
>
> On Wednesday, October 14, 2015 at 8:37:54 AM UTC-7, Michael M wrote:
>>
>> Has anyone been able to reproduce this?  And I don't think you actually 
>> need an Oracle system.  Just pointing to a Oracle URI will cause the error 
>> on my side.
>>
>> On Thursday, October 8, 2015 at 12:09:45 PM UTC-7, Michael M wrote:
>>>
>>> Thank-you Niphlod!
>>>
>>> On Thursday, October 8, 2015 at 12:08:40 PM UTC-7, Niphlod wrote:
>>>>
>>>> the repo for pydal is the other one no worries though, I linked 
>>>> your one in https://github.com/web2py/pydal/issues/299
>>>>
>>>> On Thursday, October 8, 2015 at 3:13:11 AM UTC+2, Michael M wrote:
>>>>>
>>>>> Submitted:
>>>>> https://github.com/web2py/web2py/issues/1082
>>>>>
>>>>> On Wednesday, October 7, 2015 at 5:29:43 PM UTC-7, Massimo Di Pierro 
>>>>> wrote:
>>>>>>
>>>>>> This may be a bug. Can you please open a pydal ticket and we will 
>>>>>> check it asap?
>>>>>>
>>>>>> On Wednesday, 7 October 2015 14:50:13 UTC-5, Michael M wrote:
>>>>>>>
>>>>>>> Never checked there.  But it is.
>>>>>>>
>>>>>>> $ python web2py.py
>>>>>>> web2py Web Framework
>>>>>>> Created by Massimo Di Pierro, Copyright 2007-2015
>>>>>>> Version 2.12.3-stable+timestamp.2015.08.19.00.18.03
>>>>>>> Database drivers available: cx_Oracle, pymysql, imaplib, sqlite3, 
>>>>>>> pg8000, pyodbc
>>>>>>>
>>>>>>> Weird.  just rebooted the Virt. and still getting:
>>>>>>>
>>>>>>> Traceback (most recent call last):
>>>>>>>   File "/opt/www-data/web2py/gluon/restricted.py", line 227, in 
>>>>>>> restricted
>>>>>>> exec ccode in environment
>>>>>>>   File "/opt/www-data/web2py/applications/test/models/db.py" 
>>>>>>> <https://172.21.165.93/admin/default/edit/test/models/db.py>, line 20, 
>>>>>>> in 
>>>>>>> db = DAL(myconf.take('db.uri'), 
>>>>>>> pool_size=myconf.take('db.pool_size', cast=int), check_reserved=['all'])
>>>>>>>   File "/opt/www-data/web2py/gluon/packages/dal/pydal/base.py", line 
>>>>>>> 174, in __call__
>>>>>>> obj = super(MetaDAL, cls).__call__(*args, **kwargs)
>>>>>>>   File "/opt/www-data/web2py/gluon/packages/dal/pydal/base.py", line 
>>>>>>> 459, in __init__
>>>>>>> raise RuntimeError("Failure to connect, tried %d times:\n%s" % 
>>>>>>> (attempts, tb))
>>>>>>> RuntimeError: Failure to connect, tried 5 times:
>>>>>>> Traceback (most recent call last):
>>

[web2py] Re: Oracle drivers.

[Michael M]

Tried it again.

This time I tried on another RHEL 7 server.

Downloaded Oracle's Instant Client Zips and extracted all of them instead 
of installing RPMs
Same with the cx_Oracle Module.  didnt install the RPM got the source and 
complied.

I set the envoirment variables

export ORACLE_HOME=/usr/include/oracle/11.1
export LD_LIBRARY_PATH=$ORACLE_HOME/
export PATH=$ORACLE_HOME/bin:$PATH

Created a symlink: ln -s libclntsh.so.11.1 libclntsh.so

I compiled this time 'cx_Oracle-5.1.2.tar.gz' with python setup.py build && 
python setup.py install

Still able to launch python from CLI and import cx_Oracle without problems
Still able to launch Web2py from CLI to see "cx_Oracle" in the Available 
drivers line.

Still unable to load an application that has the DB pointing to a oracle:// 
URI without a ticket being auto-generating.

Would finding an older version of Web2py maybe help?

On Wednesday, October 14, 2015 at 8:37:54 AM UTC-7, Michael M wrote:
>
> Has anyone been able to reproduce this?  And I don't think you actually 
> need an Oracle system.  Just pointing to a Oracle URI will cause the error 
> on my side.
>
> On Thursday, October 8, 2015 at 12:09:45 PM UTC-7, Michael M wrote:
>>
>> Thank-you Niphlod!
>>
>> On Thursday, October 8, 2015 at 12:08:40 PM UTC-7, Niphlod wrote:
>>>
>>> the repo for pydal is the other one no worries though, I linked your 
>>> one in https://github.com/web2py/pydal/issues/299
>>>
>>> On Thursday, October 8, 2015 at 3:13:11 AM UTC+2, Michael M wrote:
>>>>
>>>> Submitted:
>>>> https://github.com/web2py/web2py/issues/1082
>>>>
>>>> On Wednesday, October 7, 2015 at 5:29:43 PM UTC-7, Massimo Di Pierro 
>>>> wrote:
>>>>>
>>>>> This may be a bug. Can you please open a pydal ticket and we will 
>>>>> check it asap?
>>>>>
>>>>> On Wednesday, 7 October 2015 14:50:13 UTC-5, Michael M wrote:
>>>>>>
>>>>>> Never checked there.  But it is.
>>>>>>
>>>>>> $ python web2py.py
>>>>>> web2py Web Framework
>>>>>> Created by Massimo Di Pierro, Copyright 2007-2015
>>>>>> Version 2.12.3-stable+timestamp.2015.08.19.00.18.03
>>>>>> Database drivers available: cx_Oracle, pymysql, imaplib, sqlite3, 
>>>>>> pg8000, pyodbc
>>>>>>
>>>>>> Weird.  just rebooted the Virt. and still getting:
>>>>>>
>>>>>> Traceback (most recent call last):
>>>>>>   File "/opt/www-data/web2py/gluon/restricted.py", line 227, in 
>>>>>> restricted
>>>>>> exec ccode in environment
>>>>>>   File "/opt/www-data/web2py/applications/test/models/db.py" 
>>>>>> <https://172.21.165.93/admin/default/edit/test/models/db.py>, line 20, 
>>>>>> in 
>>>>>> db = DAL(myconf.take('db.uri'), 
>>>>>> pool_size=myconf.take('db.pool_size', cast=int), check_reserved=['all'])
>>>>>>   File "/opt/www-data/web2py/gluon/packages/dal/pydal/base.py", line 
>>>>>> 174, in __call__
>>>>>> obj = super(MetaDAL, cls).__call__(*args, **kwargs)
>>>>>>   File "/opt/www-data/web2py/gluon/packages/dal/pydal/base.py", line 
>>>>>> 459, in __init__
>>>>>> raise RuntimeError("Failure to connect, tried %d times:\n%s" % 
>>>>>> (attempts, tb))
>>>>>> RuntimeError: Failure to connect, tried 5 times:
>>>>>> Traceback (most recent call last):
>>>>>>   File "/opt/www-data/web2py/gluon/packages/dal/pydal/base.py", line 
>>>>>> 437, in __init__
>>>>>> self._adapter = ADAPTERS[self._dbname](**kwargs)
>>>>>>   File "/opt/www-data/web2py/gluon/packages/dal/pydal/adapters/base.py", 
>>>>>> line 57, in __call__
>>>>>> obj = super(AdapterMeta, cls).__call__(*args, **kwargs)
>>>>>>   File 
>>>>>> "/opt/www-data/web2py/gluon/packages/dal/pydal/adapters/oracle.py", line 
>>>>>> 105, in __init__
>>>>>> if do_connect: self.find_driver(adapter_args,uri)
>>>>>>   File "/opt/www-data/web2py/gluon/packages/dal/pydal/adapters/base.py", 
>>>>>> line 188, in find_driver
>>>>>> raise RuntimeError("no driv

[web2py] Re: PyCharm license for web2py dev - who wants?

[Michael M]

+1

On Sunday, October 11, 2015 at 12:21:16 PM UTC-7, Francisco Ribeiro wrote:
>
> Hello all,
>
> for those who know PyCharm is a great IDE from JetBrains that provides 
> free licenses for Open Source projects like web2py ( 
> https://www.jetbrains.com/buy/opensource/?product=pycharm ). To request 
> such a license, I need to know how many of you would want one of these as 
> well so I can provide them with a number of seats. 
>
> A "+1" response for me is enough but I will also need your email address 
> to send you the license key (which you can send on a private message).
>
> Kind regards,
> Francisco
>

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Re: qrcode

[Michael M]

Glad it worked for you!

I like the method that I found(just took three working pieces and pushed 
together) because no static files are generated using StringIO memory and 
encoding it with Base64.  (as far as I know)  ;)

On Wednesday, October 14, 2015 at 12:11:25 PM UTC-7, Fabiano Almeida wrote:
>
> Hi Michael,
>
> 2015-10-14 16:00 GMT-03:00 Michael M >:
>
>> {{=XML(img_tag)}}
>
>
> It worked! Grateful for all!
>
> Fabiano.
>

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Re: qrcode

[Michael M]

create a default/qrpage.html

insert this   {{=XML(img_tag)}}

On Wednesday, October 14, 2015 at 10:59:25 AM UTC-7, Fabiano Almeida wrote:
>
> Hi Michael,
>
> With your example, return this:
>
> Qrpage
>> StringIO:
>> ToQRData:Fabiano Likes MLP:FIMimg:> 0x7f02d1c0a9d0>img_tag:> src="data:image/png;base64,iVBORw0KGgoNSUhEUgAAAQ4AAAEOAQBQysQIAAAB0klEQVR4nO2aQY7cIBBFXwVLs4Qb5Cj4BjnT3MwcZQ4wEl6OBPpZgJ3OIhopTnpsC1YNfouvUulTRbWJT1b99hkBA/nD0rL/ksq29WU79eVMcq+HeElSgRSAmPsXSZKW08m9GlLNLAAxO5G+lx7iZGZP13JfpIVzfZFew1druR8Ss9MvZ/haLfdAJsAJqJBmh+E/jJgrRD1Zy/2QCVbbNv7dlH6AUninn/pTyb0Y0kuDtjLtQns806jIjiDJzMxCNbPgRDOKdcLmdcLms8m9FIIWX9CCE/iCFi9p8RIxu5G7xxCk7NQ6tKjSTIG4G8Xo1Y4gPVmVnVrX1nIXAC+N6B5C+uuC1B8WNlMAKTffOJPciyHNcrvv4lqZ0NK2Vw8jun+P9FutPY/5PbBbOTac4V8gyV5EfDPrnfA6tXMpn1HulZDWCZvN+6tuCtX6CqeTeyHksS/r5cJePeA0brWDSNqyFFYzYq6mhWrgCzafTe7VkH02EduAwsnm5hbP13JDZJtNpADgP1oW29xS+XRyL4u4/rqwsJVqr+NWO4BMj5t1KobPWBQQ36bnarkf8jibwGeIS52UDMDruVruh/w2m6D2YMcc6B/GbOIAYuO/OP8R+Qk7Fi5D47GUFwBJRU5ErkJggg==">
>> output:qr:> instance at 0x7f02d1bf40e0>qrcode:> '/usr/local/lib/python2.7/dist-packages/qrcode-5.1-py2.7.egg/qrcode/__init__.pyc'>
>>
>
> How to show de picture + text message?
>
> thx
>
> 2015-10-14 13:05 GMT-03:00 Michael M >:
>
>> def qrpage():
>> #Install Python Modules: (Pillow,qrcode)
>> #https://github.com/lincolnloop/python-qrcode
>> 
>> ToQRData = auth.user.username + ' Likes MLP:FIM'
>> import qrcode
>> import StringIO
>> qr = qrcode.QRCode(
>> version=1,
>> error_correction=qrcode.constants.ERROR_CORRECT_L,
>> box_size=10,
>> border=1,
>> )
>> qr.add_data(ToQRData)
>> qr.make(fit=True)
>>
>> # use an in-memory object to save
>> output = StringIO.StringIO()
>> img = qr.make_image()
>> img.save(output)
>>
>> # and the use getvalue() method to get the string
>> img_tag = '' % 
>> output.getvalue().encode('base64').replace('\n', '')
>> return locals()
>>
>>
>> On Tuesday, October 13, 2015 at 2:05:23 PM UTC-7, Fabiano Almeida wrote:
>>>
>>> Hi all!
>>>
>>> How to dynamically generate qr code in web2py?
>>>
>>> grateful,
>>>
>>> Fabiano.
>>>
>> -- 
>> Resources:
>> - http://web2py.com
>> - http://web2py.com/book (Documentation)
>> - http://github.com/web2py/web2py (Source code)
>> - https://code.google.com/p/web2py/issues/list (Report Issues)
>> --- 
>> You received this message because you are subscribed to the Google Groups 
>> "web2py-users" group.
>> To unsubscribe from this group and stop receiving emails from it, send an 
>> email to web2py+un...@googlegroups.com .
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: qrcode

[Michael M]

def qrpage():
#Install Python Modules: (Pillow,qrcode)
#https://github.com/lincolnloop/python-qrcode

ToQRData = auth.user.username + ' Likes MLP:FIM'
import qrcode
import StringIO
qr = qrcode.QRCode(
version=1,
error_correction=qrcode.constants.ERROR_CORRECT_L,
box_size=10,
border=1,
)
qr.add_data(ToQRData)
qr.make(fit=True)

# use an in-memory object to save
output = StringIO.StringIO()
img = qr.make_image()
img.save(output)

# and the use getvalue() method to get the string
img_tag = '' % 
output.getvalue().encode('base64').replace('\n', '')
return locals()


On Tuesday, October 13, 2015 at 2:05:23 PM UTC-7, Fabiano Almeida wrote:
>
> Hi all!
>
> How to dynamically generate qr code in web2py?
>
> grateful,
>
> Fabiano.
>

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: Oracle drivers.

[Michael M]

Has anyone been able to reproduce this?

On Thursday, October 8, 2015 at 12:09:45 PM UTC-7, Michael M wrote:
>
> Thank-you Niphlod!
>
> On Thursday, October 8, 2015 at 12:08:40 PM UTC-7, Niphlod wrote:
>>
>> the repo for pydal is the other one no worries though, I linked your 
>> one in https://github.com/web2py/pydal/issues/299
>>
>> On Thursday, October 8, 2015 at 3:13:11 AM UTC+2, Michael M wrote:
>>>
>>> Submitted:
>>> https://github.com/web2py/web2py/issues/1082
>>>
>>> On Wednesday, October 7, 2015 at 5:29:43 PM UTC-7, Massimo Di Pierro 
>>> wrote:
>>>>
>>>> This may be a bug. Can you please open a pydal ticket and we will check 
>>>> it asap?
>>>>
>>>> On Wednesday, 7 October 2015 14:50:13 UTC-5, Michael M wrote:
>>>>>
>>>>> Never checked there.  But it is.
>>>>>
>>>>> $ python web2py.py
>>>>> web2py Web Framework
>>>>> Created by Massimo Di Pierro, Copyright 2007-2015
>>>>> Version 2.12.3-stable+timestamp.2015.08.19.00.18.03
>>>>> Database drivers available: cx_Oracle, pymysql, imaplib, sqlite3, 
>>>>> pg8000, pyodbc
>>>>>
>>>>> Weird.  just rebooted the Virt. and still getting:
>>>>>
>>>>> Traceback (most recent call last):
>>>>>   File "/opt/www-data/web2py/gluon/restricted.py", line 227, in restricted
>>>>> exec ccode in environment
>>>>>   File "/opt/www-data/web2py/applications/test/models/db.py" 
>>>>> <https://172.21.165.93/admin/default/edit/test/models/db.py>, line 20, in 
>>>>> 
>>>>> db = DAL(myconf.take('db.uri'), pool_size=myconf.take('db.pool_size', 
>>>>> cast=int), check_reserved=['all'])
>>>>>   File "/opt/www-data/web2py/gluon/packages/dal/pydal/base.py", line 174, 
>>>>> in __call__
>>>>> obj = super(MetaDAL, cls).__call__(*args, **kwargs)
>>>>>   File "/opt/www-data/web2py/gluon/packages/dal/pydal/base.py", line 459, 
>>>>> in __init__
>>>>> raise RuntimeError("Failure to connect, tried %d times:\n%s" % 
>>>>> (attempts, tb))
>>>>> RuntimeError: Failure to connect, tried 5 times:
>>>>> Traceback (most recent call last):
>>>>>   File "/opt/www-data/web2py/gluon/packages/dal/pydal/base.py", line 437, 
>>>>> in __init__
>>>>> self._adapter = ADAPTERS[self._dbname](**kwargs)
>>>>>   File "/opt/www-data/web2py/gluon/packages/dal/pydal/adapters/base.py", 
>>>>> line 57, in __call__
>>>>> obj = super(AdapterMeta, cls).__call__(*args, **kwargs)
>>>>>   File 
>>>>> "/opt/www-data/web2py/gluon/packages/dal/pydal/adapters/oracle.py", line 
>>>>> 105, in __init__
>>>>> if do_connect: self.find_driver(adapter_args,uri)
>>>>>   File "/opt/www-data/web2py/gluon/packages/dal/pydal/adapters/base.py", 
>>>>> line 188, in find_driver
>>>>> raise RuntimeError("no driver available %s" % str(self.drivers))
>>>>> RuntimeError: no driver available ('cx_Oracle',)
>>>>>
>>>>>
>>>>> On Wednesday, October 7, 2015 at 12:45:19 PM UTC-7, Willoughby wrote:
>>>>>>
>>>>>> When you start web2py from a command line it should list 'Database 
>>>>>> drivers available' - is it on that list?
>>>>>>
>>>>>> On Wednesday, October 7, 2015 at 3:12:01 PM UTC-4, Michael M wrote:
>>>>>>>
>>>>>>> Just to cover more basis I installed the following:
>>>>>>>
>>>>>>> sudo rpm -Uvh
>>>>>>>
>>>>>>> oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm
>>>>>>> oracle-instantclient11.2-devel-11.2.0.4.0-1.x86_64.rpm
>>>>>>> oracle-instantclient11.2-jdbc-11.2.0.4.0-1.x86_64.rpm
>>>>>>> oracle-instantclient11.2-odbc-11.2.0.4.0-1.x86_64.rpm
>>>>>>> oracle-instantclient11.2-sqlplus-11.2.0.4.0-1.x86_64.rpm
>>>>>>> oracle-instantclient11.2-tools-11.2.0.4.0-1.x86_64.rpm
>>>>>>>
>>>>>>> then 
>>>>>>>
>>>>>>> cx_Oracle-5.1.2-11g-py27-1.x86_64.rpm
>>>>>>>
>>>>>>> Still no dice in Web2py
>>>>>>>
>>>>>>>
>>>>>>> On Tuesday, October 6, 2015 at 5:09:18 PM UTC-7, Michael M wrote:
>>>>>>>>
>>>>>>>> I was testing in non-prod (RHEL) to see if it was built in.  it 
>>>>>>>> wasnt.  on my Fedora 22 at my desk I installed cx_Oracle because it 
>>>>>>>> works 
>>>>>>>> when i am in CLI python and I can call it no errors.  I have yet to 
>>>>>>>> dabble 
>>>>>>>> in virtualenv.
>>>>>>>>
>>>>>>>> I have systemctl restart httpd after every change.  even reboots to 
>>>>>>>> make sure.
>>>>>>>>
>>>>>>>> On Tuesday, October 6, 2015 at 5:02:12 PM UTC-7, Leonel Câmara 
>>>>>>>> wrote:
>>>>>>>>>
>>>>>>>>> Is it possible web2py is running in a virtualenv where you have 
>>>>>>>>> not installed cx_Oracle?
>>>>>>>>>
>>>>>>>>> Also don't forget to restart Apache.
>>>>>>>>>
>>>>>>>>

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Re: Has anyone done a detailed security analysis or attempted a methodical attack on web2py?

[Michael M]

My company has to have an outside firm Pen test all Web-Service 
applications.  So I am spinning up two internal services and both are going 
to be tested around November before they go into Prod from Non-Prod.  I'm 
starting talks with the InfoSec team to see if I can share the findings of 
the test.

On Thursday, October 8, 2015 at 12:13:33 PM UTC-7, Richard wrote:
>
> :)
>
> Nice to heard that!
>
> Richard
>
> On Thu, Oct 8, 2015 at 2:59 PM, Niphlod > 
> wrote:
>
>> not really. 
>> I built some apps on web2py that are live and in production, and since 
>> EVERY app in my environment NEEDS to pass a Qualys scan to be live and 
>> production ready, I know that MY apps survive a Qualys scan with flying 
>> colors.
>> Point being "ATM web2py does not expose any obvious/hidden threat that 
>> Qualys identifies".
>> I'll reinstate the obvious though: this "just" means that if you code 
>> responsibly, your app is safe. It's not too little of a "just". But it's a 
>> "just" nonetheless. 
>> Noone is saying that EVERY app you code will pass a white-hat attempt if 
>> it's hosted on web2py, and I don't think that any framework in any language 
>> will ever have the guts to assure it. 
>>
>>
>> On Thursday, October 8, 2015 at 8:38:05 PM UTC+2, Richard wrote:
>>>
>>> @Antonio
>>>
>>> I think Simone just point to the tool that can be use for such 
>>> purpose... You can use it over your App. From my understanding the App 
>>> tested is the Ian App...
>>>
>>> Richard
>>>
>>> On Thu, Oct 8, 2015 at 1:19 PM, António Ramos  
>>> wrote:
>>>
 Niphold,
 i dont see where you are pointing on  https://www.qualys.com/
 where is the web2py app that survived the security scan ?

 thank you

 2015-10-05 11:25 GMT+01:00 Niphlod :

> here in ***undisclosed company web2py survives a 
> https://www.qualys.com/ security scan with no reports whatsoever.
>
>
> On Sunday, October 4, 2015 at 2:47:44 PM UTC+2, Ian Ryder wrote:
>>
>> Hi, just looking back over anything about penetration testing and 
>> web2py - does anyone know of any recent (or any at all) testing of 
>> web2py? 
>> We're getting close to our first customers on an app we've been 
>> developing 
>> the last year so really need to try and pick it to pieces now while we 
>> have 
>> a few months to work on anything we need to.
>>
>> Thanks
>> Ian
>>
>> On Tuesday, 10 July 2012 19:42:46 UTC+2, Massimo Di Pierro wrote:
>>>
>>> Thank you Dave for the feedback. It would be nice to have the 
>>> results of those  tests (Cenznic, Hailstorm, Quails) published 
>>> somewhere. 
>>> Once in a while people ask about this.
>>>
>>> Massimo
>>>
>>> On Tuesday, 10 July 2012 11:28:39 UTC-5, Dave wrote:

 Well

 I can't say that I have tested the current trunk version, but last 
 December I ran a pretty exhaustive penetration test against a site 
 developed web2py.  The results were very good.  No findings above low. 
  The 
 low findings were insignificant.  I ran Cenzic Hailstorm, Qualys and 
 one 
 other automated vulnerability test suite (I cant remember which at the 
 moment) against it without issue.  

 Here are some things that can cause issue though...

 * anywhere you use the XML() method in a view you should make sure 
 you have validation turned on.  Even though the framework is resilient 
 and 
 does a good job of sanitizing data in & out, you can still end up in 
 XSS or 
 XSRF trouble with XML().

 * redirects can trip up or slow down a lot of vuln scanners.  Watch 
 out if you perform your own testing that you're not getting false 
 negatives.

 I know some people that would take on a more "formal" assessment if 
 there is consensus

 Dave

 On Monday, July 9, 2012 11:48:39 AM UTC-4, scausten wrote:
>
> One of the awesome things about web2py is of course the built-in 
> and well-documented resilience against a range of attack methods, but 
> I was 
> wondering if anyone has attempted a methodical (white-hat) attack to 
> probe 
> any potential weaknesses?
>
> Just out of interest :)
>
 -- 
> Resources:
> - http://web2py.com
> - http://web2py.com/book (Documentation)
> - http://github.com/web2py/web2py (Source code)
> - https://code.google.com/p/web2py/issues/list (Report Issues)
> --- 
> You received this message because you are subscribed to the Google 
> Groups "web2py-users" group.
> To unsubscribe from this group and stop receiving emails from it, send 
> an email to web2py+un...@googlegroups.com.
> For more options, visit https://groups.google.c

[web2py] Re: Oracle drivers.

[Michael M]

Thank-you Niphlod!

On Thursday, October 8, 2015 at 12:08:40 PM UTC-7, Niphlod wrote:
>
> the repo for pydal is the other one no worries though, I linked your 
> one in https://github.com/web2py/pydal/issues/299
>
> On Thursday, October 8, 2015 at 3:13:11 AM UTC+2, Michael M wrote:
>>
>> Submitted:
>> https://github.com/web2py/web2py/issues/1082
>>
>> On Wednesday, October 7, 2015 at 5:29:43 PM UTC-7, Massimo Di Pierro 
>> wrote:
>>>
>>> This may be a bug. Can you please open a pydal ticket and we will check 
>>> it asap?
>>>
>>> On Wednesday, 7 October 2015 14:50:13 UTC-5, Michael M wrote:
>>>>
>>>> Never checked there.  But it is.
>>>>
>>>> $ python web2py.py
>>>> web2py Web Framework
>>>> Created by Massimo Di Pierro, Copyright 2007-2015
>>>> Version 2.12.3-stable+timestamp.2015.08.19.00.18.03
>>>> Database drivers available: cx_Oracle, pymysql, imaplib, sqlite3, 
>>>> pg8000, pyodbc
>>>>
>>>> Weird.  just rebooted the Virt. and still getting:
>>>>
>>>> Traceback (most recent call last):
>>>>   File "/opt/www-data/web2py/gluon/restricted.py", line 227, in restricted
>>>> exec ccode in environment
>>>>   File "/opt/www-data/web2py/applications/test/models/db.py" 
>>>> <https://172.21.165.93/admin/default/edit/test/models/db.py>, line 20, in 
>>>> 
>>>> db = DAL(myconf.take('db.uri'), pool_size=myconf.take('db.pool_size', 
>>>> cast=int), check_reserved=['all'])
>>>>   File "/opt/www-data/web2py/gluon/packages/dal/pydal/base.py", line 174, 
>>>> in __call__
>>>> obj = super(MetaDAL, cls).__call__(*args, **kwargs)
>>>>   File "/opt/www-data/web2py/gluon/packages/dal/pydal/base.py", line 459, 
>>>> in __init__
>>>> raise RuntimeError("Failure to connect, tried %d times:\n%s" % 
>>>> (attempts, tb))
>>>> RuntimeError: Failure to connect, tried 5 times:
>>>> Traceback (most recent call last):
>>>>   File "/opt/www-data/web2py/gluon/packages/dal/pydal/base.py", line 437, 
>>>> in __init__
>>>> self._adapter = ADAPTERS[self._dbname](**kwargs)
>>>>   File "/opt/www-data/web2py/gluon/packages/dal/pydal/adapters/base.py", 
>>>> line 57, in __call__
>>>> obj = super(AdapterMeta, cls).__call__(*args, **kwargs)
>>>>   File "/opt/www-data/web2py/gluon/packages/dal/pydal/adapters/oracle.py", 
>>>> line 105, in __init__
>>>> if do_connect: self.find_driver(adapter_args,uri)
>>>>   File "/opt/www-data/web2py/gluon/packages/dal/pydal/adapters/base.py", 
>>>> line 188, in find_driver
>>>> raise RuntimeError("no driver available %s" % str(self.drivers))
>>>> RuntimeError: no driver available ('cx_Oracle',)
>>>>
>>>>
>>>> On Wednesday, October 7, 2015 at 12:45:19 PM UTC-7, Willoughby wrote:
>>>>>
>>>>> When you start web2py from a command line it should list 'Database 
>>>>> drivers available' - is it on that list?
>>>>>
>>>>> On Wednesday, October 7, 2015 at 3:12:01 PM UTC-4, Michael M wrote:
>>>>>>
>>>>>> Just to cover more basis I installed the following:
>>>>>>
>>>>>> sudo rpm -Uvh
>>>>>>
>>>>>> oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm
>>>>>> oracle-instantclient11.2-devel-11.2.0.4.0-1.x86_64.rpm
>>>>>> oracle-instantclient11.2-jdbc-11.2.0.4.0-1.x86_64.rpm
>>>>>> oracle-instantclient11.2-odbc-11.2.0.4.0-1.x86_64.rpm
>>>>>> oracle-instantclient11.2-sqlplus-11.2.0.4.0-1.x86_64.rpm
>>>>>> oracle-instantclient11.2-tools-11.2.0.4.0-1.x86_64.rpm
>>>>>>
>>>>>> then 
>>>>>>
>>>>>> cx_Oracle-5.1.2-11g-py27-1.x86_64.rpm
>>>>>>
>>>>>> Still no dice in Web2py
>>>>>>
>>>>>>
>>>>>> On Tuesday, October 6, 2015 at 5:09:18 PM UTC-7, Michael M wrote:
>>>>>>>
>>>>>>> I was testing in non-prod (RHEL) to see if it was built in.  it 
>>>>>>> wasnt.  on my Fedora 22 at my desk I installed cx_Oracle because it 
>>>>>>> works 
>>>>>>> when i am in CLI python and I can call it no errors.  I have yet to 
>>>>>>> dabble 
>>>>>>> in virtualenv.
>>>>>>>
>>>>>>> I have systemctl restart httpd after every change.  even reboots to 
>>>>>>> make sure.
>>>>>>>
>>>>>>> On Tuesday, October 6, 2015 at 5:02:12 PM UTC-7, Leonel Câmara wrote:
>>>>>>>>
>>>>>>>> Is it possible web2py is running in a virtualenv where you have not 
>>>>>>>> installed cx_Oracle?
>>>>>>>>
>>>>>>>> Also don't forget to restart Apache.
>>>>>>>>
>>>>>>>

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: Oracle drivers.

[Michael M]

Submitted:
https://github.com/web2py/web2py/issues/1082

On Wednesday, October 7, 2015 at 5:29:43 PM UTC-7, Massimo Di Pierro wrote:
>
> This may be a bug. Can you please open a pydal ticket and we will check it 
> asap?
>
> On Wednesday, 7 October 2015 14:50:13 UTC-5, Michael M wrote:
>>
>> Never checked there.  But it is.
>>
>> $ python web2py.py
>> web2py Web Framework
>> Created by Massimo Di Pierro, Copyright 2007-2015
>> Version 2.12.3-stable+timestamp.2015.08.19.00.18.03
>> Database drivers available: cx_Oracle, pymysql, imaplib, sqlite3, pg8000, 
>> pyodbc
>>
>> Weird.  just rebooted the Virt. and still getting:
>>
>> Traceback (most recent call last):
>>   File "/opt/www-data/web2py/gluon/restricted.py", line 227, in restricted
>> exec ccode in environment
>>   File "/opt/www-data/web2py/applications/test/models/db.py" 
>> <https://172.21.165.93/admin/default/edit/test/models/db.py>, line 20, in 
>> 
>> db = DAL(myconf.take('db.uri'), pool_size=myconf.take('db.pool_size', 
>> cast=int), check_reserved=['all'])
>>   File "/opt/www-data/web2py/gluon/packages/dal/pydal/base.py", line 174, in 
>> __call__
>> obj = super(MetaDAL, cls).__call__(*args, **kwargs)
>>   File "/opt/www-data/web2py/gluon/packages/dal/pydal/base.py", line 459, in 
>> __init__
>> raise RuntimeError("Failure to connect, tried %d times:\n%s" % 
>> (attempts, tb))
>> RuntimeError: Failure to connect, tried 5 times:
>> Traceback (most recent call last):
>>   File "/opt/www-data/web2py/gluon/packages/dal/pydal/base.py", line 437, in 
>> __init__
>> self._adapter = ADAPTERS[self._dbname](**kwargs)
>>   File "/opt/www-data/web2py/gluon/packages/dal/pydal/adapters/base.py", 
>> line 57, in __call__
>> obj = super(AdapterMeta, cls).__call__(*args, **kwargs)
>>   File "/opt/www-data/web2py/gluon/packages/dal/pydal/adapters/oracle.py", 
>> line 105, in __init__
>> if do_connect: self.find_driver(adapter_args,uri)
>>   File "/opt/www-data/web2py/gluon/packages/dal/pydal/adapters/base.py", 
>> line 188, in find_driver
>>     raise RuntimeError("no driver available %s" % str(self.drivers))
>> RuntimeError: no driver available ('cx_Oracle',)
>>
>>
>> On Wednesday, October 7, 2015 at 12:45:19 PM UTC-7, Willoughby wrote:
>>>
>>> When you start web2py from a command line it should list 'Database 
>>> drivers available' - is it on that list?
>>>
>>> On Wednesday, October 7, 2015 at 3:12:01 PM UTC-4, Michael M wrote:
>>>>
>>>> Just to cover more basis I installed the following:
>>>>
>>>> sudo rpm -Uvh
>>>>
>>>> oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm
>>>> oracle-instantclient11.2-devel-11.2.0.4.0-1.x86_64.rpm
>>>> oracle-instantclient11.2-jdbc-11.2.0.4.0-1.x86_64.rpm
>>>> oracle-instantclient11.2-odbc-11.2.0.4.0-1.x86_64.rpm
>>>> oracle-instantclient11.2-sqlplus-11.2.0.4.0-1.x86_64.rpm
>>>> oracle-instantclient11.2-tools-11.2.0.4.0-1.x86_64.rpm
>>>>
>>>> then 
>>>>
>>>> cx_Oracle-5.1.2-11g-py27-1.x86_64.rpm
>>>>
>>>> Still no dice in Web2py
>>>>
>>>>
>>>> On Tuesday, October 6, 2015 at 5:09:18 PM UTC-7, Michael M wrote:
>>>>>
>>>>> I was testing in non-prod (RHEL) to see if it was built in.  it wasnt. 
>>>>>  on my Fedora 22 at my desk I installed cx_Oracle because it works when i 
>>>>> am in CLI python and I can call it no errors.  I have yet to dabble in 
>>>>> virtualenv.
>>>>>
>>>>> I have systemctl restart httpd after every change.  even reboots to 
>>>>> make sure.
>>>>>
>>>>> On Tuesday, October 6, 2015 at 5:02:12 PM UTC-7, Leonel Câmara wrote:
>>>>>>
>>>>>> Is it possible web2py is running in a virtualenv where you have not 
>>>>>> installed cx_Oracle?
>>>>>>
>>>>>> Also don't forget to restart Apache.
>>>>>>
>>>>>

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: Oracle drivers.

[Michael M]

Never checked there.  But it is.

$ python web2py.py
web2py Web Framework
Created by Massimo Di Pierro, Copyright 2007-2015
Version 2.12.3-stable+timestamp.2015.08.19.00.18.03
Database drivers available: cx_Oracle, pymysql, imaplib, sqlite3, pg8000, 
pyodbc

Weird.  just rebooted the Virt. and still getting:

Traceback (most recent call last):
  File "/opt/www-data/web2py/gluon/restricted.py", line 227, in restricted
exec ccode in environment
  File "/opt/www-data/web2py/applications/test/models/db.py" 
<https://172.21.165.93/admin/default/edit/test/models/db.py>, line 20, in 

db = DAL(myconf.take('db.uri'), pool_size=myconf.take('db.pool_size', 
cast=int), check_reserved=['all'])
  File "/opt/www-data/web2py/gluon/packages/dal/pydal/base.py", line 174, in 
__call__
obj = super(MetaDAL, cls).__call__(*args, **kwargs)
  File "/opt/www-data/web2py/gluon/packages/dal/pydal/base.py", line 459, in 
__init__
raise RuntimeError("Failure to connect, tried %d times:\n%s" % (attempts, 
tb))
RuntimeError: Failure to connect, tried 5 times:
Traceback (most recent call last):
  File "/opt/www-data/web2py/gluon/packages/dal/pydal/base.py", line 437, in 
__init__
self._adapter = ADAPTERS[self._dbname](**kwargs)
  File "/opt/www-data/web2py/gluon/packages/dal/pydal/adapters/base.py", line 
57, in __call__
obj = super(AdapterMeta, cls).__call__(*args, **kwargs)
  File "/opt/www-data/web2py/gluon/packages/dal/pydal/adapters/oracle.py", line 
105, in __init__
if do_connect: self.find_driver(adapter_args,uri)
  File "/opt/www-data/web2py/gluon/packages/dal/pydal/adapters/base.py", line 
188, in find_driver
raise RuntimeError("no driver available %s" % str(self.drivers))
RuntimeError: no driver available ('cx_Oracle',)


On Wednesday, October 7, 2015 at 12:45:19 PM UTC-7, Willoughby wrote:
>
> When you start web2py from a command line it should list 'Database drivers 
> available' - is it on that list?
>
> On Wednesday, October 7, 2015 at 3:12:01 PM UTC-4, Michael M wrote:
>>
>> Just to cover more basis I installed the following:
>>
>> sudo rpm -Uvh
>>
>> oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm
>> oracle-instantclient11.2-devel-11.2.0.4.0-1.x86_64.rpm
>> oracle-instantclient11.2-jdbc-11.2.0.4.0-1.x86_64.rpm
>> oracle-instantclient11.2-odbc-11.2.0.4.0-1.x86_64.rpm
>> oracle-instantclient11.2-sqlplus-11.2.0.4.0-1.x86_64.rpm
>> oracle-instantclient11.2-tools-11.2.0.4.0-1.x86_64.rpm
>>
>> then 
>>
>> cx_Oracle-5.1.2-11g-py27-1.x86_64.rpm
>>
>> Still no dice in Web2py
>>
>>
>> On Tuesday, October 6, 2015 at 5:09:18 PM UTC-7, Michael M wrote:
>>>
>>> I was testing in non-prod (RHEL) to see if it was built in.  it wasnt. 
>>>  on my Fedora 22 at my desk I installed cx_Oracle because it works when i 
>>> am in CLI python and I can call it no errors.  I have yet to dabble in 
>>> virtualenv.
>>>
>>> I have systemctl restart httpd after every change.  even reboots to make 
>>> sure.
>>>
>>> On Tuesday, October 6, 2015 at 5:02:12 PM UTC-7, Leonel Câmara wrote:
>>>>
>>>> Is it possible web2py is running in a virtualenv where you have not 
>>>> installed cx_Oracle?
>>>>
>>>> Also don't forget to restart Apache.
>>>>
>>>

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: Oracle drivers.

[Michael M]

Just to cover more basis I installed the following:

sudo rpm -Uvh

oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm
oracle-instantclient11.2-devel-11.2.0.4.0-1.x86_64.rpm
oracle-instantclient11.2-jdbc-11.2.0.4.0-1.x86_64.rpm
oracle-instantclient11.2-odbc-11.2.0.4.0-1.x86_64.rpm
oracle-instantclient11.2-sqlplus-11.2.0.4.0-1.x86_64.rpm
oracle-instantclient11.2-tools-11.2.0.4.0-1.x86_64.rpm

then 

cx_Oracle-5.1.2-11g-py27-1.x86_64.rpm

Still no dice in Web2py


On Tuesday, October 6, 2015 at 5:09:18 PM UTC-7, Michael M wrote:
>
> I was testing in non-prod (RHEL) to see if it was built in.  it wasnt.  on 
> my Fedora 22 at my desk I installed cx_Oracle because it works when i am in 
> CLI python and I can call it no errors.  I have yet to dabble in virtualenv.
>
> I have systemctl restart httpd after every change.  even reboots to make 
> sure.
>
> On Tuesday, October 6, 2015 at 5:02:12 PM UTC-7, Leonel Câmara wrote:
>>
>> Is it possible web2py is running in a virtualenv where you have not 
>> installed cx_Oracle?
>>
>> Also don't forget to restart Apache.
>>
>

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: Lost Style when deploying

[Michael M]

Hehe, indeed.

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: Oracle drivers.

[Michael M]

I was testing in non-prod (RHEL) to see if it was built in.  it wasnt.  on 
my Fedora 22 at my desk I installed cx_Oracle because it works when i am in 
CLI python and I can call it no errors.  I have yet to dabble in virtualenv.

I have systemctl restart httpd after every change.  even reboots to make 
sure.

On Tuesday, October 6, 2015 at 5:02:12 PM UTC-7, Leonel Câmara wrote:
>
> Is it possible web2py is running in a virtualenv where you have not 
> installed cx_Oracle?
>
> Also don't forget to restart Apache.
>

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: Oracle drivers.

[Michael M]

Forgot to paste the Error on my Non-Prod Virt.

Versionweb2py™Version 2.12.3-stable+timestamp.2015.08.19.00.18.03Traceback

1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.

Traceback (most recent call last):
  File "/opt/www-data/web2py/gluon/restricted.py", line 227, in restricted
exec ccode in environment
  File "/opt/www-data/web2py/applications/test/models/db.py" 
<https://lapspm01094d01.adt.np.costco.com/admin/default/edit/test/models/db.py>,
 line 37, in 
db = DAL(myconf.take('db.uri'), pool_size=myconf.take('db.pool_size', 
cast=int), check_reserved=['all'])
  File "/opt/www-data/web2py/gluon/packages/dal/pydal/base.py", line 174, in 
__call__
obj = super(MetaDAL, cls).__call__(*args, **kwargs)
  File "/opt/www-data/web2py/gluon/packages/dal/pydal/base.py", line 459, in 
__init__
raise RuntimeError("Failure to connect, tried %d times:\n%s" % (attempts, 
tb))
RuntimeError: Failure to connect, tried 5 times:
Traceback (most recent call last):
  File "/opt/www-data/web2py/gluon/packages/dal/pydal/base.py", line 437, in 
__init__
self._adapter = ADAPTERS[self._dbname](**kwargs)
  File "/opt/www-data/web2py/gluon/packages/dal/pydal/adapters/base.py", line 
57, in __call__
obj = super(AdapterMeta, cls).__call__(*args, **kwargs)
  File "/opt/www-data/web2py/gluon/packages/dal/pydal/adapters/oracle.py", line 
105, in __init__
if do_connect: self.find_driver(adapter_args,uri)
  File "/opt/www-data/web2py/gluon/packages/dal/pydal/adapters/base.py", line 
188, in find_driver
raise RuntimeError("no driver available %s" % str(self.drivers))
RuntimeError: no driver available ('cx_Oracle',)


On Tuesday, October 6, 2015 at 4:33:16 PM UTC-7, Michael M wrote:
>
> yeah I tried spinning up another application in my Non-prod env. 
>
> 2.12.3-stable+timestamp.2015.08.19.00.18.03
> (Running on Apache/2.4.6 (Red Hat Enterprise Linux) OpenSSL/1.0.1e-fips 
> mod_wsgi/3.4 Python/2.7.5, Python 2.7.5)
>
> and just changed the URI from:
>
> uri   = sqlite://storage.sqlite
>
> to:
>
> uri   = oracle://
>
> and got the same error.  and I didnt import anything just changed that one 
> thing on that app and it gave be the same error just trying to load the 
> index page as second error I pasted above.
>
>
> On Tuesday, October 6, 2015 at 4:23:05 PM UTC-7, Leonel Câmara wrote:
>>
>> Well the dal tries to "import cx_Oracle" and it should work since it's 
>> installed - Weird. Did you already have web2py running before installing 
>> cx_Oracle and you didn't restart it (say by touching its uwsgi config 
>> file)?  
>>
>

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: Oracle drivers.

[Michael M]

yeah I tried spinning up another application in my Non-prod env. 

2.12.3-stable+timestamp.2015.08.19.00.18.03
(Running on Apache/2.4.6 (Red Hat Enterprise Linux) OpenSSL/1.0.1e-fips 
mod_wsgi/3.4 Python/2.7.5, Python 2.7.5)

and just changed the URI from:

uri   = sqlite://storage.sqlite

to:

uri   = oracle://

and got the same error.  and I didnt import anything just changed that one 
thing on that app and it gave be the same error just trying to load the 
index page as second error I pasted above.


On Tuesday, October 6, 2015 at 4:23:05 PM UTC-7, Leonel Câmara wrote:
>
> Well the dal tries to "import cx_Oracle" and it should work since it's 
> installed - Weird. Did you already have web2py running before installing 
> cx_Oracle and you didn't restart it (say by touching its uwsgi config 
> file)?  
>

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: Oracle drivers.

[Michael M]

i was just trying to find some way to expose more of what going on.  When I 
call Oracle in my DB configs uri = oracle://... I get this

1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.

Traceback (most recent call last):
  File "/opt/www-data/web2py/gluon/restricted.py", line 227, in restricted
exec ccode in environment
  File "/opt/www-data/web2py/applications/test/models/db.py" 
,
 line 37, in 
db = DAL(myconf.take('db.uri'), pool_size=myconf.take('db.pool_size', 
cast=int), check_reserved=['all'])
  File "/opt/www-data/web2py/gluon/packages/dal/pydal/base.py", line 174, in 
__call__
obj = super(MetaDAL, cls).__call__(*args, **kwargs)
  File "/opt/www-data/web2py/gluon/packages/dal/pydal/base.py", line 459, in 
__init__
raise RuntimeError("Failure to connect, tried %d times:\n%s" % (attempts, 
tb))
RuntimeError: Failure to connect, tried 5 times:
Traceback (most recent call last):
  File "/opt/www-data/web2py/gluon/packages/dal/pydal/base.py", line 437, in 
__init__
self._adapter = ADAPTERS[self._dbname](**kwargs)
  File "/opt/www-data/web2py/gluon/packages/dal/pydal/adapters/base.py", line 
57, in __call__
obj = super(AdapterMeta, cls).__call__(*args, **kwargs)
  File "/opt/www-data/web2py/gluon/packages/dal/pydal/adapters/oracle.py", line 
105, in __init__
if do_connect: self.find_driver(adapter_args,uri)
  File "/opt/www-data/web2py/gluon/packages/dal/pydal/adapters/base.py", line 
188, in find_driver
raise RuntimeError("no driver available %s" % str(self.drivers))
RuntimeError: no driver available ('cx_Oracle',)


On Tuesday, October 6, 2015 at 3:45:40 PM UTC-7, Leonel Câmara wrote:
>
> You don't need to import it in your application the DAL does it for you.
>

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Oracle drivers.

[Michael M]

2.12.3-stable+timestamp.2015.08.19.00.18.03
(Running on Apache/2.4.16 (Fedora) OpenSSL/1.0.1k-fips mod_wsgi/4.4.8 
Python/2.7.10, Python 2.7.10)

So "import cx_Oracle" works in python console but when I tried using it in 
web2py it errors out.  (Cannot import module 
'applications.test2.modules.cx_Oracle')

the only thing i have found is that the file structure looks different from 
cx_Oracle to another import i use.

pysnmp works in web2py and straight python:
>>> import pysnmp
>>> pysnmp.__file__
'/usr/lib/python2.7/site-packages/pysnmp/__init__.pyc'

cx_Oracle doesnt work in web2py but works in py files.
>>> import cx_Oracle
>>> cx_Oracle.__file__
'/usr/lib/python2.7/site-packages/cx_Oracle.so'


the only difference I saw was that its a .so file instead of __init__.pyc

Any thoughts.  Trying to get this to work in Fedora 22.  Thanks!

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Proposed Change to "setup-web2py-fedora.sh"

[Michael M]

In my environment.  I have to go to a different floor and sit at a linux 
admin's desk to finalize the script.  He yelled at me that the password 
prompt should not be in clear text.  And their policy is watch exactly what 
non-admins are doing.

On Tuesday, September 29, 2015 at 9:06:00 AM UTC-7, Niphlod wrote:
>
> uhm, pretty different topics. the setup file doesn't hold the password. 
> the proposed fix just avoids prying eyes from snooping it (read, a 
> collegue behind you) when you fill itis there something I'm missing 
> ?
>

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Proposed Change to "setup-web2py-fedora.sh"

[Michael M]

On File "Setup-web2py-fedora.sh"

Line 387: sudo -u apache python -c "from gluon.main import save_password; 
save_password(raw_input('admin password: '),443)"
to
Line 387: sudo -u apache python -c "from gluon.main import save_password; 
import getpass; save_password(getpass.getpass('admin password: '),443)"

To not have chosen password in clear text.  Tested/Working.

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: Load Balanced Server code updating

[Michael M]

That gives me a lot to go on.  Thank-you Niphlod. 

I just got off the vanpool this morning and found out one of my co-workers 
runs some of our corporate infrastructure.  He suggested I look at Puppet, 
Chef, or Ansible for cluster management.  So looks like I have some 
learning to do.  :)

Wish me luck.  :)

On Wednesday, August 12, 2015 at 12:03:33 AM UTC-7, Niphlod wrote:
>
> the update process on several frontend servers can be split into 2 modes: 
> you can have an "incremental" update, in which the newer version of the 
> application doesn't break the old one, and the "breaking" update, in which 
> the newer version of the application breaks the old one.
>
> in the first case, you can log into each one of the servers and update the 
> app.
> in the second case, you need to log into each server, put the application 
> in "maintenance mode", update each server, and then revoke the "maintenance 
> mode" on each.
>
> there are SEVERAL ways to do it, some more elegant and intricated, some 
> more simple and maintainable.
>
> Start with basics: prepare a makefile or a procedure that updates a single 
> node, then execute it in a "foreach server" loop. It can be bash, python, 
> go, whatever you're more comfortable with. Draw the procedure on a sheet of 
> paper first (yes, it gets the deal done to unravel the necessary steps 
> beforehand) and then implement each piece. I use fabric to handle the 
> automation part wherever I can. Bash makefiles or powershell scripts where 
> I can't.
>
> On Wednesday, August 12, 2015 at 7:49:13 AM UTC+2, Michael M wrote:
>>
>> Hello All,
>>
>> I was looking at Load Balancing due to my Self Service Web Portal is I/O 
>> and Networking intensive.  
>>
>> I found 
>> http://www.web2pyslices.com/slice/show/1360/high-availability-cluster-with-pound
>>  
>> in it there is a this "We recommend using  
>> <http://www.web2pyslices.com/slice/show/1360/29>this install procedure 
>> <http://www.web2pyslices.com/slice/show/1360/29>" Which looks like a 
>> dead link.
>>
>> So if anyone knows the current slice that is referring to would be a 
>> great help.
>>
>> The main question is: Say I have 10 servers and I make a change to a 
>> module  and a view of an application.  How do I update to all servers 
>> without having to log into each and upload a Tar?
>>
>> Or what is the best practices?
>>
>> I am new to web-servers so please be verbose so I can learn as much as 
>> possible.  Thank-you.
>>
>

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Load Balanced Server code updating

[Michael M]

Hello All,

I was looking at Load Balancing due to my Self Service Web Portal is I/O 
and Networking intensive.  

I found 
http://www.web2pyslices.com/slice/show/1360/high-availability-cluster-with-pound
 
in it there is a this "We recommend using  
this install procedure 
" Which looks like a dead 
link.

So if anyone knows the current slice that is referring to would be a great 
help.

The main question is: Say I have 10 servers and I make a change to a module 
 and a view of an application.  How do I update to all servers without 
having to log into each and upload a Tar?

Or what is the best practices?

I am new to web-servers so please be verbose so I can learn as much as 
possible.  Thank-you.

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.