Re: [Bacula-users] Can't run bacula any more.

[Richard]

> Date: Monday, March 13, 2017 23:30:36 +0100
> From: "Erik P. Olsen" 
>
> On 2017-03-13 at 16:07:35 Richard wrote:
> 
>> > Date: Monday, March 13, 2017 15:34:04 +0100
>> > From: "Erik P. Olsen" 
>> > 
>> > On 2017-03-13 at 13:38:44 Richard wrote:
>> >   
>> >> 
>> >> 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 HostUserPasswordSelect_priv
>> > Insert_privUpdate_priv Delete_priv
>> > Create_privDrop_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: 
. . .
>> 
>> and:
>> 
>>select * from db where User='bacula' \G
> 
> MariaDB [mysql]> select * from db where User='bacula' \G
> *** 1. row ***
>  Host: %
>Db: bacula
>  User: bacula
. . .
> 
> 
>> 
>> 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".

What you have for privileges is what I would expect. My
"grant_mysql_privileges" script has two lines - the first will do the
"localhost" setup for the bacula user. Assuming that your script is
lacking that, you might want to add it and try rerunning the script.

 grant all privileges on ${db_name}.* to ${db_user}@localhost ${pass};
 grant all privileges on ${db_name}.* to ${db_user}@"%" ${pass};




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

Re: [Bacula-users] Can't run bacula any more.

[Erik P. Olsen]

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" 
> >
> > On 2017-03-13 at 13:38:44 Richard wrote:
> >   
> >> > Date: Monday, March 13, 2017 14:07:04 +0100
> >> > From: "Erik P. Olsen" 
> >> > 
> >> > 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
> >> >>thetop 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 UserPasswordSelect_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.00
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


 

Re: [Bacula-users] Bacula on Devil-Linux

[Heitor Faria]

> gents,
Hello, Jan, 

> it’s possible to install Bacula on Devil-Linux?
Likely if you are able install gcc and other stuff. I suppose you are trying to 
install only Bacula File Daemon. 

> If yes, do you know the location for binaries?
If you can't find the binaries you can always build the daemons from source: 
http://bacula.us/compilation 

> Million thanks in advance!!!

> Thanks, take care

> Jan Stefanovic

> IT Systems Administrator

Regards, 
-- 
=== 
Heitor Medrado de Faria - LPIC-III | ITIL-F | Bacula Systems Certified 
Administrator II 
• Do you need Bacula training? http://bacula.us/video-classes/ 
+55 61 8268-4220 | http://bacula.us 
=== 
--
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

[Bacula-users] Bacula on Devil-Linux

[Jan Stefanovic]

gents,

it’s possible to install Bacula on Devil-Linux?
If yes, do you know the location for binaries?

Million thanks in advance!!!

Thanks, take care

Jan Stefanovic
IT Systems Administrator
--
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

Re: [Bacula-users] Can't run bacula any more.

[Richard]

 Original Message 
> Date: Monday, March 13, 2017 15:34:04 +0100
> From: "Erik P. Olsen" 
>
> On 2017-03-13 at 13:38:44 Richard wrote:
> 
>> > Date: Monday, March 13, 2017 14:07:04 +0100
>> > From: "Erik P. Olsen" 
>> > 
>> > 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
>> >>thetop 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   UserPasswordSelect_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.]

and:

   select * from db where User='bacula' \G

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



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

Re: [Bacula-users] Can't run bacula any more.

[Erik P. Olsen]

On 2017-03-13 at 11:46:52 Wanderlei Huttel wrote:
Hello Wanderlei,

[root@Erik-PC bacula]# ./grant_mysql_privileges -u root -p
Enter password: 
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: 
YES)
Error creating privileges.
[root@Erik-PC bacula]# 

-- 
Erik

> Hello Erik
> 
> Run the command informing user and password (just -p) then the prompt
> will ask for your password.
> ./grant_mysql_privileges -u root -p
> 
> 
> Best regards
> 
> *Wanderlei Hüttel*
> http://www.huttel.com.br
> 
> 2017-03-13 11:34 GMT-03:00 Erik P. Olsen :
> 
> > On 2017-03-13 at 13:38:44 Richard wrote:
> >  
> > > > Date: Monday, March 13, 2017 14:07:04 +0100
> > > > From: "Erik P. Olsen" 
> > > >
> > > > 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
> > > >>thetop 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 HostUserPasswordSelect_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
> >  

 

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

Re: [Bacula-users] Can't run bacula any more.

[Erik P. Olsen]

On 2017-03-13 at 13:38:44 Richard wrote:

> > Date: Monday, March 13, 2017 14:07:04 +0100
> > From: "Erik P. Olsen" 
> >
> > 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
> >>thetop 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
HostUserPasswordSelect_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

Re: [Bacula-users] Can't run bacula any more.

[Richard]

> Date: Monday, March 13, 2017 14:07:04 +0100
> From: "Erik P. Olsen" 
>
> 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
>>thetop 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?




--
Announcing the Oxford Dictionaries API! The API offers world-renowned
dictionary content that is easy and intuitive to access. Sign up for an
account today to start using our lexical data to power your apps and
projects. Get started today and enter our developer competition.
http://sdm.link/oxford
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Can't run bacula any more.

[Erik P. Olsen]

On 2017-03-13 at 12:40:52 Richard wrote:

> > Date: Monday, March 13, 2017 12:26:07 +0100
> > From: "Erik P. Olsen" 
> >
> > On 2017-03-13 at 09:15:17 Richard wrote:
> >   
> >> > Date: Monday, March 13, 2017 07:40:08 +0100
> >> > From: "Erik P. Olsen" 
> >> > 
> >> > On 2017-03-12 at 18:58:55 Mike Ruskai wrote:
> >> > 
> >> >> On 3/12/2017 10:29, Erik P. Olsen wrote:
> >> >> > 
> >> >> > [snip]
> >> >> > 
> >> >> > mysql -u bacula
> >> >> > 
> >> >> > was OK.
> >> >> > 
> >> >> > show databases;
> >> >> > 
> >> >> > gave:
> >> >> > 
> >> >> > ++
> >> >> > | Database   |
> >> >> > ++
> >> >> > | information_schema |
> >> >> > | test   |
> >> >> > ++
> >> >> > 
> >> >> > So apparently the scripts did not create the bacula database.
> >> >> > I'll have to see why that happened.
> >> >> > 
> >>   
> >> >> Is your root DB password blank as well?  Were you logged in as
> >> >> root when running the scripts?
> >> > Root DB password: don't know. I was using su - when running the
> >> > scripts.
> >> >> 
> >> >> What do you get if you simply type "mysql" on the command line?
> >> >> If you get a prompt, what does "show processlist" report?
> >> > 
> >> > 
> >> > [root@Erik-PC etc]# exit
> >> > log ud
> >> > [erik@Erik-PC ~]$ mysql
> >> > Welcome to the MariaDB monitor.  Commands end with ; or \g.
> >> > Your MariaDB connection id is 722
> >> > Server version: 10.1.21-MariaDB MariaDB Server
> >> > 
> >> > Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and
> >> > others.
> >> > 
> >> > Type 'help;' or '\h' for help. Type '\c' to clear the current
> >> > input statement.
> >> > 
> >> > MariaDB [(none)]> 
> >> > 
> >> >> 
> >> >> If you weren't logged in as root when running the script, with a
> >> >> blank root DB password, then the DB scripts wouldn't work.
> >> >> 
> >> >> That is, with a secured DB server, this wouldn't work:
> >> >> 
> >> >> /usr/libexec/bacula/create_bacula_database
> >> >> 
> >> >> But this would, provided the password were correct:
> >> >> 
> >> >> /usr/libexec/bacula/create_bacula_database -u root
> >> >> --password=
> >> >> 
> >> >> The scripts don't just fail silently, either.
> >> 
> >> A slight follow-on. You should invoke mysql as mysql root (mysql -u
> >> root -p [if the password isn't set pressing a CR will get you past
> >> the password prompt]) or after su-ing to system root (and then
> >> don't use the "-u root -p"). Once you have the "mysql>" prompt
> >> issue the "show databases;" command. The output should include the
> >> "mysql" database. If the "bacula" database is also listed that
> >> indicates that it was set up but not permitted to the mysql
> >> "bacula" user. If it's not there (but you see the "mysql"
> >> database) that's an indication that your bacula database creation
> >> effort(s) failed.  
> > 
> > With root I got:
> > 
> > ++
> >| Database   |
> > ++
> >| bacula |
> >| information_schema |
> >| mysql  |
> >| performance_schema |
> >| test   |
> > ++  
> 
> Now, as system root:
> 
>mysql bacula
> 
> and once at the "MariaDB [bacula]>" prompt:
>   
>show tables;
> 
> 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".

> 
> If it now shows the "bacula" database:
> 
>use bacula; 
> 
>show tables;
> 
> Ideally you'll see the same list of ~25 tables.
> 
> If that works, that should indicate that the obvious bacula table
> creation/privileges issue(s) have been resolved, so you should try to
> proceed with bacula (where this all started) and see what you get.
> 
> You may want to double check the "Catalog" section of your
> bacula-dir.conf file (in /etc/bacula) to confirm that the db
> credentials line shows:
> 
>   dbname = "bacula"; dbuser = "bacula"; dbpassword = ""

Yes, this is set in the Catalog section.

I believe I have configured bacula correctly as I have done so many
times without problems and I have not modified the scripts at all. So
to my understanding it should just work first time.

-- 
Erik


 

--
Announcing the Oxford Dictionaries API! The API offers world-renowned
dictionary content that is easy and intuitive to access. Sign up for an
account today to start using our lexical data to power your apps and
projects. Get 

Re: [Bacula-users] baculum's rpm package

[KEN SAWADA]

Hello Marcin

Thank you for your reply.
Since Bacula 7.4.5 it became possible to use the Japanese interface
with buculum, I thought that it is convenient to have the rpm file and
asked a question.
Install from tar ball.
Thank you.

Best regards,
Ken Sawada


2017-03-12 22:30 GMT+09:00 Marcin Haba :

> Hello Ken,
>
> New Baculum rpm packages will not be created because there is very few
> changes lately to Baculum 7.4.
>
> I am in the middle of preparing some new features but unfortunatelly I
> couldn't finalize them yet. It is something that I can't add
> partially, but it has to be added at once.
>
> New Baculum version is in bacula-gui tar archive, for example here:
>
> https://sourceforge.net/projects/bacula/files/bacula/7.4.6/
>
> and here is instruction how to install it:
>
> http://www.bacula.org/7.4.x-manuals/en/console/Baculum_Web_GUI_Tool.html#
> SECTION0035
>
> I hope that it helps.
>
> Best regards.
> Marcin Haba (gani)
>
> On 12 March 2017 at 08:00, KEN SAWADA  wrote:
> > Hi!
> >
> > Will baculum's rpm package not be updated?
> > http://bacula.org/downloads/baculum/centos/
> >
> > Is there a new version somewhere else?
> > I'm happy to get advice.
> >
> > Best regards,
> >
> > Ken Sawada
> >
> >
> > 
> --
> > Announcing the Oxford Dictionaries API! The API offers world-renowned
> > dictionary content that is easy and intuitive to access. Sign up for an
> > account today to start using our lexical data to power your apps and
> > projects. Get started today and enter our developer competition.
> > http://sdm.link/oxford
> > ___
> > Bacula-users mailing list
> > Bacula-users@lists.sourceforge.net
> > https://lists.sourceforge.net/lists/listinfo/bacula-users
> >
>
>
>
> --
> "Greater love hath no man than this, that a man lay down his life for
> his friends." Jesus Christ
>
> "Większej miłości nikt nie ma nad tę, jak gdy kto życie swoje kładzie
> za przyjaciół swoich." Jezus Chrystus
>
--
Announcing the Oxford Dictionaries API! The API offers world-renowned
dictionary content that is easy and intuitive to access. Sign up for an
account today to start using our lexical data to power your apps and
projects. Get started today and enter our developer competition.
http://sdm.link/oxford___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Can't run bacula any more.

[Richard]

> Date: Monday, March 13, 2017 12:26:07 +0100
> From: "Erik P. Olsen" 
>
> On 2017-03-13 at 09:15:17 Richard wrote:
> 
>> > Date: Monday, March 13, 2017 07:40:08 +0100
>> > From: "Erik P. Olsen" 
>> > 
>> > On 2017-03-12 at 18:58:55 Mike Ruskai wrote:
>> >   
>> >> On 3/12/2017 10:29, Erik P. Olsen wrote:  
>> >> > 
>> >> > [snip]
>> >> > 
>> >> > mysql -u bacula
>> >> > 
>> >> > was OK.
>> >> > 
>> >> > show databases;
>> >> > 
>> >> > gave:
>> >> > 
>> >> > ++
>> >> > | Database   |
>> >> > ++
>> >> > | information_schema |
>> >> > | test   |
>> >> > ++
>> >> > 
>> >> > So apparently the scripts did not create the bacula database.
>> >> > I'll have to see why that happened.
>> >> >   
>> 
>> >> Is your root DB password blank as well?  Were you logged in as
>> >> root when running the scripts?  
>> > Root DB password: don't know. I was using su - when running the
>> > scripts.  
>> >> 
>> >> What do you get if you simply type "mysql" on the command line?
>> >> If you get a prompt, what does "show processlist" report?  
>> > 
>> > 
>> > [root@Erik-PC etc]# exit
>> > log ud
>> > [erik@Erik-PC ~]$ mysql
>> > Welcome to the MariaDB monitor.  Commands end with ; or \g.
>> > Your MariaDB connection id is 722
>> > Server version: 10.1.21-MariaDB MariaDB Server
>> > 
>> > Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and
>> > others.
>> > 
>> > Type 'help;' or '\h' for help. Type '\c' to clear the current
>> > input statement.
>> > 
>> > MariaDB [(none)]> 
>> >   
>> >> 
>> >> If you weren't logged in as root when running the script, with a
>> >> blank root DB password, then the DB scripts wouldn't work.
>> >> 
>> >> That is, with a secured DB server, this wouldn't work:
>> >> 
>> >> /usr/libexec/bacula/create_bacula_database
>> >> 
>> >> But this would, provided the password were correct:
>> >> 
>> >> /usr/libexec/bacula/create_bacula_database -u root
>> >> --password=
>> >> 
>> >> The scripts don't just fail silently, either.  
>> 
>> A slight follow-on. You should invoke mysql as mysql root (mysql -u
>> root -p [if the password isn't set pressing a CR will get you past
>> the password prompt]) or after su-ing to system root (and then
>> don't use the "-u root -p"). Once you have the "mysql>" prompt
>> issue the "show databases;" command. The output should include the
>> "mysql" database. If the "bacula" database is also listed that
>> indicates that it was set up but not permitted to the mysql
>> "bacula" user. If it's not there (but you see the "mysql"
>> database) that's an indication that your bacula database creation
>> effort(s) failed.
> 
> With root I got:
> 
> ++
>| Database   |
> ++
>| bacula |
>| information_schema |
>| mysql  |
>| performance_schema |
>| test   |
> ++

Now, as system root:

   mysql bacula

and once at the "MariaDB [bacula]>" prompt:
  
   show tables;

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.

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;

If it now shows the "bacula" database:

   use bacula; 

   show tables;

Ideally you'll see the same list of ~25 tables.

If that works, that should indicate that the obvious bacula table
creation/privileges issue(s) have been resolved, so you should try to
proceed with bacula (where this all started) and see what you get.

You may want to double check the "Catalog" section of your
bacula-dir.conf file (in /etc/bacula) to confirm that the db
credentials line shows:

  dbname = "bacula"; dbuser = "bacula"; dbpassword = ""




--
Announcing the Oxford Dictionaries API! The API offers world-renowned
dictionary content that is easy and intuitive to access. Sign up for an
account today to start using our lexical data to power your apps and
projects. Get started today and enter our developer competition.
http://sdm.link/oxford
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Regression testing - let's get more involved

[Francisco Javier Funes Nieto]

I have some spare time and one test machine to do some regression tests.

How can I start?
J.

2017-03-12 16:53 GMT+01:00 Dan Langille :

> On Mar 9, 2017, at 11:03 AM, Kern Sibbald  wrote:
>
> Hello Dan,
>
> Thank you for taking the initiative on this.  Yes, there was a brief
> period when there was no project defined for regression testing (Dart)
> after the switch from the old server to the new one.  However, it is up and
> working.  The project is Bacula-7.4.
>
>
> I have jails set up just for this; I just need to upgrade the regress
> directory and enable the cron jobs.
>
> I would especially appreciate it if someone could test on OpenBSD, where
> currently there is a seg fault in the new acl-xattr code.  If all goes
> well, I will shortly have a fix, but I don't have a system to test it on.
>
>
> I got my first proof-of-concept working with the latest source.  Over the
> next week, I'll enable the other jails. I'm catching up on mail today.
>
> http://regress.bacula.org/index.php?project=Bacula-7.4=2017-03-09
>
> --
> Dan Langille - BSDCan / PGCon
> d...@langille.org
>
>
>
>
> Best regards,
> Kern
>
> On 03/09/2017 03:12 PM, Dan Langille wrote:
>
> Regression testing is important. With it, you can ensure that future
> releases work with your chosen combination of OS and DB.
>
> Setting up regression testing is not difficult.  Automating it is also
> easy.  It can be done in any environment and DOES NOT require root privs.
> It can be run as whatever user you choose.
>
> After a short absence, it appears that http://regress.bacula.org is back,
> although I'd like to see it available over https as well.
>
> I am not sure the regression testing is configured to accept incoming
> tests yet.  From last night's logs:
>
> ###
> The following tests FAILED:
>   1 - disk:acl-xattr-test (Failed)
>   6 - disk:backup-bacula-test (Failed)
>  28 - disk:estimate-test (Failed)
>  77 - disk:tls-test (Failed)
> Performing coverage
> Submit files (using http)
>Using HTTP submit method
>Drop site:http://regress.bacula.org/submit.php?project=bacula
>Submission failed: Not a valid project.
>Uploaded: /usr/home/dan/src/Bacula7RegressionTesting-
> TRUNK/regress/Testing/20170308-2200/Build.xml
>Submission failed: Not a valid project.
>Uploaded: /usr/home/dan/src/Bacula7RegressionTesting-
> TRUNK/regress/Testing/20170308-2200/Configure.xml
>Submission failed: Not a valid project.
>Uploaded: /usr/home/dan/src/Bacula7RegressionTesting-
> TRUNK/regress/Testing/20170308-2200/Test.xml
>Submission failed: Not a valid project.
>Uploaded: /usr/home/dan/src/Bacula7RegressionTesting-
> TRUNK/regress/Testing/20170308-2200/Update.xml
>Using HTTP trigger method
>Trigger site: http://regress.bacula.org
>Dart server triggered...
>Errors occurred during submission.
> End nightly-disk Thu Mar  9 04:06:33 UTC 2017
> ###
>
> My own regression testing covers MySQL 5.5 and 5.6 & PostgreSQL 9.2-9.6 on
> FreeBSD 10.3.  I could do similar on FreeBSD 11 but ... time.
>
> Anyone else interested in helping out the devs? This involves a little bit
> of initial work, but the long-term payback is great.  It is a simple way
> that anyone can contribute to the project.
>
> --
> Dan Langille - BSDCan / PGCon
> d...@langille.org
>
>
>
>
> --
> Announcing the Oxford Dictionaries API! The API offers world-renowned
> dictionary content that is easy and intuitive to access. Sign up for an
> account today to start using our lexical data to power your apps and
> projects. Get started today and enter our developer 
> competition.http://sdm.link/oxford
>
>
>
> ___
> Bacula-users mailing 
> listBacula-users@lists.sourceforge.nethttps://lists.sourceforge.net/lists/listinfo/bacula-users
>
>
> 
> --
> Announcing the Oxford Dictionaries API! The API offers world-renowned
> dictionary content that is easy and intuitive to access. Sign up for an
> account today to start using our lexical data to power your apps and
> projects. Get started today and enter our developer competition.
> http://sdm.link/oxford___
> Bacula-users mailing list
> Bacula-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/bacula-users
>
>
>
> 
> --
> Announcing the Oxford Dictionaries API! The API offers world-renowned
> dictionary content that is easy and intuitive to access. Sign up for an
> account today to start using our lexical data to power your apps and
> projects. Get started today and enter our developer competition.
> http://sdm.link/oxford
> ___
> Bacula-users mailing list
> 

Re: [Bacula-users] Can't run bacula any more.

[Erik P. Olsen]

On 2017-03-13 at 09:15:17 Richard wrote:

> > Date: Monday, March 13, 2017 07:40:08 +0100
> > From: "Erik P. Olsen" 
> >
> > On 2017-03-12 at 18:58:55 Mike Ruskai wrote:
> >   
> >> On 3/12/2017 10:29, Erik P. Olsen wrote:  
> >> > 
> >> > [snip]
> >> > 
> >> > mysql -u bacula
> >> > 
> >> > was OK.
> >> > 
> >> > show databases;
> >> > 
> >> > gave:
> >> > 
> >> > ++
> >> > | Database   |
> >> > ++
> >> > | information_schema |
> >> > | test   |
> >> > ++
> >> > 
> >> > So apparently the scripts did not create the bacula database.
> >> > I'll have to see why that happened.
> >> >   
> 
> >> Is your root DB password blank as well?  Were you logged in as root
> >> when running the scripts?  
> > Root DB password: don't know. I was using su - when running the
> > scripts.  
> >> 
> >> What do you get if you simply type "mysql" on the command line?  If
> >> you get a prompt, what does "show processlist" report?  
> > 
> > 
> > [root@Erik-PC etc]# exit
> > log ud
> > [erik@Erik-PC ~]$ mysql
> > Welcome to the MariaDB monitor.  Commands end with ; or \g.
> > Your MariaDB connection id is 722
> > Server version: 10.1.21-MariaDB MariaDB Server
> > 
> > Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.
> > 
> > Type 'help;' or '\h' for help. Type '\c' to clear the current input
> > statement.
> > 
> > MariaDB [(none)]> 
> >   
> >> 
> >> If you weren't logged in as root when running the script, with a
> >> blank root DB password, then the DB scripts wouldn't work.
> >> 
> >> That is, with a secured DB server, this wouldn't work:
> >> 
> >> /usr/libexec/bacula/create_bacula_database
> >> 
> >> But this would, provided the password were correct:
> >> 
> >> /usr/libexec/bacula/create_bacula_database -u root
> >> --password=
> >> 
> >> The scripts don't just fail silently, either.  
> 
> A slight follow-on. You should invoke mysql as mysql root (mysql -u
> root -p [if the password isn't set pressing a CR will get you past
> the password prompt]) or after su-ing to system root (and then don't
> use the "-u root -p"). Once you have the "mysql>" prompt issue the
> "show databases;" command. The output should include the "mysql"
> database. If the "bacula" database is also listed that indicates that
> it was set up but not permitted to the mysql "bacula" user. If it's
> not there (but you see the "mysql" database) that's an indication
> that your bacula database creation effort(s) failed.

With root I got:

++
| Database   |
++
| bacula |
| information_schema |
| mysql  |
| performance_schema |
| test   |
++

-- 
Erik


 

--
Announcing the Oxford Dictionaries API! The API offers world-renowned
dictionary content that is easy and intuitive to access. Sign up for an
account today to start using our lexical data to power your apps and
projects. Get started today and enter our developer competition.
http://sdm.link/oxford
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Can't run bacula any more.

[Richard]

> Date: Monday, March 13, 2017 07:40:08 +0100
> From: "Erik P. Olsen" 
>
> On 2017-03-12 at 18:58:55 Mike Ruskai wrote:
> 
>> On 3/12/2017 10:29, Erik P. Olsen wrote:
>> > 
>> > [snip]
>> > 
>> > mysql -u bacula
>> > 
>> > was OK.
>> > 
>> > show databases;
>> > 
>> > gave:
>> > 
>> > ++
>> > | Database   |
>> > ++
>> > | information_schema |
>> > | test   |
>> > ++
>> > 
>> > So apparently the scripts did not create the bacula database.
>> > I'll have to see why that happened.
>> > 

>> Is your root DB password blank as well?  Were you logged in as root
>> when running the scripts?
> Root DB password: don't know. I was using su - when running the
> scripts.
>> 
>> What do you get if you simply type "mysql" on the command line?  If
>> you get a prompt, what does "show processlist" report?
> 
> 
> [root@Erik-PC etc]# exit
> log ud
> [erik@Erik-PC ~]$ mysql
> Welcome to the MariaDB monitor.  Commands end with ; or \g.
> Your MariaDB connection id is 722
> Server version: 10.1.21-MariaDB MariaDB Server
> 
> Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.
> 
> Type 'help;' or '\h' for help. Type '\c' to clear the current input
> statement.
> 
> MariaDB [(none)]> 
> 
>> 
>> If you weren't logged in as root when running the script, with a
>> blank root DB password, then the DB scripts wouldn't work.
>> 
>> That is, with a secured DB server, this wouldn't work:
>> 
>> /usr/libexec/bacula/create_bacula_database
>> 
>> But this would, provided the password were correct:
>> 
>> /usr/libexec/bacula/create_bacula_database -u root
>> --password=
>> 
>> The scripts don't just fail silently, either.

A slight follow-on. You should invoke mysql as mysql root (mysql -u
root -p [if the password isn't set pressing a CR will get you past
the password prompt]) or after su-ing to system root (and then don't
use the "-u root -p"). Once you have the "mysql>" prompt issue the
"show databases;" command. The output should include the "mysql"
database. If the "bacula" database is also listed that indicates that
it was set up but not permitted to the mysql "bacula" user. If it's
not there (but you see the "mysql" database) that's an indication
that your bacula database creation effort(s) failed.



--
Announcing the Oxford Dictionaries API! The API offers world-renowned
dictionary content that is easy and intuitive to access. Sign up for an
account today to start using our lexical data to power your apps and
projects. Get started today and enter our developer competition.
http://sdm.link/oxford
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Can't run bacula any more.

[Erik P. Olsen]

On 2017-03-12 at 23:06:36 Erik P. Olsen wrote:

> On 2017-03-12 at 15:31:35 Sven Hartge wrote:
> 
> > On 12.03.2017 14:54, Richard wrote:
> >   
> > > Looking back through all the messages in this thread, it appears
> > > that you have two problems. One is that you can't connect to the
> > > director daemon:
> >   
> > > The other is your db setup/access:
> > 
> > Both problems will be related. He cannot connect to the director
> > with bconsole because the director dies because the database is not
> > reachable or not setup correctly.
> > 
> > First step should be to fix the database so that the director daemon
> > starts correctly and _then_ see if this automagically fixes the
> > problem with bconsole (I think it will).
> >   
> I've looked at the mariadb log file. I've found a few lines that look
> strange and may contain important info. I've removed some leading
> timestamps and other data not relating to the possible error in order
> to make more readable:
>  
> [Warning] InnoDB: New log files created, LSN=3965718
> [Note] InnoDB: Highest supported file format is Barracuda.
> [Note] InnoDB: 128 rollback segment(s) are active.
> [Note] InnoDB: Waiting for purge to start
> [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.34-79.1
> started; log sequence number 3965964 [Note] Plugin 'FEEDBACK' is
> disabled. [Note] InnoDB: Dumping buffer pool(s) not yet started
> [Warning] GSSAPI plugin : default principal
> 'mariadb/erik-pc.epolan.dk@' not found in keytab [ERROR] mysqld:
> Server GSSAPI error (major 851968, minor 2529639093) :
> gss_acquire_cred failed -Unspecified GSS failure.  Minor code may
> provide more information. Keytab FILE:/etc/krb5.keytab is nonexistent
> or empty. [ERROR] Plugin 'gssapi' init function returned error.
> [Note] Server socket created on IP: '0.0.0.0'.
> [Note] /usr/libexec/mysqld: ready for connections. Version:
> '10.1.21-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306
> MariaDB Server [Note] /usr/libexec/mysqld: Normal shutdown 
> 
> I hope it makes sense to someone.
> 

Did a check of my running bacula system and it had exactly the same
messages - without failing. So this has nothing to do with the failing
system.

-- 
Erik


--
Announcing the Oxford Dictionaries API! The API offers world-renowned
dictionary content that is easy and intuitive to access. Sign up for an
account today to start using our lexical data to power your apps and
projects. Get started today and enter our developer competition.
http://sdm.link/oxford
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Can't run bacula any more.

[Erik P. Olsen]

On 2017-03-12 at 18:58:55 Mike Ruskai wrote:

> On 3/12/2017 10:29, Erik P. Olsen wrote:
> >
> > [snip]
> >
> > mysql -u bacula
> >
> > was OK.
> >
> > show databases;
> >
> > gave:
> >
> > ++
> > | Database   |
> > ++
> > | information_schema |
> > | test   |
> > ++
> >
> > So apparently the scripts did not create the bacula database. I'll
> > have to see why that happened.
> >
> > Thanks for the information.
> >
> > --
> > Regards,
> > Erik P. Olsen, M.Sc. EE
> > Solsortvej 30
> > DK-2000 Frederiksberg
> > Denmark  
> 
> Is your root DB password blank as well?  Were you logged in as root
> when running the scripts?
Root DB password: don't know. I was using su - when running the scripts.
> 
> What do you get if you simply type "mysql" on the command line?  If
> you get a prompt, what does "show processlist" report?


[root@Erik-PC etc]# exit
log ud
[erik@Erik-PC ~]$ mysql
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 722
Server version: 10.1.21-MariaDB MariaDB Server

Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> 

> 
> If you weren't logged in as root when running the script, with a
> blank root DB password, then the DB scripts wouldn't work.
> 
> That is, with a secured DB server, this wouldn't work:
> 
> /usr/libexec/bacula/create_bacula_database
> 
> But this would, provided the password were correct:
> 
> /usr/libexec/bacula/create_bacula_database -u root
> --password=
> 
> The scripts don't just fail silently, either.

-- 
Erik


--
Announcing the Oxford Dictionaries API! The API offers world-renowned
dictionary content that is easy and intuitive to access. Sign up for an
account today to start using our lexical data to power your apps and
projects. Get started today and enter our developer competition.
http://sdm.link/oxford
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users