R: error in nagiosql install

[Marco Borsani]

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-per-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


------------------------------------------------------------------------------
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