Connect to tr database

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

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 :|

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

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

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) .

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

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