[Bacula-users] Bacula on Ubuntu 12.04.01
Hi@all,
I want to install bacula on a ubuntu-server (12.04.01-LTS / 64bit). I
install with the following command:
aptitude install postgresql
aptitude install bacula-director-pgsql bacula-common-pgsql
bacula-sd-pgsql bacula-fd bacula-sd-tools bacula-console
and answer the questions:
Konfigurieren der Datenbank für bacula-director-pgsql mit
dbconfig-common:Ja
PostgreSQL-Anwendungspasswort für bacula-director-pgsql:
secret
Now I want test my director with:
bacula-dir -t
and get the error:
bacula-dir: dird.c:954 Konnte Catalog MyCatalog, database bacula
nicht öffnen.
bacula-dir: dird.c:959 postgresql.c:241 Unable to connect to PostgreSQL
server. Database=bacula User=bacula
Possible causes: SQL server not running; password incorrect;
max_connections exceeded.
15-Jan 10:04 bacula-dir ERROR TERMINATION
Bitte die Konfigurationsdatei korrigieren: bacula-dir.conf
The role 'bacula' is available:
postgres=# \dg[+]
List of roles
Role name | Attributes | Member of
| Description
---++---+-
bacula|| {}
|
postgres | Superuser, Create role, Create DB, Replication | {}
|
but I miss the script's (create_bacula_database, make_bacula_tables and
grant_bacula_privileges). Where can I find the scripts on my
ubuntu-system?
--
Viele Grüsse
Sven Gehr
--
Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS
and more. Get SQL Server skills now (including 2012) with LearnDevNow -
200+ hours of step-by-step video tutorials by Microsoft MVPs and experts.
SALE $99.99 this month only - learn more at:
http://p.sf.net/sfu/learnmore_122512
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] bacula 5.2.12 randomly fails to recycle disk based volumes
Zitat von Uwe Schuerkamp uwe.schuerk...@nionex.net: On Fri, Jan 11, 2013 at 02:52:05PM +, Martin Simmons wrote: Do you know which volume is used? There seems to be some confusion between incremental-0058 and incremental-0508. Is that a common feature of other failures like this? The problem is that this occurs only every once in a while, for the most part volume recycling works as advertised. Do you suggest I should delete the volume in question and have bacula create a new one? Can you log all queries in the mysql server to see if that records anthing interesting? I guess such a log would grow to be quite large, right? Esp. as I have no way of knowing when the error occurs, and I expect a *lot* of queries to be fired up on a 200GB+ File table ;) Fact is that Bacula has to wait for the query doing the recycling/pruning task and MySQL does not finish in a reasonable time. With this the following errors are possible: - Wrong usage of SQL query by Bacula, but this should get problems everytime not at random occasions - Bad planer decisions inside MySQL - Scalability problems with MySQL While it might be possible to tune-up the MySQL part of Bacula, your short term solution is more at the MySQL side. Do you have the latest release and checked/repaired all index and optimizer values? If yes, you might try export/import or replicate/switch-over or maybe even switch to PostgreSQL. Regards Andreas -- Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS and more. Get SQL Server skills now (including 2012) with LearnDevNow - 200+ hours of step-by-step video tutorials by Microsoft MVPs and experts. SALE $99.99 this month only - learn more at: http://p.sf.net/sfu/learnmore_122512 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Bacula on Ubuntu 12.04.01
Zitat von Sven Gehr mailingli...@dreampixel.de:
Hi@all,
I want to install bacula on a ubuntu-server (12.04.01-LTS / 64bit). I
install with the following command:
aptitude install postgresql
aptitude install bacula-director-pgsql bacula-common-pgsql
bacula-sd-pgsql bacula-fd bacula-sd-tools bacula-console
and answer the questions:
Konfigurieren der Datenbank für bacula-director-pgsql mit
dbconfig-common: Ja
PostgreSQL-Anwendungspasswort für bacula-director-pgsql:
secret
Now I want test my director with:
bacula-dir -t
and get the error:
bacula-dir: dird.c:954 Konnte Catalog MyCatalog, database bacula
nicht öffnen.
bacula-dir: dird.c:959 postgresql.c:241 Unable to connect to PostgreSQL
server. Database=bacula User=bacula
Possible causes: SQL server not running; password incorrect;
max_connections exceeded.
15-Jan 10:04 bacula-dir ERROR TERMINATION
Bitte die Konfigurationsdatei korrigieren: bacula-dir.conf
The role 'bacula' is available:
postgres=# \dg[+]
List of roles
Role name | Attributes | Member of
| Description
---++---+-
bacula|| {}
|
postgres | Superuser, Create role, Create DB, Replication | {}
|
but I miss the script's (create_bacula_database, make_bacula_tables and
grant_bacula_privileges). Where can I find the scripts on my
ubuntu-system?
Hello
you should check pg_hba.conf. It is set restrictive on a stock Ubuntu
12.04 install and be aware that per default unix sockets are used if
you dont at least specify localhost as target.
Regards
Andreas
--
Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS
and more. Get SQL Server skills now (including 2012) with LearnDevNow -
200+ hours of step-by-step video tutorials by Microsoft MVPs and experts.
SALE $99.99 this month only - learn more at:
http://p.sf.net/sfu/learnmore_122512
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Bacula on Ubuntu 12.04.01
I checked whether the database exists:
postgres=# \l
List of databases
Name| Owner | Encoding | Collate |Ctype|
Access privileges
---+--+---+-+-+---
bacula| postgres | SQL_ASCII | de_DE.UTF-8 | de_DE.UTF-8 |
postgres | postgres | UTF8 | de_DE.UTF-8 | de_DE.UTF-8 |
template0 | postgres | UTF8 | de_DE.UTF-8 | de_DE.UTF-8 |
=c/postgres +
| | | | |
postgres=CTc/postgres
template1 | postgres | UTF8 | de_DE.UTF-8 | de_DE.UTF-8 |
=c/postgres +
| | | | |
postgres=CTc/postgres
(4 rows)
Am 15-01-2013 10:21, schrieb Sven Gehr:
Hi@all,
I want to install bacula on a ubuntu-server (12.04.01-LTS / 64bit). I
install with the following command:
aptitude install postgresql
aptitude install bacula-director-pgsql bacula-common-pgsql
bacula-sd-pgsql bacula-fd bacula-sd-tools bacula-console
and answer the questions:
Konfigurieren der Datenbank für bacula-director-pgsql mit
dbconfig-common: Ja
PostgreSQL-Anwendungspasswort für bacula-director-pgsql:
secret
Now I want test my director with:
bacula-dir -t
and get the error:
bacula-dir: dird.c:954 Konnte Catalog MyCatalog, database bacula
nicht öffnen.
bacula-dir: dird.c:959 postgresql.c:241 Unable to connect to
PostgreSQL
server. Database=bacula User=bacula
Possible causes: SQL server not running; password incorrect;
max_connections exceeded.
15-Jan 10:04 bacula-dir ERROR TERMINATION
Bitte die Konfigurationsdatei korrigieren: bacula-dir.conf
The role 'bacula' is available:
postgres=# \dg[+]
List of roles
Role name | Attributes | Member
of
| Description
---++---+-
bacula|| {}
|
postgres | Superuser, Create role, Create DB, Replication | {}
|
but I miss the script's (create_bacula_database, make_bacula_tables
and
grant_bacula_privileges). Where can I find the scripts on my
ubuntu-system?
--
Viele Grüsse
Sven Gehr
--
Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS
and more. Get SQL Server skills now (including 2012) with LearnDevNow
-
200+ hours of step-by-step video tutorials by Microsoft MVPs and
experts.
SALE $99.99 this month only - learn more at:
http://p.sf.net/sfu/learnmore_122512
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
--
Viele Grüsse
Sven Gehr
--
Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS
and more. Get SQL Server skills now (including 2012) with LearnDevNow -
200+ hours of step-by-step video tutorials by Microsoft MVPs and experts.
SALE $99.99 this month only - learn more at:
http://p.sf.net/sfu/learnmore_122512
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Bacula on Ubuntu 12.04.01
I add the line:
hostlocalhost all 127.0.0.1/32trust
an restart the server. Same problem again.
Am 15-01-2013 10:42, schrieb lst_ho...@kwsoft.de:
Zitat von Sven Gehr mailingli...@dreampixel.de:
Hi@all,
I want to install bacula on a ubuntu-server (12.04.01-LTS / 64bit). I
install with the following command:
aptitude install postgresql
aptitude install bacula-director-pgsql bacula-common-pgsql
bacula-sd-pgsql bacula-fd bacula-sd-tools bacula-console
and answer the questions:
Konfigurieren der Datenbank für bacula-director-pgsql mit
dbconfig-common: Ja
PostgreSQL-Anwendungspasswort für bacula-director-pgsql:
secret
Now I want test my director with:
bacula-dir -t
and get the error:
bacula-dir: dird.c:954 Konnte Catalog MyCatalog, database bacula
nicht öffnen.
bacula-dir: dird.c:959 postgresql.c:241 Unable to connect to
PostgreSQL
server. Database=bacula User=bacula
Possible causes: SQL server not running; password incorrect;
max_connections exceeded.
15-Jan 10:04 bacula-dir ERROR TERMINATION
Bitte die Konfigurationsdatei korrigieren: bacula-dir.conf
The role 'bacula' is available:
postgres=# \dg[+]
List of roles
Role name | Attributes | Member
of
| Description
---++---+-
bacula|| {}
|
postgres | Superuser, Create role, Create DB, Replication | {}
|
but I miss the script's (create_bacula_database, make_bacula_tables
and
grant_bacula_privileges). Where can I find the scripts on my
ubuntu-system?
Hello
you should check pg_hba.conf. It is set restrictive on a stock Ubuntu
12.04 install and be aware that per default unix sockets are used if
you dont at least specify localhost as target.
Regards
Andreas
--
Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS
and more. Get SQL Server skills now (including 2012) with LearnDevNow
-
200+ hours of step-by-step video tutorials by Microsoft MVPs and
experts.
SALE $99.99 this month only - learn more at:
http://p.sf.net/sfu/learnmore_122512
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
--
Viele Grüsse
Sven Gehr
--
Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS
and more. Get SQL Server skills now (including 2012) with LearnDevNow -
200+ hours of step-by-step video tutorials by Microsoft MVPs and experts.
SALE $99.99 this month only - learn more at:
http://p.sf.net/sfu/learnmore_122512
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Which is better, conio or readline
On Mon, Jan 14, 2013 at 03:55:45PM +0100, Radosław Korzeniewski wrote: Hello, 2013/1/14 jba...@bayertechnologygroup.com If you have both, which would be better to use? Use readline and disable conio. How about command line completion via TAB, is this feature available in the community version? I have one instance (out of four) compiled with readline instead of conio and hitting TAB does nothing. Cheers, Uwe -- Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS and more. Get SQL Server skills now (including 2012) with LearnDevNow - 200+ hours of step-by-step video tutorials by Microsoft MVPs and experts. SALE $99.99 this month only - learn more at: http://p.sf.net/sfu/learnmore_122512 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Bacula on Ubuntu 12.04.01
Zitat von Sven Gehr mailingli...@dreampixel.de: I add the line: hostlocalhost all 127.0.0.1/32trust an restart the server. Same problem again. Check if DB Adress = localhost is set in your Bacula-Directory config file, if not the unix sockets are used, which work by trusting the matching OS user. It does not work if you test as root or other non-bacula user. You should also reset the above line to md5 instead of trust Regards Andreas -- Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS and more. Get SQL Server skills now (including 2012) with LearnDevNow - 200+ hours of step-by-step video tutorials by Microsoft MVPs and experts. SALE $99.99 this month only - learn more at: http://p.sf.net/sfu/learnmore_122512 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Which is better, conio or readline
Uwe Schuerkamp uwe.schuerkamp at nionex.net writes: How about command line completion via TAB, is this feature available in the community version? I have one instance (out of four) compiled with readline instead of conio and hitting TAB does nothing. Yes try hitting tab twice. Been working for a couple of years is not an Enterprise only feature. It queries the director for a list of needed keywords, storages and it also works in the restore selection. Only then it only completes one level e.g. you have to do multiple completions for a deep path. Marco -- Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS and more. Get SQL Server skills now (including 2012) with LearnDevNow - 200+ hours of step-by-step video tutorials by Microsoft MVPs and experts. SALE $99.99 this month only - learn more at: http://p.sf.net/sfu/learnmore_122512 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Bacula on Ubuntu 12.04.01
You should also reset the above line to md5 instead of trust
ok, I chanege the line to:
hostlocalhost all 0.0.0.0/0 md5
Check if DB Adress = localhost is set in your Bacula-Directory
after the install the section looks like:
Catalog {
Name = MyCatalog
# Uncomment the following line if you want the dbi driver
# dbdriver = dbi:sqlite3; dbaddress = 127.0.0.1; dbport =
dbname = bacula; DB Address = ; dbuser = bacula; dbpassword =
geheim
}
I set the DB Address an now it works.
many many thanks !!!
--
Viele Grüsse
Sven Gehr
--
Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS
and more. Get SQL Server skills now (including 2012) with LearnDevNow -
200+ hours of step-by-step video tutorials by Microsoft MVPs and experts.
SALE $99.99 this month only - learn more at:
http://p.sf.net/sfu/learnmore_122512
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] UbuntuRepositorie?
Hi@all, I use ubuntu server 12.04 LTS because of the long suport an here are the version 5.2.5 available. For other linux-distros I found repos with newer version: http://download.opensuse.org/repositories/home:/dassit:/bacula/ but not for ubuntu. Does anyone have a repo with newer versions? -- Viele Grüsse Sven Gehr -- Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS and more. Get SQL Server skills now (including 2012) with LearnDevNow - 200+ hours of step-by-step video tutorials by Microsoft MVPs and experts. SALE $99.99 this month only - learn more at: http://p.sf.net/sfu/learnmore_122512 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] UbuntuRepositorie?
On 15 January 2013 14:06, Sven Gehr mailingli...@dreampixel.de wrote: I use ubuntu server 12.04 LTS because of the long suport an here are the version 5.2.5 available. For other linux-distros I found repos with newer version: http://download.opensuse.org/repositories/home:/dassit:/bacula/ Sorry, can't help for Ubuntu, but since is the first time I see this repository I would like to comment on the Fedora/RHEL packages. In my opinion the SPEC file is really over-complicated and the changelog stops at 5.2.10. Some pacakges are the same version of the packages already in the distribution: Fedora 17/18/19 = 5.2.12 Fedora 16 = 5.0.3 (EOL in a month) CentOS/RHEL 5 (epel) = 2.4.4 CentOS/RHEL 6 (official) = 5.0.0 Regards, --Simone -- You cannot discover new oceans unless you have the courage to lose sight of the shore (R. W. Emerson). -- Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS and more. Get SQL Server skills now (including 2012) with LearnDevNow - 200+ hours of step-by-step video tutorials by Microsoft MVPs and experts. SALE $99.99 this month only - learn more at: http://p.sf.net/sfu/learnmore_122512___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] GZIP not supported on this Client
Hello, I'm not 100% my last request made the list, or if there were simply no known answers or others who experienced this, so my apologies for the latter two. I'm trying a bare-metal recovery of Ubuntu 10.04 LTS with Bacula (static-bacula-fd) using the method described in the Bacula documentation, but I'm seeing an error: Warning: GZIP is not supported on this client. Bacula Console states the restore was successful, but no files show up on the target system. Is there a proper way to boot the system from Rescue Broken System mode, start the static Bacula daemon, and recover the system that wasn't show in the docs? I've also tried installing the base OS, then Bacula-fd, then restore full system, but if I do that even root can no longer log into the system (corrupted pam.d?). Has anyone run into this and know what I'm missing? I know there's a right way, or Bacula wouldn't be so successful. Thanks in advance!! Brian P.S. I can email more info on my Procedure, I just wanted to see if everyone gets this question in the Inbox first. :) -- Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS and more. Get SQL Server skills now (including 2012) with LearnDevNow - 200+ hours of step-by-step video tutorials by Microsoft MVPs and experts. SALE $99.99 this month only - learn more at: http://p.sf.net/sfu/learnmore_122512___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] GZIP not supported on this Client
Sounds to me like the client was built without the GZIP library or something like that. That's unfortunate, but my guess is the solution is to create/restore a backup that isn't GZIP compressed or to build a new client that includes support. From: brconflict [mailto:brconfl...@gmail.com] Sent: Tuesday, January 15, 2013 09:33 AM To: Bacula-users@lists.sourceforge.net Bacula-users@lists.sourceforge.net Subject: [Bacula-users] GZIP not supported on this Client Hello, I'm not 100% my last request made the list, or if there were simply no known answers or others who experienced this, so my apologies for the latter two. I'm trying a bare-metal recovery of Ubuntu 10.04 LTS with Bacula (static-bacula-fd) using the method described in the Bacula documentation, but I'm seeing an error: Warning: GZIP is not supported on this client. Bacula Console states the restore was successful, but no files show up on the target system. Is there a proper way to boot the system from Rescue Broken System mode, start the static Bacula daemon, and recover the system that wasn't show in the docs? I've also tried installing the base OS, then Bacula-fd, then restore full system, but if I do that even root can no longer log into the system (corrupted pam.d?). Has anyone run into this and know what I'm missing? I know there's a right way, or Bacula wouldn't be so successful. Thanks in advance!! Brian P.S. I can email more info on my Procedure, I just wanted to see if everyone gets this question in the Inbox first. :) -- Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS and more. Get SQL Server skills now (including 2012) with LearnDevNow - 200+ hours of step-by-step video tutorials by Microsoft MVPs and experts. SALE $99.99 this month only - learn more at: http://p.sf.net/sfu/learnmore_122512___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] GZIP not supported on this Client
Not sure. Hopefully someone else can answer. I've got to assume this is possible. BTW, it is generally bad list etiquette to respond to replies off list. Always address the mailing list. From: brconflict [mailto:brconfl...@gmail.com] Sent: Tuesday, January 15, 2013 09:51 AM To: Novosielski, Ryan Subject: Re: [Bacula-users] GZIP not supported on this Client Ryan, Thanks! That's what I uncovered as well. I'm sure this is a simple thing I'm missing. Unfortunately, we use GZIP for backups from even before I started doing this. I compiled as: ./configure--prefix=/usr \ --sbindir=/usr/sbin --sysconfdir=/etc/bacula \ --with-scriptdir=/etc/bacula --enable-smartalloc \ --enable-client-only –enable-static-client-only --enable- static-fd --disable-libtool make Then I grabbed the ~/src/filed/static-bacula-fd and a valid bacula-fd.conf and copied them to a USB stick. I'm just not sure how to tell if the static-bacula-fd daemon was compiled with GZIP. Is there a way to tell? Or, is there a way I can specify where libz.so files are located when starting the static-bacula-fd daemon? Thanks!! Brian On Tue, Jan 15, 2013 at 8:45 AM, Novosielski, Ryan novos...@umdnj.edumailto:novos...@umdnj.edu wrote: Sounds to me like the client was built without the GZIP library or something like that. That's unfortunate, but my guess is the solution is to create/restore a backup that isn't GZIP compressed or to build a new client that includes support. From: brconflict [mailto:brconfl...@gmail.commailto:brconfl...@gmail.com] Sent: Tuesday, January 15, 2013 09:33 AM To: Bacula-users@lists.sourceforge.netmailto:Bacula-users@lists.sourceforge.net Bacula-users@lists.sourceforge.netmailto:Bacula-users@lists.sourceforge.net Subject: [Bacula-users] GZIP not supported on this Client Hello, I'm not 100% my last request made the list, or if there were simply no known answers or others who experienced this, so my apologies for the latter two. I'm trying a bare-metal recovery of Ubuntu 10.04 LTS with Bacula (static-bacula-fd) using the method described in the Bacula documentation, but I'm seeing an error: Warning: GZIP is not supported on this client. Bacula Console states the restore was successful, but no files show up on the target system. Is there a proper way to boot the system from Rescue Broken System mode, start the static Bacula daemon, and recover the system that wasn't show in the docs? I've also tried installing the base OS, then Bacula-fd, then restore full system, but if I do that even root can no longer log into the system (corrupted pam.d?). Has anyone run into this and know what I'm missing? I know there's a right way, or Bacula wouldn't be so successful. Thanks in advance!! Brian P.S. I can email more info on my Procedure, I just wanted to see if everyone gets this question in the Inbox first. :) -- Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS and more. Get SQL Server skills now (including 2012) with LearnDevNow - 200+ hours of step-by-step video tutorials by Microsoft MVPs and experts. SALE $99.99 this month only - learn more at: http://p.sf.net/sfu/learnmore_122512___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] GZIP not supported on this Client
Yeah, I subscribed and attempted to email the list there. I think my timing was bad. Ok, so one thing I'll try is to Install the base system, then bacula-fd, restore the system, then attempt to reset the root passwd while I'm SSH'd to the system before getting kicked out. Will see what that does. But for the static-bacula-fd compiled with GZIP, I'd like to see if I can fix that so I know bare-metal would be an option. Thanks! On Tue, Jan 15, 2013 at 8:54 AM, Novosielski, Ryan novos...@umdnj.eduwrote: Not sure. Hopefully someone else can answer. I've got to assume this is possible. BTW, it is generally bad list etiquette to respond to replies off list. Always address the mailing list. *From*: brconflict [mailto:brconfl...@gmail.com] *Sent*: Tuesday, January 15, 2013 09:51 AM *To*: Novosielski, Ryan *Subject*: Re: [Bacula-users] GZIP not supported on this Client Ryan, Thanks! That's what I uncovered as well. I'm sure this is a simple thing I'm missing. Unfortunately, we use GZIP for backups from even before I started doing this. I compiled as: *./configure--prefix=/usr \* * --sbindir=/usr/sbin --sysconfdir=/etc/bacula \* * --with-scriptdir=/etc/bacula --enable-smartalloc \* * --enable-client-only –enable-static-client-only --enable- * * static-fd --disable-libtool* *make* Then I grabbed the ~/src/filed/static-bacula-fd and a valid bacula-fd.conf and copied them to a USB stick. I'm just not sure how to tell if the static-bacula-fd daemon was compiled with GZIP. Is there a way to tell? Or, is there a way I can specify where libz.so files are located when starting the static-bacula-fd daemon? Thanks!! Brian On Tue, Jan 15, 2013 at 8:45 AM, Novosielski, Ryan novos...@umdnj.eduwrote: Sounds to me like the client was built without the GZIP library or something like that. That's unfortunate, but my guess is the solution is to create/restore a backup that isn't GZIP compressed or to build a new client that includes support. *From*: brconflict [mailto:brconfl...@gmail.com] *Sent*: Tuesday, January 15, 2013 09:33 AM *To*: Bacula-users@lists.sourceforge.net Bacula-users@lists.sourceforge.net *Subject*: [Bacula-users] GZIP not supported on this Client Hello, I'm not 100% my last request made the list, or if there were simply no known answers or others who experienced this, so my apologies for the latter two. I'm trying a bare-metal recovery of Ubuntu 10.04 LTS with Bacula (static-bacula-fd) using the method described in the Bacula documentation, but I'm seeing an error: Warning: GZIP is not supported on this client. Bacula Console states the restore was successful, but no files show up on the target system. Is there a proper way to boot the system from Rescue Broken System mode, start the static Bacula daemon, and recover the system that wasn't show in the docs? I've also tried installing the base OS, then Bacula-fd, then restore full system, but if I do that even root can no longer log into the system (corrupted pam.d?). Has anyone run into this and know what I'm missing? I know there's a right way, or Bacula wouldn't be so successful. Thanks in advance!! Brian P.S. I can email more info on my Procedure, I just wanted to see if everyone gets this question in the Inbox first. :) -- Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS and more. Get SQL Server skills now (including 2012) with LearnDevNow - 200+ hours of step-by-step video tutorials by Microsoft MVPs and experts. SALE $99.99 this month only - learn more at: http://p.sf.net/sfu/learnmore_122512___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] restore performance
On Mon, Jan 14, 2013 at 09:01:32AM -0500, Novosielski, Ryan wrote: http://wiki.bacula.org/doku.php?id=faq#restore_takes_a_long_time_to_retrieve_sql_results_from_mysql_catalog Actually, after re-reading that, I'm a little confused. I don't know whether it says to drop all indexes except for primary and then drop the listed indices or drop everything except for primary and except for the listed indices. In any case, this solved the problem for me. I wonder if a repair would have also and maybe that's why? I have the following indexes defined on the File table: MariaDB [bacula] show indexes in File ; +---++--+--+-+---+-+--++--++-+---+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | +---++--+--+-+---+-+--++--++-+---+ | File | 0 | PRIMARY |1 | FileId | A | 947714927 | NULL | NULL | | BTREE | | | | File | 1 | JobId|1 | JobId | A |2513 | NULL | NULL | | BTREE | | | | File | 1 | JobId_2 |1 | JobId | A |2513 | NULL | NULL | | BTREE | | | | File | 1 | JobId_2 |2 | PathId | A |30571449 | NULL | NULL | | BTREE | | | | File | 1 | JobId_2 |3 | FilenameId | A | 947714927 | NULL | NULL | | BTREE | | | +---++--+--+-+---+-+--++--++-+---+ 5 rows in set (0.00 sec) MariaDB [bacula] select count(*) from File ; +---+ | count(*) | +---+ | 947749966 | +---+ 1 row in set (0.00 sec) So it seems I'm more or less in the clear regarding our index setup, or am I missing something? Cheers thanks in advance, Uwe -- Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS and more. Get SQL Server skills now (including 2012) with LearnDevNow - 200+ hours of step-by-step video tutorials by Microsoft MVPs and experts. SALE $99.99 this month only - learn more at: http://p.sf.net/sfu/learnmore_122512 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] UbuntuRepositorie?
Zitat von Sven Gehr mailingli...@dreampixel.de: Hi@all, I use ubuntu server 12.04 LTS because of the long suport an here are the version 5.2.5 available. For other linux-distros I found repos with newer version: http://download.opensuse.org/repositories/home:/dassit:/bacula/ This is a common problem of using distribution packages. The release version is merely frozen and only security fixes will be backported. If there is a busy maintainer you sometimes get personal repositories but for Ubuntu none exists to my knowledge... but not for ubuntu. Does anyone have a repo with newer versions? We have build Ubuntu 12.04 x64 style deb-packages for our own server with the 5.2.12, but there is no public repository. I can sent you a URL in personal mail to the as-is tar.gz archiv. Regards Andreas -- Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS and more. Get SQL Server skills now (including 2012) with LearnDevNow - 200+ hours of step-by-step video tutorials by Microsoft MVPs and experts. SALE $99.99 this month only - learn more at: http://p.sf.net/sfu/learnmore_122512 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] windows enterprise is not working, x32/x64.
On Jan 14, 2013, at 3:41 PM, Adrian Reyer wrote: On Sun, Jan 13, 2013 at 06:00:18PM -0500, Bryan Harris wrote: Bacula community edition will continue, unix, linux, windows products? I think he means Will Windows be supported?, or Will Windows continue?, or something along those lines. Here is my understanding, feel free to correct me if I'm wrong: As I understand the mentioned page, there won't be precompiled Windows Community Binaries anymore. However, windows as a client will still be supported, but you have to compile it yourself. As windows users/administrators are not as used to compiling things as linux/unix users are, there is an offer of Bacula Systems on precompiled Enterprise versions. Alternatively someone else could just step up and offer the precompiled windows binaries. If I misgot this and future windows fd-development ceased to exist, the code about to be removed, I'd see it as a serious problem as it damages the credibility of bacula as an available system. Umm, where did you get that idea from? Wild speculation, without foundation from what I understand. There has been no mention of removing support for Windows clients. Bacula Systems is not a solution to this as it is not free software and if tomorrow Bacula Systems decides to only support e.g. Android as the single plattform, there is no source to continue with. Don't misunderstand me there, I really like Bacula Systems providing the Enterprise windows binaries. I'd prefer them to provide the community binaries, though, The community is free to provide community binaries. it is clear that nobody in the community is willing to do that work. and while they are at it, perhaps 'certified' community binaries for the major linux distributions. I think the project has no business supplying binaries. I believe that is the responsibility of each project (e.g. FreeBSD, NetBSD, etc). The Bacula community project needs more volunteers. if someone wants something badly enough, then they'll step up and do the work. Otherwise, it won't get done. That's the nature of a volunteer project. -- Dan Langille - http://langille.org -- Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS and more. Get SQL Server skills now (including 2012) with LearnDevNow - 200+ hours of step-by-step video tutorials by Microsoft MVPs and experts. SALE $99.99 this month only - learn more at: http://p.sf.net/sfu/learnmore_122512 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] restore performance
I would say it depends on your read of that article and either way whether or not you believe it. I'm not quite sure what to think. I believe I will re-add the indices I dropped and see what happens. - Original Message - From: Uwe Schuerkamp [mailto:uwe.schuerk...@nionex.net] Sent: Tuesday, January 15, 2013 10:32 AM To: Novosielski, Ryan Cc: John Drescher dresche...@gmail.com; bacula-users Bacula-users@lists.sourceforge.net Subject: Re: [Bacula-users] restore performance On Mon, Jan 14, 2013 at 09:01:32AM -0500, Novosielski, Ryan wrote: http://wiki.bacula.org/doku.php?id=faq#restore_takes_a_long_time_to_retrieve_sql_results_from_mysql_catalog Actually, after re-reading that, I'm a little confused. I don't know whether it says to drop all indexes except for primary and then drop the listed indices or drop everything except for primary and except for the listed indices. In any case, this solved the problem for me. I wonder if a repair would have also and maybe that's why? I have the following indexes defined on the File table: MariaDB [bacula] show indexes in File ; +---++--+--+-+---+-+--++--++-+---+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | +---++--+--+-+---+-+--++--++-+---+ | File | 0 | PRIMARY |1 | FileId | A | 947714927 | NULL | NULL | | BTREE | | | | File | 1 | JobId|1 | JobId | A |2513 | NULL | NULL | | BTREE | | | | File | 1 | JobId_2 |1 | JobId | A |2513 | NULL | NULL | | BTREE | | | | File | 1 | JobId_2 |2 | PathId | A |30571449 | NULL | NULL | | BTREE | | | | File | 1 | JobId_2 |3 | FilenameId | A | 947714927 | NULL | NULL | | BTREE | | | +---++--+--+-+---+-+--++--++-+---+ 5 rows in set (0.00 sec) MariaDB [bacula] select count(*) from File ; +---+ | count(*) | +---+ | 947749966 | +---+ 1 row in set (0.00 sec) So it seems I'm more or less in the clear regarding our index setup, or am I missing something? Cheers thanks in advance, Uwe -- Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS and more. Get SQL Server skills now (including 2012) with LearnDevNow - 200+ hours of step-by-step video tutorials by Microsoft MVPs and experts. SALE $99.99 this month only - learn more at: http://p.sf.net/sfu/learnmore_122512 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] windows enterprise is not working, x32/x64.
On 2013-01-15 17:02, Dan Langille wrote: On Jan 14, 2013, at 3:41 PM, Adrian Reyer wrote: On Sun, Jan 13, 2013 at 06:00:18PM -0500, Bryan Harris wrote: Bacula community edition will continue, unix, linux, windows products? I think he means Will Windows be supported?, or Will Windows continue?, or something along those lines. Here is my understanding, feel free to correct me if I'm wrong: As I understand the mentioned page, there won't be precompiled Windows Community Binaries anymore. However, windows as a client will still be supported, but you have to compile it yourself. As windows users/administrators are not as used to compiling things as linux/unix users are, there is an offer of Bacula Systems on precompiled Enterprise versions. Alternatively someone else could just step up and offer the precompiled windows binaries. If I misgot this and future windows fd-development ceased to exist, the code about to be removed, I'd see it as a serious problem as it damages the credibility of bacula as an available system. Umm, where did you get that idea from? Wild speculation, without foundation from what I understand. There has been no mention of removing support for Windows clients. Bacula Systems is not a solution to this as it is not free software and if tomorrow Bacula Systems decides to only support e.g. Android as the single plattform, there is no source to continue with. Don't misunderstand me there, I really like Bacula Systems providing the Enterprise windows binaries. I'd prefer them to provide the community binaries, though, The community is free to provide community binaries. it is clear that nobody in the community is willing to do that work. The documentation on how to build the binaries is really outdated. The minimum requirements of Qt etc are not more up-to-date. The build system is also a bit annoying. The gcc/mingw version that it uses is so old, that it gives issues on some newer systems. I've been able to build a 64bit windows exe/dll on a Ubuntu 12.10 system with the mingw64 from packages in Ubuntu. Also used OpenSSL 1.0 instead of the older versions given in the build docs for win32. I had to change some small things in the code the build system to get everything building. The symbols file also contains issues (missing exports). Maby I should file a bug for this? So the build system can be improved a bit on Windows? Then its really not a big issue to build Bacula exe's. I did not build bat yet, only the bacula-fd exe's itself (which is enough for most of the users). and while they are at it, perhaps 'certified' community binaries for the major linux distributions. I think the project has no business supplying binaries. I believe that is the responsibility of each project (e.g. FreeBSD, NetBSD, etc). The Bacula community project needs more volunteers. if someone wants something badly enough, then they'll step up and do the work. Otherwise, it won't get done. That's the nature of a volunteer project. -- Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS and more. Get SQL Server skills now (including 2012) with LearnDevNow - 200+ hours of step-by-step video tutorials by Microsoft MVPs and experts. SALE $99.99 this month only - learn more at: http://p.sf.net/sfu/learnmore_122512 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] GZIP not supported on this Client
On Tue, 15 Jan 2013 09:23:21 -0600, brconflict said: Yeah, I subscribed and attempted to email the list there. I think my timing was bad. Ok, so one thing I'll try is to Install the base system, then bacula-fd, restore the system, then attempt to reset the root passwd while I'm SSH'd to the system before getting kicked out. Will see what that does. But for the static-bacula-fd compiled with GZIP, I'd like to see if I can fix that so I know bare-metal would be an option. Have you checked if a bacula-fd built with --disable-libtool (but not the --enable-static... options) will run in the bare-metal recovery shell? That would be much simpler than trying to link everything statically. __Martin Thanks! On Tue, Jan 15, 2013 at 8:54 AM, Novosielski, Ryan novos...@umdnj.eduwrote: Not sure. Hopefully someone else can answer. I've got to assume this is possible. BTW, it is generally bad list etiquette to respond to replies off list. Always address the mailing list. *From*: brconflict [mailto:brconfl...@gmail.com] *Sent*: Tuesday, January 15, 2013 09:51 AM *To*: Novosielski, Ryan *Subject*: Re: [Bacula-users] GZIP not supported on this Client Ryan, Thanks! That's what I uncovered as well. I'm sure this is a simple thing I'm missing. Unfortunately, we use GZIP for backups from even before I started doing this. I compiled as: *./configure--prefix=/usr \* * --sbindir=/usr/sbin --sysconfdir=/etc/bacula \* * --with-scriptdir=/etc/bacula --enable-smartalloc \* * --enable-client-only enable-static-client-only --enable- * * static-fd --disable-libtool* *make* Then I grabbed the ~/src/filed/static-bacula-fd and a valid bacula-fd.conf and copied them to a USB stick. I'm just not sure how to tell if the static-bacula-fd daemon was compiled with GZIP. Is there a way to tell? Or, is there a way I can specify where libz.so files are located when starting the static-bacula-fd daemon? Thanks!! Brian On Tue, Jan 15, 2013 at 8:45 AM, Novosielski, Ryan novos...@umdnj.eduwrote: Sounds to me like the client was built without the GZIP library or something like that. That's unfortunate, but my guess is the solution is to create/restore a backup that isn't GZIP compressed or to build a new client that includes support. *From*: brconflict [mailto:brconfl...@gmail.com] *Sent*: Tuesday, January 15, 2013 09:33 AM *To*: Bacula-users@lists.sourceforge.net Bacula-users@lists.sourceforge.net *Subject*: [Bacula-users] GZIP not supported on this Client Hello, I'm not 100% my last request made the list, or if there were simply no known answers or others who experienced this, so my apologies for the latter two. I'm trying a bare-metal recovery of Ubuntu 10.04 LTS with Bacula (static-bacula-fd) using the method described in the Bacula documentation, but I'm seeing an error: Warning: GZIP is not supported on this client. Bacula Console states the restore was successful, but no files show up on the target system. Is there a proper way to boot the system from Rescue Broken System mode, start the static Bacula daemon, and recover the system that wasn't show in the docs? I've also tried installing the base OS, then Bacula-fd, then restore full system, but if I do that even root can no longer log into the system (corrupted pam.d?). Has anyone run into this and know what I'm missing? I know there's a right way, or Bacula wouldn't be so successful. Thanks in advance!! Brian P.S. I can email more info on my Procedure, I just wanted to see if everyone gets this question in the Inbox first. :) -- Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS and more. Get SQL Server skills now (including 2012) with LearnDevNow - 200+ hours of step-by-step video tutorials by Microsoft MVPs and experts. SALE $99.99 this month only - learn more at: http://p.sf.net/sfu/learnmore_122512 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] LTO-5 Tapes full after between 30-130gb Dell PV-124T
Hi,
I'm using a Bacula setup in conjunction with a Dell PV-124T which has 16 LTO-5
tapes. The system works correctly except that the tapes become extremely
quickly. There is no consistency between the amount written to each tape though
it is generally in the range of 30-130gb - far less then the expected volume.
I'm not getting an error messages in either dmesg or kern.log, there are no
errors when swapping between tapes bacula simply gets back a -1 from the tape
drive:
bacula-sd End of Volume Tape13 at 3:8729 on device LTO5-Drive1 (/dev/nst0).
Write of 1048576 bytes got -1.
bacula-sd Re-read of last block succeeded.
My dir:
Pool {
Name = LTO5
Pool Type = Backup
Recycle = yes # Bacula can automatically recycle Volumes
AutoPrune = yes # Prune expired volumes
Volume Retention = 45 days # one year
}
Storage {
Name = LTO5
Address = localhost# N.B. Use a fully qualified name here
SDPort = 9103
Password = password
Device = PV-124T
Media Type = LTO5
Autochanger = Yes
}
Client {
Name = bacula-fd-local
Address = localhost
FDPort = 9102
Catalog = MyCatalog
Password = password # password for FileDaemon
File Retention = 45 days# 30 days
Job Retention = 6 months# six months
AutoPrune = yes # Prune expired Jobs/Files
}
JobDefs {
Name = DefaultJob
Type = Backup
Level = Incremental
Client = bacula-fd-local
Messages = Standard
Pool = LTO5
Priority = 10
Write Bootstrap = /var/lib/bacula/%c.bsr
}
Job {
Name = HeritageJob
JobDefs = DefaultJob
FileSet = HeritageSet
Schedule = WeeklyCycle2
Storage=LTO5
}
My sd:
Storage { # definition of myself
Name = bacula-sd
SDPort = 9103 # Director's port
WorkingDirectory = /var/lib/bacula
Pid Directory = /var/run/bacula
Maximum Concurrent Jobs = 20
SDAddress = 127.0.0.1
}
Device {
Name = LTO5-Drive1
Drive Index = 0
Media Type = LTO5
Device Type = Tape
Archive Device = /dev/nst0
Changer Device = /dev/sg4
AutomaticMount = yes; # when device opened, read it
AlwaysOpen = yes;
RemovableMedia = yes;
RandomAccess = no;
AutoChanger = yes;
Maximum File Size = 10G
#Maximum Spool Size = 50G
#Maximum Job Spool Size = 20G # will need this is there are concurrent jobs
Maximum Block Size = 1024k
Spool Directory = /home/bacula/tapehold
Alert Command = sh -c 'tapeinfo -f %c |grep TapeAlert|cat'
}
Autochanger {
Name = PV-124T
Device = LTO5-Drive1
Changer Command = /etc/bacula/scripts/mtx-changer %c %o %S %a %d
Changer Device = /dev/sg4
}
If anyone could suggest any possible routes to a solution or perhaps mistakes
I've made in config I would greatly appreciate it.
Thanks,
Bill
--
Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS
and more. Get SQL Server skills now (including 2012) with LearnDevNow -
200+ hours of step-by-step video tutorials by Microsoft MVPs and experts.
SALE $99.99 this month only - learn more at:
http://p.sf.net/sfu/learnmore_122512___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Data encryption fails if backed up from fifo
Files backed up with readfifo = yes seem to be backed up fine: --- Software Compression: None VSS:no Encryption: yes Accurate: no Volume name(s): DB1-DB-DAILY-0120 Volume Session Id: 15 Volume Session Time:1358198139 Last Volume Bytes: 15,341,071,607 (15.34 GB) Non-fatal FD errors:0 SD Errors: 0 FD termination status: OK SD termination status: OK Termination:Backup OK --- Trying to restore them fails with following err: --- 15-Jan 22:21 db1-fd JobId 2492: Error: restore.c:772 \ Missing encryption session data stream for /usr/local/pgsql/bacula_backup/fifo/development.data.dump --- No problems to backup and restore flat files with data encryption. This is bacula 5.2.12 (12Sep12). Tested with clients on FreeBSD 8.2 and 9.1. Axel --- PGP-Key:29E99DD6 ☀ +49 151 2300 9283 ☀ computing @ chaos claudius -- Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS and more. Get SQL Server skills now (including 2012) with LearnDevNow - 200+ hours of step-by-step video tutorials by Microsoft MVPs and experts. SALE $99.99 this month only - learn more at: http://p.sf.net/sfu/learnmore_122512 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
