Connect to tr database

[vladcbv]

Hi Guys,

I am using IPOCC 10.1.2 .
I want to connect to the tr database to get some info. I am using ODBC 32bit . the problem that i have is that i get invalid password for Administrator. and I am sure I enter the corect password because I can use pgbackup to backup ipocc..
Is there a new way of doing it for latest version of ipocc ?

 

[janni78]

Are you connecting from the IPOCC server or from another server?
As default remote connections aren't allowed to the database.

"Trying is the first step to failure..." - Homer

 

[vladcbv]

Directly from IPOCC Server.

I ussualy use Excel to connect to ODBC Datasource..so I first create a DSN with ODBC 32bit and then use Excel for Data import.
I haven't installed excel yet but I see that I can use user postgress with no password to connect to the tr database with odbc 32bit :|

 

[janni78]

The IPOCC installation should already have created an ODBC connection to the TR database called TRS-DSN which you would use.
The postgres user is trusted on the local server so it should always be able to connect without password.



"Trying is the first step to failure..." - Homer

 

[janni78]

You might also need to use localhost and not the IP of the server when creating a new ODBC.

"Trying is the first step to failure..." - Homer

 

[vladcbv]

Hi,

I had to get an avaya tech to reset my db admin password

Ok so I am using localhost to get a successfull connection, though I would also like in the feature to connect from another pc.
When I put the IP addr of IPOCC server i get an error : FATAL: no pg_hba.conf entry for host 192.168.1.3, user "Administrator"
database tr, SSL off .. Which for me means that Administrator dosen't have rights (sort of speak - I am an amateur on databases) .

 

[janni78]

You're only allowed to connect from localhost (127.0.0.1) to the database as default.

If you want to connect from another PC you need to allow that in the C:\ProgramData\Avaya\PostgreSQL\9.3\pg_hba.conf and restart the services.
The line below would allow you to access from 192.168.0.10 with any login.

host all all 192.168.0.10/32 md5

You could also specify which user is allowed to connect.

"Trying is the first step to failure..." - Homer

 

[vladcbv]

Thank you for this info janni..
I remember trying this on an ipocc server but what I did was to mess up everything.
I will try it on a test system and check it out.

Sorry for delayed reponse