NetXMS Support Forum

English Support => General Support => Topic started by: lindeamon on November 04, 2012, 01:19:36 PM

Title: PostgreSQL v1.2.4
Post by: lindeamon on November 04, 2012, 01:19:36 PM
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
Title: Re: PostgreSQL v1.2.4
Post by: Victor Kirhenshtein on November 04, 2012, 08:40:57 PM
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
Title: Re: PostgreSQL v1.2.4
Post by: lindeamon on November 04, 2012, 09:13:25 PM
hi victor,

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

Best Regards,
Lindeamon
Title: Re: PostgreSQL v1.2.4
Post by: lindeamon on November 04, 2012, 09:28:23 PM
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
Title: Re: PostgreSQL v1.2.4
Post by: Victor Kirhenshtein on November 05, 2012, 11:08:05 AM
Hi!

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

Best regards,
Victor
Title: Re: PostgreSQL v1.2.4
Post by: lindeamon on November 05, 2012, 05:14:59 PM
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
Title: Re: PostgreSQL v1.2.4
Post by: Victor Kirhenshtein on November 05, 2012, 05:28:47 PM
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
Title: Re: PostgreSQL v1.2.4
Post by: lindeamon on November 05, 2012, 10:39:47 PM
Hi Victor,

i hope i will be able to do this tomorrow.

Best Regards,
Lindeamon
Title: Re: PostgreSQL v1.2.4
Post by: lindeamon on November 06, 2012, 06:55:15 PM
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