Re: akonadi failing to connect to database

2013-07-20 Thread Brad Alexander
On Sat, Jul 20, 2013 at 8:34 AM, Kevin Krammer kevin.kram...@gmx.at wrote:


 Hmm.
 Can you run the mysqld command manually?
 for me it looks like:
 /usr/sbin/mysqld \\
 --defaults-file=/home/kevin/.local/share/akonadi/mysql.conf \\
 --datadir=/home/kevin/.local/share/akonadi/db_data/ \\
 --socket=/home/kevin/.local/share/akonadi/socket-persephone/mysql.socket


I cannot Running the equivalent command on my machine gives me

130720 12:17:45 [Warning] One can only use the --user switch if running as
root

130720 12:17:45 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
130720 12:17:45 [ERROR] Can't open the mysql.plugin table. Please run
mysql_upgrade to create it.
130720 12:17:45 InnoDB: The InnoDB memory heap is disabled
130720 12:17:45 InnoDB: Mutexes and rw_locks use GCC atomic builtins
130720 12:17:45 InnoDB: Compressed tables use zlib 1.2.7
130720 12:17:45 InnoDB: Using Linux native AIO
130720 12:17:45 InnoDB: Initializing buffer pool, size = 128.0M
130720 12:17:45 InnoDB: Completed initialization of buffer pool
InnoDB: Error: log file ./ib_logfile0 is of different size 0 67108864 bytes
InnoDB: than specified in the .cnf file 0 5242880 bytes!
130720 12:17:45 [ERROR] Plugin 'InnoDB' init function returned error.
130720 12:17:45 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE
failed.
130720 12:17:45 [ERROR] /usr/sbin/mysqld: unknown variable
'defaults=/home/storm/.local/share/akonadi/mysql.conf'
130720 12:17:45 [ERROR] Aborting

130720 12:17:45 [Note] /usr/sbin/mysqld: Shutdown complete

Now, having said that, the blunt-force trauma approach seems to have
worked. I deleted $HOME/.config/akonadi and $HOME/.local/share/akonadi
seems to have done the trick. kmail/kontact  is working now.

Thanks all!
--b


Re: akonadi failing to connect to database

2013-07-19 Thread Brad Alexander
Thanks Kevin. I think this is what is broken. It's got a split brained
config. So let me ask this...Which is a better backend? PostgresQL, MySQL
or SQLITE? My understanding is that sqlite is not as heavy as mysql, at the
cost of one thread (or query) at a time. Having said that, I know nothing
about this particular use case.  And if MySQL is the right answer, can I
use MariaDB?

Thanks,
--b


On Thu, Jul 18, 2013 at 7:26 PM, Kevin Krammer kevin.kram...@gmx.at wrote:

 On Thursday, 2013-07-18, Brad Alexander wrote:

  Is there a config file that I should get rid of and just let it configure
  from defaults? I tried dpkg-reconfigure akonadi-backend-sqlite
  akonadi-server akonadiconsole but it had the same behavior after doing
 so.

 The package doesn't change any user level configuration.
 You probably have to install akonadi-backend-mysql or change the config
 $HOME/.config/akonadi/akonadiserverrc so that it uses QSQLITE3 instead of
 QMYSQL as the driver.

 Cheers,
 Kevin



Re: Re: akonadi failing to connect to database

2013-07-19 Thread Diederik de Haas
On Friday 19 July 2013 08:22:03 Brad Alexander wrote:
 Which is a better backend? PostgresQL, MySQL or SQLITE? 

MySQL is (by far) the most tested. PostgreSQL should probably work too (but 
haven't tried it). SQLite is AFAIK 'too light' for nepomuk/akonadi.

 And if MySQL is the right answer, can I use MariaDB?

I wouldn't do that until MariaDB gets into the debian archive.
-- 
GPG: 0x138E41915C7EFED6

signature.asc
Description: This is a digitally signed message part.


akonadi failing to connect to database

2013-07-18 Thread Brad Alexander
I was trying to get kmail working since my upgrade to 4.10. I never got it
working in 4.8.4 either, with similar errors. I looked online, but akonadi
troubleshooting tips are all over the board. I found some for 4.3, and on
the KDE wiki has one troubleshooting tip for Can't read any details of
some messages or big delays to read it so I thought I would ask here.

When I opened kmail, it tried to transition to 4.10, and the first step was
to start akonadi. It failed after a few minutes. Tests 1, 2, and 6 passed,
tests 3, 4, and 5 (the mysql stuff) were untested.

Test 7:  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 8:  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 9:  ERROR


Nepomuk search service not registered at D-Bus.
Details: The Nepomuk search service is not registered at D-Bus which
typically means it was not started or encountered a fatal error during
startup.

Test 10:  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 11:  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:/usr/share:/usr/local/share'; make sure this includes all
paths where Akonadi agents are installed.

Directory listing of '/usr/share/akonadi/agents':
akonadinepomukfeederagent.desktop
akonotesresource.desktop
archivemailagent.desktop
birthdaysresource.desktop
contactsresource.desktop
davgroupwareresource.desktop
icaldirresource.desktop
icalresource.desktop
imapresource.desktop
invitationsagent.desktop
kabcresource.desktop
kalarmdirresource.desktop
kalarmresource.desktop
kcalresource.desktop
kdeaccountsresource.desktop
knutresource.desktop
localbookmarksresource.desktop
maildirresource.desktop
maildispatcheragent.desktop
mailfilteragent.desktop
mboxresource.desktop
microblog.desktop
mixedmaildirresource.desktop
mtdummyresource.desktop
nepomuktagresource.desktop
nntpresource.desktop
notesresource.desktop
openxchangeresource.desktop
pop3resource.desktop
vcarddirresource.desktop
vcardresource.desktop

Environment variable XDG_DATA_DIRS is set to
'/usr/share:/usr/share:/usr/local/share'

Test 12:  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='/home/storm/.local/share/akonadi/akonadiserver.error'/home/storm/.local/share/akonadi/akonadiserver.error/a.

File '/home/storm/.local/share/akonadi/akonadiserver.error' could not be
opened

Test 13:  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='/home/storm/.local/share/akonadi/akonadiserver.error.old'/home/storm/.local/share/akonadi/akonadiserver.error.old/a.

File '/home/storm/.local/share/akonadi/akonadiserver.error.old' could not
be opened

Test 14:  SUCCESS


No current Akonadi control error log found.
Details: The Akonadi control process did not report any errors during its
current startup.

Test 15:  SUCCESS


No previous Akonadi control error log found.
Details: The Akonadi control process did not report any errors during its
previous startup.


Now in the error log, I see lines like

Database error: Cannot open database.
  Last driver error: QMYSQL: Unable to connect
  Last database error: Can't connect to local MySQL server through socket
'/home/storm/.local/share/akonadi/socket-defiant/mysql.socket' (2)
Unable to open database Can't connect to local MySQL server through socket
'/home/storm/.local/share/akonadi/socket-defiant/mysql.socket' (2) QMYSQL:
Unable to connect
[
0: akonadiserver() [0x418114]
1: akonadiserver() [0x418541]
2: /lib/x86_64-linux-gnu/libc.so.6(+0x35260) [0x7f8236c4f260]
3: /lib/x86_64-linux-gnu/libc.so.6(gsignal+0x35) [0x7f8236c4f1e5]
4: /lib/x86_64-linux-gnu/libc.so.6(abort+0x148) [0x7f8236c52398]
5:
/usr/lib/x86_64-linux-gnu/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x102)
[0x7f82386f8912]
6: akonadiserver() [0x41a3eb]
7: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0xb0)
[0x7f8238793190]
8: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(+0x11858d) [0x7f82387a058d]
9: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x33)
[0x7f82387a9173]
10: akonadiserver() [0x41d2cd]
11: akonadiserver() [0x41e487]
12: 

Re: akonadi failing to connect to database

2013-07-18 Thread David Baron
My akonadi works ... until it doesn't
Had few if any problems with 4.8
4.10 from the beginning, kmail is quite flakey.
Messages will sort of dissappear, the number in 
the folder will show but no message. Until I restart 
kmail.
After a while, mail resources broken, on line.
Must restart kde to get off that one.