LinuxQuestions.org
Go Job Hunting at the LQ Job Marketplace
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices

Reply
 
Search this Thread
Old 05-01-2012, 03:18 AM   #1
nonshatter
Member
 
Registered: Aug 2010
Location: Hants
Distribution: SLES, Ubuntu, Centos
Posts: 41

Rep: Reputation: 0
dbconfig-common failures when installing through apt on Ubuntu10.4


Hi all,

I have managed to install Cacti on several other debian servers without too many problems. However, there is one server which is not working at all for me.

I am using the Ubuntu sources through apt, which usually works without any issues. It seems to get stuck around the point of creating the cacti database, failing with a couple of mysql-related errors, along with a 'Chown invalid user root:staff'.

This is a production server, so I'd rather not try anything that might risk mashing my system.

Here is most of the output from /var/log/apt/term.log:

Code:
Selecting previously deselected package cacti.
(Reading database ... 152051 files and directories currently installed.)
Unpacking cacti (from .../cacti_0.8.7e-2ubuntu0.2_all.deb) ...
Setting up cacti (0.8.7e-2ubuntu0.2) ...
dbconfig-common: writing config to /etc/dbconfig-common/cacti.conf

Creating config file /etc/dbconfig-common/cacti.conf with new version

Creating config file /etc/cacti/debian.php with new version
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '/usr/bin/mysql' at line 1.
unable to connect to mysql server.
error encountered creating user:
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '/usr/bin/mysql' at line 1
dbconfig-common: cacti configure: trying again.
dbconfig-common: writing config to /etc/dbconfig-common/cacti.conf
Replacing config file /etc/cacti/debian.php with new version
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '/usr/bin/mysql' at line 1.
unable to connect to mysql server.
error encountered creating user:
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '/usr/bin/mysql' at line 1
dbconfig-common: cacti configure: trying again.
dbconfig-common: writing config to /etc/dbconfig-common/cacti.conf
Replacing config file /etc/cacti/debian.php with new version
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '/usr/bin/mysql' at line 1.
unable to connect to mysql server.
error encountered creating user:
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '/usr/bin/mysql' at line 1
dbconfig-common: cacti configure: aborted.
dbconfig-common: flushing administrative password
dpkg: error processing cacti (--configure):
subprocess installed post-installation script returned error exit status 1
Errors were encountered while processing:
cacti
Log ended: 2012-04-30  19:25:04

Log started: 2012-04-30  19:26:57
Setting up cacti (0.8.7e-2ubuntu0.2) ...
dbconfig-common: writing config to /etc/dbconfig-common/cacti.conf
Replacing config file /etc/cacti/debian.php with new version
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '/usr/bin/mysql' at line 1.
unable to connect to mysql server.
error encountered creating user:
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '/usr/bin/mysql' at line 1
dbconfig-common: cacti configure: ignoring errors from here forwards
populating database via sql...  done.
dbconfig-common: flushing administrative password

Creating config file /etc/cacti/apache.conf with new version
chown: invalid group: `root:staff'

Log ended: 2012-04-30  19:27:14
I have tried reinstalling several times using apt-get remove --purge cacti, but still no luck...
My feeling is that if I can solve where this error is coming from, then the other problems might go away:

Code:
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '/usr/bin/mysql' at line 1

At this point you choose "retry", you will be prompted with all the configuration questions once more and another attempt will be made at performing the operation. 
"retry (skip questions)" will immediately attempt the operation again, skipping all questions. If you choose "abort", the operation will fail and you will need to 
downgrade, reinstall, reconfigure this package, or otherwise manually intervene to continue using it. If you choose "ignore", the operation will continue, ignoring further errors from dbconfig-common.
Any help appreciated
ns

Last edited by nonshatter; 05-01-2012 at 03:25 AM.
 
  


Reply

Tags
apt, cacti, mysql, ubuntu


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
[SOLVED] Query in installing omnet++ in ubuntu10.04 ron_cutler Linux - Newbie 2 03-19-2012 03:30 PM
apt-get gets stuck at vim-common PBSchmidt Debian 3 01-08-2008 09:15 AM
apt-get install samba-common kristof_v Debian 2 02-26-2007 10:11 AM
Failures in apt-get? upchucky Debian 8 12-17-2005 08:01 PM
networking and sound failures after apt-get upgrade JediGuy_bob Debian 3 06-05-2004 09:18 PM


All times are GMT -5. The time now is 04:53 AM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration