View Single Post
  #2  
Old 12th January 2007, 20:47
wmunguiam wmunguiam is offline
Junior Member
 
Join Date: Jan 2007
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Something is wrong!

Hello,
I use tutorial http://www.howtoforge.com/cacti_ispconfig

On ISPConfig I created a Site CACTI, in OPTIONS I ADDED a Database with database name: web1_db1 and user: web1_u1, then I download Cacti package and Installed and I had a problem in Step 4:

Step 4 - Setup the Cacti database:
Create the MySQL database (If you prefer, you can use the PHPMyAdmin):
sudo mysqladmin --user=root
Import the default cacti database:
sudo mysql web1_db1 < cacti.sql

and it is the response:

noc@manager:/var/www/web1/web$ sudo mysqladmin --user=web1_u1
mysqladmin Ver 8.41 Distrib 5.0.24a, for pc-linux-gnu on i486
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

Administration program for the mysqld daemon.
Usage: mysqladmin [OPTIONS] command command....
-c, --count=# Number of iterations to make. This works with -i
(--sleep) only.
.....
.....

--shutdown_timeout=#

Variables (--variable-name=value)
and boolean options {FALSE|TRUE} Value (after reading options)
--------------------------------- -----------------------------
count 0
force FALSE
compress FALSE
character-sets-dir (No default value)
default-character-set (No default value)
host (No default value)
port 3306
relative FALSE
socket /var/run/mysqld/mysqld.sock
sleep 0
ssl FALSE
ssl-ca (No default value)
ssl-capath (No default value)
ssl-cert (No default value)
ssl-cipher (No default value)
ssl-key (No default value)
ssl-verify-server-cert FALSE
user web1_u1
verbose FALSE
vertical FALSE
connect_timeout 43200
shutdown_timeout 3600

Default options are read from the following files in the given order:
/etc/mysql/my.cnf ~/.my.cnf /etc/mysql/my.cnf
The following groups are read: mysqladmin client
The following options may be given as the first argument:
--print-defaults Print the program argument list and exit
--no-defaults Don't read default options from any options file
....
....

variables Prints variables available
version Get version info from server
noc@manager:/var/www/web1/web$ sudo mysql web1_db1 < cacti.sql
-bash: cacti.sql: Permission denied
noc@manager:/var/www/web1/web$

What is the problem?? Why I can't import database cacti.sql to web1_db1??
Reply With Quote