[Bacula-users] How to set in Scheduler resource last day month?
How to describe/set in Scheduler resource last day month?
Thanks.
N�HS^�隊X���'���u���ڂ�.���y�� �*m�x%jx.j���^�קvƩ�X�jب�ȧ�� m�ݚ�v��קv�^�+j�Z{az^��h���n���)��{h���� �ا��+h�(m�Z�� jY�w��ǥrg
Re: [Bacula-users] Problem with my Surestore 230, is not responding anymore.
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.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,448 rate=0.2 KB/s
18-Apr 10:26 btape: btape Fatal error: acquire.c:143 Num_writers=1 not
Re: [Bacula-users] Windows FD and Backup API
On Wednesday 19 April 2006 05:45, Erich Prinz wrote: It's odd that the FD works with all other variations of the Windows OSes and yet the W2K presents the problem you and others on this list have encountered. It really points back to an issue with W2K server API since the bacula FD works on the other platforms. You've done more than an adequate due diligence to show it's not a configuration or ACL issue. This really shouldn't be a surprise to anyone. Microsoft programmers being the superb non-compatible programmers that they are have created significant sometimes subtle incompatible differences in the API between each different flavor of Windows. We have lots of grotesquely complicated Windows only code to try to handle those differences. I'm not sure that any Bacula developer has a W2K machine, so it isn't to surprising there are problems. Have you attempted to use the most recent FD build yet (1.38.8 I think) on this W2K box yet? As a work around (ugly as it might be) use NTBackup.exe or xcopy/ robocopy to do a temp dump of the files in an open directory prior to bacula running, then cleanse the directory in an after job fashion? Just a thought since you're stuck with the Win2K box and hope they help you get beyond this task. Erich On Apr 18, 2006, at 5:33 AM, [EMAIL PROTECTED] wrote: Hello Erich, So only the user 'test' has access to this file based on the ACL and no others? Logged in as Administrator, can you navigate, see, open, and save the file in subfolder1 via Windows Explorer? Of course not, but this is normal Windows behaviour. The Backup-API is the way, to solve this. Quote from MSDN-Library: In most cases, the ability to read and write the security settings of a file or directory object is restricted to kernel-mode processes. Clearly, you would not want any user process to be able to change the ownership or access restriction on your private file or directory. However, a backup application would not be able to complete its job of backing up your file if the access restrictions you have placed on your file or directory does not allow the application's user-mode process to read it. Backup applications must be able to override the security settings of file and directory objects to ensure a complete backup. Similarly, if a backup application attempts to write a backup copy of your file over the disk-resident copy, and you explicitly deny write privileges to the backup application process, the restore operation cannot complete. In this case also, the backup application must be able to override the access control settings of your file. The SE_BACKUP_NAME and SE_RESTORE_NAME access privileges were specifically created to provide this ability to backup applications. If these privileges have been granted and enabled in the access token of the backup application process, it can then call CreateFile to open your file or directory for backup, specifying the standard READ_CONTROL access right as the value of the dwDesiredAccess parameter. However, to identify the calling process as a backup process, the call to CreateFile must include the FILE_FLAG_BACKUP_SEMANTICS flag in the dwFlagsAndAttributes parameter. If I would have to guess what happens, I would say bacula is using this privilege for reading object to backup, but not for browsing the directory-tree. But of course usually things aren't that easy :-) Greetings Christoph Erich Prinz [EMAIL PROTECTED] 10.04.2006 20:08 To [EMAIL PROTECTED] cc bacula-users@lists.sourceforge.net Subject Re: [Bacula-users] Windows FD and Backup API Hi Christoph, This has got to be a thorn in your side! Gr. Accessible only for test means, that user test is the owner of that filesystem object an the only entry in the ACL as well. So only the user 'test' has access to this file based on the ACL and no others? Logged in as Administrator, can you navigate, see, open, and save the file in subfolder1 via Windows Explorer? Odd that the ACL allows access all the way to subfolder1 but not subfile1. If all checks out above, seems to me to be a FD issue. Kern released a new build (see prior links below) and may be worth attempting using the latest build. Erich On Apr 10, 2006, at 12:09 PM, [EMAIL PROTECTED] wrote: Hello, as reported here some time ago, I have problem with the bacula FD in a Win2K domain controller. I get Access is denied errors for files, which are not accessible to the user running the FD-process. As bacula is using the windows backup API, this should work anyway. Now, I created virtual machines for testing purposes and detected, that there is no difference between domain controllers and other windows installation, as I said before. It just happened that I didn't made the testing situation as complicated as it is on the
Re: [Bacula-users] Segmentation violation message
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=lnkkid=110944bid=241720dat=121642 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] case insensitive query
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=lnkkid=110944bid=241720dat=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=lnkkid=110944bid=241720dat=121642 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] case insensitive query
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=lnkkid=110944bid=241720dat=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=lnkkid=110944bid=241720dat=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=lnkkid=110944bid=241720dat=121642 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] case insensitive query
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=lnkkid=110944bid=241720dat=121642 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Segmentation violation message
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=lnkkid=110944bid=241720dat=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=lnkkid=110944bid=241720dat=121642 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] case insensitive query
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=lnkkid=110944bid=241720dat=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=lnkkid=110944bid=241720dat=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
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=lnkkid=110944bid=241720dat=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
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=lnkkid=110944bid=241720dat=121642 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Bacula segfault (pythonlib?)
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=lnkkid=110944bid=241720dat=121642 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] case insensitive query
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=lnkkid=110944bid=241720dat=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=lnkkid=110944bid=241720dat=121642 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] case insensitive query
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=lnkkid=110944bid=241720dat=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=lnkkid=110944bid=241720dat=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=lnkkid=110944bid=241720dat=121642 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Segmentation violation message
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=lnkkid=110944bid=241720dat=121642 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] case insensitive query
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=lnkkid=110944bid=241720dat=121642 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Segmentation violation message
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=lnkkid=110944bid=241720dat=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=lnkkid=110944bid=241720dat=121642 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Bacula segfault (pythonlib?)
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=lnkkid=110944bid=241720dat=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.
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=lnkkid=110944bid=241720dat=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.
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=lnkkid=110944bid=241720dat=121642 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Segmentation violation message
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=lnkkid=110944bid=241720dat=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=lnkkid=110944bid=241720dat=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=lnkkid0709bid3057dat1642 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Zombie processes in job list
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=lnkkid=120709bid=263057dat=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?
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=lnkkid=110944bid=241720dat=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=lnkkid=120709bid=263057dat=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
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=lnkkid0709bid3057dat1642
___
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.
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, theSurestore has the same
Input themmy 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,448 rate=0.2 KB/s 18-Apr 10:26 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
Re: [Bacula-users] Problem with my Surestore 230, is not responding anymore.
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 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
[Bacula-users] Silent install / mass deployment assistant scripts
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=lnkkid0709bid3057dat1642 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Re: case insensitive query
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=lnkkid=120709bid=263057dat=121642 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Segmentation violation message
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=lnkkid=110944bid=241720dat=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=lnkkid=110944bid=241720dat=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=lnkkid=120709bid=263057dat=121642 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Re: case insensitive query
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=lnkkid=120709bid=263057dat=121642 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
