Results 1 to 9 of 9

Thread: akonadi doesn't start

  1. #1

    Default akonadi doesn't start

    hi, happy saint stephen again
    on my [Laptop=Dell latitude E6510, RAM=8Gb, GPU=GT218 NVS 3100M, CPU=i7 Q 720 @ 1.60GHz running opensuse leap 42.2, plasma 5.8.4, KDE frameworks 5.29.0, KDE applications 16.12.0, Kernel 4.4.36-8-default, nvidia drivers]
    akonadi doesn't start and this is the report:
    how can I have a working akonadi?
    manythanks, ciao, :-) pier
    Code:
    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 '/home/pla/.config/akonadi/akonadiserverrc':
    [%General]
    Driver=QMYSQL
    
    
    Test 2:  SUCCESS
    --------
    
    Akonadi is not running as root
    Details: Akonadi is not running as a root/administrator user, which is the recommended setup for a secure system.
    
    Test 3:  ERROR
    --------
    
    MySQL server not found.
    Details: You have currently configured Akonadi to use the MySQL server ''.
    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:  ERROR
    --------
    
    Executing the MySQL server failed.
    Details: Executing the MySQL server '' failed with the following error message: ''
    
    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 '/home/pla/.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/akonadi/mysql-global.conf'>/etc/akonadi/mysql-global.conf</a>.
    
    File content of '/etc/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@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_zero_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:  ERROR
    --------
    
    MySQL server configuration not found or not readable.
    Details: The MySQL server configuration was not found or is not readable.
    
    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 1.13.0
    
    
    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 /opt/kf5/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':
    akonadinepomukfeederagent.desktop
    akonotesresource.desktop
    birthdaysresource.desktop
    contactsresource.desktop
    davgroupwareresource.desktop
    facebookresource.desktop
    googlecalendarresource.desktop
    googlecontactsresource.desktop
    icaldirresource.desktop
    icalresource.desktop
    imapresource.desktop
    invitationsagent.desktop
    kabcresource.desktop
    kalarmdirresource.desktop
    kalarmresource.desktop
    kcalresource.desktop
    kdeaccountsresource.desktop
    kolabproxyresource.desktop
    kolabresource.desktop
    localbookmarksresource.desktop
    maildirresource.desktop
    maildispatcheragent.desktop
    mboxresource.desktop
    migrationagent.desktop
    mixedmaildirresource.desktop
    mtdummyresource.desktop
    newmailnotifieragent.desktop
    nntpresource.desktop
    notesresource.desktop
    openxchangeresource.desktop
    pop3resource.desktop
    vcarddirresource.desktop
    vcardresource.desktop
    Directory listing of '/opt/kf5/share/akonadi/agents':
    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
    knutresource.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
    tomboynotesresource.desktop
    vcarddirresource.desktop
    vcardresource.desktop
    
    Environment variable XDG_DATA_DIRS is set to '/usr/share:/opt/kf5/share'
    
    Test 14:  SUCCESS
    --------
    
    No current Akonadi server error log found.
    Details: The Akonadi server did not report any errors during its current startup.
    
    Test 15:  SUCCESS
    --------
    
    No previous Akonadi server error log found.
    Details: The Akonadi server did not report any errors during its previous startup.
    
    Test 16:  ERROR
    --------
    
    Current Akonadi control error log found.
    Details: The Akonadi control process reported errors during its current startup. The log can be found in <a href='/home/pla/.local/share/akonadi/akonadi_control.error'>/home/pla/.local/share/akonadi/akonadi_control.error</a>.
    
    File content of '/home/pla/.local/share/akonadi/akonadi_control.error':
    ProcessControl: Application akonadiserver stopped unexpectedly ( "Process crashed" ) 
    ProcessControl: Application akonadiserver stopped unexpectedly ( "Process crashed" ) 
    ProcessControl: Application akonadiserver stopped unexpectedly ( "Process crashed" ) 
    
    
    Test 17:  ERROR
    --------
    
    Previous Akonadi control error log found.
    Details: The Akonadi control process reported errors during its previous startup. The log can be found in <a href='/home/pla/.local/share/akonadi/akonadi_control.error.old'>/home/pla/.local/share/akonadi/akonadi_control.error.old</a>.
    
    File content of '/home/pla/.local/share/akonadi/akonadi_control.error.old':
    ProcessControl: Application akonadiserver stopped unexpectedly ( "Process crashed" ) 
    ProcessControl: Application akonadiserver stopped unexpectedly ( "Process crashed" ) 
    ProcessControl: Application akonadiserver stopped unexpectedly ( "Process crashed" )

  2. #2
    Join Date
    Jun 2008
    Location
    San Diego, Ca, USA
    Posts
    10,917
    Blog Entries
    2

    Default Re: akonadi doesn't start

    When installing a database application on a machine, its initial state is stopped.

    Verify it's state (whether it's running) with
    Code:
    systemctl status mysql.service
    If it's stopped, then start it with
    Code:
    systemctl start mysql.service
    Then verify the status of your mysql.service again.
    If it's not running, you will see a relevant snippet from the journal which might say what the problem is, if you aren't able to resolve then you can post the entire "status" output in a post.

    Best practices is that you should also run the script that secures mysql, but may not be necessary for your akonadi.

    TSU
    Beginner Wiki Quickstart - https://en.opensuse.org/User:Tsu2/Quickstart_Wiki
    Solved a problem recently? Create a wiki page for future personal reference!
    Learn something new?
    Attended a computing event?
    Post and Share!

  3. #3

    Default Re: akonadi doesn't start

    manythanks tsu
    Quote Originally Posted by tsu2 View Post
    When installing a database application on a machine, its initial state is stopped.

    Verify it's state (whether it's running) with
    Code:
    systemctl status mysql.service
    Code:
    pla@pla3-TW:~> systemctl status mysql.service
    ● mysql.service - MySQL server
       Loaded: loaded (/usr/lib/systemd/system/mysql.service; disabled; vendor preset: disabled)
       Active: inactive (dead)
    pla@pla3-TW:~>
    I don't know if it is running or not, if "Active: inactive (dead)" means not running then I try to start it
    Quote Originally Posted by tsu2 View Post
    If it's stopped, then start it with
    Code:
    systemctl start mysql.service
    this is the result
    Code:
    pla@pla3-TW:~> systemctl start mysql.service
    pla@pla3-TW:~>
    Quote Originally Posted by tsu2 View Post
    Then verify the status of your mysql.service again.
    it seems different from the first, may be it is running
    Code:
    pla@pla3-TW:~> systemctl status mysql.service
    ● mysql.service - MySQL server
       Loaded: loaded (/usr/lib/systemd/system/mysql.service; disabled; vendor preset: disabled)
       Active: active (running) since Mon 2016-12-26 18:54:43 CET; 1min 1s ago
      Process: 10551 ExecStartPost=/usr/lib/mysql/mysql-systemd-helper wait (code=exited, status=0/SUCCESS)
      Process: 10536 ExecStartPre=/usr/lib/mysql/mysql-systemd-helper upgrade (code=exited, status=0/SUCCESS)
      Process: 10442 ExecStartPre=/usr/lib/mysql/mysql-systemd-helper install (code=exited, status=0/SUCCESS)
     Main PID: 10550 (mysqld)
        Tasks: 23 (limit: 512)
       CGroup: /system.slice/mysql.service
               └─10550 /usr/sbin/mysqld --defaults-file=/etc/my.cnf --user=mysql
    pla@pla3-TW:~>
    Quote Originally Posted by tsu2 View Post
    If it's not running, you will see a relevant snippet from the journal which might say what the problem is, if you aren't able to resolve then you can post the entire "status" output in a post.

    Best practices is that you should also run the script that secures mysql, but may not be necessary for your akonadi.
    I tried to start akonadi again but this is the result:
    Code:
    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 '/home/pla/.config/akonadi/akonadiserverrc':
    [%General]
    Driver=QMYSQL
    
    
    Test 2:  SUCCESS
    --------
    
    Akonadi is not running as root
    Details: Akonadi is not running as a root/administrator user, which is the recommended setup for a secure system.
    
    Test 3:  ERROR
    --------
    
    MySQL server not found.
    Details: You have currently configured Akonadi to use the MySQL server ''.
    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:  ERROR
    --------
    
    Executing the MySQL server failed.
    Details: Executing the MySQL server '' failed with the following error message: ''
    
    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 '/home/pla/.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/akonadi/mysql-global.conf'>/etc/akonadi/mysql-global.conf</a>.
    
    File content of '/etc/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@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_zero_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:  ERROR
    --------
    
    MySQL server configuration not found or not readable.
    Details: The MySQL server configuration was not found or is not readable.
    
    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 1.13.0
    
    
    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 /opt/kf5/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':
    akonadinepomukfeederagent.desktop
    akonotesresource.desktop
    birthdaysresource.desktop
    contactsresource.desktop
    davgroupwareresource.desktop
    facebookresource.desktop
    googlecalendarresource.desktop
    googlecontactsresource.desktop
    icaldirresource.desktop
    icalresource.desktop
    imapresource.desktop
    invitationsagent.desktop
    kabcresource.desktop
    kalarmdirresource.desktop
    kalarmresource.desktop
    kcalresource.desktop
    kdeaccountsresource.desktop
    kolabproxyresource.desktop
    kolabresource.desktop
    localbookmarksresource.desktop
    maildirresource.desktop
    maildispatcheragent.desktop
    mboxresource.desktop
    migrationagent.desktop
    mixedmaildirresource.desktop
    mtdummyresource.desktop
    newmailnotifieragent.desktop
    nntpresource.desktop
    notesresource.desktop
    openxchangeresource.desktop
    pop3resource.desktop
    vcarddirresource.desktop
    vcardresource.desktop
    Directory listing of '/opt/kf5/share/akonadi/agents':
    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
    knutresource.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
    tomboynotesresource.desktop
    vcarddirresource.desktop
    vcardresource.desktop
    
    Environment variable XDG_DATA_DIRS is set to '/usr/share:/opt/kf5/share'
    
    Test 14:  SUCCESS
    --------
    
    No current Akonadi server error log found.
    Details: The Akonadi server did not report any errors during its current startup.
    
    Test 15:  SUCCESS
    --------
    
    No previous Akonadi server error log found.
    Details: The Akonadi server did not report any errors during its previous startup.
    
    Test 16:  ERROR
    --------
    
    Current Akonadi control error log found.
    Details: The Akonadi control process reported errors during its current startup. The log can be found in <a href='/home/pla/.local/share/akonadi/akonadi_control.error'>/home/pla/.local/share/akonadi/akonadi_control.error</a>.
    
    File content of '/home/pla/.local/share/akonadi/akonadi_control.error':
    ProcessControl: Application akonadiserver stopped unexpectedly ( "Process crashed" ) 
    ProcessControl: Application akonadiserver stopped unexpectedly ( "Process crashed" ) 
    ProcessControl: Application akonadiserver stopped unexpectedly ( "Process crashed" ) 
    
    
    Test 17:  ERROR
    --------
    
    Previous Akonadi control error log found.
    Details: The Akonadi control process reported errors during its previous startup. The log can be found in <a href='/home/pla/.local/share/akonadi/akonadi_control.error.old'>/home/pla/.local/share/akonadi/akonadi_control.error.old</a>.
    
    File content of '/home/pla/.local/share/akonadi/akonadi_control.error.old':
    ProcessControl: Application akonadiserver stopped unexpectedly ( "Process crashed" ) 
    ProcessControl: Application akonadiserver stopped unexpectedly ( "Process crashed" ) 
    ProcessControl: Application akonadiserver stopped unexpectedly ( "Process crashed" )
    manythanks tsu, ciao, :-) pier

  4. #4
    Join Date
    Jun 2008
    Location
    San Diego, Ca, USA
    Posts
    10,917
    Blog Entries
    2

    Default Re: akonadi doesn't start

    Quote Originally Posted by pier_andreit View Post
    manythanks tsu

    Code:
    pla@pla3-TW:~> systemctl status mysql.service
    ● mysql.service - MySQL server
       Loaded: loaded (/usr/lib/systemd/system/mysql.service; disabled; vendor preset: disabled)
       Active: inactive (dead)
    pla@pla3-TW:~>
    I don't know if it is running or not, if "Active: inactive (dead)" means not running then I try to start it

    this is the result
    Code:
    pla@pla3-TW:~> systemctl start mysql.service
    pla@pla3-TW:~>

    it seems different from the first, may be it is running
    Code:
    pla@pla3-TW:~> systemctl status mysql.service
    ● mysql.service - MySQL server
       Loaded: loaded (/usr/lib/systemd/system/mysql.service; disabled; vendor preset: disabled)
       Active: active (running) since Mon 2016-12-26 18:54:43 CET; 1min 1s ago
      Process: 10551 ExecStartPost=/usr/lib/mysql/mysql-systemd-helper wait (code=exited, status=0/SUCCESS)
      Process: 10536 ExecStartPre=/usr/lib/mysql/mysql-systemd-helper upgrade (code=exited, status=0/SUCCESS)
      Process: 10442 ExecStartPre=/usr/lib/mysql/mysql-systemd-helper install (code=exited, status=0/SUCCESS)
     Main PID: 10550 (mysqld)
        Tasks: 23 (limit: 512)
       CGroup: /system.slice/mysql.service
               └─10550 /usr/sbin/mysqld --defaults-file=/etc/my.cnf --user=mysql
    pla@pla3-TW:~>

    I tried to start akonadi again but this is the result:
    Code:
    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 '/home/pla/.config/akonadi/akonadiserverrc':
    [%General]
    Driver=QMYSQL
    
    
    Test 2:  SUCCESS
    --------
    
    Akonadi is not running as root
    Details: Akonadi is not running as a root/administrator user, which is the recommended setup for a secure system.
    
    Test 3:  ERROR
    --------
    
    MySQL server not found.
    Details: You have currently configured Akonadi to use the MySQL server ''.
    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:  ERROR
    --------
    
    Executing the MySQL server failed.
    Details: Executing the MySQL server '' failed with the following error message: ''
    
    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 '/home/pla/.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/akonadi/mysql-global.conf'>/etc/akonadi/mysql-global.conf</a>.
    
    File content of '/etc/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@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_zero_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:  ERROR
    --------
    
    MySQL server configuration not found or not readable.
    Details: The MySQL server configuration was not found or is not readable.
    
    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 1.13.0
    
    
    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 /opt/kf5/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':
    akonadinepomukfeederagent.desktop
    akonotesresource.desktop
    birthdaysresource.desktop
    contactsresource.desktop
    davgroupwareresource.desktop
    facebookresource.desktop
    googlecalendarresource.desktop
    googlecontactsresource.desktop
    icaldirresource.desktop
    icalresource.desktop
    imapresource.desktop
    invitationsagent.desktop
    kabcresource.desktop
    kalarmdirresource.desktop
    kalarmresource.desktop
    kcalresource.desktop
    kdeaccountsresource.desktop
    kolabproxyresource.desktop
    kolabresource.desktop
    localbookmarksresource.desktop
    maildirresource.desktop
    maildispatcheragent.desktop
    mboxresource.desktop
    migrationagent.desktop
    mixedmaildirresource.desktop
    mtdummyresource.desktop
    newmailnotifieragent.desktop
    nntpresource.desktop
    notesresource.desktop
    openxchangeresource.desktop
    pop3resource.desktop
    vcarddirresource.desktop
    vcardresource.desktop
    Directory listing of '/opt/kf5/share/akonadi/agents':
    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
    knutresource.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
    tomboynotesresource.desktop
    vcarddirresource.desktop
    vcardresource.desktop
    
    Environment variable XDG_DATA_DIRS is set to '/usr/share:/opt/kf5/share'
    
    Test 14:  SUCCESS
    --------
    
    No current Akonadi server error log found.
    Details: The Akonadi server did not report any errors during its current startup.
    
    Test 15:  SUCCESS
    --------
    
    No previous Akonadi server error log found.
    Details: The Akonadi server did not report any errors during its previous startup.
    
    Test 16:  ERROR
    --------
    
    Current Akonadi control error log found.
    Details: The Akonadi control process reported errors during its current startup. The log can be found in <a href='/home/pla/.local/share/akonadi/akonadi_control.error'>/home/pla/.local/share/akonadi/akonadi_control.error</a>.
    
    File content of '/home/pla/.local/share/akonadi/akonadi_control.error':
    ProcessControl: Application akonadiserver stopped unexpectedly ( "Process crashed" ) 
    ProcessControl: Application akonadiserver stopped unexpectedly ( "Process crashed" ) 
    ProcessControl: Application akonadiserver stopped unexpectedly ( "Process crashed" ) 
    
    
    Test 17:  ERROR
    --------
    
    Previous Akonadi control error log found.
    Details: The Akonadi control process reported errors during its previous startup. The log can be found in <a href='/home/pla/.local/share/akonadi/akonadi_control.error.old'>/home/pla/.local/share/akonadi/akonadi_control.error.old</a>.
    
    File content of '/home/pla/.local/share/akonadi/akonadi_control.error.old':
    ProcessControl: Application akonadiserver stopped unexpectedly ( "Process crashed" ) 
    ProcessControl: Application akonadiserver stopped unexpectedly ( "Process crashed" ) 
    ProcessControl: Application akonadiserver stopped unexpectedly ( "Process crashed" )
    manythanks tsu, ciao, :-) pier
    Your MySQL server was not running before, If you are running the above commands in one of the openSUSE enhanced terminals like Konsole, LXterminal, Qterminal, et al then you should have seen highlighted in the following which I didn't place in CODE tags so you can see the highlight

    systemctl status mysql.service
    ● mysql.service - MySQL server
    Loaded: loaded (/usr/lib/systemd/system/mysql.service; disabled; vendor preset: disabled)
    Active: active (running) since Mon 2016-12-26 18:54:43 CET; 1min 1s ago
    Process: 10551 ExecStartPost=/usr/lib/mysql/mysql-systemd-helper wait (code=exited, status=0/SUCCESS)
    Process: 10536 ExecStartPre=/usr/lib/mysql/mysql-systemd-helper upgrade (code=exited, status=0/SUCCESS)
    Process: 10442 ExecStartPre=/usr/lib/mysql/mysql-systemd-helper install (code=exited, status=0/SUCCESS)

    But, apparently there is more that's necessary for running Akonadi.
    It appears that an Akonadi configuration isn't specifying your local MySQL server (likely by name or address, and that would generally also require configuring your MySQL server security to allow only local machine calls or network sockets).

    How did you install Akonadi, and are you following any guides for setup and use?

    I'm trying to understand if you installed packages from a source that should have automatically set up everything for you or if the way you're installing requires plenty of manual configuration.

    TSU
    Beginner Wiki Quickstart - https://en.opensuse.org/User:Tsu2/Quickstart_Wiki
    Solved a problem recently? Create a wiki page for future personal reference!
    Learn something new?
    Attended a computing event?
    Post and Share!

  5. #5

    Default Re: akonadi doesn't start

    Quote Originally Posted by tsu2 View Post
    But, apparently there is more that's necessary for running Akonadi.
    It appears that an Akonadi configuration isn't specifying your local MySQL server (likely by name or address, and that would generally also require configuring your MySQL server security to allow only local machine calls or network sockets).

    How did you install Akonadi, and are you following any guides for setup and use?

    I'm trying to understand if you installed packages from a source that should have automatically set up everything for you or if the way you're installing requires plenty of manual configuration.

    TSU
    I installed from opensuse repository, the wolfi one

  6. #6
    Join Date
    Nov 2009
    Location
    West Virginia Sector 13
    Posts
    15,646

    Default Re: akonadi doesn't start

    Are you sure you are not mixing the standard KDE stuff with wolfi's???

    You should use totally one or the other. Mixing things can cause problems

    Do a full vendor change to the wolfi repo if that is what you want to use

  7. #7

    Default Re: akonadi doesn't start

    Quote Originally Posted by gogalthorp View Post
    Are you sure you are not mixing the standard KDE stuff with wolfi's???

    You should use totally one or the other. Mixing things can cause problems

    Do a full vendor change to the wolfi repo if that is what you want to use
    the situation of akonadi installed is this:
    Code:
    Package                | Installed (Available)|  
                                                 |the ones with "w" are from the wolfi repo home:wolfi323:branches:KDE:Frameworks5 / openSUSE_Leap_42.2
    libakonadi4            | 4.14.10-10.16        | w
    libKF5AkonadiCalendar5 | 16.12.0-93.1         | w
    akonadi-import-wizard  | 16.12.0-5.1          | w
    akonadiconsole         | 16.12.0-5.1          | w
    akonadi-contact        | 16.12.0-33.1         | w
    libKF5AkonadiContact5  | 16.12.0-33.1         | w
    akonadi-mime           | 16.12.0-27.1         | w
    libKF5AkonadiMime5     | 16.12.0-27.1         | w
    libKF5AkonadiNotes5    | 16.12.0-19.1         | w
    akonadi-server         | 16.12.0-116.3        | w
    akonadi-server-sqlite  | 16.12.0-116.3        | w
    libKF5AkonadiAgentBase5| 16.12.0-116.3        | w
    libKF5AkonadiCore5     | 16.12.0-116.3        | w 
    libKF5AkonadiPrivate5  | 16.12.0-116.3        | w 
    libKF5AkonadiWidgets5  | 16.12.0-116.3        | w 
    libKF5AkonadiXml5      | 16.12.0-116.3        | w 
    akonadi-search         | 16.12.0-102.1        | w
    libKF5AkonadiSearch    | 16.12.0-102.1        | w 
    
    only this is from the opensuse OS repo, but the wolfi version is absent
    akonadi-runtime        | 1.13.0-4.5           | openSUSE Leap 42
    but one doubt, I have also something that seems related to akonadi-kde4 mixed, could it is the why??

    manythanks, ciao, :-) pier

  8. #8
    Join Date
    Jun 2008
    Location
    Groningen, Netherlands
    Posts
    19,644
    Blog Entries
    14

    Default Re: akonadi doesn't start

    Why do you use these repos ? Stick to the stock packages and you won't have these issues.
    ° Appreciate my reply? Click the star and let me know why.

    ° Perfection is not gonna happen. No way.

    https://en.opensuse.org/openSUSE:Board#Members
    http://en.opensuse.org/User:Knurpht
    http://nl.opensuse.org/Gebruiker:Knurpht

  9. #9
    Join Date
    Jun 2008
    Location
    Düsseldorf/Germany
    Posts
    244

    Default Re: akonadi doesn't start

    Just for the records - I had a similar problem yesterday with a Tumbleweed installation (as of 2017-02-04) : akonadictl crashed permanently, and mysql was not able to start.
    Solution was mor a shot in the dark, but successful: I deleted content of /tmp completely and rebootet. All was working afterwards. Seems some temporary file had a hickup

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •