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

[snc@…]

Has duplicate #33984.

[ryandesign@…]

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

[snc@…]

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

[mk@…]

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

[mk@…]

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?

[mk@…]

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

[mk@…]

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.

[mk@…]

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@…]

Cc Me!

[pixilla@…]

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

[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 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

[mk@…]

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

[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.

[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@…]

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.

[mk@…]

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

[mk@…]

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@…]

Cc Me!