NDO2DB 1.4b4 field length problem

[Livio Zanol Puppim]

Thanks,
I've used an ALTER TABLE and my problem is now solved....

ALTER TABLE nagios_hosts CHANGE alias alias varchar(128) NOT NULL default
"";

I hope that fields will be bigger in new versions.


2007/10/17, Andreas Ericsson <ae at op5.se>:
>
> 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.monitoring-lists.org/archive/users/attachments/20071017/ae54def3/attachment.html>
-------------- next part --------------
-------------------------------------------------------------------------
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/
-------------- 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