R: R: R: error in nagiosql install

Thomas Anderson zelnaga at gmail.com
Wed Apr 27 06:12:51 CEST 2011
Previous message: R: R: error in nagiosql install
Next message: AUTO: Jason Shaffer is out of the office. (returning 05/02/2011)
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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 at ...]
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 at ...]
> 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 at ...> 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 at ...]
>> 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 at ...
>>> 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 at ...
>> 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
>>
>
>

------------------------------------------------------------------------------
WhatsUp Gold - Download Free Network Management Software
The most intuitive, comprehensive, and cost-effective network 
management toolset available today.  Delivers lowest initial 
acquisition cost and overall TCO of any competing solution.
http://p.sf.net/sfu/whatsupgold-sd
_______________________________________________
Nagios-users mailing list
Nagios-users at lists.sourceforge.net
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
Previous message: R: R: error in nagiosql install
Next message: AUTO: Jason Shaffer is out of the office. (returning 05/02/2011)
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Users mailing list