continuum-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Wayne Fay" <wayne...@gmail.com>
Subject Re: admin account locked
Date Tue, 24 Jul 2007 14:35:49 GMT
Reinstall using another database instance. Export both and compare
tables with diff or a similar tool. Eventually you'll find it.

When you do, please post back to the list for the benefit of others.

Wayne

On 7/24/07, B. De Mezzo <benoit.demezzo@paycool.net> wrote:
> UP !
>
> No more ideas ?
>
> B. De Mezzo a écrit :
> > yes I looked at your link, but it is explained for an older db schema
> > and it is not usable with the current db shema. The current db seems
> > to be quite different than the old one. And I can't find how to set
> > permission with the current db schema. ....
> >
> > Anoop kumar V a écrit :
> >> Did you check the link I sent - I think what you want is done in the
> >> steps
> >> mentioned in the link. A normal user is converted into an admin user.
> >>
> >> Anoop
> >>
> >> On 7/23/07, B. De Mezzo <benoit.demezzo@paycool.net> wrote:
> >>>
> >>> No :) I don't try to create a new line in the db to get another user. I
> >>> used the web page ! But I can set (within the derby db) the admin
> >>> permission for this new user as the db schema evolves and I can't found
> >>> the right table to update the user permission.
> >>>
> >>> Is there someone who know how to set this permission within the db ?
> >>>
> >>> Thx !
> >>>
> >>> Anoop kumar V a écrit :
> >>> > You say that you are trying to create a new user.. directly in the
> >>> derby
> >>> > db?? Do you mean you do not have any other continuum user at all
> >>> whose
> >>> > password you are aware of?
> >>> >
> >>> > On 7/20/07, B. De Mezzo <benoit.demezzo@paycool.net> wrote:
> >>> >>
> >>> >> :( I try normal kill, killer-kill (-9) then start but still
> >>> locked. I
> >>> >> try to register a new user and then use the derby db to modify
the
> >>> >> permission/role for this new user but I was unable to find the
table
> >>> who
> >>> >> make the link between user and permission/role ...
> >>> >>
> >>> >> Here the table list I get :
> >>> >> ij> show tables;
> >>> >> TABLE_SCHEM         |TABLE_NAME                    |REMARKS
> >>> >>
> >>> ------------------------------------------------------------------------
> >>>
> >>> >> SYS                 |SYSALIASES                    |
> >>> >> SYS                 |SYSCHECKS                     |
> >>> >> SYS                 |SYSCOLUMNS                    |
> >>> >> SYS                 |SYSCONGLOMERATES              |
> >>> >> SYS                 |SYSCONSTRAINTS                |
> >>> >> SYS                 |SYSDEPENDS                    |
> >>> >> SYS                 |SYSFILES                      |
> >>> >> SYS                 |SYSFOREIGNKEYS                |
> >>> >> SYS                 |SYSKEYS                       |
> >>> >> SYS                 |SYSSCHEMAS                    |
> >>> >> SYS                 |SYSSTATEMENTS                 |
> >>> >> SYS                 |SYSSTATISTICS                 |
> >>> >> SYS                 |SYSTABLES                     |
> >>> >> SYS                 |SYSTRIGGERS                   |
> >>> >> SYS                 |SYSVIEWS                      |
> >>> >> SYSIBM              |SYSDUMMY1                     |
> >>> >> SA                  |JDOAUTHENTICATIONKEY          |
> >>> >> SA                  |JDOUSER                       |
> >>> >> SA                  |JDOUSER_PREVIOUSENCODEDPASSWO&|
> >>> >> SA                  |SECURITY_OPERATIONS           |
> >>> >> SA                  |SECURITY_PERMISSIONS          |
> >>> >> SA                  |SECURITY_RESOURCES            |
> >>> >> SA                  |SECURITY_ROLES                |
> >>> >> SA                  |SECURITY_ROLE_CHILDROLE_MAP   |
> >>> >> SA                  |SECURITY_ROLE_PERMISSION_MAP  |
> >>> >> SA                  |SECURITY_USERASSIGNMENT_ROLEN&|
> >>> >> SA                  |SECURITY_USER_ASSIGNMENTS     |
> >>> >>
> >>> >> which is the good one ?
> >>> >>
> >>> >> I STILL need help !!!  :) but I thank you for your previous
> >>> comments.
> >>> >>
> >>> >> regards.
> >>> >>
> >>> >>
> >>> >> Anoop kumar V a écrit :
> >>> >> > To restart why not just do a cold start. Use kill to stop
> >>> (assuming
> >>> >> > you are
> >>> >> > on [Li][U]nix) and start continuum.
> >>> >> >
> >>> >> >
> >>> >> > On 7/20/07, B. De Mezzo <benoit.demezzo@paycool.net>
wrote:
> >>> >> >>
> >>> >> >> I try the continuum-restart method (does not work) and
try to
> >>> access
> >>> >> the
> >>> >> >> user database and change the 'locked' attribut of sa.JDOUSER
but
> >>> >> it is
> >>> >> >> already set to 'N' ...
> >>> >> >> but admin account stills locked :'(
> >>> >> >>
> >>> >> >> perhaps by removing the 'admin' entry in the db ?
> >>> >> >>
> >>> >> >> Jesse McConnell a écrit :
> >>> >> >> > should be able to just restart the instance it it
will
> >>> unlock all
> >>> >> >> > admin accounts
> >>> >> >> >
> >>> >> >> > On 7/20/07, Anoop kumar V <anoopkumarv@gmail.com>
wrote:
> >>> >> >> >> If you have not yet found it.. here it is: (one
of the ways)
> >>> >> >> >>
> >>> >> >> >>
> >>> >> >>
> >>> >>
> >>>
> http://www.nabble.com/Change-a-user-role-to-build-admin-tf3136881.html#a8692812
> >>>
> >>> >>
> >>> >> >>
> >>> >> >> >>
> >>> >> >> >>
> >>> >> >> >> Anoop
> >>> >> >> >>
> >>> >> >> >> On 7/19/07, Wayne Fay <waynefay@gmail.com>
wrote:
> >>> >> >> >> >
> >>> >> >> >> > This has been asked (and answered) several
times on this
> >>> list.
> >>> >> >> Search
> >>> >> >> >> > the list archives at Nabble.com -- you're
bound to find a
> >>> few
> >>> >> hits.
> >>> >> >> >> > And I'd assume its probably documented in
the Continuum
> >>> wiki as
> >>> >> >> well.
> >>> >> >> >> >
> >>> >> >> >> > Wayne
> >>> >> >> >> >
> >>> >> >> >> > On 7/19/07, BDM <bdm@paycool.net>
wrote:
> >>> >> >> >> > > hello,
> >>> >> >> >> > > I locked my admin account by typing
to many times the
> >>> wrong
> >>> >> >> >> password (I
> >>> >> >> >> > > have checked later that it was the
good one ... strange)
> >>> >> !!! But
> >>> >> >> now
> >>> >> >> >> > > how can I unlock this main account
????
> >>> >> >> >> > >
> >>> >> >> >> > >
> >>> >> >> >> > > Thx !!
> >>> >> >> >> > >
> >>> >> >> >> >
> >>> >> >> >>
> >>> >> >> >
> >>> >> >> >
> >>> >> >>
> >>> >> >>
> >>> >> >
> >>> >>
> >>> >>
> >>> >
> >>>
> >>>
> >>
> >
> >
> >
>
>

Mime
View raw message