Ein paar Fragen von einem Anfänger

[Antonio Lopez]

Hallo an alle,

ich habe folgendes installiert:

Debian Squeeze 6.0 (2.6.32-5-686-bigmem)
Dovecot 1.2.15
Postfix 2.7.1
amavis 2.6.4
Open-Xchange Server 6.20.0 Rev8

Spamassassin läuft über amavis und wird von Open Xchange benutzt, damit der User Spam markieren kann. Spamassassin lernt über die Ordner .confirmed-spam und .confirmed-ham

Desweiteren habe ich mir SQL-Views angelegt damit Postfix und Dovecot nicht separat mit Usern konfiguriert werden muss:

für die User:
CREATE VIEW virtual_users AS
select id,cid as domain_id,userpassword as password, imaplogin as email from oxdatabase_6.user;

für die Aliase:
create view virtual_aliases as
select user.id,user.cid as domain_id, user_attribute.value as source, user.imaplogin as destination from oxdatabase_6.user, oxdatabase_6.user_attribute where user.id=user_attribute.id and user.cid=user_attribute.cid and name="alias";


ACL Konfiguration in Dovecot habe ich ebenfalls erledigt. User können E-Mail Ordner freigeben, abonnieren usw.


Meine Fragen:

1) In welcher Datenbanktabelle kann ich den context (Mail-Domain) auslesen?

2) Was sollte ich für postfix und dovecot ausser den oben angegebenen Views (virtual_users, virtual_aliases) noch berücksichtigen?

3) Was muss ich tun damit bei der Anmeldung der User auswählen kann ob er an einem privaten oder öffentlichem PC sitzt (Anmeldefenster wie bei OXAE)?

4) Was muss ich konfigurieren damit beim Einstellungs-Assistent der Schritt "3. Kontakte veröffentlichen" angezeigt wird?

Besten Dank für Eure hoffentlich zahlreichen Antworten.

Mit freundlichem Gruß
Antonio López

[Martin Heiland]

Hallo Antonio,

1) In welcher Datenbanktabelle kann ich den context (Mail-Domain) auslesen?

Generell kann ein Kontext jeglichen Namen besitzen, es muss nicht zwangsläufig ein valider Domainname sein. Es handelt sich lediglich um ein Login-Mapping. Wenn das aber bei deiner Installation der Fall ist, kannst du den Kontextnamen aus der Tabelle configdb.login2context holen.

3) Was muss ich tun damit bei der Anmeldung der User auswählen kann ob er an einem privaten oder öffentlichem PC sitzt (Anmeldefenster wie bei OXAE)?

sessiond.properties

com.openexchange.sessiond.autologin=true

4) Was muss ich konfigurieren damit beim Einstellungs-Assistent der Schritt "3. Kontakte veröffentlichen" angezeigt wird?

Dieser Menüpunkt ist mit 6.20 aus Gründen der Übersicht entfernt worden, da Benutzer bei der Verwendung des Wizards meistens noch keine Kontaktordner haben die sie freigeben können. Das Freigeben ist nach wie vor per Rechtsklick auf Ordner -> Erweitert -> Veröffentlichen möglich.

Gruß

[Antonio Lopez]

Besten Dank für die Antworten!!!

Ich bin auf etwas gestossen, was mich verwirrt:


Ich habe gestern drei mal versucht eine komplette Neuinstallation zu machen (Debian 6.0 nach Anleitung auf der open-Xchange Website)

Jedes mal wenn ich damit fertig war und nachsehen wollte, welche DBs generiert wurden war anstelle einer oxdatabase_6 eine oxdatabase_5 vorhanden:

mysql
show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| configdb |
| mysql |
| oxdatabase_5 |
+--------------------+
4 rows in set (0.00 sec)

Ist das normal???

Hab ich irgendeinen Fehler gemacht???

Mit freundlichem Gruß
Antonio Lopez


---------

dpkg -l | grep open-xchange
ii open-xchange 6.20.0.0-8 Open-Xchange server scripts and configuration
ii open-xchange-activation 6.20.0.0-7 Bundled version of the Java Activation Framework
ii open-xchange-admin 6.20.0.0-7 Open Xchange Admin Daemon containing commandline tools and provisioning interface
ii open-xchange-admin-client 6.20.0.0-7 The Open Xchange Admin Daemon RMI client library
ii open-xchange-admin-doc 6.20.0.0-7 Documentation for the Open Xchange RMI client library.
ii open-xchange-admin-lib 6.20.0.0-7 The Open Xchange Admin Daemon Bundle client library
ii open-xchange-admin-plugin-hosting 6.20.0.0-7 Open Xchange Admin Hosting Plugin
ii open-xchange-admin-plugin-hosting-client 6.20.0.0-7 The Open Xchange Admin Hosting RMI client library
ii open-xchange-admin-plugin-hosting-doc 6.20.0.0-7 Documentation for the Open Xchange RMI client library.
ii open-xchange-admin-plugin-hosting-lib 6.20.0.0-7 The Open Xchange Admin Hosting Bundle client library
ii open-xchange-ajp 6.20.0.0-7 The Open-Xchange AJP bundle
ii open-xchange-authentication-database 6.20.0.0-7 The Open-Xchange Database Authentication
ii open-xchange-authorization-standard 6.20.0.0-7 Default Open-Xchange Authorization implementation
ii open-xchange-cache 6.20.0.0-7 The Open-Xchange Server Caching Bundle
ii open-xchange-calendar 6.20.0.0-7 Calendar Module
ii open-xchange-calendar-printing 6.20.0.0-7 Printing calendars via templating
ii open-xchange-charset 6.20.0.0-7 charset bundle
ii open-xchange-common 6.20.0.0-7 jar files and OSGi bundles commonly used by all open-xchange packages
ii open-xchange-config-cascade 6.20.0.0-7 The Open-Xchange Server Config Cascade Bundle
ii open-xchange-config-cascade-context 6.20.0.0-7 The Open-Xchange Server Config Cascade Bundle
ii open-xchange-config-cascade-user 6.20.0.0-7 The Open-Xchange Server Config Cascade Bundle
ii open-xchange-configread 6.20.0.0-7 The Open-Xchange Server Config Bundle
ii open-xchange-contactcollector 6.20.0.0-7 The contact collector collects eMail addresses in a custom contact folder
ii open-xchange-control 6.20.0.0-7 The Open-Xchange Server Control Bundle
ii open-xchange-conversion 6.20.0.0-7 The Open-Xchange Conversion Bundle
ii open-xchange-conversion-engine 6.20.0.0-7 The Open-Xchange Conversion Engine Bundle
ii open-xchange-conversion-servlet 6.20.0.0-7 The Open-Xchange Conversion Servlet
ii open-xchange-crypto 6.20.0.0-7 Provides cryptography services to bundles in the OX server
ii open-xchange-data-conversion-ical4j 6.20.0.0-7 The Open-Xchange data conversion iCal4j implementation
ii open-xchange-dataretention 6.20.0.0-7 The Open-Xchange Server Data Retention Bundle
ii open-xchange-file-storage 6.20.0.0-7 The Open-Xchange File Storage Bundle
ii open-xchange-file-storage-composition 6.20.0.0-7 The Open-Xchange File Storage Composition Bundle
ii open-xchange-file-storage-config 6.20.0.0-7 The Open-Xchange File Storage Config Bundle
ii open-xchange-file-storage-generic 6.20.0.0-7 The Open-Xchange File Storage Generic Bundle
ii open-xchange-file-storage-infostore 6.20.0.0-7 The Open-Xchange File Storage Infostore Bundle
ii open-xchange-file-storage-json 6.20.0.0-7 The Open-Xchange File Storage JSON Bundle
ii open-xchange-folder-json 6.20.0.0-7 The Open-Xchange folder JSON interface bundle
ii open-xchange-frontend-uwa 6.20.0.0-7 Management of UWA Widgets
ii open-xchange-frontend-uwa-json 6.20.0.0-7 The Open-Xchange File Storage JSON Bundle
ii open-xchange-genconf 6.20.0.0-7 The Open-Xchange Server Generic Configuration Bundle
ii open-xchange-genconf-mysql 6.20.0.0-7 Stores a set of generic options in the mysql database
ii open-xchange-global 6.20.0.0-8 global bundle
ii open-xchange-gui 6.20.0.0-8 Package containing the AJAX gui
ii open-xchange-gui-loading-theme-default 6.20.0.0-8 Package containing the default loading theme
ii open-xchange-gui-login-theme-default 6.20.0.0-8 Package containing the default login theme
ii open-xchange-gui-themes-default 6.20.0.0-8 Package containing the default themes
ii open-xchange-gui-wizard-plugin 6.20.0.0-7 Open-Xchange GUI Wizard Server Plug-In.
ii open-xchange-gui-wizard-plugin-gui 6.20.0.0-7 Open-Xchange GUI Wizard Plug-In.
ii open-xchange-html 6.20.0.0-7 The Open-Xchange HTML Bundle
ii open-xchange-i18n 6.20.0.0-7 The Open-Xchange i18n Bundle
ii open-xchange-imap 6.20.0.0-7 The Open-Xchange Server IMAP Bundle
ii open-xchange-jcharset 6.20.0.0-7 jcharset bundle
ii open-xchange-logging 6.20.0.0-7 The Open-Xchange Logging Configuration
ii open-xchange-management 6.20.0.0-7 The Open-Xchange Management Bundle
ii open-xchange-messaging 6.20.0.0-7 The Open-Xchange Messaging Bundle
ii open-xchange-messaging-facebook 6.20.0.0-7 The Open-Xchange Messaging Facebook Bundle
ii open-xchange-messaging-generic 6.20.0.0-7 The Open-Xchange Messaging Generic Bundle
ii open-xchange-messaging-json 6.20.0.0-7 The Open-Xchange Messaging JSON Bundle
ii open-xchange-messaging-rss 6.20.0.0-7 The Open-Xchange Messaging Facebook Bundle
ii open-xchange-messaging-twitter 6.20.0.0-7 The Open-Xchange Messaging Twitter Bundle
ii open-xchange-meta-admin 6.20.0.0-7 The Open-Xchange Meta package for User/Group Provisioning
ii open-xchange-meta-gui 6.20.0.0-7 The Open-Xchange Meta package for OX GUI
ii open-xchange-meta-messaging 6.20.0.0-7 The Open-Xchange Meta package for Messaging
ii open-xchange-meta-pubsub 6.20.0.0-7 The Open-Xchange Meta package for Publish and Subscribe
ii open-xchange-meta-server 6.20.0.0-7 The Open-Xchange Meta package for OX Backend
ii open-xchange-meta-singleserver 6.20.0.0-7 The Open-Xchange Meta package for OX on a single server
ii open-xchange-modules-json 6.20.0.0-7 The Open-Xchange generic JSON interface bundle
ii open-xchange-modules-model 6.20.0.0-7 Base classes for attribute based programming
ii open-xchange-modules-storage 6.20.0.0-7 Helper classes for common storage tasks
ii open-xchange-monitoring 6.20.0.0-7 The Open-Xchange Monitoring Bundle
ii open-xchange-oauth 6.20.0.0-7 OAuth Service
ii open-xchange-oauth-facebook 6.20.0.0-7 Facebook via OAuth for Open-Xchange Server 6
ii open-xchange-oauth-json 6.20.0.0-7 The Open-Xchange OAuth JSON interface bundle
ii open-xchange-oauth-linkedin 6.20.0.0-7 LinkedIn via OAuth for Open-Xchange Server 6
ii open-xchange-oauth-msn 6.20.0.0-1 WindowsLive / MSN via OAuth for Open-Xchange Server 6
ii open-xchange-oauth-twitter 6.20.0.0-7 Twitter via OAuth for Open-Xchange Server 6
ii open-xchange-online-help-de-de 6.20.0.0-7 Package containing german OX online help
ii open-xchange-online-help-en-us 6.20.0.0-7 Package containing english OX online help
ii open-xchange-online-help-fr-fr 6.20.0.0-7 Package containing french OX online help
ii open-xchange-pop3 6.20.0.0-7 The Open-Xchange Server POP3 Bundle
ii open-xchange-proxy 6.20.0.0-7 The Open-Xchange Proxy Bundle
ii open-xchange-proxy-servlet 6.20.0.0-7 The Open-Xchange Proxy Servlet Bundle
ii open-xchange-publish 6.20.0.0-7 Interfaces defining the OX publication API
ii open-xchange-publish-basic 6.20.0.0-7 Basic OSGi based implementation of the publication infrastructure
ii open-xchange-publish-infostore-online 6.20.0.0-7 Publishes a single infostore document externally
ii open-xchange-publish-json 6.20.0.0-7 HTTP-API Interface implementation for publication services
ii open-xchange-publish-microformats 6.20.0.0-7 Publishes a set of objects in OXMF externally
ii open-xchange-push 6.20.0.0-7 The Open-Xchange Push Bundle
ii open-xchange-push-udp 6.20.0.0-7 The Open-Xchange Server Push UDP Bundle
ii open-xchange-report-client 6.20.0.0-7 Open-Xchange reporting client.
ii open-xchange-secret 6.20.0.0-7 Creates plugin architecture for supplying the application with secret strings used for encryption and decryption.
ii open-xchange-secret-recovery 6.20.0.0-7 Recovery for saved encrypted strings when changing the secret.
ii open-xchange-secret-recovery-json 6.20.0.0-7 Recovery for saved encrypted strings when changing the secret in Mail Accounts.
ii open-xchange-secret-recovery-mail 6.20.0.0-7 Recovery for saved encrypted strings when changing the secret in Mail Accounts.
ii open-xchange-server 6.20.0.0-8 The Open-Xchange Server Bundle
ii open-xchange-sessiond 6.20.0.0-7 The Open-Xchange Server Session Daemon
ii open-xchange-settings-extensions 6.20.0.0-7 The Open-Xchange Settings Extensions
ii open-xchange-smtp 6.20.0.0-7 The Open-Xchange Server SMTP Bundle
ii open-xchange-spamhandler-default 6.20.0.0-7 The Open-Xchange Default Spam Handler
ii open-xchange-sql 6.20.0.0-7 SQL Builder API
ii open-xchange-subscribe 6.20.0.0-7 Basic OSGi based implementation of the subscription infrastructure
ii open-xchange-subscribe-crawler 6.20.0.0-7 Subscribe Crawler feeds
ii open-xchange-subscribe-facebook 6.20.0.0-7 Facebook Subscription Source for Open-Xchange Server 6
ii open-xchange-subscribe-json 6.20.0.0-7 HTTP-API Interface implementation for subscription services
ii open-xchange-subscribe-linkedin 6.20.0.0-7 LinkedIn Subscription Source for Open-Xchange Server 6
ii open-xchange-subscribe-microformats 6.20.0.0-7 Subscribe Microformat feeds
ii open-xchange-subscribe-msn 6.20.0.0-1 LinkedIn Subscription Source for Open-Xchange Server 6
ii open-xchange-templating 6.20.0.0-7 Provides access to the templating subsystem
ii open-xchange-templating-json 6.20.0.0-7 Provides access to template names via the HTTP-API
ii open-xchange-threadpool 6.20.0.0-7 The Open-Xchange Thread Pool Bundle
ii open-xchange-twitter 6.20.0.0-7 The Open-Xchange Twitter Bundle
ii open-xchange-tx 6.20.0.0-7 Transaction Services
ii open-xchange-unifiedinbox 6.20.0.0-7 The Open-Xchange Server Unified INBOX Bundle
ii open-xchange-user-json 6.20.0.0-7 The Open-Xchange user JSON interface bundle
ii open-xchange-xerces-sun 6.20.0.0-7 Xerces Compat for Sun Java
ii open-xchange-xml 6.20.0.0-7 XML Services

----

[Martin Heiland]

Hi,

die Zahl wird einfach vom Admindaemon hochgezählt. Das gilt für jeden Server, jeden Filestorage und jede Datenbank die hinzugefügt wird. Funktional hat das keine Auswirkung.

Gruß