[op5-users] Ninja Merlin Install

Thomas Hudson tom.hudson at isotoma.com
Tue Oct 6 21:17:26 CEST 2009 

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
>

More information about the op5-users mailing list