[op5-users] Ninja Merlin Install

[Lino Eduardo Avila]

Thanks for your help Tom it already imported the users but still
getting some errors

[root at nagios-centOS install_scripts]# ./ninja_db_init.sh
/usr/local/nagios/addons/ninja
Enter password:
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 Fatal error:  Call to undefined method
ninja_auth_import::gui_db_connect() in
/usr/local/nagios/addons/ninja/install_scripts/auth_import_mysql.php
on line 137


Regards,


On Tue, Oct 6, 2009 at 12:33 PM, Thomas Hudson <tom.hudson at isotoma.com> wrote:
> 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
> _______________________________________________
> op5-users mailing list
> op5-users at lists.op5.com
> http://lists.op5.com/mailman/listinfo/op5-users
>