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" <[email protected]> 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" <[email protected]> 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
<[email protected]> 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
> [email protected]
>
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!
https://urldefense.proofpoint.com/v2/url?u=http-3A__sdm.link_slashdot&d=DwIGaQ&c=sy2pFYeXOTBQJUPqadkFIXq5lzPIgQxhI8DCCAdSjYc&r=N3_BTL1Tt2ryeleRqn2wc-R4w3v0TnI7dlgnwdQ7zE8&m=5rQw5U8AAGF8DuPtPBL7a4toPleX6bpPBX_NR2uWzYA&s=x5pJhx7GvFPZDqcoq_zPi6lEpURUgSYRerdBIsnWFsg&e=
_______________________________________________
Bacula-users mailing list
[email protected]
https://urldefense.proofpoint.com/v2/url?u=https-3A__lists.sourceforge.net_lists_listinfo_bacula-2Dusers&d=DwIGaQ&c=sy2pFYeXOTBQJUPqadkFIXq5lzPIgQxhI8DCCAdSjYc&r=N3_BTL1Tt2ryeleRqn2wc-R4w3v0TnI7dlgnwdQ7zE8&m=5rQw5U8AAGF8DuPtPBL7a4toPleX6bpPBX_NR2uWzYA&s=aVi8ynvmfI7xK4WoKE45k4fEcbMyerT8IuU-uL40G8E&e=
------------------------------------------------------------------------------
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/bacula-users