NetXMS Support Forum

Before upgrading on the operational network i first upgraded my testmachine with NetXMS 2.0 to the newest release NetXMS 2.0.2

Since then I am not able to logon again to the NetXMS Console. -->error message : connection refused

On the test machine the NetXMS database runs on a SQL Server 2012 (SQLEXPRESS) instance.

troubleshooting until now :

-ran command line : nxdbmgr upgrade
this reported a successful upgrade
new login attempt -->connection still refused

-ran command line : nxdbmgr check
this reported a database lock, and removed the lock
new login attempt -->connection still refused

-ran command line : nxdbmgr resetadmin
this reported a successful reset of the admin account to the default password "netxms"
new login attempt with default admin credentials-->connection still refused


Before i upgrade the live operation to 2.0.2 i want to sort out this issue.
So hereby a request for help.
Any suggestions?

Kindest regards,
Mark

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.

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.

the screenshot

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

Simply point your server at the already existing database.

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

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

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

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)

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

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

Hi,

Output sql queries as requested attached in this reply post.

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

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!