dosubot[bot] commented on issue #33862: URL: https://github.com/apache/superset/issues/33862#issuecomment-2996003841
<!-- Greeting --> Hi @caerux! I'm [Dosu](https://go.dosu.dev/dosubot) and I’m helping the superset team. <!-- Answer --> This is a known regression in Superset 4.x when using MySQL as the metadata database. The root cause is a case sensitivity issue in the ab_view_menu table: MySQL's default collation is case-insensitive, so only one entry ('security', all lowercase) is created, while Superset expects 'Security' (capital S) for the menu to appear. This does not happen with PostgreSQL, which is case-sensitive by default. To fix it, update the ab_view_menu table in your MySQL metadata database so that the entry is 'Security' (with a capital S). For example: ```sql UPDATE ab_view_menu SET name='Security' WHERE name='security'; ``` After running this, restart Superset and the Security menu should reappear for admin users. You may want to check for similar issues with other menu entries (like 'SQLLab') if you notice other missing menus. More details and confirmation of this workaround are available in [this issue thread](https://github.com/apache/superset/issues/33672). If you are running Superset in Docker, make sure the mysqlclient driver is installed in your image, as missing drivers can cause incomplete migrations and related permission issues. If the problem persists, check your Superset logs for any errors related to permissions or menu rendering. <!-- Dosu Comment Footer --> *To reply, just mention [@dosu](https://go.dosu.dev/dosubot).* --- <sup>How did I do? [Good](https://app.dosu.dev/response-feedback/b88d3db4-4926-418f-adff-49f37aca2f15?feedback_type=great_response) | [Irrelevant](https://app.dosu.dev/response-feedback/b88d3db4-4926-418f-adff-49f37aca2f15?feedback_type=irrelevant_answer) | [Incorrect](https://app.dosu.dev/response-feedback/b88d3db4-4926-418f-adff-49f37aca2f15?feedback_type=incorrect_sources) | [Verbose](https://app.dosu.dev/response-feedback/b88d3db4-4926-418f-adff-49f37aca2f15?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/b88d3db4-4926-418f-adff-49f37aca2f15?feedback_type=hallucination) | [Report 🐛](https://app.dosu.dev/response-feedback/b88d3db4-4926-418f-adff-49f37aca2f15?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/b88d3db4-4926-418f-adff-49f37aca2f15?feedback_type=other)</sup> [](https://go.dosu.dev/discord-bot) [! [Share on X](https://img.shields.io/badge/X-share-black)](https://twitter.com/intent/tweet?text=%40dosu_ai%20helped%20me%20solve%20this%20issue!&url=https%3A//github.com/apache/superset/issues/33862) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
