[op5-users] Ninja Merlin Install

Lino Eduardo Avila lino.avila at gmail.com
Tue Oct 6 22:10:09 CEST 2009 

finally. Thank you very much Tom!

The installation guide should have these settings at least for CentOS.

import.php and database.php



On Tue, Oct 6, 2009 at 3:05 PM, Thomas Hudson <tom.hudson at isotoma.com> wrote:
> Lino,
>
> Try changing the password in ninja/application/config/database.php as well.
>
> Tom Hudson
> isotoma
>
>
> Lino Eduardo Avila wrote:
>> that did the trick thanks Tom!.... now... when logging into ninja in
>> the web interface  I get the following message:
>>
>> Warning Message
>>
>> An error was detected which prevented the loading of this page. If
>> this problem persists, please contact the website administrator.
>>
>> system/libraries/drivers/Database/Mysql.php [61]:
>>
>> mysql_connect() [function.mysql-connect]: Access denied for user
>> 'merlin'@'localhost' (using password: YES)
>>
>>
>>
>> I believe this has to do with the ninja configuration... Does anyone
>> knows where is stored this info?
>>
>>
>> Best Regards,
>>
>>
>> On Tue, Oct 6, 2009 at 2:17 PM, Thomas Hudson <tom.hudson at isotoma.com> wrote:
>>
>>> Lino,
>>>
>>> Have you changed the merlin database user password?
>>> It's the only thing I can think of right now.
>>>
>>> If you have, you should change it in import.php in the merlin root
>>> directory:
>>> $imp->db_pass = 'merlin';
>>>
>>> If not, let me know and I'll have another look at it.
>>>
>>> Hope that helps,
>>>
>>> Tom Hudson
>>> isotoma
>>>
>>> Lino Eduardo Avila wrote:
>>>
>>>> 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
>>>>>
>>>>>
>>>>>
>>>> _______________________________________________
>>>> 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
>>>
>>>
>> _______________________________________________
>> 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
>

More information about the op5-users mailing list