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" <epodata AT gmail DOT com>
> >
> > On 2017-03-13 at 13:38:44 Richard wrote:
> >   
> >> > Date: Monday, March 13, 2017 14:07:04 +0100
> >> > From: "Erik P. Olsen" <epodata AT gmail DOT 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 AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users