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
Hi,
yes, this is a bug. It is already fixed in development trunk. Can you wait for 1.2.17 release?
Best regards,
Victor
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"
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
Currently we plan to release 1.2.17 early in September.
Best regards,
Victor
Is there any quick fix or workaround for this problem like sql query for user_groups table?
Best regards,
Marcin
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
It's Solaris 10.