refused logon to NetXMS Cons after upgrade NetXMS 2.0 to NetXMS 2.0.2 (SOLVED)

[tomaskir]

Connection refused usually means server is not even running.
Check if netxmsd is actually running.

Also, before doing anything with nxdbmgr, stop netxmsd.
After you are done, you need to start netxmsd again.

[Mark.Ouwendijk]

I tried starting netxmsd, Unfortunately without any success.

Eventually I decided to remove the installation from the testmachine (and keep the already existing database) and then to install and run setup again.

At the end of the installation/setup, at 'applying server configuration', an error message is displayed :

error:sql query failed, CREATE  TABLE metadata.....<see attached screenshot>

I can not continue and complete setup after the error.

Any suggestions for next steps and further troubleshooting? I still want to try to use the existing database that i already used with version 2.0

Thanks in advance.
Kindest regards.

[Mark.Ouwendijk]

the screenshot

---

[tomaskir]

If you kept the database, do not re-initialize it after server reinstall.

Simply point your server at the already existing database.

[Mark.Ouwendijk]

With your help (no re-intialize) I now successfully have installed NetXMS 2.0.2. 

Unfortunately when i now login to the NetXMS console i still get the error "connection refused", as like before.

When i checked if the server is actually running i noticed it wasn't.

Troubleshooting from there :

• started netxms core service from Windows GUI --> error "can not start the NetXMS core service on the local machine / Error 1067 the process has unexpectedly terminated ", screenshot with error message in dutch attached in this reply

• started netxmsd from Windows command line --> error "Error 1067 the process has unexpectedly terminated" screenshot with error message in dutch attached in this reply.
  Also screenshot of application error in event viewer attached in this reply.

• started netxmsd with debug -D 9 --> debug output file attached in this reply

Any ideas for following steps to take in solving this issue?

Thanks in advance.

Kindest regards.

Markus

---

debug output netxmsd Windows command line start

[Mark.Ouwendijk]

Attached in this post a better more readable debug output logfile. (output of command: netxmsd -D 9  command line Windows )

---

netxmslog.txt

[victor]

Hi,

looks like server is crashing on startup. Can you please enable crash dump generation by adding

CreateCrashDumps = yes
DumpDirectory = some existing directory

to netxmsd.conf, star tserver again, and sent info and mdmp file to us?

Best regards,
Victor

[Mark.Ouwendijk]

Hello Victor,

Regarding this issue :
"connection refused logon to NetXMS Cons after upgrade NetXMS 2.0 to NetXMS 2.0.2" (netxms core crash on startup)

In this reply post I attached the files .info and .mdmp you requested.

Kind regards,

Mark (MarkusO)

---

netxmsd-7232-1455262944.info

netxmsd-7232-1455262944.mdmp

[victor]

Could you please send me results of the following queries:

SELECT * FROM dashboard_elements WHERE dashboard_id=107;
SELECT num_columns,options FROM dashboards WHERE id=107;

Best regards,
Victor

[victor]

It seems that I've found bug in our MS SQL database driver. Could you please replace file mssql.ddr with attached one and try to start server?

Best regards,
Victor

---

mssql.ddr

[Mark.Ouwendijk]

Hi,

Output sql queries as requested attached in this reply post.

---

output SELECT FROM dashboard_elements WHERE dashboard_id=107

output SELECT num_columns,options FROM dashboards WHERE id=107

[Mark.Ouwendijk]

Replaced the mssql.ddr file with the new mssql.ddr file, provided by you.

NetXMS Core service starting and running OK now.
Login to console also working.

It seems that the issue has been resolved.
Thank you for your help.

Kindest regards,

Mark

[bdefloo]

Hi,

Just a quick heads up. We just upgraded from v1.2.16 to v2.0.2 and the nxdbmgr.exe tool crashed when trying to upgrade from database version 383. Also using SQL Express 2012.

After replacing the mssql.ddr file with the one from this forum thread this was successful.

Thanks!