Re: [Bacula-users] Problem with my Surestore 230, is not responding anymore.

2006-04-19 Thread Kern Sibbald
On Wednesday 19 April 2006 17:54, pedro moreno wrote:
> On 4/18/06, Kern Sibbald <[EMAIL PROTECTED]> wrote:
> > I cannot comment on your problems in your first email because it seems to
> > be
> > hardware related.  See below for some comments.
> >
> > On Wednesday 19 April 2006 03:57, pedro moreno wrote:
> > >   Hi people, i have this.
> > >
> > > HP Surestore Ultrium 230
> > > Adaptec 29160 Chip PCI
> > > FreeBSD 5.4-p10
> > > Bacula 1.38.5 Server
> > >
> > >   The SCSI card has one external connector LVD, the  Surestore has the
> >
> > same
> >
> > > Input them  my cable is one HP C5741A wich support:
> > >
> > > AutoBackup PC 100
> > > AutoBackup PC 25
> > > SCSI Cable
> > > StorageWorks DAT40e
> > > StorageWorks Ultrium 215 tape drive for ProLiant
> > > StorageWorks Ultrium 460 tape drive
> > > SureStore DAT40e
> > > SureStore DAT40x6e
> > > SureStore DLT 1e
> > > SureStore DLT VS80e
> > > SureStore DLT80e
> > > SureStore Ultrium 215e
> > > SureStore Ultrium 230e
> > >
> > >I setup my bacula-sd.conf like this:
> > >
> > > Device {
> > >   Name = Surestore-230
> > >   Media Type = LTO-1
> > >   Archive Device = /dev/nsa0
> > >   AutomaticMount = yes;
> > >   AlwaysOpen = yes
> > >   Offline On Unmount = no
> > >   Hardware End of Medium = no
> > >   BSF at EOM = yes
> > >   Maximum Spool Size = 5G
> > >   Spool Directory = /opt/backup/spool
> > >   Backward Space Record = no
> > >   Fast Forward Space File = no
> > >   TWO EOF = yes
> > > }
> >
> > Judging by the error messages you got below during the btape "test"
> > command, I
> > would try the test again with two changes:
> >
> >BSF at EOM = no
> >TWO EOF = no
> >
> > If that fails, try the two recommended configurations given in the
> > manual. One
> > is probably identical to the above, but it would be worth checking.
> >
> > > Them i start my test with btape wich say that everything was nice and
> > > candy, them i use the fill command and start the problems:
> > >
> > > Do you want to run the simplified test (s) with one tape
> > > or the complete multiple tape (m) test: (s/m) s
> > > Simple test (single tape) selected.
> > > Wrote Volume label for volume "TestVolume1".
> > > Wrote Start of Session label.
> > > 08:22:46 Begin writing Bacula records to tape ...
> > > Wrote blk_block=5000, dev_blk_num=986 VolBytes=63,608,832
> > > rate=1551.4KB/s Wrote blk_block=1, dev_blk_num=5986
> > > VolBytes=386,168,808
> > > rate=1331.6KB/s Wrote blk_block=15000, dev_blk_num=10986
> > > VolBytes=708,728,752 rate=1342.3KB/s 18-Apr 08:36 btape: End of Volume
> > > "TestVolume1" at 1:14686 on device "Surestore-230" (/dev/nsa0). Write
> > > of 64512 bytes got 0.
> > > 18-Apr 08:40 btape: btape Error: Error writing final EOF to tape. This
> > > Volume may not be readable.
> > > dev.c:1536 ioctl MTWEOF error on "Surestore-230" (/dev/nsa0).
> > > ERR=Input/output error.
> > > btape: btape.c:2301 Last block at: 1:14685 this_dev_block_num=14686
> > > btape: btape.c:2335 End of tape 1:14686. VolumeCapacity=947,423,112.
> >
> > Write
> >
> > > rate = 911.0 KB/s
> > > Done writing ...
> > > Wrote state file last_block_num1=14685 last_block_num2=0
> > >
> > > 08:40:06 Done filling tape at 1:14686. Now beginning re-read of tape
> > > ... Rewinding.
> > > Reading the first 1 records from 0:0.
> > > 18-Apr 08:46 btape: End of Volume at file 1 on device "Surestore-230"
> > > (/dev/nsa0), Volume "TestVolume1"
> > > btape: btape.c:2732 End of Volume "TestVolume1"
> > > Read block=18700, VolBytes=64,448 rate=0.2 KB/s
> > > 18-Apr 08:46 btape: btape Fatal error: acquire.c:143 Num_writers=1 not
> > > zero. Job 0 canceled.
> > > btape: btape.c:2759 Cannot open Dev="Surestore-230" (/dev/nsa0),
> > > Vol=TestVolume2
> > > 18-Apr 08:46 btape: End of all volumes.
> > > Reposition from 0:0 to 1:14685
> > > 18-Apr 08:46 btape: Fatal Error at dev.c:1441 because:
> > > dev.c:1440 Bad call to reposition_dev. Device not open
> > > Reposition error. ERR=dev.c:1440 Bad call to reposition_dev. Device not
> > > open
> > >
> > > Here i use my Cleaner.
> > >
> > > Them i use another new tape and start the test following the bacula
> > > tape test process, and again the fill test fail:
> > >
> > > Do you want to run the simplified test (s) with one tape
> > > or the complete multiple tape (m) test: (s/m) s
> > > Simple test (single tape) selected.
> > > Wrote Volume label for volume "TestVolume1".
> > > Wrote Start of Session label.
> > > 09:53:31 Begin writing Bacula records to tape ...
> > > Wrote blk_block=5000, dev_blk_num=986 VolBytes=63,608,832
> > > rate=1631.0KB/s Wrote blk_block=1, dev_blk_num=5986
> > > VolBytes=386,168,808
> > > rate=1440.9KB/s Wrote blk_block=15000, dev_blk_num=10986
> > > VolBytes=708,728,752 rate=1403.4KB/s 18-Apr 10:06 btape: End of Volume
> > > "TestVolume1" at 1:15212 on device "Surestore-230" (/dev/nsa0). Write
> > > of 64512 bytes got 0.
> > > 18-Apr 10:21 btape: btape Error: Error writing final EOF to tape. This
> > > Volume may not be 

Re: [Bacula-users] Newbe question: cancel a running job.

2006-04-19 Thread Ryan Novosielski
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

What version is this? I believe something like this was repaired in a
later version (or is due to be repaired)...?

  _  _ _  _ ___  _  _  _
 |Y#| |  | |\/| |  \ |\ |  | |Ryan Novosielski - User Support Spec. III
 |$&| |__| |  | |__/ | \| _| |[EMAIL PROTECTED] - 973/972.0922 (2-0922)
 \__/ Univ. of Med. and Dent.|IST/AST - NJMS Medical Science Bldg - C630


Jaime Ventura wrote:
> Hi
>I've used the "run" command on the console to run a job in client A.
> Meanwhile i had to restart bacula-dir.
>Now when i make "status director" there is no running job , but if i
> get the status of client A, it says there is a job running.
>How do I cancel that job. Cant i restart bacula while  there is a job
> running?
> Thanks for help.
> 
> 
> ---
> This SF.Net email is sponsored by xPML, a groundbreaking scripting language
> that extends applications into web and mobile media. Attend the live
> webcast
> and join the prime developer group breaking into this new coding territory!
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
> ___
> Bacula-users mailing list
> Bacula-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/bacula-users
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.2.2 (MingW32)

iD8DBQFERmYNmb+gadEcsb4RAlnbAJ9fCFwR6AJJPeAVdfBKDvkxvx2zygCg4pNY
9+uBIINrLQmJ+vBEW/p6pCQ=
=0v2s
-END PGP SIGNATURE-



---
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] Silent install / mass deployment assistant scripts

2006-04-19 Thread Dominic Marks
Hello,

I've worked up something which I think is useful following the
discussion on bacula-devel regarding automated installing and
upgrading of Bacula on large sites with a big Windows element.

The scripts require some customisation which is the nature of these
things but I hope they are useful to others.

Once you have done the preparatory work of creating a security group
which will contain your Bacula clients, downloading the version of the
Windows FD you want to run and setting paths appropriately all you
need to do to deploy to a machine is to add it to the security group
and wait for someone with admin rights (often the user) to log in.
Upgrades are similarly easy. The new version of the installer is
downloaded, a single variable in the script is updated and from then
on upgrades will commence as systems log in.

When combined with the PHP script and a little site specific code you
can easily have it reconfigure the Director too so that both client
and server configuration is fully automated.

Contents:

 1. bacula-install-and-upgrade.vbs

>From the script:
' Bacula Automatic Install & Upgrade VBScript
' -
'
' This script is designed to be customised into a
' organisations domain logon script. The Bacula client
' will be conditionally installed on the presence of
' the executing computer's membership of a Bacula
' group.
'
' When a user with administrator rights logs in to a
' system on a Computer which is present in the Bacula
' group (in ActiveDirectory) the client will be
' installed or upgraded if the existing version is older.
'
' Optionally the client can be automatically configured
' with the director by querying a PHP script residing on
' a Web server (possibly on the director, but that is not
' a requirement)
'
' The PHP script is also designed to be customised into an
' organisations own systems. The supplied template just
' generates a password and a very simple bacula-fd.conf
' storing the password and computer name in a comma
' delimited file.
'
' Most organisations will want to customise this to store
' these details in a database table from which they can
' generate their bacula-dir and bacula-sd conf(s) using a
' template.
'

http://goodforbusiness.eu/~dom/bacula-install-and-upgrade.vbs

 2. fdconf.php

A minimal implementation of a script to configure the client and
possibly the server. This area is site specific however and needs to
be customised so this is just a starting point.

http://goodforbusiness.eu/~dom/fdconf.phps

Comments welcome.

Thanks,
Dominic


---
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid0709&bid&3057&dat1642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] Re: case insensitive query

2006-04-19 Thread Mark Nienberg

Cedric Tefft wrote:

Troy Daniels wrote:


An update to this.

I cant vouch for this exact query - on my system it takes a looonnggg 
time to finish due to the 2 million plus files recorded and I gave up 
and canceled it, but the following simplified version worked:


mysql> select Name from Filename where LCASE(Name) = 'makedev';
+-+
| Name|
+-+
| MAKEDEV |
+-+
1 row in set (1.15 sec)

So I dont understand why it wouldn't work in the other query - but I'm 
not a MySQL Guru.


I am running MySQL Server 3.23.58 tho which could be the difference I 
suppose.




Hmm... yeah, I tried that, but it didn't work for me, whereas the 
CONVERT() strategy does:


mysql> select Name from Filename where LCASE(Name) = 'makedev';
Empty set (1.03 sec)

mysql> select Name from Filename where CONVERT(Name using 
latin1)='makedev';

+-+
| Name|
+-+
| MAKEDEV |
+-+
1 row in set (1.85 sec)


I am using mysql 5.0.18, though, like you,  I don't know why that should 
make a difference.


Thank you so much for your help on this.  I've tested the suggestions 
above on my system, which uses MySQL v4.1 and found that the LCASE 
doesn't work but the CONVERT does work.  As I am just getting into 
production with bacula, my database isn't large enough yet to make any 
speed conclusions.  This is a great help.  Thanks again.

Mark



---
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] "Segmentation violation" message

2006-04-19 Thread Jaime Ventura

sorry, next time maybe i should see the bug reports first.
thanks

Kern Sibbald wrote:

On Wednesday 19 April 2006 11:00, Jaime Ventura wrote:
  

Ok, i understand that. But should i report it as a bug?



This has been already reported as a bug, and I already have the code that will 
fix the bug that was reported and possibly yours.


  

Should i never use the "reload" command on the console any more?
If i do "/etc/init.d/bacula-dir restart", at least i wont have a
"Segmentation violation"...:(
Well, thanks anyway.

Cedric Tefft wrote:


Jaime Ventura wrote:
  

18-Apr 18:50 bserver-dir:  Error: message.c:668 fopen
ñ/bserver-dir.bserver-dir.5 992232.mail failed:
ERR=No such file or directory
18-Apr 18:50 bserver-dir: Fatal Error because: Bacula interrupted by
signal 11: Segmentation viol ation
*
Can you help me with this last error messages?


It just means the director crashed -- probably due to the errors in
your initial config.  Now that you've corrected those errors, it
shouldn't happen again.

- Cedric



---
This SF.Net email is sponsored by xPML, a groundbreaking scripting
language
that extends applications into web and mobile media. Attend the live
webcast
and join the prime developer group breaking into this new coding
territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
  

---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live
webcast and join the prime developer group breaking into this new coding
territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users



  



---
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] Re: case insensitive query

2006-04-19 Thread Mark Nienberg

Troy Daniels wrote:

An update to this.

I cant vouch for this exact query - on my system it takes a looonnggg 
time to finish due to the 2 million plus files recorded and I gave up 
and canceled it, but the following simplified version worked:


mysql> select Name from Filename where LCASE(Name) = 'makedev';
+-+
| Name|
+-+
| MAKEDEV |
+-+
1 row in set (1.15 sec)

So I dont understand why it wouldn't work in the other query - but I'm 
not a MySQL Guru.


I am running MySQL Server 3.23.58 tho which could be the difference I 
suppose.


Yes, I think that does make a difference.  On this page:

http://dev.mysql.com/doc/refman/4.1/en/charset-binary-op.html

it notes that something is different about binary column types after v4. 
 Not sure I understand it enough to say what the difference is though!


Mark



---
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] "Segmentation violation" message

2006-04-19 Thread Cedric Tefft

Jaime Ventura wrote:



18-Apr 18:50 bserver-dir:  Error: message.c:668 fopen 
ñ/bserver-dir.bserver-dir.5 992232.mail failed: ERR=No 
such file or directory
18-Apr 18:50 bserver-dir: Fatal Error because: Bacula interrupted by 
signal 11: Segmentation viol ation

*
Can you help me with this last error messages?


It just means the director crashed -- probably due to the errors in your 
initial config.  Now that you've corrected those errors, it shouldn't 
happen again.


- Cedric



---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] case insensitive query

2006-04-19 Thread Dominic Marks

Mark Nienberg wrote:
I'm using Bacula to back up a Linux Samba fileserver among other 
machines.  Of course the clients to the fileserver are windows machines 
and they don't care about case in filenames.  They create all sorts of 
case combinations like "document1.doc", "Document2.DOC" and so on.


My most common restore scenario is when someone deletes or corrupts a 
file and asks me to restore a previous version of it.  The easiest way 
to do this in the console is (I think) to use the query command option 2 
"List Jobs where a given File is saved", and then pick an appropriate 
jobID to restore from based on date of backup.


The problem is that the search for the filename is case sensitive (the 
MySQL field is type "binary") so it is hard to guess what filename to 
enter.  I wonder if I could use option 4 "Enter SQL list command" to do 
a case-insensitive search.  Any suggestions on what this SQL command 
would look like for MySQL?  Or is there a better way to do this?


One method:

Do you locate(1) on the Linux boxes? If you don't have it enabled set it 
to run at least as frequently as you Backup. Then you can use 
locate+grep to find your files.


Example:

 locate /raid/samba/home/dom | grep -i ".doc"

This will list off all the files locate last saw and you can grep on 
that list in any way you like (eg: case insenstive).


Just make sure you archive your old locate databases rather than 
overwriting and you should have the ability to go back in time and 
search in a variety of ways over your SAMBA server.


A little scripting required perhaps but a work-able solution.

Cheers,
Dominic


Thanks,
Mark



---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live 
webcast

and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users




---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] case insensitive query

2006-04-19 Thread Troy Daniels
Under MySQL you can use the LCASE() (Or UCASE if you prefer) function to 
do something like:


SELECT DISTINCT Job.JobId as JobId, Client.Name as Client,
  Path.Path,Filename.Name,StartTime,Level,JobFiles,JobBytes
 FROM Client,Job,File,Filename,Path WHERE Client.ClientId=Job.ClientId
 AND JobStatus='T' AND Job.JobId=File.JobId
 AND Path.PathId=File.PathId AND Filename.FilenameId=File.FilenameId
 AND LCASE(Filename.Name)='filenameinlowercase.doc'
 ORDER BY Job.StartTime LIMIT 20;

You would need to provide the filename in all lowercase to get a match.

Not sure what sort of performance hit this would cause for your query 
tho - can imagine it could be pretty harsh on larger systems


FYI, The above query is straight out of /etc/bacula/query.sql on my 
system and was only modified to add the LCASE function and fake filename.


Cheers


Troy Daniels
Systems Administrator
iTouch Australia PTY LTD.


Dominic Marks wrote:

Mark Nienberg wrote:
I'm using Bacula to back up a Linux Samba fileserver among other 
machines.  Of course the clients to the fileserver are windows 
machines and they don't care about case in filenames.  They create all 
sorts of case combinations like "document1.doc", "Document2.DOC" and 
so on.


My most common restore scenario is when someone deletes or corrupts a 
file and asks me to restore a previous version of it.  The easiest way 
to do this in the console is (I think) to use the query command option 
2 "List Jobs where a given File is saved", and then pick an 
appropriate jobID to restore from based on date of backup.


The problem is that the search for the filename is case sensitive (the 
MySQL field is type "binary") so it is hard to guess what filename to 
enter.  I wonder if I could use option 4 "Enter SQL list command" to 
do a case-insensitive search.  Any suggestions on what this SQL 
command would look like for MySQL?  Or is there a better way to do this?


One method:

Do you locate(1) on the Linux boxes? If you don't have it enabled set it 
to run at least as frequently as you Backup. Then you can use 
locate+grep to find your files.


Example:

 locate /raid/samba/home/dom | grep -i ".doc"

This will list off all the files locate last saw and you can grep on 
that list in any way you like (eg: case insenstive).


Just make sure you archive your old locate databases rather than 
overwriting and you should have the ability to go back in time and 
search in a variety of ways over your SAMBA server.


A little scripting required perhaps but a work-able solution.

Cheers,
Dominic


Thanks,
Mark



---
This SF.Net email is sponsored by xPML, a groundbreaking scripting 
language
that extends applications into web and mobile media. Attend the live 
webcast
and join the prime developer group breaking into this new coding 
territory!

http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users




---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live 
webcast

and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users



---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] case insensitive query

2006-04-19 Thread Cedric Tefft

Mark Nienberg wrote:

I'm using Bacula to back up a Linux Samba fileserver among other 
machines.  Of course the clients to the fileserver are windows 
machines and they don't care about case in filenames.  They create all 
sorts of case combinations like "document1.doc", "Document2.DOC" and 
so on.


My most common restore scenario is when someone deletes or corrupts a 
file and asks me to restore a previous version of it.  The easiest way 
to do this in the console is (I think) to use the query command option 
2 "List Jobs where a given File is saved", and then pick an 
appropriate jobID to restore from based on date of backup.


The problem is that the search for the filename is case sensitive (the 
MySQL field is type "binary") so it is hard to guess what filename to 
enter.  I wonder if I could use option 4 "Enter SQL list command" to 
do a case-insensitive search.  Any suggestions on what this SQL 
command would look like for MySQL?  Or is there a better way to do this?



Add this query to your  query.sql file:

# 18 - case insensitive version of query #2
:List up to 20 places where a File is saved regardless of the directory 
(case insensitive):

*Enter Filename (no path):
SELECT DISTINCT Job.JobId as JobId, Client.Name as Client,
 Path.Path,Filename.Name,StartTime,Level,JobFiles,JobBytes
FROM Client,Job,File,Filename,Path WHERE Client.ClientId=Job.ClientId
AND JobStatus='T' AND Job.JobId=File.JobId
AND Path.PathId=File.PathId AND Filename.FilenameId=File.FilenameId
AND convert(Filename.Name USING latin1)='%1'
ORDER BY Job.StartTime LIMIT 20;

Now, instead of picking query #2, pick query #18 (or whatever is the 
last one on the list).  It works exactly like query #2, but it's case 
insensitive.  I suspect you'll need at least mysql 4.0 or better for 
this to work, and it's rather slow, but it should do the trick.


- Cedric



---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] case insensitive query

2006-04-19 Thread Cedric Tefft

Troy Daniels wrote:

Under MySQL you can use the LCASE() (Or UCASE if you prefer) function 
to do something like:


SELECT DISTINCT Job.JobId as JobId, Client.Name as Client,
  Path.Path,Filename.Name,StartTime,Level,JobFiles,JobBytes
 FROM Client,Job,File,Filename,Path WHERE Client.ClientId=Job.ClientId
 AND JobStatus='T' AND Job.JobId=File.JobId
 AND Path.PathId=File.PathId AND Filename.FilenameId=File.FilenameId
 AND LCASE(Filename.Name)='filenameinlowercase.doc'
 ORDER BY Job.StartTime LIMIT 20;

Have you actually tried this?  It didn't work for me.  I suspect this is 
because LCASE is designed to operate on text fields and, as Mark pointed 
out, the Name field is defined as a binary object.


- Cedric




---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] "Segmentation violation" message

2006-04-19 Thread Jaime Ventura

Ok, i understand that. But should i report it as a bug?
Should i never use the "reload" command on the console any more?
If i do "/etc/init.d/bacula-dir restart", at least i wont have a 
"Segmentation violation"...:(

Well, thanks anyway.

Cedric Tefft wrote:

Jaime Ventura wrote:



18-Apr 18:50 bserver-dir:  Error: message.c:668 fopen 
ñ/bserver-dir.bserver-dir.5 992232.mail failed: 
ERR=No such file or directory
18-Apr 18:50 bserver-dir: Fatal Error because: Bacula interrupted by 
signal 11: Segmentation viol ation

*
Can you help me with this last error messages?


It just means the director crashed -- probably due to the errors in 
your initial config.  Now that you've corrected those errors, it 
shouldn't happen again.


- Cedric



---
This SF.Net email is sponsored by xPML, a groundbreaking scripting 
language
that extends applications into web and mobile media. Attend the live 
webcast
and join the prime developer group breaking into this new coding 
territory!

http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users




---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] case insensitive query

2006-04-19 Thread Troy Daniels

Doh! I have to admit a failure to test this particular query.

I've used the technique on other queries tho and just applied it to this 
scenario.


I completely missed the reference to the filename field being binary too 
- too much work, not enough time!


My bad! Sorry!


Troy.

Cedric Tefft wrote:

Troy Daniels wrote:

Under MySQL you can use the LCASE() (Or UCASE if you prefer) function 
to do something like:


SELECT DISTINCT Job.JobId as JobId, Client.Name as Client,
  Path.Path,Filename.Name,StartTime,Level,JobFiles,JobBytes
 FROM Client,Job,File,Filename,Path WHERE Client.ClientId=Job.ClientId
 AND JobStatus='T' AND Job.JobId=File.JobId
 AND Path.PathId=File.PathId AND Filename.FilenameId=File.FilenameId
 AND LCASE(Filename.Name)='filenameinlowercase.doc'
 ORDER BY Job.StartTime LIMIT 20;

Have you actually tried this?  It didn't work for me.  I suspect this is 
because LCASE is designed to operate on text fields and, as Mark pointed 
out, the Name field is defined as a binary object.


- Cedric




---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live 
webcast

and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users



---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Newbie: How to manage multiple pools and multiple FDs

2006-04-19 Thread Cedric Tefft

Thomas Deutsch wrote:


How can I backup (nightly backup) both of this servers on the same tape and use my 4 
tapepools? The 4 pools are for daily, weekly, monthly and yearly backup. But in the 
definition of the jobs, I can use "Pool ="  only once, right? How can I make 
this?
 

This would be done in the schedule definition.  See 
http://www.bacula.org/rel-manual/Configuring_Director.html#SECTION000145000



And another stupid newbie-question: What is "catalog database" and do I have to 
backup ist for every FD?
 

To the first question, read the manual: 
http://www.bacula.org/rel-manual/What_is_Bacula.html#SECTION00042000


To the second question: no.  By default, you have only one catalog 
database which holds metadata for all your clients.


- Cedric




---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] what kind of pool

2006-04-19 Thread Cedric Tefft

Eric Warnke wrote:

I would _presume_ it used the one in the job description ( more 
specific ), but you can always tell by issuing a the reload and run 
command in bconsole to preview what pool it's using.


According to the docs, the settings in the Schedule take precedence over 
the settings in the Job:


From 

http://www.bacula.org/rel-manual/Configuring_Director.html#SECTION000145000

"The *Job-overrides* permit overriding the Level, the Storage, the 
Messages, and the Pool specifications provided in the Job resource. In 
addition, the FullPool, the IncrementalPool, and the DifferentialPool 
specifications permit overriding the Pool specification according to 
what backup Job Level is in effect."


- Cedric



---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Bacula segfault (pythonlib?)

2006-04-19 Thread Cedric Tefft

Kern Sibbald wrote:

By the way, I would be interested in hearing what you are doing with 
Bacula+Python, and most likely some of the list members would too.


 

Nothing very exciting -- just generating new volume labels.  The script 
is attached to my original post on this topic if you're curious.


- Cedric



---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] case insensitive query

2006-04-19 Thread Troy Daniels

An update to this.

I cant vouch for this exact query - on my system it takes a looonnggg 
time to finish due to the 2 million plus files recorded and I gave up 
and canceled it, but the following simplified version worked:


mysql> select Name from Filename where LCASE(Name) = 'makedev';
+-+
| Name|
+-+
| MAKEDEV |
+-+
1 row in set (1.15 sec)

So I dont understand why it wouldn't work in the other query - but I'm 
not a MySQL Guru.


I am running MySQL Server 3.23.58 tho which could be the difference I 
suppose.


Cheers,


Troy.


Cedric Tefft wrote:

Troy Daniels wrote:

Under MySQL you can use the LCASE() (Or UCASE if you prefer) function 
to do something like:


SELECT DISTINCT Job.JobId as JobId, Client.Name as Client,
  Path.Path,Filename.Name,StartTime,Level,JobFiles,JobBytes
 FROM Client,Job,File,Filename,Path WHERE Client.ClientId=Job.ClientId
 AND JobStatus='T' AND Job.JobId=File.JobId
 AND Path.PathId=File.PathId AND Filename.FilenameId=File.FilenameId
 AND LCASE(Filename.Name)='filenameinlowercase.doc'
 ORDER BY Job.StartTime LIMIT 20;

Have you actually tried this?  It didn't work for me.  I suspect this is 
because LCASE is designed to operate on text fields and, as Mark pointed 
out, the Name field is defined as a binary object.


- Cedric




---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live 
webcast

and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users



---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] case insensitive query

2006-04-19 Thread Troy Daniels
An update to my update - I ran my query against a smaller bacula db 
(Only just over 700k files in this one) and after 5m 38s of waiting it 
returned a case insensitive matching list of files.


Without the LCASE() function it took 1m 49s for the same query to be 
performed.


So thats just over 3 times as long to complete.

Cheers,


Troy.

Troy Daniels wrote:

An update to this.

I cant vouch for this exact query - on my system it takes a looonnggg 
time to finish due to the 2 million plus files recorded and I gave up 
and canceled it, but the following simplified version worked:


mysql> select Name from Filename where LCASE(Name) = 'makedev';
+-+
| Name|
+-+
| MAKEDEV |
+-+
1 row in set (1.15 sec)

So I dont understand why it wouldn't work in the other query - but I'm 
not a MySQL Guru.


I am running MySQL Server 3.23.58 tho which could be the difference I 
suppose.


Cheers,


Troy.


Cedric Tefft wrote:

Troy Daniels wrote:

Under MySQL you can use the LCASE() (Or UCASE if you prefer) function 
to do something like:


SELECT DISTINCT Job.JobId as JobId, Client.Name as Client,
  Path.Path,Filename.Name,StartTime,Level,JobFiles,JobBytes
 FROM Client,Job,File,Filename,Path WHERE Client.ClientId=Job.ClientId
 AND JobStatus='T' AND Job.JobId=File.JobId
 AND Path.PathId=File.PathId AND Filename.FilenameId=File.FilenameId
 AND LCASE(Filename.Name)='filenameinlowercase.doc'
 ORDER BY Job.StartTime LIMIT 20;

Have you actually tried this?  It didn't work for me.  I suspect this 
is because LCASE is designed to operate on text fields and, as Mark 
pointed out, the Name field is defined as a binary object.


- Cedric




---
This SF.Net email is sponsored by xPML, a groundbreaking scripting 
language
that extends applications into web and mobile media. Attend the live 
webcast
and join the prime developer group breaking into this new coding 
territory!

http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users



---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live 
webcast

and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users



---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] "Segmentation violation" message

2006-04-19 Thread Cedric Tefft

Jaime Ventura wrote:


Ok, i understand that. But should i report it as a bug?
Should i never use the "reload" command on the console any more?
If i do "/etc/init.d/bacula-dir restart", at least i wont have a 
"Segmentation violation"...:(

Well, thanks anyway.


Well, I don't think it was technically the reload that caused the 
crash.  From your original report, the last line in the log file before 
the crash was about "Resetting previous configuration", so it would 
appear the problem is not so much in the reload command, but in bacula's 
attempt to revert to the previous config.


This does look like a bug, and you can report it as such (go to 
http://bugs.bacula.org), but it's a bug that would only occur when your 
config file is invalid, so my suspicion is that  it may not be at the 
top of Kern's to do list.  But I don't want to speak for the guy, and it 
can't hurt to try, so by all means, give it a shot.


- Cedric




---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] case insensitive query

2006-04-19 Thread Cedric Tefft

Troy Daniels wrote:


An update to this.

I cant vouch for this exact query - on my system it takes a looonnggg 
time to finish due to the 2 million plus files recorded and I gave up 
and canceled it, but the following simplified version worked:


mysql> select Name from Filename where LCASE(Name) = 'makedev';
+-+
| Name|
+-+
| MAKEDEV |
+-+
1 row in set (1.15 sec)

So I dont understand why it wouldn't work in the other query - but I'm 
not a MySQL Guru.


I am running MySQL Server 3.23.58 tho which could be the difference I 
suppose.




Hmm... yeah, I tried that, but it didn't work for me, whereas the 
CONVERT() strategy does:


mysql> select Name from Filename where LCASE(Name) = 'makedev';
Empty set (1.03 sec)

mysql> select Name from Filename where CONVERT(Name using latin1)='makedev';
+-+
| Name|
+-+
| MAKEDEV |
+-+
1 row in set (1.85 sec)


I am using mysql 5.0.18, though, like you,  I don't know why that should 
make a difference.


- Cedric






---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] "Segmentation violation" message

2006-04-19 Thread Jaime Ventura

I think the previous configuration was correct.
I will try to reproduce the crash and see the exact circumstances, and 
submit the info to http://bugs.bacula.org

Thanks again.

Cedric Tefft wrote:

Jaime Ventura wrote:


Ok, i understand that. But should i report it as a bug?
Should i never use the "reload" command on the console any more?
If i do "/etc/init.d/bacula-dir restart", at least i wont have a 
"Segmentation violation"...:(

Well, thanks anyway.


Well, I don't think it was technically the reload that caused the 
crash.  From your original report, the last line in the log file 
before the crash was about "Resetting previous configuration", so it 
would appear the problem is not so much in the reload command, but in 
bacula's attempt to revert to the previous config.


This does look like a bug, and you can report it as such (go to 
http://bugs.bacula.org), but it's a bug that would only occur when 
your config file is invalid, so my suspicion is that  it may not be at 
the top of Kern's to do list.  But I don't want to speak for the guy, 
and it can't hurt to try, so by all means, give it a shot.


- Cedric




---
This SF.Net email is sponsored by xPML, a groundbreaking scripting 
language
that extends applications into web and mobile media. Attend the live 
webcast
and join the prime developer group breaking into this new coding 
territory!

http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users




---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Bacula segfault (pythonlib?)

2006-04-19 Thread Kern Sibbald
On Wednesday 19 April 2006 11:42, Cedric Tefft wrote:
> Kern Sibbald wrote:
> >By the way, I would be interested in hearing what you are doing with
> >Bacula+Python, and most likely some of the list members would too.
>
> Nothing very exciting -- just generating new volume labels.  The script
> is attached to my original post on this topic if you're curious.

Thanks.  Since I only looked in detail at the traceback, I missed that.


-- 
Best regards,

Kern

  (">
  /\
  V_V


---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] Newbe question: cancel a running job.

2006-04-19 Thread Jaime Ventura

Hi
   I've used the "run" command on the console to run a job in client A. 
Meanwhile i had to restart bacula-dir.
   Now when i make "status director" there is no running job , but if i 
get the status of client A, it says there is a job running.
   How do I cancel that job. Cant i restart bacula while  there is a 
job running?

Thanks for help.


---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Newbe question: cancel a running job.

2006-04-19 Thread Jo

Jaime Ventura wrote:

Hi
   I've used the "run" command on the console to run a job in client 
A. Meanwhile i had to restart bacula-dir.
   Now when i make "status director" there is no running job , but if 
i get the status of client A, it says there is a job running.
   How do I cancel that job. Cant i restart bacula while  there is a 
job running?

Thanks for help.

Hi Jaime,

The easiest way is probably to restart the file daemon as well. I don't 
think it's wise to restart bacula when it is running. The job won't 
complete successfully and you will only have half a backup, for which I 
don't know what it's worth.


Jo


---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] "Segmentation violation" message

2006-04-19 Thread Kern Sibbald
On Wednesday 19 April 2006 11:00, Jaime Ventura wrote:
> Ok, i understand that. But should i report it as a bug?

This has been already reported as a bug, and I already have the code that will 
fix the bug that was reported and possibly yours.

> Should i never use the "reload" command on the console any more?
> If i do "/etc/init.d/bacula-dir restart", at least i wont have a
> "Segmentation violation"...:(
> Well, thanks anyway.
>
> Cedric Tefft wrote:
> > Jaime Ventura wrote:
> >> 18-Apr 18:50 bserver-dir:  Error: message.c:668 fopen
> >> ñ/bserver-dir.bserver-dir.5 992232.mail failed:
> >> ERR=No such file or directory
> >> 18-Apr 18:50 bserver-dir: Fatal Error because: Bacula interrupted by
> >> signal 11: Segmentation viol ation
> >> *
> >> Can you help me with this last error messages?
> >
> > It just means the director crashed -- probably due to the errors in
> > your initial config.  Now that you've corrected those errors, it
> > shouldn't happen again.
> >
> > - Cedric
> >
> >
> >
> > ---
> > This SF.Net email is sponsored by xPML, a groundbreaking scripting
> > language
> > that extends applications into web and mobile media. Attend the live
> > webcast
> > and join the prime developer group breaking into this new coding
> > territory!
> > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
> > ___
> > Bacula-users mailing list
> > Bacula-users@lists.sourceforge.net
> > https://lists.sourceforge.net/lists/listinfo/bacula-users
>
> ---
> This SF.Net email is sponsored by xPML, a groundbreaking scripting language
> that extends applications into web and mobile media. Attend the live
> webcast and join the prime developer group breaking into this new coding
> territory!
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
> ___
> Bacula-users mailing list
> Bacula-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/bacula-users

-- 
Best regards,

Kern

  (">
  /\
  V_V


---
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid0709&bid&3057&dat1642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] Zombie processes in job list

2006-04-19 Thread Francisco Reyes

Had a director crash due to running out of space.
A couple of jobs were in "Created" state.

When I brought back the director the jobs appear on "list jobs", but "status 
client" showed there were not there anymore.


How can they be removed?
The only reason it's an issue is that they always appear at the bottom of 
job list, so it makes it harder to see what job(s) are the most recent.


ServerA and ServerB are just two mail servers we are backing up.

71|ServerA|2006-04-18 23:04:44|B|F|7,464|1,000,707,982 |A|

|74|ServerA|2006-04-18 23:20:30|B|F|0|0|R|
58|ServerA||B|I|0|0|C|  <== Zombie listing
59|ServerB||B|I|0|0|C|  <== Zombie listing

Do I need to look for those records in he database and delete them? 



---
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] FAQ: What kind of tapedrive?

2006-04-19 Thread Arno Lehmann

Hi,

back from my vacation (I even discovered kind of a new hobby - 
geocaching. Fun :-)


On 4/18/2006 11:51 AM, Stephan Holl wrote:

Dear list,

as stated in the subject this question is sort of a FAQ I guess.
We are going to get a new tape-drive for backup and we are not sure
what kind of technique we are going to purchase.
LTO-1, LTO-2, LTO-3, DLT?


Depends on your needs regarding capacity and speed, obviously.


We are about to backup somewhat about 200 GB in a full-backup-session.
Currently we are using DDS-3, which is quite old (and does not have the
needed capacity).

Can anybody recommend good hardware for that task?


LTO-2 or -3, depending on how fast you expect your data to grow, or one 
the current DLT technology. DLT-V4 might be a good compromise between 
price, capacity and robustness.



Thanks in advance.


Need an offer? :-)

Arno


Stephan


---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users



--
IT-Service Lehmann[EMAIL PROTECTED]
Arno Lehmann  http://www.its-lehmann.de


---
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Automatic volume recycling fails

2006-04-19 Thread Thomas Sturm
Am Freitag April 14 2006 09:26 schrieb Kern Sibbald:
> Please permit me to complain a bit: you would get far better answers if you
> always include the essentials of your setup. Please see the support page of
> www.bacula.org, but at a minimum the Bacula version is critcal.

I'm sorry that I forgot the essentials :-(
This is what I use:
Gentoo Linux bacula 2.4.25_pre7-gss-r3 #8 Mo Mär 7 09:53:29 CET 2005 i686 
Intel(R) Pentium(R) 4 CPU 1.80GHz GenuineIntel GNU/Linux
Bacula Version: 1.38.5 (18 January 2006)


>
> On Thursday 13 April 2006 09:07, Thomas Sturm wrote:
> > The recycling of used volumes fails.
> > The retention is set to 2 days, but when the job starts (after 6 days
> > without using the tape), I get the following information:
> >
> >Current Volume "Do_2-s8" not acceptable because:
> > 1000 OK VolName=Do_2-s8 VolJobs=11 VolFiles=29 VolBlocks=358018
> >  VolBytes=23096161180 VolMounts=153 VolErrors=0 VolWrites=10878720
> >  MaxVolBytes=0 VolCapacityBytes=0 VolStatus=Used Slot=8 MaxVolJobs=0
> >  MaxVolFiles=0 InChanger=0 VolReadTime=0 VolWriteTime=0 EndFile=28
> >  EndBlock=1128 VolParts=0 LabelType=0
> >  13-Apr 08:43 bacula-sd: Please mount Volume "Do_2-s8" on Storage
> >  Device "VS160"
> >  (/dev/st0) for Job rechnungsdruck.2006-04-13_08.41.08
>
> There was one recent case where no body was printed for this "not
> acceptable because:" message, but the above concerns me a bit because the
> "1000 OK ..." is a Director message that is used for entirely different
> purposes.
>
> > The tape "Do_2-s8" is mounted and when I purge it manually and do a
> > mount, the backup will start.
> >
> > This ist what "list media" shows:
> > | mediaid | volumename | volstatus | volbytes   | volfiles |
> > | volretention recycle | slot | inchanger | mediatype | lastwritten
> >
> > +-++---++--+-
> >-- ---+-+--+---+---+-+
> >
> > |  67 | Do_2-s8| Used  | 23,096,161,180 | 29 |  172,800 |
> > | 1
> >
> > 8 | 0 | DLT8000   | 2006-04-07 00:16:56
> >
> > This is from bacula-dir.conf:
> >
> > Pool {
> > Name = Mo-Do
> > Pool Type = Backup
> > Recycle = yes   # Bacula can automatically recycle
> > Volumes  AutoPrune = yes # Prune expired volumes
> > Volume Retention = 2d  # 2 Tage
> > Volume Use Duration = 2d# noch 2 Tage nach dem Start des
> > Accept Any Volume = yes # write on any volume in the
> > }
> >
> > What goes wrong here?
> > Thanks for help.


---
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid0709&bid&3057&dat1642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Problem with my Surestore 230, is not responding anymore.

2006-04-19 Thread pedro moreno
On 4/18/06, Kern Sibbald <[EMAIL PROTECTED]> wrote:
I cannot comment on your problems in your first email because it seems to behardware related.  See below for some comments.On Wednesday 19 April 2006 03:57, pedro moreno wrote:>   Hi people, i have this.
>> HP Surestore Ultrium 230> Adaptec 29160 Chip PCI> FreeBSD 5.4-p10> Bacula 1.38.5 Server>>   The SCSI card has one external connector LVD, the  Surestore has the same
> Input them  my cable is one HP C5741A wich support:>> AutoBackup PC 100> AutoBackup PC 25> SCSI Cable> StorageWorks DAT40e> StorageWorks Ultrium 215 tape drive for ProLiant
> StorageWorks Ultrium 460 tape drive> SureStore DAT40e> SureStore DAT40x6e> SureStore DLT 1e> SureStore DLT VS80e> SureStore DLT80e> SureStore Ultrium 215e> SureStore Ultrium 230e
>>I setup my bacula-sd.conf like this:>> Device {>   Name = Surestore-230>   Media Type = LTO-1>   Archive Device = /dev/nsa0>   AutomaticMount = yes;>   AlwaysOpen = yes
>   Offline On Unmount = no>   Hardware End of Medium = no>   BSF at EOM = yes>   Maximum Spool Size = 5G>   Spool Directory = /opt/backup/spool>   Backward Space Record = no>   Fast Forward Space File = no
>   TWO EOF = yes> }Judging by the error messages you got below during the btape "test" command, Iwould try the test again with two changes:   BSF at EOM = no   TWO EOF = no
If that fails, try the two recommended configurations given in the manual. Oneis probably identical to the above, but it would be worth checking.>> Them i start my test with btape wich say that everything was nice and
> candy, them i use the fill command and start the problems:>> Do you want to run the simplified test (s) with one tape> or the complete multiple tape (m) test: (s/m) s> Simple test (single tape) selected.
> Wrote Volume label for volume "TestVolume1".> Wrote Start of Session label.> 08:22:46 Begin writing Bacula records to tape ...> Wrote blk_block=5000, dev_blk_num=986 VolBytes=63,608,832 rate=
1551.4 KB/s> Wrote blk_block=1, dev_blk_num=5986 VolBytes=386,168,808> rate=1331.6KB/s Wrote blk_block=15000, dev_blk_num=10986> VolBytes=708,728,752 rate=1342.3KB/s 18-Apr 08:36 btape: End of Volume
> "TestVolume1" at 1:14686 on device "Surestore-230" (/dev/nsa0). Write of> 64512 bytes got 0.> 18-Apr 08:40 btape: btape Error: Error writing final EOF to tape. This> Volume may not be readable.
> dev.c:1536 ioctl MTWEOF error on "Surestore-230" (/dev/nsa0).> ERR=Input/output error.> btape: btape.c:2301 Last block at: 1:14685 this_dev_block_num=14686> btape: btape.c:2335 End of tape 1:14686. VolumeCapacity=947,423,112. Write
> rate = 911.0 KB/s> Done writing ...> Wrote state file last_block_num1=14685 last_block_num2=0>> 08:40:06 Done filling tape at 1:14686. Now beginning re-read of tape ...> Rewinding.
> Reading the first 1 records from 0:0.> 18-Apr 08:46 btape: End of Volume at file 1 on device "Surestore-230"> (/dev/nsa0), Volume "TestVolume1"> btape: btape.c:2732 End of Volume "TestVolume1"
> Read block=18700, VolBytes=64,448 rate=0.2 KB/s> 18-Apr 08:46 btape: btape Fatal error: acquire.c:143 Num_writers=1 not> zero. Job 0 canceled.> btape: btape.c:2759 Cannot open Dev="Surestore-230" (/dev/nsa0),
> Vol=TestVolume2> 18-Apr 08:46 btape: End of all volumes.> Reposition from 0:0 to 1:14685> 18-Apr 08:46 btape: Fatal Error at dev.c:1441 because:> dev.c:1440 Bad call to reposition_dev. Device not open
> Reposition error. ERR=dev.c:1440 Bad call to reposition_dev. Device not> open>> Here i use my Cleaner.>> Them i use another new tape and start the test following the bacula tape
> test process, and again the fill test fail:>> Do you want to run the simplified test (s) with one tape> or the complete multiple tape (m) test: (s/m) s> Simple test (single tape) selected.
> Wrote Volume label for volume "TestVolume1".> Wrote Start of Session label.> 09:53:31 Begin writing Bacula records to tape ...> Wrote blk_block=5000, dev_blk_num=986 VolBytes=63,608,832 rate=
1631.0 KB/s> Wrote blk_block=1, dev_blk_num=5986 VolBytes=386,168,808> rate=1440.9KB/s Wrote blk_block=15000, dev_blk_num=10986> VolBytes=708,728,752 rate=1403.4KB/s 18-Apr 10:06 btape: End of Volume
> "TestVolume1" at 1:15212 on device "Surestore-230" (/dev/nsa0). Write of> 64512 bytes got 0.> 18-Apr 10:21 btape: btape Error: Error writing final EOF to tape. This> Volume may not be readable.
> dev.c:1536 ioctl MTWEOF error on "Surestore-230" (/dev/nsa0).> ERR=Input/output error.> btape: btape.c:2301 Last block at: 1:15211 this_dev_block_num=15212> btape: btape.c:2335 End of tape 1:15212. VolumeCapacity=981,356,424. Write
> rate = 576.3 KB/s> Done writing ...> Wrote state file last_block_num1=15211 last_block_num2=0>> 10:21:54 Done filling tape at 1:15212. Now beginning re-read of tape ...> Rewinding.
> Reading the first 1 records from 0:0.> 18-Apr 10:26 btape: End of Volume at file 1 on device "Surestore-230"> (/dev/nsa0), Volume "TestVolume1"> btape: btape.c:2732 End of Volume "TestVolume1"
> Read block=19226, VolBytes=64,4