Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I set up Bugzilla server on my system and accidentally lost login for it. I have done a research on it but nothing has worked so far. Things that I tried to do are:

I tried adding more administrative users using the MySQL interface. Ran "mysql" from the command line, and use the following commands:

mysql> use bugs;<br />
mysql>  update profiles set groupset=0x7ffffffffffffff where login_name = "admin";<br />

I get an error message saying:

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

I also found my e-mail that I used for admin for registration but I cannot recover my password:

mysql> select login_name from profiles where userid=1; 
| login_name        |
| |
1 row in set (0.00 sec)

Anytime I tried to delete a super user I got this:

mysql> delete from  profiles where userid=1; 
ERROR 1451 (23000): Cannot delete or update a parent row: a foreign key constraint fails (`bugzilla`.`components`, CONSTRAINT `fk_components_initialowner_profiles_userid` FOREIGN KEY (`initialowner`) REFERENCES `profiles` (`userid`) ON UPDATE CASCADE)
mysql> update profiles set groupset=0x7ffffffffffffff where login_name = "(user's login name)";

I changed my password using


Tried to log in to localhost Bugzilla user id: password: (my password)

I get the following internal error:

Bugzilla has suffered an internal error. Please save this page and send it to with details of what you were doing at the time this message appeared.

There was an error sending mail from 'bugzilla-daemon' to '': Couldn't find 'sendmail' executable in your PATH and $Email::Send::Sendmail::SENDMAIL is not set

 at Bugzilla/ line 190
    Bugzilla::Mailer::MessageToMTA(...) called at Bugzilla/ line 307
    Bugzilla::Token::Cancel(...) called at Bugzilla/ line 323
    Bugzilla::Token::DeletePasswordTokens(...) called at Bugzilla/Auth/Verify/ line 85
    Bugzilla::Auth::Verify::DB::check_credentials(...) called at Bugzilla/Auth/Verify/ line 62
    Bugzilla::Auth::Verify::Stack::check_credentials(...) called at Bugzilla/ line 72
    Bugzilla::Auth::login(...) called at line 345
    Bugzilla::login(...) called at /var/www/bugzilla/index.cgi line 40

Is there way to change username?

Nothing is working so far. How can I login into Bugzilla? Thank you

share|improve this question
up vote 0 down vote accepted

is the correct solution to your problem of not being able to log in because you lost the password.

But then, you have hit a different problem. Your email config is not set up correctly. (Bugzilla shouldn't throw an error in this case; you might want to file a bug on that.)

To work around it temporarily, edit the file


and set 'mail_delivery_method' to 'Test'. That should prevent it looking for sendmail.


share|improve this answer
The problem was with the email. Thanks – Vladimir Oct 30 '12 at 21:14

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.