This post is more than 5 years old
8 Posts
0
7644
February 5th, 2014 09:00
Avamar DB remote access using JDBC
Hi All,
I'm trying to connect to mdbc avamar database remotly using a JDBC connection with the string jdbc:postgresql://10.76.52.80:5555/mcdb. I get the "connection refused error". I'm a newbie on Postgres database, I can't do more check.
Thanks
No Events found!
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