Results 1 to 3 of 3

Thread: kmail/akonadi problem, new disk, clean install of tumbleweed 20160525

  1. #1
    Join Date
    Jun 2008
    Location
    London
    Posts
    172

    Default kmail/akonadi problem, new disk, clean install of tumbleweed 20160525

    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:

    Code:
    ~> 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"
    "\nSql error: Table 'akonadi.relationtypetable' doesn't exist in engine QMYSQL: Unable to execute query\nQuery: 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...
    Last edited by gerrygavigan; 28-May-2016 at 10:33. Reason: user's nmae anonymised

  2. #2
    Join Date
    Jun 2008
    Location
    London
    Posts
    172

    Default Re: kmail/akonadi problem, new disk, clean install of tumbleweed 20160525 - SOLVED

    Quote Originally Posted by gerrygavigan View Post
    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

    [/code]
    I make no claims for elegance but it worked...

    created a third account on new install - no files - kmail seemed happy, no akonadi problems

    so it seems that while not mixing stacks on a clean install, restoring a complete user account mixes settings

    Went back to original files - used kmail export filter to create an email archive for both accounts.

    with new system - for each account I nuked all hidden files in local folder - there were probably many I didn't need to nuke but I definitely didn't want anything associated with the previous software versions being left behind

    restarted the account,

    opened kmail

    it was sweet

    imported the email archive

    re-established the mailer settings (a bit of a pain, but not as painful as a non-functional kmail...)

    now working and very nice the new kmail is too

    with one footnote

    for sending emails TLS seems to get set by default (i.e., both users on the new system) - modifying the sending account has two tabs - general/advanced - salvation lies in the advanced tab

    FWIW


    more elegant versions of the above gratefully received

  3. #3
    Join Date
    Mar 2008
    Location
    Bochum, Germany
    Posts
    3,587

    Default Re: kmail/akonadi problem, new disk, clean install of tumbleweed20160525

    gerrygavigan wrote on 02.06.2016 01:06:
    > more elegant versions of the above gratefully received


    Not more elegant, but I ran into the same issue after installing on a new disk.
    I copied the /home first, and after another install, everything was fine. My guess is, upon the first boot with a blank /home, Akonadi configures the database and once you copy over your old /home, it conflicts with the settings Akonadi made.

    Uwe

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •