Gmail Calendar Documents Reader Web more »
Recently Visited Groups | Help | Sign in
Google Groups Home
installation error while creating bugs database
There are currently too many topics in this group that display first. To make this topic appear first, remove this option from another topic.
There was an error processing your request. Please try again.
flag
  7 messages - Collapse all  -  Translate all to Translated (View all originals)
The group you are posting to is a Usenet group. Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
 
From:
To:
Cc:
Followup To:
Add Cc | Add Followup-to | Edit Subject
Subject:
Validation:
For verification purposes please type the characters you see in the picture below or the numbers you hear by clicking the accessibility icon. Listen and type the numbers you hear
 
ipr...@gmail.com  
View profile  
 More options Nov 30 2005, 6:55 am
Newsgroups: netscape.public.mozilla.webtools
From: ipr...@gmail.com
Date: 29 Nov 2005 11:55:54 -0800
Local: Wed, Nov 30 2005 6:55 am
Subject: installation error while creating bugs database
hi,
  i am installing bugzilla on a linux box and i get an error while it
tries to create the bugs database.

  OS: linux
  Distro: debian sarge (stable)
  bugzilla version: 2.20

  i am following the steps in the install document and completed
installing all the required PERL modules. i also filled the right
values in localconfig for the mysql database and from the output (and
the fact that the bugs database is created) it is clear that bugzilla
was able to log onto mysql. i see only one table called "bz_schema" in
the bugs database.
  here is the full output from checksetup.pl

-----------------------
/usr/local/bugzilla-2.20# ./checksetup.pl

Checking perl modules ...
Checking for       AppConfig (v1.52)   ok: found v1.56
Checking for             CGI (v2.93)   ok: found v3.11
Checking for    Data::Dumper (any)     ok: found v2.121
Checking for    Date::Format (v2.21)   ok: found v2.22
Checking for             DBI (v1.38)   ok: found v1.48
Checking for      File::Spec (v0.84)   ok: found v3.14
Checking for      File::Temp (any)     ok: found v0.16
Checking for        Template (v2.08)   ok: found v2.14
Checking for      Text::Wrap (v2001.0131) ok: found v2005.0824
Checking for    Mail::Mailer (v1.65)   ok: found v1.67
Checking for        Storable (any)     ok: found v2.15

The following Perl modules are optional:
Checking for              GD (v1.20)    not found
Checking for     Chart::Base (v1.0)     not found
Checking for     XML::Parser (any)     ok: found v2.34
Checking for       GD::Graph (any)      not found
Checking for GD::Text::Align (any)      not found
Checking for     PatchReader (v0.9.4)   not found

If you you want to see graphical bug charts (plotting historical data
over
time), you should install libgd and the following Perl modules:

GD:          /usr/bin/perl -MCPAN -e 'install "GD"'
Chart:       /usr/bin/perl -MCPAN -e 'install "Chart::Base"'

If you you want to see graphical bug reports (bar, pie and line charts
of
current data), you should install libgd and the following Perl modules:

GD:              /usr/bin/perl -MCPAN -e 'install "GD"'
GD::Graph:       /usr/bin/perl -MCPAN -e 'install "GD::Graph"'
GD::Text::Align: /usr/bin/perl -MCPAN -e 'install "GD::Text::Align"'

If you want to see pretty HTML views of patches, you should install the
PatchReader module:
PatchReader: /usr/bin/perl -MCPAN -e 'install "PatchReader"'
Checking user setup ...
Removing existing compiled templates ...
Precompiling templates ...
Checking for      DBD::mysql (v2.9003) ok: found v3.0002_4
Checking for           MySQL (v3.23.41) ok: found v5.0.15-standard-log
Creating database bugs ...

DBD::mysql::db selectrow_array warning:  [for Statement "SELECT
COUNT(*) FROM bz_schema"] at Bugzilla/DB.pm line 799.
Building Schema object from database...
Adding new table bz_schema ...
Initializing the new Schema storage...
Out of memory!
Out of memory!
Callback called exit.
DBI::db=HASH(0x981aecc)->disconnect invalidates 1 active statement
handle (either destroy statement handles or call finish on them before
disconnecting) at ./checksetup.pl line 1543.
-----------------------

 NOTE: if i run checksetup.pl again (after the above error) , then it's
a different error:

...
...
...
Checking user setup ...
Removing existing compiled templates ...
Precompiling templates ...
Checking for      DBD::mysql (v2.9003) ok: found v3.0002_4
Checking for           MySQL (v3.23.41) ok: found v5.0.15-standard-log

DBD::mysql::st execute failed: Table 'bugs.bugs' doesn't exist [for
Statement "SHOW INDEX FROM bugs"] at Bugzilla/DB/Mysql.pm line 539

Bugzilla::DB::Mysql::bz_index_info_real('Bugzilla::DB::Mysql=HASH(0x8a6eeec )',
'bugs', 'assigned_to') called at Bugzilla/DB/Mysql.pm line 265

Bugzilla::DB::Mysql::bz_setup_database('Bugzilla::DB::Mysql=HASH(0x8a6eeec) ')
called at ./checksetup.pl line 1593

--------------------

to get back to the previous state of errors, i just delete the bugs
database and it's the same thing all over again.

has anyone experienced this before and what, if any, is the way out of
this?
thanks,
-prash.


    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Benton, Kevin  
View profile  
 More options Nov 30 2005, 7:19 am
Newsgroups: netscape.public.mozilla.webtools
From: "Benton, Kevin" <kevin.ben...@amd.com>
Date: Tue, 29 Nov 2005 12:19:39 -0800
Local: Wed, Nov 30 2005 7:19 am
Subject: RE: installation error while creating bugs database
How much memory is on the system you're running Bugzilla on?  Is it
possible it really did run out of RAM during the install process?  Is
MySQL running?  What version?  Did you give access to the bugs user to
the bugs database?  Did you pre-create just the database (no tables)?
...  It looks like you're going to want to drop the bugs database and
re-create it if this is a brand new install.  Otherwise, see above and
we can continue from there...

---
Kevin Benton
Perl/Bugzilla Developer/Administrator, Perforce SCM Administrator
Personal Computing Systems Group
Advanced Micro Devices

The opinions stated in this communication do not necessarily reflect the
view of Advanced Micro Devices and have not been reviewed by management.
This communication may contain sensitive and/or confidential and/or
proprietary information.  Distribution of such information is strictly
prohibited without prior consent of Advanced Micro Devices.  This
communication is for the intended recipient(s) only.  If you have
received this communication in error, please notify the sender, then
destroy any remaining copies of this communication.

Bugzilla::DB::Mysql::bz_index_info_real('Bugzilla::DB::Mysql=HASH(0x8a6e
ee
> c)',
> 'bugs', 'assigned_to') called at Bugzilla/DB/Mysql.pm line 265

Bugzilla::DB::Mysql::bz_setup_database('Bugzilla::DB::Mysql=HASH(0x8a6ee
ec


    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
ipr...@gmail.com  
View profile  
 More options Nov 30 2005, 8:21 am
Newsgroups: netscape.public.mozilla.webtools
From: ipr...@gmail.com
Date: 29 Nov 2005 13:21:33 -0800
Local: Wed, Nov 30 2005 8:21 am
Subject: Re: installation error while creating bugs database
hello,
  thanks for the reply. i have 512 mb ram (and about 60% free at the
time of retrying this). for a debian box i am pretty sure that's
plenty. mysql is up (like i said - it indeed creates a bugs database
with one single table. details follow:

-----

root@softsit:/usr/local/bugzilla-2.20# mysqladmin version -p
Enter password:
mysqladmin  Ver 8.41 Distrib 5.0.15, for pc-linux-gnu on i686
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

Server version          5.0.15-standard
Protocol version        10
Connection              Localhost via UNIX socket
UNIX socket             /tmp/mysql.sock
Uptime:                 10 min 3 sec

Threads: 1  Questions: 21  Slow queries: 0  Opens: 0  Flush tables: 1
Open tables: 8  Queries per second avg: 0.035

-----

root@softsit:/usr/local/bugzilla-2.20# mysql -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 6 to server version: 5.0.15-standard

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| bugs               |
| mysql              |
| test               |
+--------------------+
4 rows in set (0.00 sec)

mysql> use bugs;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> show tables;
+----------------+
| Tables_in_bugs |
+----------------+
| bz_schema      |
+----------------+
1 row in set (0.01 sec)

mysql> select * from bz_schema;
+--------------+---------+
| schema_data  | version |
+--------------+---------+
| $VAR1 = {};
 |    2.00 |
+--------------+---------+
1 row in set (0.00 sec)

-----

in answer to your questions,
Is MySQL running?  YES
What version? 5.0.15
Did you give access to the bugs user to the bugs database?  YES
Did you pre-create just the database (no tables)? NO (it creates the
bugs database, not me - am i supposed to create the bugs database?)

  thanks again,
  -prash.


    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
prash  
View profile  
 More options Dec 1 2005, 5:17 am
Newsgroups: netscape.public.mozilla.webtools
From: "prash" <ipr...@gmail.com>
Date: 30 Nov 2005 10:17:38 -0800
Local: Thurs, Dec 1 2005 5:17 am
Subject: Re: installation error while creating bugs database
hi,
  was just wondering if anyone else had anything else for me to go on
with. i still face the same problem.
  thanks,
  -prash.


    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Tim Thome  
View profile  
 More options Dec 1 2005, 3:34 pm
Newsgroups: netscape.public.mozilla.webtools
From: Tim Thome <tth...@cox.net>
Date: Wed, 30 Nov 2005 20:34:20 -0800
Local: Thurs, Dec 1 2005 3:34 pm
Subject: Re: installation error while creating bugs database
Prash,

Go into mysql and convert the account to use the old password hash format.

mysql> SET PASSWORD FOR 'some_user'@'some_host' = OLD_PASSWORD('mypass');

Try that, report back what happens...

Tim


    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Olav Vitters  
View profile  
 More options Dec 1 2005, 7:01 pm
Newsgroups: netscape.public.mozilla.webtools
From: Olav Vitters <o...@bkor.dhs.org>
Date: Thu, 1 Dec 2005 09:01:37 +0100
Local: Thurs, Dec 1 2005 7:01 pm
Subject: Re: installation error while creating bugs database

On Tue, Nov 29, 2005 at 11:55:54AM -0800, ipr...@gmail.com wrote:
> Checking for      DBD::mysql (v2.9003) ok: found v3.0002_4

Probably that is a beta version. Beta versions of DBD drivers often
cause weird errors when creating the tables. Suggest to find a
DBD-mysql version without the _4.

> Out of memory!
> Out of memory!

--
Regards,
Olav

    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
prash  
View profile  
 More options Dec 2 2005, 3:18 am
Newsgroups: netscape.public.mozilla.webtools
From: "prash" <ipr...@gmail.com>
Date: 1 Dec 2005 08:18:21 -0800
Local: Fri, Dec 2 2005 3:18 am
Subject: Re: installation error while creating bugs database
thank you very much - this solved the problem!
all tables created and admin user created!
i am now using v3.0002.
( i will report this incident to the develoeprs of v3.0002_4)
thanks again!
-prash.


    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
End of messages
« Back to Discussions « Newer topic     Older topic »

Create a group - Google Groups - Google Home - Terms of Service - Privacy Policy
©2010 Google