Re: [Bacula-users] After bscan how to restore?
Well I don't know quite how, but it unexpectedly worked on the umpteenth attempt and I have now restored all my data. Yippee! Thank you Bacula. > On 07/08/2023 18:33 Graham Dicker via Bacula-users > wrote: > > > Hi all > > After doing a bscan on the volume I want to restore I see all the files I > want > to restore in the File table but restore never seems to finish building the > directory tree. Is that because the VolFiles figure in the Pool table entry > is 0? I did bscan again with the -m and without the -s option but it didn't > update the file count. Is that because I made the volume read-only? Is there > any way I can see what the building the directory tree is doing e.g. some > verbose or debug option? I left it running for about 6 hours yesterday but it > did not finish. > > Thanks > > Graham___ > Bacula-users mailing list > Bacula-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/bacula-users ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] After bscan how to restore?
Hi all After doing a bscan on the volume I want to restore I see all the files I want to restore in the File table but restore never seems to finish building the directory tree. Is that because the VolFiles figure in the Pool table entry is 0? I did bscan again with the -m and without the -s option but it didn't update the file count. Is that because I made the volume read-only? Is there any way I can see what the building the directory tree is doing e.g. some verbose or debug option? I left it running for about 6 hours yesterday but it did not finish. Thanks Graham signature.asc Description: This is a digitally signed message part. ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Problem with grant_mysql_privileges
On Thursday, 3 August 2023 15:39:26 BST Phil Stracchino wrote:
> On 8/3/23 04:05, Graham Dicker via Bacula-users wrote:
> > On Thursday, 3 August 2023 08:35:39 BST Graham Dicker via Bacula-users
wrote:
> >> On Wednesday, 2 August 2023 17:21:49 BST Phil Stracchino wrote:
> >>> On 8/2/23 11:12, Graham Dicker via Bacula-users wrote:
> >>>> Hello
> >>>>
> >>>> I am installing Bacula 13.0.2 on Opensuse 15.5 and get this problem
> >>>> when
> >>>> I
> >>>> run grant_mysql_privileges:
> >>>>
> >>>> ERROR 1064 (42000) at line 3: You have an error in your SQL syntax;
> >>>> check
> >>>> the manual that corresponds to your MariaDB server version for the
> >>>> right
> >>>> syntax to use near '%{db_user}@"%"' at line 1
> >>>>
> >>>> Database version 10.6.14-MariaDB
> >>>>
> >>>> I guess it's complaining about the statement
> >>>>
> >>>> db_user=${db_user:-bacula}
> >>>>
> >>>> Can anyone help with this please?
> >>>
> >>> What does the line 'echo "Created MySQL database user: ${db_user}"'
> >>> report as the value of ${db_user}?
> >>
> >> It reports just the single word bacula
> >>
> >> Graham
> >
> > It doesn't actually create the user bacula either although when I run the
> > script it says it has created it.
>
> Martin is correct that the second GRANT line is incorrect, it should be
> ${db_user} not %{db_user}
>
> Try doing this yourself manually. It's not complex. You know your
> MariaDB superuser password I assume. Log into MariaDB and run the
> following commands:
>
>
> GRANT ALL PRIVILEGES ON bacula@'HOST' IDENTIFIED BY "password goes here";
> GRANT PROCESS ON *.* TO bacula@'HOST';
> FLUSH PRIVILEGES;
>
>
> HOST here can be one of several things. The script uses '%', a wildcard
> meaning 'any host'. If your DB runs on the same host as your Director
> and will not be accessed from anywhere else, it would be more secure to
> use 'localhost' there. Or if you have a subnet behind a firewall and
> want to allow access from a range of hosts or all of your hosts, you can
> use something like bacula@'1.2.3.%'.
>
>
> Report any errors.
Yay!! It's working. Thanks very much Phil for your help. Much appreciated.
Graham
signature.asc
Description: This is a digitally signed message part.
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Problem with grant_mysql_privileges
On Thursday, 3 August 2023 08:35:39 BST Graham Dicker via Bacula-users wrote:
> On Wednesday, 2 August 2023 17:21:49 BST Phil Stracchino wrote:
> > On 8/2/23 11:12, Graham Dicker via Bacula-users wrote:
> > > Hello
> > >
> > > I am installing Bacula 13.0.2 on Opensuse 15.5 and get this problem when
> > > I
> > > run grant_mysql_privileges:
> > >
> > > ERROR 1064 (42000) at line 3: You have an error in your SQL syntax;
> > > check
> > > the manual that corresponds to your MariaDB server version for the right
> > > syntax to use near '%{db_user}@"%"' at line 1
> > >
> > > Database version 10.6.14-MariaDB
> > >
> > > I guess it's complaining about the statement
> > >
> > > db_user=${db_user:-bacula}
> > >
> > > Can anyone help with this please?
> >
> > What does the line 'echo "Created MySQL database user: ${db_user}"'
> > report as the value of ${db_user}?
>
> It reports just the single word bacula
>
> Graham
It doesn't actually create the user bacula either although when I run the
script it says it has created it.
signature.asc
Description: This is a digitally signed message part.
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Problem with grant_mysql_privileges
On Wednesday, 2 August 2023 17:21:49 BST Phil Stracchino wrote:
> On 8/2/23 11:12, Graham Dicker via Bacula-users wrote:
> > Hello
> >
> > I am installing Bacula 13.0.2 on Opensuse 15.5 and get this problem when I
> > run grant_mysql_privileges:
> >
> > ERROR 1064 (42000) at line 3: You have an error in your SQL syntax; check
> > the manual that corresponds to your MariaDB server version for the right
> > syntax to use near '%{db_user}@"%"' at line 1
> >
> > Database version 10.6.14-MariaDB
> >
> > I guess it's complaining about the statement
> >
> > db_user=${db_user:-bacula}
> >
> > Can anyone help with this please?
>
> What does the line 'echo "Created MySQL database user: ${db_user}"'
> report as the value of ${db_user}?
It reports just the single word bacula
Graham
signature.asc
Description: This is a digitally signed message part.
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Problem with grant_mysql_privileges
Hello
I am installing Bacula 13.0.2 on Opensuse 15.5 and get this problem when I run
grant_mysql_privileges:
ERROR 1064 (42000) at line 3: You have an error in your SQL syntax; check the
manual that corresponds to your MariaDB server version for the right syntax to
use near '%{db_user}@"%"' at line 1
Database version 10.6.14-MariaDB
I guess it's complaining about the statement
db_user=${db_user:-bacula}
Can anyone help with this please?
Graham Dicker
signature.asc
Description: This is a digitally signed message part.
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] How to verify downloaded Bacula files
On Tuesday, 1 August 2023 10:20:46 BST Graham Dicker via Bacula-users wrote: > On Monday, 31 July 2023 22:44:15 BST Bill Arlofski via Bacula-users wrote: > > On 7/31/23 01:42, GRAHAM DICKER via Bacula-users wrote: > > > I find I have reasons to wantto verify if the gzip file I have > > > downloaded > > > is the right file. I downloaded the gzip file for Bacula 11.0.6 and the > > > signature file. But the instructions I have been following to verify the > > > file say that I should compare the fingerprint with that given on the > > > web > > > site. I can't find it on the web site. Does anyone know where I can find > > > it? Also, how do I unsubscribe my old email address? I now get two > > > copies > > > of each posting. I can recieve but not send from the old address. > > > > > > Thank you > > > > > > Graham Dicker > > > > Hello Graham, > > > > Why not just clone the Git repository? > > > > Git takes care of all of the gory details automatically. > > > > Plus you get the added benefit of having the latest version 13.0.3... > > > > > > Best regards, > > Bill > > > > -- > > Bill Arlofski > > w...@protonmail.com > > Hi Bill > That's a jolly good idea. I am trying that. I'm not familiar with the > cloning of a repository so I downloaded > bacula-community-Release-13.0.2.tar.gz from > https://gitlab.bacula.org/bacula-community-edition/bacula-community/-/ > releases. I hope that amounts to the same thing. Another funny thing: on > Opensuse I always need to edit the database creation scripts to add a > switch to tell mysql where the socket is. This seems to be because akonadi > likes to have it in /run/user/1000/akonadi and arguing with akonadi in the > past has always proved fruitless for me. If anyone knows how to avoid > having to edit the scripts I would be very grateful for the information. > Thanks > Graham Oops! Ignore all that about the socket. I've just realised I have been doing it all wrong for at least the last five years! Cheers G signature.asc Description: This is a digitally signed message part. ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] How to verify downloaded Bacula files
On Monday, 31 July 2023 22:44:15 BST Bill Arlofski via Bacula-users wrote: > On 7/31/23 01:42, GRAHAM DICKER via Bacula-users wrote: > > I find I have reasons to wantto verify if the gzip file I have downloaded > > is the right file. I downloaded the gzip file for Bacula 11.0.6 and the > > signature file. But the instructions I have been following to verify the > > file say that I should compare the fingerprint with that given on the web > > site. I can't find it on the web site. Does anyone know where I can find > > it? Also, how do I unsubscribe my old email address? I now get two copies > > of each posting. I can recieve but not send from the old address. > > > > Thank you > > > > Graham Dicker > > Hello Graham, > > Why not just clone the Git repository? > > Git takes care of all of the gory details automatically. > > Plus you get the added benefit of having the latest version 13.0.3... > > > Best regards, > Bill > > -- > Bill Arlofski > w...@protonmail.com Hi Bill That's a jolly good idea. I am trying that. I'm not familiar with the cloning of a repository so I downloaded bacula-community-Release-13.0.2.tar.gz from https://gitlab.bacula.org/bacula-community-edition/bacula-community/-/ releases. I hope that amounts to the same thing. Another funny thing: on Opensuse I always need to edit the database creation scripts to add a switch to tell mysql where the socket is. This seems to be because akonadi likes to have it in /run/user/1000/akonadi and arguing with akonadi in the past has always proved fruitless for me. If anyone knows how to avoid having to edit the scripts I would be very grateful for the information. Thanks Graham signature.asc Description: This is a digitally signed message part. ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] How to verify downloaded Bacula files
On Monday, 31 July 2023 13:33:01 BST Martin Simmons wrote: > I think the keys/fingerprints are here (from the DOWNLOADS menu on > https://www.bacula.org/): > https://www.bacula.org/bacula-distribution-verification-public-keys/ I see the Bacula Distribution Verification Public Keys but no mention of a fingerprint. > > To unsubscribe, see the List-Unsubscribe link in the email headers (or > https://www.bacula.org/support/email-lists/). If I unsubscribe using the link in the emails, it sends a message using my current email address, not the old one. I need to find out how to email the moderator. I thought I would try to do the verification anyway. I did this: graham@localhost:~/Documents/bacula11> gpg --import Bacula-4096-Distribution- Verification-key.asc graham@localhost:~/Documents/bacula11> gpg --verify bacula-11.0.6.tar.gz.sig bacula-11.0.6.tar.gz gpg: Signature made Thu 10 Mar 2022 15:58:02 GMT gpg:using RSA key 5235F5B668D81DB61704A82DC0BE2A5FE9DF3643 gpg:issuer "k...@bacula.org" gpg: Good signature from "Bacula 4096 Distribution Verification Key (www.bacula.org) " [unknown] gpg: WARNING: This key is not certified with a trusted signature! gpg: There is no indication that the signature belongs to the owner. Primary key fingerprint: 5235 F5B6 68D8 1DB6 1704 A82D C0BE 2A5F E9DF 3643 I don't know if this means anything. Did it validate the file or not? All is deeply unclear and mysterious Graham > > __Martin > > >>>>> On Mon, 31 Jul 2023 08:42:22 +0100 (BST), GRAHAM DICKER via Bacula- users said: > > I find I have reasons to wantto verify if the gzip file I have downloaded > > is the right file. I downloaded the gzip file for Bacula 11.0.6 and the > > signature file. But the instructions I have been following to verify the > > file say that I should compare the fingerprint with that given on the > > web site. I can't find it on the web site. Does anyone know where I can > > find it? > > > > Also, how do I unsubscribe my old email address? I now get two copies of > > each posting. I can recieve but not send from the old address. > > > > > > > > Thank you > > > > > > > > Graham Dicker > > ___ > Bacula-users mailing list > Bacula-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/bacula-users signature.asc Description: This is a digitally signed message part. ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] How to verify downloaded Bacula files
I find I have reasons to wantto verify if the gzip file I have downloaded is the right file. I downloaded the gzip file for Bacula 11.0.6 and the signature file. But the instructions I have been following to verify the file say that I should compare the fingerprint with that given on the web site. I can't find it on the web site. Does anyone know where I can find it? Also, how do I unsubscribe my old email address? I now get two copies of each posting. I can recieve but not send from the old address. Thank you Graham Dicker ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
