Hi all, what databases does Beaker support? I had the impression that it should support MySQL and PostgreSQL to name a few but with Postgre I keep getting errors.
When you import a distro in Cobbler and then run the osversion.trigger script on the beaker-server I get this error:
ProgrammingError: (ProgrammingError) function min(boolean) does not exist at character 639 HINT: No function matches the given name and argument types. You might need to add explicit type casts. 'SELECT watchdog.id AS watchdog_id, watchdog.system_id AS watchdog_system_id, watchdog.recipe_id AS watchdog_recipe_id, watchdog.recipetask_id AS watchdog_recipetask_id, watchdog.subtask AS watchdog_subtask, watchdog.kill_time AS watchdog_kill_time \nFROM watchdog JOIN system ON system.id = watchdog.system_id JOIN recipe ON recipe.id = watchdog.recipe_id JOIN recipe_set ON recipe_set.id = recipe.recipe_set_id \nWHERE %(param_1)s = system.lab_controller_id AND recipe_set.id IN (SELECT recipe_set.id \nFROM watchdog JOIN recipe ON recipe.id = watchdog.recipe_id JOIN recipe_set ON recipe_set.id = recipe.recipe_set_id GROUP BY recipe_set.id \nHAVING min(watchdog.kill_time <= %(kill_time_1)s)) ORDER BY watchdog.id' {'kill_time_1': datetime.datetime(2011, 4, 15, 18, 10, 26, 66766), 'param_1': 1} 2011-04-15 21:10:26,097 bkr.server.xmlrpccontroller ERROR Error handling XML-RPC method
The offending part I think is HAVING min(watchdog.kill_time <= %(kill_time_1)s))
Regards, Alexander.