I recently updated from updates-testing to get:
akonadi-1.8.0-1.fc17.x86_64 kdepimlibs-4.9.1-3.fc17.x86_64 kdepimlibs-akonadi-4.9.1-3.fc17.x86_64 kdepim-libs-4.9.1-1.fc17.x86_64 kdepim-4.9.1-1.fc17.x86_64 kdepim-runtime-libs-4.9.1-1.fc17.x86_64 kdepim-runtime-4.9.1-1.fc17.x86_64
and others.
This didn't go as expected.
The first problem was that yum wanted to remove mysql for dependencies. I added --setopt=clean_requirements_on_remove=0 to fix that. This was the first hint that I did something wrong. :-(
Next, after restarting the desktop, I got this:
Test 6: ERROR --------
MySQL server default configuration not found. Details: The default configuration for the MySQL server was not found or was not readable. Check your Akonadi installation is complete and you have all required access rights.
Another hint.
I found a copy of the missing file in
/usr/share/kde4/apps/digikam/database/mysql-global.conf
and copied it to /etc/akonadi .
Now I'm stuck on this error:
"Unable to add column 'version' to table 'SchemaVersionTable'. Query error: 'Table 'akonadi.SchemaVersionTable' doesn't exist QMYSQL: Unable to execute query'" Unable to initialize database.
What am I doing wrong?
(Incidentally, sqlite is hopeless. I tried that after the first error and akonadi consumes all of the CPU resource without any hint that it will subside.)
-- Garry Williams
On Saturday 22 September 2012 10:20:52 Garry Williams wrote:
I recently updated from updates-testing to get:
akonadi-1.8.0-1.fc17.x86_64 kdepimlibs-4.9.1-3.fc17.x86_64 kdepimlibs-akonadi-4.9.1-3.fc17.x86_64 kdepim-libs-4.9.1-1.fc17.x86_64 kdepim-4.9.1-1.fc17.x86_64 kdepim-runtime-libs-4.9.1-1.fc17.x86_64 kdepim-runtime-4.9.1-1.fc17.x86_64and others.
This didn't go as expected.
The first problem was that yum wanted to remove mysql for dependencies. I added --setopt=clean_requirements_on_remove=0 to fix that. This was the first hint that I did something wrong. :-(
Next, after restarting the desktop, I got this:
Test 6: ERROR -------- MySQL server default configuration not found. Details: The default configuration for the MySQL server was notfound or was not readable. Check your Akonadi installation is complete and you have all required access rights.
Another hint.
I found a copy of the missing file in
/usr/share/kde4/apps/digikam/database/mysql-global.confand copied it to /etc/akonadi .
Now I'm stuck on this error:
"Unable to add column 'version' to table 'SchemaVersionTable'. Query error: 'Table 'akonadi.SchemaVersionTable' doesn't existQMYSQL: Unable to execute query'" Unable to initialize database.
What am I doing wrong?
Hi,
Have you akonadi-mysql installed?
Martin Kho
(Incidentally, sqlite is hopeless. I tried that after the first error and akonadi consumes all of the CPU resource without any hint that it will subside.)
-- Garry Williams _______________________________________________ kde mailing list kde@lists.fedoraproject.org https://admin.fedoraproject.org/mailman/listinfo/kde New to KDE4? - get help from http://userbase.kde.org
On Saturday, September 22, 2012 18:58:13 Martin Kho wrote:
On Saturday 22 September 2012 10:20:52 Garry Williams wrote:
What am I doing wrong?
Have you akonadi-mysql installed?
Yes, Rex Deiter replied the same off-list.
The real problem was that I updated "kde*" and that didn't include akonadi. Installing akonadi-mysql restored the missing configuration file. But the 'Unable to add column' problem was due to my local mysql.conf file. I uncommented this line to get past the error:
#lower_case_table_names=1
I don't know why this was commented or even why the file was there in the first place. I renamed the file and restarted akonadi and all is well.
Thanks for the suggestion.
Garry T. Williams wrote:
The real problem was that I updated "kde*" and that didn't include akonadi.
And for reference, as explained in Bugzilla, the best way to fetch a testing update is: yum install yum-security yum --enablerepo=updates-testing --advisory=FEDORA-2012-14137 update
Kevin Kofler
-
Garry Williams -
Kevin Kofler -
Martin Kho