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. Starting the Bacula Storage daemon Starting the Bacula File daemon Starting the Bacula Director daemon Stopping the Bacula File daemon Stopping the Bacula Storage daemon Stopping the Bacula Director daemon hyperion-dir: smartall.c:418-0 Orphaned buffer: hyperion-dir 1048 bytes at 7f122400b328 from lib/berrno.h:68 echo "Doing: scripts/do_sed" Doing: scripts/do_sed scripts/do_sed Thanks and regards, Adolf Belka
best regards -- Radosław Korzeniewski rados...@korzeniewski.net <mailto:rados...@korzeniewski.net>
_______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
