[op5-users] Help installing Ninja

[Ricardo Trindade]

My root certainly doesn't have a blank root password. I had to clear
it for merlin installation to work and after that I returned to my
regular password.

Is there any reason why op5 tools rely on blank passwords instead of
configuring mysql to ask them to the operator or ask it as a parameter
(except on batch mode, of course)?

Anyway, you should add something about this to the README. It would
avoid a lot of time lost trying to get it to work because of such a
simple thing.

Thanks for the help and congratulations for this awesome tool.

[]'s

On Wed, Nov 25, 2009 at 2:46 PM, Russell Jennings <russ at geekwhiz.com> wrote:
> pretty sure the install script runs it. but, it may have failed on you
> due to DB permissions, i think the script assumes a blank root pass or
> something. so that part takes some tinkering... but your conclusion is
> correct otherwise, it needs the tables ;)
>
>
>
> On Nov 25, 2009, at 11:43 AM, Ricardo Trindade wrote:
>
>> 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.
>>>
>> _______________________________________________
>> op5-users mailing list
>> op5-users at lists.op5.com
>> http://lists.op5.com/mailman/listinfo/op5-users
>
> _______________________________________________
> op5-users mailing list
> op5-users at lists.op5.com
> http://lists.op5.com/mailman/listinfo/op5-users
>