On Sun, 16 Dec 2012, Bjørn T Johansen wrote:
I just thought I would check if this was a known problem first..
And it seems to be that it should have been, but it might have
been fixed in a later version...
The error text is pretty concrete -- Postgresql doesn't have the
FROM_UNIXTIME() function. Are you declaring MySQL or Postgres in
your ido2db.cfg file?
I took a quick search and that function seems to be a function that
MySQL has and PGSQL has not.. But I also find a funtion that I could
add to make PGSQL support the from_unixtime funtion and it seems to
be working....
If there is an addition to the Postgres package to add the
FROM_UNIXTIME() function (and UNIX_TIMESTAMP()) then it's a matter
of adding it to the Postgres environment. If that's the case, please
post details of it. A documentation case may need to be created to
showcase that and call it to folks' attention.
Cheers!
+------------------------------------------------+---------------------+
| Carl Richard Friend (UNIX Sysadmin) | West Boylston |
| Minicomputer Collector / Enthusiast | Massachusetts, USA |
| mailto:crfri...@rcn.com +---------------------+
| http://users.rcn.com/crfriend/museum | ICBM: 42:22N 71:47W |
+------------------------------------------------+---------------------+
------------------------------------------------------------------------------
LogMeIn Rescue: Anywhere, Anytime Remote support for IT. Free Trial
Remotely access PCs and mobile devices and provide instant support
Improve your efficiency, and focus on delivering more value-add services
Discover what IT Professionals Know. Rescue delivers
http://p.sf.net/sfu/logmein_12329d2d
_______________________________________________
icinga-users mailing list
icinga-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/icinga-users
