To minimise difficulty n a two user system I archived $home from a system running 13.2 - installed a new disk - clean installed tumbleweed 20160525 - restored $home - everything is fine except kmail.
Opened kmail in the hope that it would “just work” but akonadi isn’t running and I’m not sure how to restore the existing kmail database
kmail does not appear to be functional, yet, until I’ve solved the import/restore I don’t want to use it in case I create version incompatibility problems
The akonadi problem appears to have been discussed at length in relation to incompatibilities between versions but it’s a clean install so I’m not mixing stacks
Grateful for advice, never found kmail migration easy:
trying manual start gets this:
~> akonadictl start
Starting Akonadi Server...
done.
Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
c...a@linux-6dbk:~> QCommandLineParser: option not defined: "start-without-control"
search paths: ("/home/c...a/bin", "/usr/local/bin", "/usr/bin", "/bin", "/usr/bin/X11", "/usr/games", "/usr/sbin", "/usr/local/sbin", "/usr/local/libexec", "/usr/libexec", "/opt/mysql/libexec", "/opt/local/lib/mysql5/bin", "/opt/mysql/sbin")
Found mysql_install_db: "/usr/bin/mysql_install_db"
Found mysqlcheck: "/usr/bin/mysqlcheck"
akonadi.collectionattributetable OK
akonadi.collectionmimetyperelation OK
akonadi.collectionpimitemrelation OK
akonadi.collectiontable OK
akonadi.flagtable OK
akonadi.mimetypetable OK
akonadi.parttable OK
akonadi.parttypetable OK
akonadi.pimitemflagrelation OK
akonadi.pimitemtable OK
akonadi.pimitemtagrelation OK
akonadi.relationtable
Error : Table 'akonadi.relationtable' doesn't exist in engine
status : Operation failed
akonadi.relationtypetable
Error : Table 'akonadi.relationtypetable' doesn't exist in engine
status : Operation failed
akonadi.resourcetable OK
akonadi.schemaversiontable OK
akonadi.tagattributetable OK
akonadi.tagremoteidresourcerelationtable OK
akonadi.tagtable OK
akonadi.tagtypetable OK
mysql.column_stats OK
mysql.columns_priv OK
mysql.db OK
mysql.event OK
mysql.func OK
mysql.gtid_slave_pos
Error : Table 'mysql.gtid_slave_pos' doesn't exist in engine
status : Operation failed
mysql.help_category OK
mysql.help_keyword OK
mysql.help_relation OK
mysql.help_topic OK
mysql.host OK
mysql.index_stats OK
mysql.innodb_index_stats
Error : Table 'mysql.innodb_index_stats' doesn't exist in engine
status : Operation failed
mysql.innodb_table_stats
Error : Table 'mysql.innodb_table_stats' doesn't exist in engine
status : Operation failed
mysql.ndb_binlog_index OK
mysql.plugin OK
mysql.proc OK
mysql.procs_priv OK
mysql.proxies_priv OK
mysql.roles_mapping OK
mysql.servers OK
mysql.table_stats OK
mysql.tables_priv OK
mysql.time_zone OK
mysql.time_zone_leap_second OK
mysql.time_zone_name OK
mysql.time_zone_transition OK
mysql.time_zone_transition_type OK
mysql.user OK
Repairing tables
test.relationtable
Error : Table 'test.relationtable' doesn't exist
status : Operation failed
test.relationtypetable
Error : Table 'test.relationtypetable' doesn't exist
status : Operation failed
test.gtid_slave_pos
Error : Table 'test.gtid_slave_pos' doesn't exist
status : Operation failed
test.innodb_index_stats
Error : Table 'test.innodb_index_stats' doesn't exist
status : Operation failed
test.innodb_table_stats
Error : Table 'test.innodb_table_stats' doesn't exist
status : Operation failed
MySQL version OK (required "5.1" , available "10.0" )
Database "akonadi" opened using driver "QMYSQL"
DbInitializer::run()
checking table "SchemaVersionTable"
checking table "ResourceTable"
checking table "CollectionTable"
checking table "MimeTypeTable"
checking table "PimItemTable"
checking table "FlagTable"
checking table "PartTypeTable"
checking table "PartTable"
checking table "CollectionAttributeTable"
checking table "TagTypeTable"
checking table "TagTable"
checking table "TagAttributeTable"
checking table "TagRemoteIdResourceRelationTable"
checking table "RelationTypeTable"
"ALTER TABLE RelationTypeTable ADD COLUMN id BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY"
"
Sql error: Table 'akonadi.relationtypetable' doesn't exist in engine QMYSQL: Unable to execute query
Query: ALTER TABLE RelationTypeTable ADD COLUMN id BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY"
Unable to initialize database.
terminating service threads
terminating connection threads
stopping db process
Application 'akonadiserver' exited normally...