I suspect we have a major problem here: "role" is a keyword in postgresql and I did not know about it. To check if this is the problem:
1) remove the database 2) remove everything in databases/* 3) create the database again 4) go to appadmin and tell me which tables you see Once we have identified the problem, we'll find a solution. Massimo On Jul 16, 9:49 pm, FERNANDO VILLARROEL <[email protected]> wrote: > Hello, > > I am using a database Postgres. > > > Can you show the entire traceback? > > Traceback (most recent call last): > File "/home/fvillarroel/web2py/gluon/restricted.py", line 107, in restricted > exec ccode in environment > File > "/home/fvillarroel/web2py/applications/clientes/controllers/default.py", line > 53, in <module> > File "/home/fvillarroel/web2py/gluon/globals.py", line 80, in <lambda> > self._caller = lambda f: f() > File > "/home/fvillarroel/web2py/applications/clientes/controllers/default.py", line > 32, in user > return dict(form=auth()) > File "/home/fvillarroel/web2py/gluon/tools.py", line 436, in __call__ > return self.register() > File "/home/fvillarroel/web2py/gluon/tools.py", line 745, in register > group_id = self.add_group("user_%s" % form.vars.id, description) > File "/home/fvillarroel/web2py/gluon/tools.py", line 1211, in add_group > description=description) > File "/home/fvillarroel/web2py/gluon/sql.py", line 1377, in insert > self._db._execute(query) > File "/home/fvillarroel/web2py/gluon/sql.py", line 726, in <lambda> > self._execute = lambda *a, **b: self._cursor.execute(*a, **b) > ProgrammingError: no existe la relación «auth_group» > > > Do you get error even if > > auth.settings.create_user_groups=True? > > yes > > > If you use appadmin, do you see the auth_group? > > No > appadmin is the front end for administrator? > > > > > On Jul 16, 4:29 pm, FERNANDO VILLARROEL <[email protected]> > > wrote: > > > Dear all. > > > > I am trying to use authentication: > > > >http://www.web2py.com/examples/default/tools > > > > I have the following code on my db.py: > > > > from gluon.tools import * > > > auth=Auth(globals(),db) # > > authentication/authorization > > > > # define custom tables (table_user_name is > > 'auth_user') > > > auth.settings.table_user = > > db.define_table(auth.settings.table_user_name, > > > db.Field('first_name', length=128,default=''), > > > db.Field('last_name', length=128,default=''), > > > db.Field('email', length=128,default='', > > requires = [IS_EMAIL(), > > IS_NOT_IN_DB(db,'%s.email'%auth.settings.table_user_name)]), > > > db.Field('password', 'password', readable=False, > > label='Password', requires=CRYPT()), > > > db.Field('registration_key', length=128, > > writable=False, readable=False,default=''),migrate=False) > > > > auth.define_tables() # creates > > all needed tables > > > auth.settings.create_user_groups=False > > > > But the application return the next exception: > > > > self._db._execute(query) > > > File "/home/fvillarroel/web2py/gluon/sql.py", line > > 726, in <lambda> > > > self._execute = lambda *a, **b: > > self._cursor.execute(*a, **b) > > > ProgrammingError: no existe la relación > > «auth_group» > > > > What is the struct of the table auth_group? > > > > what i am doing wrong? > > > > Any idea or how i can solved the problem. > > > > Fernando --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
