NagMIN Error

[Skip Montanaro]

    David> Is there a NagMIN list? Anyway, any suggestions are appreciated. 

yes, but it seems quiet.

    David> When I try to add a contact via NagMIN I receive an error.
    David> SQL insert into `Contact` values (NULL , 'dgitman' , 'David Gitman' , 'david at domain.com' , 'dgitman at domain.com' , NULL , NULL , NULL , NULL , NULL , NULL , NULL) failed :

I don't think the template column can be NULL.  MySQL tells me this about
the Contact table.  Note the lack of a "YES" in the Null column for the
template field.

    mysql> describe Contact;
    +-------------------------------+--------------+------+-----+--------...
    | Field                         | Type         | Null | Key | Default...
    +-------------------------------+--------------+------+-----+--------...
    | template                      | varchar(80)  |      |     |        ...
    | contact_name                  | varchar(80)  |      | PRI |        ...
    | alias                         | varchar(80)  |      |     |        ...
    | email                         | varchar(80)  | YES  |     | NULL   ...
    | pager                         | varchar(80)  | YES  |     | NULL   ...
    | service_notification_period   | varchar(80)  | YES  |     | NULL   ...
    | host_notification_period      | varchar(80)  | YES  |     | NULL   ...
    | service_notification_options  | varchar(20)  | YES  |     | NULL   ...
    | host_notification_options     | varchar(20)  | YES  |     | NULL   ...
    | service_notification_commands | varchar(80)  | YES  |     | NULL   ...
    | host_notification_commands    | varchar(80)  | YES  |     | NULL   ...
    | comment                       | varchar(255) | YES  |     | NULL   ...
    +-------------------------------+--------------+------+-----+--------...
    12 rows in set (0.00 sec)

and my Contact record looks like this:

    | template        | contact_name | alias          | email            ...
    +-----------------+--------------+----------------+------------------...
    | system-engineer | skip         | Skip Montanaro | s-montanaro at north...

-- 
Skip Montanaro
Got gigs? http://www.musi-cal.com/
Got spam? http://spambayes.sf.net/


-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
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