Yes, I installed the full installer and selected the DB client library each time. I've probably gone through about 10-15 attempts at installing it.
For now, I'm going to use SQL Server and just use the Windows Authentication as I really need to get this up and running.
This is puzzling to say the least. I was able to get the NetXMS Core service to finally start using SQL Server...only if I switched it to use a Windows account, and I had to run nxdbmgr upgrade because I was getting a different error (something about format for one version, compile for another)
I would prefer to run this using MySQL, so I wish I could get this squared away...
Ok, it is basically telling me the password being passed by NetXMS is incorrect. I can log in manually via command line using the username/password in the config file, but the NetXMS Core service fails.
Just for the heck of it, I tried re-installing on a SQL Server 2008 R2 database, and the exact same thing happens.
Ideas? Is the password somehow getting jumbled in the process? Did I miss a setting somewhere to use specific character set or something?
Not getting an error if I log into MySQL via command line with the exact same credentials. Is there a way to log in MySQL to see what NetXMS is trying as credentials?
MYSql was the one I originally tried. The user has full access to the MYSql server. I can connect via other tools....just not Netxms.
I'm setting up NETXMS 1.2.7 on Windows 7 machine. I can get through the install and I'm having trouble in the configuration part. When I try to start Netxms Core I get the following: Unable to establish connection with database (Access denied for user 'netxms_usr'@'localhost' (using password: YES))
I have tried using ODBC connection. I have tried installing MS SQL Server and using that as my DB engine. I have tried using SQL Lite. All give the same error, cannot connect to db.
I can connect other programs to my database server. Firewall is off. It is only Netxms I am having a problem with.
When I run netxmsd check I get 'NetXMS Core initialization failed'.
Below is my config file(username and password masked out). Any ideas?
LogFile = {syslog}
DBDriver = mysql.ddr
DBServer = localhost
DBName = netxms_db
DBLogin = ############
DBPassword = ##############
LogFailedSQLQueries = yes
