View Full Version : Zabbix 1.1.2 / PostgreSQL 7.4
agehring
03-10-2006, 00:18
During the install, the images from the 'data.sql' failed to load...
Ideas?
Thanks
James Wells
03-10-2006, 00:47
Greetings,
Usually, this is caused by the images not being in the location, the SQL tries to load them from, usually /home/zabbix/zabbix/create/data/images. Another possibility is that the Postgress user does not have permission to read the directory that the images are stored in.
During the install, the images from the 'data.sql' failed to load...
For some reason (pre-release mistake!) we didn't include proper image file for PostgreSQL into 1.1.2. Please wait for 1.1.3.
GateKeeper
04-10-2006, 07:33
Just replace sql queries in your data.sql (the last lines), which insert images into DB with ones like this (the first image):
INSERT INTO images VALUES (1,1,'Hub',decode('89504E470D0A1A0A0000000D4948445 2000000300000003008060000005702F98700000006624B474 400FF00FF00FFA0BDA7930000000774494D4507D1011F092B1 C4D0C91FA0000074A4944415478DAED994F6C53C91DC73FEFD 9982C90C4E06441254542D425DA82A0AC54B5DA1015417B58A A569538A1E5EF023D70415C9A13EA815E809CA844A51050B71 5A7802A552A69DA882A62D5A8A83D401C017622C85A2B48084 996D8CE7B7E33D30333D6C4D889D938660F1DC9CA3CC77E33D FDFEF3BBFDFF7FB0CFF1FEF76383558A3116805A2D67A5F675 D057C010CEB3900E11A0068EEE8E8F8D1A953A77EB56EDDBA5 6A514C52F29E5BCBF666EAE85103C7BF6ECAF6D6D6DBF071E0 30290B502E0EED9B3E707B158AC756464E47528F5068510F33 66FBF675ED96C96EDDBB7D3DCDCFC31F0195007CCE92CA8700 D28EAFABE8F9412805DBB76BDF54DB2D92C63636300F5C02A2 0D01910D502F0D3227E2BE0EF7AEE48295D137980E9CC0C424 AFCBC8F9FF7F17CAFEC8DBFFBEDEF009800AC06DE03B2800FE 0562BD2D96CB6776666A6B7A7A7E73610D1F47401574AE91A9 A00088BDF4A29A4523435C6888423AC5D192B7D825F835F09A C00422660E12AD124E4791E994C86AEAE2E749AEB80BC59C84 41FE0E18334D9598F7C10E0FB1E2DF1B5C4EA25134F32A4BD2 9C69E8FE17A11B6B76D2A7C470861021EB2B35D0D002E10EAE FEFA7ABAB8B44226152BD0AC8008E52CA31D106F8E0834DB84 E885028040AD22FD328A5581109313727914A125911B68A652 1004E710B0897E1F242F5DADCF66F368803070E7C924EA7FFD 4D2D27246473F02E4EC0C180AADAC8B100E87999C79C9FB6B9 B5193A6EA287C3FCFAB992C0D4D519485C0CEA03DC2A5B85CE EC300A9548A1D3B76FC5C7351E8B7FF01FCC2FAD8E7BA4A28B BE91800E35313B8AE8B528AB1675F309BCBD0B8BA11C77158B F611DD1B5F56CF8568C977313147F7721000E10524A91CD66E 72137809452DCBE7DDBAE0639BD51A94B1BBA46E7749510A5E E333E358E52AF3725A4201FE4711CD8F9619C874F1EB329DA4 C7AFC4B5CD7293E030B0230070480BD7BF772E8D0A17937387 CF830B3B3B3000D1A4400787AA30680AF41E44DB72CA6D09CE 7A1D0CD4C4A0211F060649807A9047911F0782C492004D9B9E C5B51C83100A494F4F5F5914C26B974E91267CF9E251E8FDB9 158AD793E6BD57D132201B45920C2BA9416A2D8FEFD8FDEBA5 25442A1425F30357ACB962D5CB972659E6EC9E7F3E803BAA25 41F49A7D37F30F3C1C1416EDDBAC5993367181C1C241E8FCFA 367A5E3FEFDFB150328A4EBFAF5EB0821104270F2E4C90200D FF7B12AD51B55AAA5A5E5533DCDEB6CB8C07BE3E3E3BF6E6A6 ADA323939F98650B3E7428837E6524A5EBC78415161500B023 872E44861D3B95C8E9191115A5B5B0D0D8AEBB12ABAFE97061 068001FEEDCB9F377376EDCF8A552AAFD6DA2BF71E3461289C 4E7A74F9FFEA775D64C3A4A8B39BBCD032493492E5EBCC8B56 BD7CAA6B2A84F041A405EBFF76FE07B070F1EFCB3D648753A7 8CE22DEC0443A0FA4800756D1289F0103C064A3B5B595EEEEE E425A1719422F624AA9D4C5E1BF5ACBD7EB2210D1D9590C80D 4F79905A675770FCA02989E9EE6F2E5CBDCBC79934824C2B66 DDB48A5520441C0F4F434E170B81200790D624E6FC0B1AE335 6062A1193A6C798FE92B369142EC5FFFEFE7E1A1A1AD8B0610 3C96412802008C8E572C4E3719E3E7D5AC9A2C27A61CD3DBD6 E68117BAB8A8212943803A529F4FCF9738410A45229EAEAEA9 052B266CD1A5CD7ADE40C94F3C48D465E57C0FD72541A5BD41 347A351EEDCB933AF7BDAE7E1FCF9F3DCBB77EF6D36D0DCD1D 1F1C32A7AE24756964B674008C1891327E8EAEAE2F8F1E3747 77773ECD831AE5EBD6A1FE2367DA88C3F2DC767A7E69E5829C 5D6AD5B1142146ABFB99652D2DEDEFEDB7DFBF6B17FFF7ED6A F5F5FFCF55051A3ABBD271642B07BF76E9452B4B5B5CDBB965 2323030F09B818181A973E7CEBDD2871220944EA73FD3005CD BD42FA7272EDB074CCDB7E742088220309AE93FC09495CE1F5 B9BB60D915389277E3FDAC4579957AC0ED533E54D2ECD13DB7 CF47DBF20E28220309B9056B7F5ADEE4BB189A9B927F63C8F0 B172E303434C4E6CD9B191D1DA5B7B797274F9ED0D7D7C7A34 78F8C509BD3A9CCEA0D7B56CD96A522580B4F2C63B1D851601 DD03034345407B88944C201542291905647359BCF59EA135BA 71403586E4FAC803EDD7062FA6F9DD5784C33990366B424F03 5759C125157E54CC9727962C36BE338B225F48A518639FD7F6 31B17D534B5F0C4E620E6F4C63225D4A2B28006B62A5CE0D17 DE1B9D0727B623B0BC2D4D94574BA2C2329F6E8B352734F4CA 90A5281D0B23DF11F6D51D8D9D9C9D1A34779F8F061ED3CF15 2C637C21357E161EFBBF5C44B1CEFDE132F71BC5B4FFC3529F 393A2453F026EEBA62796D313578BF31F673219353131A17A7 A7A14F009B0B628CA217DBD4A6721AA3FB3D82B6AF98048919 8AB5A065CDFF7F13C8FE1E1E1528F1E9525F28232DC5FC8D42 B2B1BAADA65D401DCD1D1513A3B3BB97BF7AE01F046B44A48E D4A012CB8F8524708F819B0460BC015BA6AFC451B9E9CFD3BC 172D4EC6A0058A97F3368D4734F2BD6AFACB2B72CA31A142A5 6B121BDE1EC2262EF1B930163F5C2567352965A95CB09E07F0 CFE0CEC102DF9950000000049454E44AE426082','hex'));