On Sun, 16 Dec 2012 20:39:23 +0100 Michael Friedrich <michael.friedr...@gmail.com> wrote:
> On 16.12.2012 20:29, Bjørn T Johansen wrote: > > I have just installed Icinga and I see a lot of these in my log...: > > > > Dec 16 03:32:38 gandalf ido2db: Error: database query failed for 'UPDATE > > icinga_programstatus SET status_update_time=FROM_UNIXTIME(1355625158), > > program_start_time=FROM_UNIXTIME(1355614426), is_currently_ > > running=1, process_id=20690, daemon_mode=1, > > last_command_check=FROM_UNIXTIME(1355625158), > > last_log_rotation=FROM_UNIXTIME(0), notifications_enabled=1, > > active_service_checks_enabled=1, passive_service_che > > cks_enabled=1, active_host_checks_enabled=1, passive_host_checks_enabled=1, > > event_handlers_enabled=1, flap_detection_enabled=1, > > failure_prediction_enabled=1, process_performance_data=0, obsess_over_hosts > > =0, obsess_over_services=0, modified_host_attributes=0, > > modified_service_attributes=0, global_host_event_handler=E'', > > global_service_event_handler=E'' WHERE instance_id=1' - 'ERROR: function > > from_unixti > > me(integer) does not exist#012LINE 1: ...PDATE icinga_programstatus SET > > status_update_time=FROM_UNIXT...#012 > > ^#012HINT: No function matches th > > e given name and argument types. You might need to add explicit type > > casts.#012' > > > > > > Is this a known bug or? How can I fix it? > > without any hints on version/os/src|pkg it will hard to guess. > furthermore, does from_unixtime exist in your icinga database as > accessible function? > > > > > > > Regards, > > > > BTJ > > > > 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... btw, I am running CentOS 6 and PGSQL 9.2 and Icinga 1.7.2 (the latest version in repoforge..) 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.... BTJ -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. ------------------------------------------------------------------------------ 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
