Homepage | Products | OX Knowledge Base | Support | Try Now | Contact | Company
OX Logo
Results 1 to 3 of 3
  1. #1
    Join Date
    May 2010
    Location
    Ilmenau
    Posts
    51

    Default 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. #2
    Carsten Hoeger is offline Open-Xchange Professional Services
    Join Date
    Mar 2007
    Posts
    703

    Default

    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.
    OXpedia.org - the answer to almost all questions.

  3. #3
    Join Date
    May 2010
    Location
    Ilmenau
    Posts
    51

    Default

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

    Silvio

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •