[web2py] Scheduler on Opalstack

Hello. Did someone tried to use the scheduler on Opalstack? I was used to run this command to start a worker in Webfaction but in Opalstack it don't works: nohup python web2py.py -K applicationname & I've tried in also in the virtualenv no way. Someone knows how I can do it? Thanks. --

[web2py] Re: InFailedSqlTransaction

I've deleted the scheduler.py file and deleted the scheduler tables. Now if I add again the scheduler.py file the scheduler tables are in the admin but not in the DB, and the error is the same for all the scheduler tables, InFailedSqlTransaction. Someone can help me? Il giorno domenica 8

Re: [web2py] Scheduler on Opalstack

it worked for me. Em ter., 10 de nov. de 2020 às 09:25, Gaël Princivalle < gaelprinciva...@gmail.com> escreveu: > > Hello. > > Did someone tried to use the scheduler on Opalstack? > > I was used to run this command to start a worker in Webfaction but in > Opalstack it don't works: > nohup python

[web2py] How to generate SQL string without connecting to any database?

Hi! I was previously (web2py 2.18.5) using postgres:pg8000 adapter and a dummy connection string with the parameter do_connect=False in order to be able to generate SQL query strings without actually connecting to any database. I see that with the latest version (2.20.4) the "do_connect" was

[web2py] Re: InFailedSqlTransaction

Can you go to the databases directory in your app and delete the scheduler tables from there? Then make sure your db connection has migrate=True specified along with fake-migrate=False. I'm thinking that should force a rebuild of the scheduler tables in your database. -Jim On Tuesday,

[web2py] Re: InFailedSqlTransaction

Thank you Jim. I've setted migrate to False and fake-migrate to True. Deleted the scheduler tables in the database folder Setted migrate to True and fake-migrate to False And the tables are not rebuild in the DB. The error still the same. I'll try to delete the scheduler.py file, export the db,

[web2py] Re: InFailedSqlTransaction

Did you go in to the application so that db.py would be executed, thereby triggering the migration to happen? -Jim On Tuesday, November 10, 2020 at 8:33:41 AM UTC-6, Gaël Princivalle wrote: > > Thank you Jim. > > I've setted migrate to False and fake-migrate to True. > Deleted the scheduler

Re: [web2py] On Windows I am trying to delete an application that uses logging but the delete fails because the log file is "in use"

We found that by modifying the gluon\admin.py app_uninstall function, we could search for the open log file handles and close them before the actual delete of the files is performed. import logging import logging.handlers for nm, lgr in logging.root.manager.loggerDict.items():

Re: [web2py] Displaying content based on the id attribute

Oh ok, that makes sense, that could've worked On Monday, November 9, 2020 at 4:37:52 PM UTC+2 roge...@gmail.com wrote: > That was a long thread which I didn't read fully. But what I did read made > me think that maybe the original problem was that you needed a slight delay > between when you

[web2py] Re: Error: Connection lost during download

How do I fix this? Any suggestion would be appreciated. On Tuesday, November 10, 2020 at 11:47:53 AM UTC-6 Clemens wrote: > If I had to guess, I'd say, that your web server is running in a timeout > while downloading such a large file. > > Best regards > Clemens > > On Tuesday, November 10,

[web2py] Re: Error: Connection lost during download

That depends on your software stack. Where is this hosted? What web server? Are you using uwsgi? I have experience with nginx and uwsgi but not much else. -Jim On Tuesday, November 10, 2020 at 3:10:28 PM UTC-6, SR wrote: > > How do I fix this? Any suggestion would be appreciated. > > On

[web2py] Error: Connection lost during download

Hi I store my uploaded file in the web2py "static" folder. One of the download link for linux binaries fails. It downloads 1GB, then fails. This is the link: https://cryoem.bcm.edu/cryoem/static/software/continuous_build/eman2_sphire_sparx_huge.linux.unstable.sh . Is this problem due to the

[web2py] Re: InFailedSqlTransaction

> Did you go in to the application so that db.py would be executed, thereby triggering the migration to happen? Yes, after each modification of the DB connection string I reload a website page. I've resolved this problem moving the scheduler tables in another DB. Thanks for your help. Il

[web2py] Re: InFailedSqlTransaction

I was guessing that you were missing a field in your scheduled_task table. I don't know when it happened, but at some point an additional field was added to the table. I'm confused as to why your migrate didn't work though to rebuild everything. Well, glad you have it all working now. -Jim

[web2py] Re: Error: Connection lost during download

If I had to guess, I'd say, that your web server is running in a timeout while downloading such a large file. Best regards Clemens On Tuesday, November 10, 2020 at 6:41:35 PM UTC+1 SR wrote: > Hi > I store my uploaded file in the web2py "static" folder. > One of the download link for linux

[web2py] Re: Error: Connection lost during download

Same as Jim: I have experience with nginx and uwsgi. And googling " set timeout" should give you the answer, e.g.: https://ubiq.co/tech-blog/increase-request-timeout-nginx/ https://httpd.apache.org/docs/2.4/mod/core.html#keepalivetimeout If it's not a timeout problem (but I'm sure it is), I

Re: [web2py] On Windows I am trying to delete an application that uses logging but the delete fails because the log file is "in use"

Good tip. Thanks. Seems like something that should end up in the public version. ___ *www.TenOutOfTen.org* rogers...@gmail.com (+95) 09 250018669 (Myanmar) On Tue, 10 Nov 2020 at 23:09, Davidiam wrote: > We found that by modifying the