Connection Error to NDO DataBase

[tagger]

OS : Debian Etch
Nagios : 3.03
Centreon : centreon-2.0-b3

I'm following the instructions on the wiki to install centreon but I don't understand for the Installation of NDO (Part 2) : where is the sql command to create the user centreon for the NDO mysql base ?
When I want to control the different users on mysql, the isn't a centreon user ( select user from user).

Thanks in advance for your help.

[Eric G]

Hello,
I had the same problem and used the following lines :

# mysql -u root
mysql> CREATE DATABASE `ndo` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
mysql> exit
# mysql -u root ndo < ~/downloads/centreon-2.0-b2/www/install/createNDODB.sql
# mysql -u root
mysql> GRANT SELECT , INSERT , UPDATE , DELETE ON `ndo` . * TO 'centreon'@'localhost';
mysql> exit

[tagger]

Hi Eric,

I have already following this step before this error.
I checked my database :

mysql> show databases ;
+--------------------+
| Database |
+--------------------+
| information_schema |
| DBCenstorage |
| DBCentreon |
| mysql |
| ndo |
+--------------------+

The tables have been also created, as you see it hereafter :
mysql> show tables;
+----------------------------------------+
| Tables_in_ndo |
+----------------------------------------+
| centreon_acl |
| nagios_acknowledgements |
| nagios_commands |
| nagios_commenthistory |
| nagios_comments |
| nagios_configfiles |
| nagios_configfilevariables |
| nagios_conninfo |
| nagios_contact_addresses |
| nagios_contact_notificationcommands |
| nagios_contactgroup_members |
| nagios_contactgroups |
| nagios_contactnotificationmethods |
| nagios_contactnotifications |
| nagios_contacts |
| nagios_contactstatus |
| nagios_customvariables |
| nagios_customvariablestatus |
| nagios_dbversion |
| nagios_downtimehistory |
| nagios_eventhandlers |
| nagios_externalcommands |
| nagios_flappinghistory |
| nagios_host_contactgroups |
| nagios_host_contacts |
| nagios_host_parenthosts |
| nagios_hostchecks |
| nagios_hostdependencies |
| nagios_hostescalation_contactgroups |
| nagios_hostescalation_contacts |
| nagios_hostescalations |
| nagios_hostgroup_members |
| nagios_hostgroups |
| nagios_hosts |
| nagios_hoststatus |
| nagios_instances |
| nagios_logentries |
| nagios_notifications |
| nagios_objects |
| nagios_processevents |
| nagios_programstatus |
| nagios_runtimevariables |
| nagios_scheduleddowntime |
| nagios_service_contactgroups |
| nagios_service_contacts |
| nagios_servicechecks |
| nagios_servicedependencies |
| nagios_serviceescalation_contactgroups |
| nagios_serviceescalation_contacts |
| nagios_serviceescalations |
| nagios_servicegroup_members |
| nagios_servicegroups |
| nagios_services |
| nagios_servicestatus |
| nagios_statehistory |
| nagios_systemcommands |
| nagios_timedeventqueue |
| nagios_timedevents |
| nagios_timeperiod_timeranges |
| nagios_timeperiods |
+----------------------------------------+
60 rows in set (0.01 sec)

[tagger]

problem resolved :
sql command :
mysql> GRANT SELECT , INSERT , UPDATE , DELETE ON `ndo` . * TO 'centreon'@'localhost' identified by [password];