Re: [Bacula-users] newbie: errors in baculum

2024-01-27 Thread Stefan G. Weichinger

Am 26.01.24 um 21:01 schrieb Marcin Haba:

Hello Stefan,

Yes, for PostgreSQL 15 you need this patch. It should still be valid.

At the moment Bacula GitLab stopped working so I am sending the patch
in attachment. It is a one line patch.

After applying it, the TDbCommand error should not occur anymore.


correct, thanks! Yours is a different patch than the one I had found.
GUI works now, I can proceed learning and configuring ...



___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] newbie: errors in baculum

2024-01-26 Thread Marcin Haba
Hello Stefan,

Yes, for PostgreSQL 15 you need this patch. It should still be valid.

At the moment Bacula GitLab stopped working so I am sending the patch
in attachment. It is a one line patch.

After applying it, the TDbCommand error should not occur anymore.

Good luck.

Best regards,
Marcin Haba (gani)

On Thu, 25 Jan 2024 at 13:45, Stefan G. Weichinger  wrote:
>
> seems I hit this:
>
> https://www.mail-archive.com/bacula-users@lists.sourceforge.net/msg72759.html
>
> Is it advised to use bacularis instead now?
>
>
> ___
> Bacula-users mailing list
> Bacula-users@lists.sourceforge.net
> 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
From 5ac1bbcd9c8d68b99f1a3569b7b7f7d95610f747 Mon Sep 17 00:00:00 2001
From: Marcin Haba 
Date: Mon, 3 Jul 2023 13:14:07 +0200
Subject: [PATCH] baculum: Improve support for newer PostgreSQL versions

This change is ported from Bacularis.
---
 .../prado/framework/Data/Common/Pgsql/TPgsqlMetaData.php| 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/gui/baculum/protected/vendor/pradosoft/prado/framework/Data/Common/Pgsql/TPgsqlMetaData.php b/gui/baculum/protected/vendor/pradosoft/prado/framework/Data/Common/Pgsql/TPgsqlMetaData.php
index 68a8bff5f..394a05ed6 100644
--- a/gui/baculum/protected/vendor/pradosoft/prado/framework/Data/Common/Pgsql/TPgsqlMetaData.php
+++ b/gui/baculum/protected/vendor/pradosoft/prado/framework/Data/Common/Pgsql/TPgsqlMetaData.php
@@ -297,7 +297,7 @@ EOD;
 			SELECT
 	conname,
 	pg_catalog.pg_get_constraintdef(oid) AS consrc,
-	contype,
+	CAST(contype AS text),
 	conrelid AS relid,
 	NULL AS indkey,
 	FALSE AS indisclustered
-- 
2.43.0

___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] newbie: errors in baculum

2024-01-25 Thread Stefan G. Weichinger

seems I hit this:

https://www.mail-archive.com/bacula-users@lists.sourceforge.net/msg72759.html

Is it advised to use bacularis instead now?


___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] newbie: errors in baculum

2024-01-25 Thread Stefan G. Weichinger

Am 25.01.24 um 11:58 schrieb Stefan G. Weichinger:


"Error code: 1000

Message: Internal error. TDbCommand failed to execute the query SQL " 
SELECT conname, consrc, contype, "


Googled that, unsure about it.



I find 
https://www.mail-archive.com/search?l=bacula-users@lists.sourceforge.net=subject:%22Re%5C%3A+%5C%5BBacula%5C-users%5C%5D+Baculum+api+installs%2C+but+throws+Error+1000%22=newest=1


but the linked PR/patch seems not to match exactly ... it's 3 yrs old so 
I assume it's not valid anymore in my environment.


This is PostgreSQL-15.5 (Debian 15.5-0+deb12u1)


___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] newbie: errors in baculum

2024-01-25 Thread Stefan G. Weichinger



greetings, bacula-users

I am a complete starter with bacula and test things in a Debian 12.4 
machine.


I can write to and read from tape already, using an autochanger ... 
looks good already.


I maybe have a "mixed" setup: at first I installed from the debian 
repos, then I found the specific bacula repos for Debian.


Which repos to use for bacula and bookworm?

I added baculum:

# cat /etc/apt/sources.list.d/baculum.list
deb http://www.bacula.org/downloads/baculum/stable-11/debian bullseye main
deb-src http://www.bacula.org/downloads/baculum/stable-11/debian 
bullseye main


and was able to set up API and web ... although in the baculum-GUI I get 
database-related errors like:


"Error code: 1000

Message: Internal error. TDbCommand failed to execute the query SQL " 
SELECT conname, consrc, contype, "


Googled that, unsure about it.

Do I maybe have a too old DB now, coming from bacula-9.6?
Is it compatible at all?

Should I somehow upgrade bacula?

Should I start from scratch?

pls advise, thanks in advance, Stefan


___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users