>>>>> On Mon, 22 Mar 2021 19:35:04 +0100, Adolf Belka (gmail) said:
>
> Hi Radoslaw,
>
> Sent from my Desktop Computer
>
> On 22/03/2021 16:23, Radosław Korzeniewski wrote:
> > Hello,
> >
> > pon., 22 mar 2021 o 15:44 Adolf Belka (gmail) <adolf.be...@gmail.com
> > <mailto:adolf.be...@gmail.com>> napisał(a):
> >
> > Hi All,
> >
> > I initially setup the regression system with sqlite3 to prove it was
> > working in a simple manner. This worked and I was able to run the
> > regression tests, most of which passed.
> >
> >
> > I then changed my setup to mysql (mariadb for Arch Linux).
> >
> > I then re-ran make setup but get a whole lot of errors at the end. The
> > following is just the end part with the errors but if the whole of the
> > output from make setup is required I can provide that.
> >
> >
> > Any clues, from the error messages being seen, for what I have not done
> > correctly.
> >
> >
> > Stopping the Bacula File daemon
> > Stopping the Bacula Storage daemon
> > Stopping the Bacula Director daemon
> > Running database creation scripts
> > Creating mysql database
> > ERROR 1044 (42000) at line 1: Access denied for user ''@'localhost' to
> > database 'regress'
> >
> >
> > It seems you have no permissions (Access denied above) to create a
> > database. No database, no regression testing.
> >
> Thanks very much for the input.
>
> Yes, I had to add my unprivileged user into mariadb with full granting,
> creation etc privileges and then most of the errors disappeared. I had to
> also redo the root user as somehow the blank password had become an invalid
> password and that was still causing some errors.
>
> Once that was solved then I only have two errors left but they don't appear
> to be blocking (yet) as the regression tests are running okay so far.
>
> The need to have your unprivileged user in mariadb/mysql with granting etc
> rights is not mentioned in the Regression instructions section of the manual.
>
> The error messages still left are the "ERROR 1133...." line and the
> "....smartall.c:418-0 Orphaned buffer...." line in the output below.
>
> I think the ERROR 1133 line may be related to the mariadb.sys user. Searching
> found other people with the same message and it was said to be a feature of
> that user.
>
> The other error I have not been able to figure out at all but the disk based
> tests all seem to be working at the moment with mysql/mariadb.
>
> Stopping the Bacula File daemon
> Stopping the Bacula Storage daemon
> Stopping the Bacula Director daemon
> Running database creation scripts
> Creating mysql database
> Creation of regress database succeeded.
> Deletion of regress MySQL tables succeeded.
> Dropped mysql tables
> Making mysql tables
> Creation of Bacula MySQL tables succeeded.
> Granting mysql privileges
> Created MySQL database user: regress
> 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_privCreate_priv Drop_priv Reload_priv Shutdown_priv
> Process_priv File_priv Grant_priv References_priv Index_priv
> Alter_priv Show_db_priv Super_privCreate_tmp_table_priv Lock_tables_priv
> Execute_priv Repl_slave_priv Repl_client_priv Create_view_priv
> Show_view_priv Create_routine_priv Alter_routine_privCreate_user_priv
> Event_priv Trigger_priv Create_tablespace_priv
> Delete_history_privssl_type ssl_cipher x509_issuer x509_subject
> max_questions max_updatesmax_connections max_user_connections plugin
> authentication_string password_expired is_role default_role
> max_statement_time
> localhost mariadb.sys N N N N N N N NN N N
> N N N N N N N N N NN N N N N N N
> N N 00 0 0 mysql_native_password N N
> 0.000000
> localhost root Y Y Y Y Y Y Y Y YY Y Y
> Y Y Y Y Y Y Y Y Y YY Y Y Y Y Y Y
> Y 00 0 0 mysql_native_password N N
> 0.000000
> localhost ahb Y Y Y Y Y Y Y Y YY Y Y
> Y Y Y Y Y Y Y Y Y YY Y Y Y Y Y Y
> Y 00 0 0 mysql_native_password N N
> 0.000000
> % regress N N N N N N N N N NN N N
> N N N N N N N N N NN N N N N N N
> 0 00 0 mysql_native_password N N
> 0.000000
> Privileges for user regress granted on database regress.
It looks like this error 1133 is coming from Bacula's grant_mysql_privileges
script. Line 2 expects to find regress@localhost:
use mysql
grant all privileges on ${db_name}.* to ${db_user}@localhost ${ssl_options};
grant all privileges on ${db_name}.* to ${db_user}@"%" ${ssl_options};
select * from user;
flush privileges;
That is probably benign if everything else works.
__Martin
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
