Moving our production NetXMS server to a new computer server. I have an issue.

[jbriseno]

Hi, Filipp. I did that you mentioned in the your latest post reply.  I did not find 2022.06.06 11:41:35.641 *I* [comm.listener      ] SocketListener/Clients: listening on 0.0.0.0:4701

However I found in the same file the following lines:

2022.06.07 13:05:47.148 *I* [                  ] Platform subagent "/usr/lib/x86_64-linux-gnu/netxms/linux.nsm" successfully loaded
2022.06.07 13:05:47.149 *I* [db.drv            ] Database driver "mariadb.ddr" loaded and initialized successfully
2022.06.07 13:05:47.150 *I* [comm.listener      ] SocketListener/LocalAdmin: listening on 127.0.0.1:21784
2022.06.07 13:05:47.150 *I* [comm.listener      ] SocketListener/LocalAdmin: listening on [127.0.0.1]:21784
2022.06.07 13:06:12.175 *E* [db                ] Unable to establish connection with database (Access denied for user 'netxms'@'localhost' (using password: NO))

I hope these lines help.
My best
Jose

[Filipp Sudanov]

Well, this line gives the answer:
2022.06.07 13:06:12.175 *E* [db                ] Unable to establish connection with database (Access denied for user 'netxms'@'localhost' (using password: NO))
NetXMS was not able to connect to the database. Check your login and password and that the database accepts connection from that IP address.

[jbriseno]

Hi, Filipp. I am agree with you. However, I can log to the database with the same root credentials. I attach a screenshot. It is weird for me. Meanwhile I was working in this database connection issue. I have the following idea:

Because, I moved the database file into a new computer server. Maybe, I need to use the same root password that I use in the production server. I am going to try it.

My best
Jose

---

[Filipp Sudanov]

Try connecting from the machine where your netxms server is running by giving the IP address of your database server:

mysql -u root -p -h 1.2.3.4

1.2.3.4 should be replaced by IP address of your database server.

[jbriseno]

Done ! the mysql command sent back the following message on my end:

ERROR 2002 (HY000): Can't connect to MySQL server on databse IP address

Whoops !

My best
José

Side note: NetXMS server and NextXMS database server are in the same IP address.

[Filipp Sudanov]

How the IP of DB server is configured in netxmsd.conf? Is it like this:
DBServer=127.0.0.1

If so, try
mysql -u root -p -h 127.0.0.1

[jbriseno]

Done ! I attach a screenshot.

Also,  I decided to open the log file of the netxmsd. I found the following information in the latest line:

2022.06.07 16:44:25.647 *E* [db                ] Your database has format version 40.100, but server is compiled for version 41.17

---

[Filipp Sudanov]

2022.06.07 16:44:25.647 *E* [db                ] Your database has format version 40.100, but server is compiled for version 41.17

This means that netxms managed to connect to the database, but netxms binaries are newer version then these that were used last time with this database. Please execute

nxdbmgr upgrade

and once it complete try to start netxms again.

[jbriseno]

Done ! I attach two screenshots. First one is the status of the netxmsd running. Great ! Second is the Connection error window when I try to connect to the new computer server.

Any idea how can I fix this connection error.
Thanks in advance
My best
Jose

---

[jbriseno]

Hi, Filipp. our new production NetXMS server is up and running. Thanks a lot to Victor and you for your kind help. Kudos.
Finally, What I did to fix the connection error window in the latest post reply. I updated the NetXMS client. Problem solved.

My best
Jose