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 Mon, 23 Jul 2007 14:55:23 GMT
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