Now it's works.
Thank you Massimo.
--- On Fri, 7/17/09, mdipierro <mdipie...@cs.depaul.edu> wrote:
> From: mdipierro <mdipie...@cs.depaul.edu>
> Subject: [web2py:26722] Re: Authentication
> To: "web2py Web Framework" <web2py@googlegroups.com>
> Date: Friday, July 17, 2009, 1:21 AM
>
> OK. I think there is no problem then. Somebow the database
> was
> corrupted. Now everything should work. Let me know if not.
>
> Massimo
>
> On Jul 16, 11:13 pm, FERNANDO VILLARROEL <fvillarr...@yahoo.com>
> wrote:
> > > 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
> >
> > Done
> >
> > i see the following tables:
> >
> > db.tarifa
> > db.clientes
> > db.accountcode
> > db.pagos
> > db.proveedor
> > db.rutaproveedor
> > db.webuser
> > db.auth_user
> > db.auth_group
> > db.auth_membership
> > db.auth_permission
> > db.auth_event
> >
> > > Once we have identified the problem, we'll find
> a
> > > solution.
> >
> > > Massimo
> >
> > > On Jul 16, 9:49 pm, FERNANDO VILLARROEL <fvillarr...@yahoo.com>
> > > 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 <fvillarr...@yahoo.com>
> > > > > 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 web2py@googlegroups.com
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
