[op5-users] Ninja Merlin Install

Tue Oct 6 21:35:22 CEST 2009

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
>