[web2py] Re: problem adding members to group
I think most of what I need is in ch. 3 about the DAL, but using this, I
don't think there are any records with manager in them, so I am puzzled
why I am locked out.
python web2py.py -a 'your password' -i 127.0.0.1 -p 8000 gets in without
gui
myrecord = db(db.auth_group.id==0).select().first()
print myrecord
None
myrecord = db(db.auth_group.id==0).select().first()
print myrecord
None
myrecord = db(db.auth_membership.id==0).select().first()
print myrecord
None
In any case, I had a backup of my app, so I can try again to add the
manager group to a restored copy.
On Tuesday, September 11, 2012 3:53:56 PM UTC-5, greaneym wrote:
Got farther but still stuck. I got locked out of the database and am
trying to get back in with admin.
cd to directory that contains web2py.py
python web2py.py -S appname
db = DAL('sqlite://storage.sqlite', auto_import=True)
print db.tables
['auth_cas', 'auth_event', 'auth_group', 'auth_membership',
'auth_permission', 'auth_user', 'plugin_google_checkout_message',
'plugin_google_checkout_order', 'plugin_google_checkout_purchase',
'product', 'sale']
if you leave out auto_import=True you will see [] as the result of
print db.tables.
print db.auth_cas.fields
['id', 'user_id', 'created_on', 'service', 'ticket', 'renew']
print db.auth_membership.fields
['id', 'user_id', 'group_id']]
I need help with the finding the rest.
rows = db(db.auth_membership.group_id).select()
print rows
auth_membership.id,auth_membership.user_id,auth_membership.group_id
= db(db.auth_group).select()
print rows
auth_group.id,auth_group.role,auth_group.description
rows = db(db.auth_group.role).select()
print rows
auth_group.id,auth_group.role,auth_group.description
How do I find out where the manager group is, and can/should I add
admin
to it, and how is this done?
thanks for any assistance.
On Tuesday, September 11, 2012 10:32:47 AM UTC-5, Massimo Di Pierro wrote:
I do not understand this line:
python web2py.py -S app -M -N -R applications/myapp -A
-R should specify a script, not an app
-A should be followed by command line arguments for the script but you do
not have any
This is probably not the cause of your problem anyway.
On Tuesday, 11 September 2012 09:48:48 UTC-5, greaneym wrote:
Dear all,
I'm testing the pos plugin and have it mostly set up, but I'm stuck. I
had commented all the auth statements and have now uncommented them, and
was adding the group called manager and before I could add members was
interrupted. My session ended, and after that I could not use the admin
interface to access the database from appadmin. So I'm now trying to add
members through the shell, but
I'm getting an error:
python web2py.py -S app -M -N -R applications/myapp -A
Traceback (most recent call last):
File web2py.py, line 16, in module
import gluon.widget
ImportError: No module named gluon.widget
I upgraded from version 1.99 to 2.06 and just added the web2py.app.
Do I need something else? Or how can I modify the shell command please?
thanks,
Margaret
--
[web2py] Re: problem adding members to group
I see on the groups that I might need to run from the source dist instead of web2py.app since I am on a mac, so I'll try that first. On Tuesday, September 11, 2012 9:48:48 AM UTC-5, greaneym wrote: Dear all, I'm testing the pos plugin and have it mostly set up, but I'm stuck. I had commented all the auth statements and have now uncommented them, and was adding the group called manager and before I could add members was interrupted. My session ended, and after that I could not use the admin interface to access the database from appadmin. So I'm now trying to add members through the shell, but I'm getting an error: python web2py.py -S app -M -N -R applications/myapp -A Traceback (most recent call last): File web2py.py, line 16, in module import gluon.widget ImportError: No module named gluon.widget I upgraded from version 1.99 to 2.06 and just added the web2py.app. Do I need something else? Or how can I modify the shell command please? thanks, Margaret --
[web2py] Re: problem adding members to group
I do not understand this line: python web2py.py -S app -M -N -R applications/myapp -A -R should specify a script, not an app -A should be followed by command line arguments for the script but you do not have any This is probably not the cause of your problem anyway. On Tuesday, 11 September 2012 09:48:48 UTC-5, greaneym wrote: Dear all, I'm testing the pos plugin and have it mostly set up, but I'm stuck. I had commented all the auth statements and have now uncommented them, and was adding the group called manager and before I could add members was interrupted. My session ended, and after that I could not use the admin interface to access the database from appadmin. So I'm now trying to add members through the shell, but I'm getting an error: python web2py.py -S app -M -N -R applications/myapp -A Traceback (most recent call last): File web2py.py, line 16, in module import gluon.widget ImportError: No module named gluon.widget I upgraded from version 1.99 to 2.06 and just added the web2py.app. Do I need something else? Or how can I modify the shell command please? thanks, Margaret --
[web2py] Re: problem adding members to group
Got farther but still stuck. I got locked out of the database and am trying
to get back in with admin.
cd to directory that contains web2py.py
python web2py.py -S appname
db = DAL('sqlite://storage.sqlite', auto_import=True)
print db.tables
['auth_cas', 'auth_event', 'auth_group', 'auth_membership',
'auth_permission', 'auth_user', 'plugin_google_checkout_message',
'plugin_google_checkout_order', 'plugin_google_checkout_purchase',
'product', 'sale']
if you leave out auto_import=True you will see [] as the result of
print db.tables.
print db.auth_cas.fields
['id', 'user_id', 'created_on', 'service', 'ticket', 'renew']
print db.auth_membership.fields
['id', 'user_id', 'group_id']]
I need help with the finding the rest.
rows = db(db.auth_membership.group_id).select()
print rows
auth_membership.id,auth_membership.user_id,auth_membership.group_id
= db(db.auth_group).select()
print rows
auth_group.id,auth_group.role,auth_group.description
rows = db(db.auth_group.role).select()
print rows
auth_group.id,auth_group.role,auth_group.description
How do I find out where the manager group is, and can/should I add admin
to it, and how is this done?
thanks for any assistance.
On Tuesday, September 11, 2012 10:32:47 AM UTC-5, Massimo Di Pierro wrote:
I do not understand this line:
python web2py.py -S app -M -N -R applications/myapp -A
-R should specify a script, not an app
-A should be followed by command line arguments for the script but you do
not have any
This is probably not the cause of your problem anyway.
On Tuesday, 11 September 2012 09:48:48 UTC-5, greaneym wrote:
Dear all,
I'm testing the pos plugin and have it mostly set up, but I'm stuck. I
had commented all the auth statements and have now uncommented them, and
was adding the group called manager and before I could add members was
interrupted. My session ended, and after that I could not use the admin
interface to access the database from appadmin. So I'm now trying to add
members through the shell, but
I'm getting an error:
python web2py.py -S app -M -N -R applications/myapp -A
Traceback (most recent call last):
File web2py.py, line 16, in module
import gluon.widget
ImportError: No module named gluon.widget
I upgraded from version 1.99 to 2.06 and just added the web2py.app.
Do I need something else? Or how can I modify the shell command please?
thanks,
Margaret
--
