Access denied to event log with all system rights checked

Started by Marcin, August 19, 2014, 05:22:40 PM

Previous topic - Next topic

Marcin

Hi,

I configured NetXMS with LDAP.
For the new user that was created and synced with LDAP, in the Properties -> System Rights I selected everything (for test purposes).
When I'm logging in as this user (LDAP password is accepted), when I click Alarm Log I get a message:
Cannot open server log "AlarmLog": Access denied
I have the same error for other views.

I don't know if this is related but while doing ldap sync for the first time I got many errors like this:
[19-Aug-2014 16:10:54.639] [ERROR] SQL query failed (Query = "INSERT INTO user_groups (name,system_access,flags,description,guid,ldap_dn,id) VALUES (?,?,?,?,?,?,?)"): ORA-01400: cannot insert NULL into ("NETXMSOWNER"."USER_GROUPS"."DESCRIPTION")
[19-Aug-2014 16:11:54.812] [ERROR] SQL query failed (Query = "INSERT INTO user_groups (name,system_access,flags,description,guid,ldap_dn,id) VALUES (?,?,?,?,?,?,?)"): ORA-01400: cannot insert NULL into ("NETXMSOWNER"."USER_GROUPS"."DESCRIPTION")

What could be the reason of access denied problem?

Best regards,
Marcin

Victor Kirhenshtein

Hi,

yes, this is a bug. It is already fixed in development trunk. Can you wait for 1.2.17 release?

Best regards,
Victor

Alex Kirhenshtein

Second issue will be also fixed in 1.2.17.

You can also change column by executing query "alter table user_groups modify description null"

Marcin

Hi,

Alex, Victor, thank you for the prompt answer.
I will wait for 1.2.17. When this release will be available for the public?

Best regards,
Marcin

Victor Kirhenshtein

Currently we plan to release 1.2.17 early in September.

Best regards,
Victor

Marcin


Is there any quick fix or workaround for this problem like sql query for user_groups table?

Best regards,
Marcin

Victor Kirhenshtein

For user_groups table just modify schema manually:


alter table user_groups modify description null


it will not affect upgrade to next version.

Fix for "access denied" error requires server recompilation. On what platform you have NetXMS server installed?

Best regards,
Victor