Re: [Bacula-users] Latest Files link on bacula.org

2013-03-05 Thread Geert Stappers
Op 2013-02-21 om 19:20 schreef Uwe Schuerkamp:
 Hi folks,
 
 the current files link on the bacula website still points to release
 5.2.6 which might confuse some people ;) 
 

I had a closer look.

My git clone http://git.bacula.org/docs has
file home-page/en/page/dl.php with
function getfiles() {
   $ch = curl_init();
   curl_setopt($ch, CURLOPT_URL, 
http://sourceforge.net/projects/bacula/files/;);
   curl_setopt($ch, CURLOPT_HEADER, false);
   curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
   curl_setopt($ch, CURLOPT_FOLLOWLOCATION, true);
   $res = curl_exec($ch);
   curl_close($ch);

   $res = strstr($res, All Files);
//   echo res=$res;
   $res = str_replace(\n, , $res);
   $res = str_replace(\r, , $res);

   // get list of all available files and their attributes
   $count = preg_match_all(
  //  catversname
  !href=\(/projects/bacula/files/([^/]+)/([^/]+)/([^/]+)/download)\ .
  //size date downloads
  .*?td([\d\.]+ [a-zA-Z]+)/td.*?td(.*?)/td.*?td(.*?)/td!,
  $res, $files, PREG_SET_ORDER);

   // remove duplicates (due to latest files list)
   $out = array_filter_unique(
  $files, create_function('$a,$b', 'return strcmp($a[1], $b[1]);'));
   return $out;
}

What I see is that the string 'All Files' is gone from 
http://sourceforge.net/projects/bacula/files/


So far for this week.

Cheers
Geert Stappers
http://www.vanadcimplicity.com/
--
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_feb
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] bconsole autocomplete and history feature

2013-03-05 Thread Uwe Schuerkamp
On Mon, Mar 04, 2013 at 11:23:17PM +0200, Andrei Moraru wrote:
 Hi,
 
 I have installed Bacula v5.2.13 on Debian 6.0.6 x86_64
 
 
 In a putty session to the VM hosting the Bacula director, I connect to the
 console of Bacula by using bconsole utility.
 Unfortunately, I don't have autocomplete option in bconsole (by using TAB
 key) nor the history of commands entered (by using UP arrow button)
 
 Please advice how to activate these two options in bconsole.
 
 Thanks
 

Hello Andrei, 

I assume you compiled 5.2.13 from source? If so, make sure your
configure output displays either readline and / or conio enabled, this
will provide you with the history feature. 

For TAB autocompletion, I tried to activate it several times but
failed miserably. ;) 

You may need to install a variety of development packages in debian, try
readline-dev, ncurses-dev and so on (sorry, I cannot provide exact
package names as I'm on CentOS ATM). 

Good luck, 

Uwe 

-- 
NIONEX --- Ein Unternehmen der Bertelsmann SE  Co. KGaA



--
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_feb
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Migrating from myisam to innodb

2013-03-05 Thread Uwe Schuerkamp
On Tue, Mar 05, 2013 at 11:26:45AM +, Alan Brown wrote:
 On 01/03/13 11:16, Uwe Schuerkamp wrote:

 There's no real need for that. If you tell mysqldump to use compatible 
 dump formats then postgres will import it. (mysqldump --compatible=(name))
 

Hi Alan, thanks for the heads-up. 

 I'd recommend using the --no-create flags too.
 

Ok, I'll keep that in mind. 


 
 As has been posted here already:
 
 If you're stuck with 8Gb then use Inno, but given the price of a decent 
 tape drive it's false economy to run in a memory-starved environment.
 

I'm sorry for any confusion, I have 8GB on the *test* server that I
did my previous myisam  - innodb experiments on. The production
server has 18GB currently and probably could hold a lot more (compaq
proliant dl380G7). 


All the best, Uwe 

-- 
NIONEX --- Ein Unternehmen der Bertelsmann SE  Co. KGaA



--
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_feb
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] List all JOBS of every CATALOGS

2013-03-05 Thread stefano scotti
2013/3/5 Dan Langille d...@langille.org


 On Mar 4, 2013, at 5:00 PM, stefano scotti wrote:

  Hi,
 
  is it possible to list jobs for every catalogs?
 
  the command list jobs list only the jobs of the catalog selected by
  the command use.

 Initial guess: no.

 The Director deals with one Catalog/database at a time.

 why not script it?

 for catalog in $catalogs
 do
   magic
 done

 etc…?

 --
 Dan Langille - http://langille.org



what a pity...

i'd like to use the standard bacula console commands instead of do some
bash tricks every time.

should i ask for this feature in the developer list?

Thanks.
--
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_feb___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] List all JOBS of every CATALOGS

2013-03-05 Thread John Drescher
 i'd like to use the standard bacula console commands instead of do some bash
 tricks every time.

 should i ask for this feature in the developer list?


You can submit a feature request however do not expect your feature
request to be implemented any time soon for the community version
unless you send a patch.

John

--
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_feb
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] Problem with concurrent mixed priority jobs

2013-03-05 Thread stefano scotti
Hi,

My director allows 5 concurrent jobs, and each job has *Allow Mixed Priority
* set to yes.

My aim is that even if a slow job takes a lot of time to finish, there will
be other 4 job slots to use so that the backup system can still work
despite of a really really slow job.

So i can have 4 slow jobs and my system will keep scheduling fast jobs
anyway.

Now, the problem is that only jobs with an higher priority will be
scheduled, lower priority jobs still have to wait even if there are 4 free
job slots!

Is it possible to instruct bacula to let lower priority job be scheduled
not worrying about the priority of current scheduled jobs but only on the
number of free job slots?

Thanks.
--
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_feb___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] update slots scan question

2013-03-05 Thread Uwe Schuerkamp
On Fri, Feb 08, 2013 at 09:40:28AM -0500, Dan Langille wrote:
 On 2013-02-08 05:17, Uwe Schuerkamp wrote:
 I take it that your tape library does not read barcodes?  Or that you 
 are not
 using barcodes.  Which is it?

Hi Dan, thanks much for your answer. 

Our library is unable to read barcodes, we do all the labelling
manually.

snip snip

 No, not quite. inChanger is either 0 or 1 to indicate if it's in the 
 changer.
 

Ok, got it. Now what happens if I have entered a set of new / weof'ed
tapes into the library and all those are being filled with backups until
the first recycle needs to happen? Will bacula (5.2.13) honor the inchanger
flag, recycling the oldest of the volumes present *in* the library or
will it prompt the operator to insert the even older tapes with
inchanger=0 from the update slots scan run? 

I hope I'm making myself clear enough here. ;) 

Previously I manually set each removed volume status to Archive, but
judging from your answer this isn't necessary as the inChanger flag
takes precedence, right? 

All the best, Uwe 



-- 
NIONEX --- Ein Unternehmen der Bertelsmann SE  Co. KGaA



--
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_feb
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Problem with concurrent mixed priority jobs

2013-03-05 Thread Uwe Schuerkamp
On Tue, Mar 05, 2013 at 03:19:29PM +0100, stefano scotti wrote:
 Hi,
 
 My director allows 5 concurrent jobs, and each job has *Allow Mixed Priority
 * set to yes.
 
 My aim is that even if a slow job takes a lot of time to finish, there will
 be other 4 job slots to use so that the backup system can still work
 despite of a really really slow job.
 
 So i can have 4 slow jobs and my system will keep scheduling fast jobs
 anyway.
 
 Now, the problem is that only jobs with an higher priority will be
 scheduled, lower priority jobs still have to wait even if there are 4 free
 job slots!
 
 Is it possible to instruct bacula to let lower priority job be scheduled
 not worrying about the priority of current scheduled jobs but only on the
 number of free job slots?
 
 Thanks.

Hi Stefano,

I don't understand why you're using mixed priorities to begin with as
these have nothing to do with how fast or slow a job runs. You can
simply run all jobs at the same priority and a slow job of a different
priority won't hog your scheduling slots at all. Depending on your
hardware it's usually safe to up the number of concurrent jobs. We
generally use 8-16 concurrent jobs on our bacula directors. 

Cheers, Uwe 


-- 
NIONEX --- Ein Unternehmen der Bertelsmann SE  Co. KGaA



--
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_feb
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] FreeBSD Python link error

2013-03-05 Thread Dan Langille
On 2013-02-20 04:14, Geert Stappers wrote:
 Op 20130218 om 14:54 schreef Dan Langille:
 I'm trying to add Python support to the FreeBSD port.  I'm working 
 on a PR submitted to FreeBSD, but
 I'm getting a link error.  
 http://www.freebsd.org/cgi/query-pr.cgi?pr=ports/171818

 Any ideas?  Full link output at the above URL.

 The main error is:

 Linking bacula-dir ...
 
 /var/ports/usr/home/dan/src/ports/sysutils/bacula-server/work/bacula-5.2.12/libtool
  
 --silent --tag=CXX --mode=link /usr/bin/c++ -L../lib -L../cats 
 -L../findlib -L/usr/local/lib -Wl,-rpath=/usr/lib:/usr/local/lib 
 -L/usr/local/lib -o bacula-dir dird.o admin.o authenticate.o 
 autoprune.o backup.o bsr.o catreq.o dir_plugins.o dird_conf.o expand.o 
 fd_cmds.o getmsg.o inc_conf.o job.o jobq.o migrate.o mountreq.o 
 msgchan.o next_vol.o newvol.o pythondir.o recycle.o restore.o 
 run_conf.o scheduler.o ua_acl.o ua_cmds.o ua_dotcmds.o ua_query.o 
 ua_input.o ua_label.o ua_output.o ua_prune.o ua_purge.o ua_restore.o 
 ua_run.o ua_select.o ua_server.o ua_status.o ua_tree.o ua_update.o 
 vbackup.o verify.o -lbacfind -lbacsql -lbaccats -lbacpy -lbaccfg -lbac 
 -lm -pthread -lutil -lm -lpython2.7 -lutil -lpthread -lintl -lwrap 
 /usr/local/lib/libintl.so /usr/local/lib/libiconv.so -Wl,-rpath 
 -Wl,/usr/local/lib -L/usr/lib -lssl -lcrypto
 dird.o(.text+0x234e): In function `main':
 : undefined reference to 
 `init_python_interpreter(init_python_interpreter_args*)'


 FWIW: the Debian package has a build depend on 'python-dev'


 Stappers
 not familair with FreeBSD equivalents of python-dev


And neither am I.  For now, this extension to the FreeBSD port is 
stalled.

-- 
Dan Langille - http://langille.org/

--
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_feb
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Problem with concurrent mixed priority jobs

2013-03-05 Thread lst_hoe02

Zitat von stefano scotti scottistefan...@gmail.com:

 Hi,

 My director allows 5 concurrent jobs, and each job has *Allow Mixed Priority
 * set to yes.

 My aim is that even if a slow job takes a lot of time to finish, there will
 be other 4 job slots to use so that the backup system can still work
 despite of a really really slow job.

 So i can have 4 slow jobs and my system will keep scheduling fast jobs
 anyway.

 Now, the problem is that only jobs with an higher priority will be
 scheduled, lower priority jobs still have to wait even if there are 4 free
 job slots!

 Is it possible to instruct bacula to let lower priority job be scheduled
 not worrying about the priority of current scheduled jobs but only on the
 number of free job slots?

Hello,

Maybe a misunderstanding on my side but you could simply set all jobs  
to the same priority if you only care about free slots...

Regards

Andreas



--
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_feb
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Job canceling tip

2013-03-05 Thread Dan Langille
On 2013-03-04 04:42, Konstantin Khomoutov wrote:
 On Mon, 4 Mar 2013 08:45:05 +0100
 Geert Stappers geert.stapp...@vanadgroup.com wrote:

 [...]
 Thank you for the tip. I want to share another.
 It is about canceling multiple jobs. Execute from shell

for i in {17..21} ; do echo cancel yes jobid=404${i} | bconsole ;
 done

 Five jobs, 40417-40421, will be canceled.

 A minor nitpick: the construct

 for i in {17..21}; do ...

 is a bashism [1], so it won't work in any POSIX shell.

A good point! I tried the above on FreeBSD:

$ cat test.sh
#!/bin/sh

for i in {17..21} ; do echo cancel yes jobid=404${i} ; done


[dan@bast:~/bin] $ ./sh test.sh
cancel yes jobid=404{17..21}
[dan@bast:~/bin] $


 A portable way to do the same is to use the `seq` program

 for i in `seq 17 21`; do ...

 or to maintain an explicit counter:

 i=17
 while [ $i -le 21 ]; do ...; i=$(($i+1)); done

Then I tried this approach but didn't find seq at all.  I tried sh, 
csh, and tcsh.

But I know about jot.  This does 5 numbers, starting at 17:

$ jot 5 17
17
18
19
20
21

Thus, the script becomes:

$ cat test.sh
#!/bin/sh

for i in `jot 5 17` ; do echo cancel yes jobid=404${i} ; done


$ sh ./test.sh
cancel yes jobid=40417
cancel yes jobid=40418
cancel yes jobid=40419
cancel yes jobid=40420
cancel yes jobid=40421



-- 
Dan Langille - http://langille.org/

--
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_feb
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Problem with concurrent mixed priority jobs

2013-03-05 Thread John Drescher
 Is it possible to instruct bacula to let lower priority job be scheduled not
 worrying about the priority of current scheduled jobs but only on the number
 of free job slots?


No. If you want concurrency make all jobs that you want to run
concurrently run at the same priority.

John

--
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_feb
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] Best way to perform a backup for Sql Server 2012

2013-03-05 Thread Carlo Filippetto
Hi all,
as I write in the subject I need to backup Sql Server 2012, you have
any idea on how to optimize the process and have a consistend DB

I thought to make a dump script and backup it, but how?
Any other ideas?

Thank you.

---
Carlo

--
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_feb
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Problem with concurrent mixed priority jobs

2013-03-05 Thread stefano scotti
2013/3/5 Uwe Schuerkamp uwe.schuerk...@nionex.net

 On Tue, Mar 05, 2013 at 03:19:29PM +0100, stefano scotti wrote:
  Hi,
 
  My director allows 5 concurrent jobs, and each job has *Allow Mixed
 Priority
  * set to yes.
 
  My aim is that even if a slow job takes a lot of time to finish, there
 will
  be other 4 job slots to use so that the backup system can still work
  despite of a really really slow job.
 
  So i can have 4 slow jobs and my system will keep scheduling fast jobs
  anyway.
 
  Now, the problem is that only jobs with an higher priority will be
  scheduled, lower priority jobs still have to wait even if there are 4
 free
  job slots!
 
  Is it possible to instruct bacula to let lower priority job be scheduled
  not worrying about the priority of current scheduled jobs but only on the
  number of free job slots?
 
  Thanks.

 Hi Stefano,

 I don't understand why you're using mixed priorities to begin with as
 these have nothing to do with how fast or slow a job runs. You can
 simply run all jobs at the same priority and a slow job of a different
 priority won't hog your scheduling slots at all. Depending on your
 hardware it's usually safe to up the number of concurrent jobs. We
 generally use 8-16 concurrent jobs on our bacula directors.

 Cheers, Uwe


 --
 NIONEX --- Ein Unternehmen der Bertelsmann SE  Co. KGaA





Hi Uwe,

I'm using mixed priorities because i want to handle the case in which all
job slots are occupied.

For example, if there are only a free slot i'd like to assign it to a more
important job (like mailboxes) instead of a not critical job (like server
configurations).

Are you suggesting that, because of bacula behavior, i should increment the
number of slots instead of assign priorities to the critical jobs?

I don't like very much this solution... a lot of job will eat my bandwidth
slowing every job scheduled in that time, included the critical ones that
should be completed as fast as possible!
That's exactly what i want to avoid.

Thank you again.




-- 

 Please consider the environment before printing this email
--
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_feb___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Best way to perform a backup for Sql Server 2012

2013-03-05 Thread John Drescher
On Tue, Mar 5, 2013 at 9:59 AM, Carlo Filippetto
carlo.filippe...@gmail.com wrote:
 Hi all,
 as I write in the subject I need to backup Sql Server 2012, you have
 any idea on how to optimize the process and have a consistend DB

 I thought to make a dump script and backup it, but how?
 Any other ideas?

 Thank you.


I would use the T-SQL  backup command to backup the sql database to a
file then have bacula backup that file. I have tried scripting dumps
however it seems that the T-SQL BACKUP / RESTORE works better than the
management studio scripting to .sql ( at least in my testing).

John

--
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_feb
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Best way to perform a backup for Sql Server 2012

2013-03-05 Thread Konstantin Khomoutov
On Tue, 5 Mar 2013 15:59:58 +0100
Carlo Filippetto carlo.filippe...@gmail.com wrote:

 as I write in the subject I need to backup Sql Server 2012, you have
 any idea on how to optimize the process and have a consistend DB
 
 I thought to make a dump script and backup it, but how?
 Any other ideas?

Microsoft SQL Server has the VSS writer so you just have to enable VSS
for your backup job and then copy the database files (not transaction
log files though!) as is -- when the Bacula file daemon will enable
VSS on the requested volume(s), MSSQL server will flush any pending
changes to its database files and then the file daemon will copy them
from the shadow partition while they have consistent state.

You can see that VSS writer in the output of the
vssadmin list writers command run from the command prompt.

Another approach is to script running backups of the database files,
perform this script in the [Client] Run Before Job, and then back
up the resulting backup files.

--
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_feb
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Job canceling tip

2013-03-05 Thread Konstantin Khomoutov
On Tue, 05 Mar 2013 09:54:06 -0500
Dan Langille d...@langille.org wrote:

[...]
  A portable way to do the same is to use the `seq` program
 
  for i in `seq 17 21`; do ...
 
  or to maintain an explicit counter:
 
  i=17
  while [ $i -le 21 ]; do ...; i=$(($i+1)); done
 
 Then I tried this approach but didn't find seq at all.  I tried sh, 
 csh, and tcsh.
 
 But I know about jot.  This does 5 numbers, starting at 17:
 
 $ jot 5 17
 17
 18
 19
 20
 21
 
 Thus, the script becomes:
 
 $ cat test.sh
 #!/bin/sh
 
 for i in `jot 5 17` ; do echo cancel yes jobid=404${i} ; done
 
 
 $ sh ./test.sh
 cancel yes jobid=40417
 cancel yes jobid=40418
 cancel yes jobid=40419
 cancel yes jobid=40420
 cancel yes jobid=40421

Okay, it's a slip on my part: seq appears to be a GNU-ism (it's a part
of its coreutils [1] package and hence could be expected to be present
on any sensible system based on Linux).  Conversely, jot is not to be
commonly expected on GNU/Linux systems -- for instance, in Debian, it's
available as a separate package athena-jot, and its source download
location [2] hints that it's a part of some MIT project codenamed Athena
(not sure if it's that one related to X or something other).

Hence I would say using an explicit counter is the only truly portable
method.  At least with POSIX shells.

1. http://www.gnu.org/software/coreutils/
2. 
http://packages.debian.org/changelogs/pool/main/a/athena-jot/athena-jot_9.0-5/copyright

--
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_feb
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] BeforeJob: Can't find your catalog (MyCatalog) in director configuration

2013-03-05 Thread compdoc
2013-03-03 23:10:02   baculaserver-dir JobId 133: shell command: run
BeforeJob /usr/lib64/bacula/make_catalog_backup.pl MyCatalog

 

2013-03-03 23:10:02   baculaserver-dir JobId 133: BeforeJob: sh:
/usr/sbin/dbcheck.mysql: No such file or directory

2013-03-03 23:10:02   baculaserver-dir JobId 133: BeforeJob: Can't find
your catalog (MyCatalog) in director configuration

 

2013-03-03 23:10:02   baculaserver-dir JobId 133: Error: Runscript:
BeforeJob returned non-zero status=1. ERR=Child exited with code 1 

 

2013-03-03 23:10:02   baculaserver-dir JobId 133: Error: Bacula
baculaserver-dir 5.2.12 (12Sep12):

  Build OS:   x86_64-suse-linux-gnu suse 11

  JobId:  133

  Job:MyCatalog.2013-03-03_23.10.00_23

  Backup Level:   Full

  Client: baculaserver-fd 5.2.12 (12Sep12)
x86_64-suse-linux-gnu,suse,11

 

 

 

I'm thinking it might be useful to step through this manually. What is the
result of the following command:

 

sudo /usr/lib64/bacula/make_catalog_backup.pl MyCatalog

 

On mine this takes a few minutes then exits without an error code. 

 

The command:   /usr/sbin/dbcheck.mysql: No such file or directory isn't
working because the file doesn't exist. You need to correct that. Sounds
like you need to rename the file.

 

This site might be useful to you:

 

https://dan.langille.org/2010/03/23/baccula-errors-with-500-backup-catalog/

 

Is bacula working otherwise? Are you able to create backups of your clients?

 

 

--
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_feb___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Job canceling tip

2013-03-05 Thread Dan Langille
On 2013-03-05 11:17, Paul Mather wrote:
 On Mar 5, 2013, at 9:54 AM, Dan Langille d...@langille.org wrote:

 On 2013-03-04 04:42, Konstantin Khomoutov wrote:
 On Mon, 4 Mar 2013 08:45:05 +0100
 Geert Stappers geert.stapp...@vanadgroup.com wrote:

 [...]
 Thank you for the tip. I want to share another.
 It is about canceling multiple jobs. Execute from shell

   for i in {17..21} ; do echo cancel yes jobid=404${i} | bconsole 
 ;
 done

 Five jobs, 40417-40421, will be canceled.

 A minor nitpick: the construct

 for i in {17..21}; do ...

 is a bashism [1], so it won't work in any POSIX shell.

 A good point! I tried the above on FreeBSD:

 $ cat test.sh
 #!/bin/sh

 for i in {17..21} ; do echo cancel yes jobid=404${i} ; done


 [dan@bast:~/bin] $ ./sh test.sh
 cancel yes jobid=404{17..21}
 [dan@bast:~/bin] $


 A portable way to do the same is to use the `seq` program

 for i in `seq 17 21`; do ...

 or to maintain an explicit counter:

 i=17
 while [ $i -le 21 ]; do ...; i=$(($i+1)); done

 Then I tried this approach but didn't find seq at all.  I tried sh,
 csh, and tcsh.


 Seq appeared in FreeBSD 9, so if you tried it in earlier versions
 that's probably why you didn't find it.

Confirmed.  I was using FreeBSD 8.2 there.  I just tried a 9.1 machine:

$ seq 1 3
1
2
3
$

And from man seq:

HISTORY
  The seq command first appeared in Plan 9 from Bell Labs.  A seq 
command
  appeared in NetBSD 3.0, and ported to FreeBSD 9.0.  This command 
was
  based on the command of the same name in Plan 9 from Bell Labs and 
the
  GNU core utilities.  The GNU seq command first appeared in the 
1.13 shell
  utilities release.

 Using seq, you might have to use -f %02g to get two-digit sequences
 with leading zeros (or -f %0Ng to get N-digit sequences with 
 leading
 zeros).

Nice!



 But I know about jot.  This does 5 numbers, starting at 17:

 $ jot 5 17
 17
 18
 19
 20
 21

 Thus, the script becomes:

 $ cat test.sh
 #!/bin/sh

 for i in `jot 5 17` ; do echo cancel yes jobid=404${i} ; done


 $ sh ./test.sh
 cancel yes jobid=40417
 cancel yes jobid=40418
 cancel yes jobid=40419
 cancel yes jobid=40420
 cancel yes jobid=40421


 With jot you can shorten this even further:

   jot -w cancel yes jobid=404%g 5 17

 Again, you might want to zero-pad if you are cancelling, say, jobs
 40405 to 40423:

   jot -w cancel yes jobid=404%02g 19 5

 Or, better yet, just start from the job range beginning itself:

   jot -w cancel yes jobid=%g 19 40405

WOOT!

-- 
Dan Langille - http://langille.org/

--
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_feb
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] BeforeJob: Can't find your catalog (MyCatalog) in director configuration

2013-03-05 Thread Carlos Perez
 # sudo /usr/lib64/bacula/make_catalog_backup.pl MyCatalog
sh: /usr/sbin/dbcheck.mysql: No such file or directory
Can't find your catalog (MyCatalog) in director configuration

Yes, I have windows, linux clients and the server itself doing backups
without any errors.  Catalog, is the one not cooperating, thanks for you
help and I will put a few more hours into before starting from scratch.






On Tue, Mar 5, 2013 at 8:03 AM, compdoc comp...@hotrodpc.com wrote:

 2013-03-03 23:10:02   baculaserver-dir JobId 133: shell command: run
 BeforeJob /usr/lib64/bacula/make_catalog_backup.pl MyCatalog

 ** **

 2013-03-03 23:10:02   baculaserver-dir JobId 133: BeforeJob: sh:
 /usr/sbin/dbcheck.mysql: No such file or directory

 2013-03-03 23:10:02   baculaserver-dir JobId 133: BeforeJob: Can't find
 your catalog (MyCatalog) in director configuration

 ** **

 2013-03-03 23:10:02   baculaserver-dir JobId 133: Error: Runscript:
 BeforeJob returned non-zero status=1. ERR=Child exited with code 1 

 ** **

 2013-03-03 23:10:02   baculaserver-dir JobId 133: Error: Bacula
 baculaserver-dir 5.2.12 (12Sep12):

   Build OS:   x86_64-suse-linux-gnu suse 11

   JobId:  133

   Job:MyCatalog.2013-03-03_23.10.00_23

   Backup Level:   Full

   Client: baculaserver-fd 5.2.12 (12Sep12)
 x86_64-suse-linux-gnu,suse,11

 ** **

 ** **

 ** **

 I'm thinking it might be useful to step through this manually. What is the
 result of the following command:

 ** **

 sudo /usr/lib64/bacula/make_catalog_backup.pl MyCatalog

 ** **

 On mine this takes a few minutes then exits without an error code. 

 ** **

 The command:   /usr/sbin/dbcheck.mysql: No such file or directory isn’t
 working because the file doesn’t exist. You need to correct that. Sounds
 like you need to rename the file.

 ** **

 This site might be useful to you:

 ** **

 https://dan.langille.org/2010/03/23/baccula-errors-with-500-backup-catalog/
 

 ** **

 Is bacula working otherwise? Are you able to create backups of your
 clients?

 ** **

 ** **


 --
 Everyone hates slow websites. So do we.
 Make your web apps faster with AppDynamics
 Download AppDynamics Lite for free today:
 http://p.sf.net/sfu/appdyn_d2d_feb
 ___
 Bacula-users mailing list
 Bacula-users@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/bacula-users


--
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_feb___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] bconsole autocomplete and history feature

2013-03-05 Thread Andrei Moraru
Hi,

I have installed by getting the sources from Official mirrors and compiling
it.

Regards,
Andrei


On Tue, Mar 5, 2013 at 12:33 AM, compdoc comp...@hotrodpc.com wrote:

  I have installed Bacula v5.2.13 on Debian 6.0.6 x86_64

 ** **

 How did you install?

 ** **

 ** **


 --
 Everyone hates slow websites. So do we.
 Make your web apps faster with AppDynamics
 Download AppDynamics Lite for free today:
 http://p.sf.net/sfu/appdyn_d2d_feb
 ___
 Bacula-users mailing list
 Bacula-users@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/bacula-users




-- 
-- 
Best regards, Cu profund respect, С уважением,

Andrei Moraru,

Chisinau, Republic of Moldova
Mobile: +37379 960481

http://develam.com
http://develam.net

E-Mail:  andrei.morar...@gmail.com
-
Dream as if you'll live forever, live as if you'll die today.
  James
Dean

I'm a great believer in luck and I find the harder I work, the more I have
of it.

  Thomas Jefferson

It is possible to compensate for a lack of talent through the will to work
hard. But it is not possible to compensate for lack of will with talent.
_

Andrei Moraru

--
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_feb___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] bconsole autocomplete and history feature

2013-03-05 Thread Andrei Moraru
Hi,

Yes, i've compiled it from sources.

 I assume you compiled 5.2.13 from source? If so, make sure your
 configure output displays either readline and / or conio enabled, this
 will provide you with the history feature.

Can you give me more details how to get that?

Thanks,


On Tue, Mar 5, 2013 at 10:37 AM, Uwe Schuerkamp
uwe.schuerk...@nionex.netwrote:

 On Mon, Mar 04, 2013 at 11:23:17PM +0200, Andrei Moraru wrote:
  Hi,
 
  I have installed Bacula v5.2.13 on Debian 6.0.6 x86_64
 
 
  In a putty session to the VM hosting the Bacula director, I connect to
 the
  console of Bacula by using bconsole utility.
  Unfortunately, I don't have autocomplete option in bconsole (by using TAB
  key) nor the history of commands entered (by using UP arrow button)
 
  Please advice how to activate these two options in bconsole.
 
  Thanks
 

 Hello Andrei,

 I assume you compiled 5.2.13 from source? If so, make sure your
 configure output displays either readline and / or conio enabled, this
 will provide you with the history feature.

 For TAB autocompletion, I tried to activate it several times but
 failed miserably. ;)

 You may need to install a variety of development packages in debian, try
 readline-dev, ncurses-dev and so on (sorry, I cannot provide exact
 package names as I'm on CentOS ATM).

 Good luck,

 Uwe

 --
 NIONEX --- Ein Unternehmen der Bertelsmann SE  Co. KGaA





-- 
-- 
Best regards, Cu profund respect, С уважением,

Andrei Moraru,

Chisinau, Republic of Moldova
Mobile: +37379 960481

http://develam.com
http://develam.net

E-Mail:  andrei.morar...@gmail.com
-
Dream as if you'll live forever, live as if you'll die today.
  James
Dean

I'm a great believer in luck and I find the harder I work, the more I have
of it.

  Thomas Jefferson

It is possible to compensate for a lack of talent through the will to work
hard. But it is not possible to compensate for lack of will with talent.
_

Andrei Moraru

--
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_feb___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] BeforeJob: Can't find your catalog (MyCatalog) in director configuration

2013-03-05 Thread compdoc
 # sudo /usr/lib64/bacula/make_catalog_backup.pl MyCatalog

 

No errors listed, so might be ok.

 

 sh: /usr/sbin/dbcheck.mysql: No such file or directory

 

This could mean it cannot find the file MyCatalog. Did you say that there is
a file named /usr/sbin/dbcheck.mysql ?

 

Can't find your catalog (MyCatalog) in director configuration

 

Bacula is complaining. How does the section for the catalog job (and
related) in /etc/bacula/bacula-dir.conf look? Make sure the paths are
correct for your system.

 

 

 

 

 

--
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_feb___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Job canceling tip

2013-03-05 Thread Paul Mather
On Mar 5, 2013, at 9:54 AM, Dan Langille d...@langille.org wrote:

 On 2013-03-04 04:42, Konstantin Khomoutov wrote:
 On Mon, 4 Mar 2013 08:45:05 +0100
 Geert Stappers geert.stapp...@vanadgroup.com wrote:
 
 [...]
 Thank you for the tip. I want to share another.
 It is about canceling multiple jobs. Execute from shell
 
   for i in {17..21} ; do echo cancel yes jobid=404${i} | bconsole ;
 done
 
 Five jobs, 40417-40421, will be canceled.
 
 A minor nitpick: the construct
 
 for i in {17..21}; do ...
 
 is a bashism [1], so it won't work in any POSIX shell.
 
 A good point! I tried the above on FreeBSD:
 
 $ cat test.sh
 #!/bin/sh
 
 for i in {17..21} ; do echo cancel yes jobid=404${i} ; done
 
 
 [dan@bast:~/bin] $ ./sh test.sh
 cancel yes jobid=404{17..21}
 [dan@bast:~/bin] $
 
 
 A portable way to do the same is to use the `seq` program
 
 for i in `seq 17 21`; do ...
 
 or to maintain an explicit counter:
 
 i=17
 while [ $i -le 21 ]; do ...; i=$(($i+1)); done
 
 Then I tried this approach but didn't find seq at all.  I tried sh, 
 csh, and tcsh.


Seq appeared in FreeBSD 9, so if you tried it in earlier versions that's 
probably why you didn't find it.

Using seq, you might have to use -f %02g to get two-digit sequences with 
leading zeros (or -f %0Ng to get N-digit sequences with leading zeros).


 But I know about jot.  This does 5 numbers, starting at 17:
 
 $ jot 5 17
 17
 18
 19
 20
 21
 
 Thus, the script becomes:
 
 $ cat test.sh
 #!/bin/sh
 
 for i in `jot 5 17` ; do echo cancel yes jobid=404${i} ; done
 
 
 $ sh ./test.sh
 cancel yes jobid=40417
 cancel yes jobid=40418
 cancel yes jobid=40419
 cancel yes jobid=40420
 cancel yes jobid=40421


With jot you can shorten this even further:

jot -w cancel yes jobid=404%g 5 17

Again, you might want to zero-pad if you are cancelling, say, jobs 40405 to 
40423:

jot -w cancel yes jobid=404%02g 19 5

Or, better yet, just start from the job range beginning itself:

jot -w cancel yes jobid=%g 19 40405

Cheers,

Paul.


--
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_feb
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] bacula does not recognizes any slots of an ADIC-1200G

2013-03-05 Thread Tilman Gloetzner
Hello

Distribution: Ubuntu 12.04

Issue: Bacula does not properly recognize the 12 tape slots of the 
ADIC-1200 G.

Details:
1)
*update slots scan
3306 Issuing autochanger slots command.
Device AutoChanger1 has 0 slots.
No slots in changer to scan.

2) If I start bacula-sd directly, it works
# service bacula-sd stop
  * Stopping Bacula Storage 
daemon... [ OK ]
# /usr/sbin/bacula-sd
# bconsole
Connecting to Director 127.0.0.1:9101
*update slots scan
...
Connecting to Storage daemon TapeStorage2  ...
3306 Issuing autochanger slots command.
Device AutoChanger1 has 12 slots.

3) I would think of a permission problem. The file permissions seem 
however not be related to this issue.
# ls -la /dev/sg0
crw-rw 1 root tape 21, 0 Mar  5 19:14 /dev/sg0
# ls -la /etc/bacula/scripts/mtx-changer
-rwxr-xr-x 1 bacula bacula 7524 Mar  2 11:14 /etc/bacula/scripts/mtx-changer
# chmod 0666 /dev/sg0
# service bacula-sd start
  * Starting Bacula Storage 
daemon... [ OK ]
# beconsole
*update slot scan
3306 Issuing autochanger slots command.
Device AutoChanger1 has 0 slots.
No slots in changer to scan.

I would appreciate help

Thanks

Tilman


--
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_feb
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] bacula does not recognizes any slots of an ADIC-1200G

2013-03-05 Thread Dan Langille

On Mar 5, 2013, at 3:52 PM, Tilman Gloetzner wrote:

 Hello
 
 Distribution: Ubuntu 12.04
 
 Issue: Bacula does not properly recognize the 12 tape slots of the 
 ADIC-1200 G.
 
 Details:
 1)
 *update slots scan
 3306 Issuing autochanger slots command.
 Device AutoChanger1 has 0 slots.
 No slots in changer to scan.
 
 2) If I start bacula-sd directly, it works
 # service bacula-sd stop
  * Stopping Bacula Storage 
 daemon... [ OK ]
 # /usr/sbin/bacula-sd
 # bconsole
 Connecting to Director 127.0.0.1:9101
 *update slots scan
 ...
 Connecting to Storage daemon TapeStorage2  ...
 3306 Issuing autochanger slots command.
 Device AutoChanger1 has 12 slots.
 
 3) I would think of a permission problem. The file permissions seem 
 however not be related to this issue.
 # ls -la /dev/sg0
 crw-rw 1 root tape 21, 0 Mar  5 19:14 /dev/sg0
 # ls -la /etc/bacula/scripts/mtx-changer
 -rwxr-xr-x 1 bacula bacula 7524 Mar  2 11:14 /etc/bacula/scripts/mtx-changer
 # chmod 0666 /dev/sg0
 # service bacula-sd start
  * Starting Bacula Storage 
 daemon... [ OK ]
 # beconsole
 *update slot scan
 3306 Issuing autochanger slots command.
 Device AutoChanger1 has 0 slots.
 No slots in changer to scan.
 '

It may be permissions.  I documented how I got my mtx-changer stuff to work:

http://www.freebsddiary.org/tape-library.php
http://www.freebsddiary.org/tape-library-integration.php

It's the permissions that get you, and they aren't where you may think they 
are. 

-- 
Dan Langille - http://langille.org


--
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_feb
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] Fwd: Re: bacula does not recognizes any slots of an ADIC-1200G

2013-03-05 Thread Tilman Gloetzner
Hello Dan

 It may be permissions. I documented how I got my mtx-changer stuff to 
work: http://www.freebsddiary.org/tape-library.php 
 http://www.freebsddiary.org/tape-library-integration.php It's the 
permissions that get you, and they aren't where you may think they
  are.

It was a permission issue of the  mtx.log file -- thanks for the link.

# ls -la  /var/lib/bacula/mtx.log
-rw-r--r-- 1 root root 230018 Mar  5 23:12 /var/lib/bacula/mtx.log
# rm /var/lib/bacula/mtx.log
# service bacula-sd restart
  * Stopping Bacula Storage 
daemon... [ OK ]
  * Starting Bacula Storage 
daemon... [ OK ]
# ls -l /var/lib/bacula/mtx.log
-rw-r- 1 bacula tape 246 Mar  5 23:18 /var/lib/bacula/mtx.log

I changed the owner of the mtx-changer script as well -- just in case.
# chown bacula:tape /etc/bacula/scripts/mtx-changer

Thanks again

Tilman


--
Symantec Endpoint Protection 12 positioned as A LEADER in The Forrester  
Wave(TM): Endpoint Security, Q1 2013 and remains a good choice in the  
endpoint security space. For insight on selecting the right partner to 
tackle endpoint security challenges, access the full report. 
http://p.sf.net/sfu/symantec-dev2dev
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Job canceling tip

2013-03-05 Thread Dan Langille
On Mar 5, 2013, at 5:44 PM, Luis H. Forchesatto wrote:

 If its all about cancel the jobs in queue, why don't you guys simply restart 
 bacula-dir?

These tips are about canceling SOME jobs. Some specific jobs.  Not all jobs.

 Restarting makes bacula to cancel all jobs queued, no matter if the job is 
 either executing ou awaiting. 
 
 Just a tip…


Yes.  It does.  Thanks.

-- 
Dan Langille - http://langille.org


--
Symantec Endpoint Protection 12 positioned as A LEADER in The Forrester  
Wave(TM): Endpoint Security, Q1 2013 and remains a good choice in the  
endpoint security space. For insight on selecting the right partner to 
tackle endpoint security challenges, access the full report. 
http://p.sf.net/sfu/symantec-dev2dev
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users