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" <ganius...@gmail.com> 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 <srappap...@shutterfly.com> 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 > > [login] => bacula > > [password] => ****** > > [host] => xbacdirector01-lv > > [port] => 3306 > > ) > > , Connection=false, TablesFormat=NULL > > > > I’m able to connect to the database from a remote host so that shouldn’t be > a problem. > > > > Does anyone have any ideas on what could be causing this connection to fail? > > > > Thanks! > > > > --Shawn > > > ------------------------------------------------------------------------------ > Check out the vibrant tech community on one of the world's most > engaging tech sites, Slashdot.org! https://urldefense.proofpoint.com/v2/url?u=http-3A__sdm.link_slashdot&d=DwIFaQ&c=sy2pFYeXOTBQJUPqadkFIXq5lzPIgQxhI8DCCAdSjYc&r=N3_BTL1Tt2ryeleRqn2wc-R4w3v0TnI7dlgnwdQ7zE8&m=ZcS2AM_EDHBz-z5_zSpTo9mbsyyT-_wUTeVj75__FkI&s=mE5u4OetWVlzDWuLo9QKGrHLkzlhBaOFGymXCBRCyhI&e= > _______________________________________________ > Bacula-users mailing list > Bacula-users@lists.sourceforge.net > https://urldefense.proofpoint.com/v2/url?u=https-3A__lists.sourceforge.net_lists_listinfo_bacula-2Dusers&d=DwIFaQ&c=sy2pFYeXOTBQJUPqadkFIXq5lzPIgQxhI8DCCAdSjYc&r=N3_BTL1Tt2ryeleRqn2wc-R4w3v0TnI7dlgnwdQ7zE8&m=ZcS2AM_EDHBz-z5_zSpTo9mbsyyT-_wUTeVj75__FkI&s=-XM5rz_NJsQNPt-JVpk61aZNAMr-hJDrEMoyD9kvxJc&e= > -- "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