On 12/28/21 11:33, Graham Dicker wrote:
Looking good. A full backup completed and make_catalog_backup performed
flawlessly, which was the original problem. All done manually. Tomorrow
morning it'll be back on automatic and I have every expectation that when I
finish breakfast there will be
On 2021-12-28 17:33, Graham Dicker wrote:
Looking good. A full backup completed and make_catalog_backup performed
flawlessly, which was the original problem. All done manually. Tomorrow
morning it'll be back on automatic and I have every expectation that
when I
finish breakfast there will be
Looking good. A full backup completed and make_catalog_backup performed
flawlessly, which was the original problem. All done manually. Tomorrow
morning it'll be back on automatic and I have every expectation that when I
finish breakfast there will be emails waiting for me reporting successful
On 2021-12-28 14:18, Graham Dicker wrote:
On Tuesday, 28 December 2021 12:03:05 GMT Josip Deanovic wrote:
> Is dropping user bacula the action that emptied all the Bacula tables
> of data?
> I know very little about the behaviour of mysql. Anyway, the tables
> were still
> there but empty so I
On Tuesday, 28 December 2021 12:03:05 GMT Josip Deanovic wrote:
> > Is dropping user bacula the action that emptied all the Bacula tables
> > of data?
> > I know very little about the behaviour of mysql. Anyway, the tables
> > were still
> > there but empty so I created a new volume and Bacula is
On 2021-12-28 12:41, Graham Dicker wrote:
On Tuesday, 28 December 2021 11:21:19 GMT Josip Deanovic wrote:
Could send the output of this command:
mysql -u root -e "show databases; show variables where
variable_name='datadir' or variable_name='socket';"
This will output all your databases and
On Tuesday, 28 December 2021 11:21:19 GMT Josip Deanovic wrote:
> Could send the output of this command:
>
> mysql -u root -e "show databases; show variables where
> variable_name='datadir' or variable_name='socket';"
>
>
> This will output all your databases and in addition, it will
> output
On 2021-12-28 11:20, Graham Dicker wrote:
On Tuesday, 28 December 2021 09:31:46 GMT Josip Deanovic wrote:
Could you please send the output of this command:
ps auxww | grep -i mysql
Yes of course - see below. But the mariadb service actually starts on
boot.
akonadi doesn't start at all until
On Tuesday, 28 December 2021 09:31:46 GMT Josip Deanovic wrote:
> On 2021-12-28 10:23, Graham Dicker wrote:
> > On Monday, 27 December 2021 18:56:32 GMT Phil Stracchino wrote:
> >> On 12/27/21 13:38, Graham Dicker wrote:
> >> > On Monday, 27 December 2021 18:19:23 GMT Phil Stracchino wrote:
> >> >
On Monday, 27 December 2021 19:47:40 GMT Josip Deanovic wrote:
> On 2021-12-27 19:38, Graham Dicker wrote:
> > On Monday, 27 December 2021 18:19:23 GMT Phil Stracchino wrote:
> >> On 12/27/21 12:10, Josip Deanovic wrote:
> >> > On 2021-12-27 14:24, Graham Dicker wrote:
> >> >> I can't get those
On 2021-12-28 10:23, Graham Dicker wrote:
On Monday, 27 December 2021 18:56:32 GMT Phil Stracchino wrote:
On 12/27/21 13:38, Graham Dicker wrote:
> On Monday, 27 December 2021 18:19:23 GMT Phil Stracchino wrote:
> > The blazes? If mysql.user is a VIEW, something is VERY BADLY
> > WRONG.
On Monday, 27 December 2021 18:56:32 GMT Phil Stracchino wrote:
> On 12/27/21 13:38, Graham Dicker wrote:
> > On Monday, 27 December 2021 18:19:23 GMT Phil Stracchino wrote:
> > > The blazes? If mysql.user is a VIEW, something is VERY BADLY
> > > WRONG.
> > > Are you still using Akonadi's
On 2021-12-27 21:07, Dmitri Maziuk wrote:
On 12/27/2021 2:02 PM, Josip Deanovic wrote:
On 2021-12-27 19:19, Phil Stracchino wrote:
...
The blazes? If mysql.user is a VIEW, something is VERY BADLY
WRONG.
Are you still using Akonadi's MySQL instance?
Yes, that doesn't look normal.
On 12/27/21 15:07, Dmitri Maziuk wrote:
On 12/27/2021 2:02 PM, Josip Deanovic wrote:
On 2021-12-27 19:19, Phil Stracchino wrote:
...
The blazes? If mysql.user is a VIEW, something is VERY BADLY WRONG.
Are you still using Akonadi's MySQL instance?
Yes, that doesn't look normal.
I
On 2021-12-27 21:01, Dmitri Maziuk wrote:
Thank you, I learned something today (not that I wanted to: I try to
stay away from that POS as much as I can, but that doesn't work 100%).
Now I know why you had to grant to both 'root'@'localhost' and
'root'@'127.0.0.1' -- in addition to 'root'@'%' of
On 12/27/2021 2:02 PM, Josip Deanovic wrote:
On 2021-12-27 19:19, Phil Stracchino wrote:
...
The blazes? If mysql.user is a VIEW, something is VERY BADLY WRONG.
Are you still using Akonadi's MySQL instance?
Yes, that doesn't look normal.
I hope it's not something Suse specific.
On 2021-12-27 19:19, Phil Stracchino wrote:
On 12/27/21 12:10, Josip Deanovic wrote:
On 2021-12-27 14:24, Graham Dicker wrote:
I can't get those commands to work
MariaDB [mysql]> CREATE USER 'bacula'@'localhost' IDENTIFIED BY
'xxx';
ERROR 1396 (HY000): Operation CREATE USER failed for
On 12/27/2021 1:44 PM, Josip Deanovic wrote:
'localhost' and '%' are special keywords.
'localhost' applies only to unix socket.
'%' has a meaning of any AF_INTET socket (any IP address or host)
So, the '%' does not include 'localhost'.
Thank you, I learned something today (not that I wanted
On 2021-12-27 19:56, Phil Stracchino wrote:
On 12/27/21 13:38, Graham Dicker wrote:
On Monday, 27 December 2021 18:19:23 GMT Phil Stracchino wrote:
> The blazes? If mysql.user is a VIEW, something is VERY BADLY
WRONG.
> Are you still using Akonadi's MySQL instance?
Not as far as I
On 2021-12-27 19:38, Graham Dicker wrote:
On Monday, 27 December 2021 18:19:23 GMT Phil Stracchino wrote:
On 12/27/21 12:10, Josip Deanovic wrote:
> On 2021-12-27 14:24, Graham Dicker wrote:
>> I can't get those commands to work
>>
>> MariaDB [mysql]> CREATE USER 'bacula'@'localhost' IDENTIFIED
On 2021-12-27 19:28, Dmitri Maziuk wrote:
On 12/27/2021 7:24 AM, Graham Dicker wrote:
...
If I change the Catalog definition from
dbname = "bacula"; dbuser = "bacula"; dbpassword = ""
to
dbname = "bacula"; dbuser = "root"; dbpassword = ""
then Bacula does work but it doesn't "see" the
On 12/27/21 13:38, Graham Dicker wrote:
On Monday, 27 December 2021 18:19:23 GMT Phil Stracchino wrote:
> The blazes? If mysql.user is a VIEW, something is VERY BADLY WRONG.
> Are you still using Akonadi's MySQL instance?
Not as far as I can tell. I changed /etc/my.cnf to say:
port =
On Monday, 27 December 2021 18:19:23 GMT Phil Stracchino wrote:
> On 12/27/21 12:10, Josip Deanovic wrote:
> > On 2021-12-27 14:24, Graham Dicker wrote:
> >> I can't get those commands to work
> >>
> >> MariaDB [mysql]> CREATE USER 'bacula'@'localhost' IDENTIFIED BY 'xxx';
> >> ERROR 1396
On 12/27/2021 7:24 AM, Graham Dicker wrote:
...
If I change the Catalog definition from
dbname = "bacula"; dbuser = "bacula"; dbpassword = ""
to
dbname = "bacula"; dbuser = "root"; dbpassword = ""
then Bacula does work but it doesn't "see" the volumes already in the database
and wants
to
On 12/27/21 12:10, Josip Deanovic wrote:
On 2021-12-27 14:24, Graham Dicker wrote:
I can't get those commands to work
MariaDB [mysql]> CREATE USER 'bacula'@'localhost' IDENTIFIED BY 'xxx';
ERROR 1396 (HY000): Operation CREATE USER failed for
'bacula'@'localhost'
MariaDB [mysql]> UPDATE
On 2021-12-27 14:24, Graham Dicker wrote:
I can't get those commands to work
MariaDB [mysql]> CREATE USER 'bacula'@'localhost' IDENTIFIED BY 'xxx';
ERROR 1396 (HY000): Operation CREATE USER failed for
'bacula'@'localhost'
MariaDB [mysql]> UPDATE mysql.user SET Host='localhost' WHERE
On Monday, 27 December 2021 12:34:32 GMT Josip Deanovic wrote:
> On 2021-12-27 12:55, Graham Dicker wrote:
> > I tried (while running mysql as root)
> > MariaDB [(none)]> UPDATE mysql.db SET Host='localhost' WHERE
> > User='bacula';
> >
> > that worked OK
> >
> > but this didn't
> >
> > MariaDB
I can't get those commands to work
*vivaldi:/home/graham #* mysql -u root
*Welcome to the MariaDB monitor. Commands end with ; or \g.*
*Your MariaDB connection id is 30*
*Server version: 10.5.13-MariaDB MariaDB package*
*Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.*
On 2021-12-27 12:55, Graham Dicker wrote:
I tried (while running mysql as root)
MariaDB [(none)]> UPDATE mysql.db SET Host='localhost' WHERE
User='bacula';
that worked OK
but this didn't
MariaDB [(none)]> UPDATE mysql.user SET Host='localhost' WHERE
User='bacula';
ERROR 1356 (HY000): View
On Monday, 27 December 2021 10:16:38 GMT Josip Deanovic wrote:
> On 2021-12-27 10:34, Graham Dicker wrote:
> [...]
>
> > Thank you for the information.
> > mysql> select user, host from mysql.user;
> > returned the following (without the leading dots) :
> > . +-+---+
> > . |
On 2021-12-27 10:34, Graham Dicker wrote:
[...]
Thank you for the information.
mysql> select user, host from mysql.user;
returned the following (without the leading dots) :
. +-+---+
. | User| Host |
. +-+---+
. | bacula | % |
. |
On Sunday, 26 December 2021 17:19:15 GMT Phil Stracchino wrote:
> You say you can log into the mysql instance as root. Do this:
>
> mysql> select user, host from mysql.user;
>
> See if there is a bacula user or another such user that you created for
> your catalog database. You should see
On 12/26/21 12:59, Josip Deanovic wrote:
When using MySQL roles and grant statement to change privileges, the
command "flush privileges" is not necessary but it doesn't hurt.
When modifying mysql/user and similar tables then it is necessary to
issue "flush privileges" in order to re-read and
On 2021-12-26 18:19, Phil Stracchino wrote:
If so:
mysql> GRANT ALL PRIVILEGES ON bacula.* TO 'bacula'@'localhost' (or
whatever DB user you want bacula to connect as) IDENTIFIED BY 'bacula
password goes here';
mysql> FLUSH PRIVILEGES;
When using MySQL roles and grant statement to change
On 2021-12-26 13:47, Graham Dicker wrote:
Thank you Josip this is very helpful. I have restored everything I had
tinkered with back to what it was, that is:
Removed specification of port and socket from /etc/my.cnf
Removed specification of port and socket from bacula-dir.conf
both of this were
On 12/26/21 07:47, Graham Dicker wrote:
I see that my attempts to paste messages copied from a console window into an
email are not working as I expect. Trying again...The message above should
have read:
26-Dec 09:39 bacula-dir JobId 0: Fatal error: Could not open Catalog
"MyCatalog", database
On Sunday, 26 December 2021 10:42:58 GMT Graham Dicker wrote:
> On Saturday, 25 December 2021 17:18:56 GMT Josip Deanovic wrote:
> > On Friday 2021-12-24 13:32:42 Graham Dicker wrote:
> > > Thanks for the tip Phil, which I will bear in mind if I ever get Bacula
> > > working again as it should
On Sunday, 26 December 2021 10:42:58 GMT Graham Dicker wrote:
> On Saturday, 25 December 2021 17:18:56 GMT Josip Deanovic wrote:
> > On Friday 2021-12-24 13:32:42 Graham Dicker wrote:
> > > Thanks for the tip Phil, which I will bear in mind if I ever get Bacula
> > > working again as it should
On Saturday, 25 December 2021 17:18:56 GMT Josip Deanovic wrote:
> On Friday 2021-12-24 13:32:42 Graham Dicker wrote:
> > Thanks for the tip Phil, which I will bear in mind if I ever get Bacula
> > working again as it should (and has done for the past 10 years or more).
> > Up until about a year
On Friday 2021-12-24 13:32:42 Graham Dicker wrote:
> Thanks for the tip Phil, which I will bear in mind if I ever get Bacula
> working again as it should (and has done for the past 10 years or more).
> Up until about a year ago my workstation would boot itself up when
> woken by the motherboard
On Thursday 2021-12-23 14:42:12 Graham Dicker wrote:
> Hi all
>
> I'm running Bacula on a desk machine with OpenSuse 15.3 and Bacula
> 11.0.4.
>
> The make_catalog_backup command has stopped working following a complete
> loss and restore of my Bacula database.
> I don't know how the database
On Thursday 2021-12-23 13:04:13 Phil Stracchino wrote:
> On 12/23/21 11:19, Graham Dicker wrote:
> > Thank you for your reply Graham.
> >
> > I don't think Bacula itself has any problems, it is only the script
> > mysqldump that has a problem. The script is just supposed to create a
> > dump of
On Thursday, 23 December 2021 18:04:13 GMT Phil Stracchino wrote:
> On 12/23/21 11:19, Graham Dicker wrote:
> > Thank you for your reply Graham.
> >
> > I don't think Bacula itself has any problems, it is only the script
> > mysqldump that has a problem. The script is just supposed to create a
>
On 12/23/21 11:19, Graham Dicker wrote:
Thank you for your reply Graham.
I don't think Bacula itself has any problems, it is only the script mysqldump
that has a problem. The script is just supposed to create a dump of the
database and (if it is successful) then Bacula goes on to first back it
=" line of bacula-dir.conf, and check the script it
executes to make sure it has the credentials it needs.
Thanks.
--
Graham Sparks
From: Graham Dicker
Sent: 23 December 2021 16:19
To: bacula-users@lists.sourceforge.net
Subject: Re: [Bacula-users] make
-database-name.* to your-bacula-user
> identified by 'your-password';
>
> to ensure everything is set up correctly again.
>
>
> Thanks.
> --
> Graham Sparks
>
> ____________
> From: Graham Dicker
> Sent: 23 December 2021 14:51
> To: bacul
__
From: Graham Dicker
Sent: 23 December 2021 14:51
To: bacula-users@lists.sourceforge.net
Subject: [Bacula-users] make_catalog_backup stopped working
Further to my previous post I notice that the user table contains the
following. Is that what it should look like?
Oops I should have replied to my own message. And the leading pipe symbols
seem to cause a problem. Sorry about that.
MariaDB [mysql]> select host,user from user;
+---+-+
Host | User|
+---+-+
% | bacula |
localhost |
Further to my previous post I notice that the user table
contains the following. Is that what it should look like?
MariaDB [mysql]> select host,user from user;
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
Hi all
I'm running Bacula on a desk machine with OpenSuse 15.3 and Bacula 11.0.4.
The make_catalog_backup command has stopped working following a complete loss
and
restore of my Bacula database.
I don't know how the database vanished but I restored it from the last
successful backup
thus:
50 matches
Mail list logo