Integration issue

[solmann]

Sir,

I am trying to use moddbexport module with postgres sql.

I am getting following error:-
password authetication failed for user…. I have created user properly in admin and password also with application prevelage.

..screen shots :-
https://postimg.org/image/yg3te2skp/
..
http://postimg.org/image/aley1rdk1/

Logs of DB export error as under

nnecting to DB PostgreSQL – localhost: FATAL: 28P01: password authentication failed for user “export”
Error connecting to DB PostgreSQL – localhost: FATAL: 28P01: password authentication failed for user “export”
Error connecting to DB PostgreSQL – localhost: FATAL: 28P01: password authentication failed for user “export”
Error connecting to DB PostgreSQL – localhost: FATAL: 28P01: password authentication failed for user “export”
Error connecting to DB PostgreSQL – localhost: FATAL: 28P01: password authentication failed for user “export”
Error connecting to DB PostgreSQL – localhost: FATAL: 28P01: password authentication failed for user “export”
.
.
.
more info
Server config user.dat is updated.. and looks good with required users

any clue…

[Mikhail]

Try using these manuals:
https://www.postgresql.org/docs/9.1/static/client-authentication-problems.html
https://www.postgresql.org/docs/9.3/static/auth-pg-hba-conf.html
http://stackoverflow.com/questions/21388701/postgresql-sspi-authentication-fatal-2801-password-authentication-failed-for

This issue is not caused by ModDBExport but the PostgreSQL itself.

[solmann]

I am trying for that,

Also let me know where to spcify port number for oracle db export.

as sql devloper specify for port 1521,,

…. i am trying various combination but error listener refuse connection. ORA12505.. any clue??

at Scada server templets there is a server connection tab also … do i need to play with it…

[Mikhail]

1521 is the default Oracle port. I don’t think you should explicitly specify it.
Have you specified your connection settings in tnsnames.ora ?

Connection tab contains settings those used by the shell to connect to SCADA-Server service. You don’t need to change them.

[Mikhail]

The most simple is MySQL and MS SQL 🙂

[Author]

Posts