NetXMS Support Forum

All,
I have been trying to install NetXMS from source for the last two days and haven't gotten anywhere. I've tried building with MySQL, Postgresql and SQLite. Each one comes with it's own set of problems.

With Postgresql, when I try to run the 'nxdbmgr init' command it tells me that NetXMS is unable to connect to the database 'netxms@localhost'. I've already checked and made sure the netxms database exists. Even dropped the database and rebuilt it. After that didn't work I re-installed Postgresql and worked my way through everything again, coming to the same end.

With MySQL, when running the 'nxdbmgr init' command, I am getting a message that the server cannot communicate with the netxms database. So again, I tried rebulding the database, same issue. Uninstalled and reinstalled MySQL and ran into the same issue as I did with Postgresql.

With SQLite, well, SQLite never works. But I tried it just to say I tried it.

If anybody could give me some pointers or possibly some guidance that would really be appreciated.

Thank you!

Are you able to connect to either database using the cli tools such as mysql  or psql for postgres ?   Did you make sure to add the correct db driver username and credentials in the netxms config?  You also would have to have configured netxms to build those drivers   --with-pgsql  --with-mysql --with-sqlite in orderian to initialize the databases.  Hope any of that helps. I have never had any issues as long as every thing builds correctly and I am able to connect to the DB with my configured username and password from the cli tools then i'm usually good to go.

Yup. Went through all of that, made sure and double made sure I could get to the databases. Confirmed that the 'netxms' user was created, had sufficient privileges.

I'd suggest running ./configure with  --with-pgsql  --with-mysql --with-sqlite again, make clean and rebuilding from start to make sure that it's ok with client binaries.
Just in case, pls show your server configuration.
Currently it's easier to install on Debian/Ubuntu distros - here we have packages available so at least we can exclude complication problems.

Just an update I downloaded CentOS 7 and was able to successfully build and install using the latest netxms source and postgres 12.    However i did run into  an initial issues when trying to nxdb init

Unable to connect to database netxms_db@localhost as netxms (FATAL:  Ident authentication failed for user "netxms") i believe this is because the pg_hba.conf does not have an entry for netxms after changing to the following i was able to initialize via nxbmgr init

local   all             postgres                                trust
# IPv4 local connections:
host    netxms_db   netxms         127.0.0.1/32             md5
# IPv6 local connections:
host    netxms_db   netxms         ::1/128                  md5



using pqsql i created a db of netxms_db and  user netxms with password of netxms for testing   


hope this helps