Recover/Recreate completely missing Mailbox Database

Question

Is there any possibility to change or add a prefix for user table in Ejabberd database.

My requirement is, I want to user authentication ( using php ) via my own database ( pgsql ). Using external auth settings I have managed to do that. Same as I would like to save all my chat related data on that same DB. ( Not saving inside Ejabberd ). But I already have a user credential table, unfortunately it is not "users" and I can not change it.

I am thinking if I will change the Ejabberd "users" table reference into my DB's user data table name, I could use "external" database settings for authenticate and storing.

If I need to do some changes and rebuild the source code, where and what are the correct changes I should add or update into source code. I try to understand with reading the Ejabberd source base but I could not find any clue ( Of course I am newby to Erlang and Ejabberd )

If anybody has good sofisticate idea or solution please update me.

Solution

I would just wipe the server and start over again. Otherwise you're in for a long day (and calls with Microsoft) trying to get Exchange to behave.

Comments

[gparent]

Wouldn't it be easier to restore from backups and go from there? Are you doing this on your live environment without ever having tested it before?

[Robbietjuh]

Unfortunately I can't test this anymore now as we decided to just nuke the machine and start over with a fresh install. However, we were missing the entire database - not just a single mailbox. I'm not sure as I can't replicate right now, but it looks like you're just recreating the mailboxes - not the entire database. Thanks for your answer and effort, though!

[Jeremy Lyons]

You said it was the existence of the mailbox preventing you from proceeding with the uninstall. Are you also rebuilding AD? If not, it's still there. You'll have to use adsiedit to remove it from Configuration > Services > Microsoft Exchange > ORG_NAME > Administrative Groups > Exchange Administrative Group (FYDIBOHF23SPDLT) > Databases. When you delete it here, it's deleted from Exchange. That will leave you with orphaned system mailboxes though, for which you'll have to follow the instructions above to recreate.

[Umanda]

That is what I am using. @Badlop I am using "external" auth ( extauth_program: some php file connect with my DB as document explaining ) . And I am using "sql_type" as my DB with ejabberd database schema. but once I change the table name, client can not authenticate. And when I create users it won't show in Admin section. where I went wrong ?