Hello all,
could you kindly help me with understanding on why Reporting Server is not starting on my server ...
Configuration:
QuoteLinux server: cat /etc/redhat-release
Red Hat Enterprise Linux Server release 7.1 (Maipo)
NetXMS version 2.0.4 compiled with next configuration:
QuoteCPPFLAGS=-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
QuoteLogFile = /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:
Quote/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
Quote<config>
<workspace>/usr/local/netxms/reporting/workspace</workspace>
<netxmsdConfig>/etc/netxmsd.conf</netxmsdConfig>
</config>
Starting server:
java -jar ./reporting-server-2.0.4.jar
Quote...........
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.
Hello, you need to start the Reporting Server as "sudo", otherwise, the reporting server not answer.
Regards.