From: Thomas A. <ze...@gm...> - 2011-04-27 04:13:00
|
Seems to me like the NagiosQL people ought to be using phpseclib (phpseclib.sourceforge.net) instead of the PECL ssh2 extension. It's better supported, much more portable and surprisingly, faster, too: http://kevin.vanzonneveld.net/techblog/article/make_ssh_connections_with_php/#comment_3759 ssh2_exec(), from libssh2, also returns ANSI color codes and sometimes never returns output and sometimes does (it's inconsistent). >Well > >I download nagiosql 3.1.1 again. >Uncompress and move it to /var/www/html/nagiosql > [root]# ls -la >drwxr-xr-x 10 root root 4096 26 apr 10:13 . >drwxr-xr-x 4 root root 4096 26 apr 10:13 .. drwxr-xr-x 2 root root 4096 26 apr 10:13 admin -rw-r--r-- 1 root root 7883 26 apr 10:13 admin.php drwxrwxrwx 3 root root 4096 26 apr 10:13 config -rw-r--r-- 1 root root 1150 26 apr 10:13 favicon.ico drwxr-xr-x 4 root root 4096 26 apr 10:13 functions drwxr-xr-x 2 root root 4096 26 apr 10:13 images -rw-r--r-- 1 root root 2577 26 apr 10:13 index.php drwxr-xr-x 8 root root 4096 26 apr 10:13 install drwxr-xr-x 3 root root 4096 26 apr 10:13 libraries drwxr-xr-x 2 root root 4096 26 apr 10:13 scripts drwxr-xr-x 4 root root 4096 26 apr 10:13 templates I set a new mysql root password. I see that I have not config/settings.php file and see same warning (see Check.pg) [root]# ls -la config rwxrwxrwx 3 root root 4096 26 apr 10:13 . drwxr-xr-x 10 root root 4096 26 apr 10:13 .. -rw-r--r-- 1 root root 26286 26 apr 10:13 fieldvars.php drwxr-xr-x 15 root root 4096 26 apr 10:13 locale -rw-r--r-- 1 root root 10277 26 apr 10:13 main.css Running the installation I still have same problem (see the Error.jpg) Reading nagiosql documentation I see: Requirements Webserver e.g. Apache 1.x or above PHP 4.3 or above MySQL 4.1 or above Nagios 2 or above PEAR Module: HTML_Template_IT 1.1 or above PHP Extension: gettext PHP Extension: mysql PHP Extension: ftp Javascript enabled at your Webbrowser How can I verify/install PEAR MODULE and the three PHP extensions ? Regards -----Messaggio originale----- Da: Giorgio Zarrelli [mailto:zarrelli@...] Inviato: martedì 26 aprile 2011 09:36 A: Marco Borsani Cc: 'Giorgio Zarrelli'; 'Nagios Users List' Oggetto: Re: R: R: [Nagios-users] error in nagiosql install Hi, > In the "checking requirements", I have always two warnings: > - SSH2: Not available (but I am connecting to that host via ssh2) It's an OPTIONAL PECL PHP extension. So, if you do not have it, do not mind. As you can read from this documenti (http://www.nagiosql.org/component/content/article/1-latest-news/105-nagiosq l-310.html) "SSH/SFTP support for remote domains authencation by username and password or by SSH-Key verifiy and restart remote installation with SSH" So if you do not need ssh auth on remote domains (the domain is a config container in NagioSQL, not a real internet domani), you may not install it. If you want to install the SSH PHP extension, keep in mind it's a PECL extension. I do not use CentOS, so, I can't say to you how to do with yum. Here (http://stackoverflow.com/questions/561024/install-pecl-ssh2-extension-for-p hp) they say it can be done this way: yum install libssh2-devel The source tgz is here (http://pecl.php.net/package/ssh2) Here some infos on PECL installation (http://php.net/manual/en/install.pecl.php) I installed a NagioSQL and kept some screenshot I attached to this email. Check what I did and see if it matches with what you did. Giorgio > - Settings file does not exist (config/settings.php): will be created > (but the file exist and I wrote inside: physical = > /var/www/html/nagiosql/) > > Must Nagios be up and running or stopped ? > > Marco > > -----Messaggio originale----- > Da: Giorgio Zarrelli [mailto:zarrelli@...] > Inviato: sabato 23 aprile 2011 12:57 > A: Marco Borsani > Cc: Nagios Users List > Oggetto: Re: R: [Nagios-users] error in nagiosql install > > If you can wait till thue I can try to give you step Bu step > instructions on how to install NagiosQl by hands. > > Ciao, > > Giorgio > > Il giorno 22/apr/2011, alle ore 14:59, "Marco Borsani" > <m.borsani@...> ha scritto: > >> Hi >> I saw that mysql.servers table does not exist, but I don't know how >> going on because I don't know what the automatic procedure has to do. >> >> I find this guide: >> http://nolabnoparty.com/installare-nagios-nagiosql-su-linux-centos-pe >> r >> -il-mo >> nitoraggio-della-rete/ >> >> where you can see tha the steps after "Reloading MySQL User Table" are : >> - Testing database connection to db_nagiosql_v3 >> - Writing global settings to database >> - Writing database configuration to settings php >> - Set Initial NagiosQL Administrator >> - Import Nagios sample data >> >> >> Any idea ? >> Thanks >> >> Marco >> >> >> -----Messaggio originale----- >> Da: Giorgio Zarrelli [mailto:zarrelli@...] >> Inviato: venerd 22 aprile 2011 14:16 >> A: Nagios Users List >> Oggetto: Re: [Nagios-users] error in nagiosql install >> >> Hi, >> >> mysql.servers does not exist: >> >> mysql> use mysql >> Reading table information for completion of table and column names >> You can turn off this feature to get a quicker startup with -A >> >> Database changed >> mysql> show tables; >> +---------------------------+ >> | Tables_in_mysql | >> +---------------------------+ >> | columns_priv | >> | db | >> | func | >> | help_category | >> | help_keyword | >> | help_relation | >> | help_topic | >> | host | >> | proc | >> | procs_priv | >> | tables_priv | >> | time_zone | >> | time_zone_leap_second | >> | time_zone_name | >> | time_zone_transition | >> | time_zone_transition_type | >> | user | >> +---------------------------+ >> 17 rows in set (0.00 sec) >> >> Try to go on anyway. You can manually create a user, pass and db and >> the find, among the installation files, the one holding the db and >> load it. >> >> >> <quota chi="Marco Borsani"> >>> >>> >>> Hi all >>> >>> >>> >>> During the nagiosQL 3.1.1 install I have this page with one error: >>> >>> >>> >>> NagiosQL Installation: Finishing Setup >>> >>> >>> >>> Create new NagiosQL database >>> >>> 1. MySQL server connection (privileged user) >>> passed >>> >>> 2. MySQL server version >>> 5.1.56 >>> >>> 3. MySQL server support >>> supported >>> >>> 4. Delete existing NagiosQL database db_nagiosql_v3 >>> done >>> >>> 5. Creating new database db_nagiosql_v3 >>> done >>> >>> 6. Create NagiosQL MySQL user >>> done >>> >>> 7. Update MySQL permissions >>> done >>> >>> 8. Reloading MySQL User Table >>> failed ( Table 'mysql.servers' doesn't exist ) >>> >>> Any idea ? >>> >>> Regards >>> >>> Marco >>> >>> -------------------------------------------------------------------- >>> - >>> - >>> -------- >>> Fulfilling the Lean Software Promise Lean software platforms are now >>> widely adopted and the benefits have been demonstrated beyond >>> question. Learn why your peers are replacing JEE containers with >>> lightweight application servers - and what you can gain from the >>> move. >>> http://p.sf.net/sfu/vmware-sfemails_________________________________ >>> _ >>> _ >>> ____________ >>> Nagios-users mailing list >>> Nagios-users@... >>> https://lists.sourceforge.net/lists/listinfo/nagios-users >>> ::: Please include Nagios version, plugin version (-v) and OS when >>> reporting any issue. >>> ::: Messages without supporting info will risk being sent to >>> /dev/null >> >> >> >> --------------------------------------------------------------------- >> - >> ------ >> -- >> Fulfilling the Lean Software Promise >> Lean software platforms are now widely adopted and the benefits have >> been demonstrated beyond question. Learn why your peers are replacing >> JEE containers with lightweight application servers - and what you >> can gain from the move. http://p.sf.net/sfu/vmware-sfemails >> _______________________________________________ >> Nagios-users mailing list >> Nagios-users@... >> https://lists.sourceforge.net/lists/listinfo/nagios-users >> ::: Please include Nagios version, plugin version (-v) and OS when >> reporting any issue. >> ::: Messages without supporting info will risk being sent to /dev/null >> > > |