Re: [Bacula-users] bacula-fd missing on Ubuntu 22.04 (Jammy)
Have you got a solution? On 02/05/2022 11:40, Ken Mandelberg wrote: After an update from Ubuntu 21.10 to 22.04 bacula-fd was missing. There are packages for the director and sd, but no fd. Any help? ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users -- *Marcio Merlone*___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Baculum xenial package.
Hello, Indeed, forgot I have a ppa (hawq/bacula) for latest bacula packages and it does have a baculum package, sorry for the mess and thanks all for your help. Best regards. Em 05/07/2017 14:00, Vanush "Misha" Paturyan escreveu: On 5 July 2017 at 17:35, Marcin Haba <ganius...@gmail.com <mailto:ganius...@gmail.com>> wrote: It is a bit strange because latest Baculum 7.4.4 in the stable packages repository for Ubuntu 16.04 doesn't contain PHP 5 dependencies. I think that you are trying to install an older version than 7.4.4 or you use other repository than the official. simple "apt-cache policy baculum" should show you which repository the "baculum" package is being installed from. and "apt-cache showpkg baculum" will list its dependencies. -- *Marcio Merlone* -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Baculum xenial package.
Em 08/10/2016 17:14, Marcin Haba escreveu: I let know that I prepared Baculum 7.4.4 packages for Ubuntu 16.04. I tested them so I added them to official Baculum packages repository. Here is the repository definition for Ubuntu 16.04: deb [ arch=amd64 ] http://bacula.org/downloads/baculum/ubuntu xenial main deb-src http://bacula.org/downloads/baculum/ubuntu xenial main The most important change in these packages is using metapackages for PHP that currently install modules for PHP 7. Hi, I am trying to install Baculum on a Ubuntu 16.04 server with no luck, it looks for a php5 package, which is not available: root@phobos:/var/www/html/baculum# apt install baculum-apache2 baculum Reading package lists... Done Building dependency tree Reading state information... Done Some packages could not be installed. This may mean that you have requested an impossible situation or if you are using the unstable distribution that some required packages have not yet been created or been moved out of Incoming. The following information may help to resolve the situation: The following packages have unmet dependencies: baculum : Depends: php5-cgi but it is not installable Depends: php5-curl but it is not installable Depends: php5-json but it is not installable Depends: php5-mysql but it is not installable Depends: php5-pgsql but it is not installable Depends: php5-sqlite but it is not installable baculum-apache2 : Depends: libapache2-mod-php5 but it is not installable E: Unable to correct problems, you have held broken packages. root@phobos:/var/www/html/baculum# Any hint? -- *Marcio Merlone* -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] No slots in changer to scan.
Hi,
I am running a bacula server since its 3.x series, now on version 7.4,
Ubuntu 16.04 on a Dell PE 2900 (old but gold). Just got this brand new
Dell TL1000 with 8 slots and one drive as an upgrade from the old simple
LTO-4 we have. Everything works fine on bash using the mtx-changer
script, while on bconsole it does not. Any hint?
root@phobos:~# lsscsi -g
[0:0:0:0]cd/dvd TSSTcorp CDRWDVD TS-H492C DE02 /dev/sr0 /dev/sg0
[2:0:8:0]enclosu DP BACKPLANE1.05 - /dev/sg1
[2:2:0:0]diskDELL PERC 5/i 1.03 /dev/sda /dev/sg2
[3:0:0:0]tapeIBM ULTRIUM-TD4 97F0 /dev/st0 /dev/sg3
[3:0:1:0]tapeIBM ULT3580-HH6 G9P1 /dev/st1 /dev/sg4
[3:0:1:1]mediumx IBM 3572-TL 0071 /dev/sch0 /dev/sg5
root@phobos:~# /etc/bacula/mtx-changer /dev/sg5 slots
8
root@phobos:~# /etc/bacula/mtx-changer /dev/sg5 listall 0 /dev/sg4 0
D:0:E
S:1:F:01L6
S:2:E
S:3:E
S:4:E
S:5:E
S:6:E
S:7:E
S:8:F:CLNU00L1
root@phobos:~# echo "update slots storage=TL1000" | bconsole
Connecting to Director 192.168.0.207:9101
1000 OK: 102 mercurio-dir Version: 7.4.7 (15 March 2017)
Enter a period to cancel a command.
update slots storage=TL1000
Automatically selected Catalog: CatalogoA1Sede
Using Catalog "CatalogoA1Sede"
Connecting to Storage daemon TL1000 at 192.168.0.207:9103 ...
3306 Issuing autochanger "slots" command.
Device "TL1000" has 0 slots.
No slots in changer to scan.
root@phobos:~#
bacula-sd.conf:
Storage {
Name = phobos-sd
SDPort= 9103
WorkingDirectory = "/var/lib/bacula"
Pid Directory = "/var/run/bacula"
Maximum Concurrent Jobs = 20
SDAddress = 192.168.0.207
Maximum Concurrent Jobs = 1
}
Device {
Name= LTO
Media Type = LTO-4
Archive Device = /dev/st0
Device Type = Tape
AutomaticMount = yes
AlwaysOpen = yes
RemovableMedia = yes
RandomAccess= no
AutoChanger = no
Volume Poll Interval= 0
Offline On Unmount = yes
Close on Poll = yes
Maximum Concurrent Jobs = 1
}
Autochanger {
Name = TL1000
device= LTO-6
Changer Device= /dev/sg5
Changer Command = "/etc/bacula/scripts/mtx-changer %c %o %S %a %d"
}
Device {
Name= LTO-6
Media Type = LTO-6
Archive Device = /dev/sg4
Autochanger = yes
LabelMedia = no
AutomaticMount = yes
AlwaysOpen = yes
}
bacula-dir.conf:
Storage {
Name= LTO
Address = 192.168.0.207
SDPort = 9103
Password= "nonono"
Device = LTO
Media Type = LTO-4
Autochanger = no
Maximum Concurrent Jobs = 1
}
Storage {
Name= TL1000
Address = 192.168.0.207
SDPort = 9103
Password= "nonono"
Device = TL1000
Media Type = LTO-6
Autochanger = yes
Maximum Concurrent Jobs = 1
}
Thanks for any hint and for bacula, best regards.
--
*Marcio Merlone*
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Per-job Job Retention
Greetings, I need to specify a per-job Job Retention. On bacula main documentation this parameter is not listed on Job Resource docs (1), but I found many examples on the web and even in this list archive (2). Plain question: can I specify a big (bogus) Job Retention for the client (or even omit) and smaller Job Retention on each Job Definitions? Best regards. (1) http://www.bacula.org/en/dev-manual/main/main/Configuring_Director.html#SECTION00143 (2) http://sourceforge.net/mailarchive/message.php?msg_id=27890720 -- *Marcio Merlone* TI - Administrador de redes *A1 Engenharia - Unidade Corporativa* Fone: +55 41 3616-3797 Cel:+55 41 9689-0036 http://www.a1.ind.br/ http://www.a1.ind.br -- Get 100% visibility into Java/.NET code with AppDynamics Lite! It's a free troubleshooting tool designed for production. Get down to code-level detail for bottlenecks, with 2% overhead. Download for free and get started troubleshooting in minutes. http://pubads.g.doubleclick.net/gampad/clk?id=48897031iu=/4140/ostg.clktrk___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Restore hangs on bat (Postgresql)
Greetings, I have a running bacula 5.0.1-1ubuntu1 on a Ubuntu 10.04.4 LTS server box for some years now, using PostgreSQL 8.4.12-0ubuntu10.04. My file table has around 20M+ records. Whenever I try to restore something using the bacula-console-qt 5.2.5-0ubuntu6.1 from my workstation (Ubuntu 12.04) it hangs forever. Is the director x console version mismatch the problem or should I check something else? Please let me know if you need further info. Thanks in advance and best regards. -- *Marcio Merlone* -- Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Restore hangs on bat (Postgresql)
Em 09-08-2012 09:54, John Drescher escreveu: On Thu, Aug 9, 2012 at 8:23 AM, Marcio Merlone marcio.merl...@a1.ind.br wrote: I have a running bacula 5.0.1-1ubuntu1 on a Ubuntu 10.04.4 LTS server box for some years now, using PostgreSQL 8.4.12-0ubuntu10.04. My file table has around 20M+ records. Whenever I try to restore something using the bacula-console-qt 5.2.5-0ubuntu6.1 from my workstation (Ubuntu 12.04) it hangs forever. Is the director x console version mismatch the problem or should I check something else? Please let me know if you need further info. Does restoring work in bconsole? Yes, bconsole works, and It works on bat 5.0 too. Just _my_ bat 5.2 doesn't. -- *Marcio Merlone* -- Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Restore hangs on bat (Postgresql)
Em 09-08-2012 09:56, Jummo escreveu: Hi Marcio, On Thu, 9 Aug 2012, Marcio Merlone wrote: I have a running bacula 5.0.1-1ubuntu1 on a Ubuntu 10.04.4 LTS server box for some years now, using PostgreSQL 8.4.12-0ubuntu10.04. My file table has around 20M+ records. Whenever I try to restore something using the bacula-console-qt 5.2.5-0ubuntu6.1 from my workstation (Ubuntu 12.04) it hangs forever. Where exactly hangs the restore? On the Building directory tree for JobId(s) xxx, xxx, xxx Do you have tuned your PostgreSQL installation? The default settings are for wide compatibility and not perfomance, see [1]. I have adjusted shared_buffers to 2GB and effective_cache_size to 5G and this boost the building directory phase of a restore greatly. Furthermore I have tuned the squence object arrcording to [2], but I think this isn't helpful for restores. I felt the need for some tune, but this is not the issue. As I told John, restore works on bconsole and bat 5.0, the issue is just with my bat 5.2. Regarding Postgre tunning, will procrastinate this since it is not the issue. But will definitely do it when time is available. -- *Marcio Merlone* -- Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] 5.2.x client with 5.0.3 director/storage
Em 12-12-2011 18:41, Ben Walton escreveu: I don't see a documented item about running a 5.2.1 client with the older 5.0.3 director and 5.0.3 storage daemon. (I do see notes about doing this version straddle in the opposite direction.) It seems to work but is it a valid configuration? Is there anything I should know when running like this? +1 I was about to try that. Windows version of bat 5.0.x is broken for me, so I wanted to try the new version, but had no guts for this... :) -- *Marcio Merlone* -- Systems Optimization Self Assessment Improve efficiency and utilization of IT resources. Drive out cost and improve service delivery. Take 5 minutes to use this Systems Optimization Self Assessment. http://www.accelacomm.com/jaw/sdnl/114/51450054/___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Slow tape write, no more than 60-70 MB/s in 5.0.3
Em 09-11-2011 09:26, Cejka Rudolf escreveu: Cejka Rudolf wrote (2011/11/09): does anybody have any idea, why after upgrade from Bacula 2.4.3 to 5.0.3, tape write speed dropped down from about 70-120 MB/s (LTO-3 tape limits) to just 60-70 MB/s? I think that I have seen somewhere, that something (signatures?) has been moved from clients or director to storage daemon, but could not find it anymore. Or could be the problem somewhere else? Oops, I'm sorry, I forgot to add -O3. After returning -O3, I can see again speeds over 100 MB/s. Please enlighten me (us?): Where did you add -03 to improve the speed? I have an LTO-4 drive and get no more than 50~60 MB/s! -- *Marcio Merlone* -- RSA(R) Conference 2012 Save $700 by Nov 18 Register now http://p.sf.net/sfu/rsa-sfdev2dev1___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Help with a stuck restore
Em Ter 25 Out 2011 13:53:44 BRST, Marcio Merlone escreveu: I run a bacula 5.0.1-1ubuntu1 server for some years now on an Ubuntu 10.04.3 LTS. A few days ago a users asked for a restore, but I am still unable to complete the task, bconsole stucks on Building directory tree for JobId(s) 2202,2369,2383,2397 It used to take long, but this time it is really stuck, I left it running for more than 24 hours without luck. On mysql administrator, the query SELECT Path.Path, Filename.Name, Temp.Fileindex runs fine but stalls on state sending data and nothing happens. I have already run dbcheck and fixed everything, but yet no luck. Has anybody gone trough this? Can anybody assist me find and correct this? Bump! Please? -- *Marcio Merlone* -- The demand for IT networking professionals continues to grow, and the demand for specialized networking skills is growing even more rapidly. Take a complimentary Learning@Cisco Self-Assessment and learn about Cisco certifications, training, and career opportunities. http://p.sf.net/sfu/cisco-dev2dev___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Help with a stuck restore
Greetings, I run a bacula 5.0.1-1ubuntu1 server for some years now on an Ubuntu 10.04.3 LTS. A few days ago a users asked for a restore, but I am still unable to complete the task, bconsole stucks on Building directory tree for JobId(s) 2202,2369,2383,2397 It used to take long, but this time it is really stuck, I left it running for more than 24 hours without luck. On mysql administrator, the query SELECT Path.Path, Filename.Name, Temp.Fileindex runs fine but stalls on state sending data and nothing happens. I have already run dbcheck and fixed everything, but yet no luck. Has anybody gone trough this? Can anybody assist me find and correct this? Thanks in advance, best regards. -- *Marcio Merlone* -- The demand for IT networking professionals continues to grow, and the demand for specialized networking skills is growing even more rapidly. Take a complimentary Learning@Cisco Self-Assessment and learn about Cisco certifications, training, and career opportunities. http://p.sf.net/sfu/cisco-dev2dev___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Yet another 'Invalid command .messages' on restore
Greetings, I am a happy user of bacula 5.0.1 on a Ubuntu 10.04.3 LTS server. It backs up 8 clients without any problem. All clients have bacula-fd 5.0.1 or above, so no old client with new server - all linux servers use 5.0.1 and the lonely windows server uses 5.0.3. I also disabled automatic messages display on preferences as I found on list archives. But yet, when trying to restore something it often - but not always - gives the error Invalid command .messages. Can anybody help me find a solution? That problem annoys me for years... Thanks and best regards. -- *Marcio Merlone* -- All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity and more. Splunk takes this data and makes sense of it. Business sense. IT sense. Common sense. http://p.sf.net/sfu/splunk-d2dcopy1___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Restore performance
Em 21-09-2011 09:29, Gavin McCullagh escreveu: On Wed, 21 Sep 2011, Erik P. Olsen wrote: I am running a very smooth bacula 5.0.3 on Fedora 14. Everything seems to be OK except restores which are incredibly slow. How can I debug it to see what's wrong? - building the file tree for selection +1 on this. I am running bacula 5.0.1-1ubuntu1 on a Ubuntu 10.04.3 LTS server. Database is about 150GB big and any restore takes 2 or 3 minutes to build the tree. -- *Marcio Merlone* attachment: marcio_merlone.vcf-- All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity and more. Splunk takes this data and makes sense of it. Business sense. IT sense. Common sense. http://p.sf.net/sfu/splunk-d2dcopy1___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Restore performance
Em 21-09-2011 10:29, Gavin McCullagh escreveu: A 150GB database. That's pretty large. How many clients have you? About a dozen clients - some inactive but still with valid backup - File Retention = 6 months, Job Retention = 1 year. Most clients have few or no changes, but my storage server has 2,825,101 files on a full backup and almost 100.000 on an incremental. Which database are you using (MySQL, Postgresql)? MySQL. If you haven't seen it already, this might be useful: http://wiki.bacula.org/doku.php?id=faq#restore_takes_a_long_time_to_retrieve_sql_results_from_mysql_catalog Yes, I was there when you mail arrived. It made think about going to Postgres. Is there any upgrade path or helper to go from mysql to postgres? I am now optimizing File table and will then run dbcheck. Best regards, -- *Marcio Merlone* -- All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity and more. Splunk takes this data and makes sense of it. Business sense. IT sense. Common sense. http://p.sf.net/sfu/splunk-d2dcopy1___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Yet another 'Invalid command .messages' on restore
Em 21-09-2011 11:04, Marcello Romani escreveu: I suppose you're referring to Bat. If yes, Sorry, yes. :) do the following: Settings = Preferences Uncheck Check messages, or leave it checked but insert a very long interval (like 3600 seconds) Have done ages ago, no luck. below. This is not enough, though. If you have unread messages you'll still get the error on restore. Open an ssh (i.e. command line) connection to the bacula server. Launch the bconsole command and type the messages command. This will clear the unread messages queue in bacula. Now you can connect with BAT restore files without the .messages error. This is the procedure that currently works for me. HTH Good tip, but it is a workaround, not a solution. What is the solution? -- *Marcio Merlone* -- All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity and more. Splunk takes this data and makes sense of it. Business sense. IT sense. Common sense. http://p.sf.net/sfu/splunk-d2dcopy1___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Yet another 'Invalid command .messages' on restore
Em 21-09-2011 13:03, Marcello Romani escreveu: Il 21/09/2011 16:28, Marcio Merlone ha scritto: Em 21-09-2011 11:04, Marcello Romani escreveu: do the following: Settings = Preferences Uncheck Check messages, or leave it checked but insert a very long interval (like 3600 seconds) Have done ages ago, no luck. below. This is not enough, though. If you have unread messages you'll still get the error on restore. Open an ssh (i.e. command line) connection to the bacula server. Launch the bconsole command and type the messages command. This will clear the unread messages queue in bacula. Now you can connect with BAT restore files without the .messages error. This is the procedure that currently works for me. HTH Good tip, but it is a workaround, not a solution. What is the solution? I haven't found one yet. This workaround seems good enough for me. I guess a definitive solution would come from modifying BAT (this looks like a bug in BAT to me). Is there any bacula developer here to talk about? -- *Marcio Merlone* -- All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity and more. Splunk takes this data and makes sense of it. Business sense. IT sense. Common sense. http://p.sf.net/sfu/splunk-d2dcopy1___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Restore performance
Em 21-09-2011 13:33, Alexandre Chapellon escreveu: As Gavin pointed out, a 150GB database is huuuge for only a dozen client. Unless you have billions of files on each client there is no reason your catalog is that large. Are you sure you correctly applied job and file retention on your catalog? Also are you sure you catalog is not full of orphaned records? Before migrating to postgres (which is a good choice for big catalogs), I would look at the catalog to see if all retention period are correctly applied. I am running dbcheck to see how many rabbits come out of the bushes. File table is only 6.6GB and Log is 105GB. What's that Log table for? It only have blobs... Also, in a near future I will change bacula-dir to another server, which will be a good opportunity to start a blank catalog and go with Postgres, without any migration, just keeping the old one sitting there until the end of retention period. -- *Marcio Merlone* -- All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity and more. Splunk takes this data and makes sense of it. Business sense. IT sense. Common sense. http://p.sf.net/sfu/splunk-d2dcopy1___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Purge Log table - was: Re: Restore performance
Em 21-09-2011 14:45, Alexandre Chapellon escreveu: Le 21/09/2011 18:56, Marcio Merlone a écrit : Em 21-09-2011 13:33, Alexandre Chapellon escreveu: As Gavin pointed out, a 150GB database is huuuge for only a dozen client. Unless you have billions of files on each client there is no reason your catalog is that large. Are you sure you correctly applied job and file retention on your catalog? Also are you sure you catalog is not full of orphaned records? Before migrating to postgres (which is a good choice for big catalogs), I would look at the catalog to see if all retention period are correctly applied. I am running dbcheck to see how many rabbits come out of the bushes. File table is only 6.6GB and Log is 105GB. What's that Log table for? It only have blobs... It is supposed to contain bacula report... just like in the bacula log file. I'm not sure having such a big amount of data in another table hurts, may be it does if you use innodb. If you use MyISAM... my guess is it should not hurts... but note I am not a DBA! Me neither, and it is innodb, in my case. However, I'd like to know if this table can be safely purged? As one day or another it will grow to an unacceptable size... (even more if I have the same info in logfile). +1 Can it? -- *Marcio Merlone* -- All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity and more. Splunk takes this data and makes sense of it. Business sense. IT sense. Common sense. http://p.sf.net/sfu/splunk-d2dcopy1___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Purge Log table - was: Re: Restore performance
Em 21-09-2011 15:24, Alexandre Chapellon escreveu: maybe you could try this: http://dev.mysql.com/doc/refman/5.0/en/innodb-multiple-tablespaces.html However, I'd like to know if this table can be safely purged? As one day or another it will grow to an unacceptable size... (even more if I have the same info in logfile). +1 Can it? Thanks, but nah! I'd rather purge this. I'll set another server anyway... Regards. -- *Marcio Merlone* attachment: marcio_merlone.vcf-- All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity and more. Splunk takes this data and makes sense of it. Business sense. IT sense. Common sense. http://p.sf.net/sfu/splunk-d2dcopy1___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Bacula sabe se atingiu a capacidade máxima de uma fita?
Em 29-04-2011 11:21, Victor Lima escreveu: Rodrigo I'm sorry, I forgot this list was international. I asked this question because the bacula recorded a tape of me until it gets to 2.4TB. What I did find it strange for the reason the tape reaches up to 1.6TB. I have a LTO-4 tape full with 2.7GB and another with 2.89GB. :) -- *Marcio Merlone* attachment: marcio_merlone.vcf-- WhatsUp Gold - Download Free Network Management Software The most intuitive, comprehensive, and cost-effective network management toolset available today. Delivers lowest initial acquisition cost and overall TCO of any competing solution. http://p.sf.net/sfu/whatsupgold-sd___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Maildir and mysql plugin
Good afternoon! I was wondering... would be nice to have a maildir backup plugin, where one could backup a maildir and have its contents indexed and restorable by sender, subject, date, attachments, etc.. I could try to write one myself, but wouldn't have the required skills and time. Has anyone ever though about this? Is it doable? Not to mention a mysql plugin, where one could restore specific database, table, row, on a live system I think those are the features lacking on bacula to put it side-by-side with commercial products. Pls, no flames! Bacula is great, I love it, and would not change it for a commercial one even if they were free, I am just making a feature request and brain storming. That could even pave the path for Exchange, MS-SQL, Firebird, Oracle, etc... Best regards. -- Marcio Merlone -- Sell apps to millions through the Intel(R) Atom(Tm) Developer Program Be part of this innovative community and reach millions of netbook users worldwide. Take advantage of special opportunities to increase revenue and speed time-to-market. Join now, and jumpstart your future. http://p.sf.net/sfu/intel-atom-d2d ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Maildir and mysql plugin
Em 23-08-2010 16:39, Radosław Korzeniewski escreveu: 2010/8/23 Marcio Merlone marcio.merl...@a1.ind.br mailto:marcio.merl...@a1.ind.br I was wondering... would be nice to have a maildir backup plugin, where one could backup a maildir and have its contents indexed and restorable by sender, subject, date, attachments, etc.. I could try to write one myself, but wouldn't have the required skills and time. Has anyone ever though about this? Is it doable? It is a good idea. It should be easy. The problem is, who wants to use it? Good question, at least me. Not that I ever needed anyway, but seems cool and rather useful in an event. :) Not to mention a mysql plugin, where one could restore specific database, table, row, on a live system Well, a mysql plugin for hot backup should be available soon :) Is there an ETA? But a problem is it will backup a whole mysql instance, not a specific database, table or row. The main problem with restoring database objects on a live system is database data integrity. You can't restore a particular row without checking table or column constraints, triggers or else. Sure. I think those are the features lacking on bacula to put it side-by-side with commercial products. Pls, no flames! Bacula is great, I love it, and would not change it for a commercial one even if they were free, I am just making a feature request and brain storming. That could even pave the path for Exchange, MS-SQL, Firebird, Oracle, etc... A plugin for backup of Exchange is available for some time. Plugin for Oracle is on newest project TODO list. But to compete with other commercial products, Bacula should have a strong commercial support and development, so not all new feature will be available on community version, only on enterprise one - check Kerns email on bacula-devel a few weeks ago. Thanks God I don't care about exchange. But I do about MS-SQL. Any plans for that? Currently I use community version, but with a MS-SQL plugin it could change. -- Marcio Merlone -- Sell apps to millions through the Intel(R) Atom(Tm) Developer Program Be part of this innovative community and reach millions of netbook users worldwide. Take advantage of special opportunities to increase revenue and speed time-to-market. Join now, and jumpstart your future. http://p.sf.net/sfu/intel-atom-d2d___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Job stuck running
Morning all! I am running bacula director 5.0.1-1ubuntu1 on a Ubuntu Lucid box. It is now backing up a 2.4.2-1ubuntu4~hardy1 client and the job seems stuck: Director: Running Jobs: JobId Level Name Status == 3282 Increme JobMercurio.2010-07-08_17.30.00_44 is running Storage: Device DAT-72 (/dev/st0) is mounted with: Volume: BDI-0012 Pool:PoolDiario Media type: DAT-72 Total Bytes=10,340,241,408 Blocks=160,283 Bytes/block=64,512 Positioned at File=16 Block=26 Total bytes, blocks, position, etc, nothing changes. Could this be a version mismatch between director and fd on the client? Any workaround? Thanks and best regards. -- Marcio Merlone -- This SF.net email is sponsored by Sprint What will you do first with EVO, the first 4G phone? Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Job stuck running
Em 09-07-2010 09:51, John Drescher escreveu: 2010/7/9 Marcio Merlonemarcio.merl...@a1.ind.br: Morning all! I am running bacula director 5.0.1-1ubuntu1 on a Ubuntu Lucid box. It is now backing up a 2.4.2-1ubuntu4~hardy1 client and the job seems stuck: Director: Running Jobs: JobId Level Name Status == 3282 Increme JobMercurio.2010-07-08_17.30.00_44 is running Storage: Device DAT-72 (/dev/st0) is mounted with: Volume: BDI-0012 Pool:PoolDiario Media type: DAT-72 Total Bytes=10,340,241,408 Blocks=160,283 Bytes/block=64,512 Positioned at File=16 Block=26 Total bytes, blocks, position, etc, nothing changes. Could this be a version mismatch between director and fd on the client? Any workaround? Is it spooling attributes. Check for database activity on the server. This job started yesterday 17:30, it is now 10:24. It never took so long, and the mysql server seems idle, there are two connections from bacula user, both sleeping and no load on mysql. Thanks for you reply, any other idea, please? -- Marcio Merlone -- This SF.net email is sponsored by Sprint What will you do first with EVO, the first 4G phone? Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Job stuck running
Em 09-07-2010 10:28, John Drescher escreveu: This job started yesterday 17:30, it is now 10:24. It never took so long, and the mysql server seems idle, there are two connections from bacula user, both sleeping and no load on mysql. What does status client return for that client? mercurio-fd Version: 2.4.2 (26 July 2008) i486-pc-linux-gnu debian lenny/sid Daemon started 21-Jun-10 17:30, 13 Jobs run since started. Heap: heap=1,032,192 smbytes=233,089 max_bytes=528,257 bufs=157 max_bufs=325 Sizeof: boffset_t=8 size_t=4 debug=0 trace=0 Running Jobs: JobId 3282 Job JobMercurio.2010-07-08_17.30.00_44 is running. Backup Job started: 08-Jul-10 17:30 Files=3 Bytes=1,672,559 Bytes/sec=27 Errors=0 Files Examined=1,051 Processing file: /home/dados/public_eng/APL/ELETRICA/A1PRO/DB_TESTE SDReadSeqNo=5 fd=5 Director connected at: 09-Jul-10 10:30 -- Marcio Merlone -- This SF.net email is sponsored by Sprint What will you do first with EVO, the first 4G phone? Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Job stuck running
Em 09-07-2010 10:39, Anatoly Pugachev escreveu: On 09.07.2010 / 10:26:49 -0300, Marcio Merlone wrote: Em 09-07-2010 09:51, John Drescher escreveu: 2010/7/9 Marcio Merlonemarcio.merl...@a1.ind.br: Morning all! I am running bacula director 5.0.1-1ubuntu1 on a Ubuntu Lucid box. It is now backing up a 2.4.2-1ubuntu4~hardy1 client and the job seems stuck: Director: Running Jobs: JobId Level Name Status == 3282 Increme JobMercurio.2010-07-08_17.30.00_44 is running Storage: Device DAT-72 (/dev/st0) is mounted with: Volume: BDI-0012 Pool:PoolDiario Media type: DAT-72 Total Bytes=10,340,241,408 Blocks=160,283 Bytes/block=64,512 Positioned at File=16 Block=26 Total bytes, blocks, position, etc, nothing changes. Could this be a version mismatch between director and fd on the client? Any workaround? Is it spooling attributes. Check for database activity on the server. This job started yesterday 17:30, it is now 10:24. It never took so long, and the mysql server seems idle, there are two connections from bacula user, both sleeping and no load on mysql. Thanks for you reply, any other idea, please? please post : status dir and status storage *st dir asteroid-dir Version: 5.0.1 (24 February 2010) i486-pc-linux-gnu ubuntu 10.04 Daemon started 05-Jul-10 14:22, 37 Jobs run since started. Heap: heap=528,384 smbytes=188,114 max_bytes=329,240 bufs=581 max_bufs=772 Scheduled Jobs: Level Type Pri Scheduled Name Volume === Differential Backup10 09-Jul-10 17:30JobAsteroidBSI-0003 Differential Backup10 09-Jul-10 17:30JobMercurioBSI-0003 Differential Backup10 09-Jul-10 17:30JobHaumea BSI-0003 Differential Backup10 09-Jul-10 17:30JobNetuno BSI-0003 Differential Backup10 09-Jul-10 17:30JobVenus BSI-0003 Differential Backup10 09-Jul-10 17:30JobUrano BSI-0003 Full Backup11 09-Jul-10 23:10BackupCatalog BDI-0012 Running Jobs: Console connected at 08-Jul-10 09:21 Console connected at 08-Jul-10 09:21 Console connected at 09-Jul-10 10:30 JobId Level Name Status == 3282 Increme JobMercurio.2010-07-08_17.30.00_44 is running 3283 Increme JobHaumea.2010-07-08_17.30.00_45 is waiting on max Storage jobs 3284 Increme JobNetuno.2010-07-08_17.30.00_46 is waiting on max Storage jobs 3285 Increme JobVenus.2010-07-08_17.30.00_47 is waiting on max Storage jobs 3286 Increme JobUrano.2010-07-08_17.30.00_48 is waiting on max Storage jobs 3287 FullBackupCatalog.2010-07-08_23.10.00_49 is waiting execution Terminated Jobs: JobId LevelFiles Bytes Status FinishedName 3272 Incr1703.646 G OK 07-Jul-10 11:57 JobUrano 3273 Incr 7 403 OK 07-Jul-10 11:57 JobVenus 3274 Incr 1,03515.56 M OK 07-Jul-10 17:30 JobAsteroid 3275 Incr 36,4275.668 G OK 08-Jul-10 08:56 JobMercurio 3276 Incr 17,3332.059 G OK 08-Jul-10 09:14 JobHaumea 3277 Incr 5,886355.7 M OK 08-Jul-10 09:18 JobNetuno 3278 Incr 101.906 K OK 08-Jul-10 09:19 JobVenus 3279 Incr1583.150 G OK 08-Jul-10 09:26 JobUrano 3280 Full 11.559 G OK 08-Jul-10 09:31 BackupCatalog 3281 Incr 1,07615.59 M OK 08-Jul-10 17:30 JobAsteroid **st sto The defined Storage resources are: 1: DAT-72 2: StHddSemestral Select Storage resource (1-2): 1 Connecting to Storage daemon DAT-72 at 192.168.0.213:9103 asteroid-sd Version: 5.0.1 (24 February 2010) i486-pc-linux-gnu ubuntu 10.04 Daemon started 05-Jul-10 14:22, 28 Jobs run since started. Heap: heap=401,408 smbytes=155,248 max_bytes=287,700 bufs=106 max_bufs=117 Sizes: boffset_t=8 size_t=4 int32_t=4 int64_t=8 Running Jobs: Writing: Incremental Backup job JobMercurio JobId=3282 Volume=BDI-0012 pool=PoolDiario device=DAT-72 (/dev/st0) spooling=0 despooling=0 despool_wait=0 Files=3 Bytes=1,672,969 Bytes/sec=25 FDReadSeqNo=332 in_msg=320 out_msg=5 fd=5 Jobs waiting to reserve a drive: Terminated Jobs: JobId LevelFiles Bytes Status FinishedName === 3272 Incr1703.646 G OK 07-Jul-10 11:57 JobUrano 3273 Incr 71.060 K OK 07-Jul-10 11:57 JobVenus 3274 Incr 1,03515.70 M OK
Re: [Bacula-users] Job stuck running
Em 09-07-2010 10:37, John Drescher escreveu: Check dmesg and lsof on client to see if there are any errors or somehow /home/dados/public_eng/APL/ELETRICA/A1PRO/DB_TESTE is not readable. Nothing on dmesg, but the file is actually open. I think this should not be an issue, should it? r...@mercurio:~# lsof | grep TESTE smbd 4605 rodrigo.maia 38u REG8,4 191897608437840 /home/dados/public_eng/APL/ELETRICA/A1PRO/DB_TESTE/BD_A1PRO.mdb smbd 4605 rodrigo.maia 39u REG8,4 191897608437840 /home/dados/public_eng/APL/ELETRICA/A1PRO/DB_TESTE/BD_A1PRO.mdb smbd 4605 rodrigo.maia 63uw REG8,4 1288437881 /home/dados/public_eng/APL/ELETRICA/A1PRO/DB_TESTE/BD_A1PRO.ldb r...@mercurio:~# -- Marcio Merlone -- This SF.net email is sponsored by Sprint What will you do first with EVO, the first 4G phone? Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] 1/2 SOLVED: Re: Job stuck running
Em 09-07-2010 11:51, Marcio Merlone escreveu: Em 09-07-2010 10:37, John Drescher escreveu: Check dmesg and lsof on client to see if there are any errors or somehow /home/dados/public_eng/APL/ELETRICA/A1PRO/DB_TESTE is not readable. Nothing on dmesg, but the file is actually open. I think this should not be an issue, should it? r...@mercurio:~# lsof | grep TESTE smbd 4605 rodrigo.maia 38u REG8,4 191897608437840 /home/dados/public_eng/APL/ELETRICA/A1PRO/DB_TESTE/BD_A1PRO.mdb smbd 4605 rodrigo.maia 39u REG8,4 191897608437840 /home/dados/public_eng/APL/ELETRICA/A1PRO/DB_TESTE/BD_A1PRO.mdb smbd 4605 rodrigo.maia 63uw REG8,4 1288437881 /home/dados/public_eng/APL/ELETRICA/A1PRO/DB_TESTE/BD_A1PRO.ldb r...@mercurio:~# Good news first: it unstuck and finished successfully. The bad news: I don't know why, where, when, and the file above is still open. -- Marcio Merlone -- This SF.net email is sponsored by Sprint What will you do first with EVO, the first 4G phone? Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] 1/2 SOLVED: Re: Job stuck running
Em 09-07-2010 13:55, John Drescher escreveu: 2010/7/9 Marcio Merlonemarcio.merl...@a1.ind.br: Em 09-07-2010 11:51, Marcio Merlone escreveu: Good news first: it unstuck and finished successfully. The bad news: I don't know why, where, when, and the file above is still open Looks like a samba user has this open. For sure, I mentioned just to enlighten it was not the reason for the job stuck. What bothers me is that I still don't know (and probably won't) why it stuck. -- Marcio Merlone -- This SF.net email is sponsored by Sprint What will you do first with EVO, the first 4G phone? Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Semestral schedule
Hi all, I am a little confused on how to specify a semestral schedule and could not find a sample on the net. Can anybody help me? In short, it must be run twice a year, first monday of january and july. Thanks and regards. -- Marcio Merlone -- ThinkGeek and WIRED's GeekDad team up for the Ultimate GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the lucky parental unit. See the prize list and enter to win: http://p.sf.net/sfu/thinkgeek-promo ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Automatic Eject tape once job finishes
Em 15-05-2010 08:32, Koldo Santisteban escreveu: Try using RunAfterJob option on the Job definition with a command like mt -f /dev/st0 eject (using you scsi device path of course) I would like it to be executed when it asks for another tape only, since I can reuse the same tape along the week. Is it possible? -- Marcio Merlone -- ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
