I'm evaluating Bacula for use in my organization. I am a n00b. Last week, I followed the instructions, performing a fresh install of Bacula v9.4.4 on new, fully patched CentOS7, via RPM's from the official repo. I'm happy to report this went VERY well; built from a new Ansible playbook. I've been using the text console - works great, backed up 377Gb in our Test environment, in 1h 18m, nice! Works with SELinux set to 'enforcing', too: wicked.
I'm aware that v9.6.2 of Bacula has *just* been released (but hasn't landed in the RPM repositories, yet). Perhaps this is an awkward time, as I'm finding a mix of new & old documentation. Today I've been fighting to install the Bacu*lum* GUI. I had to come here to the mailing list to find the updated documentation: https://www.bacula.org/9.6.x-manuals/en/console/Baculum_API_Web_GUI_Tools.html#SECTION00313000000000000000... Thanks, previous post. So, for the API, I can get all the panels with a "test" button to go OK/green, but when I finally get to the query panel eg http://localhost:9096/panel/, I get this error: { "output": "Internal error. TDbCommand failed to execute the query SQL \"\tSELECT conname, consrc, contype, indkey, indisclustered FROM (\n\t\t\tSELECT\n\t\t\t\t\tconname,\n\t\t\t\t\tCASE WHEN contype='f' THEN\n\t\t\t\t\t\t\tpg_catalog.pg_get_constraintdef(oid)\n\t\t\t\t\tELSE\n\t\t\t\t\t\t\t'CHECK (' || consrc || ')'\n\t\t\t\t\tEND AS consrc,\n\t\t\t\t\tcontype,\n\t\t\t\t\tconrelid AS relid,\n\t\t\t\t\tNULL AS indkey,/n \t\t\t\t\tFALSE AS indisclustered\n\t\t\tFROM\n\t\t\t\t\tpg_catalog.pg_constraint\n\t\t\tWHERE\n\t\t\t\t\tcontype IN ('f', 'c')\n\t\t\tUNION ALL\n\t\t\tSELECT\n\t\t\t\t\tpc.relname,\n\t\t\t\t\tNULL,\n\t\t\t\t\t CASE WHEN indisprimary THEN\n\t\t\t\t\t\t\t'p'\n\t\t\t\t\tELSE\n\t\t\t\t\t\t\t'u'\n\t\t\t\t\tEND,\n\t\t\t\t\tpi.indrelid,\n\t\t\t\t\tindkey,\n\t\t\t\t\tpi.indisclustered\n\t\t\tFROM\n\t\t\t\t\tpg_catalog.pg_class pc,\n\t\t\t\t\tpg_catalog.pg_index pi\n\t\t\tWHERE\n\t\t\t\t\tpc.oid=pi.indexrelid\n\t\t\t\t\tAND EXISTS (\n\t\t\t\t\t\t\tSELECT 1 FROM pg_catalog.pg_depend d JOIN pg_catalog.pg_constraint c\n\t\t\t\t\t\t\tON (d.refclassid = c.tableoid AND d.refobjid = c.oid)\n\t\t\t\t\t\t\tWHERE d.classid = pc.tableoid AND d.objid = pc.oid AND d.deptype = 'i' AND c.contype IN ('u', 'p')\n\t\t\t)\n\t) AS sub\n\tWHERE relid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table\n\t\t\t\t\tAND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace\n\t\t\t\t\tWHERE nspname=:schema))\n\tORDER BY\n\t\t\t1\": SQLSTATE[42703]: Undefined column: 7 ERROR: column \"consrc\" does not exist\nLINE 7: 'CHECK (' || consrc || ')'\n ^\n HINT: Perhaps you meant to reference the column \"pg_constraint.conkey\" or the column \"pg_constraint.conbin\".", "error": 1000 } Has anybody else run into this? (That's some wizard-level black magic SQL...) Am I doing something wrong? [root@bac-rec-test-1 ~]# rpm -qa | egrep 'bacula|baculum' | sort > bacula-libs-9.4.4-1.el7.x86_64 > bacula-postgresql-9.4.4-1.el7.x86_64 > baculum-api-9.6.2-1.el7.noarch > baculum-api-httpd-9.6.2-1.el7.noarch > baculum-api-selinux-9.6.2-1.el7.noarch > baculum-common-9.6.2-1.el7.noarch > baculum-web-9.6.2-1.el7.noarch > baculum-web-httpd-9.6.2-1.el7.noarch > baculum-web-selinux-9.6.2-1.el7.noarch > -- -Neil 780-492-3155 University of Alberta Libraries 4-30 Cameron Library
_______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
