NetXMS Support Forum

Thanks!

I have created these tables and now I can execute a report.
I see results in the tables, but I do not see anything in the console.
I can add a schedule, this is shown in the console correctly.
Even when using the schedule I do not see any results.
Also when adding a notification to my email address I do not receive an email.
I see the actions in the reporting server log as:
Hibernate: insert into reporting_results (executionTime, jobId, reportId, userId) values (?, ?, ?, ?)
Hibernate: select notificati0_.id as id1_0_, notificati0_.attach_format_code as attach_f2_0_, notificati0_.jobid as jobid3_0_, notificati0_.mail as mail4_0_, notificati0_.report_name as report_n5_0_ from report_notification notificati0_ where jobid=?
Hibernate: select notificati0_.id as id1_0_, notificati0_.attach_format_code as attach_f2_0_, notificati0_.jobid as jobid3_0_, notificati0_.mail as mail4_0_, notificati0_.report_name as report_n5_0_ from report_notification notificati0_ where jobid=?
Hibernate: select reportresu0_.id as id1_1_, reportresu0_.executionTime as executio2_1_, reportresu0_.jobId as jobId3_1_, reportresu0_.reportId as reportId4_1_, reportresu0_.userId as userId5_1_ from reporting_results reportresu0_ where reportresu0_.reportId=? order by reportresu0_.executionTime desc

so it is doing something!

Hi,

We are getting segfaults on the netxmsd after upgrading to 1.2.16.
error is:

netxmsd[32695]: segfault at 7f62ef0d666c ip 00007f62f3806dd0 sp 00007f62ef09ad50 error 4 in libnxcore.so.1.0.0

OS is Oracle Linux (RedHat) 6.3 with kernel: 2.6.32-300.3.1.el6uek.x86_64
glibc version is glibc-2.12-1.80.el6_3.6.i686

Any update on the missing tables?

Thanks,
Edward

Much better!!

the only thing is that I'm missing some tables.(reporting_results and report_notification)
In the source I see the scripts for Oracle, but not for mysql.
Could you please add them?
maybe also include the QUARTZ scripts


Regards,
Edward

username and password are 100% correct.
same username and password as netxmsd is using.
Also same host.
the most strange thing is that the quartz scheduler is accessing the database correct.
looks like the password is not parsed corectly.
is there a way to debug this?

I have compiled nxreporting from source (1.2.16), Configured the datasources to use mysql.
So far so good. nxreporting server is started (after creating the QUARTZ table in mysql)
from the client I can see the IP inventory report, but when I click it I get mysql connect errors in the reporting console log.

attached I have the log with debug switched on.

nxreporting.properties is:

# Workspace root. Contains deployed report definitions and output files
nxreporting.workspace=./workspace

# Datasource used by nxReporting itself to store job and schedule details
system.datasource.driverClassName=com.mysql.jdbc.Driver
system.datasource.url=jdbc:mysql://127.0.0.1/netxms
system.datasource.dialect=org.hibernate.dialect.MySQLDialect
system.datasource.username=netxms
system.datasource.password=<password>

# Datasource passed to Jasper Reports
report.datasource.driverClassName=com.mysql.jdbc.Driver
report.datasource.url=jdbc:mysql://127.0.0.1/netxms
report.datasource.username=netxms
report.datasource.password=<password>

report.datasource2.driverClassName=com.mysql.jdbc.Driver
report.datasource2.url=jdbc:mysql://127.0.0.1/netxms
report.datasource2.username=netxms
report.datasource2.password=<password>

org.quartz.dataSource.myDS.driver = com.mysql.jdbc.Driver
org.quartz.dataSource.myDS.URL = jdbc:mysql://127.0.0.1/netxms
org.quartz.dataSource.myDS.user = netxms
org.quartz.dataSource.myDS.password = <password>

From Mysql I can see that it is connection, so the URL is correct.
What could be the problem?

this is one of the errors:

[15-Aug-2014 18:50:41.373] [ERROR] SQL query failed (Query = "INSERT INTO snmp_trap_log (trap_id,trap_timestamp,ip_addr,object_id,trap_oid,trap_varlist) VALUES (17210,1408121441,'172.30.108.252',109,'.1.3.6.1.4.1.9.9.171.2.0.2','.1.3.6.1.4.1.9.9.171.1.2.2.1.6.1.4.188.204.63.138.1.4.87.197.107.139.473 == ''¼Ì?''; .1.3.6.1.4.1.9.9.171.1.2.2.1.7.1.4.188.204.63.138.1.4.87.197.107.139.473 == ''WÅk''; .1.3.6.1.4.1.9.9.171.1.2.3.1.16.473 == ''8640000''; .1.3.6.1.4.1.9.9.171.1.4.2.1.1.2.473 == ''3''')"): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''.1.3.6.1.4.1.9.9.171.1.2.2.1.6.1.4.188.204.63.138.1.4.87.197.107.139.473 == ''' at line 1

another error is:

[15-Aug-2014 13:28:24.612] [ERROR] SQL query failed (Query = "UPDATE alarms SET alarm_state=0,ack_by=87686256,term_by=30541662,last_change_time=87686256,current_severity=0,repeat_count=0,hd_state         =0,hd_ref='`Ò',timeout=0,timeout_event=51,message='Ò',resolved_by=0, ack_timeout=0 WHERE alarm_id=49001504"): You have an error in your SQL syntax; check the manual that corresponds to your MySQL          server version for the right syntax to use near ''`' at line 1

hmm, seems to be an incident. I have deleted these DCI's and created them again.
Now it is working fine. no idea what went wrong.

Hi,

I have an issue with thresholds. It looks like the event is not raised.
What I did:

On an existing node I added an new snmp DCI. (value is string)
On this DCI I have set a threshold (last polled value != ok) which raise SYS_THRESHOLD_REACHED.
Now after activating this DCI I see in the event monitor SYS_DCI_ACTIVE.
After polling cycle I see the value of the DCI is changed to unavailable, so the threshold is activated. ==>> all looks OK.
the only thing is that I do not see any event generated. I have set a policy to generate an alarm, but this alarm is not generated.

We recently upgraded to 1.2.16.

Hi,

I see some documentation coming!!
Where can I download/build the reporting server?

Hi,

Could you please tell me how to configure the reporting server feature?
I'm running 1.2.16. could not find anything in the documentation (yet).

Thanks,
Edward

Hi, I'm trying to us nxapush to push data for another node.
So my command is (from the netxms server): ./nxapush -o 1371 nearixvol0=12345
1371 is the id for the node I want the data.

nearixvol0 is the parameter I filled in when creating the DCI on node 1371. the dci type is set to push.
in the agent log I see:
[04-Apr-2014 08:49:15.024] [DEBUG] ProcessPushRequest: connection established
[04-Apr-2014 08:49:15.024] [DEBUG] ProcessPushRequest: received message CMD_PUSH_DCI_DATA
[04-Apr-2014 08:49:15.024] [DEBUG] PushData: "nearixvol0" = "12345"
[04-Apr-2014 08:49:15.024] [DEBUG] ProcessPushRequest: connection closed

On the node I see no data comming into the DCI.

Am I missing something?

Regards,
Edward

Hi Lindeamon,

Serverplatform is linux 64bit.

Facing the same issue. Is there a work-around?

Regards,

Edward

That solved the problem!
Thanks