continuum-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "B. De Mezzo" <benoit.deme...@paycool.net>
Subject Re: admin account locked
Date Tue, 24 Jul 2007 15:28:13 GMT
Sorry I do a bad manipulation ... and I remove the continuum tree ... So 
I have now to reinstall all project ... :(

Thx for all your advices !

BDM.

Wayne Fay a écrit :
> 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