VPN: configuration and event correlation

[user54119]

Hi Victor

Sorry for the late reply.

for 1:
Ok so I hope everything for VPN connectors will be available in Java console in 1.2.15 and there is no need for the old console anymore.

for 2:
I can't say which solution is better (more powerfull, flexible and better integrated in the concept of NetXMS), but I tend to solution 1. Can you open this as a feature request for V1.2.15?

Thanks

[victor]

Hi!

I also like solution 1 more. I just implemented it - starting with 1.2.15 SYS_NODE_UP event will have parameter at index 1 which will be set to 1 if node is returning from "unreachable" state and 0 if from "down".

Best regards,
Victor

[user54119]

Wow, thank's.
Is it possible to allready have the changed source file for tests? (as I allways compile from sources on Linux x64)

Thank's
Dani

[victor]

Hi!

I've put console builds and source package from current development branch here: https://www.netxms.org/download/1.2.15-M1/. Feel free to try!

Best regards,
Victor

[user54119]

Thanks. I tried V1.2.15-M1. Compile ok, but in DB upgrading from version 321 to 322:

SQL query failed (42601 ERROR:  syntax error at or near "ALTERT"
LINE 1: ALTER TABLE users ALTERT COLUMN system_access TYPE bigint
                          ^):
ALTER TABLE users ALTERT COLUMN system_access TYPE bigint

[victor]

Oops, typo in PostgreSQL query Run nxdbmgr with -X option and the run manually the following queries:

ALTER TABLE users ALTER COLUMN system_access TYPE bigint;
ALTER TABLE user_groups ALTER COLUMN system_access TYPE bigint;

Best regards,
Victor

[user54119]

you mean?:
nxdbmgr -X upgrade? (that results in an endless loop)
i stopped this and then: nxdbmgr batch script.sql (where I copied the two lines in)
But netxmsd doesn't start

[victor]

Try to execute manually query

UPDATE metadata SET var_value='322' WHERE var_name='SchemaVersion';

then netxmsd should start.

Best regards,
Victor

[user54119]

Hi Victor

Thank's for the fast help. Now it starts. Then I tested the new function with the new parameter of Event SYS_NODE_UP with a filter script ($1 != 1). Works exactly like expected! That will help me a lot! Now I revert to V1.2.14 again. For production I will wait for V1.2.15

Dani

[user54119]

to point 1 (configuration of VPN connectors in JAVA console):
Now there is a possibility to 'create' VPN connectors, but you can only specify a name of the connector and that's it. It's still not possible to configure the connector (peer node). In properties are only 'access control', 'comments', 'custom attributes' and 'status calculation'. So I still need the old console application.

to point 2 (event correlation):
The new parameter for SYS_NODE_UP is working as expected.