[web2py] PythonAnywhere to AWS

2019-09-10 Thread Ian Ryder
Hi all, I asked a question a while back about AWS and Nginx but didn't get a reply so trying a different path! I've got an app I need to move over to AWS - does anyone know the easiest way to get web2py up and running on Amazon? I tried the old scripts for nginx but they seem to be out of date.

[web2py] Ubuntu + nginx on AWS

2019-08-22 Thread Ian Ryder
Hi all, does any know if the recipe / script for deploying on Amazon is still OK? I tried (admittedly in a bit of hurry) a few weeks ago and it complained about versions and I had to drop it and get on with other stuff. Before I try again, just wanted to double check - if you know where any cur

[web2py] Logger issue

2017-10-22 Thread Ian Ryder
Hi, we're just getting logging running on an app we're building and have a what I hope is a bit of noob issue. It seems every time a request comes in a new file handle is opened and not released when the request is finished. Eventually we get an error with too many open files and everything sto

[web2py] Re: sitemap.xml

2017-06-21 Thread Ian Ryder
def sitemap(): # Import Os and Regex import os from gluon.myregex import regex_expose # Finding You Controllers ctldir = os.path.join(request.folder, "controllers") ctls = os.listdir(ctldir) # Excluding The appadmin.py and the Manage.py

[web2py] Re: New site on web2py

2017-06-21 Thread Ian Ryder
Hi Ron, we've started up a company, I'm one of the founders On Wednesday, 21 June 2017 16:54:00 UTC+2, Ron Chatterjee wrote: > > Is this your personal site or you doing this for a client? -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2p

[web2py] Re: New site on web2py

2017-06-21 Thread Ian Ryder
e site. congratulations! > > On Wednesday, 14 June 2017 08:36:18 UTC-5, Ian Ryder wrote: >> >> Hi all, not sure if it's OK to do this - slap me down if not! >> >> We're just about to launch a new tool / site based on web2py - >> https://www.wherecani.live

Re: [web2py] New site on web2py

2017-06-19 Thread Ian Ryder
http://itjp.net.b <http://itjp.net.br>r >> *Ovidio Marinho Falcao Neto* >> ovid...@gmail.com >> Brasil >> >> >> 2017-06-14 10:36 GMT-03:00 Ian Ryder > >: >> >>> Hi a

Re: [web2py] Re: New site on web2py

2017-06-18 Thread Ian Ryder
u Clabaut wrote: > > Looks nice, and the concept is interesting. > FYI, the next button didn't work here on Firefox on android. > > What's your hosting model ? > > Le sam. 17 juin 2017 à 11:35, Ian Ryder > a écrit : > >> Thanks Tim, much appreciated - it's

[web2py] Re: New site on web2py

2017-06-17 Thread Ian Ryder
y, 16 June 2017 16:12:47 UTC+2, tim.n...@conted.ox.ac.uk wrote: > > Very impressive. Especially impressed by the 'Save for later' process, > which I bet I'll end up copying. > > On Wednesday, 14 June 2017 14:36:18 UTC+1, Ian Ryder wrote: >> >> Hi

Re: [web2py] New site on web2py

2017-06-14 Thread Ian Ryder
Thanks - can't take all the credit, it was based around one called Unify but has been heavily tweaked! On Wednesday, 14 June 2017 18:22:00 UTC+2, Chinh Dang wrote: > > Beautiful design. Did you use any particular bootstrap-based theme for > this? > > On Jun 14, 2017

[web2py] Re: New site on web2py

2017-06-14 Thread Ian Ryder
he press around Brexit. It's very relevant for a lot of people stuck in limbo right now! On Wednesday, 14 June 2017 18:00:27 UTC+2, Ron Chatterjee wrote: > > Interesting! What are the marketing steps you are taking to promote the > site? > > On Wednesday, June 14, 2017 a

[web2py] New site on web2py

2017-06-14 Thread Ian Ryder
Hi all, not sure if it's OK to do this - slap me down if not! We're just about to launch a new tool / site based on web2py - https://www.wherecani.live Any feedback appreciated and if it's useful to anyone looking to live in different parts of the world, great stuff. Thanks Massimo et al for t

[web2py] Re: AWE Elasticbeanstalk and web2py

2017-03-14 Thread Ian Ryder
Hi, has anyone successfully set up ELB with web2py? I've been trying and struggling to get very far. I made it as far as 'web2py/handlers/wsgihandler.py web2py' in the instructions below and can't get any further - the error I get is 'Running from the wrong folder' Looking at the code in wsgih

Re: [web2py] Re: Handling (2006, 'MySQL server has gone away') from Scheduler, pythonanywhere

2016-05-23 Thread Ian Ryder
re is fantastic - so easy to get going, just not enough control for our full requirements. On Monday, 23 May 2016 16:40:17 UTC+2, Andre Kozaczka wrote: > > Thanks for the quick response! You still using pythonanywhere? > > > On Monday, May 23, 2016 at 10:12:49 AM UTC-4, Ian Ryder wr

Re: [web2py] Re: Handling (2006, 'MySQL server has gone away') from Scheduler, pythonanywhere

2016-05-23 Thread Ian Ryder
g your own scheduling handler? > > -Andre > > On Thursday, February 5, 2015 at 5:55:04 AM UTC-5, Ian Ryder wrote: > >> Think it is pretty similar to this - we have 3 databases open. Seems to >> only happen when a big process / query runs. >> >> More worrying no

[web2py] Re: Create a service running continuously

2016-03-02 Thread Ian Ryder
Sounds like you just need some sort of never ending loop (obviously you can put checks in the loop for stop requests and whatever other complexity you like / need). You can pass arguments on the python command line. So for example you could do something like: python web2py.py -S your_app -M -A

[web2py] Re: A MCV-related question: global search form

2015-11-18 Thread Ian Ryder
It could be pretty straight forward - as Leonel says, you would use Javascript / Ajax. If you rolled your own autocomplete you would have a controller in default (for example) and the layout would refer back to that controller. Doesn't matter what page you are looking at, the Ajax call is alway

[web2py] Re: Scheduler - Worker node heartbeats stop randomly

2015-11-05 Thread Ian Ryder
Where are you running your app? If it's PythonAnywhere they regular restart backend systems so there's no guarantee on any task hanging around for very long. https://help.pythonanywhere.com/pages/LongRunningTasks/ Beyond that we had a lot of similar issues that we couldn't quite put our finger

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

2015-10-05 Thread Ian Ryder
to have a blog for this type of news... > > 2015-10-05 15:27 GMT+02:00 Ian Ryder > >: > >> Thanks, just running some of their tools against our app - all good so >> far, if there's anything of interest I'll let you know (possibly off forum >>

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

2015-10-05 Thread Ian Ryder
ps://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 w

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

2015-10-04 Thread Ian Ryder
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 f

[web2py] Joined query help

2015-07-30 Thread Ian Ryder
Hi, I’m trying to construct a query in web2py which I’m struggling with - help appreciated :) Table 1 table1.batch_id Table 2 table2.table1 table2.table3 table2.amount Table 3 table3.name Query is roughly: select table3.name, sum(table2.amount), count(tabl

[web2py] Re: update_record not working but not failing.

2015-06-01 Thread Ian Ryder
I can't give specifics as I had to workaround it but I was having a similar issue last week with update_record. I'm using it everywhere without issue but one particular method wouldn't update and didn't show any error...if I see it again I'll post up and not work around it (I was having trouble

[web2py] Re: _before_insert / update question

2015-06-01 Thread Ian Ryder
st of (field, value) tuples). If you don't > mind, please file a pydal github issue and reference this post. > > Anthony > > On Friday, May 29, 2015 at 3:21:33 PM UTC-4, Ian Ryder wrote: >> >> It was this: >> >> new_ilis = [] >> ... >>

[web2py] Re: _before_insert / update question

2015-05-29 Thread Ian Ryder
TC+2, Anthony wrote: > > Possible bug. What does your bulk_insert code look like? > > On Friday, May 29, 2015 at 1:32:35 AM UTC-4, Ian Ryder wrote: >> >> OK - I think I have the answer. >> >> I discovered it wasn't table-specific, it worked with this same m

[web2py] Re: _before_insert / update question

2015-05-29 Thread Ian Ryder
TC+2, Anthony wrote: > > Possible bug. What does your bulk_insert code look like? > > On Friday, May 29, 2015 at 1:32:35 AM UTC-4, Ian Ryder wrote: >> >> OK - I think I have the answer. >> >> I discovered it wasn't table-specific, it worked with this same m

[web2py] Re: web2py Google Group

2015-05-28 Thread Ian Ryder
Hi, sorry - thought this was just to the group owner so wasn't supposed to be a general post, especially as it has my contact details in :) Any chance of it being removed from history? On Thursday, May 28, 2015 at 7:16:55 AM UTC+2, Ian Ryder wrote: > > Hi there > > I wonder

[web2py] Re: _before_insert / update question

2015-05-28 Thread Ian Ryder
OK - I think I have the answer. I discovered it wasn't table-specific, it worked with this same method / table elsewhere in the app. The place it was failing was using bulk_insert. I changed to insert individually and all works fine. Bug? On Friday, May 29, 2015 at 6:39:56 AM UTC+2, Ian

[web2py] Re: _before_insert / update question

2015-05-28 Thread Ian Ryder
Hi, the key point is I'm not getting passed a dict, I'm getting passed a list. Here's a dump of what the _is_before handler gets passed: [(, datetime.datetime(2015, 5, 29, 6, 32, 27, 732420)), (, 1L), (, 8L), (, 2L), (, 5.0), (, 14093L), (, 'APPEAL'), (, 1L), (, 358001L), (, datetime.datetim

[web2py] Re: _before_insert / update question

2015-05-28 Thread Ian Ryder
(or I need correcting) Here's the definition I have which I think is all standard?: db.income_line_item._before_insert.append(lambda f: trigger_ili_before_insert(f)) On Thursday, May 28, 2015 at 7:16:55 AM UTC+2, Ian Ryder wrote: > > Hi, I'd like to modify the data on a re

[web2py] Re: _before_insert / update question

2015-05-28 Thread Ian Ryder
Thanks - I couldn't find any documentation / examples and my tests didn't seem to work as expected. Do you know of any examples anywhere I can scan over? I'll have another test in the mean time and update if I get it working On Thursday, May 28, 2015 at 12:02:52 PM UTC+2, Niphlod wrote: > > "mo

[web2py] _before_insert / update question

2015-05-27 Thread Ian Ryder
Hi, I'd like to modify the data on a record before it is inserted / updated. I was hoping I could do this with _before_insert / update but I don't think it's possible. As an example from a previous life, in Salesforce on a before trigger you can change field values in memory on the way into the

[web2py] web2py Google Group

2015-05-27 Thread Ian Ryder
s not something specific about my account this must be the same for others. Is there anything I can do? It's generally holding back our use of web2py as we effectively don't have access to the community and we're building a pretty big application using it. Thanks Ian -- Ian R

[web2py] Re: Web2Py compute fields not working on update

2015-04-17 Thread Ian Ryder
Same problem here - all works fine but am using an after_update callback on a child record but the compute doesn't work when the parent record values are updated. On Tuesday, June 19, 2012 at 2:24:05 AM UTC+10, Brandon Reynolds wrote: > > I have this problem when i try to generate thumbnails.

Re: [web2py] Re: Ongoing issue with 'Lost connection to MySQL server during query'

2015-03-18 Thread Ian Ryder
adapter.close() > - db._adapter.reconnect() > Without the last trunk, try the following: > try: > db._adapter.close() > except: > db._adapter.connection = None > db._adapter.reconnect() > > but my suggestion is to use the last trunk > > > > > Paolo > > 2

Re: [web2py] Re: Ongoing issue with 'Lost connection to MySQL server during query'

2015-03-17 Thread Ian Ryder
operations, placing a db.commit between them. > Mind that in this case the bulk_insert will be executed into few > transactions. > > Otherwise, you can run a custom bulk_insert based on an executesql > containing all the inserts. > let us know more information about the quer

[web2py] Re: Ongoing issue with 'Lost connection to MySQL server during query'

2015-03-16 Thread Ian Ryder
mands in the last transaction (but > if you do a db.commit() before the operation, then it is fine). > a discussion about this new feature is here: > https://groups.google.com/d/topic/web2py-developers/e161iZZmp0Y/discussion > Finally, I've never tried it with mysql, but it shou

[web2py] Re: Ongoing issue with 'Lost connection to MySQL server during query'

2015-03-13 Thread Ian Ryder
nsert(table, item) for item in items] File "/home/ianryder/yarpr/web2py/gluon/dal.py", line 1361, in insert raise e OperationalError: (2006, 'MySQL server has gone away') On Saturday, March 14, 2015 at 8:30:39 AM UTC+11, Ian Ryder wrote: > > Hi, we are using Web2py to do som

[web2py] Re: Can we disable moderation in the group?

2015-03-13 Thread Ian Ryder
I think that's the case, this post won't go up until some time down the track and I've posted a few times On Saturday, March 7, 2015 at 1:12:30 PM UTC+11, Jack Kuan wrote: > > I don't see the need and think it can be off putting for new comers. > -- Resources: - http://web2py.com - http://web2

[web2py] Re: Can we disable moderation in the group?

2015-03-13 Thread Ian Ryder
I agree, I've posted quite a few and still have to wait what could be a day for my posts to appear (and I think some haven't appeared) so definitely puts me off using what is otherwise an essential resource. Certainly think traffic would go up...and not just spam :) On Saturday, March 7, 2015 a

[web2py] Ongoing issue with 'Lost connection to MySQL server during query'

2015-03-13 Thread Ian Ryder
Hi, we are using Web2py to do some batch processing of data but from day one have had show-stopping issues with losing connection to MySQL on PythonAnywhere. We've refactored the code to be much lighter in terms of batch sizes etc which has made it much closer to perfect but we still have probl

Re: [web2py] Re: Handling (2006, 'MySQL server has gone away') from Scheduler, pythonanywhere

2015-02-05 Thread Ian Ryder
Think it is pretty similar to this - we have 3 databases open. Seems to only happen when a big process / query runs. More worrying now is that I'm getting situations where a process starts and just disappears into the ether - no timeout, no fail, no error message. Just starts and is never seen

[web2py] Re: Handling (2006, 'MySQL server has gone away') from Scheduler, pythonanywhere

2015-02-03 Thread Ian Ryder
ffectively unworkable at the moment. Thanks in advance Ian On Tuesday, February 3, 2015 at 6:27:04 AM UTC+11, Massimo Di Pierro wrote: > > Did you put any dal query in a try... except? I am recently seeing people > do this a lot and it very wrong. > > On Monday, 2 February 2015

[web2py] Handling (2006, 'MySQL server has gone away') from Scheduler, pythonanywhere

2015-02-02 Thread Ian Ryder
Hi, I've got a showstopper running scheduler on pythonanywhere - every few hours it drops out with: Traceback (most recent call last): File "/web2py/gluon/shell.py", line 272, in run exec(python_code, _env) File "", line 1, in File "/web2py/gluon/scheduler.py", line 719, in loop self.wrapped_

[web2py] Re: Strange behaviour with request.args(0)

2015-01-29 Thread Ian Ryder
xternal_Key,])))] The URL generated looks a bit like this: http://127.0.0.1:8000/visuals/supporter_profile/003U00XXLrgIAE But the controller sees 'images' instead of '003U00XXLrgIAE' On Monday, January 26, 2015 at 10:21:40 AM UTC+11, Ian Ryder wrote: > > Hi th

[web2py] Re: site went down for no reason on pythonanywhere

2015-01-29 Thread Ian Ryder
I had this a few days ago - on investigation I found a reference to it on an import statement in the web2py code...I've no idea where it came from (via an update?), I removed it all worked OK from there On Thursday, January 29, 2015 at 1:24:07 PM UTC+11, LoveWeb2py wrote: > > receiving this erro

[web2py] Re: Strange behaviour with request.args(0)

2015-01-26 Thread Ian Ryder
Just to add, I swapped to use request.vars and it's all fine with the same IDs...so I'm rolling but a mystery with .args :) On Monday, January 26, 2015 at 10:21:40 AM UTC+11, Ian Ryder wrote: > > Hi there, first post after a couple of months using web2py - really > enjoyi

[web2py] Strange behaviour with request.args(0)

2015-01-25 Thread Ian Ryder
Hi there, first post after a couple of months using web2py - really enjoying it. I have a strange one though - I have a page where an ID is passed to the controller through request.arg(0) 80% of the time there's no issue, then seemingly randomly the value the controller gets becomes 'images'.