lost admin password - Bugzilla

[Johnson, Christopher L.]

Hi everyone,

We currently have a problem, we inherited a Bugzilla box where do not
have any of the passwords or documentation. Does anyone know how we
reset the Admin password for Bugzilla? We are running version 3.0.2 and
it is on a Linux box.

Thanks in advance

Chris

[Tosh, Michael J]

If you have shell access, look at the localconfig file to get valid
database credentials. Once there, either copy the
profiles.cryptpassword for a known user account to the administrator
account, OR add your account to the admin group:

SELECT @myusr := userid FROM profiles WHERE login_name="PUT YOUR EMAIL
HERE";
SELECT @admin := id FROM groups WHERE name="admin";
INSERT INTO user_group_map (user_id,group_id,isbless,grant_type) VALUES
(@myusr,@admin,0,0);

Then you will have an administrative account.

Hi everyone,

Thanks in advance

Chris

_______________________________________________
support-bugzilla mailing list
support-...@lists.mozilla.org
https://lists.mozilla.org/listinfo/support-bugzilla
PLEASE put support-...@lists.mozilla.org in the To: field when you
reply.

[philip.g...@currenta.de]

Hi!

./checksetup.pl --help
Usage:
./checksetup.pl [--help|--check-modules]
./checksetup.pl [SCRIPT [--verbose]] [--no-templates|-t]
[--make-admin=us...@domain.com]

Options:
SCRIPT
Name of script to drive non-interactive mode. This script should
define an %answer hash whose keys are variable names and the
values
answers to all the questions checksetup.pl asks. For details on
the
format of this script, do "perldoc checksetup.pl" and look for the
"RUNNING CHECKSETUP NON-INTERACTIVELY" section.

--help
Display this help text

--check-modules
Only check for correct module dependencies and quit afterward.

--make-admin=user...@domain.com
Makes the specified user into a Bugzilla administrator. This is in
case you accidentally lock yourself out of the Bugzilla
administrative interface.

--no-templates (-t)
Don't compile the templates at all. Existing compiled templates
will
remain; missing compiled templates will not be created. (Used
primarily by developers to speed up checksetup.) Use this switch
at
your own risk.

--verbose
Output results of SCRIPT being processed.

The important option is --make-admin=user...@domain.com.

Good luck.

Greetings, Philip

Btw... the Bugzilla docs are also available at
http://www.bugzilla.org/docs, what a surprise.

[Max Kanat-Alexander]

On Thu, 21 Feb 2008 09:26:05 -0500 "Tosh, Michael J"
<michael...@lmco.com> wrote:
> If you have shell access, look at the localconfig file to get valid
> database credentials. Once there, either copy the
> profiles.cryptpassword for a known user account to the administrator
> account, OR add your account to the admin group:

The easier way to add your account to the admin group is:

./checksetup.pl --make-admin=us...@domain.com

-Max
--
http://www.everythingsolved.com/
Competent, Friendly Bugzilla and Perl Services. Everything Else, too.

[techguy]

Ok,

I'm an absolute newbie when it comes to bugzilla and for that matter almost
any freeware.

I just inherited a bugzilla setup, everthing is working (for the moment)

No one has a clue about the system besides it works.

1st. I need to grant admin rights to an account so we can administer it.

2nd Is there a maintenance schedule or recommended best practices that I can
beef up on.

I'm sure there will be many more posts to come, but hopefully this will get
me pushed in the right directions.

PS, were do you type the commands from the post below.
<philip.g...@currenta.de> wrote in message
news:mailman.824.1203604057...@lists.mozilla.org...

[Marc Schumann]

Philip,

2008/2/25, techguy <sup...@ciinc.com>:

> 1st. I need to grant admin rights to an account so we can administer it.

you give the answer yourself -- run checksetup.pl with the --make-admin option.

> PS, were do you type the commands from the post below.

At a command line, in Bugzilla's main directory. That's the place the
original installer chose to put Bugzilla at.

Regards
Marc

[alchemis...@gmail.com]

thankyou so very much for this tip sir, saved my arse today!! thankyou thankyou thankyou!!

[an...@buuteeq.com]

It might be new version 4.4 thing, but when I first install bugzilla I forgot my login and password. Because there is millions of login password db names user and all these creepy things I had gone through.

I went to checksetup and --make-admin won't work for, because only available script for me was --help!!!

I went to localconfig and tried to change things there but it gives me only problems since it guys logins and pass for dbase.

Next thing I did is I went to phpMyAdmin and found table profiles and finally found my login for bugzilla. However in password table was encrypted so next 10 minutes I was try unencrypted it. NoTHING !!!

So I went to bugzilla and using RESET PASSWORD tool since I found my login right?

System send me email, but the link was short token.cgi?t=3Btw0rssdadu7C&a=cfmpw

Next thing make sure you put: www.myBugzilla.com/"put you token here"

Profit !!!

[Thorsten Schöning]

Guten Tag an...@buuteeq.com,
am Freitag, 19. Juli 2013 um 01:28 schrieben Sie:

> It might be new version 4.4 thing, but when I first install
> bugzilla I forgot my login and password.

I didn't see any changes to your memory in Bugzilla 4.4. ;-)

> Because there is millions
> of login password db names user and all these creepy things I had gone through.

I don't seem to understand that statement, do you mean brute forcing
login names? That's really not the first thing one should do if he
lost his login name. A look in the profile table would have been a
better start.

> I went to checksetup and --make-admin won't work for, because only
> available script for me was --help!!!

How did you call the script, with which exact command line?
checksetup..pl works the same for most people and make-admin is there.

> I went to localconfig and tried to change things there but it gives
> me only problems since it guys logins and pass for dbase.

Right, login names and passwords for users are only stored in the
database.

> Next thing I did is I went to phpMyAdmin and found table profiles
> and finally found my login for bugzilla. However in password table
> was encrypted so next 10 minutes I was try unencrypted it. NoTHING !!!

Of course it is salted and hashed, that's intentional for security
reasons: If some bad guys gets your profiles table somehow, they can't
use your passwords easily.

> So I went to bugzilla and using RESET PASSWORD tool since I found my login right?

checksetup.pl provides reset-password, too.

> System send me email, but the link was short
> token.cgi?t=3Btw0rssdadu7C&a=cfmpw

Surely because you didn't properly configure things like urlbase,
which. can be set in the file data/params even without logigng into
Bugzilla.

> Next thing make sure you put: www.myBugzilla.com/"put you token here"

This manual step shouldn't be necessary once Bugzilla gets properly
configured.

> Profit !!!

Congratulations! I'm really glad you stopped brute forcing your
password after 10 minutes and didn't wait much longer. ;-) But
seriously, you should have asked on this list in the first place, a
look into the profiles table and reset-password of checksetup.pl would
have saved you a lot of time.

Mit freundlichen Grüßen,

Thorsten Schöning

--
Thorsten Schöning E-Mail:Thorsten....@AM-SoFT.de
AM-SoFT IT-Systeme http://www.AM-SoFT.de/

Telefon...........05151- 9468- 55
Fax...............05151- 9468- 88
Mobil..............0178-8 9468- 04

AM-SoFT GmbH IT-Systeme, Brandenburger Str. 7c, 31789 Hameln
AG Hannover HRB 207 694 - Geschäftsführer: Andreas Muchow

[sreeji...@gmail.com]

how will i know about the admin group
is it inside local.config file?

[Emmanuel Seyman]

* sreeji...@gmail.com [05/09/2014 02:27] :

>
> how will i know about the admin group
> is it inside local.config file?

No, the admin group is created by Bugzilla in the database.

Emmanuel

[sreeji...@gmail.com]

so if i provide this command "
> ./checksetup.pl --make-admin=sreeji...@gmail.com "
in the bugzilla command prompt will this work ?

[Thorsten Schöning]

Guten Tag sreeji...@gmail.com,
am Freitag, 5. September 2014 um 11:55 schrieben Sie:

> so if i provide this command "
>> ./checksetup.pl --make-admin=sreeji...@gmail.com "
> in the bugzilla command prompt will this work ?

That depends on what you expect this command to do. :-) It will make
that user an admin, nothing more, nothing less. But I don't see the
connection to your former question.