Announcement

**xiao** · 08-03-2007, 07:30 PM

Originally posted by Martin Braun View Post

did you also tried /var/lib/cyrus/? I'm sorry but i have to guess because it worked for me perfectly :/

ok, martin thans, the error occurred because it uses cyrus-imap in his version in testing and apparently it has failures of permissions in the data bases….

**xiao** · 08-03-2007, 08:37 PM

hi, boys I have another problem, I cannot send mails; here I put to them what I found in my logs:

mail.log:

Code:

Aug  3 13:32:27 localhost cyrus/master[29482]: about to exec /usr/lib/cyrus/bin/imapd
Aug  3 13:32:27 localhost cyrus/imap[29482]: executed
Aug  3 13:32:27 localhost cyrus/imap[29482]: accepted connection
Aug  3 13:32:27 localhost cyrus/master[29483]: about to exec /usr/lib/cyrus/bin/imapd
Aug  3 13:32:27 localhost cyrus/imap[29483]: executed
Aug  3 13:32:27 localhost cyrus/imap[29483]: accepted connection
Aug  3 13:32:27 localhost cyrus/master[29484]: about to exec /usr/lib/cyrus/bin/imapd
Aug  3 13:32:27 localhost cyrus/imap[29484]: executed
Aug  3 13:32:27 localhost cyrus/imap[29484]: accepted connection
Aug  3 13:32:27 localhost cyrus/imap[29482]: login: localhost [127.0.0.1] leonardof plaintext User logged in
Aug  3 13:32:27 localhost cyrus/imap[29483]: login: localhost [127.0.0.1] leonardof plaintext User logged in
Aug  3 13:32:27 localhost cyrus/imap[29483]: seen_db: user leonardof opened /var/lib/cyrus/user/l/leonardof.seen
Aug  3 13:32:27 localhost cyrus/imap[29483]: open: user leonardof opened INBOX
Aug  3 13:32:27 localhost cyrus/imap[29484]: login: localhost [127.0.0.1] leonardof plaintext User logged in
Aug  3 13:32:39 localhost postfix/smtpd[29506]: fatal: restriction class `local_only' needs a definition
Aug  3 13:32:40 localhost postfix/master[3205]: warning: process /usr/lib/postfix/smtpd pid 29506 exit status 1
Aug  3 13:32:40 localhost postfix/master[3205]: warning: /usr/lib/postfix/smtpd: bad command startup -- throttling

mail.info:

Code:

Aug  3 13:32:27 localhost cyrus/imap[29482]: login: localhost [127.0.0.1] leonardof plaintext User logged in
Aug  3 13:32:27 localhost cyrus/imap[29483]: login: localhost [127.0.0.1] leonardof plaintext User logged in
Aug  3 13:32:27 localhost cyrus/imap[29484]: login: localhost [127.0.0.1] leonardof plaintext User logged in
Aug  3 13:32:39 localhost postfix/smtpd[29506]: fatal: restriction class `local_only' needs a definition
Aug  3 13:32:40 localhost postfix/master[3205]: warning: process /usr/lib/postfix/smtpd pid 29506 exit status 1
Aug  3 13:32:40 localhost postfix/master[3205]: warning: /usr/lib/postfix/smtpd: bad command startup -- throttling

mail.err:

Code:

Aug  3 13:31:38 localhost postfix/smtpd[29433]: fatal: restriction class `local_only' needs a definition
Aug  3 13:32:39 localhost postfix/smtpd[29506]: fatal: restriction class `local_only' needs a definition

and mail.warn:

Code:

Aug  3 13:32:39 localhost postfix/smtpd[29506]: fatal: restriction class `local_only' needs a definition
Aug  3 13:32:40 localhost postfix/master[3205]: warning: process /usr/lib/postfix/smtpd pid 29506 exit status 1
Aug  3 13:32:40 localhost postfix/master[3205]: warning: /usr/lib/postfix/smtpd: bad command startup -- throttling

**xiao** · 08-06-2007, 02:49 PM

hello friends, umm nobody can help me? it is that he is urgent.

**Martin Heiland** · 08-06-2007, 03:06 PM

Hi,

Aug 3 13:32:39 localhost postfix/smtpd[29506]: fatal: restriction class `local_only' needs a definition

seems you postfix setup is a bit broken, would you please post the main.cf file?
local_only = check_recipient_access mysql:/etc/postfix/ox_domains.cf, reject
should be present.

**xiao** · 08-06-2007, 03:20 PM

Originally posted by Martin Braun View Post

Hi,

Aug 3 13:32:39 localhost postfix/smtpd[29506]: fatal: restriction class `local_only' needs a definition

seems you postfix setup is a bit broken, would you please post the main.cf file?
local_only = check_recipient_access mysql:/etc/postfix/ox_domains.cf, reject
should be present.

if this present, watches:

Code:

mailbox_transport = lmtp:unix:/var/run/cyrus/socket/lmtp
virtual_alias_domains = mysql:/etc/postfix/ox_domains.cf
virtual_alias_maps = mysql:/etc/postfix/ox_user_aliases.cf, mysql:/etc/postfix/ox_aliases.cf, mysql:/etc/postfix/ox_resource_aliases.cf, mysql:/etc/postfix/ox_group_aliases.cf
smtpd_sender_restrictions = check_sender_access mysql:/etc/postfix/ox_externaldomaincheck.cf
[COLOR="Blue"]smtpd_restriction_classes = local_only local_only = check_recipient_access mysql:/etc/postfix/ox_domains.cf, reject[/COLOR]
smtpd_recipient_restrictions = check_sender_access mysql:/etc/postfix/ox_senderrestrictions.cf, permit_sasl_authenticated, permit_mynetworks, reject_unauth_destination

**Martin Heiland** · 08-06-2007, 03:24 PM

Please enter a linebreak:
smtpd_restriction_classes = local_only
local_only = check_recipient_access mysql:/etc/postfix/ox_domains.cf, reject

this is my main.cf:

Code:

smtpd_banner = $myhostname - ESMTP Service
mailbox_transport = lmtp:unix:/var/run/cyrus/socket/lmtp

virtual_alias_domains = mysql:/etc/postfix/ox_domains.cf
virtual_alias_maps = mysql:/etc/postfix/ox_user_aliases.cf, mysql:/etc/postfix/ox_aliases.cf, mysql:/etc/postfix/ox_resource_aliases.cf, mysql:/etc/postfix/ox_group_aliases.cf

smtpd_sender_restrictions = check_sender_access mysql:/etc/postfix/ox_externaldomaincheck.cf
smtpd_restriction_classes = local_only
local_only = check_recipient_access mysql:/etc/postfix/ox_domains.cf, reject

smtpd_recipient_restrictions = check_sender_access mysql:/etc/postfix/ox_senderrestrictions.cf, permit_sasl_authenticated, permit_mynetworks, reject_unauth_destination
smtpd_tls_cert_file = /etc/ssl/certs/eecert.pem
smtpd_tls_key_file = /etc/ssl/private/eekey.pem
procmail_destination_concurrency_limit = 1
procmail_destination_recipient_limit = 1
maximal_queue_lifetime = 1d
alias_maps = $alias_database
bounce_queue_lifetime = 1d

**xiao** · 08-06-2007, 03:44 PM

Originally posted by Martin Braun View Post

Please enter a linebreak:
smtpd_restriction_classes = local_only
local_only = check_recipient_access mysql:/etc/postfix/ox_domains.cf, reject

friend hears, comparing in my main.cf I do not have this commented line

maximal_queue_lifetime = 1d
alias_maps = $alias_database
bounce_queue_lifetime = 1d

I must comment?

**Martin Heiland** · 08-06-2007, 03:51 PM

I'm not sure, i've added those to get the mailqueue empty after 1 day if a mail cannot be sent to the recipient. But it worked without the parameters, does it work for you now?

**xiao** · 08-06-2007, 04:03 PM

Originally posted by Martin Braun View Post

I'm not sure, i've added those to get the mailqueue empty after 1 day if a mail cannot be sent to the recipient. But it worked without the parameters, does it work for you now?

thanks Martin, Now work no longer I see in log of error the message of the restriction, but it seems that shipment the mail but does not arrive at another user of he himself servant from open-xchange, you can help me?

**pedro** · 08-07-2007, 09:47 PM

OS changed but

O.k !!

Since friday I've been working in change my OS, from CentOS to Ubuntu 6.06 Server.

I followed the instalation guide (http://wiki.open-xchange.com/wiki/in...e_Installation) without problems but when I tried to add the first user, i got the following message a deal =\.

Code:

root@mailt:~# /etc/init.d/open-xchange-admin start
Starting Open-Xchange Admin Daemon: open-xchange-admin.
root@mailt:~# /opt/open-xchange/sbin/createuser -A oxadmin -P "******" --username alan_turing --displayname "Alan Turing" --password 3nIgm4 --email alan_turing@bletchleypark.invalid --givenname Alan --surname Turing --language en_US --timezone Europe/London --department Decryption --company "Bletchley Park" -c 1
user in context 1 could not be created:
java.lang.NullPointerException
        at com.openexchange.database.Database.get(Database.java:111)
        at com.openexchange.server.DBPool.pickupWriteable(DBPool.java:75)
        at com.openexchange.admin.storage.sqlStorage.OXAdminPoolDBPool.getWRITEConnectionForCONFIGDB(OXAdminPoolDBPool.java:102)
        at com.openexchange.admin.tools.AdminCache.getWRITEConnectionForCONFIGDB(AdminCache.java:185)
        at com.openexchange.admin.storage.mysqlStorage.OXToolMySQLStorage.selectwithint(OXToolMySQLStorage.java:1850)
        at com.openexchange.admin.storage.mysqlStorage.OXToolMySQLStorage.existsContext(OXToolMySQLStorage.java:160)
        at com.openexchange.admin.rmi.impl.BasicAuthenticator.doAuthentication(BasicAuthenticator.java:129)
        at com.openexchange.admin.rmi.impl.OXUser.create(OXUser.java:383)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:305)
        at sun.rmi.transport.Transport$1.run(Transport.java:159)
        at java.security.AccessController.doPrivileged(Native Method)
        at sun.rmi.transport.Transport.serviceCall(Transport.java:155)
        at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:535)
        at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(TCPTransport.java:790)
        at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:649)
        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:885)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907)
        at java.lang.Thread.run(Thread.java:619)
        at sun.rmi.transport.StreamRemoteCall.exceptionReceivedFromServer(StreamRemoteCall.java:255)
        at sun.rmi.transport.StreamRemoteCall.executeCall(StreamRemoteCall.java:233)
        at sun.rmi.server.UnicastRef.invoke(UnicastRef.java:142)
        at java.rmi.server.RemoteObjectInvocationHandler.invokeRemoteMethod(RemoteObjectInvocationHandler.java:178)
        at java.rmi.server.RemoteObjectInvocationHandler.invoke(RemoteObjectInvocationHandler.java:132)
        at $Proxy0.create(Unknown Source)
        at com.openexchange.admin.console.user.Create.maincall(Create.java:110)
        at com.openexchange.admin.console.user.CreateCore.commonfunctions(CreateCore.java:116)
        at com.openexchange.admin.console.user.Create.<init>(Create.java:83)
        at com.openexchange.admin.console.user.Create.main(Create.java:74)
root@mailt:~#

I really don't know what to do!!

Thanks ,
Pedro Gustavo

**Martin Heiland** · 08-08-2007, 12:28 AM

I would encourage you to open a new thread for that problem, this is getting very messy

Greetings

**xiao** · 08-08-2007, 07:45 PM

Originally posted by xiao View Post

thanks Martin, Now work no longer I see in log of error the message of the restriction, but it seems that shipment the mail but does not arrive at another user of he himself servant from open-xchange, you can help me?

please, you can help me?

**Martin Heiland** · 08-08-2007, 08:07 PM

any logfiles? mail.*? syslog?

**xiao** · 08-08-2007, 09:30 PM

Originally posted by Martin Braun View Post

any logfiles? mail.*? syslog?

this is my mail.info

Code:

Aug  8 14:22:07 localhost postfix/smtp[4026]: connect to Servidor3.servioptica.sv.tc[212.163.58.71]: Connection timed out (port 25)
Aug  8 14:22:08 localhost postfix/smtp[4026]: 2EBA420214: to=<root@Servidor3.servioptica.sv.tc>, orig_to=<root>, relay=none, delay=428705, delays=428674/1/30/0, dsn=4.4.1, status=deferred (connect to Servidor3.servioptica.sv.tc[212.163.58.71]: Connection timed out)
Aug  8 14:26:35 localhost postfix/qmgr[4006]: 8789F201C9: from=<>, size=2673, nrcpt=1 (queue active)
Aug  8 14:26:44 localhost cyrus/imap[4905]: login: localhost [127.0.0.1] leonardof plaintext User logged in
Aug  8 14:26:44 localhost cyrus/imap[4915]: login: localhost [127.0.0.1] leonardof plaintext User logged in
Aug  8 14:26:46 localhost cyrus/imap[4915]: skiplist: recovered /var/lib/cyrus/user/l/leonardof.seen (2 records, 2708 bytes) in 0 seconds
Aug  8 14:26:46 localhost cyrus/imap[4905]: login: localhost [127.0.0.1] leonardof plaintext User logged in
Aug  8 14:26:46 localhost cyrus/imap[4923]: login: localhost [127.0.0.1] leonardof plaintext User logged in
Aug  8 14:27:05 localhost postfix/smtp[4898]: connect to Servidor3.SERVIOPTICA.sv.tc[212.163.58.71]: Connection timed out (port 25)
Aug  8 14:27:05 localhost postfix/smtp[4898]: 8789F201C9: to=<root@Servidor3.SERVIOPTICA.sv.tc>, relay=none, delay=3204, delays=3174/0.11/30/0, dsn=4.4.1, status=deferred (connect to Servidor3.SERVIOPTICA.sv.tc[212.163.58.71]: Connection timed out)

this is my log. amm in addition I believe that something walks bad with the name of my servant of mail since direction IP publishes to which is connected according to log is not mine… which I will have done badly?

and this it is my mail.log

Code:

Aug  8 14:32:30 localhost cyrus/imap[5558]: open: user leonardof opened INBOX/Sent Items
Aug  8 14:32:30 localhost postfix/error[5568]: 04FFE201B9: to=<manelly@servioptica.sv.tc>, relay=none, delay=0.11, delays=0.07/0.01/0/0.03, dsn=5.0.0, status=bounced (User unknown in virtual alias table)
Aug  8 14:32:30 localhost postfix/cleanup[5513]: 26BB32022B: message-id=<20070808193230.26BB32022B@mail.servioptica.sv.tc>
Aug  8 14:32:30 localhost cyrus/imap[5558]: seen_db: user leonardof opened /var/lib/cyrus/user/l/leonardof.seen
Aug  8 14:32:30 localhost postfix/bounce[5569]: 04FFE201B9: sender non-delivery notification: 26BB32022B
Aug  8 14:32:30 localhost postfix/qmgr[4006]: 26BB32022B: from=<>, size=3551, nrcpt=1 (queue active)
Aug  8 14:32:30 localhost cyrus/imap[5558]: open: user leonardof opened INBOX/Sent Items
Aug  8 14:32:30 localhost postfix/qmgr[4006]: 04FFE201B9: removed
Aug  8 14:32:31 localhost postfix/error[5568]: 26BB32022B: to=<leonardof@servioptica.sv.tc>, orig_to=<leonardof.sistemas@servioptica.sv.tc>, relay=none, delay=1.3, delays=0.1/0/0/1.2, dsn=5.0.0, status=bounced (User unknown in virtual alias table)
Aug  8 14:32:31 localhost postfix/qmgr[4006]: 26BB32022B: removed

**Martin Heiland** · 08-08-2007, 11:20 PM

Hi,

as it seems, there is something wrong with the virtual alias mapping

Code:

Aug  8 14:32:31 localhost postfix/error[5568]: 26BB32022B: to=<leonardof@servioptica.sv.tc>, orig_to=<leonardof.sistemas@servioptica.sv.tc>, relay=none, delay=1.3, delays=0.1/0/0/1.2, dsn=5.0.0, status=bounced (User unknown in virtual alias table)

As i see from the logs your mailserver of the OX machine is running with hostname "servidor3.servioptica.sv.tc" but you try to sent as "leonardof@servioptica.sv.tc" which leads to a error because the servidor3. stuff is missing. That means that the SMTP Server declines that mail and that it does not get into the mailqueue (=not being sent). Would you explain that mail setup in detail or am i right?

In human speech:
Client (OX): Hey mailserver, i am leonardof@servioptica.sv.tc and i want to sent a mail to someone.
Server (SMTP) checks for that mail address at the ox database and does not find "leonardof@servioptica.sv.tc" because the entry says "leonardof@servidor3.servioptica.sv.tc"
Server (SMTP): No way dude, you're not a valid user.

This may be fixed by adding the correct mail address to the "user" table of the open-xchange-db. Just do a "select * from user where id=4 \G;" to check whats set to the "mail" field.

Announcement

Adding frst user problem

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment