no kdepim4 application work.

[mparchet@…]

I have install the kdepim4 package but no program no program work.

Have you already test some program of this package.

Is there a bug ?

See attachment the reports.

Can you help me please ?

Best regards

mparchet

[nerdling (Jeremy Lavergne)]

Has duplicate #33984.

[ryandesign (Ryan Carsten Schmidt)]

Why Cc me? I don't know anything about KDE...

[nerdling (Jeremy Lavergne)]

Replying to ryandesign@…:

Why Cc me? I don't know anything about KDE...

Simply because in the past you had updated the akonadi port.

[mparchet@…]

Hello,

it seems that qtSQLdriver or qtSQL is missing.

With port contain this driver ?

Best regards

mparchet

[bjoern.ricks@…]

You need to build qt-mac with mysql to be able to run akonadi with mysql database backend or change your the akonadiserverrc manually to use the sqlite3 backend.

[mparchet@…]

Hello,

I have installed the mariadb package.

Is it compatible with the QMYSQL driver ?

Tanks for your answer.

Best regards

mparchet

[mkae (Marko Käning)]

Cc Me!

[mparchet@…]

Hello,

It seems that the mysql driver is missing.

Witch macport package content the mysql driver require by the akonadi server ?

Tanks for your help.

Best regares

mpardchet

[mparchet@…]

Hello,

I can't find the mysql5 driver required by the akonadi server. Where is it ?

Can you help me please ?

Best regards

mparchet

[mkae (Marko Käning)]

Ah, ok, I figured it out, you started akonadi using akonadictl! I see the same errors:

$ /opt/macports-test/bin/akonadictl start
Starting Akonadi Server...
   done.
Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
search paths:  ("/Users/marko/bin", "/opt/macports-test/bin", "/opt/macports-test/sbin", "/opt/macports-test/libexec/gnubin", "/usr/bin", "/bin", "/usr/sbin", "/sbin", "/usr/local/bin", "/usr/local/MacGPG2/bin", "/usr/texbin", "/usr/X11/bin", "/usr/sbin", "/usr/local/sbin", "/usr/local/libexec", "/usr/libexec", "/opt/mysql/libexec", "/opt/local/lib/mysql5/bin", "/opt/mysql/sbin", "/Applications/KDE4") 
Found mysql_install_db:  "" 
Found mysqlcheck:  "" 
QSqlDatabase: QMYSQL driver not loaded
QSqlDatabase: available drivers: QSQLITE
Invalid database object during database server startup
"[
0: 0   akonadiserver                       0x000000010000b43b _Z11akBacktracev + 59
1: 1   akonadiserver                       0x000000010000b78c _ZL19defaultCrashHandleri + 268
2: 2   libSystem.B.dylib                   0x00007fff8a4841ba _sigtramp + 26
3: 3   ???                                 0x000000000008d9a0 0x0 + 580000
4: 4   libQtCore.4.dylib                   0x0000000100220b85 _Z17qt_message_output9QtMsgTypePKc + 117
5: 5   akonadiserver                       0x000000010000d75a _ZN15FileDebugStream9writeDataEPKcx + 170
6: 6   libQtCore.4.dylib                   0x00000001002c84d0 _ZN9QIODevice5writeEPKcx + 128
7: 7   libQtCore.4.dylib                   0x00000001002d55f6 _ZN18QTextStreamPrivate16flushWriteBufferEv + 230
8: 8   libQtCore.4.dylib                   0x00000001002d5958 _ZN11QTextStreamD2Ev + 104
9: 9   akonadiserver                       0x00000001000b36b3 _ZN13DbConfigMysql19startInternalServerEv + 10675
10: 10  akonadiserver                       0x000000010000fb8a _ZN7Akonadi13AkonadiServer20startDatabaseProcessEv + 202
11: 11  akonadiserver                       0x0000000100011fd0 _ZN7Akonadi13AkonadiServerC2EP7QObject + 192
12: 12  akonadiserver                       0x00000001000139a7 _ZN7Akonadi13AkonadiServer8instanceEv + 71
13: 13  akonadiserver                       0x00000001000044ef main + 975
14: 14  akonadiserver                       0x00000001000040e8 start + 52
15: 15  ???                                 0x0000000000000001 0x0 + 1
]
"
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
.
.
.
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
"akonadiserver" crashed too often and will not be restarted!

Well, there is the connection to a deprecated signal. Hmm, could it perhaps be that akonadi never worked on MacOSX?

[mkae (Marko Käning)]

BTW, mparchet, did you install qt4-mac in its mysql-variant?

[mkae (Marko Käning)]

Try this:

$ sudo port install qt4-mac-mysql5-plugin

and you will get

$ /opt/macports-test/bin/akonadictl start
Starting Akonadi Server...
   done.
Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
search paths:  ("/Users/marko/bin", "/opt/macports-test/bin", "/opt/macports-test/sbin", "/opt/macports-test/libexec/gnubin", "/usr/bin", "/bin", "/usr/sbin", "/sbin", "/usr/local/bin", "/usr/local/MacGPG2/bin", "/usr/texbin", "/usr/X11/bin", "/usr/sbin", "/usr/local/sbin", "/usr/local/libexec", "/usr/libexec", "/opt/mysql/libexec", "/opt/local/lib/mysql5/bin", "/opt/mysql/sbin", "/Applications/KDE4") 
Found mysql_install_db:  "" 
Found mysqlcheck:  "" 
Failed to use database "akonadi" 
Query error: "Unknown database 'akonadi' QMYSQL: Unable to execute query" 
Database error: " " 
Trying to create database now... 
Database "akonadi" opened using driver "QMYSQL" 
DbInitializer::run() 
checking table  "SchemaVersionTable" 
"CREATE TABLE SchemaVersionTable (version INTEGER NOT NULL DEFAULT 0)  COLLATE=utf8_general_ci DEFAULT CHARSET=utf8" 
"INSERT INTO SchemaVersionTable (version) VALUES (20)" 
checking table  "ResourceTable" 
"CREATE TABLE ResourceTable (id BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY, name VARBINARY(255) NOT NULL UNIQUE, isVirtual BOOL DEFAULT false)  COLLATE=utf8_general_ci DEFAULT CHARSET=utf8" 
"INSERT INTO ResourceTable (name,isVirtual) VALUES ('akonadi_search_resource',true)" 
checking table  "CollectionTable" 
"CREATE TABLE CollectionTable (id BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY, remoteId VARBINARY(255), remoteRevision VARBINARY(255), name VARBINARY(255) NOT NULL, parentId BIGINT, resourceId BIGINT NOT NULL, subscribed BOOL NOT NULL DEFAULT true, cachePolicyInherit BOOL NOT NULL DEFAULT true, cachePolicyCheckInterval INTEGER NOT NULL DEFAULT -1, cachePolicyCacheTimeout INTEGER NOT NULL DEFAULT -1, cachePolicySyncOnDemand BOOL NOT NULL DEFAULT false, cachePolicyLocalParts VARBINARY(255), queryString VARBINARY(1024), queryLanguage VARBINARY(255), FOREIGN KEY (parentId) REFERENCES CollectionTable(id) ON DELETE CASCADE ON UPDATE CASCADE, FOREIGN KEY (resourceId) REFERENCES ResourceTable(id) ON DELETE CASCADE ON UPDATE CASCADE)  COLLATE=utf8_general_ci DEFAULT CHARSET=utf8" 
adding index "CREATE UNIQUE INDEX CollectionTable_parentAndNameIndex ON CollectionTable (parentId,name)" 
"INSERT INTO CollectionTable (resourceId,name,parentId) VALUES (1,'Search',NULL)" 
checking table  "MimeTypeTable" 
.
.
.

i.e. a successfully installed akonadi database.

[mkae (Marko Käning)]

OK, this means port qt4-mac-mysql*-plugin needs to be a dependency for akonadi. Since several different plugin subports are available the akonadi port probably should automatically select the correct port for the user. I hope that the more experienced portfile authors can come up with a more general solution as the quick fix in my previous comment.

[ryandesign (Ryan Carsten Schmidt)]

Cc Me!

[pixilla (Bradley Giesbrecht)]

mparchet@…:

Which MacPorts mysql ports do you have installed?

What qt4-mac-*-plugin mysql port do you have active?

What commands did you execute to produced the two error/reports?

[mparchet@…]

Hello,

Here is your questions and the answers.

Which MacPorts mysql ports do you have installed?

the following ports are currently installed:
  mysql5 @5.1.63_0
  mysql5 @5.1.65_0
  mysql5 @5.1.66_0
  mysql5 @5.1.66_1 (active)

With a mysql_secure_installation5

What qt4-mac-*-plugin mysql port do you have active?

The following ports are currently installed:
  qt4-mac-mysql5-plugin @4.8.3_0 (active)

There is a mysql error log file attachment.

Tanks for your help

Best regards

mparchet

[mparchet@…]

Hello,

I have do some tests on a linux virtual machine and I realized that the akonadi server hadn't correctly configured. So I would like to configure the akonadi server with my mysql username's and password.

In witch files should I Put my mysql login data ?

Tanks for your help.

Best regards

mparchet

[mparchet@…]

Hello,

the config file is heare

/.config/akonadi/akonadiserverrc 

my parametters is :

Name=akonadi
Host="127.0.0.1"
ServerPath=/opt/local/libexec/mysqld
StartServer=true
User=username
Password=password

Now I have a problem with dbus.

See attachment for more details.

Can you help me please ?

Best regards

mparchet

[mkae (Marko Käning)]

Your selftest indicates that your MySQL database is corrupted. If I were you I'd try to run some maintenance on MySQL first before proceeding with these akonadi issues.

InnoDB: Cannot initialize created log files because
62	InnoDB: data files are corrupt, or new data files were
63	InnoDB: created when the database was started previous
64	InnoDB: time but the database was not shut down
65	InnoDB: normally after that.
66	121024  0:18:31 [ERROR] Plugin 'InnoDB' init function returned error.
67	121024  0:18:31 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
68	121024  0:18:31 [ERROR] Unknown/unsupported table type: innodb
69	121024  0:18:31 [ERROR] Aborting

I don't know why it is claimed that innodb tables aren't supported...

I have the following installed:

$ port installed *mysql*
The following ports are currently installed:
  mysql5 @5.1.66_1 (active)
  mysql5-connector-cpp @1.1.1_0 (active)
  mysql5-server @5.1.66_1 (active)
  mysql_select @0.1.2_0 (active)
  qt4-mac-mysql5-plugin @4.8.3_0 (active)

and it works, as if I have shown further up.

Here is my config:

[%General]
Driver=QMYSQL

[QMYSQL]
Name=akonadi
Host=
Options="UNIX_SOCKET=/Users/marko/.local/share/akonadi/socket-markos-imac/mysql.socket"
ServerPath=/opt/macports-test/libexec/mysqld
StartServer=true

[Debug]
Tracer=null

You see, my host entry is empty and there's no login info present either.

[mparchet@…]

Hello,

I have check my mysql5 configuration with mysqlcheck5 utility and I have found this error.

my command line is :

mysqlcheck5 -u username -ppassword --auto-repair --all-databases

See attachment for details.

Can you help me please ?

Best regards

mparchet

[mkae (Marko Käning)]

I do see the same output like you (i.e. with those two errors) here with akonadi working.

[pixilla (Bradley Giesbrecht)]

Replying to mparchet@…:

I have check my mysql5 configuration with mysqlcheck5 utility and I have found this error.

This is an old mysql ​issue 30487.

[mparchet@…]

Hello,

If it's a mysql issus, I think that the mysql5 @5.1.66 is out of date.

Can you update mysql ?

There is also a D-Bus and no resource agent found problem.

What is it ?

Can you help me please ?

Best regards

mparchet

PS how to configure akonadi server to use mariadb or postgreesql ?

mparchet

[ryandesign (Ryan Carsten Schmidt)]

Replying to mparchet@…:

PS how to configure akonadi server to use mariadb or postgreesql ?

File a new ticket requesting these database variants be added to the akonadi port.

[mkae (Marko Käning)]

akonadi was updated to 1.8.0 (#36098). Does this change something for you?

[mparchet@…]

Replying to pixilla@…:

Replying to mparchet@…:

I have check my mysql5 configuration with mysqlcheck5 utility and I have found this error.

This is an old mysql ​issue 30487.

Hello,

I have opened an invalid ticket about a mysql5 update request : 36815.

Where is the problem ?

1. kdepim4
2. Akonadi
3. Mysql5
4. Other

Thanks for your answer.

Best regards

mparchet

[mkae (Marko Käning)]

Replying to mk@…:

Your selftest indicates that your MySQL database is corrupted. If I were you I'd try to run some maintenance on MySQL first before proceeding with these akonadi issues.

InnoDB: Cannot initialize created log files because
62	InnoDB: data files are corrupt, or new data files were
63	InnoDB: created when the database was started previous
64	InnoDB: time but the database was not shut down
65	InnoDB: normally after that.
66	121024  0:18:31 [ERROR] Plugin 'InnoDB' init function returned error.
67	121024  0:18:31 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
68	121024  0:18:31 [ERROR] Unknown/unsupported table type: innodb
69	121024  0:18:31 [ERROR] Aborting

I don't know why it is claimed that innodb tables aren't supported...

I think this error is the one to focus on!

Pixilla, do you have an idea what's going on here? Is that also expected behaviour?

[michaelld (Michael Dickens)]

Cc Me!

[mkae (Marko Käning)]

Can we close this one here, mparchet?

[mkae (Marko Käning)]

P@sNox, regarding our IRC conversation, can you please crosscheck whether you're seeing the same issues as described here.

Please post your solution to this ticket, once you were successful setting up akonadi properly.

[pasnox@…]

Akonadi seems to start and working fine when started by hand following these steps:

• make sure to isntall mysql / maria db server, it seems to not be a dependancy of kde pim yet
• make sure to stop all akonadi things if needed (check using this command: ps aux | grep akonadi, and use killall -9 progName)
• make sure to kill / close kontact or any pim application
• start from terminal this script: akonadiserver-script.sh
• This should start akonadi and the agents / resources.
• Start kontact and wait (it could take many seconds before being responsive).

From now all pims application should works.

We need to find a way to auto start the script at user startup so the akonadi session is fine. Else if we try to start kontact before the script the things will not run fines and we will have many zombies to kill.

[barracuda156]

Replying to mkae:

akonadi is clearly broken since it gives out the same sqlite error even when SQlite backend is explicitly disabled (same error regardless). I.e., I build +mysql55 and -DINSTALL_QSQLITE_IN_QT_PREFIX=Off -DAKONADI_BUILD_QSQLITE=Off and it still starts with:

QSqlDatabase: QSQLITE3 driver not loaded
QSqlDatabase: available drivers: QSQLITE QMYSQL3 QMYSQL
Invalid database object during initial database connection
"[
0: 0   akonadiserver                       0x00007dc0 _Z11akBacktracev + 72
1: 1   akonadiserver                       0x0000822c _ZL19defaultCrashHandleri + 100
2: 2   libSystem.B.dylib                   0x00ba6294 _sigtramp + 68
3: 3   libSystem.B.dylib                   0x00b290b8 szone_malloc + 292
4: 4   ???                                 0x653c3cf8 0x0 + 1698446584
]
"
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)

It also uses a wrong name for the plugin, as you can see.

[barracuda156]

Patching out wrong name usage removes that error, but it is still broken:

36-244% /opt/local/bin/akonadiserver-script.sh
Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
36-244% QSqlDatabasePrivate::removeDatabase: connection 'initConnection' is still in use, all queries will cease to work.
QSqlDatabasePrivate::removeDatabase: connection 'initConnection' is still in use, all queries will cease to work.
ProcessControl: Application akonadiserver stopped unexpectedly ( "Process crashed" )
Application 'akonadiserver' crashed! 1 restarts left.
QSqlDatabasePrivate::removeDatabase: connection 'initConnection' is still in use, all queries will cease to work.
QSqlDatabasePrivate::removeDatabase: connection 'initConnection' is still in use, all queries will cease to work.
ProcessControl: Application akonadiserver stopped unexpectedly ( "Process crashed" )
Application 'akonadiserver' crashed! 0 restarts left.
QSqlDatabasePrivate::removeDatabase: connection 'initConnection' is still in use, all queries will cease to work.
QSqlDatabasePrivate::removeDatabase: connection 'initConnection' is still in use, all queries will cease to work.
ProcessControl: Application akonadiserver stopped unexpectedly ( "Process crashed" )
Application 'akonadiserver' crashed too often. Giving up!

Same story with the current port in MacPorts and with the latest Aconadi of 1.13.x branch.