[web2py] Re: web2py -> py4web

2024-07-15 Thread Brian M
I have a larger web2py app that would be a chore to migrate - hard to justify the time without clear incentives. It’s running Python 3.10 and not on GAE. Would be nice if there was at least some security updates. On Saturday, July 13, 2024 at 9:10:05 PM UTC-5 Massimo Di Pierro wrote: > Hello ev

[web2py] web2py.com "Not Secure" wrong SSL Cert

2024-07-09 Thread Brian M
FYI - https://www.web2py.com is giving a "Not secure" warning because the SSL certificate is actually for *.pythonanywhere.com instead of web2py.com. Your connection is not private Attackers might be trying to steal your information from *www.web2py.com* (for example, passwords, messages, or c

[web2py] web2py website

2024-02-21 Thread M B
Will the web2py website be getting a refresh anytime? That award badge - it's from 14 years ago. -- 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 rece

Re: [web2py] web3py -> py4web

2019-09-05 Thread Juan M. Chapa Z.
Great! El jul 24, 2019 12:40 a.m., "Massimo Di Pierro" escribió: > OK. I know. I am not good with names. > But there are lots of requirements to be fulfilled. > py4web.com was available and the pypi package was available. > Here is running on google cloud: > http://py4web.com/ > > Ducking... > >

Re: [web2py] bye bye T, welcome pluralize

2019-05-03 Thread Juan M. Chapa Z.
Hi Massimo! I think is great, as long as you keep both available 'cause pluralize seems to be great for countable objects and stats, while T should still be available for real translations. Those are different stuff. On Fri, Apr 26, 2019 at 12:53 AM Massimo Di Pierro < massimo.dipie...@gmail.com>

[web2py] Re: Python 3 - Traceback problems

2019-02-16 Thread Brian M
Looks like if you use the latest git version then the error tickets work as expected. On Friday, February 15, 2019 at 10:04:50 AM UTC-6, Kevin Keller wrote: > > Is there any update to this? > > On Friday, 1 February 2019 17:21:40 UTC+1, Brian M wrote: >> >> So I

[web2py] Python 3 - Traceback problems

2019-02-14 Thread Brian M
Am I really the only one having this problem? Having the error ticket system not work seems like a pretty significant obstacle to using web2py with python 3.7 -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://cod

[web2py] Web2py with python3: difference in error reporting

2019-02-05 Thread Brian M
Reported the same a few days ago but have heard nothing. :( https://groups.google.com/forum/m/#!topic/web2py/dTsDZJ8jhyg -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list

[web2py] Python 3 - Traceback problems

2019-02-01 Thread Brian M
So I'm trying to finally move my web2py apps over to Python 3.7 before Python 2.7 reaches EOL and, while for the most part they're working fine, I am finding that when there is a problem the web2py Error ticket is just about useless (doesn't tell you where the error actually occurs) because web

[web2py] Re: Caching DAL Selects - only cache.ram works?

2018-04-26 Thread Brian M
Brown', 1, u'Snoopy')) While running DISKCache_Working multiple times works just fine. The difference seems to be that the version that fails ends up with two "id" and two "name" fields while the version that works has all unique field names. pet_owners : pe

[web2py] Re: 'Column table.id not found (SQLTABLE)'

2018-04-20 Thread Brian M
Thank you for mentioning this - just wasted an hour plus trying to figure out why my code had stopped working only to find that it was because I'd done pip install pydal for something else and foolishly not used a venv. Uninstalled pydal and everything was good again. So warning to others, avoi

[web2py] Re: Caching DAL Selects - only cache.ram works?

2018-04-06 Thread Brian M
So it caching selects to disk or redis supposed to only work if you have uniquely named fields? It doesn't seem to make a difference if I set cachable=True or not. On Tuesday, April 3, 2018 at 5:15:25 PM UTC-5, Brian M wrote: > > Further investigation shows that cache.redis plays

[web2py] Re: Caching DAL Selects - only cache.ram works?

2018-04-03 Thread Brian M
:55 PM UTC-4, Anthony wrote: >> >> It should work. Could be a bug specific to using pyodbc. Have you tried >> it with other databases/drivers? Feel free to file a PyDAL issue. >> >> Anthony >> >> On Tuesday, April 3, 2018 at 12:40:50 PM UTC-4, Brian M wrote: &

[web2py] Caching DAL Selects - only cache.ram works?

2018-04-03 Thread Brian M
I've been playing with caching and looking through the mailing list and have a bit of confusion about whether or not you can actually cache DAL Selects with anything other than cache.ram due to issues with what can/cannot be pickled. When I use db(...).select(...,cache=(cache.disk, 300), cache

[web2py] customizing SQLFORM to insert many rows from one form

2018-04-02 Thread Mashareq M
Hi, I am creating a web app for attending employees. This is the model: db.define_table( 'employee', Field('name'), format = '%(name)s') db.define_table( 'attendance', Field('employee_id',db.employee), Field('attend','boolean'), Field('comments','text') ) This is t

[web2py] Re: web2py compatibility for python3

2018-01-30 Thread 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 w

[web2py] Re: iterselect() and doing other DB actions - Connection is busy with results for another command

2018-01-10 Thread Brian M
it for the next person that might find this. On Wednesday, January 10, 2018 at 3:26:16 PM UTC-6, Anthony wrote: > > On Wednesday, January 10, 2018 at 2:48:34 PM UTC-5, Brian M wrote: >> >> Thank you Anthony, that works! >> >> Only issue is that while using iter

[web2py] Re: iterselect() and doing other DB actions - Connection is busy with results for another command

2018-01-10 Thread Brian M
on=yes', ...) > > Note, it may need to be all caps -- MARS_CONNECTION. > > Anthony > > On Wednesday, January 10, 2018 at 10:48:19 AM UTC-5, Brian M wrote: >> >> I'm attempting to process through record sets from DAL queries that can >> sometimes return hund

[web2py] iterselect() and doing other DB actions - Connection is busy with results for another command

2018-01-10 Thread Brian M
I'm attempting to process through record sets from DAL queries that can sometimes return hundreds of thousands of records. To try to keep memory usage under control I wanted to use iterselect() instead of a plain DAL select(). However, the problem I'm running into is that as I process each reco

[web2py] Re: Azure deployment recommendations?

2017-05-25 Thread Brian M
4, 2017 at 7:10:48 PM UTC-7, Brian M wrote: >> >> I'm looking to try deploying a web2py app on Azure. Is the route >> mentioned here >> <https://groups.google.com/forum/#!topic/web2py/XGxM_Tb9nJ4> still the >> best approach? Since running scheduled tasks w

[web2py] Azure deployment recommendations?

2017-05-24 Thread Brian M
s a Windows service via NSSM) on Azure? Any tips or recommendations would be appreciated. Thanks, Brian M -- 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) --- Y

[web2py] Re: widget.autocomplet vs IS_IN_DB : formatting, filtering

2017-05-08 Thread Brian M
I've used bootstrap-select ( https://silviomoreto.github.io/bootstrap-select/examples/ ) to enhance standard select drop down lists and allow live searching. Would work well with your lists ofbecause the user can just type in part of any one of them and the options automatically filter down

[web2py] Re: web2py behind IIS - 404 File or Directory Not Found.

2017-04-07 Thread Brian M
I cannot truly help, but I do use IIS and have found that it can be cantankerous. I would suggest simply trying to get a static file from web2py then you can work on the IIS settings to allow certain types of files that it might be blocking. The 404 on a new IIS installation simply means you ha

[web2py] Re: TABLE and TBODY helpers add TR innapropriately

2017-04-07 Thread Brian M
Leonel thanks for your help. I did need to put everything in the XML the way I was doing it because otherwise it all gets escaped. But that is because I was basically converting everything to a string first which is not what I wanted so you were right and I was confused. As far as why not put

[web2py] Re: TABLE and TBODY helpers add TR innapropriately

2017-04-07 Thread Brian M
Anthony, this is what I was looking for. Thanks! I am trying not to build the html myself and use the helpers instead. I am going for readability and ease of use for others to modify later. In all the examples in the book nowhere did it show the append and insert for the HTML helpers I looked at

[web2py] TABLE and TBODY helpers add TR innapropriately

2017-04-06 Thread Brian M
I am trying to build a table from a joined set of db tables and need to do quite a bit of processing to make the links and buttons in each row. Making the code readable is important to me so I do not want to put one giant long line of code to do everything and make it impossible for another pers

[web2py] Re: Autoincrement which resets each month (not primary id)

2017-03-05 Thread Brian M
portion and it is perhaps slightly easier for humans to understand which is presumably important because I don't get why you'd want to include the year and month if it isn't supposed to mean anything to the user. db.your_table.human_id = Field.Virtual('human_id', la

[web2py] Docker

2017-02-01 Thread 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 (So

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

2017-02-01 Thread 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) --- Y

[web2py] Re: Difference of two date field in years

2016-12-11 Thread Brian M
Like Anthony said, without seeing your code we can't help. What exactly do you mean by "is not able to recognize date fields as date"? As an alternative to dateutil you could also look into the Pendulum package (https://pendulum.eustace.io/) which makes playing with dates even easier. On Frida

Re: [web2py] Re: Performance using MSSQL stored procedures

2016-12-02 Thread Brian M
https://datatables.net/extensions/scroller/examples/ if you must have huge numbers of rows displayed. On Friday, December 2, 2016 at 2:25:14 PM UTC-6, Dave S wrote: > > On Friday, December 2, 2016 at 12:33:46 AM UTC-8, Gabor Nyul wrote: >> >> Brian, >> >> In fact this is already done. I have a c

[web2py] Re: Javascript functions for Canvas not working

2016-12-02 Thread Brian M
In case other have this sort of a problem where javascript events are affected by the css of bootstrap... the problem was in the css file: bootstrap.min.css somehow the relative position causes the event not to bubble up. How jacked up is that? .col-xs-1,.col-sm-1,.col-md-1,.col-lg-1,.col-xs-

Re: [web2py] Re: Performance using MSSQL stored procedures

2016-12-01 Thread Brian M
What Dave S. said is key > > "*If you had insight into what the users were looking for during their > examination of the data*, you may be able to provide a better query that > could *simplify the data presentation*." Sit down with your users and find out what it is that they *actually* need

Re: [web2py] Re: https causes site to be in text

2016-12-01 Thread Brian M
The web server block for https probably needs all the same locations and error pages and such as the http server block has for the site to act the same. If those rules created identify the locations of items for the web server allow it to work in http, it only makes sense that the same rules sh

[web2py] Javascript functions for Canvas not working

2016-11-30 Thread Brian M
I have created a codepen that draws on the canvas and used a javascript addEventListener to capture the mouse clicks. I think that not working properly is my issue. What would be the proper procedure to grab a codepen sample and serve it up in the framework properly? I am still on the learning

[web2py] Is web2py better for interacting with python scripts?

2016-11-30 Thread Alex M
When wanting to make a web gui for a python script, is it then better to use a python web framework? I other words is there a better interaction between web2py and python scripts running on the server, than when using something like RoR to interact with python scripts. Or does it not matter sin

Re: [web2py] Re: Performance using MSSQL stored procedures

2016-11-30 Thread Brian M
Can you use web2py for a reporting site - sure, a lot of what I do with it is reporting. I've been using DataTables.net which can provide pagination, sorting, search, aggregation and even basic export (via TableTools) for almost free. While it can enhance regular old HTML tables, with large num

[web2py] setup_exe.py bbfreeze- Not building working executable

2016-11-30 Thread Brian M
Has anybody built their own Windows executable using extras\build_web2py\setup_exe.py lately? I've copied setup_exe.py and setup_exe.conf to the web2py TLD and ran python setup_exe.py bbfreeze and it builds the binary alright. But then when I actually launch the executable and fire up web2py ev

[web2py] Re: Do conditionals short circuit for DAL?

2016-11-26 Thread Brian M
Well even if you're writing the query using the DAL the actual data processing is being done by the database itself so that's where the "short circuiting" would need to happen and is dependent on the database's query optimization. Try running a SQL version of the query directly against the DB a

[web2py] Using whl files with web2py

2016-10-11 Thread Don M
Hi all I'm very new to this and relatively new to python. I have a project that depend has dependencies on python package on a whl file, is there a method of incorporating these into my web2py project so the users does not need to install them locally on their machine. I understand that this wh

[web2py] administrator admin

2016-10-11 Thread M Nasri AW
in the start web2py web framework at http://localhost:8000, how password to administrator password? -- 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 r

[web2py] Re: Under Scheduler request.is_scheduler is None rather than True - Why?

2016-10-09 Thread Brian M
;> On Monday, October 3, 2016 at 5:45:21 AM UTC+2, Brian M wrote: >>> >>> Is there a reason why when something is run under the scheduler >>> request.is_scheduler = None rather than True? When you access >>> request.is_scheduler from outside of the sched

[web2py] Re: Scheduler - response.render no longer working

2016-10-09 Thread Brian M
t; I'll open an issue and propose a fix. >> >> Anthony >> >> On Monday, October 3, 2016 at 5:48:40 AM UTC-4, Niphlod wrote: >>> >>> hum. Trunk has been recently updated in the management of caching code >>> for controllers and views wond

[web2py] Re: Under Scheduler request.is_scheduler is None rather than True - Why?

2016-10-03 Thread Brian M
https://github.com/web2py/web2py/issues/1484 On Monday, October 3, 2016 at 4:46:26 AM UTC-5, Niphlod wrote: > > can you please file a bug on https://github.com/web2py/web2py/issues ? > I'd like to keep track of it and fix ASAP > > On Monday, October 3, 2016 at 5:45:21 AM

[web2py] Under Scheduler request.is_scheduler is None rather than True - Why?

2016-10-02 Thread Brian M
Is there a reason why when something is run under the scheduler request.is_scheduler = None rather than True? When you access request.is_scheduler from outside of the scheduler you get False as one would expect. The current None value seems strange/non-intuitive. #this won't work if request.is_s

[web2py] Scheduler - response.render no longer working

2016-10-02 Thread Brian M
OK, so I've had multiple scheduled tasks running for years that use response.render('path/to/template.html', dict(var= 'something')) to help build email bodies and it has been working perfectly. Now when I try to upgrade to the latest web2py trunk (was on 2.13.4 - yeah I'm a bit behind) all tha

[web2py] Re: user name case sensitivity

2016-08-14 Thread 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 tab

[web2py] Re: Grid export csv

2016-08-04 Thread Kostas M
As you said, it works again now, by setting: entity_quoting=False Thanks Niphlod! -- 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 mess

[web2py] Re: Grid export csv

2016-08-01 Thread Kostas M
I have the same problem with the CSV, HTML, TSV export buttons. The Ticket for the CSV is pasted below. The problem at least with the csv export button seems to be with the REGEX_TABLE_DOT_FIELD. Normally, this constant is defined in regex.py as: REGEX_TABLE_DOT_FIELD = re.compile('^(\w+)\.([^.

[web2py] Re: UWSGI root vs limited user.

2016-07-19 Thread 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/st

[web2py] "requires distutils, but not installed" error Web2Py_Win 64bit

2016-05-24 Thread Vignesh M
Hi Team, I am using Python2.7 and Web2Py_Win.exe. I am getting "requires distutils, but not installed" error message while pressing the [Deploy to OpenShift] button. Please help me solve this issue. Thanks. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://gi

[web2py] Re: DAL connection to MSSQL

2016-04-06 Thread Brian M
You can do it but you must tell the DAL that the table exists. It won't just discovered existing tables for itself. -- 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 Is

[web2py] DAL connection to MSSQL

2016-04-04 Thread Brian M
I think db._tables only lists the tables you have defined within the DAL rather than going to the database itself and listing any tables that are there independent of the DAL (for example if you are connecting to a database that wasn't created through the DAL). Have you defined any tables withi

[web2py] Re: Function can't update DB when called from scheduler, but can when called from a controller/function

2016-03-23 Thread M Mihai
On Wednesday, March 23, 2016 at 5:44:34 PM UTC+2, Dave S wrote: > > > > On Wednesday, March 23, 2016 at 7:46:24 AM UTC-7, M Mihai wrote: >> >> >> >> On Wednesday, March 23, 2016 at 1:24:32 AM UTC+2, Dave S wrote: >>> >>> >>> &g

[web2py] Re: Function can't update DB when called from scheduler, but can when called from a controller/function

2016-03-23 Thread M Mihai
On Wednesday, March 23, 2016 at 1:24:32 AM UTC+2, Dave S wrote: > > > > On Tuesday, March 22, 2016 at 3:45:25 PM UTC-7, M Mihai wrote: >> >> So I want to update the database while a scheduler task is running but >> the function won't update it. If I

[web2py] Function can't update DB when called from scheduler, but can when called from a controller/function

2016-03-22 Thread M Mihai
So I want to update the database while a scheduler task is running but the function won't update it. If I try to run the same function from a controller it will update the database. Here is the function: def Test(): row = db(db.posts.Posted==False).select().first() row.update_record(Pos

[web2py] Re: Scheduler as a service RHEL 7

2016-03-19 Thread 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 me

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

2016-03-19 Thread 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 e

[web2py] Re: Scheduler as a service RHEL 7

2016-03-15 Thread Michael M
tworktools,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 serv

[web2py] Re: Scheduler as a service RHEL 7

2016-03-15 Thread Michael M
: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 th

[web2py] Re: Scheduler as a service RHEL 7

2016-03-15 Thread 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, Mich

[web2py] Re: Scheduler as a service RHEL 7

2016-03-13 Thread Michael M
uot; 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/web2p

[web2py] Re: Scheduler as a service RHEL 7

2016-03-13 Thread Michael M
: 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 w

[web2py] Scheduler as a service RHEL 7

2016-03-12 Thread 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 NotifyAcces

[web2py] Send Mail with AppRelay Server

2016-03-12 Thread 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

[web2py] Send Mail with AppRelay Server

2016-03-12 Thread 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

[web2py] Send Mail with AppRelay Server

2016-03-12 Thread 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

Re: [web2py] Restored DB, _enable_record_versioning() and fake migrations?

2016-02-23 Thread Brian M
determine if the issue is coming form > new web2py version or not). > > Or could it be possible that you create the archive table manually back in > time? Or that some file in app/databases/ folder get deleted?? > > Richard > > > > On Tue, Feb 23, 2016 at 11:12 AM, Brian

Re: [web2py] Restored DB, _enable_record_versioning() and fake migrations?

2016-02-23 Thread Brian M
>> _enable_record_versioning() for one turn... You try access your app with >> only one table under record versioning to see if it works... Then if this >> work, I would make sure (explicit) what is the name of the archive table to >> see if the issue go aw

Re: [web2py] Restored DB, _enable_record_versioning() and fake migrations?

2016-02-22 Thread Brian M
gt;is_active='is_active') > > Where I specified the name of the table to use for archiving records... > > You may have a look at your history table(s) and try to set the previous > parameters for each of your instanciation of the

Re: [web2py] Restored DB, _enable_record_versioning() and fake migrations?

2016-02-22 Thread Brian M
gt; > What is the traceback error message? > > On Mon, Feb 22, 2016 at 9:53 PM, Brian M > > wrote: > >> The restore was done with MS SQL Server's built-in backup & restore so >> yes it has all of the tables and info. The dozens of other tables in my >&

Re: [web2py] Restored DB, _enable_record_versioning() and fake migrations?

2016-02-22 Thread Brian M
6 at 8:39:22 PM UTC-6, Richard wrote: > > If you restore database like for like, why are you bother with > fake_migrate... Just leave everything to migrate=False should be alright if > you dump contains all the tables... > > Richard > > On Mon, Feb 22, 2016 at 4:55 PM, Brian

[web2py] Restored DB, _enable_record_versioning() and fake migrations?

2016-02-22 Thread Brian M
I seem to have run into a problem with tables I'm using _enable_record_versioning() with. I'm setting up on a new computer and have restored a DB backup to the new computer. Now when I try to run pages that utilize those tables the database is complaining that the _archive tables already exist.

[web2py] Re: daily scheduler task - FIX

2016-02-21 Thread Brian M
n the times_failed becomes zero and now you're going to calculate incorrect next_run_time values (they'll likely end up in the past) and just end up with your task running extra again. So not quite so simple of a fix as I initially thought. :\ On Sunday, February 21, 2016 at 9:44:41 AM

[web2py] Re: daily scheduler task - FIX

2016-02-21 Thread Brian M
n the times_failed becomes zero and now you're going to calculate incorrect next_run_time values (they'll likely end up in the past) and just end up with your task running extra again. So not quite so simple of a fix as initially On Sunday, February 21, 2016 at 9:44:41 AM UTC-6

[web2py] Re: daily scheduler task - FIX

2016-02-21 Thread Brian M
Well I was looking at it as the task was still run by the scheduler even if it didn't complete successfully so the run count should go up regardless. If you are not using the prevent drift option then the scheduler bumps forward the next run time whether or not the task was successful so my cha

[web2py] Re: daily scheduler task

2016-02-20 Thread Brian M
ersion of gluon/scheduler.py and it does appear to fix the problem so after. So if Massimo, Nilphod or another developer can review and add the patch I'm sure at least Alex & I would appreciate it. Brian On Saturday, February 20, 2016 at 8:21:24 PM UTC-6, Brian M wrote: > > My setu

[web2py] Re: daily scheduler task

2016-02-20 Thread Brian M
My setup is on Windows with the scheduler running as a service via nssm. I have it set to run every 86400 seconds (24hrs) with infinite number of runs and retries. The timeout is something like 2 or 3 minutes. I am also using the "cron like" option so that it always runs at exactly the same time

[web2py] Re: daily scheduler task

2016-02-19 Thread Brian M
Oddly enough I actually had this happen this past weekend. I have a daily task that sends plant status update emails and the view template that renders the email body was choking because of an unexpected dividide by zero. The first day after the bad data was entered the scheduled run did simply

[web2py] Re: A guide how to install your web2py app on your own server (using DigitalOcean droplets)

2016-02-15 Thread &#x27;M Bailey' via web2py-users
Wow just read your blog. Really useful, clear instructions - thank you. On Monday, 15 February 2016 10:54:01 UTC, Dragan Matic wrote: > > Hey guys, I wrote a guide for beginners how to install and configure your > own server and how to host your web2py app on it, if anybody's interested > here's

[web2py] Memcache, MEMDB tcp connections not closing

2016-02-10 Thread Russ M
I use memcache and MEMDB for session storage and caching. The CentOS server is setup with an apache modwsgi process group, setup through the wsgihandler.py. I establish the MemcacheClient and MEMDB as the cache and session db in my app's models/db.py file. It appears that when requests have

[web2py] Re: Yellow box on screen following update

2016-02-08 Thread M Bailey
> > > Thanks guys, appreciate the feedback. -- 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 G

[web2py] Yellow box on screen following update

2016-02-04 Thread M Bailey
Hi All I just updated web2py today on my ubuntu box and I now get a yellow box on the screen in the admin area, which wasn't appearing before (screen shot attached). It's like an information dialog which isn't displaying anything and it only affects the admin area. The applications themselves

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

2016-01-26 Thread Michael M
rst_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

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

2016-01-22 Thread 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_n

[web2py] Re: Problems with user_signature=True in URL( )

2015-12-25 Thread Jes M
Thanks for your answers Massimo and Anthony. I'll try again and share the full piece of related code if it continues to fail. Best regards Jes -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p

[web2py] Problems with user_signature=True in URL( )

2015-12-24 Thread Jes M
Hi: I've been browsing google but I can't manage the code to works with other solutions I've found. Here it goes the issue: controller: btn_edit = lambda row: A(T("Editar"), _href=URL('manage_user', args=[row.id],user_signature=True)) links = [ btn_edit ] .. .. adminusers_g

[web2py] Re: Select statement with MSSQL

2015-12-19 Thread Brian M
You must first tell the DAL about the tables in your database before you can ask it to select data from them. http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Table-constructor On Saturday, December 19, 2015 at 3:39:45 AM UTC-6, sa wrote: > > Hi, > > Can not select

[web2py] Re: Oracle drivers.

2015-12-04 Thread 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

[web2py] Re: Oracle drivers.

2015-11-23 Thread 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, Nov

[web2py] Re: Oracle drivers.

2015-10-22 Thread Michael M
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

[web2py] Re: Oracle drivers.

2015-10-22 Thread Michael M
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 Thursda

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

2015-10-15 Thread 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

Re: [web2py] Re: qrcode

2015-10-14 Thread Michael M
: > > 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 (Sourc

Re: [web2py] Re: qrcode

2015-10-14 Thread Michael M
ode/__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 >&

[web2py] How to import data from csv file in web2py for SQLite database?

2015-10-14 Thread Prasad M
I am trying to import data from csv in web2py's SQlite databae. 1) First I have defined table in database. 2) I wrote db.table2.import_from_csv_file(open(open('mycsv','r')) this line . Both steps are in Model. But while displaying data from the same table I am getting repeated rows at each re

[web2py] Re: qrcode

2015-10-14 Thread 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_COR

[web2py] Re: Oracle drivers.

2015-10-14 Thread 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 link

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

2015-10-09 Thread 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 te

[web2py] Re: Oracle drivers.

2015-10-08 Thread 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,

  1   2   3   4   5   6   7   8   >