Mail home server - variable set?

german

#1

Hello,
When trying to set new value for user in Advanced Options - Mail Home Server the system complains “The value entered is not valid”

Questions:

             1)  From where  UCS is pulling  that value?
             2)  What is required to do to change/update  or add additional MAIL HOME SERVER to an user. 

Rolando Riley


#2

The value in that field should not be entered manually, but be one picked from the drop-down.
The drop-down list is populated from the list of mail domains in the Mail module (see chapter Management of mail domains in the manual).

Greetings
Daniel Tröder


#3

[quote]Several mail domains can be managed with UCS. The managed mail domains do not need to be the DNS domains of the server - they can be selected at will. The mail domains registered on a mail server are automatically saved in the Univention Configuration Registry variable mail/hosteddomains.

To ensure that external senders can also send e-mails to members of the domain, MX records must be created in the configuration of the authoritative name servers, which designate the UCS server as mail server for the domain. These DNS adjustments are generally performed by an Internet provider.

Mail domains are managed in the UMC module Mail with the Mail domain object type.[/quote]

Hello Daniel,
Thanks for the reading. Been adding Mail domain object, ucr mail/hosteddomains get updated but it doesn’t make any difference on the Mail Home Server selection attribute, it keeps coming empty. Can you please verify if on your systems works that way or maybe I am missing an additional step. Mail domain object seems to be a setting for the domain, but there should be an associated host name that needs to be set aswell on the module.

Rolando Riley


#4

Hello Rolando,

can you please check some things:
[ul][li] Have you installed the Mailserver app from the app center?

univention-app info dpkg -l univention-mail-server[/li]
[li] What UCS version is installed?

lsb_release -r

[li] Have all join scripts run successfully?

univention-run-join-scripts

[li] What is the output of:

udm mail/domain list univention-ldapsearch -LLL '(objectClass=univentionMailDomainname)'[/li][/ul]


#5

~# univention-app info UCS: 4.1-0 errata60 App Center compatibility: 4 Installed: kde=4 mailserver=10 nagios=3.4 oxseforucs=7.8.0-6-ucs2 samba4=4.3 Upgradable: oxseforucs

dpkg -l univention-mail-server Desired=Unknown/Install/Remove/Purge/Hold | Status=Not/Inst/Conf-files/Unpacked/halF-conf/Half-inst/trig-aWait/Trig-pend |/ Err?=(none)/Reinst-required (Status,Err: uppercase=bad) ||/ Name Version Architecture Description +++-==============-============-============-================================= ii univention-mai 10.0.0-11.27 all UCS - postfix configuration

root@mail:~# lsb_release -r Release: 4.1-0 errata60

[code]udm mail/domain list

DN: cn=airesistemas.com,cn=domain,cn=mail,dc=airesistemas,dc=com
ARG: None
name: airesistemas.com

DN: cn=mail.airesistemas.com,cn=domain,cn=mail,dc=airesistemas,dc=com
ARG: None
name: mail.airesistemas.com

[/code]

The bellow given command is pointing out to what it seems I am looking for oxImapServer attribute. This needs to be updated to mail.ariresistemas.com; How to do it?

root@mail:~# univention-ldapsearch -LLL '(objectClass=univentionMailDomainname)'dn: cn=airesistemas.com,cn=domain,cn=mail,dc=airesistemas,dc=com
oxImapServer: airesistemas.com
oxContextName: context10
cn: airesistemas.com
objectClass: top
objectClass: univentionMailDomainname
objectClass: oxMailDomainServerSettings
objectClass: univentionObject
univentionObjectType: oxmail/oxdomain

dn: cn=mail.airesistemas.com,cn=domain,cn=mail,dc=airesistemas,dc=com
objectClass: top
objectClass: univentionMailDomainname
objectClass: oxMailDomainServerSettings
objectClass: univentionObject
oxImapServer: mail.airesistemas.com
oxContextName: context10
univentionObjectType: oxmail/oxdomain
cn: mail.airesistemas.com
        univention-run-join-scripts  leaves a pending module pointing out to a mysql GRANT problem.  I faced this problem before last upgrade and was able to fix it with mysql --skip-grant-tables .      Having a hard time to do it now. Seems related to the new mysql  version passwd encryption.

ox-server-install: Checking for Open-Xchange context in LDAP... Existing context 'context10' will be re-used. ox-server-install: Checking MySQL credentials... ERROR 1045 (28000) at line 1: Access denied for user 'root'@'localhost' (using password: YES) ox-server-install: Failed to grant privileges on MySQL databases to user 'openexchange'. 65univention-ox.inst: Failed to setup new installation. EXITCODE=1

   65univention-ox  is the only module left behind pending due to this mysql problem.

Rolando Riley


#6

Please mention the next time, that you have a OX system!

Are you sure, that the OX Groupware is installed on the server mail.ariresistemas.com?

To change the UDM objects run:

udm oxmail/oxdomain modify --dn=cn=airesistemas.com,cn=domain,cn=mail,dc=airesistemas,dc=com --set oxImapServer=mail.airesistemas.com udm oxmail/oxdomain modify --dn=cn=mail.airesistemas.com,cn=domain,cn=mail,dc=airesistemas,dc=com --set oxImapServer=mail.airesistemas.com

Is mail.ariresistemas.com really a domain for which you host email? Are there users with an adress user@mail.ariresistemas.com? If not, you can remove that oxmail domain.

[quote=“rriley”]univention-run-join-scripts leaves a pending module pointing out to a mysql GRANT problem. I faced this problem before last upgrade and was able to fix it with mysql --skip-grant-tables . Having a hard time to do it now. Seems related to the new mysql version passwd encryption.

ox-server-install: Checking for Open-Xchange context in LDAP... Existing context 'context10' will be re-used. ox-server-install: Checking MySQL credentials... ERROR 1045 (28000) at line 1: Access denied for user 'root'@'localhost' (using password: YES) ox-server-install: Failed to grant privileges on MySQL databases to user 'openexchange'. 65univention-ox.inst: Failed to setup new installation. EXITCODE=1

65univention-ox is the only module left behind pending due to this mysql problem.[/quote]
The pasword in /etc/mysql.secret might be wrong. Please try the following:

[code]cat /etc/mysql.secret
mysql -u root -h localhost -p

enter password from /etc/mysql.secret[/code]


#7

MYSQL PROBLEM. Credentials are right, whe ox-server-install scripts reaches to the GRANT statement then the problems of acces denied pops up.

[code]root@mail:~# mysql -u root -h localhost -p$(cat /etc/mysql.secret)
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8356
Server version: 5.5.46-0.17.201512141630 (Univention)

Copyright © 2000, 2015, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

mysql>
[/code]

Domain object mail.airesistemas.com was created just for testin purposes for MAIL HOME SERVER; it will be removed. Will be executing the LDAP updating commands during the day and will revert back.

Rolando