[op5-users] Help installing Ninja

[Ricardo Trindade]

I finally found it. It's ninja.sql the script who creates ninja
tables. I don't know if shell is supposed to run it or if I should run
it by myself. If this is supposed to run manually it should be in the
README install doc.

Thanks anyway. If you need more information about this issue to
troubleshoot it for new users who might have the same problem as me, I
will be glad to help.

[]'s

On Wed, Nov 25, 2009 at 2:17 PM, Ricardo Trindade <rtrind.mail at gmail.com> wrote:
> Hi,
>
>    I am trying to install ninja and I am having trouble always at the
> same point.
>
> My actual setup:
> Nagios 3.2.0
> NagVis 1.4.4 (from git, because of some corrected bugs on automap)
> PNP4Nagios 0.6RC6
> Merlin v0.6.4
>
>    I migrated from NDO2DB to Merlin as a back-end because of ninja
> and its resources. Merlin is installed successfully and working with
> NagVis perfectly.
>
>    Following the README i am having trouble with install-setup.sh. It
> always fails in setting up the database for ninja:
>
> ---------------------
> [root at casserver ninja]# install_scripts/ninja_db_init.sh
> /usr/local/nagios/addons/ninja
> Installing database tables for Ninja GUI
> Importing users from cgi.cfg
> PHP Warning:  mysql_fetch_array(): supplied argument is not a valid
> MySQL result resource in
> /usr/local/nagios/addons/ninja/cli-helpers/htpasswd-import.php on line
> 42
>
> Warning: mysql_fetch_array(): supplied argument is not a valid MySQL
> result resource in
> /usr/local/nagios/addons/ninja/cli-helpers/htpasswd-import.php on line
> 42
> query 'INSERT INTO users(username, password_algo, password)
> VALUES('nagiosadmin', 'crypt', 't44CBV8swaoh2')' failed with error:
>  Table 'merlin.users' doesn't exist
> SQL query failed with the following error message;<br />
> Table 'merlin.users' doesn't exist<br />
> -----------------
>
> The table really doesn't exist on the database, but i found no info if
> this is an additional table needed by ninja or a regular table created
> by merlin.
>
> I even tried the same procedure with the latest git version but the
> problem still remains. I really wouldn't want to create this table
> manually, because there may be more items to correct beyond this one.
>
> What can I try next?
>
> Tks in advance.
>