[Bacula-users] ERR=Operation timed out
Hello everyone, I have recently received the following error for a bacula job: Fatal error: Network error with FD during Backup: ERR=Operation timed out Fatal error: No Job status returned from FD. bacula starts the backup job, it runs for a few mins, ( I could see the backup progress) but it terminate all of a sudden while reporting the above error. thanks in advance for your help Regards, -- 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-web bconsole permissions problem
Hello Chris, Could you tell me if you configured bconsole access via sudo in the following way: http://www.bacula.org/9.0.x-manuals/en/console/Baculum_API_Web_GUI_Tools.html#SECTION00344000 Did you test the sudo from www-data user? In newer Baculum versions in the install wizard you should see error message that comes directly from the bconsole execution. What Baculum version do you use? If you are going to not use sudo, then you need to give the web server user access both to bconsole binary and to bconsole config file. Usually this setting is up to the user, I don't have the only one valid solution here. Best regards. Marcin Haba (gani) On 16 May 2018 at 19:44, Chris Wilkinsonwrote: > In a new install of baculum-web on Debian wheezy, I ran into a permissions > issue with Apache2 not being able to access bconsole. This shows up as an > error in the install wizard and in the Web page when attempting any > operation. Bconsole works fine from the command line, as root/sudo of > course. Since Apache runs as www-data:www-data, I'm guessing I need to fix > some permissions. I'm not sure what permissions I need to change so could > anybody advise? > > Many thanks > Chris > > -- > 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 > -- "Greater love hath no man than this, that a man lay down his life for his friends." Jesus Christ "Większej miłości nikt nie ma nad tę, jak gdy kto życie swoje kładzie za przyjaciół swoich." Jezus Chrystus -- 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] Baculum-web bconsole permissions problem
In a new install of baculum-web on Debian wheezy, I ran into a permissions issue with Apache2 not being able to access bconsole. This shows up as an error in the install wizard and in the Web page when attempting any operation. Bconsole works fine from the command line, as root/sudo of course. Since Apache runs as www-data:www-data, I'm guessing I need to fix some permissions. I'm not sure what permissions I need to change so could anybody advise? Many thanks Chris -- 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 - Grouping error: 7 ERROR: column "media.volumename" ...
Hello Rasmus, Thanks for the confirmation that the patch works well. On 16 May 2018 at 09:17, Rasmus Lindenwrote: > Hi Marcin ! > Thanks a bunch, works a charm > A quick note, I’m currently in German, on timezone Europe/Berlin. > If i do not set a timezone definition in php.ini, the java script for > choosing files does not work, and logs a error to console warning about > having to set a timezone, and not relying on default. Yes, right. Timezone setting is something what has to be more exposed in the documentation specially that it can cause the warning that you mentioned. Currently there is only small notice about timezone in the README file. I will add more information to the doc. Thanks. > And a big thanks again for helping me out, very very much appreciated. Thanks too for your help. Best regards. Marcin Haba (gani) > All the best > > Ras > > >> On 15 May 2018, at 21:46, Marcin Haba wrote: >> >> Hello Rasmus, >> >> Thanks for reporting this problem. >> >> It is a bug that will be fixed in the next Baculum version. >> >> In attachment I added patch that fixes it. >> >> Best regards. >> Marcin Haba (gani) >> >> On 14 May 2018 at 15:07, Rasmus Linden wrote: >>> Hey All! >>> Im a long time bacula user, and finally got myself updated to v9.0.7, and i >>> have run into a issue with baculum i just cannot figure out how to solve. >>> I have everything working, except restoring using baculm. -bat and bconsole >>> works with no issues. >>> >>> When i have chosen files to restore, and click next, i get a sql error : >>> >>> Baculum problem >>> Error 100 - Problem with connection to remote host. cURL error 0: . >>> >>> SQLSTATE[42803]: Grouping error: 7 ERROR: column "media.volumename" must >>> appear in the GROUP BY clause or be used in an aggregate function LINE 2: >>> SELECT VolumeName, InChanger, MIN(FirstIndex) as first_in... ^ >>> >>> >>> 0083: $connection = VolumeRecord::finder()->getDbConnection(); >>> 0084: $connection->setActive(true); >>> 0085: $sql = sprintf('SELECT first_index, last_index, VolumeName AS >>> volname, InChanger AS inchanger FROM ( >>> 0086: SELECT VolumeName, InChanger, MIN(FirstIndex) as first_index, >>> MAX(LastIndex) as last_index >>> 0087: FROM JobMedia JOIN Media ON (JobMedia.MediaId = >>> Media.MediaId) >>> 0088: WHERE JobId = %d GROUP BY (VolumeName, InChanger) >>> 0089: ) AS gv, File >>> 0090: WHERE FileIndex >= first_index >>> 0091: AND FileIndex <= last_index >>> 0092: AND File.FileId = %d', $jobid, $fileid); >>> 0093: $pdo = $connection->getPdoInstance(); >>> 0094: $result = $pdo->query($sql); >>> 0095: $ret = $result->fetchAll(); >>> 0096: $pdo = null; >>> 0097: $volumes = array(); >>> 0098: if (is_array($ret)) { >>> 0099: for ($i = 0; $i < count($ret); $i ) { >>> 0100: $volumes[] = array( >>> 0101: 'first_index' => $ret[$i]['first_index'], >>> 0102: 'last_index' => $ret[$i]['last_index'], >>> 0103: 'volume' => $ret[$i]['volname'], >>> 0104: 'inchanger' => $ret[$i]['inchanger'] >>> 0105: ); >>> 0106: } >>> >>> >>> I started out with a quite large MySql database, but for troubleshooting, i >>> am running a clean posgress database. >>> Os is CentOS Linux release 7.5.1804 (Core) >>> >>> Anybody got any good ideas ?? >>> >>> All the best >>> >>> Ras >>> >>> >>> >>> -- >>> 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 >>> >> >> >> >> -- >> "Greater love hath no man than this, that a man lay down his life for >> his friends." Jesus Christ >> >> "Większej miłości nikt nie ma nad tę, jak gdy kto życie swoje kładzie >> za przyjaciół swoich." Jezus Chrystus >> > -- "Greater love hath no man than this, that a man lay down his life for his friends." Jesus Christ "Większej miłości nikt nie ma nad tę, jak gdy kto życie swoje kładzie za przyjaciół swoich." Jezus Chrystus -- 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] Bacula-users Digest, Vol 145, Issue 20
On Wed, May 16, 2018 at 12:57 AM,wrote: > Send Bacula-users mailing list submissions to > bacula-users@lists.sourceforge.net > > To subscribe or unsubscribe via the World Wide Web, visit > https://lists.sourceforge.net/lists/listinfo/bacula-users > or, via email, send a message with subject or body 'help' to > bacula-users-requ...@lists.sourceforge.net > > You can reach the person managing the list at > bacula-users-ow...@lists.sourceforge.net > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of Bacula-users digest..." > > > Today's Topics: > >1. Re: Bacula director crashes while labelling tapes with their > barcodes. (Gary R. Schmidt) >2. Re: Can't see director start up errors with systemd (Tom Plancon) >3. Re: Baculum - Grouping error: 7 ERROR: column > "media.volumename" ... (Marcin Haba) >4. Bacula 7.4, 7, CentOS 7, and systemd - a cautionary tale > (Tom Plancon) >5. Re: Bacula 7.4, 7, CentOS 7, and systemd - a cautionary tale > (Alan Brown) >6. Re: Bacula 7.4, 7, CentOS 7, and systemd - a cautionary tale > (Dimitri Maziuk) >7. Re: Bacula 7.4, 7, CentOS 7, and systemd - a cautionary tale > (Dimitri Maziuk) > > > -- > > Message: 1 > Date: Tue, 15 May 2018 23:17:55 +1000 > From: "Gary R. Schmidt" > To: Bacula-users@lists.sourceforge.net > Subject: Re: [Bacula-users] Bacula director crashes while labelling > tapes with their barcodes. > Message-ID: > <21b122bc-707e-486a-65b2-d37e5d325...@mcleod-schmidt.id.au> > Content-Type: text/plain; charset=utf-8; format=flowed > > On 15/05/2018 22:01, Charles Nadeau wrote: > > Hello! > > > > I just got a used Dell TL2000 tape library to use with Bacula (9.0.4 for > > the director on Ubuntu 16.04, 9.0.6 for the storage director on Ubuntu > > 18.04). > > > > I tested it with btape and mtx-changer and it passes all tests (strongly > > inspired by Dan Langille's > > https://dan.langille.org/2016/02/04/dell-tl4000-tape-library > -running-btape-and-configuring-baculas-mtx-changer/). > > Once defined/integrated in Bacula, I can't label the tapes, > > bacula-director crashes. > > > > Here is what the session is at bconsole: > > > [SNIP] > > > > Could anybody tell me where the problem could be? Could it be about the > > versions mismatch? I saw on the list that Dan Langille wrote > > (https://sourceforge.net/p/bacula/mailman/message/36187800/): > > "bacula-dir = bacula-sd >= bacula-fd" How close should the versions of > > -dir and -sd be? In my case they are 0.0.2 apart. > > It's =. > > Not ~, or ~=, or "just a smidge like". > > Dir and SD have to be the same version. > > I repeat, DIR AND SD HAVE TO BE THE SAME VERSION. > > Got it? > > That's what "=" means. (Except when it mean "assignment", which makes > no sense in this context.) > > Cheers, > GaryB-) > Gary, Kern, I updated the version of my director; the versions are now the same (9.0.6). The problem persisted but upon testing with another pool, it worked. So I modified the definition of my scratch pool and it is working. Thanks! Charles -- 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] Bacula 7.4, 7, CentOS 7, and systemd - a cautionary tale
Title: myEMAILsignature You probably have two bacula-dir.conf files on your system. The best thing is to *always* use the -c option and specify the full path to the conf file. That way, you can be sure which one you are getting. Kern On 05/15/2018 11:09 PM, Tom Plancon wrote: Hi folks, Just spent several frustrating hours trying to get some special backup configs into my bacula-dir.conf file. I'd shut down the Director, "sytemctl stop bacula-dir", edit the file, then start the Director, "systemctl start bacula-dir" and nothing. Did a "bacula-dir -t" and found some syntax errors, fixed those and then "systemctl start bacula-dir" and again - nothing. Tried "bacula-dir -t", no errors reported! Edited the conf file and commented out all my changes, then "systemctl start bacula-dir" and it worked. But I did not have the config I wanted. So piece by piece I un-commented the lines I wanted, did a "bacula-dir -t", no errors reported. Tried to start, "systemctl start bacula-dir", nothing. Went back and forth this way for a long time finally commenting out again back to original file, then "bacula-dir -t", no errors reported. Tried to start, "systemctl start bacula-dir", nothing! Then I rebooted the whole server - when it came up the Director was running!!! Stopped the Director, tried adding back in some of the config lines I wanted, did a "bacula-dir -t", no errors reported. Tried to start, "systemctl start bacula-dir", nothing! Again I rebooted - Director was running with my special config!!! Not sure what was going on, but bottom line - don't trust systemd! -- Thomas Plancon CAD/IT MANAGER E: tplan...@bkaarchs.com W: www.bkaarchitects.com -- 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 -- 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] Bacula director crashes while labelling tapes with their barcodes.
The first and most obvious problem is that your Director and Storage daemons must both be *exactly* the same version. Best regards, Kern On 05/15/2018 02:01 PM, Charles Nadeau wrote: Hello! I just got a used Dell TL2000 tape library to use with Bacula (9.0.4 for the director on Ubuntu 16.04, 9.0.6 for the storage director on Ubuntu 18.04). I tested it with btape and mtx-changer and it passes all tests (strongly inspired by Dan Langille's https://dan.langille.org/2016/02/04/dell-tl4000-tape-library-running-btape-and-configuring-baculas-mtx-changer/). Once defined/integrated in Bacula, I can't label the tapes, bacula-director crashes. Here is what the session is at bconsole: charles@bigzilla:/mnt/data/toburn/archive$ bconsole Connecting to Director 192.168.0.53:9101 1000 OK: 103 bigzilla-dir Version: 9.0.4 (06 September 2017) Enter a period to cancel a command. *label barcodes Automatically selected Catalog: MyCatalog Using Catalog "MyCatalog" The defined Storage resources are: 1: File3 2: TL2000 Select Storage resource (1-2): 2 Connecting to Storage daemon TL2000 at 192.168.0.17:9103 ... Connecting to Storage daemon TL2000 at 192.168.0.17:9103 ... 3306 Issuing autochanger "slots" command. Device "Autochanger" has 24 slots. Connecting to Storage daemon TL2000 at 192.168.0.17:9103 ... 3301 Issuing autochanger "loaded? drive 0" command. 3302 Autochanger "loaded? drive 0", result: nothing loaded. 3306 Issuing autochanger "list" command. The following Volumes will be labeled: Slot Volume == 1 000151L3 2 000133L3 3 000128L3 4 000126L3 5 000122L3 6 000125L3 7 000124L3 8 000137L3 9 000129L3 10 000134L3 11 000131L3 12 000140L3 14 000153L3 15 000152L3 16 000132L3 17 000121L3 18 000127L3 19 000130L3 Do you want to label these Volumes? (yes|no): yes Defined Pools: 1: Default 2: Default3 3: DefaultTape 4: Differential-File3 5: Differential-Tape 6: File 7: Full-File3 8: Full-Tape 9: Incremental-File3 10: Incremental-Tape 11: Photo-File 12: Scratch Select the Pool (1-12): 12 Here are some details of my configuration: charles@superbackup:/etc/bacula$ sudo lsscsi -g [sudo] password for charles: [3:0:0:0] disk ATA WDC WD20EARS-00M AB51 /dev/sda /dev/sg0 [7:0:0:0] cd/dvd HL-DT-ST DVDRAM GSA-H62L DL00 /dev/sr0 /dev/sg1 [8:0:0:0] disk ATA WDC WD20EARS-00M AB51 /dev/sdb /dev/sg2 [9:0:0:0] disk ATA WDC WD20EARX-00P AB51 /dev/sdc /dev/sg3 [10:0:0:0] disk ATA WDC WD20EARX-008 AB51 /dev/sdd /dev/sg4 [14:0:0:0] tape IBM ULT3580-TD3 73P5 /dev/st0 /dev/sg7 [14:0:0:1] mediumx IBM 3573-TL 8.40 /dev/sch0 /dev/sg8 [15:0:0:0] disk ATA WDC WD20EFRX-68E 0A82 /dev/sde /dev/sg5 [16:0:0:0] disk ATA WDC WD20EARS-00M AB51 /dev/sdf /dev/sg6 charles@superbackup:~$ sudo tapeinfo -f /dev/sg7 Product Type: Tape Drive Vendor ID: 'IBM ' Product ID: 'ULT3580-TD3 ' Revision: '73P5' Attached Changer API: No SerialNumber: '1210306523' MinBlock: 1 MaxBlock: 16777215 SCSI ID: 0 SCSI LUN: 0 Ready: no Here is the relevant part of my bacula-sd.conf: Autochanger { Name = Autochanger Device = Drive-1 Changer Command = "/etc/bacula/scripts/mtx-changer %c %o %S %a %d" Changer Device = /dev/sg8 } Device { Name = Drive-1 Media Type = LTO-3 Device Type = Tape Archive Device = /dev/nst0 AutomaticMount = yes # when device
Re: [Bacula-users] Baculum - Grouping error: 7 ERROR: column "media.volumename" ...
Hi Marcin ! Thanks a bunch, works a charm A quick note, I’m currently in German, on timezone Europe/Berlin. If i do not set a timezone definition in php.ini, the java script for choosing files does not work, and logs a error to console warning about having to set a timezone, and not relying on default. And a big thanks again for helping me out, very very much appreciated. All the best Ras > On 15 May 2018, at 21:46, Marcin Habawrote: > > Hello Rasmus, > > Thanks for reporting this problem. > > It is a bug that will be fixed in the next Baculum version. > > In attachment I added patch that fixes it. > > Best regards. > Marcin Haba (gani) > > On 14 May 2018 at 15:07, Rasmus Linden wrote: >> Hey All! >> Im a long time bacula user, and finally got myself updated to v9.0.7, and i >> have run into a issue with baculum i just cannot figure out how to solve. >> I have everything working, except restoring using baculm. -bat and bconsole >> works with no issues. >> >> When i have chosen files to restore, and click next, i get a sql error : >> >> Baculum problem >> Error 100 - Problem with connection to remote host. cURL error 0: . >> >> SQLSTATE[42803]: Grouping error: 7 ERROR: column "media.volumename" must >> appear in the GROUP BY clause or be used in an aggregate function LINE 2: >> SELECT VolumeName, InChanger, MIN(FirstIndex) as first_in... ^ >> >> >> 0083: $connection = VolumeRecord::finder()->getDbConnection(); >> 0084: $connection->setActive(true); >> 0085: $sql = sprintf('SELECT first_index, last_index, VolumeName AS >> volname, InChanger AS inchanger FROM ( >> 0086: SELECT VolumeName, InChanger, MIN(FirstIndex) as first_index, >> MAX(LastIndex) as last_index >> 0087: FROM JobMedia JOIN Media ON (JobMedia.MediaId = >> Media.MediaId) >> 0088: WHERE JobId = %d GROUP BY (VolumeName, InChanger) >> 0089: ) AS gv, File >> 0090: WHERE FileIndex >= first_index >> 0091: AND FileIndex <= last_index >> 0092: AND File.FileId = %d', $jobid, $fileid); >> 0093: $pdo = $connection->getPdoInstance(); >> 0094: $result = $pdo->query($sql); >> 0095: $ret = $result->fetchAll(); >> 0096: $pdo = null; >> 0097: $volumes = array(); >> 0098: if (is_array($ret)) { >> 0099: for ($i = 0; $i < count($ret); $i ) { >> 0100: $volumes[] = array( >> 0101: 'first_index' => $ret[$i]['first_index'], >> 0102: 'last_index' => $ret[$i]['last_index'], >> 0103: 'volume' => $ret[$i]['volname'], >> 0104: 'inchanger' => $ret[$i]['inchanger'] >> 0105: ); >> 0106: } >> >> >> I started out with a quite large MySql database, but for troubleshooting, i >> am running a clean posgress database. >> Os is CentOS Linux release 7.5.1804 (Core) >> >> Anybody got any good ideas ?? >> >> All the best >> >> Ras >> >> >> >> -- >> 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 >> > > > > -- > "Greater love hath no man than this, that a man lay down his life for > his friends." Jesus Christ > > "Większej miłości nikt nie ma nad tę, jak gdy kto życie swoje kładzie > za przyjaciół swoich." Jezus Chrystus > -- 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] Can't see director start up errors with systemd
Title: myEMAILsignature Yes, I find systemd rather non-satisfactory. One thing is if there is no error printed, it usually means everything went well. A "service bacula-dir status" should tell you if it is running or not. Otherwise service bacula-dir start output gives you two commands to use to get more detailed information. The one I use most often is journalctl -xe Best regards, Kern On 05/14/2018 11:18 PM, Tom Plancon wrote: Hello, I'm changing some configurations in my bacula-dir.conf on a CentOS 7 server. Unfortunately it uses the new-fangled systemd to stop and start the director. I don't get any reports as to whether it starts or not after "systemctl start bacula-dir". In the old days, if the director failed to start because of a configuration error, I would get a fairly comprehensible explanation why, down to the line number! I don see anything in /var/log/messages. Any idea where to look for those good old explanatory errors to see why my director refuses to start? Thanks much! -- Thomas Plancon CAD/IT MANAGER E: tplan...@bkaarchs.com W: www.bkaarchitects.com -- 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 -- 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