Re: [Bacula-users] Baculum Workspace problems
Hello Shawn, You can try to enable debug in Baculum by clicking on the bottom checkbox with label 'Enable debug'. Then you can click few times on these parts that don't show any data. In the end you can look in the /usr/share/baculum/htdocs/protected/Web/Logs/ If it doesn't show any error then you can enable API debug. The API debug you can enable in file: /usr/share/baculum/htdocs/protected/API/Config/api.conf by switching in [api] section option debug to "1". API logs are in the following path: /usr/share/baculum/htdocs/protected/API/Logs/ Please let know here if there is something wrong in these debug files. Best regards. Marcin Haba (gani) On 8 February 2018 at 23:46, Shawn Rappaport wrote: > System details: > CentOS 7.3 > > Bacula 9.06 > > Baculum 9.05 > > MySQL (MariaDB) 5.5.56 > > > > I just finished configuring Baculum and have access to the web interface > now. However, when I try to click on any of the options on the Workspace > (Storage Daemons, Clients, Volumes, Pools, etc..), nothing happens. I > checked /var/log/httpd/baculum-web-error.log and I see these two errors: > > > > [Thu Feb 08 13:10:09.679435 2018] [access_compat:error] [pid 4399] [client > 172.31.48.196:57161] AH01797: client denied by server configuration: > /usr/share/baculum/htdocs/index.php, referer: > http://xbacdirector01-lv:9095/web/ > > [Thu Feb 08 13:10:09.679773 2018] [access_compat:error] [pid 4399] [client > 172.31.48.196:57161] AH01797: client denied by server configuration: > /usr/share/baculum/htdocs/web, referer: http://xbacdirector01-lv:9095/web/ > > > > There is no /usr/share/baculum/htdocs/web on my system. > > > > I tried adding the following to /etc/httpd/conf/httpd.conf and restarting > httpd: > > > > AllowOverride All > > Require all granted > > > > > > That didn’t help though. Does anyone have any ideas on how to fix this? > > > > --Shawn > > > -- > 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] trying to build a static bacula-fd
Am 06.02.2018 um 19:46 schrieb Mike Eggleston: > Thanks for the suggestion. I’m now using: > > ./configure --enable-client-only --enable-static-client-only > --enable-static-fd --disable-libtool --without-ssl > > with no success… L Still the same error? Still saying > checking for MySQL support... yes ? What if you turn off MySQL support explicitly with --without-mysql? (The theory behind that suggestion being that just as two databases specified for a director is one too many, so is one database specified for a file daemon.) -- Tilman Schmidt E-Mail: til...@imap.cc Bonn, Germany Diese Nachricht besteht zu 100% aus wiederverwerteten Bits. Ungeöffnet mindestens haltbar bis: (siehe Rückseite) -- 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 Workspace problems
System details: CentOS 7.3 Bacula 9.06 Baculum 9.05 MySQL (MariaDB) 5.5.56 I just finished configuring Baculum and have access to the web interface now. However, when I try to click on any of the options on the Workspace (Storage Daemons, Clients, Volumes, Pools, etc..), nothing happens. I checked /var/log/httpd/baculum-web-error.log and I see these two errors: [Thu Feb 08 13:10:09.679435 2018] [access_compat:error] [pid 4399] [client 172.31.48.196:57161] AH01797: client denied by server configuration: /usr/share/baculum/htdocs/index.php, referer: http://xbacdirector01-lv:9095/web/ [Thu Feb 08 13:10:09.679773 2018] [access_compat:error] [pid 4399] [client 172.31.48.196:57161] AH01797: client denied by server configuration: /usr/share/baculum/htdocs/web, referer: http://xbacdirector01-lv:9095/web/ There is no /usr/share/baculum/htdocs/web on my system. I tried adding the following to /etc/httpd/conf/httpd.conf and restarting httpd: AllowOverride All Require all granted That didn’t help though. Does anyone have any ideas on how to fix this? --Shawn -- 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 error connecting to MySQL DB
Well, I must be blind. A few minutes after posting my message, I found this section in bacula-dir.conf: # Generic catalog service Catalog { Name = MyCatalog dbname = "bacula"; dbuser = "bacula"; dbpassword = "" } I added my password and now things are working again. Sorry for the false alarm. --Shawn On 2/8/18, 1:29 PM, "Shawn Rappaport" wrote: Hi Marcin, Thanks for the info! I didn’t realize I was using an old version of baculum. I removed version 7 and installed version 9. I was then able to connect to the DB on the Catalog API tab. Now I’m running into a problem on the Console API tab. I have the Bconsole binary file path set to /sbin/bconsole and the Bconsole admin config file path set to /etc/bacula/bconsole.conf. I also have Use sudo checked. When I clicked Test, I got this: Problem with connection to bconsole. Output=>Connecting to Director xbacdirector01-lv:9101, Exitcode=>1 Sure enough, when I tried to run bconsole from the Director server itself, the command times out: 10:53:05][root@xbacdirector01-lv:/etc/bacula:573]$ /sbin/bconsole Connecting to Director xbacdirector01-lv:9101 [10:53:37][root@xbacdirector01-lv:/etc/bacula:574]$ I checked with ps and bacula-dir is not running. Next, I ran this to debug the problem with bacula-dir: /sbin/bacula-dir -d100 -c /etc/bacula/bacula-dir.conf Here is the relevant part of the output: bacula-dir: mysql.c:263-0 mysql_real_connect done bacula-dir: mysql.c:265-0 db_user=bacula db_name=bacula db_password= bacula-dir: mysql.c:275-0 Error 1045 (28000): Access denied for user 'bacula'@'localhost' (using password: NO) bacula-dir: dird.c:1165-0 Could not open Catalog "MyCatalog", database "bacula". bacula-dir: dird.c:1170-0 mysql.c:271 Unable to connect to MySQL server. Database=bacula User=bacula MySQL connect failed either server not running or your authorization is incorrect. bacula-dir: mysql.c:325-0 closedb ref=0 connected=0 db=0 08-Feb 11:36 bacula-dir ERROR TERMINATION Please correct configuration file: /etc/bacula/bacula-dir.conf It looks like the problem is that the Director is trying to connect to the MySQL DB without a password. Does anyone know how to fix this so it uses the password I have set for bacula in the DB? I don’t see an option in bacula-dir.conf. Since the Director last worked, I haven’t changed anything with my configuration other than removing Baculum 7 and installing Baculum 9. So, I’m not sure what I did to screw things up. Thanks! --Shawn On 2/7/18, 10:56 PM, "Marcin Haba" wrote: Hello Shawn, It looks that you use an old Baculum version (7.x). I would suggest to remove the 7.x and install 9.x (there is no direct update way between versions 7 and 9). Here you can find how to install version Baculum 9.x: https://urldefense.proofpoint.com/v2/url?u=http-3A__www.bacula.org_9.0.x-2Dmanuals_en_console_Baculum-5FAPI-5FWeb-5FGUI-5FTools.html&d=DwIFaQ&c=sy2pFYeXOTBQJUPqadkFIXq5lzPIgQxhI8DCCAdSjYc&r=N3_BTL1Tt2ryeleRqn2wc-R4w3v0TnI7dlgnwdQ7zE8&m=ZcS2AM_EDHBz-z5_zSpTo9mbsyyT-_wUTeVj75__FkI&s=Y0_N8HdGAovGbo9GNuMHAIEJfjKZqyueKogDlYMVqxI&e= If you want to stay in version 7 then you can try the following: 1) To check connection try to connect to database by below mysql command on host with Baculum: mysql -u bacula -h xbacdirector01-lv -P 3306 bacula -p 2) check if you have installed "php-mysql" package 3) To fix your timezone setting (not related to the mysql) you can find in /etc/php.ini file line: ;date.timezone = and change it to data.timezone = Your/Timezone Supported by PHP timezone list is here: https://urldefense.proofpoint.com/v2/url?u=http-3A__php.net_manual_en_timezones.php&d=DwIFaQ&c=sy2pFYeXOTBQJUPqadkFIXq5lzPIgQxhI8DCCAdSjYc&r=N3_BTL1Tt2ryeleRqn2wc-R4w3v0TnI7dlgnwdQ7zE8&m=ZcS2AM_EDHBz-z5_zSpTo9mbsyyT-_wUTeVj75__FkI&s=HttPEm6zAYRWfknioRpeXQIEY23GlxAJLaL81Sv7U5g&e= At the end you need to restart the web server. Good luck. Best regards. Marcin Haba (gani) On 7 February 2018 at 23:47, Shawn Rappaport wrote: > I’m new to Bacula. I’ve been playing with the latest version for the past > couple of days on a CentOS 7.3 server with a MySQL DB. I’m now tryin
Re: [Bacula-users] Baculum error connecting to MySQL DB
Hi Marcin, Thanks for the info! I didn’t realize I was using an old version of baculum. I removed version 7 and installed version 9. I was then able to connect to the DB on the Catalog API tab. Now I’m running into a problem on the Console API tab. I have the Bconsole binary file path set to /sbin/bconsole and the Bconsole admin config file path set to /etc/bacula/bconsole.conf. I also have Use sudo checked. When I clicked Test, I got this: Problem with connection to bconsole. Output=>Connecting to Director xbacdirector01-lv:9101, Exitcode=>1 Sure enough, when I tried to run bconsole from the Director server itself, the command times out: 10:53:05][root@xbacdirector01-lv:/etc/bacula:573]$ /sbin/bconsole Connecting to Director xbacdirector01-lv:9101 [10:53:37][root@xbacdirector01-lv:/etc/bacula:574]$ I checked with ps and bacula-dir is not running. Next, I ran this to debug the problem with bacula-dir: /sbin/bacula-dir -d100 -c /etc/bacula/bacula-dir.conf Here is the relevant part of the output: bacula-dir: mysql.c:263-0 mysql_real_connect done bacula-dir: mysql.c:265-0 db_user=bacula db_name=bacula db_password= bacula-dir: mysql.c:275-0 Error 1045 (28000): Access denied for user 'bacula'@'localhost' (using password: NO) bacula-dir: dird.c:1165-0 Could not open Catalog "MyCatalog", database "bacula". bacula-dir: dird.c:1170-0 mysql.c:271 Unable to connect to MySQL server. Database=bacula User=bacula MySQL connect failed either server not running or your authorization is incorrect. bacula-dir: mysql.c:325-0 closedb ref=0 connected=0 db=0 08-Feb 11:36 bacula-dir ERROR TERMINATION Please correct configuration file: /etc/bacula/bacula-dir.conf It looks like the problem is that the Director is trying to connect to the MySQL DB without a password. Does anyone know how to fix this so it uses the password I have set for bacula in the DB? I don’t see an option in bacula-dir.conf. Since the Director last worked, I haven’t changed anything with my configuration other than removing Baculum 7 and installing Baculum 9. So, I’m not sure what I did to screw things up. Thanks! --Shawn On 2/7/18, 10:56 PM, "Marcin Haba" wrote: Hello Shawn, It looks that you use an old Baculum version (7.x). I would suggest to remove the 7.x and install 9.x (there is no direct update way between versions 7 and 9). Here you can find how to install version Baculum 9.x: https://urldefense.proofpoint.com/v2/url?u=http-3A__www.bacula.org_9.0.x-2Dmanuals_en_console_Baculum-5FAPI-5FWeb-5FGUI-5FTools.html&d=DwIFaQ&c=sy2pFYeXOTBQJUPqadkFIXq5lzPIgQxhI8DCCAdSjYc&r=N3_BTL1Tt2ryeleRqn2wc-R4w3v0TnI7dlgnwdQ7zE8&m=ZcS2AM_EDHBz-z5_zSpTo9mbsyyT-_wUTeVj75__FkI&s=Y0_N8HdGAovGbo9GNuMHAIEJfjKZqyueKogDlYMVqxI&e= If you want to stay in version 7 then you can try the following: 1) To check connection try to connect to database by below mysql command on host with Baculum: mysql -u bacula -h xbacdirector01-lv -P 3306 bacula -p 2) check if you have installed "php-mysql" package 3) To fix your timezone setting (not related to the mysql) you can find in /etc/php.ini file line: ;date.timezone = and change it to data.timezone = Your/Timezone Supported by PHP timezone list is here: https://urldefense.proofpoint.com/v2/url?u=http-3A__php.net_manual_en_timezones.php&d=DwIFaQ&c=sy2pFYeXOTBQJUPqadkFIXq5lzPIgQxhI8DCCAdSjYc&r=N3_BTL1Tt2ryeleRqn2wc-R4w3v0TnI7dlgnwdQ7zE8&m=ZcS2AM_EDHBz-z5_zSpTo9mbsyyT-_wUTeVj75__FkI&s=HttPEm6zAYRWfknioRpeXQIEY23GlxAJLaL81Sv7U5g&e= At the end you need to restart the web server. Good luck. Best regards. Marcin Haba (gani) On 7 February 2018 at 23:47, Shawn Rappaport wrote: > I’m new to Bacula. I’ve been playing with the latest version for the past > couple of days on a CentOS 7.3 server with a MySQL DB. I’m now trying to set > up Baculum. I’m able to connect to the web interface. However, when I fill > in all of the DB information on the Database tab and click Test, I get > “Connection error”. I checked /var/log/httpd/baculum-error.log and see the > following: > > > > [Wed Feb 07 12:18:37.550545 2018] [:error] [pid 10647] [client > 172.31.48.196:53501] PHP Notice: date_default_timezone_set(): Timezone ID > 'PST' is invalid in /usr/share/baculum/htdocs/protected/Init.php on line 31, > referer: https://urldefense.proofpoint.com/v2/url?u=http-3A__xbacdirector01-2Dlv-3A9095_wizard_&d=DwIFaQ&c=sy2pFYeXOTBQJUPqadkFIXq5lzPIgQxhI8DCCAdSjYc&r=N3_BTL1Tt2ryeleRqn2wc-R4w3v0TnI7dlgnwdQ7zE8&m=ZcS2AM_EDHBz-z5_zSpTo9mbsyyT-_wUTeVj75__FkI&s=1C3vp4k2j0zaWcbCujUmZh6wrvLbP0DmRnE_5y5sS3c&e= > > > > The /etc/baculum/Data-apache/baculum.dbg file shows: > > > > Feb 07 20:18:37 [Info] [Execute] DBParams=Array > > ( > > [type] => mysql > > [name] => bacula
[Bacula-users] backup usage breakdown
Hello, I'm using Bacula 5.2.6 with about 15 clients and recently experienced a tape filling up quite unexpectedly. So I'm looking for a way to make some kind of space usage listing. Something like a list of top-level directory sizes for each client on any given tape and date. The idea is to be able to hunt for top culprits quickly. I can get some info from bconsole with e.g: list jobtotals list jobname= Can I see more details / breakdowns with Bacula commands? My guess is certain SQL queries can provide additional info so maybe somebody has some nice templates and willing to share? I'm using MySQL 5.5.31 as a backend. Or maybe some third party tools? Prefer to ask rather than spending days re-inventing the wheel. Thanks Adam -- 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] JobBytes
Thank you Martin. We are using a pretty old Bacula 5.2.6. This version already appears to support compressions on clients. But it's currently not defined for any. I'm assuming hardware compression is enabled on the LTO-4 tape drive. I've checked: - Device and Storage directives, - "status storage" from bconsole, - mtab, - any place mentioning /dev/nts0 but couldn't find any compression related options. Without it we would only be able to write 800GB to each tape and we write close to 1.6TB, right? Can we switch between these two modes? Also - does it make sense to use more than one compression (i.e. software on clients and hardware on tape drive) concurrently? With the current settings does it make sense to track all big text files on clients and compress them before a backup run? Cheers Adam On 07/02/18 19:43, Martin Simmons wrote: JobBytes is the number of bytes sent from the FD (client) to the SD. If you are using Bacula's software compression (the compression option in the Fileset), then that will be the size after compression. Bacula's software compression is always done in the FD. You can control concurrency of backups using the various "Maximum Concurrent Jobs" options. __Martin On Wed, 7 Feb 2018 12:02:56 +, Adam Weremczuk said: Hi all, Last night a tape filled so I'm spending most of today investigating the cause and ensuring the next run completes fine. When executing "list jobname=" from the console I'm presented with 2 columns: JobFiles and JobBytes. Is JobBytes expected to show the volume read from the client or written to the tape? In the latter the count is after compression, right? On that note: Is compression always performed on the server or can it be done on clients? It could make sense to iterate over all clients first and instruct them to start compressing. Then they start reporting as ready to the director and data transfers begin. Please advise. Regards Adam -- 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