Reporting server not starting

[Vladimir Iosifo]

Hello all,
could you kindly help me with understanding on why Reporting Server is not starting on my server ...

Configuration:

Linux server:  cat /etc/redhat-release
Red Hat Enterprise Linux Server release 7.1 (Maipo)

NetXMS version 2.0.4 compiled with next configuration:

CPPFLAGS=-I/usr/include/oracle/11.2/client64/ LDFLAGS=-L/usr/lib/oracle/11.2/client64/lib ./configure --with-agent --with-oracle --with-mysql --with-client --with-server --enable-unicode -prefix=/usr/local/netxms --exec-prefix=/usr/local/netxms --disable-ldap --disable-ipv6

/etc/netxmsd.conf

LogFile = /usr/local/netxms/log/netxms.log
#DBDriver = sqlite.ddr
#DBName = /usr/local/netxms/database/netxms_db
DBDriver = mysql.ddr
DBServer = localhost
DBName = <DBNAME_HIDDEN>
DBUser = netxms
DBPassword = <PWD_HIDDEN>
LogFailedSQLQueries = yes
EnableReportingServer = 1
ReportingServerPort = 4710
ReportingServerHostname = localhost

I have 2 issues:

1. When I'm enabling Reporting Server and restarting netxms server, port is still not listened:

/usr/local/netxms/bin/nxdbmgr set EnableReportingServer 1
/etc/init.d/netxmsd stop
/etc/init.d/netxmsd start
netstat -an | grep 4710
NOTHING

2. When I'm trying to start netxms-reporting-server, some errors thrown on the screen which I'm not able to overcome:
   conf/nxreporting.xml

<config>
  <workspace>/usr/local/netxms/reporting/workspace</workspace>
    <netxmsdConfig>/etc/netxmsd.conf</netxmsdConfig>
</config>

Starting server:
java -jar ./reporting-server-2.0.4.jar

...........
Caused by: org.springframework.beans.BeanInstantiationException: Failed to instantiate [javax.sql.DataSource]: Factory method 'dataSource' threw exception; nested exception is java.lang.NullPointerException
        at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:189)
        at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:588)
        ... 40 more
Caused by: java.lang.NullPointerException
        at com.radensolutions.reporting.dao.DaoContextConfig.dataSource(DaoContextConfig.java:42)
        at com.radensolutions.reporting.dao.DaoContextConfig$$EnhancerBySpringCGLIB$$28d50b10.CGLIB$dataSource$1(<generated>)
........

I also tried with another command:
java -cp /usr/local/netxms/reporting/lib/\*.jar:/usr/local/netxms/reporting/conf:/usr/local/netxms/reporting/reporting-server-2.0.4.jar com.radensolutions.reporting.Launcher

But results are still the same. I tried to read all the articles posted on this forum but was not able to find such issue.

[radw]

Hello, you need to start the Reporting Server as "sudo", otherwise, the reporting server not answer.

Regards.

[Vladimir Iosifo]

Hi radw,
thanks for ideas. But of course I executed it as root with proper environment variables and rights.