| View previous topic :: View next topic |
| Author |
Message |
Featherfoot
Veteran
Joined: 28 Dec 2002
Posts: 1108
Location: Stuart, Florida
|
 Posted: Fri Mar 12, 2010 12:47 am Post subject: Akonadi Still Won't Start and I've tried the other posts |
 |
|
I have been struggling to get Akonadi to start for several days now. At this point I have two errors: (1) No resource agents found and (2) Previous Akonadi control error log found.
I figure 2 is a noobie trap, but I can't figure out 1.
I am running system 2.6.31-gentoo-r6 on an amd64 system with kde 4.4.1.
Here's the error log:
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/jc/.config/akonadi/akonadiserverrc':
[%General]
Driver=QMYSQL
SizeThreshold=4096
ExternalPayload=false
[QMYSQL]
Name=akonadi
Host=
User=
Password=
Options="UNIX_SOCKET=/home/jc/.local/share/akonadi/db_misc/mysql.socket"
ServerPath=/usr/sbin/mysqld
StartServer=true
[Debug]
Tracer=null
Test 2: SUCCESS
--------
MySQL server found.
Details: You currently have 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 locations varies depending on the distribution.
Test 3: SUCCESS
--------
MySQL server is executable.
Details: MySQL server found: /usr/sbin/mysqld Ver 5.0.90-log for pc-linux-gnu on x86_64 (Gentoo Linux mysql-5.0.90-r2)
Test 4: WARNING
--------
MySQL server log contains warnings.
Details: The MySQL server log file '<a href='/home/jc/.local/share/akonadi/db_data/mysql.err'>/home/jc/.local/share/akonadi/db_data/mysql.err</a>' contains warnings.
File content of '/home/jc/.local/share/akonadi/db_data/mysql.err':
InnoDB: The InnoDB memory heap is disabled
InnoDB: use atomic builtins.
100311 19:13:51 InnoDB: Started; log sequence number 0 188140
100311 19:13:51 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them
100311 19:13:51 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.90-log' socket: '/home/jc/.local/share/akonadi/db_misc/mysql.socket' port: 0 Gentoo Linux mysql-5.0.90-r2
Test 5: SUCCESS
--------
MySQL server default configuration found.
Details: The default configuration for the MySQL server was found and is readable at <a href='/usr/share/config/akonadi/mysql-global.conf'>/usr/share/config/akonadi/mysql-global.conf</a>.
File content of '/usr/share/config/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]
skip_grant_tables
skip_networking
# 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
# use InnoDB for transactions and better crash recovery
default_storage_engine=innodb
# case-insensitive table names, avoids trouble on windows
lower_case_table_names=1
character_set_server=latin1
collation_server=latin1_general_ci
table_cache=200
thread_cache_size=3
log_bin=mysql-bin
expire_logs_days=3
#sync_bin_log=0
# error log file name, relative to datadir
log_error=mysql.err
log_warnings=2
# 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
# maximum blob size
max_allowed_packet=32M
max_connections=256
# makes sense when having the same query multiple times
# makes no sense with prepared statements and/or transactions
query_cache_type=0
query_cache_size=0
innodb_file_per_table=1
innodb_log_buffer_size=1M
innodb_additional_mem_pool_size=1M
# messure database size and adjust
# SELECT sum(data_length) as bla, sum(index_length) as blub FROM information_schema.tables WHERE table_schema not in ("mysql", "information_schema");
innodb_buffer_pool_size=80M
# size of average write burst, keep Innob_log_waits small, keep Innodb_buffer_pool_wait_free small (see show global status like "inno%", show global variables)
innodb_log_file_size=64M
innodb_flush_log_at_trx_commit=2
Test 6: SKIP
--------
MySQL server custom configuration not available.
Details: The custom configuration for the MySQL server was not found but is optional.
Test 7: SUCCESS
--------
MySQL server configuration is usable.
Details: The MySQL server configuration was found at <a href='/home/jc/.local/share/akonadi/mysql.conf'>/home/jc/.local/share/akonadi/mysql.conf</a> and is readable.
File content of '/home/jc/.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@mysql.com>
#
[mysqld]
skip_grant_tables
skip_networking
# 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
# use InnoDB for transactions and better crash recovery
default_storage_engine=innodb
# case-insensitive table names, avoids trouble on windows
lower_case_table_names=1
character_set_server=latin1
collation_server=latin1_general_ci
table_cache=200
thread_cache_size=3
log_bin=mysql-bin
expire_logs_days=3
#sync_bin_log=0
# error log file name, relative to datadir
log_error=mysql.err
log_warnings=2
# 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
# maximum blob size
max_allowed_packet=32M
max_connections=256
# makes sense when having the same query multiple times
# makes no sense with prepared statements and/or transactions
query_cache_type=0
query_cache_size=0
innodb_file_per_table=1
innodb_log_buffer_size=1M
innodb_additional_mem_pool_size=1M
# messure database size and adjust
# SELECT sum(data_length) as bla, sum(index_length) as blub FROM information_schema.tables WHERE table_schema not in ("mysql", "information_schema");
innodb_buffer_pool_size=80M
# size of average write burst, keep Innob_log_waits small, keep Innodb_buffer_pool_wait_free small (see show global status like "inno%", show global variables)
innodb_log_file_size=64M
innodb_flush_log_at_trx_commit=2
user=jc
Test 8: 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.3.1
Test 9: SUCCESS
--------
Akonadi control process registered at D-Bus.
Details: The Akonadi control process is registered at D-Bus which typically indicates it is operational.
Test 10: SUCCESS
--------
Akonadi server process registered at D-Bus.
Details: The Akonadi server process is registered at D-Bus which typically indicates it is operational.
Test 11: SUCCESS
--------
Nepomuk search service registered at D-Bus.
Details: The Nepomuk search service is registered at D-Bus which typically indicates it is operational.
Test 12: SUCCESS
--------
Nepomuk search service uses an appropriate backend.
Details: The Nepomuk search service uses one of the recommended backends.
Test 13: 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 14: 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 /usr/share/akonadi/agents'. The XDG_DATA_DIRS environment variable is set to '/usr/share:/usr/local/share:/usr/share:/usr/share/gdm', make sure this includes all paths where Akonadi agents are installed to.
Directory listing of '/usr/share/akonadi/agents':
birthdaysresource.desktop
contactsresource.desktop
icalresource.desktop
imapresource.desktop
kabcresource.desktop
kcalresource.desktop
knutresource.desktop
kolabproxyresource.desktop
localbookmarksresource.desktop
maildirresource.desktop
maildispatcheragent.desktop
mboxresource.desktop
microblog.desktop
mtdummyresource.desktop
nepomukcalendarfeeder.desktop
nepomukcontactfeeder.desktop
nepomuktagresource.desktop
nntpresource.desktop
notesresource.desktop
pop3resource.desktop
vcarddirresource.desktop
vcardresource.desktop
Directory listing of '/usr/share/akonadi/agents':
birthdaysresource.desktop
contactsresource.desktop
icalresource.desktop
imapresource.desktop
kabcresource.desktop
kcalresource.desktop
knutresource.desktop
kolabproxyresource.desktop
localbookmarksresource.desktop
maildirresource.desktop
maildispatcheragent.desktop
mboxresource.desktop
microblog.desktop
mtdummyresource.desktop
nepomukcalendarfeeder.desktop
nepomukcontactfeeder.desktop
nepomuktagresource.desktop
nntpresource.desktop
notesresource.desktop
pop3resource.desktop
vcarddirresource.desktop
vcardresource.desktop
Environment variable XDG_DATA_DIRS is set to '/usr/share:/usr/local/share:/usr/share:/usr/share/gdm'
Test 15: SUCCESS
--------
No current Akonadi server error log found.
Details: The Akonadi server did not report any errors during its current startup.
Test 16: ERROR
--------
Previous Akonadi server error log found.
Details: The Akonadi server did report error during its previous startup into <a href='/home/jc/.local/share/akonadi/akonadiserver.error.old'>/home/jc/.local/share/akonadi/akonadiserver.error.old</a>.
File content of '/home/jc/.local/share/akonadi/akonadiserver.error.old':
Control process died, committing suicide!
D-Bus session bus went down - quitting
Test 17: SUCCESS
--------
No current Akonadi control error log found.
Details: The Akonadi control process did not report any errors during its current startup.
Test 18: ERROR
--------
Previous Akonadi control error log found.
Details: The Akonadi control process did report error during its previous startup into <a href='/home/jc/.local/share/akonadi/akonadi_control.error.old'>/home/jc/.local/share/akonadi/akonadi_control.error.old</a>.
File content of '/home/jc/.local/share/akonadi/akonadi_control.error.old':
D-Bus session bus went down - quitting
emerge --info follows:
# emerge --info
Portage 2.1.7.17 (default/linux/amd64/10.0/desktop, gcc-4.3.4, glibc-2.10.1-r1, 2.6.31-gentoo-r6 x86_64)
=================================================================
System uname: Linux-2.6.31-gentoo-r6-x86_64-AMD_Athlon-tm-_64_X2_Dual_Core_Processor_6000+-with-gentoo-2.0.1
Timestamp of tree: Fri, 12 Mar 2010 00:00:23 +0000
app-shells/bash: 4.0_p35
dev-java/java-config: 2.1.9-r2and
dev-lang/python: 2.4.6, 2.6.4
dev-python/pycrypto: 2.0.1-r8
dev-util/cmake: 2.6.4-r3
sys-apps/baselayout: 2.0.1
sys-apps/openrc: 0.6.0-r1
sys-apps/sandbox: 1.6-r2
sys-devel/autoconf: 2.13, 2.63-r1
sys-devel/automake: 1.5, 1.7.9-r1, 1.8.5-r3, 1.9.6-r2, 1.10.3
sys-devel/binutils: 2.18-r3
sys-devel/gcc: 4.3.4
sys-devel/gcc-config: 1.4.1
sys-devel/libtool: 2.2.6b
virtual/os-headers: 2.6.33
ACCEPT_KEYWORDS="amd64"
ACCEPT_LICENSE="* -@EULA"
CBUILD="x86_64-pc-linux-gnu"
CFLAGS="-march=k8 -O2 -pipe -fomit-frame-pointer"
CHOST="x86_64-pc-linux-gnu"
CONFIG_PROTECT="/etc /usr/share/X11/xkb /usr/share/config"
CONFIG_PROTECT_MASK="/etc/ca-certificates.conf /etc/env.d /etc/env.d/java/ /etc/fonts/fonts.conf /etc/gconf /etc/gentoo-release /etc/php/apache2-php5/ext-active/ /etc/php/cgi-php5/ext-active/ /etc/php/cli-php5/ext-active/ /etc/revdep-rebuild /etc/sandbox.d /etc/terminfo"
CXXFLAGS="-march=k8 -O2 -pipe -fomit-frame-pointer"
DISTDIR="/usr/portage/distfiles"
FEATURES="assume-digests distlocks fixpackages news parallel-fetch protect-owned sandbox sfperms strict unmerge-logs unmerge-orphans userfetch"
GENTOO_MIRRORS="http://distfiles.gentoo.org"
LDFLAGS="-Wl,-O1"
LINGUAS="en_US en"
MAKEOPTS="-j3"
PKGDIR="/usr/portage/packages"
PORTAGE_CONFIGROOT="/"
PORTAGE_RSYNC_OPTS="--recursive --links --safe-links --perms --times --compress --force --whole-file --delete --stats --timeout=180 --exclude=/distfiles --exclude=/local --exclude=/packages"
PORTAGE_TMPDIR="/var/tmp"
PORTDIR="/usr/portage"
SYNC="rsync://rsync.gentoo.org/gentoo-portage"
USE="X a52 aac acl acpi aim alsa amd64 apm audiofile avi bash-completion berkdb branding bzip2 cairo calendar cdda cdparanoia cdr cdrtools cgi clamav cli colordiff consolekit cracklib css ctrype cups curl cxx dbus dri dts dvd dvdr eds emboss encode evo examples fam fbcon festival ffmpeg firefox flac foomaticdb fortran ftp gcj gdbm gif glut gnome gnome-keyring gphoto2 gpm gsm gstreamer gtk gtk2 gtkhtml guile gzip hal handbook hddtemp iconv icq ieee1394 imagemagick imlib ipv6 jabber java java6 javascript jpeg jpeg2k kde kde4 kontact ldap libgda libnotify libwww lirc lm_sensors lua lzo mad maildir mikmod milter mime mmx mng modules mono mp3 mp4 mpeg mpeg4 mpi mplayer mudflap multilib mysql mysqli ncurses nls nntp nptl nptlonly nsplugin nvtv ofx ogg oggvorbis opengl openmp oss pam pcre pdf perl php png ppds pppd python qt qt3support qt4 quicktime rdesktop readline reflection rss ruby samba sdl session slang smp sndfile soap sockets spell spl sqlite sqlite3 sse sse2 ssl startup-notification subversion suid svg symlink sysfs syslog sysvipc tcl tcltk tcpd theora threads thunar tidy tiff timidity tk tokenizer truetype unicode usb v4l v4l2 vcd vhost videos vnc vorbis webkit wmf wxwidgets x264 xcb xcomposite xft xine xinerama xinetd xml xorg xpm xscreensaver xsl xulrunner xv xvid yahoo zeroconf zlib" ALSA_CARDS="ali5451 als4000 atiixp atiixp-modem bt87x ca0106 cmipci emu10k1x ens1370 ens1371 es1938 es1968 fm801 hda-intel intel8x0 intel8x0m maestro3 trident usb-audio via82xx via82xx-modem ymfpci" ALSA_PCM_PLUGINS="adpcm alaw asym copy dmix dshare dsnoop empty extplug file hooks iec958 ioplug ladspa lfloat linear meter mmap_emul mulaw multi null plug rate route share shm softvol" APACHE2_MODULES="actions alias auth_basic authn_alias authn_anon authn_dbm authn_default authn_file authz_dbm authz_default authz_groupfile authz_host authz_owner authz_user autoindex cache dav dav_fs dav_lock deflate dir disk_cache env expires ext_filter file_cache filter headers include info log_config logio mem_cache mime mime_magic negotiation rewrite setenvif speling status unique_id userdir usertrack vhost_alias" ELIBC="glibc" INPUT_DEVICES="evdev mouse keyboard" KERNEL="linux" LCD_DEVICES="bayrad cfontz cfontz633 glk hd44780 lb216 lcdm001 mtxorb ncurses text" LINGUAS="en_US en" RUBY_TARGETS="ruby18" USERLAND="GNU" VIDEO_CARDS="nvidia"
Unset: CPPFLAGS, CTARGET, EMERGE_DEFAULT_OPTS, FFLAGS, INSTALL_MASK, LANG, LC_ALL, PORTAGE_COMPRESS, PORTAGE_COMPRESS_FLAGS, PORTAGE_RSYNC_EXTRA_OPTS, PORTDIR_OVERLAY
bopper akonadi #
XDG_DATA_DIRS is
$ echo $XDG_DATA_DIRS
/usr/share:/usr/local/share:/usr/share:/usr/share/gdm
I have deleted the ~/.local/akonadi directory and rebooted as was recommended in one of the posts several times. That did not help. Other posts helped me to get mysql working.
There have been a couple of times when I was able to log out and log in again with no error messages and my contacts list appeared inside Kontact, but the error message reappeared when I rebooted.
I don't know what do do next and would appreciate any advice you can give me to get going. |
|
| Back to top |
|
 |
Featherfoot
Veteran
Joined: 28 Dec 2002
Posts: 1108
Location: Stuart, Florida
|
| Posted: Fri Mar 12, 2010 1:35 am Post subject: |
|
|
Things are getting worse.
I deleted .~/.local/share/akonadi again and rebooted again. This time I get akonadi server not registering with dbus:
| Code: |
est 10: 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.
|
There are a bunch of dbus's running:
| Code: |
bopper kde-base # ps -A | grep dbus
3404 ? 00:00:00 dbus-daemon
3876 ? 00:00:00 dbus-launch
3877 ? 00:00:00 dbus-daemon
4238 ? 00:00:00 dbus-launch
4239 ? 00:00:01 dbus-daemon
bopper kde-base #
|
|
|
| Back to top |
|
|
Mike Hunt
Watchman
Joined: 19 Jul 2009
Posts: 5287
|
| Posted: Fri Mar 12, 2010 1:37 am Post subject: |
|
|
I also have all those dbus processess running, but no problems, so that's not it.
I suppose you could try (re)moving the $HOME/.config/akonadi/ folder and restarting your KDE session. |
|
| Back to top |
|
|
Featherfoot
Veteran
Joined: 28 Dec 2002
Posts: 1108
Location: Stuart, Florida
|
| Posted: Fri Mar 12, 2010 1:55 am Post subject: |
|
|
Things are still unhappy: The server isn't hooking up with DBus, no resource agents were found. Now I'm also getting
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/jc/.config/akonadi/akonadiserverrc':
[%General]
Driver=QMYSQL
SizeThreshold=4096
ExternalPayload=false
[QMYSQL]
Name=akonadi
Host=
User=
Password=
Options="UNIX_SOCKET=/home/jc/.local/share/akonadi/db_misc/mysql.socket"
ServerPath=/usr/sbin/mysqld
StartServer=true
[Debug]
Tracer=null
Test 2: SUCCESS
--------
MySQL server found.
Details: You currently have 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 locations varies depending on the distribution.
Test 3: SUCCESS
--------
MySQL server is executable.
Details: MySQL server found: /usr/sbin/mysqld Ver 5.0.90-log for pc-linux-gnu on x86_64 (Gentoo Linux mysql-5.0.90-r2)
Test 4: SUCCESS
--------
No current MySQL error log found.
Details: The MySQL server did not report any errors during this startup into '/home/jc/.local/share/akonadi/db_data/mysql.err'.
Test 5: SUCCESS
--------
MySQL server default configuration found.
Details: The default configuration for the MySQL server was found and is readable at <a href='/usr/share/config/akonadi/mysql-global.conf'>/usr/share/config/akonadi/mysql-global.conf</a>.
File content of '/usr/share/config/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]
skip_grant_tables
skip_networking
# 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
# use InnoDB for transactions and better crash recovery
default_storage_engine=innodb
# case-insensitive table names, avoids trouble on windows
lower_case_table_names=1
character_set_server=latin1
collation_server=latin1_general_ci
table_cache=200
thread_cache_size=3
log_bin=mysql-bin
expire_logs_days=3
#sync_bin_log=0
# error log file name, relative to datadir
log_error=mysql.err
log_warnings=2
# 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
# maximum blob size
max_allowed_packet=32M
max_connections=256
# makes sense when having the same query multiple times
# makes no sense with prepared statements and/or transactions
query_cache_type=0
query_cache_size=0
innodb_file_per_table=1
innodb_log_buffer_size=1M
innodb_additional_mem_pool_size=1M
# messure database size and adjust
# SELECT sum(data_length) as bla, sum(index_length) as blub FROM information_schema.tables WHERE table_schema not in ("mysql", "information_schema");
innodb_buffer_pool_size=80M
# size of average write burst, keep Innob_log_waits small, keep Innodb_buffer_pool_wait_free small (see show global status like "inno%", show global variables)
innodb_log_file_size=64M
innodb_flush_log_at_trx_commit=2
Test 6: SKIP
--------
MySQL server custom configuration not available.
Details: The custom configuration for the MySQL server was not found but is optional.
Test 7: SUCCESS
--------
MySQL server configuration is usable.
Details: The MySQL server configuration was found at <a href='/home/jc/.local/share/akonadi/mysql.conf'>/home/jc/.local/share/akonadi/mysql.conf</a> and is readable.
File content of '/home/jc/.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@mysql.com>
#
[mysqld]
skip_grant_tables
skip_networking
# 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
# use InnoDB for transactions and better crash recovery
default_storage_engine=innodb
# case-insensitive table names, avoids trouble on windows
lower_case_table_names=1
character_set_server=latin1
collation_server=latin1_general_ci
table_cache=200
thread_cache_size=3
log_bin=mysql-bin
expire_logs_days=3
#sync_bin_log=0
# error log file name, relative to datadir
log_error=mysql.err
log_warnings=2
# 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
# maximum blob size
max_allowed_packet=32M
max_connections=256
# makes sense when having the same query multiple times
# makes no sense with prepared statements and/or transactions
query_cache_type=0
query_cache_size=0
innodb_file_per_table=1
innodb_log_buffer_size=1M
innodb_additional_mem_pool_size=1M
# messure database size and adjust
# SELECT sum(data_length) as bla, sum(index_length) as blub FROM information_schema.tables WHERE table_schema not in ("mysql", "information_schema");
innodb_buffer_pool_size=80M
# size of average write burst, keep Innob_log_waits small, keep Innodb_buffer_pool_wait_free small (see show global status like "inno%", show global variables)
innodb_log_file_size=64M
innodb_flush_log_at_trx_commit=2
Test 8: 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.3.1
Test 9: SUCCESS
--------
Akonadi control process registered at D-Bus.
Details: The Akonadi control process is registered at D-Bus which typically indicates it is operational.
Test 10: 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 11: SUCCESS
--------
Nepomuk search service registered at D-Bus.
Details: The Nepomuk search service is registered at D-Bus which typically indicates it is operational.
Test 12: SUCCESS
--------
Nepomuk search service uses an appropriate backend.
Details: The Nepomuk search service uses one of the recommended backends.
Test 13: 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 14: 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 /usr/share/akonadi/agents'. The XDG_DATA_DIRS environment variable is set to '/usr/share:/usr/local/share:/usr/share:/usr/share/gdm', make sure this includes all paths where Akonadi agents are installed to.
Directory listing of '/usr/share/akonadi/agents':
birthdaysresource.desktop
contactsresource.desktop
icalresource.desktop
imapresource.desktop
kabcresource.desktop
kcalresource.desktop
knutresource.desktop
kolabproxyresource.desktop
localbookmarksresource.desktop
maildirresource.desktop
maildispatcheragent.desktop
mboxresource.desktop
microblog.desktop
mtdummyresource.desktop
nepomukcalendarfeeder.desktop
nepomukcontactfeeder.desktop
nepomuktagresource.desktop
nntpresource.desktop
notesresource.desktop
pop3resource.desktop
vcarddirresource.desktop
vcardresource.desktop
Directory listing of '/usr/share/akonadi/agents':
birthdaysresource.desktop
contactsresource.desktop
icalresource.desktop
imapresource.desktop
kabcresource.desktop
kcalresource.desktop
knutresource.desktop
kolabproxyresource.desktop
localbookmarksresource.desktop
maildirresource.desktop
maildispatcheragent.desktop
mboxresource.desktop
microblog.desktop
mtdummyresource.desktop
nepomukcalendarfeeder.desktop
nepomukcontactfeeder.desktop
nepomuktagresource.desktop
nntpresource.desktop
notesresource.desktop
pop3resource.desktop
vcarddirresource.desktop
vcardresource.desktop
Environment variable XDG_DATA_DIRS is set to '/usr/share:/usr/local/share:/usr/share:/usr/share/gdm'
Test 15: SUCCESS
--------
No current Akonadi server error log found.
Details: The Akonadi server did not report any errors during its current startup.
Test 16: SUCCESS
--------
No previous Akonadi server error log found.
Details: The Akonadi server did not report any errors during its previous startup.
Test 17: SUCCESS
--------
No current Akonadi control error log found.
Details: The Akonadi control process did not report any errors during its current startup.
Test 18: SUCCESS
--------
No previous Akonadi control error log found.
Details: The Akonadi control process did not report any errors during its previous startup.
I'm also getting the following error message when I start:
The file /home/jc/.local/share/akonadi/db_data/mysql.err could not be loaded, as it was not possible to read from it.
Check if you have read access to this file.
I checked the file and got the following:
jc@bopper ~/.local/share/akonadi/db_data $ ls -al
total 141479
drwxr-xr-x 3 jc jc 288 Mar 11 20:50 .
drwxr-xr-x 5 jc jc 200 Mar 11 20:50 ..
drwx------ 2 jc jc 952 Mar 11 20:50 akonadi
-rw-rw---- 1 jc jc 5 Mar 11 20:50 bopper.pid
-rw-rw---- 1 jc jc 67108864 Mar 11 20:50 ib_logfile0
-rw-rw---- 1 jc jc 67108864 Mar 11 20:50 ib_logfile1
-rw-rw---- 1 jc jc 10485760 Mar 11 20:50 ibdata1
-rw-rw---- 1 jc jc 12890 Mar 11 20:50 mysql-bin.000001
-rw-rw---- 1 jc jc 19 Mar 11 20:50 mysql-bin.index
-rw-rw---- 1 jc jc 1256 Mar 11 20:50 mysql.err
jc@bopper ~/.local/share/akonadi/db_data $ cat mysql.err
InnoDB: The InnoDB memory heap is disabled
InnoDB: use atomic builtins.
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
100311 20:50:15 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
100311 20:50:17 InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 64 MB
InnoDB: Database physically writes the file full: wait...
100311 20:50:21 InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 64 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
100311 20:50:25 InnoDB: Started; log sequence number 0 0
100311 20:50:25 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them
100311 20:50:25 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.90-log' socket: '/home/jc/.local/share/akonadi/db_misc/mysql.socket' port: 0 Gentoo Linux mysql-5.0.90-r2
jc@bopper ~/.local/share/akonadi/db_data $
|
|
| Back to top |
|
|
Mike Hunt
Watchman
Joined: 19 Jul 2009
Posts: 5287
|
| Posted: Fri Mar 12, 2010 3:13 am Post subject: |
|
|
Weird.
There is one thread about similar issues that claims the following fixed it.
| Code: | # revdep-rebuild --library libmysqlclient.so.15
# revdep-rebuild --library libmysqlclient_r.so.15
# perl-cleaner reallyall |
Of course, I would check again that mysql and dbus are in fact started and not crashed. |
|
| Back to top |
|
|
albright
Advocate
Joined: 16 Nov 2003
Posts: 2588
Location: Near Toronto
|
| Posted: Fri Mar 12, 2010 3:40 am Post subject: |
|
|
I don't know if akonadi's use of mysql requires that the user
have set up a default database but if you haven't done
that it might be worth a try (see mysql emerge messages
for instructions).
_________________
.... there is nothing - absolutely nothing - half so much worth
doing as simply messing about with Linux ...
(apologies to Kenneth Graeme) |
|
| Back to top |
|
|
Featherfoot
Veteran
Joined: 28 Dec 2002
Posts: 1108
Location: Stuart, Florida
|
| Posted: Fri Mar 12, 2010 3:47 am Post subject: |
|
|
I haven't gotten any error messages about MySQL not starting lately. That part seems like it has been working well.
A bunch of dbus's are starting and mysqld is running.
Doing the revdep-rebuilds for the third time now... We'll see. |
|
| Back to top |
|
|
Featherfoot
Veteran
Joined: 28 Dec 2002
Posts: 1108
Location: Stuart, Florida
|
| Posted: Fri Mar 12, 2010 4:42 am Post subject: |
|
|
| Still the same problem after doing the revdep-rebuilds for the third time. |
|
| Back to top |
|
|
Featherfoot
Veteran
Joined: 28 Dec 2002
Posts: 1108
Location: Stuart, Florida
|
| Posted: Fri Mar 12, 2010 4:57 am Post subject: |
|
|
Very odd things.
If I delete the old error logs and log out, when I log back in again, akonadi appears to start correctly and kontact works.
If I delete the old error logs, terminate kontact, and reboot, akonadi appears to start correctly and kontact works.
If I reboot with kontact running, when I log in, I get the error messages. |
|
| Back to top |
|
|
pingz
n00b
Joined: 21 Mar 2010
Posts: 1
|
|
| Back to top |
|
|
Featherfoot
Veteran
Joined: 28 Dec 2002
Posts: 1108
Location: Stuart, Florida
|
| Posted: Mon Mar 22, 2010 1:08 am Post subject: |
|
|
It helps a lot. It fixed it.
Thank you for your help. |
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
Desktop Environments
