Opened 8 years ago

Last modified 10 months ago

#33998 assigned defect

no kdepim4 application work.

Reported by: mparchet@… Owned by: NicosPavlov
Priority: Normal Milestone:
Component: ports Version: 2.0.4
Keywords: Cc: nerdling (Jeremy Lavergne), bjoern.ricks@…, mkae (Marko Käning), pixilla (Bradley Giesbrecht), pasnox@…
Port: akonadi kdepim4

Description

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

Attachments (8)

akandiserver and korganiser crach report.txt (27.1 KB) - added by mparchet@… 8 years ago.
akonadi-selftest-report-20120410.txt (32.5 KB) - added by mparchet@… 8 years ago.
akonadi-selftest-report-20121017.txt (17.0 KB) - added by mparchet@… 8 years ago.
akonadi-selftest-report-20121017.2.txt (17.0 KB) - added by mparchet@… 8 years ago.
mysql.err (1.4 KB) - added by mparchet@… 8 years ago.
akonadi-selftest-report-20121021.txt (16.9 KB) - added by mparchet@… 8 years ago.
akonadi-selftest-report-20121026.txt (14.4 KB) - added by mparchet@… 8 years ago.
mysqlcheck5 output.txt (1.3 KB) - added by mparchet@… 8 years ago.

Download all attachments as: .zip

Change History (45)

Changed 8 years ago by mparchet@…

Changed 8 years ago by mparchet@…

comment:1 Changed 8 years ago by nerdling (Jeremy Lavergne)

Has duplicate #33984.

comment:2 Changed 8 years ago by nerdling (Jeremy Lavergne)

Keywords: kde4 added; kdepim4 korganizer kadressbook knote removed
Port: akonadi kdepim4 added; kdepimn4 removed

comment:3 Changed 8 years ago by nerdling (Jeremy Lavergne)

Cc: ryandesign@… michaelld@… added

comment:4 Changed 8 years ago by ryandesign (Ryan Schmidt)

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

comment:5 in reply to:  4 Changed 8 years ago by 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.

comment:6 Changed 8 years ago by mparchet@…

Hello,

it seems that qtSQLdriver or qtSQL is missing.

With port contain this driver ?

Best regards

mparchet

comment:7 Changed 8 years ago by 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.

comment:8 Changed 8 years ago by mparchet@…

Hello,

I have installed the mariadb package.

Is it compatible with the QMYSQL driver ?

Tanks for your answer.

Best regards

mparchet

comment:9 Changed 8 years ago by mkae (Marko Käning)

Cc: mk@… added

Cc Me!

comment:10 Changed 8 years ago by 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

Changed 8 years ago by mparchet@…

Changed 8 years ago by mparchet@…

comment:11 Changed 8 years ago by 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

comment:12 Changed 8 years ago by 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?

Last edited 8 years ago by mkae (Marko Käning) (previous) (diff)

comment:13 Changed 8 years ago by mkae (Marko Käning)

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

comment:14 Changed 8 years ago by 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.

comment:15 Changed 8 years ago by 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.

comment:16 Changed 8 years ago by mkae (Marko Käning)

Cc: pixilla@… added

comment:17 Changed 8 years ago by ryandesign (Ryan Schmidt)

Cc: ryandesign@… removed

Cc Me!

Changed 8 years ago by mparchet@…

Attachment: mysql.err added

Changed 8 years ago by mparchet@…

comment:18 Changed 8 years ago by 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?

comment:19 Changed 8 years ago by 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

Last edited 8 years ago by ryandesign (Ryan Schmidt) (previous) (diff)

comment:20 Changed 8 years ago by 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

comment:21 Changed 8 years ago by 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

Changed 8 years ago by mparchet@…

comment:22 Changed 8 years ago by 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.

Changed 8 years ago by mparchet@…

Attachment: mysqlcheck5 output.txt added

comment:23 Changed 8 years ago by 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

comment:24 Changed 8 years ago by mkae (Marko Käning)

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

comment:25 in reply to:  23 ; Changed 8 years ago by 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.

comment:26 Changed 8 years ago by 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

comment:27 in reply to:  26 Changed 8 years ago by ryandesign (Ryan 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.

comment:28 Changed 8 years ago by mkae (Marko Käning)

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

comment:29 in reply to:  25 Changed 8 years ago by 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

Last edited 8 years ago by ryandesign (Ryan Schmidt) (previous) (diff)

comment:30 in reply to:  22 Changed 8 years ago by 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?

comment:31 Changed 8 years ago by michaelld (Michael Dickens)

Cc: michaelld@… removed

Cc Me!

comment:32 Changed 7 years ago by sharky@…

Cc: sharky@… removed

comment:33 Changed 6 years ago by mkae (Marko Käning)

Can we close this one here, mparchet?

comment:34 Changed 6 years ago by mkae (Marko Käning)

Cc: pasnox@… added

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.

comment:35 Changed 6 years ago by 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.

comment:36 Changed 10 months ago by jmroot (Joshua Root)

Owner: changed from macports-tickets@… to NicosPavlov
Status: newassigned

comment:37 Changed 10 months ago by mf2k (Frank Schima)

Keywords: kde4 removed
Note: See TracTickets for help on using tickets.