First time installing NetXMS

Started by Egert143, May 21, 2019, 09:22:49 AM

Previous topic - Next topic

Egert143

Hello

Wanted to give NetXMS a try run but already hiting some troubles. I installed fresh win 7 for testing purpose and added all neccesary upgrades. After that i installed microsoft sql express 2012. When installing NetXMS i reach the configuration wizard that cant connect to db. What could be the problem ?


Victor Kirhenshtein

Hi,

make sure that if you are using Windows authentication you have used * as login name and current user has access rights to the database, or if you are using SQL authentication (using login and password) that mixed mode authentication is enabled on SQL Server. Another possible issue could be using IP address (event loopback) with TCP/IP connector not enabled on SQL Server side.

Best regards,
Victor

Egert143

Thanks for the fast reply but unfortunately still no go.

I enabled mixed login mode for sql, with management studio i can login with windows user and sa user. Also enabled Sql named pipes and tcp/ip + Restarted sql service.

In netXMS configurator i have tryed multiple combinations
server address : localhost, 127.0.0.1, real local ip.
check for create new db
user name: * or sa with corresponding passwords

Any more suggestions ? :)

Victor Kirhenshtein

Try to cancel configuration wizard and run initialization manually (using nxdbmgr init) - it may provide more diagnostic information. You can also try to create user and database manually and choose "use existing database" option in configuration wizard.

Best regards,
Victor

Egert143

Hello

Got it working when i changed Ms Sql to mysql database. Have been playing with it for few days, so far very nice piece of software. :)

I would like to ask one additional question, but not sure if i should start new thread for that. Is there possibility to have a "safe / know" list of devices per "site / subnet" for example known good mac + ip combo and when new device appears with network discovery it will get flagged?

Egert

Victor Kirhenshtein

Quote from: Egert143 on May 27, 2019, 10:11:15 AM
I would like to ask one additional question, but not sure if i should start new thread for that. Is there possibility to have a "safe / know" list of devices per "site / subnet" for example known good mac + ip combo and when new device appears with network discovery it will get flagged?

Yes, it's possible with some scripting. Rough idea is to create mapping table with good MACs, setup script action to SYS_NODE_ADDED event, and in that script check if one of node's MAC addresses is in that table.

Best regards,
Victor