Hello --
I am going through the motions of install Icinga 1.7.0 onto an Ubuntu 10.04 LTS
system, and I have opted to install the
new web interface. I am going through the motions of setting up the database,
which in this case is the MySQL 5.162
release. I have created the database icinga_web, and have given the user
account of the same name the privileges
outlined in the installation document. The command sequence that I have used to
accomplish this is the following:
# mysql -u root -p
mysql> CREATE DATABASE icinga_web;
GRANT USAGE ON *.* TO 'icinga_web'@'localhost' IDENTIFIED BY
'icinga_web' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0
MAX_UPDATES_PER_HOUR 0;
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER, INDEX ON
icinga_web.* TO 'icinga_web'@'localhost';
FLUSH PRIVILEGES;
quit
I am at the point in the procedure to install the tables into the database. To
that end, I have run the following command:
make-db-initialize
However, the output that I am getting is the following:
root@lamp src/icinga-web-1.7.0# make db-initialize
cd ./etc/ && ../bin/phing -f build.xml db-initialize
Buildfile: /usr/src/icinga-web-1.7.0/etc/build.xml
[property] Loading /usr/src/icinga-web-1.7.0/etc/build.properties
icinga-web > db-initialize:
[phingcall] Calling Buildfile '/usr/src/icinga-web-1.7.0/etc/build.xml' with
target 'db-create'
[property] Loading /usr/src/icinga-web-1.7.0/etc/build.properties
icinga-web > prepare:
icinga-web > db-prepare:
Use the db-user specified in icinga-webs database.xml (Needs create
Database/create Table rights)?(n,y)? y
icinga-web > db-create:
Error during schema creation - are you sure the table doesn't already exist? If
so, use the update command.
PDO Connection Error: SQLSTATE[28000] [1045] Access denied for user
'icinga_web'@'localhost' (using password: YES)
WARNING: Initial data import may have failed due too many references.
BUILD FINISHED
Total time: 4.9909 seconds
When I check the database, it is shown there are no tables within it. What
steps do I need to take in order to correct this problem,
and get the database installed onto the system?
Thanks.
The information in this e-mail is intended only for the person to whom it is
addressed. If you believe this e-mail was sent to you in error and the e-mail
contains patient information, please contact the Partners Compliance HelpLine at
http://www.partners.org/complianceline . If the e-mail was sent to you in error
but does not contain patient information, please contact the sender and properly
dispose of the e-mail.
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
icinga-users mailing list
icinga-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/icinga-users
