[op5-users] Help installing Ninja

[Russell Jennings]

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