View Issue Details

IDProjectCategoryView StatusLast Update
0004147SOGoOpenChange backendpublic2017-05-30 19:30
ReporterColmar0 Assigned Toludovic  
PrioritynormalSeverityminorReproducibilityalways
Status resolvedResolutionsuspended 
Platform16.04.2 LTSOSUbuntuOS Version16.04
Product Version3.2.8 
Summary0004147: Can not start apache2 and mysql start error with ocsmanager.conf configuration
Description

mysql does not start and apache2 get following error message after trying to start it:


Apr 13 15:29:50 sogo-test2 apache2[11330]: * The apache2 configtest failed.
Apr 13 15:29:50 sogo-test2 apache2[11330]: Output of config test was:
Apr 13 15:29:50 sogo-test2 apache2[11330]: AH00526: Syntax error on line 2 of /etc/apache2/conf-enabled/ocsmanager.conf:
Apr 13 15:29:50 sogo-test2 apache2[11330]: Invalid command 'debug', perhaps misspelled or defined by a module not included in the server configuration
Apr 13 15:29:50 sogo-test2 apache2[11330]: Action 'configtest' failed.
Apr 13 15:29:50 sogo-test2 apache2[11330]: The Apache error log may have more information.
Apr 13 15:29:50 sogo-test2 systemd[1]: apache2.service: Control process exited, code=exited status=1
Apr 13 15:29:50 sogo-test2 systemd[1]: Failed to start LSB: Apache2 web server.
Apr 13 15:29:50 sogo-test2 systemd[1]: apache2.service: Unit entered failed state.
Apr 13 15:29:50 sogo-test2 systemd[1]: apache2.service: Failed with result 'exit-code'.
root@sogo-test2:/etc/apache2# vim /etc/apache2/conf-enabled/ocsmanager.conf
root@sogo-test2:/etc/apache2# service apache2 restart
Job for apache2.service failed because the control process exited with error code. See "systemctl status apache2.service" and "journalctl -xe" for details.
root@sogo-test2:/etc/apache2#
root@sogo-test2:/etc/apache2# service apache2 status
? apache2.service - LSB: Apache2 web server
Loaded: loaded (/etc/init.d/apache2; bad; vendor preset: enabled)
Drop-In: /lib/systemd/system/apache2.service.d
??apache2-systemd.conf
Active: failed (Result: exit-code) since Do 2017-04-13 15:30:40 CEST; 3s ago
Docs: man:systemd-sysv-generator(8)
Process: 11528 ExecStart=/etc/init.d/apache2 start (code=exited, status=1/FAILURE)


Additional Information

ocsmanager.conf:
[DEFAULT]
debug = true
email_to = Bla.Test@augsburg.de
smtp_server = smtp.augsburg.de
error_email_from = paste@localhost
[main]
auth = ldap
mapistore_root = /var/lib/samba/private
mapistore_data = /var/lib/samba/private/mapistore
debug = yes
[auth:file]
[auth:ldap]
host = ldap://127.0.0.1
port = 389
bind_dn = CN=sogo,OU=Gaeste,DC=rz,DC=augsburg,DC=de
bind_pw = %1OpenChang
basedn = DC=rz,DC=augsburg,DC=de
username = openchange
password = 3aumro
[server:main]
use = egg:Paste–http
host = 127.0.0.1
port = 5000
protocol_version = HTTP/1.1
[app:main]
use = egg:ocsmanager
full_stack = true
static_files = true
cache_dir = %(here)s/data
beaker.session.key = ocsmanager
beaker.session.secret = SDyKK3dKyDgW0mlpqttTMGU1f
app_instance_uuid = {ee533ebc-f266-49d1-ae10-d017ee6aa98c}
NTLMAUTHHANDLER_WORKDIR = /var/cache/ntlmauthhandler
SAMBA_HOST = 127.0.0.1
[rpcproxy:ldap]
host = localhost
port = 389
basedn = DC=rz,DC=augsburg,DC=de
set debug = true

[autodiscover]
[autodiscover:rpcproxy]
enabled = true
[outofoffice]
[outofoffice:file]
sieve_script_path = /var/vmail/$domain/$user/sieve-script
sieve_script_path_mkdir = false
[outofoffice:managesieve]
secret = secret
[loggers]
keys = root
[handlers]
keys = console
[formatters]
keys = generic
[logger_root]
level = INFO
handlers = console
[handler_console]
class = StreamHandler
args = (sys.stderr,)
level = NOTSET
formatter = generic
[formatter_generic]
format = %(asctime)s %(levelname)-5.5s [%(name)s] [%(threadName)s] %(message)s


apache2.conf:

This is the main Apache server configuration file. It contains the

configuration directives that give the server its instructions.

See http://httpd.apache.org/docs/2.4/ for detailed information about

the directives and /usr/share/doc/apache2/README.Debian about Debian specific

hints.

#
#

Summary of how the Apache 2 configuration works in Debian:

The Apache 2 web server configuration in Debian is quite different to

upstream's suggested way to configure the web server. This is because Debian's

default Apache2 installation attempts to make adding and removing modules,

virtual hosts, and extra configuration directives as flexible as possible, in

order to make automating the changes and administering the server as easy as

possible.

It is split into several files forming the configuration hierarchy outlined

below, all located in the /etc/apache2/ directory:

#

/etc/apache2/

|-- apache2.conf

| `-- ports.conf

|-- mods-enabled

| |-- *.load

| `-- *.conf

|-- conf-enabled

| `-- *.conf

`-- sites-enabled

`-- *.conf

#
#

* apache2.conf is the main configuration file (this file). It puts the pieces

together by including all remaining configuration files when starting up the

web server.

#

* ports.conf is always included from the main configuration file. It is

supposed to determine listening ports for incoming connections which can be

customized anytime.

#

* Configuration files in the mods-enabled/, conf-enabled/ and sites-enabled/

directories contain particular configuration snippets which manage modules,

global configuration fragments, or virtual host configurations,

respectively.

#

They are activated by symlinking available configuration files from their

respective *-available/ counterparts. These should be managed by using our

helpers a2enmod/a2dismod, a2ensite/a2dissite and a2enconf/a2disconf. See

their respective man pages for detailed information.

#

* The binary is called apache2. Due to the use of environment variables, in

the default configuration, apache2 needs to be started/stopped with

/etc/init.d/apache2 or apache2ctl. Calling /usr/bin/apache2 directly will not

work with the default configuration.

Global configuration

#

#

ServerRoot: The top of the directory tree under which the server's

configuration, error, and log files are kept.

#

NOTE! If you intend to place this on an NFS (or otherwise network)

mounted filesystem then please read the Mutex documentation (available

at <URL:http://httpd.apache.org/docs/2.4/mod/core.html#mutex>);

you will save yourself a lot of trouble.

#

Do NOT add a slash at the end of the directory path.

#
#ServerRoot "/etc/apache2"

#

The accept serialization lock file MUST BE STORED ON A LOCAL DISK.

#
Mutex file:${APACHE_LOCK_DIR} default

#

PidFile: The file in which the server should record its process

identification number when it starts.

This needs to be set in /etc/apache2/envvars

#
PidFile ${APACHE_PID_FILE}

#

Timeout: The number of seconds before receives and sends time out.

#
Timeout 300

#

KeepAlive: Whether or not to allow persistent connections (more than

one request per connection). Set to "Off" to deactivate.

#
KeepAlive On

#

MaxKeepAliveRequests: The maximum number of requests to allow

during a persistent connection. Set to 0 to allow an unlimited amount.

We recommend you leave this number high, for maximum performance.

#
MaxKeepAliveRequests 100

#

KeepAliveTimeout: Number of seconds to wait for the next request from the

same client on the same connection.

#
KeepAliveTimeout 5

These need to be set in /etc/apache2/envvars

User ${APACHE_RUN_USER}
Group ${APACHE_RUN_GROUP}

#

HostnameLookups: Log the names of clients or just their IP addresses

e.g., www.apache.org (on) or 204.62.129.132 (off).

The default is off because it'd be overall better for the net if people

had to knowingly turn this feature on, since enabling it means that

each client request will result in AT LEAST one lookup request to the

nameserver.

#
HostnameLookups Off

ErrorLog: The location of the error log file.

If you do not specify an ErrorLog directive within a <VirtualHost>

container, error messages relating to that virtual host will be

logged here. If you do define an error logfile for a <VirtualHost>

container, that host's errors will be logged there and not here.

#
ErrorLog ${APACHE_LOG_DIR}/error.log

#

LogLevel: Control the severity of messages logged to the error_log.

Available values: trace8, ..., trace1, debug, info, notice, warn,

error, crit, alert, emerg.

It is also possible to configure the log level for particular modules, e.g.

"LogLevel info ssl:warn"

#
LogLevel warn

Include module configuration:

IncludeOptional mods-enabled/.load
IncludeOptional mods-enabled/
.conf

Include list of ports to listen on

Include ports.conf

Sets the default security model of the Apache2 HTTPD server. It does

not allow access to the root filesystem outside of /usr/share and /var/www.

The former is used by web applications packaged in Debian,

the latter may be used for local directories served by the web server. If

your system is serving content from a sub-directory in /srv you must allow

access here, or in any related virtual host.

<Directory />
Options FollowSymLinks
AllowOverride None
Require all denied
</Directory>

<Directory /usr/share>
AllowOverride None
Require all granted
</Directory>

<Directory /var/www/>
Options Indexes FollowSymLinks
AllowOverride None
Require all granted
</Directory>

#<Directory /srv/>

Options Indexes FollowSymLinks

AllowOverride None

Require all granted

#</Directory>

AccessFileName: The name of the file to look for in each directory

for additional configuration directives. See also the AllowOverride

directive.

#
AccessFileName .htaccess

#

The following lines prevent .htaccess and .htpasswd files from being

viewed by Web clients.

#
<FilesMatch "^.ht">
Require all denied
</FilesMatch>

#

The following directives define some format nicknames for use with

a CustomLog directive.

#

These deviate from the Common Log Format definitions in that they use %O

(the actual bytes sent including headers) instead of %b (the size of the

requested file), because the latter makes it impossible to detect partial

requests.

#

Note that the use of %{X-Forwarded-For}i instead of %h is not recommended.

Use mod_remoteip instead.

#
LogFormat "%v:%p %h %l %u %t \"%r\" %>s %O \"%{Referer}i\" \"%{User-Agent}i\"" vhost_combined
LogFormat "%h %l %u %t \"%r\" %>s %O \"%{Referer}i\" \"%{User-Agent}i\"" combined
LogFormat "%h %l %u %t \"%r\" %>s %O" common
LogFormat "%{Referer}i -> %U" referer
LogFormat "%{User-agent}i" agent

Include of directories ignores editors' and dpkg's backup files,

see README.Debian for details.

Include generic snippets of statements

IncludeOptional conf-enabled/*.conf

Include the virtual host configurations:

IncludeOptional sites-enabled/*.conf

vim: syntax=apache ts=4 sw=4 sts=4 sr noet


SOGo.conf:

Alias /SOGo.woa/WebServerResources/ \
/usr/lib/GNUstep/SOGo/WebServerResources/
Alias /SOGo/WebServerResources/ \
/usr/lib/GNUstep/SOGo/WebServerResources/

<Directory /usr/lib/GNUstep/SOGo/>
AllowOverride None

&lt;IfVersion &lt; 2.4>      
    Order deny,allow
    Allow from all
&lt;/IfVersion>
&lt;IfVersion >= 2.4>
    Require all granted
&lt;/IfVersion>

# Explicitly allow caching of static content to avoid browser specific behavior.
# A resource's URL MUST change in order to have the client load the new version.
&lt;IfModule expires_module>
  ExpiresActive On
  ExpiresDefault &quot;access plus 1 year&quot;
&lt;/IfModule>

</Directory>

Uncomment the following to enable proxy-side authentication, you will then

need to set the "SOGoTrustProxyAuthentication" SOGo user default to YES and

adjust the "x-webobjects-remote-user" proxy header in the "Proxy" section

below.

#

For full proxy-side authentication:

#<Location /SOGo>

AuthType XXX

Require valid-user

SetEnv proxy-nokeepalive 1

Allow from all

#</Location>
#

For proxy-side authentication only for CardDAV and GroupDAV from external

clients:

#<Location /SOGo/dav>

AuthType XXX

Require valid-user

SetEnv proxy-nokeepalive 1

Allow from all

#</Location>

ProxyRequests Off

ProxyRequests On

SetEnv proxy-nokeepalive 1

ProxyPreserveHost On

When using CAS, you should uncomment this and install cas-proxy-validate.py

in /usr/lib/cgi-bin to reduce server overloading

#

ProxyPass /SOGo/casProxy http://localhost/cgi-bin/cas-proxy-validate.py

<Proxy http://localhost/app/cas-proxy-validate.py>

Order deny,allow

Allow from your-cas-host-addr

</Proxy>

ProxyPass /SOGo http://127.0.0.1:20000/SOGo retry=0

Enable to use Microsoft ActiveSync support

Note that you MUST have many sogod workers to use ActiveSync.

See the SOGo Installation and Configuration guide for more details.

#

ProxyPass /Microsoft-Server-ActiveSync \

http://127.0.0.1:20000/SOGo/Microsoft-Server-ActiveSync \

retry=60 connectiontimeout=5 timeout=360

<Proxy http://127.0.0.1:20000/SOGo>

adjust the following to your configuration

RequestHeader set "x-webobjects-server-port" "443"

RequestHeader set "x-webobjects-server-name" "sogo-test2.rz.augsburg.de"

RequestHeader set "x-webobjects-server-url" "https://sogo-test2.rz.augsburg.de&quot;

When using proxy-side autentication, you need to uncomment and

adjust the following line:

RequestHeader unset "x-webobjects-remote-user"

RequestHeader set "x-webobjects-remote-user" "%{REMOTE_USER}e" env=REMOTE_USER

RequestHeader set "x-webobjects-server-protocol" "HTTP/1.0"

AddDefaultCharset UTF-8

Order allow,deny

Allow from all

</Proxy>

For Apple autoconfiguration

<IfModule rewrite_module>
RewriteEngine On
RewriteRule ^/.well-known/caldav/?$ /SOGo/dav [R=301]
</IfModule>

TagsNo tags attached.

Activities

ludovic

ludovic

2017-04-13 14:18

administrator   ~0011716

Don't use OpenChange - it is likely set to be removed from SOGo.

Colmar0

Colmar0

2017-04-13 14:21

reporter   ~0011717

Is there any official statement about this?

ludovic

ludovic

2017-04-13 14:23

administrator   ~0011718

It was discussed in the mailing list a couple of weeks go.

Colmar0

Colmar0

2017-04-13 14:36

reporter   ~0011721

Who was discussing it?
A discussion between the development or only user discussion?
What is the motivation of is discussion?

ludovic

ludovic

2017-04-13 14:39

administrator   ~0011722

https://lists.inverse.ca/sogo/arc/users/2017-03/msg00158.html

Colmar0

Colmar0

2017-04-13 14:42

reporter   ~0011723

This discussion seems to be between the sogo users.

ludovic

ludovic

2017-04-13 15:18

administrator   ~0011724

I am involved in that discussion.

ludovic

ludovic

2017-05-30 19:30

administrator   ~0011859

OpenChange is dead - setting for removal from SOGo.

Issue History

Date Modified Username Field Change
2017-04-13 14:12 Colmar0 New Issue
2017-04-13 14:18 ludovic Note Added: 0011716
2017-04-13 14:21 Colmar0 Note Added: 0011717
2017-04-13 14:23 ludovic Note Added: 0011718
2017-04-13 14:36 Colmar0 Note Added: 0011721
2017-04-13 14:39 ludovic Note Added: 0011722
2017-04-13 14:42 Colmar0 Note Added: 0011723
2017-04-13 15:18 ludovic Note Added: 0011724
2017-05-30 19:30 ludovic Note Added: 0011859
2017-05-30 19:30 ludovic Status new => resolved
2017-05-30 19:30 ludovic Resolution open => suspended
2017-05-30 19:30 ludovic Assigned To => ludovic