Thank you, Marcin, you were absolutely right. I wiped my install & started again with the default version of PostgreSQL, and it works perfectly. You went above and beyond the call on this one!
On Fri, Mar 6, 2020 at 8:52 PM Marcin Haba <[email protected]> wrote: > 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 > -- -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
