View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - [SOLVED] Admin account blocked, now what....? - ProjeQtOr
 
 

[SOLVED] Admin account blocked, now what....?

More
12 Oct 2017 21:43 #1 by ancm
Admin account blocked, now what....? was created by ancm
Hi,

What to do when the (only) admin account is blocked and you cannot log on? ;)

Any suggestions appreciated.

Regards,

Mike

Please Log in or Create an account to join the conversation.

More
13 Oct 2017 20:24 #2 by babynus
Replied by babynus on topic Admin account blocked, now what....?
Update database, table resource, for line of corresponding user (defaut admin is first one)
Set locked=0
If you loose password
set password='newpassword', crypto=null
Babynus
Administrator of ProjeQtOr web site
The following user(s) said Thank You: ancm

Please Log in or Create an account to join the conversation.

More
15 Jan 2018 09:53 #3 by ancm
Replied by ancm on topic Admin account blocked, now what....?
Hi,

As of 6.52 I receive the message:

ERROR 1054 (42S22): Unknown column 'isLdpa' in 'field list'

Any suggestion?

Regs.

Mike

Please Log in or Create an account to join the conversation.

More
15 Jan 2018 09:53 #4 by ancm
Replied by ancm on topic Admin account blocked, now what....?

ancm wrote: Hi,

As of 6.52 I receive the message:

ERROR 1054 (42S22): Unknown column 'isLdpa' in 'field list'

Any suggestion?

Regs.

Mike


I used:

UPDATE resource SET password='newPassword', crypto=NULL, isLdpa=0 WHERE id=1;

Please Log in or Create an account to join the conversation.

More
15 Jan 2018 13:25 #5 by babynus
Replied by babynus on topic Admin account blocked, now what....?
field is "isLdap", not "isLdpa"
UPDATE resource SET password='newPassword', crypto=NULL, isLdap=0 WHERE id=1;
Babynus
Administrator of ProjeQtOr web site
The following user(s) said Thank You: ancm

Please Log in or Create an account to join the conversation.

Moderators: babynus, protion
Time to create page: 0.047 seconds

Cookies settings

×

Functional Cookies

Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.

Session

Please login to see yours activities!

Other cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.

Login Form