Re: [Bacula-users] Regression testing - errors found with make setup

2021-03-24 Thread Martin Simmons 
> 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)  > > 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.00
> 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.00
> 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.00
> %    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.00
> 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

Re: [Bacula-users] Regression testing - errors found with make setup

2021-03-23 Thread Radosław Korzeniewski 
Hello,

pon., 22 mar 2021 o 19:35 Adolf Belka (gmail) 
napisał(a):

> Yes, I had to add my unprivileged user into mariadb with full granting,
> creation etc privileges and then most of the errors disappeared.


Great to hear from you. This is the most common mistake I make when I setup
a new regression tests. :)


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

Unfortunately what I observe is the successive divergence between mysql and
mariadb. I could even make an opinion that both engines are now different
products and should not be treated as mysql/mariadb any more.


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

best regards
-- 
Radosław Korzeniewski
rados...@korzeniewski.net
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Regression testing - errors found with make setup

2021-03-22 Thread Adolf Belka (gmail) 

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) 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.00
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.00
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.00
%    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.00
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

Re: [Bacula-users] Regression testing - errors found with make setup

2021-03-22 Thread Radosław Korzeniewski 
Hello,

pon., 22 mar 2021 o 15:44 Adolf Belka (gmail) 
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.

best regards
-- 
Radosław Korzeniewski
rados...@korzeniewski.net
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

[Bacula-users] Regression testing - errors found with make setup

2021-03-22 Thread Adolf Belka (gmail) 

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'
Creation of regress database succeeded.
ERROR 1044 (42000) at line 1: Access denied for user ''@'localhost' to database 
'regress'
Deletion of regress MySQL tables failed.
Dropped mysql tables
Making mysql tables
ERROR 1044 (42000) at line 1: Access denied for user ''@'localhost' to database 
'regress'
ERROR 1046 (3D000) at line 8: No database selected
ERROR 1046 (3D000) at line 15: No database selected
ERROR 1046 (3D000) at line 36: No database selected
ERROR 1046 (3D000) at line 51: No database selected
ERROR 1046 (3D000) at line 77: No database selected
ERROR 1046 (3D000) at line 84: No database selected
ERROR 1046 (3D000) at line 91: No database selected
ERROR 1046 (3D000) at line 111: No database selected
ERROR 1046 (3D000) at line 147: No database selected
ERROR 1046 (3D000) at line 181: No database selected
ERROR 1046 (3D000) at line 189: No database selected
ERROR 1046 (3D000) at line 203: No database selected
ERROR 1046 (3D000) at line 211: No database selected
ERROR 1046 (3D000) at line 227: No database selected
ERROR 1046 (3D000) at line 285: No database selected
ERROR 1046 (3D000) at line 317: No database selected
ERROR 1046 (3D000) at line 328: No database selected
ERROR 1046 (3D000) at line 338: No database selected
ERROR 1046 (3D000) at line 347: No database selected
ERROR 1046 (3D000) at line 349: No database selected
ERROR 1046 (3D000) at line 359: No database selected
ERROR 1046 (3D000) at line 368: No database selected
ERROR 1046 (3D000) at line 374: No database selected
ERROR 1046 (3D000) at line 381: No database selected
ERROR 1046 (3D000) at line 405: No database selected
ERROR 1046 (3D000) at line 412: No database selected
ERROR 1046 (3D000) at line 415: No database selected
ERROR 1046 (3D000) at line 423: No database selected
ERROR 1046 (3D000) at line 427: No database selected
ERROR 1046 (3D000) at line 443: No database selected
ERROR 1046 (3D000) at line 449: No database selected
ERROR 1046 (3D000) at line 454: No database selected
Creation of Bacula MySQL tables succeeded.
Granting mysql privileges
ERROR 1698 (28000): Access denied for user 'root'@'localhost'
Error creating privileges.
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
bacula-dir: lockmgr.c:621-0 Failed ASSERT: 0
echo "Doing: scripts/do_sed"
Doing: scripts/do_sed
scripts/do_sed


Regards,

Adolf Belka

Sent from my Desktop Computer




___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users