Bug 962657
Summary: | The RESULT content is not consistent when adding db cartridges which makes website can not display username and password when adding mongodb. | ||
---|---|---|---|
Product: | OpenShift Online | Reporter: | Yujie Zhang <yujzhang> |
Component: | Containers | Assignee: | Dan Mace <dmace> |
Status: | CLOSED CURRENTRELEASE | QA Contact: | libra bugs <libra-bugs> |
Severity: | medium | Docs Contact: | |
Priority: | medium | ||
Version: | 2.x | CC: | dmace, xtian |
Target Milestone: | --- | ||
Target Release: | --- | ||
Hardware: | Unspecified | ||
OS: | Unspecified | ||
Whiteboard: | |||
Fixed In Version: | Doc Type: | Bug Fix | |
Doc Text: | Story Points: | --- | |
Clone Of: | Environment: | ||
Last Closed: | 2013-06-11 04:03:26 UTC | Type: | Bug |
Regression: | --- | Mount Type: | --- |
Documentation: | --- | CRM: | |
Verified Versions: | Category: | --- | |
oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |
Cloudforms Team: | --- | Target Upstream Version: | |
Embargoed: |
Description
Yujie Zhang
2013-05-14 07:41:53 UTC
Are you saying when using the web interface you do not see the second databases credentials? Yes,there is no username and password of database after adding postgresql from website. Since the rhc commands provide the expected output, I believe this is a website issue rather than a node issue. This is the values the REST API returns to us. The client only displays what gets returned from node as "CLIENT_RESULT". In case of postgres only connection URL is returned and needs to be fixed in the cartridge. Returned from postgres cartridge CLIENT_RESULT: Connection URL: postgresql://$OPENSHIFT_POSTGRESQL_DB_HOST:$OPENSHIFT_POSTGRESQL_DB_PORT Returned from mysql cartridge CLIENT_RESULT: MySQL 5.1 database added. Please make note of these credentials: CLIENT_RESULT: Root User: [HIDDEN] CLIENT_RESULT: Root Password: [HIDDEN] CLIENT_RESULT: Database Name: app CLIENT_RESULT: Connection URL: mysql://$OPENSHIFT_MYSQL_DB_HOST:$OPENSHIFT_MYSQL_DB_PORT/ CLIENT_RESULT: You can manage your new MySQL database by also embedding phpmyadmin-3.4. CLIENT_RESULT: The phpmyadmin username and password will be the same as the MySQL credentials above. Fotios: The postgresql install script needs the following: client_result "" client_result "PostgreSQL ${version} database added. Please make note of these credentials:" client_result "" client_result " Root User: ${username}" client_result " Root Password: ${password}" client_result "" client_result "Connection URL: ${conn_url}" client_result "" During the course of testing this, I noticed the initial postgres db is now coming from a statically built tarball. However, the expectation is that the initial database name will follow the app name; I see no code in install to account for this, and using `psql` from a shell in the new gear errors as it expects to connect to a database name matching the app name. Please address both the credential reporting with client_result entries and also fix the database naming as part of this issue (ensuring to also report the database name in the client_result entries). Fotios: I found the database setup code I had missed before, and corrected the remaining client_result issue. Commit pushed to master at https://github.com/openshift/origin-server https://github.com/openshift/origin-server/commit/6ddaff5ce1c41d4a7f452727097ea7cae1834b26 Bug 962657: Return db info to client during postgres install Tested on devenv_3277, it can display username and password when adding postgresql and mysql, but can not display username and password of mongodb this time, could you please help to check again?Thanks! Commit pushed to master at https://github.com/openshift/origin-server https://github.com/openshift/origin-server/commit/5ab6507853f67e15098e4a22cc9c8282c34ee2cd Bug 962657: Add client result for mongodb credentials during install Commit pushed to master at https://github.com/openshift/origin-server https://github.com/openshift/origin-server/commit/d661b862158ebe46e29b1a39cfdd3dd4e01b84d4 Bug 962657 Tested on devenv_3282, the there is username and password when adding mysql,postgresql and mongo db to application, so verify this bug, thanks. |