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 ?
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
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 ? :)
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
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
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