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.
I
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 hop
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 c
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.
Go
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
'bacul
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 can
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 volume
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 = 33
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 (HY000):
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 crea
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 mysql.us
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
User='bacu
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) :
> > . +-+---+
> > . | Us
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 somet
20 matches
Mail list logo