Re: Bacula-Web won't play nice.

Hi Daniel,

You need to update the pg_hba.conf on the postgres server side.

Here's below an extract of one of my postgreSQL server pg_hba.conf

# TYPE  DATABASE        USER            ADDRESS                 METHOD
...
host    bacula          bacula          192.168.1.0/24          md5
...

You must add above line (adapt the address to fit to your environment.

then reload postgreSQL service.

You can test it from the server where you installed Bacula-Web with this
command

$ psql -h db-server.domain.com -U bacula -p 5432 -d bacula -W

If you are running RHEL 9, please have a look at
https://www.bacula-web.org/docs/install/selinux

Hope it helps.

p.s: I'll update the documentation for both MySQL/MariaDB and postgreSQL.

Best,

Davide

On Wed, Nov 27, 2024 at 9:47 PM White, Daniel E. (GSFC-764.0)[AEGIS] via
Bacula-users <[email protected]> wrote:

> Community Bacula 15.0.2 on RHEL 9 from https://www.bacula.org/packages/<access
> key>/rpms/15.0.2/el9/x86_64/
>
> Bacula-web installed with Composer
>
> I set up "authentication":
>
> ----------------------------------------------
>
> sudo -u apache php bwc setupauth
>
> It's now time to setup the application back-end database
> [Important!] Please note that all information stored in the user database
> will be destroyed
> Can we proceed ?
>   [0] yes
>   [1] no
>  > 0
> You have selected: yes
> Deleting users authentication database
> Database file removed
> Creating database schema
> Database created
> User creation
> Username: admin
> Email: <redacted>
> Password: <redacted>
> 1 user created successfuly
> You can now connect to your Bacula-Web instance using provided credentials
>
> ----------------------------------------------
>
> If I leave the database section of "config.php" commented out,
>
> // PostgreSQL bacula catalog
> // $config[0]['label'] = 'Prod Server';
> // $config[0]['host'] = 'db-server.domain.com';
> // $config[0]['login'] = 'bacula';
> // $config[0]['password'] = 'otherstrongpassword';
> // $config[0]['db_name'] = 'bacula';
> // $config[0]['db_type'] = 'pgsql';
> // $config[0]['db_port'] = '5432';
>
> ----------------------------------------------
>
> I get this: (abbreviated)
>
> 200~Bacula-Web logo Bacula-Web
>  Oops, it looks like something went wrong somehow :(
>  Configuration error
>  Configuration error: catalog id <0> is empty or does not exist
>  File: /var/www/html/bacula-web/core/Db/Database.php on line 54 in
> function App\Libs\FileConfig::get_Value
>  File: /var/www/html/bacula-web/core/Db/DatabaseFactory.php on line 36 in
> function Core\Db\Database->__construct
>  File: /var/www/html/bacula-web/application/config/container-bindings.php
> on line 68 in function Core\Db\DatabaseFactory::getDatabase
>
> ----------------------------------------------
>
> If I fill it in,
>
> ----------------------------------------------
>
> // PostgreSQL bacula catalog
> $config[0]['label'] = 'Prod Server';
> $config[0]['host'] = 'db-server.domain.com';
> $config[0]['login'] = 'bacula';
> $config[0]['password'] = '<redacted>';
> $config[0]['db_name'] = 'bacula';
> $config[0]['db_type'] = 'pgsql';
> $config[0]['db_port'] = '5432';
>
> ----------------------------------------------
>
> I get this: (abbreviated)
>
> ----------------------------------------------
>
> 200~Bacula-Web logo Bacula-Web
>  Oops, it looks like something went wrong somehow :(
>  Database error
>  SQLSTATE[08006] [7] FATAL: Ident authentication failed for user "bacula"
>  File: /var/www/html/bacula-web/core/Db/Database.php on line 81 in
> function PDO->__construct
>  File: /var/www/html/bacula-web/core/Db/DatabaseFactory.php on line 36 in
> function Core\Db\Database->__construct
>  File: /var/www/html/bacula-web/application/config/container-bindings.php
> on line 68 in function Core\Db\DatabaseFactory::getDatabase
>
> ----------------------------------------------
>
> Any clues out there for this clueless one ?
>
>
>
> _______________________________________________
> Bacula-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/bacula-users
>

_______________________________________________
Bacula-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/bacula-users