[op5-users] Ninja Merlin Install

[Thomas Hudson]

Lino Eduardo Avila wrote:
> I have the same issue in CentOS 5 with nagios 3.2, ninja 0.3.2
>
> [root at nagios-centOS ninja]# install_scripts/ninja_db_init.sh
> /usr/local/nagios/addons/ninja
> Importing users from cgi.cfg
> PHP Warning:  mysql_connect(): Access denied for user
> 'merlin'@'localhost' (using password: YES) in
> /usr/local/nagios/addons/ninja/install_scripts/auth_import_mysql.php
> on line 99
> PHP Warning:  mysql_connect(): Access denied for user
> 'merlin'@'localhost' (using password: YES) in
> /usr/local/nagios/addons/ninja/cli-helpers/htpasswd-import.php on line
> 34
> PHP Warning:  mysql_select_db(): Access denied for user
> 'root'@'localhost' (using password: NO) in
> /usr/local/nagios/addons/ninja/cli-helpers/htpasswd-import.php on line
> 35
> PHP Warning:  mysql_select_db(): A link to the server could not be
> established in /usr/local/nagios/addons/ninja/cli-helpers/htpasswd-import.php
> on line 35
> Failed to select database 'merlin'
> Access denied for user 'root'@'localhost' (using password: NO)
>
> I already tried with the user merlin and root in the file:
> install_scripts/ninja_db_init.sh
>
> but the same problem...
>
> Merlin is working correctly. I already looked at the db.
>
>
> Regards,
>
>
>
> On Tue, Oct 6, 2009 at 3:57 AM, Martin Svangren <martin.svangren at op5.com> wrote:
>   
>> Hi Michael,
>>
>> You might need to edit the install scripts a bit for the user import to
>> work. Have a look at the "Modify and run the install scripts" section of
>> this wiki page:
>>
>> https://wiki.op5.com/ninja:docs:quickstart-centos5
>>
>> Basically, you'll need to edit some hardcoded paths in auth_import_mysql.php
>> and run the install scripts again. Note that you also need to have the 'awk'
>> utility installed for the scripts to work.
>>
>> /Martin
>>
>> On Tue, Oct 6, 2009 at 10:46 AM, Thomas Hudson <tom.hudson at isotoma.com>
>> wrote:
>>     
>>> Michael Saville wrote:
>>>       
>>>> Hello,
>>>>
>>>> Ive installed and configured both merlin and ninja as per the online
>>>> documentation. I did not get any errors throughout the process. I can
>>>> browse to //localhost/ninja but cannt login i get Login failed -
>>>> please try again everytime. Ive tried the user name and password
>>>> configured for nagios. I also looked around the mailing archive and
>>>> found another user with the similar problem he found that using
>>>> monitor, monitor was the solution for him. Ive tried and that doe not
>>>> work. I installed phpmy admin and took a look at the database i can
>>>> see that the ninja.sql did import and merlin seems to have information
>>>> in it. Any Ideas on a solution ? Im very new to Nagios and am not sure
>>>> where to begin troubleshooting this. Thanks -Michael
>>>>
>>>> --
>>>> Michael L Saville
>>>> ------------------------------------------------------------------------
>>>>
>>>> _______________________________________________
>>>> op5-users mailing list
>>>> op5-users at lists.op5.com
>>>> http://lists.op5.com/mailman/listinfo/op5-users
>>>>
>>>>         
>>> Michael,
>>>
>>> It's possible that the install of ninja didn't create all of the tables
>>> and copy the usernames and passwords across from nagios. I had that
>>> problem when I was installing yesterday.
>>> I've fixed the scripts but I'm still working out how to use git. When I
>>> do, I'll submit the changes and - fingers crossed - you'll be able to
>>> use those and it'll just work.
>>>
>>> In the mean-time, things you should check:
>>> - In the merlin database, has ninja created the tables, for example
>>> ninja_user_authorization.
>>> - If that table is there, is there anything in it?
>>>
>>> Cheers,
>>>
>>> Tom Hudson
>>> _______________________________________________
>>> op5-users mailing list
>>> op5-users at lists.op5.com
>>> http://lists.op5.com/mailman/listinfo/op5-users
>>>       
>>
>> --
>> Martin Svangren
>> System Administrator
>>
>> op5 AB
>> Första Långgatan 19
>> SE-413 27 Göteborg, SWEDEN
>>
>> Direct: +46 (0)31-352 56 21
>> Mobile: +46 (0)733-70 90 21
>> Switchboard: +46 (0)31-352 56 00
>>
>> E-mail: martin.svangren at op5.com
>> Web: http://www.op5.com
>>
>> _______________________________________________
>> 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
>   
That's one of the things I've changed (though I don't know if it's the 
desired solution and haven't had time to submit the patches).

I changed the line:
db_login_opts="-u$db_user"

in ninja_db_init.sh to:
db_login_opts="-u$db_user -p"


which prompts you for the db admin password rather than assuming there 
isn't one.

Hope this helps,

Tom Hudson
isotoma