Failing install at create database

Started by ulink, September 21, 2015, 01:05:25 AM

Previous topic - Next topic

ulink

Hello forum
Installing the latest NetXMS RC on a win 7 32bit machine.  Have installed mySQL 5.6 and setup admin for the account.  I can only go so far into the server config installer before failing at creating database.  Get
SQL Query failed: Create Database netxms_db

Researching forum I see instances where permissions for my admin users may not be sufficient.  Okay, I dig into mysql syntax to run on the command line client and do so.
grant all privileges on *.* to 'user'@'localhost';
flush privileges

Query comes back okay but I get same results on the server configuration.

What else could I be missing?

Victor Kirhenshtein

Hi,

try to create database and user for NetXMS using MySQL management tools and in server installer select "use existing database" and specify user and database you created.

Best regards,
Victor

ulink

Thanks for replying Victor
That work around helped move a couple steps forward.  I removed the DB from SQL and stepped back through the configuration.  It failed but I went back through with existing DB selected and it moved ahead through Initilizing database, Configuring Server then failed with an error at Installing Service
Pop up Error window stating "Cannot connect to Service Manager: Access is denied"

Okay
Did search on forums and found this post"
https://www.netxms.org/forum/installation/netxms-server-'cannot-connect-to-service-manager'/

I dropped the DB again and stepped through the whole process with the config wizard as Admin and it finally took.

Finally moving ahead.

Thanks for the help