Postfix and Aliases -> Database error, tables doesnt exist

[silvio]

Ive installed postfix and want to reade the aliases from the ox database.
The wiki has an nice howto i think the ox databese has changed:

http://oxpedia.org/index.php?title=Basic_Mail_Setup_CentOS5

In my maillog i can see a lot of errors like this:

Dec 10 10:44:02 ox postfix/trivial-rewrite[3014]: warning: mysql query failed: Table 'oxdatabase_6.address_mappings' doesn't exist
Dec 10 10:44:02 ox postfix/trivial-rewrite[3014]: fatal: mysql:/etc/postfix/ox_aliases.cf(0,lock|fold_fix): table lookup problem

Next step, look into the database:

mysql> show tables;
+--------------------------------------+
| Tables_in_oxdatabase_6 |
+--------------------------------------+
| dateExternal |
| delDateExternal |
| del_attachment |
| del_contacts |
| del_contacts_image |
| del_date_rights |
| del_dates |
| del_dates_members |
| del_dlist |
| del_groups |
| del_infostore |
| del_infostore_document |
| del_oxfolder_permissions |
| del_oxfolder_tree |
| del_resource |
| del_task |
| del_task_eparticipant |
| del_task_folder |
| del_task_participant |
| del_user |
| filestore_usage |
| genconf_attributes_bools |
| genconf_attributes_strings |
| groups |
| groups_member |
| ical_ids |
| ical_principal |
| infostore |
| infostoreReservedPaths |
| infostore_document |
| infostore_lock |
| infostore_property |
| lock_null |
| lock_null_lock |
| login2user |
| messagingAccount |
| oxfolder_lock |
| oxfolder_permissions |
| oxfolder_property |
| oxfolder_specialfolders |
| oxfolder_tree |
| oxfolder_userfolders |
| oxfolder_userfolders_standardfolders |
| pop3_storage_deleted |
| pop3_storage_ids |
| prg_attachment |
| prg_contacts |
| prg_contacts_image |
| prg_contacts_linkage |
| prg_date_rights |
| prg_dates |
| prg_dates_members |
| prg_dlist |
| prg_links |
| publication_users |
| publications |
| reminder |
| replicationMonitor |
| resource |
| sequence_attachment |
| sequence_calendar |
| sequence_contact |
| sequence_folder |
| sequence_forum |
| sequence_genconf |
| sequence_gid_number |
| sequence_gui_setting |
| sequence_ical |
| sequence_id |
| sequence_infostore |
| sequence_mail_service |
| sequence_pinboard |
| sequence_principal |
| sequence_project |
| sequence_publications |
| sequence_reminder |
| sequence_resource |
| sequence_resource_group |
| sequence_subscriptions |
| sequence_task |
| sequence_uid_number |
| sequence_webdav |
| subscriptions |
| task |
| task_eparticipant |
| task_folder |
| task_participant |
| task_removedparticipant |
| updateTask |
| user |
| user_attribute |
| user_configuration |
| user_mail_account |
| user_mail_account_properties |
| user_setting |
| user_setting_admin |
| user_setting_mail |
| user_setting_mail_signature |
| user_setting_server |
| user_setting_spellcheck |
| user_transport_account |
| user_transport_account_properties |
| vcard_ids |
| vcard_principal |
| virtualBackupPermission |
| virtualBackupSubscription |
| virtualBackupTree |
| virtualPermission |
| virtualSubscription |
| virtualTree |
+--------------------------------------+

Ok, the adress_mappings, mail_domains and user_mail_restrictions tables doesnt exist.

My question is, has OX changed the database design or do i need a package to resolve the problem?


Silvio

[Carsten Hoeger]

Yes, these tables had been introduced for a product which is no longer maintained and thus had been removed.
I added a note to the article http://oxpedia.org/index.php?title=B..._Setup_CentOS5 that it describes an outdated version of open-xchange.

[silvio]

Thanks for the answer.
Can you give me a hint where i now can find mappings for resources and groups.

Silvio