Yesterday i finished to install our Openfire server 3.6.4 on ubuntu 8.04 with mysql as a database,
and entered all our users and assigned each to his proper group.
i have created a NEW service group in the group chat settings. ( didn’t use the default public “conference” and removed it)
then i created 4 chat rooms under that service.
all were working fine and i was able to see then in the Pandion client and connect to each of the rooms.
HOWEVER when i came to work today i have notice that 2 out of the 4 room are missing from the list.
when i checked the server i saw that they are not shown under my service group.
i have tried to add them again and i got an error saying that there ID already in the database.
i checked the sql database and saw all the information about the groups there.
but it was not shown in the server configuration.
i have restarted the server using “openfire restart” but when the server came back
there were NO service groups at all !
but i can still see them in the mysql database.
how can i restore the missing service groups and chat rooms ?
it took me long time to set it all up and i wouldn’t want to spand a full day reentering the information
to the database with “new” names since the old ones are still there.