314385 - MySQL configuration instructions result in error

Status: RESOLVED FIXED

(Bugzilla :: Documentation, defect)

Description

[Pavel Greenfield]

User-Agent:       Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)
Build Identifier: 

Following the following Bugzilla instructions under "Configuration":

By default, MySQL will limit the size of a table to 4GB. This limit is present even if the underlying filesystem has no such limit. To set a higher limit, follow these instructions. 

Run the MySQL command-line client and enter: 

  mysql> ALTER TABLE attachments 
            AVG_ROW_LENGTH=1000000, MAX_ROWS=20000;

 I get:
ERROR 1046 (3D000): No database selected.


Reproducible: Always

Steps to Reproduce:

Comment 1

[Dave Miller [:justdave]]

Although I would think the error message would make it obvious (tell mysql that you want to do things in the database that belongs to Bugzilla first), I suppose we could add a hint to that section of the docs...  "make sure you've selected your Bugzilla database first" or something.

Comment 2

[Pavel Greenfield]

Hi,

I believe documentation assumes a lot of knowledge which I ( a software engineer with 18 years of experience :) ) simply do not possess. I have never done any database administration.

I assume I need to use the "use" command, but hat is the name of the bugzilla database?

Your response inspired me to do a google 'sql command "show available databases"' and I found "show databases;" and I got this:

mysql
test

but where's the bugzilla database?

Thanks for your help,

Pavel

Comment 3

[Colin Ogilvie [:cso]]

Attachment: Patch v1

Patch v1

Clarify when to complete this step.

Comment 4

[Colin Ogilvie [:cso]]

Attachment: Patch v1.1

Actually tackle the problem...

This clarifies that you should 'use $bugs_db;' first.

Comment 5

[Dave Miller [:justdave]]

Pavel: Colin pointed out on IRC that this instruction is in the docs prior to the spot where it tell you to create the database.  If the database hasn't even been created yet, then of course it's not going to work. :)  And if we hadn't told you to create it yet, then you wouldn't know you'd have to.  So yes, the docs are assuming you'd know something you read later in the docs when you haven't gotten to it yet, thus a problem with the docs.  I hadn't realized it was all backwards when I said the above.  Hope you accept my apology! :)

Comment 6

[Dave Miller [:justdave]]

Comment on attachment 201369 [details] [diff] [review]
Patch v1.1

How about if we combine the two patches and both point out the "after you've completed the database setup part of installation" and that you need to "use bugs".

Comment 7

[Colin Ogilvie [:cso]]

Attachment: Patch v2

Combine the two patches...

Comment 8

[Pavel Greenfield]

Thanks, guys.

I'm very encouraged that you take documentation seriously. Ease of installment and management is at times more important than the feature set.

Comment 9

[Frédéric Buclin]

*** Bug 280395 has been marked as a duplicate of this bug. ***

Comment 10

[Frédéric Buclin]

*** Bug 331811 has been marked as a duplicate of this bug. ***

Comment 11

[Vlad Dascalu]

Comment on attachment 201371 [details] [diff] [review]
Patch v2

This looks good, with 2 specific additions that will probably go upon checkin:

-> swap those 2 questions :), especially since they are in reversed order.

-> specify that the default for $bugs_db is "bugs" (the other question simply assumes default values in their example, which is also good).

Comment 12

[Vlad Dascalu]

Attachment: v2.1: colin's patch with nits fixed

r=vladd

Comment 13

[Vlad Dascalu]

Attachment: v2.1: colin's patch, 2.18 backport

Unfortunately 2.18 required a manual backport :(. Here's the patch FTR.

Comment 14

[Vlad Dascalu]

In the attachment v2.1 (only the version for trunk, 2.22 and 2.20) there were some tabs (coming from v2) that I've fixed upon checkin.

trunk commit:

Checking in docs/xml/installation.xml;
/cvsroot/mozilla/webtools/bugzilla/docs/xml/installation.xml,v  <--  installation.xml
new revision: 1.121; previous revision: 1.120
done

BUGZILLA-2_22-BRANCH:

Checking in docs/xml/installation.xml;
/cvsroot/mozilla/webtools/bugzilla/docs/xml/installation.xml,v  <--  installation.xml
new revision: 1.107.2.10; previous revision: 1.107.2.9
done

BUGZILLA-2_20-BRANCH:

Checking in docs/xml/installation.xml;
/cvsroot/mozilla/webtools/bugzilla/docs/xml/installation.xml,v  <--  installation.xml
new revision: 1.98.2.18; previous revision: 1.98.2.17
done

BUGZILLA-2_18-BRANCH:

Checking in docs/xml/installation.xml;
/cvsroot/mozilla/webtools/bugzilla/docs/xml/installation.xml,v  <--  installation.xml
new revision: 1.72.2.31; previous revision: 1.72.2.30
done