NDO2DB 1.4b4 field length problem

[Andreas Ericsson]

Livio Zanol Puppim wrote:
> Hi,
> 
> I'm having troubles with the fields length in the table "nagios_hosts". The
> "alias" field is not supporting all characters that is written at the config
> file.
> 
> I've checked the database an saw this definition for fields:
> | alias                                   | varchar(64)
> | display_name                      | varchar(64)
> | address                              | varchar(128)
> 
> Example:
> 
> The alias is like this at the config file:
> Superintendencia Regional de Educacao de Cachoeiro de Itapemim,500-0000,se
> 1/3.00,(28)xxxx-xxxx
> 
> At the database the same alias is showing this:
> Superintendencia Regional de Educacao de Cachoeiro de Itapemim,5
> 
> 
> Well, as you can see, the field has archived it's limit, and cannot store
> the entire alias. Is there anyway I can raise the field length so the alias
> is entirely stored at the database?

Just do an ALTER TABLE sql thingie. Google probably has ample material for you
to read.

> Is this corrected in new versions?
> 

I wouldn't bet on it, but you can always check.

-- 
Andreas Ericsson                   andreas.ericsson at op5.se
OP5 AB                             www.op5.se
Tel: +46 8-230225                  Fax: +46 8-230231

-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
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