[dev] "Customer Users <-> Groups" mapping with external Customer User Backend DB

[Roberto Giana]

Hi I have successfully set up a OTRS installation, whith an external "Customer User Backend DB". External users can login and work. External users are visible under "Customer Users" in the admin area. Now I'm trying to impelment "Customer Users <-> Groups" mapping. Checking "Customer Users <-> Groups" in the admin area I can't see any user. Checking the logs I see: Wed Sep 21 01:13:12 2005 error OTRS-CGI-10 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1, SQL: 'SELECT mos_users.username, mos_users.username, SUBSTRING(mos_users.email,LOCATE('@',mos_users.email)+1) FROM mos_users WHERE valid_id in ( )' Wed Sep 21 01:13:12 2005 error OTRS-CGI-10 Table 'Mambo.valid' doesn't exist, SQL: 'SELECT id FROM valid WHERE name = 'valid'' Looking at the second line it seems that OTRS is trying to access the "valid" table erroneously on the external "Customer User Backend DB" instead off its own, internal DB. A Bug? --  Best regards Roberto Giana _____________________________________________________ Giana Roberto Consulting - GiaRoCo https://www.giaroco.ch/ _____________________________________________________

_______________________________________________
OTRS mailing list: dev - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/dev
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev