314221 - Installation instruction fail on a fresh install of Linux (when followed by a novice)

Status: RESOLVED INVALID

(Bugzilla :: Installation & Upgrading, defect)

Description

[Pavel Greenfield]

User-Agent:       Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.8) Gecko/20050524 Fedora/1.0.4-4 Firefox/1.0.4
Build Identifier: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.8) Gecko/20050524 Fedora/1.0.4-4 Firefox/1.0.4

Just made a clean install of Fedora Core 4 on a dell box. MySQL is running, under whatever the install conditions are. When logged in as root, I am able to type mysql to get a mysql> prompt. Then typing "mysql> use test" results in "Database Changed". (This is the extent of my MySQL and otherwise database knowledge.)

Then in the course of the Bundle::Bugzilla installation I get the following error;

t/dbi............ok 13/63Template process failed: DBI error - DBI connect failed: Unknown MySQL server host 'test' (1)
FAILED 14:  - template text 6 process FAILED: [% USE dbi -%]\n[% dbi.connect(da...
t/dbi............NOK 14FAILED 15:  - (obviously did not match expected)      
t/dbi............FAILED tests 14-15                                          
        Failed 2/63 tests, 96.83% okay


The final message is this:

Failed Test Stat Wstat Total Fail  Failed  List of Failed
-------------------------------------------------------------------------------
t/dbi.t                   63    2   3.17%  14-15
11 tests skipped.
Failed 1/90 test scripts, 98.89% okay. 2/2555 subtests failed, 99.92% okay.
make: *** [test_dynamic] Error 255
  /usr/bin/make test -- NOT OK
Running make install
  make test had returned bad status, won't install without force
Text::Wrap is up to date.
Bundle summary: The following items in bundle Bundle::Bugzilla had
installation problems:
  Template 

How to solve?

Reproducible: Always

Steps to Reproduce:
1. Install FC4 with mysql. Make sure MySQL is running, but (realizing that you have no clue about databases) make now other configurational changes
2. Type perl -MCPAN -e 'install "Bundle::Buzilla"'


Actual Results:  
Get the errors descirbed above.

Expected Results:  
No error messages.

I think that the installation guide should assume no database knowledge.

Comment 1

[Olav Vitters]

Seems you changed $db_host to "test". Leave that as the default:
  $db_host = "localhost";
that described the computer it will connect to

Instead the test should be here:
  $db_name = "test";
and that is the database name (use test;).

but I do not recommend using test. Suggest to create a normal database.

This is not an error in Bugzilla but a support issue, so I'm closing this bug.

Bugzilla support is given at the newsgroup and IRC channel described at:
http://www.bugzilla.org/support/

Of course feel free to file other bugs.

Comment 2

[Pavel Greenfield]

Thanks.

Perhaps you could still help me just a little bit more.

I actually never entered "test" anywhere, and I'm completely clueless what the variabls $db_host and $db_name are and where they can be found or changed. Are these perl variable? What file would they be found it?
I'm only presented with the following dialog:

Please enter the driver name for the test database.
The DBD drivers installed on your system are

    DBM, ExampleP, File, Pg, Proxy, Sponge, mysql

Enter driver name:  [mysql] 

Now enter the data source (DSN) for the test database.
Many DBD drivers require only a database name (e.g. 'test') while
others may require an alternate format or additional parameters
(e.g. 'dbname=test').  Please consult your DBD documentation for
further details.

Database name:  [test] 
Enter user name :  [] root
Enter password  :  [] ******

I don't get to choose the host....

I would appreciate any guidance on this!

Comment 3

[Pavel Greenfield]

OK, I finally figured it out. 

With MySQL you need to say "dbname=test" rather than simply "test".

Darn it.