View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0001010 | bareos-core | installer / packages | public | 2018-09-24 13:42 | 2023-09-05 16:06 |
| Reporter | Assigned To | bruno-at-bareos | |||
| Priority | normal | Severity | feature | Reproducibility | always |
| Status | closed | Resolution | fixed | ||
| Platform | Linux | OS | Ubuntu | OS Version | 16.04 |
| Product Version | 17.2.4 | ||||
| Summary | 0001010: Bareos database scripts should use db_address parameter in catalog config | ||||
| Description | If we configure the catalog resource and set "DB Address" and/or "DB Port" it is not used by the database scripts. For flawless configuration the scripts should be capable of installing, maintaining and deleting remote databases. | ||||
| Steps To Reproduce | # Check the configuration bareos@ubuntu1604-daemons:~# /usr/sbin/bareos-dbcheck -B catalog=MyCatalog db_name=bareos db_driver=postgresql db_user=bareos db_password=postgrespassword db_address=databasehost.example.com db_port=5432 db_socket= db_type=PostgreSQL working_dir=/var/lib/bareos # Execute one of the scripts bareos@ubuntu1604-daemons:~# su postgres -c /usr/lib/bareos/scripts/drop_bareos_tables Dropping postgresql tables psql: FATAL: database "bareos" does not exist Dropping of Bareos PostgreSQL tables failed. # Execute the script and pass the not-recognized parameter like the hostname bareos@ubuntu1604-daemons:~# su postgres -c "/usr/lib/bareos/scripts/drop_bareos_tables --host databasehost.example.com" Dropping postgresql tables Password: DROP TABLE [...] DROP TABLE Dropping of Bareos PostgreSQL tables succeeded. | ||||
| Tags | No tags attached. | ||||
 |
the scripts usually respect PG_XXX ENV variables. beware that your catalog config need to be accessible to "postgres" user when using su postgres -c |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2018-09-24 13:42 |
|
New Issue | |
| 2018-09-24 13:42 |
|
Status | new => assigned |
| 2018-09-24 13:42 |
|
Assigned To | => aron_s |
| 2018-09-24 13:43 |
|
Status | assigned => confirmed |
| 2018-10-04 14:31 |
|
Assigned To | aron_s => |
| 2018-10-04 14:31 |
|
Steps to Reproduce Updated | |
| 2023-09-05 16:06 | bruno-at-bareos | Assigned To | => bruno-at-bareos |
| 2023-09-05 16:06 | bruno-at-bareos | Status | confirmed => closed |
| 2023-09-05 16:06 | bruno-at-bareos | Resolution | open => fixed |
| 2023-09-05 16:06 | bruno-at-bareos | Note Added: 0005379 |
