Editing the ZLM Database to Change Custom Targets
Novell Cool Solutions: Tip
By Lothar Haeger
Digg This -
Posted: 17 May 2007
ENVIRONMENT: ZENworks Linux Management 7.x
PROBLEM: In ZLM 7.x default platform targets cannot be disabled, but slow down certain operations significantly, even if completely unused.
Also after an upgrade from ZLM 7.0 to ZLM 7.2, SLES/SLED custom targets remain to be "custom defined", even though SLES/SLED are now standard target platforms. This tip shows how to edit the ZLM database to change the above settings that are not accessible through the UI.
SOLUTION: You'll need a Windows PC and MS Access or something similar:
- Get the postgressl ODBC driver from http://www.postgresql.org/ftp/odbc/versions/
- In Windows, define a DSN that points to the database "zenworks" on your ZLM server. As username specify "zenadmin", take the password from /etc/opt/novell/zenworks/secret
- Connect to the DB (e.g. using MS Access) and edit columns "enabled" and/or "userdefined" in table "public.os_targets" according to your needs.
- Open ZCC - Configuration - Platform and verify the new settings
If you have any questions you may contact Lothar at lothar.haeger@TAKETHISOUTsteria-mummert.de
Novell Cool Solutions (corporate web communities) are produced by WebWise Solutions. www.webwiseone.com