PostgreSQL v1.2.4

[lindeamon]

hi,

i am trying to install the new version 1.2.4 on centos linux with postgresql .
up until now i did not have problems but with this new version i get "unable to load and initialize database driver...", what is the problem ? what have changed ?
i use pgsql v9.1

Best Regards,
Lindeamon

[victor]

Hi!

Nothing changed in PostgreSQL driver. Try to run server from command line as

netxmsd -D9

maybe there will be additional error messages. Also, please send me output of

uname -a

and

ldd <netxms_install_prefix>/lib/netxms/dbdrv/pgsql.ddr

Best regards,
Victor

[lindeamon]

hi victor,

it will take me a few days but i will get you the info

Best Regards,
Lindeamon

[lindeamon]

hi victor,

could not wait so i did it now.
from the files i can see that maybe the nxdbmgr has a problem.
by the way, i have installed 1.2.4 on windows servers and i did not have a problem
attached are the files you requested and sorry that i could not post the name in the uname

Best Regards,
Lindeamon

---

netxms_D9.txt

netxms_ldd_pgsql.txt

netxms_uname.txt

[victor]

Hi!

Server looks good, you just have to upgrade the database. Did you run nxdbmgr upgrade command?

Best regards,
Victor

[lindeamon]

Hi Victor,

Of course. this is what gave me the error saying it can not load or initialize.
i was not able to upgrade the db.
as i mentioned, i have installed the x64 and the x32 versions on different computers and different operating systems and the problem did not occurs, the DB was upgraded.
the problem occurs only in my linux box.
when i installed v1.2.3 on the same linux box with the same postgre everything went smooth.
hope this info will give you a lead

Best Regards,
Lindeamon

[victor]

Hi!

That's very strange, both nxdbmgr and server uses same database driver. Can you please send me full output of nxdbmgr, and output of ldd nxdbmgr? Also, try to run nxdbmgr giving configuration file explicitly with -c command line option. And try to specify database driver in netxmsd.conf as

DBDriver = pgsql.ddr

Best regards,
Victor

[lindeamon]

Hi Victor,

i hope i will be able to do this tomorrow.

Best Regards,
Lindeamon

[lindeamon]

Hi Victor,

i do not know what happened but it works. i have installed the new version, changed the directory to the netxms bin directory, ran the upgrade and it worked.
the only thing i can think of is that i ran the nxdbmgr command out of the netxms bin directory {i really do not remember what i did}
thank you anyway.

Best Regards,
Lindeamon