User story #8873
closed
Allow to customize reports database name and user to ease a separate database
Added by Alexis Mousset over 7 years ago.
Updated over 7 years ago.
Category:
System integration
Description
Currently, the database name and the user name (rudder and rudder) are set in rudder-web.properties and rsyslog.d/rudder.conf. The rsyslog file is templated and the name and user are hardcoded in the source template, which makes it impossible to use different values.
This is a stopblocker when one wants to run several Rudder instance on the same database server, for example for dev and test.
A possible workaround is to edit /var/rudder/configuration-repository/techniques/system/distributePolicy/1.0/rudder-rsyslog-root.st on the root server and set the right values. This will be overwritten during each update though.
We will add two system variables: RUDDER_REPORTS_DB_NAME and RUDDER_REPORTS_DB_USER
- Tracker changed from Bug to User story
- Description updated (diff)
- Subject changed from Make the databse name and user configurable to Make the database name and user configurable
The solution is to give database name and user as technique parameters, and use them in corresponding system technique.
I'm going to use that ticket for the rudder update.
- Tracker changed from User story to Bug
- Subject changed from Make the database name and user configurable to The database name and user can not be changed
- Description updated (diff)
- Target version changed from 3.1.13 to 2.11.24
- Reproduced set to No
- Status changed from New to In progress
- Assignee set to François ARMAND
Some more thinking: we already get contextual information for that script, see:
:msg, ereregex, "R: @@[ a-zA-Z0-9_\-]+?@@[a-zA-Z0-9_\-]{1,64}?@@[a-zA-Z0-9\-]+@@[a-zA-Z0-9\-]+?@@[0-9]+?@@.*?@@.*?@@[0-9]{4}-[0-9]{2}-[0-9]{2} [0-9]{2}:[0-9]{2}:[0-9]{2}[+-][0-9]{1,2}:[0-9]{2}##[a-zA-Z0-9\-]+?@#.*" :ompgsql:${install_rsyslogd.rudder_postgres_server},rudder,rudder,${p.psql_password[2]};RudderReportsFormat
Shouldn't we pass the DB name/login in the same way ?
Or ok, perhaps we want to have something different for password, but the server URL is almost the same thing as the DB name.
- Tracker changed from Bug to User story
- Target version changed from 2.11.24 to 3.1.13
We are targeting 3.1 because 2.11 is EOL in 15 days, so if somebody want that, he just need to use a supported version.
- Description updated (diff)
- Status changed from In progress to Pending technical review
- Assignee changed from François ARMAND to Vincent MEMBRÉ
- Pull Request set to https://github.com/Normation/cf-clerk/pull/92
- Status changed from Pending technical review to Pending release
- % Done changed from 33 to 100
- Subject changed from The database name and user can not be changed to Allow to configure reports database name and user
- Subject changed from Allow to configure reports database name and user to Allow to customize reports database name and user to ease a separate database
- Category changed from System techniques to System integration
- Status changed from Pending release to Released
This bug has been fixed in Rudder 3.1.13 and 3.2.6 which were released today.
Also available in: Atom
PDF
Updated by 
Updated by 
Updated by