[web2py] Re: Is it possible to load older web2py binaries for Mac?

2019-12-19 Thread 'Annet' via web2py-users
Hi Jarrod,

I also have an issue after upgrading to Mac OS X Catalina see this post for 
Massimo's answer:

https://groups.google.com/forum/?fromgroups=#!topic/web2py/431xgrgLkn0


Best,

Annet

-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/f66a0cda-54d2-46d3-801b-8407e2003412%40googlegroups.com.


[web2py] py4web - cannot get logged in

2019-12-19 Thread Jim S
python3 -m pip install --upgrade py4web
py4web-start apps

Entered my password

Went to http://127.0.0.1:8000/_dashboard

I am asked for a password - no matter what I do, I can't get past this page.

At first I was getting this error:

ERROR:root:Traceback (most recent call last):
  File "/home/jim/.local/lib/python3.7/site-packages/py4web/core.py", line 
473, in wrapper
ret = func(*func_args, **func_kwargs)
  File "/home/jim/.local/lib/python3.7/site-packages/py4web/core.py", line 
439, in wrapper
ret = func(*args, **kwargs)
  File "apps/_dashboard/__init__.py", line 56, in login
valid = password and CRYPT()(password)[0] == os.environ[
'PY4WEB_PASSWORD']
  File "/usr/lib/python3.7/os.py", line 679, in __getitem__
raise KeyError(key) from None
KeyError: 'PY4WEB_PASSWORD'

I created the environment variable and stored my plain text password 
there.  Now this error is gone, but still not working.

I can see that password.txt was created in the directory from which I 
initiated the py4web-start command.

I restart py4web and the password still doesn't work.

I deleted password.txt and restarted - was asked for the password and I 
entered it.

Still no luck.  

I've had py4web running successfully in the past.  Just now sure what has 
happened now that is preventing me from logging in.

-Jim


-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/0ccea3e0-1730-48ea-b9c8-efacf260ec7d%40googlegroups.com.


[web2py] Error 400 for Not authorized? Shouldn't we use 401?

2019-12-19 Thread Tito Garrido
Hi Guys,

I am using AuthJWT from
https://github.com/web2py/web2py/blob/master/gluon/tools.py
I could see that an expired token or not authorized token is
returning error 400. Shouldn't we use 401 - Unauthorized?

https://developer.mozilla.org/en-US/docs/Web/HTTP/Status/401

Thanks!

Tito


-- 

Linux User #387870
.
 _/_õ|__|
..º[ .-.___.-._| . . . .
.__( o)__( o).:___

-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/CAL67CHHB%3DxrppU9s%2BKT_UoxRJiWtmxjNyFqnYK5hSS1Pe0p1cg%40mail.gmail.com.


[web2py] mssql set identity_insert on

2019-12-19 Thread Davidiam
As part of our release process, we need to insert records in the auth tables 
using specific id's.  On sqlite this is no problem, but in mssql we get an 
error saying insert_identity is off.
The solution is to set insert_identity in, but I am not sure how to do this 
using the web2py DAL.  Can any give me an code example for this?
We are basically inserting user and group records using ids from a master table.

Thanks, 
David 

-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/bdaa9fde-4d70-4108-b4ff-a877a66f3d72%40googlegroups.com.


[web2py] Re: mssql set identity_insert on

2019-12-19 Thread Dave S


On Thursday, December 19, 2019 at 2:37:29 PM UTC-8, Davidiam wrote:
>
> As part of our release process, we need to insert records in the auth 
> tables using specific id's.  On sqlite this is no problem, but in mssql we 
> get an error saying insert_identity is off.
> The solution is to set insert_identity ON, but I am not sure how to do 
> this using the web2py DAL.  Can any give me an code example for this?
> We are basically inserting user and group records using ids from a master 
> table.
>
> This is the command that I would need to run before doing the inserts :
>
> SET IDENTITY_INSERT dbo.auth_user ON;   
>
> Thanks, 
> David 
>



I can't, because I'm using a different DB, but I remember thinking at the 
time of your earlier post about IDs that ... this is wrong.  I think your 
process should be using *roles*, not *ID*s, and this is what the auth_group 
table is for.  Perhaps if I understood your process, I would agree that 
relying on specific IDs is the right answer, but it is going to take some 
effort to convince me.

/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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/709105be-e47f-487f-a486-5865fe0e37b2%40googlegroups.com.