You need to use the viewuser / viewuser1 account for remote access to the mcdb views. Accessing the mcdb from remote systems using the admin account is not supported.
It sounds like your host is trying to connect to the internal "postgres" database instead of the "mcdb" database. The postgres database stores internal PostgreSQL information and should not be accessible from remote hosts. Please be sure that your remote client is configured to connect to the mcdb database.
I guess I should've seen this question coming. At the moment we don't support changing the viewuser password. There's currently an internal discussion ongoing about this.
The change-passwords script allows the passwords for the following built-in accounts to be changed:
OS accounts: root, admin, dpn
DPN accounts: root, MCUser
The passwords for other built-in DPN accounts such as backuponly. restoreonly, etc. can be changed through the GUI.
In addition, Avamar uses SSH keys to authenticate between nodes (primarily from the utility node to the storage nodes). It is strongly recommended to regenerate the dpnid key and the admin key using the change-passwords script.
You can find instructions and best practices for Avamar security in the security manual and the operational best practices guide.
ionthegeek
2 Intern
•
2K Posts
0
October 9th, 2013 13:00
Sorry, momentary loss of sanity.
You need to use the viewuser / viewuser1 account for remote access to the mcdb views. Accessing the mcdb from remote systems using the admin account is not supported.
ionthegeek
2 Intern
•
2K Posts
0
October 9th, 2013 12:00
It sounds like your host is trying to connect to the internal "postgres" database instead of the "mcdb" database. The postgres database stores internal PostgreSQL information and should not be accessible from remote hosts. Please be sure that your remote client is configured to connect to the mcdb database.
snowmizer1
1 Rookie
•
94 Posts
0
October 9th, 2013 13:00
In the database configuration I specified port 5555 user admin database mcdb. So I'm not sure why it's trying to connect to the postgres database.
snowmizer1
1 Rookie
•
94 Posts
1
October 9th, 2013 14:00
You're a genius. Once I used this user I was able to connect successfully.
snowmizer1
1 Rookie
•
94 Posts
0
October 9th, 2013 17:00
So can you change the viewuser password?
o17Uu33DCF12520
4 Operator
•
1.1K Posts
0
October 9th, 2013 20:00
as far as i know it can't be changed.
ionthegeek
2 Intern
•
2K Posts
0
October 10th, 2013 08:00
I guess I should've seen this question coming. At the moment we don't support changing the viewuser password. There's currently an internal discussion ongoing about this.
snowmizer1
1 Rookie
•
94 Posts
0
October 10th, 2013 12:00
Ok so what passwords can be changed on Avamar? I know there's MCUser, root, admin, dpn.
Thanks.
ionthegeek
2 Intern
•
2K Posts
0
October 10th, 2013 12:00
The change-passwords script allows the passwords for the following built-in accounts to be changed:
OS accounts: root, admin, dpn
DPN accounts: root, MCUser
The passwords for other built-in DPN accounts such as backuponly. restoreonly, etc. can be changed through the GUI.
In addition, Avamar uses SSH keys to authenticate between nodes (primarily from the utility node to the storage nodes). It is strongly recommended to regenerate the dpnid key and the admin key using the change-passwords script.
You can find instructions and best practices for Avamar security in the security manual and the operational best practices guide.