[kdepim-users] Akonadi stops
Sandro Knauß
sknauss at kde.org
Thu Feb 18 18:21:07 GMT 2016
Hey,
don't start akonadi as root. Like it is recommended from test 2.
regards,
sandro
--
Am Monday 15 February 2016, 15:28:03 schrieb Christopher Glasoe:
> I am on Opensuse Leap and Plasma.
>
> Akonadi stops.
>
> The Akonadicosole reports;
>
> Akonadi Server Self-Test Report
> ===============================
>
> Test 1: SUCCESS
> --------
>
> Database driver found.
> Details: The QtSQL driver 'QMYSQL' is required by your current Akonadi
> server configuration and was found on your system.
>
> File content of '/root/.config/akonadi/akonadiserverrc':
> [%General]
> Driver=QMYSQL
>
> [QMYSQL]
> Host=
> Name=akonadi
> Options="UNIX_SOCKET=/tmp/akonadi-root.hcfv3M/mysql.socket"
> ServerPath=/usr/sbin/mysqld
> StartServer=true
>
>
> Test 2: ERROR
> --------
>
> Akonadi was started as root
> Details: Running Internet-facing applications as root/administrator exposes
> you to many security risks. MySQL, used by this Akonadi installation, will
> not allow itself to run as root, to protect you from these risks.
>
> Test 3: SUCCESS
> --------
>
> MySQL server found.
> Details: You have currently configured Akonadi to use the MySQL server
> '/usr/ sbin/mysqld'.
> Make sure you have the MySQL server installed, set the correct path and
> ensure you have the necessary read and execution rights on the server
> executable. The server executable is typically called 'mysqld'; its
> location varies depending on the distribution.
>
> Test 4: SUCCESS
> --------
>
> MySQL server is executable.
> Details: MySQL server found: 2016-02-15 15:27:09 140292944263040 [Note]
> /usr/ sbin/mysqld (mysqld 10.1.6-MariaDB) starting as process 21846 ...
> /usr/sbin/mysqld Ver 10.1.6-MariaDB for Linux on x86_64 (openSUSE package)
>
>
> Test 5: SUCCESS
> --------
>
> No current MySQL error log found.
> Details: The MySQL server did not report any errors during this startup. The
> log can be found in '/root/.local/share/akonadi/db_data/mysql.err'.
>
> Test 6: SUCCESS
> --------
>
> MySQL server default configuration found.
> Details: The default configuration for the MySQL server was found and is
> readable at <a href="/etc/xdg/akonadi/mysql-global.conf">/etc/xdg/akonadi/
> mysql-global.conf</a>.
>
> File content of '/etc/xdg/akonadi/mysql-global.conf':
> #
> # Global Akonadi MySQL server settings,
> # These settings can be adjusted using
> $HOME/.config/akonadi/mysql-local.conf #
> # Based on advice by Kris Köhntopp <kris at mysql.com>
> #
> [mysqld]
>
> # strict query parsing/interpretation
> # TODO: make Akonadi work with those settings enabled
> #
> sql_mode=strict_trans_tables,strict_all_tables,strict_error_for_division_by_
> zero,no_auto_create_user,no_auto_value_on_zero,no_engine_substitution,no_zer
> o_date,no_zero_in_date,only_full_group_by,pipes_as_concat #
> sql_mode=strict_trans_tables
>
> # DEBUGGING:
> # log all queries, useful for debugging but generates an enormous amount of
> data
> # log=mysql.full
> # log queries slower than n seconds, log file name relative to datadir (for
> debugging only)
> # log_slow_queries=mysql.slow
> # long_query_time=1
> # log queries not using indices, debug only, disable for production use
> # log_queries_not_using_indexes=1
> #
> # mesure database size and adjust innodb_buffer_pool_size
> # SELECT sum(data_length) as bla, sum(index_length) as blub FROM
> information_schema.tables WHERE table_schema not in ("mysql",
> "information_schema");
>
> # NOTES:
> # Keep Innob_log_waits and keep Innodb_buffer_pool_wait_free small (see show
> global status like "inno%", show global variables)
>
> #expire_logs_days=3
>
> #sync_bin_log=0
>
> # Use UTF-8 encoding for tables
> character_set_server=utf8
> collation_server=utf8_general_ci
>
> # use InnoDB for transactions and better crash recovery
> default_storage_engine=innodb
>
> # memory pool InnoDB uses to store data dictionary information and other
> internal data structures (default:1M)
> # Deprecated in MySQL >= 5.6.3
> innodb_additional_mem_pool_size=1M
>
> # memory buffer InnoDB uses to cache data and indexes of its tables
> (default: 128M)
> # Larger values means less I/O
> innodb_buffer_pool_size=80M
>
> # Create a .ibd file for each table (default:0)
> innodb_file_per_table=1
>
> # Write out the log buffer to the log file at each commit (default:1)
> innodb_flush_log_at_trx_commit=2
>
> # Buffer size used to write to the log files on disk (default:1M for
> builtin, 8M for plugin)
> # larger values means less I/O
> innodb_log_buffer_size=1M
>
> # Size of each log file in a log group (default:5M) larger means less I/O
> but more time for recovery.
> innodb_log_file_size=64M
>
> # # error log file name, relative to datadir (default:hostname.err)
> log_error=mysql.err
>
> # print warnings and connection errors (default:1)
> log_warnings=2
>
> # Convert table named to lowercase
> lower_case_table_names=1
>
> # Maximum size of one packet or any generated/intermediate string. (default:
> 1M)
> max_allowed_packet=32M
>
> # Maximum simultaneous connections allowed (default:100)
> max_connections=256
>
> # The two options below make no sense with prepared statements and/or
> transactions
> # (make sense when having the same query multiple times)
>
> # Memory allocated for caching query results (default:0 (disabled))
> query_cache_size=0
>
> # Do not cache results (default:1)
> query_cache_type=0
>
> # Do not use the privileges mechanisms
> skip_grant_tables
>
> # Do not listen for TCP/IP connections at all
> skip_networking
>
> # The number of open tables for all threads. (default:64)
> table_open_cache=200
>
> # How many threads the server should cache for reuse (default:0)
> thread_cache_size=3
>
> # wait 365d before dropping the DB connection (default:8h)
> wait_timeout=31536000
>
> # We use InnoDB, so don't let MyISAM eat up memory
> key_buffer_size=16K
>
> [client]
> default-character-set=utf8
>
>
> Test 7: SKIP
> --------
>
> MySQL server custom configuration not available.
> Details: The custom configuration for the MySQL server was not found but is
> optional.
>
> Test 8: SUCCESS
> --------
>
> MySQL server configuration is usable.
> Details: The MySQL server configuration was found at <a href="/root/.local/
> share/akonadi/mysql.conf">/root/.local/share/akonadi/mysql.conf</a> and is
> readable.
>
> File content of '/root/.local/share/akonadi/mysql.conf':
> #
> # Global Akonadi MySQL server settings,
> # These settings can be adjusted using
> $HOME/.config/akonadi/mysql-local.conf #
> # Based on advice by Kris Köhntopp <kris at mysql.com>
> #
> [mysqld]
>
> # strict query parsing/interpretation
> # TODO: make Akonadi work with those settings enabled
> #
> sql_mode=strict_trans_tables,strict_all_tables,strict_error_for_division_by_
> zero,no_auto_create_user,no_auto_value_on_zero,no_engine_substitution,no_zer
> o_date,no_zero_in_date,only_full_group_by,pipes_as_concat #
> sql_mode=strict_trans_tables
>
> # DEBUGGING:
> # log all queries, useful for debugging but generates an enormous amount of
> data
> # log=mysql.full
> # log queries slower than n seconds, log file name relative to datadir (for
> debugging only)
> # log_slow_queries=mysql.slow
> # long_query_time=1
> # log queries not using indices, debug only, disable for production use
> # log_queries_not_using_indexes=1
> #
> # mesure database size and adjust innodb_buffer_pool_size
> # SELECT sum(data_length) as bla, sum(index_length) as blub FROM
> information_schema.tables WHERE table_schema not in ("mysql",
> "information_schema");
>
> # NOTES:
> # Keep Innob_log_waits and keep Innodb_buffer_pool_wait_free small (see show
> global status like "inno%", show global variables)
>
> #expire_logs_days=3
>
> #sync_bin_log=0
>
> # Use UTF-8 encoding for tables
> character_set_server=utf8
> collation_server=utf8_general_ci
>
> # use InnoDB for transactions and better crash recovery
> default_storage_engine=innodb
>
> # memory pool InnoDB uses to store data dictionary information and other
> internal data structures (default:1M)
> # Deprecated in MySQL >= 5.6.3
> innodb_additional_mem_pool_size=1M
>
> # memory buffer InnoDB uses to cache data and indexes of its tables
> (default: 128M)
> # Larger values means less I/O
> innodb_buffer_pool_size=80M
>
> # Create a .ibd file for each table (default:0)
> innodb_file_per_table=1
>
> # Write out the log buffer to the log file at each commit (default:1)
> innodb_flush_log_at_trx_commit=2
>
> # Buffer size used to write to the log files on disk (default:1M for
> builtin, 8M for plugin)
> # larger values means less I/O
> innodb_log_buffer_size=1M
>
> # Size of each log file in a log group (default:5M) larger means less I/O
> but more time for recovery.
> innodb_log_file_size=64M
>
> # # error log file name, relative to datadir (default:hostname.err)
> log_error=mysql.err
>
> # print warnings and connection errors (default:1)
> log_warnings=2
>
> # Convert table named to lowercase
> lower_case_table_names=1
>
> # Maximum size of one packet or any generated/intermediate string. (default:
> 1M)
> max_allowed_packet=32M
>
> # Maximum simultaneous connections allowed (default:100)
> max_connections=256
>
> # The two options below make no sense with prepared statements and/or
> transactions
> # (make sense when having the same query multiple times)
>
> # Memory allocated for caching query results (default:0 (disabled))
> query_cache_size=0
>
> # Do not cache results (default:1)
> query_cache_type=0
>
> # Do not use the privileges mechanisms
> skip_grant_tables
>
> # Do not listen for TCP/IP connections at all
> skip_networking
>
> # The number of open tables for all threads. (default:64)
> table_open_cache=200
>
> # How many threads the server should cache for reuse (default:0)
> thread_cache_size=3
>
> # wait 365d before dropping the DB connection (default:8h)
> wait_timeout=31536000
>
> # We use InnoDB, so don't let MyISAM eat up memory
> key_buffer_size=16K
>
> [client]
> default-character-set=utf8
>
>
> Test 9: SUCCESS
> --------
>
> akonadictl found and usable
> Details: The program '/usr/bin/akonadictl' to control the Akonadi server was
> found and could be executed successfully.
> Result:
> Akonadi 5.1.51
>
>
> Test 10: ERROR
> --------
>
> Akonadi control process not registered at D-Bus.
> Details: The Akonadi control process is not registered at D-Bus which
> typically means it was not started or encountered a fatal error during
> startup.
>
> Test 11: ERROR
> --------
>
> Akonadi server process not registered at D-Bus.
> Details: The Akonadi server process is not registered at D-Bus which
> typically means it was not started or encountered a fatal error during
> startup.
>
> Test 12: SKIP
> --------
>
> Protocol version check not possible.
> Details: Without a connection to the server it is not possible to check if
> the protocol version meets the requirements.
>
> Test 13: ERROR
> --------
>
> No resource agents found.
> Details: No resource agents have been found, Akonadi is not usable without
> at least one. This usually means that no resource agents are installed or
> that there is a setup problem. The following paths have been searched:
> '/usr/share/ akonadi/agents'. The XDG_DATA_DIRS environment variable is set
> to '/usr/ share:/opt/kf5/share'; make sure this includes all paths where
> Akonadi agents are installed.
>
> Directory listing of '/usr/share/akonadi/agents':
> akonadibalooindexingagent.desktop
> akonadiindexingagent.desktop
> akonotesresource.desktop
> archivemailagent.desktop
> birthdaysresource.desktop
> contactsresource.desktop
> davgroupwareresource.desktop
> followupreminder.desktop
> googlecalendarresource.desktop
> googlecontactsresource.desktop
> icaldirresource.desktop
> icalresource.desktop
> imapresource.desktop
> invitationsagent.desktop
> kalarmdirresource.desktop
> kalarmresource.desktop
> kolabresource.desktop
> maildirresource.desktop
> maildispatcheragent.desktop
> mailfilteragent.desktop
> mboxresource.desktop
> migrationagent.desktop
> mixedmaildirresource.desktop
> newmailnotifieragent.desktop
> notesagent.desktop
> notesresource.desktop
> openxchangeresource.desktop
> pop3resource.desktop
> sendlateragent.desktop
> vcarddirresource.desktop
> vcardresource.desktop
>
> Environment variable XDG_DATA_DIRS is set to '/usr/share:/opt/kf5/share'
>
> Test 14: ERROR
> --------
>
> Current Akonadi server error log found.
> Details: The Akonadi server reported errors during its current startup. The
> log can be found in <a
> href="/root/.local/share/akonadi/akonadiserver.error">/
> root/.local/share/akonadi/akonadiserver.error</a>.
>
> File content of '/root/.local/share/akonadi/akonadiserver.error':
> Database process exited unexpectedly during initial connection!
> executable: "/usr/sbin/mysqld"
> arguments: ("--defaults-file=/root/.local/share/akonadi/mysql.conf", "--
> datadir=/root/.local/share/akonadi/db_data/", "--socket=/tmp/akonadi-
> root.hcfv3M/mysql.socket")
> stdout: ""
> stderr: "2016-02-15 15:27:04 139901980514176 [Note] /usr/sbin/mysqld (mysqld
> 10.1.6-MariaDB) starting as process 21844 ...\n2016-02-15 15:27:04
> 139901980514176 [ERROR] Fatal error: Please consult the Knowledge Base to
> find out how to run mysqld as root!\n\n2016-02-15 15:27:04 139901980514176
> [ERROR] Aborting\n\n2016-02-15 15:27:04 139901980514176 [Note]
> /usr/sbin/mysqld: Shutdown complete\n\n"
> exit code: 1
> process error: "Unknown error"
> Failed to remove Unix socket
> Failed to remove runtime connection config file
>
>
> Test 15: ERROR
> --------
>
> Previous Akonadi server error log found.
> Details: The Akonadi server reported errors during its previous startup. The
> log can be found in <a href="/root/.local/share/akonadi/
> akonadiserver.error.old">/root/.local/share/akonadi/akonadiserver.error.old<
> / a>.
>
> File content of '/root/.local/share/akonadi/akonadiserver.error.old':
> Database process exited unexpectedly during initial connection!
> executable: "/usr/sbin/mysqld"
> arguments: ("--defaults-file=/root/.local/share/akonadi/mysql.conf", "--
> datadir=/root/.local/share/akonadi/db_data/", "--socket=/tmp/akonadi-
> root.hcfv3M/mysql.socket")
> stdout: ""
> stderr: "2016-02-15 15:24:38 140236533303168 [Note] /usr/sbin/mysqld (mysqld
> 10.1.6-MariaDB) starting as process 21814 ...\n2016-02-15 15:24:38
> 140236533303168 [ERROR] Fatal error: Please consult the Knowledge Base to
> find out how to run mysqld as root!\n\n2016-02-15 15:24:38 140236533303168
> [ERROR] Aborting\n\n2016-02-15 15:24:38 140236533303168 [Note]
> /usr/sbin/mysqld: Shutdown complete\n\n"
> exit code: 1
> process error: "Unknown error"
> Failed to remove Unix socket
> Failed to remove runtime connection config file
>
>
> Test 16: SUCCESS
> --------
>
> No current Akonadi control error log found.
> Details: The Akonadi control process did not report any errors during its
> current startup.
>
> Test 17: SUCCESS
> --------
>
> No previous Akonadi control error log found.
> Details: The Akonadi control process did not report any errors during its
> previous startup.
>
> Any suggestions?
>
> Thank you!
>
> Chris
>
>
> _______________________________________________
> KDE PIM users mailing list
> Subscription management: https://mail.kde.org/mailman/listinfo/kdepim-users
More information about the kdepim-users
mailing list