I’m trying to create room through web service during a specific scenario in our app, the room has been created successfully, all required fields has been inserted into MUC tables (ofMucRoom, ofMucAffiliation, ofMucMember) in DB, but room users can’t see room with chat on Android and IOS
Are you making direct inserts into DB with that web app? This is not the recommended way. You should use some sort of provider (maybe RestAPI plugin will work).
MUC configuration is heavily cached in Openfire, so you should not write to the database directly. This can create data integrity issues, including data loss, if Openfire is running when changes are made to the database by other processes.
However, if you want to write into the database for testing purposes only, first shut down Openfire, then apply the database changes and restart the server.