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 11:57:40 GMT
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