Bug#289762: [Pkg-nagios-devel] Bug#289762: nagios-mysql bugs

[sean finney]

--45Z9DzgjV8m4Oswq
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

hi antonio,

On Tue, Jan 11, 2005 at 12:42:06PM +0100, Antonio J. Torres wrote:
> I've a similar problem after upgrade mysql server, I get:
>=20
> INSERT INTO programstatus=20
> (last_update,program_start,nagios_pid,daemon_mode,last_command_check,last=
_log_rotation,enable_notifications,execute_service_checks,accept_passive_se=
rvice_checks,enable_event_handlers,obsess_over_services,enable_flap_detecti=
on,enable_failure_prediction,process_performance_data)=20
> VALUES=20
> (FROM_UNIXTIME(1105433795),FROM_UNIXTIME(1105433780),'8225','0',FROM_UNIX=
TIME(1105433794),FROM_UNIXTIME(0),'1','1','1','1','0','0','1','0')

=66rom what i've read, the problem is that in the latest version of
mysql-server, the behavior of FROM_UNIXTIME() has changed, which is
what's causing this problem.

there were two suggestions i made to phillip (downgrading and trying the
nagios-mysql on my p.d.o page), could you try both of them and let us
know if they work?


	sean

--=20

--45Z9DzgjV8m4Oswq
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: Digital signature
Content-Disposition: inline

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)

iD8DBQFB4/9LynjLPm522B0RAnQzAJ4qBsDhK55Qo0D2+qw2BOYMTo2zUQCfQp40
Bxq8X0RI3eoPCJbbbdXQfdE=
=GKj8
-----END PGP SIGNATURE-----

--45Z9DzgjV8m4Oswq--