scheduler just accepts a DAL connection as a parameter. There's no way that db connection can work for the web process and not the scheduler one.
On Monday, November 21, 2016 at 4:42:55 PM UTC+1, DengFeng Mao wrote: > > I am using web2py Version 2.14.3-stable+timestamp.2016.03.26.23.02.02 with > Mysql > There is '@' in mysql password, Then I set decode_credentials=True in DAL. > The web access and mysql access work well. > Then I tried to add a task scheduler. The db table 'db.scheduler_task' , > 'db.scheduler_run', 'db.scheduler_worker' tables were created automatically > by the database migration. > Question was coming when I tried to start a worker process with the > following command: > ./web2py -K myapp > > The error like this: > --------------------------------- > RuntimeError: Failure to connect, tried 5 times: > OperationalError: (1045, u"Access denied for user .... ... > --------------------------------------------------- > > It confused me. There is no any issue for the web access database. But > scheduler worker process can't connect database. > Why? I had thought both web and scheduler worker use the same DAL > connection > > I tired mysql password without '@' and DAL decode_credentials=False. > scheduler worker process can connect database as expectation. But it > complaint > ------------------------------- > InternalError: (1050, u"Table 'auth_user' already exists") > -------------------------------- > > I know , I should set 'migrate=False' for the table 'auth_user'. But I > wonder why the web access process didn't complain that error? > Only scheduler worker process complaint it > -- 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 [email protected]. For more options, visit https://groups.google.com/d/optout.
