On 2017-03-13 at 16:07:35 Richard wrote:
> ------------ Original Message ------------
> > Date: Monday, March 13, 2017 15:34:04 +0100
> > From: "Erik P. Olsen" <epod...@gmail.com>
> >
> > On 2017-03-13 at 13:38:44 Richard wrote:
> >
> >> > Date: Monday, March 13, 2017 14:07:04 +0100
> >> > From: "Erik P. Olsen" <epod...@gmail.com>
> >> >
> >> > On 2017-03-13 at 12:40:52 Richard wrote:
> >> >
> >> >> If it shows a list of the ~25+ tables (likely ending with
> >> >> "Version"), then exit mysql/mariadb and (still as system root)
> >> >> run the "grant_mysql_privileges" script that's in your
> >> >> /usr/libexec/bacula/ directory.
> >> >
> >> > Yes, I see 26 rows ending with Version.
> >> >
> >> >>
> >> >> After doing that, then as a normal (non-root) system user, do:
> >> >>
> >> >> mysql -u bacula
> >> >>
> >> >> [i don't believe that a password is set, but you can look at
> >> >> the top of the grant script to confirm this.]
> >> >>
> >> >> show databases;
> >> >
> >> > Unfortunately does not show "bacula".
> >> >
> >>
> >>
> >> When you ran the "grant_mysql_privileges" script did it give a
> >> multi-column display of settings, with something like "Privileges
> >> for user ..." at the bottom? If so, could you confirm the user/db
> >> information on that line (you can rerun the script without having
> >> to take any other actions). If not, what type of output (if any)
> >> did you get?
> >
> > These are the first few lines:
> >
> > [root@Erik-PC bacula]# ./grant_mysql_privileges
> > Created MySQL database user: bacula
> > ERROR 1133 (28000) at line 2: Can't find any matching row in the
> > user table Host User Password Select_priv
> > Insert_priv Update_priv Delete_priv
> > Create_priv Drop_priv Reload_priv Shutdown_priv
> >
> > And this is the last:
> >
> > Privileges for user bacula granted on database bacula.
>
> To see if that last line is accurate or not (and whether that error
> is spurious), as root (either system or mysql), at the "MariaDB
> [(none)]>" prompt:
>
> use mysql;
> select * from user where User='bacula' \G
>
> [note, end that command with an uppercase "\G", that will display
> the output in a list, rather than a table.]
MariaDB [(none)]> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
MariaDB [mysql]> select * from user where User='bacula' \G
*************************** 1. row ***************************
Host: %
User: bacula
Password:
Select_priv: N
Insert_priv: N
Update_priv: N
Delete_priv: N
Create_priv: N
Drop_priv: N
Reload_priv: N
Shutdown_priv: N
Process_priv: N
File_priv: N
Grant_priv: N
References_priv: N
Index_priv: N
Alter_priv: N
Show_db_priv: N
Super_priv: N
Create_tmp_table_priv: N
Lock_tables_priv: N
Execute_priv: N
Repl_slave_priv: N
Repl_client_priv: N
Create_view_priv: N
Show_view_priv: N
Create_routine_priv: N
Alter_routine_priv: N
Create_user_priv: N
Event_priv: N
Trigger_priv: N
Create_tablespace_priv: N
ssl_type:
ssl_cipher:
x509_issuer:
x509_subject:
max_questions: 0
max_updates: 0
max_connections: 0
max_user_connections: 0
plugin:
authentication_string:
password_expired: N
is_role: N
default_role:
max_statement_time: 0.000000
1 row in set (0.00 sec)
>
> and:
>
> select * from db where User='bacula' \G
MariaDB [mysql]> select * from db where User='bacula' \G
*************************** 1. row ***************************
Host: %
Db: bacula
User: bacula
Select_priv: Y
Insert_priv: Y
Update_priv: Y
Delete_priv: Y
Create_priv: Y
Drop_priv: Y
Grant_priv: N
References_priv: Y
Index_priv: Y
Alter_priv: Y
Create_tmp_table_priv: Y
Lock_tables_priv: Y
Create_view_priv: Y
Show_view_priv: Y
Create_routine_priv: Y
Alter_routine_priv: Y
Execute_priv: Y
Event_priv: Y
Trigger_priv: Y
1 row in set (0.00 sec)
>
> The first should show two records - both for User "bacula", but one
> for Host "%" and one for "localhost" -- with (most) everything set to
> "N".
>
> The second should also show two records, same Host and User values
> and Db "bacula", but with everything (except the "Grant" privilege)
> set to "Y".
There doesn't seem to be one for "localhost".
--
Erik
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
