Hello Neil, Thanks for reporting this problem here.
It looks that you are using PostgreSQL 12. I did a test on my side and I have noticed that the framework used in Baculum doesn't support PostgreSQL 12 yet. I have reported a feature request for that: https://github.com/pradosoft/prado/issues/708 To have Baculum working in your environment you can wait for new Baculum release or you can use a patch attached to the feature request above, or eventually you can use PostgreSQL version less than 12 if you want to do this effort. Best regards, Marcin Haba (gani) On Fri, 6 Mar 2020 at 21:39, Neil MacGregor <[email protected]> wrote: > > 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 Baculum 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 > [email protected] > https://lists.sourceforge.net/lists/listinfo/bacula-users -- "Greater love hath no man than this, that a man lay down his life for his friends." Jesus Christ "Większej miłości nikt nie ma nad tę, jak gdy kto życie swoje kładzie za przyjaciół swoich." Jezus Chrystus _______________________________________________ Bacula-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/bacula-users
