NetXMS Support Forum

Please login or register.

Login with username, password and session length

Author Topic: Postgresql selection in configuration of server fails  (Read 411 times)

ravi2904

  • Newbie
  • *
  • Posts: 13
    • View Profile
Postgresql selection in configuration of server fails
« on: October 15, 2019, 05:00:21 pm »

After installing the server on windows, while configuring the server, if I select PostgreSQL as database server, I select pgsql.ddr as driver. I am getting following error:

C:\NetXMS\bin>netxmsd -D 9
Using configuration file "C:\NetXMS\etc\netxmsd.conf"
2019.10.15 19:09:35.669 *D* [                   ] LIB directory set to C:\NetXMS\lib
2019.10.15 19:09:35.676 *D* [dload              ] DLOpen: file="pgsql.ddr", module=0000000000000000
2019.10.15 19:09:35.676 *E* [db.driver          ] Unable to load database driver module "pgsql.ddr": %1 is not a valid Win32 application.
NetXMS Core initialization failed

Please let me know how can I get through this ?

Thanks and bets regards,

Ravi
Logged

Victor Kirhenshtein

  • Lead Developer
  • Administrator
  • Hero Member
  • *****
  • Posts: 6791
    • View Profile
Re: Postgresql selection in configuration of server fails
« Reply #1 on: October 15, 2019, 10:57:52 pm »

Hi,

what version you are using? Did you use minimal or full installer? If minimal, what is PostgreSQL client version? Could it be that libpq.dll in your PATH is 32 bit executable?

Best regards,
Victor
Logged

ravi2904

  • Newbie
  • *
  • Posts: 13
    • View Profile
Re: Postgresql selection in configuration of server fails
« Reply #2 on: October 16, 2019, 07:29:37 am »

Hi Victor,

I am using netxms-3.0.2305-x64.exe setup.
The libpq.dll is in c:\netxms\bin folder. The log shows LIB directory set to c:\netxms\lib folder. This folder contains jar files. I tried copying the libpq.dll as well as the pgsql.ddr in the c:\netxms\lib folder, but, get the same error. I have also included the c:\netxms\bin folder in the PATH. But the same error continues.

I checked with Dependency Walker, the libpq.dll shows as x64 file. But, it also gives error about dependency dlls missing and they are many.

Thanks and best regards,

Ravi
« Last Edit: October 16, 2019, 07:49:05 am by ravi2904 »
Logged

Victor Kirhenshtein

  • Lead Developer
  • Administrator
  • Hero Member
  • *****
  • Posts: 6791
    • View Profile
Re: Postgresql selection in configuration of server fails
« Reply #3 on: October 16, 2019, 10:08:27 am »

Hi,

could you show dependency walker output?

Best regards,
Victor
Logged

ravi2904

  • Newbie
  • *
  • Posts: 13
    • View Profile
Re: Postgresql selection in configuration of server fails
« Reply #4 on: October 17, 2019, 07:47:59 am »

Hi Victor,

I found out the problem. I was giving a wrong name for the datasource. The name of the datasource in the system DSN was "system" and I was typing "localhost" in the server configuration. This problem is now sorted out and I am able to connect NetXMS to Postgres through ODBC driver. However, I think the log or the error which pops out should be more specific.

I am anyway giving below the output of dependency walker. I used it for the first time, and need to understand it. But, anyway, here it is:

The log shows following errors:

Error: At least one required implicit or forwarded dependency was not found.
Error: At least one module has an unresolved import due to a missing export function in an implicitly dependent module.
Error: Modules with different CPU types were found.
Error: A circular dependency was detected.
Warning: At least one delay-load dependency module was not found.
Warning: At least one module has an unresolved import due to a missing export function in a delay-load dependent module.

And, a long list of .DLLs shows: "Error opening file. The system cannot find the file specified(2)":

I don't know what it means, but the server application is working fine.

Thanks for your support Victor and god bless you.

Best regards,

Ravi
Logged