Ok, I think I had problem with model definition : 'db.auth...' : foreign
key were quoted... I have this issue since a long time, If I was removing
quote I didn't have proper representation...
Fixed now...
But now it seems that I have problem with the use of id in case were I have
define a custom id. Ex:
db.define_table('table1_tab1',
Field('tab1_id','id'),
...
In the pass I was able to call id or tab1_id :
1.99.4
In [1]: db.table1_tab1(1).id
Out[1]: 1
In [2]: db.table1_tab1(1).tab1_id
Out[2]: 1
1.99.7
In [1]: db.table1_tab1(1).id
KeyError: 'id'
In [2]: db.table1_tab1(1).tab1_id
Out[2]: 1
Is it something not anymore possible or this bug have been introduce
recently?
Richard
On Tue, May 15, 2012 at 10:52 AM, Richard Vézina <
[email protected]> wrote:
> Wait...
>
>
> On Tue, May 15, 2012 at 10:37 AM, Richard Vézina <
> [email protected]> wrote:
>
>> Ok if I copy my custom auth models into a new app it keeps loading the
>> page for ever and don't create the table at postgres level.
>>
>> Richard
>>
>>
>> On Tue, May 15, 2012 at 10:19 AM, Richard Vézina <
>> [email protected]> wrote:
>>
>>> Yes I try a new app without defining auth models myself, just changed
>>> the connection string for postgres and it works.
>>>
>>> I don't have the typo in my code, it maybe happen when copy/paste the
>>> code somehow.
>>>
>>> I just add this : auth=Auth(db, *hmac_key=Auth.get_or_create_key()*)
>>>
>>> No change.
>>>
>>> Richard
>>>
>>>
>>> On Tue, May 15, 2012 at 10:04 AM, Massimo Di Pierro <
>>> [email protected]> wrote:
>>>
>>>> There is a typo in your code:
>>>>
>>>> uth.settings.hmac_key='sha512:**8e95c268-cc31-4119-890d-**a5790d3e05d3'
>>>>
>>>> should be
>>>>
>>>> auth.settings.hmac_key='sha512:**8e95c268-cc31-4119-890d-**
>>>> a5790d3e05d3'
>>>>
>>>> although this is probably not the cause for your problems. Does it work
>>>> if you use sqlite? Does it work if you use postgresql with a new database?
>>>>
>>>> On Monday, 14 May 2012 15:53:40 UTC-5, Richard wrote:
>>>>>
>>>>> Hello,
>>>>>
>>>>> I try one more time to upgrade to 1.99.7 today without succes. But now
>>>>> I know what append... It works fine, until I try to logon with a user...
>>>>>
>>>>> In shell it works fine, can access to any tables...
>>>>>
>>>>> Is there change to the logon process has been changed between 1.99.4
>>>>> and 1.99.7?
>>>>>
>>>>> Thanks
>>>>>
>>>>> Richard
>>>>>
>>>>> On Thu, Mar 8, 2012 at 12:54 PM, Richard Vézina <
>>>>> [email protected]> wrote:
>>>>>
>>>>>> Ping!
>>>>>>
>>>>>> Richard
>>>>>>
>>>>>>
>>>>>> On Wed, Mar 7, 2012 at 10:48 AM, Richard Vézina <
>>>>>> [email protected]> wrote:
>>>>>>
>>>>>>> I use to download source package and make my update by my own
>>>>>>> (manually). I don't use the update feature.
>>>>>>>
>>>>>>> Here most of my db.py that contain db connection and all related
>>>>>>> auth configuration :
>>>>>>>
>>>>>>> db=DAL('postgres://USER:**[email protected]:5432/**DATABASE<http://USER:[email protected]:5432/DATABASE>',
>>>>>>> \
>>>>>>> migrate_enabled=False)
>>>>>>>
>>>>>>>
>>>>>>> from gluon.tools import *
>>>>>>> auth=Auth(globals(),db) # authentication/authorization
>>>>>>>
>>>>>>> auth_table = db.define_table(
>>>>>>> auth.settings.table_user_name,
>>>>>>> Field('first_name', length=128, default=None,
>>>>>>> required=True,
>>>>>>> notnull=True,
>>>>>>> requires = IS_NOT_EMPTY(error_message=T(**
>>>>>>> auth.messages.is_empty)),
>>>>>>> ),
>>>>>>> Field('last_name', length=128, default=None,
>>>>>>> requires = IS_NOT_EMPTY(error_message=T(**
>>>>>>> auth.messages.is_empty)),
>>>>>>> ),
>>>>>>> Field('email', length=128, default=None, unique=True,
>>>>>>> label=T('Email'),
>>>>>>> requires = [IS_EMAIL(error_message=T(**
>>>>>>> auth.messages.invalid_email)),
>>>>>>> IS_NOT_IN_DB(db, 'auth_user.email')],
>>>>>>> ),
>>>>>>> Field('password', 'password', length=256,
>>>>>>> readable=False, label=T('Password'),
>>>>>>> required=True,
>>>>>>> notnull=True,
>>>>>>> requires = CRYPT(min_length=auth.**
>>>>>>> settings.password_min_length,
>>>>>>> error_message=T('too short'))
>>>>>>> ),
>>>>>>> Field('registration_key', length=128, default=None,
>>>>>>> writable=False, readable=False),
>>>>>>> Field('reset_password_key', length=512,
>>>>>>> writable=False, readable=False, default=None
>>>>>>> ),
>>>>>>> Field('initials','string',**length=5),
>>>>>>> migrate=False,
>>>>>>> format='%(first_name)s %(last_name)s (%(id)s)')
>>>>>>>
>>>>>>> auth.settings.table_user = auth_table # no idea what this line do...
>>>>>>>
>>>>>>> auth_table = db.define_table(
>>>>>>> auth.settings.table_event_**name,
>>>>>>> Field('time_stamp','datetime',**default=request.now),
>>>>>>> Field('client_ip','string',**length=512,default=request.**
>>>>>>> client),
>>>>>>> Field('user_id',db.auth_user),
>>>>>>> Field('origin','string',**length=512),
>>>>>>> Field('description','text'),
>>>>>>> migrate=False,)
>>>>>>>
>>>>>>> auth_table = db.define_table(
>>>>>>> auth.settings.table_group_**name,
>>>>>>> Field('role','string',length=**512),
>>>>>>> Field('description','text'),
>>>>>>> migrate=False,
>>>>>>> format='%(role)s (%(id)s)')
>>>>>>>
>>>>>>> auth_table = db.define_table(
>>>>>>> auth.settings.table_**membership_name,
>>>>>>> Field('user_id','db.auth_user'**),
>>>>>>> Field('group_id','db.auth_**group'),
>>>>>>> migrate=False,)
>>>>>>>
>>>>>>> db.auth_membership.user_id.**requires=IS_IN_DB(db,'auth_**user.id<http://auth_user.id>','%(first_name)s
>>>>>>> %(last_name)s (%(id)s)')
>>>>>>> db.auth_membership.group_id.**requires=IS_IN_DB(db,'auth_**group.id<http://auth_group.id>
>>>>>>> ','%(role)s-%(**description)s (%(id)s)')
>>>>>>>
>>>>>>> db.auth_membership.user_id.**represent=\
>>>>>>> lambda value: (value!=None and "%(first_name)s %(last_name)s
>>>>>>> (%(id)s)" %db.auth_user[value]) or 'None'
>>>>>>> db.auth_membership.group_id.**represent=\
>>>>>>> lambda value: (value!=None and "%(role)s (%(id)s)"
>>>>>>> %db.auth_group[value]) or 'None'
>>>>>>>
>>>>>>> db.define_table('auth_group_**allowed',
>>>>>>> Field('id','id'),
>>>>>>> Field('user_id','db.auth_user'**),
>>>>>>> Field('group_id','db.auth_**group'),
>>>>>>> Field('active_gr','boolean'),
>>>>>>> migrate=False,
>>>>>>> sequence_name='auth_group_**allowed_id_seq')
>>>>>>>
>>>>>>> db.auth_group_allowed.user_id.**requires=IS_IN_DB(db,'auth_**user.id<http://auth_user.id>','%(first_name)s
>>>>>>> %(last_name)s (%(id)s)')
>>>>>>> db.auth_group_allowed.group_**id.requires=IS_IN_DB(db,'auth_**
>>>>>>> group.id <http://auth_group.id>','%(role)s (%(id)s)')
>>>>>>>
>>>>>>> db.auth_group_allowed.user_id.**represent=\
>>>>>>> lambda value: (value!=None and "%(first_name)s %(last_name)s
>>>>>>> (%(id)s)" %db.auth_user[value]) or 'None'
>>>>>>> db.auth_group_allowed.group_**id.represent=\
>>>>>>> lambda value: (value!=None and "%(role)s (%(id)s)"
>>>>>>> %db.auth_group[value]) or 'None'
>>>>>>>
>>>>>>> auth_table = db.define_table(
>>>>>>> auth.settings.table_**permission_name,
>>>>>>> Field('group_id','db.auth_**group'),
>>>>>>> Field('name','string',length=**512),
>>>>>>> Field('table_name','string',**length=512),
>>>>>>> Field('record_id','integer'),
>>>>>>> migrate=False,)
>>>>>>>
>>>>>>> db.auth_permission.group_id.**requires=\
>>>>>>> IS_IN_DB(db,'auth_group.id','%**(role)s (%(id)s)')
>>>>>>>
>>>>>>> db.auth_permission.group_id.**represent=\
>>>>>>> lambda id: "%(role)s (%(id)s)" %db.auth_group[id]
>>>>>>>
>>>>>>> auth_table = db.define_table(
>>>>>>> auth.settings.table_cas_name,
>>>>>>> Field('user_id','integer'),
>>>>>>> Field('created_on','datetime')**,
>>>>>>> Field('url','string',length=**512),
>>>>>>> Field('uuid','string',length=**512),
>>>>>>> migrate=False,)
>>>>>>>
>>>>>>> crud=Crud(globals(),db) # for CRUD helpers using auth
>>>>>>> service=Service(globals()) # for json, xml, jsonrpc,
>>>>>>> xmlrpc, amfrpc
>>>>>>>
>>>>>>> crud.settings.auth=auth
>>>>>>>
>>>>>>> uth.settings.hmac_key='sha512:**8e95c268-cc31-4119-890d-**
>>>>>>> a5790d3e05d3'
>>>>>>> auth.define_tables() # creates all needed tables
>>>>>>> auth.settings.actions_**disabled.append('profile') # prohibit users
>>>>>>> to modify their profile
>>>>>>> auth.settings.actions_**disabled.append('register')
>>>>>>>
>>>>>>> Thanks
>>>>>>>
>>>>>>> Richard
>>>>>>>
>>>>>>>
>>>>>>> On Wed, Mar 7, 2012 at 10:24 AM, pbreit <[email protected]>wrote:
>>>>>>>
>>>>>>>> Are you able to upgrade to most recent version of Web2py? We might
>>>>>>>> need to see more of your model code that specifies the DB and auth.
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>
>>>>>
>>>
>>
>
