Hello,
we have a solution with 1000+ users. If I enter the security dialog in Developer, I see no users at all.
Servoy Developer
Version 3.5.1_b02-build 513
Java version 1.6.0_02-b05 (Windows Vista)
Patrick,
Does the logfile show anything? like a stacktrace?
Rob
As far as I see, nothing that shouldn’t be there:
16:10:48 DEBUG: repository_server: got managed connection
16:10:48 DEBUG: Database name PostgreSQL
16:10:48 DEBUG: Table Name servoy_client_stats tableType TABLE
16:10:48 DEBUG: Table Name servoy_columninfo tableType TABLE
16:10:48 DEBUG: Table Name servoy_content_spec tableType TABLE
16:10:48 DEBUG: Table Name servoy_element_properties tableType TABLE
16:10:48 DEBUG: Table Name servoy_elements tableType TABLE
16:10:48 DEBUG: Table Name servoy_group_elements tableType TABLE
16:10:48 DEBUG: Table Name servoy_groups tableType TABLE
16:10:48 DEBUG: Table Name servoy_media tableType TABLE
16:10:48 DEBUG: Table Name servoy_object_types tableType TABLE
16:10:48 DEBUG: Table Name servoy_releases tableType TABLE
16:10:48 DEBUG: Table Name servoy_revision_history tableType TABLE
16:10:48 DEBUG: Table Name servoy_root_elements tableType TABLE
16:10:48 DEBUG: Table Name servoy_user_groups tableType TABLE
16:10:48 DEBUG: Table Name servoy_user_properties tableType TABLE
16:10:48 DEBUG: Table Name servoy_users tableType TABLE
16:10:48 DEBUG: repository_server: Closed connection, thread=AWT-EventQueue-0
16:10:48 DEBUG: repository_server: got managed connection
16:10:48 DEBUG: Column name user_id type 4 lenght 4 nullable false
16:10:48 DEBUG: Column name user_uid type 12 lenght 200 nullable false
16:10:48 DEBUG: Column name user_name type 12 lenght 50 nullable false
16:10:48 DEBUG: Column name user_password type 12 lenght 50 nullable false
16:10:48 DEBUG: repository_server: Closed connection, thread=AWT-EventQueue-0
16:10:48 DEBUG: Loading column metainfo for table servoy_users
16:10:48 DEBUG: repository_server: got managed connection
16:10:48 DEBUG: repository_server: Closed connection, thread=AWT-EventQueue-0
16:10:48 DEBUG: repository_server: getting unmanaged connection
16:10:49 DEBUG: log_server: got managed connection
16:10:49 DEBUG: repository_server: got managed connection
16:10:49 DEBUG: Database name PostgreSQL
16:10:49 DEBUG: Column name log_id type 4 lenght 10 nullable false
16:10:49 DEBUG: Table Name servoy_client_stats tableType TABLE
16:10:49 DEBUG: Table Name servoy_columninfo tableType TABLE
16:10:49 DEBUG: Column name server_name type 12 lenght 50 nullable true
16:10:49 DEBUG: Column name table_name type 12 lenght 50 nullable true
16:10:49 DEBUG: Table Name servoy_content_spec tableType TABLE
16:10:49 DEBUG: Table Name servoy_element_properties tableType TABLE
16:10:49 DEBUG: Table Name servoy_elements tableType TABLE
16:10:49 DEBUG: Table Name servoy_group_elements tableType TABLE
16:10:49 DEBUG: Table Name servoy_groups tableType TABLE
16:10:49 DEBUG: Table Name servoy_media tableType TABLE
16:10:49 DEBUG: Table Name servoy_object_types tableType TABLE
16:10:49 DEBUG: Table Name servoy_releases tableType TABLE
16:10:49 DEBUG: Column name column_name type 12 lenght 50 nullable true
16:10:49 DEBUG: Column name log_action type 4 lenght 10 nullable true
16:10:49 DEBUG: Column name pk_data type 12 lenght 200 nullable true
16:10:49 DEBUG: Column name old_data type 12 lenght 4000 nullable true
16:10:49 DEBUG: Column name new_data type 12 lenght 4000 nullable true
16:10:49 DEBUG: Column name event_time type 93 lenght 23 nullable true
16:10:49 DEBUG: Column name user_uid type 12 lenght 200 nullable true
16:10:49 DEBUG: Table Name servoy_revision_history tableType TABLE
16:10:49 DEBUG: Table Name servoy_root_elements tableType TABLE
16:10:49 DEBUG: Table Name servoy_user_groups tableType TABLE
16:10:49 DEBUG: Table Name servoy_user_properties tableType TABLE
16:10:49 DEBUG: Table Name servoy_users tableType TABLE
16:10:49 DEBUG: repository_server: Closed connection, thread=TaskExecuter[2]
16:10:49 DEBUG: Column name user_name type 12 lenght 100 nullable true
16:10:49 DEBUG: log_server: getting unmanaged connection
16:10:49 INFO: Using dialect: org.hibernate.dialect.SQLServerDialect
16:10:49 INFO: Using dialect: com.servoy.j2db.dialect.SQLServerDialect
16:10:49 DEBUG: log_server: Closed connection, thread=AWT-EventQueue-0
16:10:49 DEBUG: Loading column metainfo for table log
Can you check the repository? How many entries are in the servoy_users table?
If this table is empty, in case you imported the users from a servoy-file, unzip this file and check the export/user_info.xml file, it should contain the users.
Rob
All the users are there and I can login perfectly. They are just not shown in the security dialog.
Patrick,
I could reproduce it, it is fixed now for 3.5.1
Rob
great.