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. -- 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
