This is the error message I get (in french ). For the pg_hba.conf file I added the line "host all all 0.0.0.0 trust" and restart all avamar machine but still get the same error.
Again error connecting the database, I think there is something wrong with the VDP configuration (database protected or some restrictions like this...).
I reviewed the VDP guide and I was unable to find any mention of database access being supported. While VDP and Avamar have a lot like in common, they are two different products. I don't believe VDP permits external access to its databases. All management and monitoring of VDP should be done through vSphere.
I was searching for ways to access VDP postgre database but seems not supported although similar to Avamar this is one feature that Avamar as and VDP don't.
Thanks for your reply. My first goal was to create custom reports. As I didn't find anything on the VDP docs mentionig if this can or not be done, I tried to do it the same way as avamar.
It s sad that is can not be possible. The default report is really hard to read and it doesn't give details on backup jobs.
Thank you for your support. I will try with a test
Dandoun
8 Posts
0
February 6th, 2014 11:00
Hi,
After looking at VDP Appliance I figured out that a firewall (avfirewall based on iptables as I can see) was there and blocking my connections.
I changed the configuration to allow 5555 and 5558 ports by adding this line to the file /etc/firawall.base
$IPT -A INPUT -p tcp -m multiport --dport 5555,5558 -j ACCEPT
I restarted the service (by doing a stop/start an not restart! I dont why the restart doesn't reload the config file :s ).
Now I m able to connect to mcdb database
Thanks guys. Have a nice day.
Dandoun
8 Posts
0
February 5th, 2014 09:00
Hi,
Thanks for your quick feedback. Tried this but it didn't work. The same error message "Connectionre refused".
The postmaster process is listening as can see on the netstat -anp output:
tcp 0 0 0.0.0.0:5555 0.0.0.0:* LISTEN 8811/postmaster
tcp 0 0 0.0.0.0:5558 0.0.0.0:* LISTEN 10698/postmaster
tcp 0 0 127.0.0.1:5555 127.0.0.1:55901 ESTABLISHED 11594/postgres: adm
tcp 0 0 127.0.0.1:5555 127.0.0.1:55284 ESTABLISHED 8838/postgres: admi
tcp 0 0 127.0.0.1:5555 127.0.0.1:55287 ESTABLISHED 8841/postgres: admi
tcp 0 0 127.0.0.1:5555 127.0.0.1:55288 ESTABLISHED 8842/postgres: admi
tcp 0 0 127.0.0.1:5555 127.0.0.1:55291 ESTABLISHED 8845/postgres: admi
tcp 0 0 127.0.0.1:5555 127.0.0.1:55285 ESTABLISHED 8839/postgres: admi
tcp 0 0 127.0.0.1:5555 127.0.0.1:55289 ESTABLISHED 8843/postgres: admi
tcp 0 0 127.0.0.1:5555 127.0.0.1:55609 ESTABLISHED 9870/postgres: admi
tcp 0 0 127.0.0.1:5555 127.0.0.1:55286 ESTABLISHED 8840/postgres: admi
tcp 0 0 127.0.0.1:5555 127.0.0.1:55290 ESTABLISHED 8844/postgres: admi
tcp 0 0 127.0.0.1:5558 127.0.0.1:38771 ESTABLISHED 10852/postgres: adm
tcp 0 0 127.0.0.1:5558 127.0.0.1:38764 ESTABLISHED 10851/postgres: adm
tcp 0 0 127.0.0.1:5555 127.0.0.1:55908 ESTABLISHED 11623/postgres: adm
tcp 0 0 127.0.0.1:5555 127.0.0.1:55292 ESTABLISHED 8846/postgres: admi
tcp 0 0 127.0.0.1:5555 127.0.0.1:55283 ESTABLISHED 8837/postgres: admi
tcp 0 0 :::5555 :::* LISTEN 8811/postmaster
tcp 0 0 :::5558 :::* LISTEN 10698/postmaster
udp 0 0 127.0.0.1:40571 127.0.0.1:40571 ESTABLISHED 10698/postmaster
udp 0 0 127.0.0.1:43537 127.0.0.1:43537 ESTABLISHED 8811/postmaster
unix 2 [ ACC ] STREAM LISTENING 26103 8811/postmaster /tmp/.s.PGSQL.5555
unix 2 [ ACC ] STREAM LISTENING 49557 10698/postmaster /tmp/.s.PGSQL.5558
Paulo_Fraga
1 Rookie
•
26 Posts
0
February 5th, 2014 09:00
Hi,
Pass the default arguments for authentication :
User: viewuser
Psw : viewuser1
Hope it helps
Regards
Dandoun
8 Posts
0
February 5th, 2014 10:00
Hi,
This is the error message I get (in french
). For the pg_hba.conf file I added the line "host all all 0.0.0.0 trust" and restart all avamar machine but still get the same error.
Regards
Paulo_Fraga
1 Rookie
•
26 Posts
0
February 5th, 2014 10:00
Hi The only message you get is : connection resfused
Are there any more details ?
Also try this :
change the pg_hba.conf file to accept connections (for example: "host all all 127.0.0.1 255.255.255.0 trust")
Regards
Paulo_Fraga
1 Rookie
•
26 Posts
0
February 6th, 2014 06:00
Hi D@ny,
Can you try create a odbc connection to postgresql and check if you can connect, because i believe the issue may be with the driver for jdbc.
Use :
c:\windows\sysWOW64\odbcad32.exe
Create a odbc connection using postgresql standard ansi driver and test if you can connect to the database.
Regards
Dandoun
8 Posts
0
February 6th, 2014 07:00
Hi Paulo,
Again error connecting the database, I think there is something wrong with the VDP configuration (database protected or some restrictions like this...).
Even a telnet on the port 5555 fails.
Regards,
Paulo_Fraga
1 Rookie
•
26 Posts
0
February 6th, 2014 07:00
Hi D@ny,
Is there any firewall in the midle between your host and the Avamar utility node , are these ports being blocked ? Can you check?
Regards
ionthegeek
2 Intern
•
2K Posts
0
February 6th, 2014 08:00
I reviewed the VDP guide and I was unable to find any mention of database access being supported. While VDP and Avamar have a lot like in common, they are two different products. I don't believe VDP permits external access to its databases. All management and monitoring of VDP should be done through vSphere.
Dandoun
8 Posts
0
February 6th, 2014 08:00
Hi,
No firewall between me and the avamar (VDP) machine
Paulo_Fraga
1 Rookie
•
26 Posts
1
February 6th, 2014 09:00
Hi D@ny,
I was searching for ways to access VDP postgre database but seems not supported although similar to Avamar this is one feature that Avamar as and VDP don't.
Best Regards
Dandoun
8 Posts
0
February 6th, 2014 10:00
Hi Ian,
Thanks for your reply. My first goal was to create custom reports. As I didn't find anything on the VDP docs mentionig if this can or not be done, I tried to do it the same way as avamar.
It s sad that is can not be possible. The default report is really hard to read and it doesn't give details on backup jobs.
Thank you for your support. I will try with a test