DCI and Authentication disabled (after OS reboot)

[victor]

Hi,

it seems that server is started on OS boot and then stopped. One possible reason could be that it started before database is ready, so it cannot access database and exits. Can you please set debug level to 9 (by adding DebugLevel=9 to netxmsd.conf), restart the system, and post server's log file?

Best regards,
Victor

[radw]

Hello, here is the netxmsd log file requested: https://www.dropbox.com/s/t3uont26zsu72vs/netxmsd?dl=0

Regards.

[victor]

It seems that netxmsd starts before MySQL is ready:

[31-May-2016 10:50:17.311] [ERROR] Unable to establish connection with database (Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2))

try to add dependency on mysqld and/or startup delay to netxmsd startup script.

Best regards,
Victor

[radw]

Hello, thanks for your answer. In those cases, which is the best practice ??. Also, is there any procedure in the documentation to perform that action ??

Regards.

[radw]

Hello Victor, can you explain me how to perform those steps. Thanks.

[alk]

Modify /etc/init.d/netxmsd, add "mysqld" to "Required-Start" section.

[radw]

Hello, I modify the file and restart the netxmsd service, however the issue persists after I reboot the Debian system:

NETXMS-TEST:~$ sudo vi /etc/init.d/netxmsd
#!/bin/sh
# vim: syntax=sh
### BEGIN INIT INFO
# Provides:          netxms-server
# Required-Start:    $network $local_fs nxagentd mysqld
# Required-Stop:
# Default-Start:     2 3 4 5
# Default-Stop:      0 1 6
# Short-Description: NetXMS server
# Description:       Network monitoring daemon, which collect and process metrics
#                    from native and SNMP agents.
### END INIT INFO

# Author: Alex Kirhenshtein <[email protected]>

Regards.

[radw]

Hello, I still have the authentication issue after rebooting or shutdown the OS.

The netxmsd service appears active, but is necessary to restart it for allow login.

Regards.

[victor]

What is in the netxmsd log when you try to connect after OS restart?

Best regards,
Victor

[radw]

Hello Victor, here is the log (at debug level9): http://jmp.sh/iZAh5EK

Regards.

[victor]

Hi,

still there is an issue with database not being ready:

[19-Aug-2016 09:55:11.539] [ERROR] Unable to establish connection with database (Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2))

If there is dependency on mysqld in netxmsd startup script, then you need to add some code to wait while mysql becomes available in netxmsd startup script, or just add delay big enough to allow mysqld to initialize.

Best regards,
Victor

[radw]

Hello Victor, thanks for your answer and analysis.

In this case, ¿¿can you guide me on on how to ingress the code you mentioned for fixing the issue ??

Regards.