Unable to configure Cacti database on install (no MySQL root password)

Bug #522142 reported by Dave-B
12
This bug affects 2 people
Affects Status Importance Assigned to Milestone
dbconfig-common (Ubuntu)
Expired
Undecided
Unassigned

Bug Description

Binary package hint: cacti

Short version:

The Cacti install should set up the database by prompting the user for database and database user information, rather than a) requiring them to research/already know about dbconfig-common, and b) fail to install the database because of not asking for the MySQL root password.

Long version:

I ran `sudo apt-get install cacti` and the system installed MySQL (with root password prompt) and other dependencies, but when it gets to configuring cacti, I get an error "No database user specified.". To continue, I'm given a choice of:

abort
retry
retry (skip questions)
ignore

Via Google I figure out that I need to set some database connection information in /etc/dbconfig-common/cacti.conf, so I add values for, database user, database user password, database name, and database admin.

I'm puzzled that there's no mention of the database admin password, but I'll try and carry on. I get no obvious Google hits around ucf, root, and password.

I re-read /usr/share/doc/cacti/README.Debian.gz, which says configuration dbconfig-common should be automatic.

Retrying the database installation step, I now get the error:
"ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)"

Obviously dbconfig-common is not getting into MySQL without a password, and is not asking me for the password.

Maybe I'm missing some "commonly known" approach to setting it up, but there's nothing in the processes telling me how to get the automatic install to work.

In the end I chose "abort", and created the database manually, as described in /usr/share/doc/cacti/README.Debian.gz. It took a bit of fiddling, but it seems to be running now.

ProblemType: Bug
Architecture: i386
Date: Mon Feb 15 13:45:03 2010
DistroRelease: Ubuntu 10.04
InstallationMedia: Ubuntu 10.04 "Lucid Lynx" - Alpha i386 (20100128)
Package: cacti 0.8.7e-2
PackageArchitecture: all
ProcEnviron:
 LANG=en_GB.utf8
 SHELL=/bin/bash
ProcVersionSignature: Ubuntu 2.6.32-12.17-generic
SourcePackage: cacti
Uname: Linux 2.6.32-12-generic i686

Revision history for this message
Dave-B (david-balch) wrote :
Revision history for this message
Bl4deRunner (bl4derunnerz) wrote :

I'll second that.
Started installing cacti trough Ubuntu Software Center, and it got stuck at 89%, with the "Debconf on ubuntu" configuration screen.
First screen I got a checkbox for "Configure database for cacti with dbconfig-comon?"
I'm a noob, so yes, please.
[Forward]
Next step for database installation:
List with
[abort]
[retry]
[retry (skip questions)]
[ignore]

Well.. retry is results in an endless loop, as it shows the previous screen.
I'm left with [abort] and [ignore].
I still haven't figured out what to do.

Revision history for this message
Paul Gevers (paul-climbing) wrote :

Could you confirm (I am afraid you won't know anymore) that mysql was installed as a dependency? I noticed the problem that mysql does not start up as is should without a reboot or "initctl reload-configuration".

See also bug 982303.

Revision history for this message
Launchpad Janitor (janitor) wrote :

Status changed to 'Confirmed' because the bug affects multiple users.

Revision history for this message
Paul Gevers (paul-climbing) wrote :

Cacti asks dbconfig-common to handle the database, so this bug is really in that package. Reassigning. I am quite sure that there is also a Debian bug about this issue, but dbconfig-common really needs a maintainer.

Changed in dbconfig-common (Ubuntu):
status: New → Confirmed
affects: cacti (Ubuntu) → dbconfig-common (Ubuntu)
Revision history for this message
Launchpad Janitor (janitor) wrote :

Status changed to 'Confirmed' because the bug affects multiple users.

Changed in cacti (Ubuntu):
status: New → Confirmed
James Page (james-page)
affects: dbconfig-common (Ubuntu) → cacti (Ubuntu)
Changed in dbconfig-common (Ubuntu):
status: New → Confirmed
James Page (james-page)
affects: cacti (Ubuntu) → dbconfig-common (Ubuntu)
Revision history for this message
James Page (james-page) wrote :

I've not been able to repeat this bug on Ubuntu 14.04; a fresh install of cacti correctly configures with mysql using dbconfig-common.

Revision history for this message
James Page (james-page) wrote :

Original bug reporter has not responded to questions so marking 'Incomplete' for the time being.

Changed in dbconfig-common (Ubuntu):
status: New → Incomplete
Revision history for this message
Launchpad Janitor (janitor) wrote :

[Expired for dbconfig-common (Ubuntu) because there has been no activity for 60 days.]

Changed in dbconfig-common (Ubuntu):
status: Incomplete → Expired
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.