Announcement

Collapse
No announcement yet.

Postfix and Aliases -> Database error, tables doesnt exist

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Postfix and Aliases -> Database error, tables doesnt exist

    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=B..._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

  • #2
    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.

    Comment


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

      Silvio

      Comment

      Working...
      X