I finally found the solution to my problem. The problem is, that the pileruser on my old system was called piler while the new one is called pileruser. I have already changed all configurations so that everything runs on pileruser except the definer on the v_messages table. While the auditor only uses the metadata table to query the messages, the other users use the algorithm in the v_messages table. This table is blocked for the pileruser because of the definer. To solve this issues I have simply added the user piler again and granted him select access on the whole pilerdb. Recreating the algorithm with the pileruser would be much cleaner, but this method was much more safe to use.
- Patrick Von: Patrick Wever/RGFI An: piler-user@list.acts.hu Datum: 07.09.2023 10:55 Betreff: Antwort: No permissions for LDAP users Hello, I can provide you with some more information about this problem. While upgrading, I made a dump of the old pilerdb and imported it into the new piler. Before i was using piler 1.2.0 with sphinx. At the moment I am using piler 1.4.3 with manticore. I checked the config-site.php for any hints, but the configuration on the old and new system is the same. Maybe there is a problem with the query on the mysql db? It could also be a problem with the manticore configuration, because i did not copy anything from the old sphinx configuration. The last location I could check would be the /var/piler/www/config.php, but I am not sure if this configuration has anything to do with permissions for the user. I also do not have any groups or users configured besides the local auditor and the admin. The only error/warning I got is while logging in: PHP Warning: Undefined array key "username" in /var/piler/www/controller/login/login.php on line 125 The only option I have, is to add the LDAP user to the auditor group, but the LDAP user should not be allowed to view mails besides his own mailadress. - Patrick Von: Patrick Wever/RGFI An: piler-user@list.acts.hu Datum: 06.09.2023 15:35 Betreff: No permissions for LDAP users Hello, I ran into the problem, that LDAP users can not see the preview of their mails. The windows only shows 'no permission for <id of the mail>'. The auditor user can see and open every message. I am currently running Piler on 1.4.3, which was upgraded from an old host with piler 1.2.0. - Patrick
