Start a Conversation

This post is more than 5 years old

Solved!

Go to Solution

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

8 Posts

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.

8 Posts

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

1 Rookie

 • 

26 Posts

February 5th, 2014 09:00

Hi,

Pass the default arguments for authentication :

User: viewuser

Psw : viewuser1

Hope it helps

Regards

8 Posts

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.
error_connection.jpg

Regards

1 Rookie

 • 

26 Posts

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

1 Rookie

 • 

26 Posts

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

8 Posts

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.

odbc_error.jpg
Regards,

1 Rookie

 • 

26 Posts

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

2 Intern

 • 

2K Posts

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.

8 Posts

February 6th, 2014 08:00

Hi,

No firewall between me and the avamar (VDP) machine


1 Rookie

 • 

26 Posts

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

8 Posts

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

No Events found!

Top