Hi @fbartels,
sorry for not being precise, my fault.
The su part makes we wondering, are you actually referring the the system user or are you really speaking about the mysql/mariadb user?
I switched to kopano system user and accessed the mysql / maria DB access then with a kopano DB user. Using this access rights I could create a test table without any problems.
Attached my server.cfg extract:
##############################################################
# SERVER SETTINGS
# IP Address to bind to (empty for ANY)
# Set to ::1 or 127.0.0.1 if connections should only come from localhost
# and through the webserver proxy
server_bind = 172.16.1.19
# Accept normal TCP connections (not recommended to disable)
server_tcp_enabled = yes
# Port to bind to
server_tcp_port = 236
# Accept Unix pipe connections (not recommended to disable)
server_pipe_enabled = yes
# Unix socket location
server_pipe_name = /var/run/kopano/server.sock
# Priority Unix socket location
server_pipe_priority = /var/run/kopano/prio.sock
# Name for identifying the server in a multi-server environment
server_name = Kopano
# Override the hostname of this server, used by Kerberos SSO if enabled
server_hostname =
# Database engine (mysql)
database_engine = mysql
# Allow connections from normal users through the Unix socket
allow_local_users = yes
# local admin users who can connect to any store (use this for the kopano-dagent)
# field is SPACE separated
# eg: local_admin_users = root vmail
local_admin_users = root kopano
# The user has full rights on a folder by default, uncomment the following line to disable this.
# owner_auto_full_access = false
owner_auto_full_access = true
# e-mail address of the Kopano System user
system_email_address = postmaster@kopano.xxxxx
# drop privileges and run the process as this user
run_as_user = kopano
# drop privileges and run the process as this group
run_as_group = kopano
# create a pid file for stopping the service via the init.d scripts
pid_file = /var/run/kopano/server.pid
# run server in this path (when not using the -F switch)
#running_path = /var/lib/kopano
# Use given allocator library. Values like libtcmalloc.so.4,
# libtcmalloc_minimal.so.4 and libjemalloc.so.2 would work.
#allocator_library = default
# create memory coredumps upon crash [no, systemdefault, yes]
#coredump_enabled = systemdefault
# session timeout for clients. Values lower than 300 will be upped to 300
# automatically. If the server hears nothing from a client in session_timeout
# seconds, then the session is killed.
session_timeout = 300
# for temporary files
# consider mounting a `tmpfs' underneath this path (wherever you
# point it to)
tmp_path = /tmp
##############################################################
# MYSQL SETTINGS (for database_engine = mysql)
# MySQL hostname to connect to for database access
mysql_host = 127.0.0.1
# MySQL port to connect with (usually 3306)
mysql_port = 3306
# The user under which we connect with MySQL
mysql_user = kopano
# The password for the user (leave empty for no password)
mysql_password = xxxxxx
# Override the default MySQL socket to access mysql locally
# Works only if the mysql_host value is empty or 'localhost'
mysql_socket =
# Database to connect to
mysql_database = kopano
# Where to place attachments. Value can be 'database', 'files' or 's3'
attachment_storage = files
# Enable fsync as method to make sure attachments are stored on disk where
# supported and will not be buffered by OS and/or filesystem. Please note
# this setting will lower attachment write performance depending on your
# environment but enhances data safety with disaster recovery.
# Only affects 'files' attachment storage backend.
attachment_files_fsync = yes
# When attachment_storage is 'files', use this path to store the files
# When attachment_storage is 's3', use this path to set a prefix to all
# attachment data of a certain cluster, for example 'attach'
attachment_path = /var/lib/kopano/attachments
Thanks for your effort.
