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

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

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

[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

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 |$&| |__| | | |__/ | \| _| |[EMAI

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

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

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

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 techn

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

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 conso

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.

[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

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

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 t

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)

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 technic

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

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'; +---

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 curiou

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

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 do

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 wr

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

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

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 o

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

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.

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