[op5-users] Ninja Merlin Install
Thomas Hudson
tom.hudson at isotoma.com
Tue Oct 6 22:05:13 CEST 2009
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
>
More information about the op5-users
mailing list