Connect to tr database
Connect to tr database
(OP)
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 ?
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 ?
RE: Connect to tr database
As default remote connections aren't allowed to the database.
"Trying is the first step to failure..." - Homer
RE: Connect to tr database
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 :|
RE: Connect to tr database
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
RE: Connect to tr database
"Trying is the first step to failure..." - Homer
RE: Connect to tr database
I had to get an avaya tech to reset my db admin password:D
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) .
RE: Connect to tr database
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
RE: Connect to tr database
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 :)