R: R: R: error in nagiosql install
Marco Borsani
m.borsani at it.net
Tue Apr 26 10:34:49 CEST 2011
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 linux.it]
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 linux.it]
> 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 it.net> 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 linux.it]
>> 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 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
>>
>>
>>
>> ---------------------------------------------------------------------
>> -
>> ------
>> --
>> 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 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
>>
>
>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: check.jpg
Type: image/jpeg
Size: 64798 bytes
Desc: not available
URL: <https://www.monitoring-lists.org/archive/users/attachments/20110426/712803c6/attachment.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Error.jpg
Type: image/jpeg
Size: 66318 bytes
Desc: not available
URL: <https://www.monitoring-lists.org/archive/users/attachments/20110426/712803c6/attachment-0001.jpg>
-------------- next part --------------
------------------------------------------------------------------------------
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
-------------- next part --------------
_______________________________________________
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
More information about the Users
mailing list