[op5-users] Ninja Merlin Install

Wed Oct 7 00:40:21 CEST 2009

Ok, i modified the files as posted above (the auth_import_mysql.php) and now
when i try to run the script i get : "Unable to find htpasswd-import class
so this script will now terminate" I did verify that awk was installed. Also
checked the database.php and found all correct data there. Thanks -Michael
On Tue, Oct 6, 2009 at 4:10 PM, Lino Eduardo Avila <lino.avila at gmail.com>wrote:

> 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
> >
> _______________________________________________
> op5-users mailing list
> op5-users at lists.op5.com
> http://lists.op5.com/mailman/listinfo/op5-users
>

-- 
Michael L Saville
_________________
Never do anything that you wouldn't want to explain to the paramedics.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.op5.com/pipermail/op5-users/attachments/20091006/4c3bcb4f/attachment-0001.html 