This forum has been archived. All content is frozen. Please use KDE Discuss instead.

Akonadi and MySQL

Tags: None
(comma "," separated)
User avatar
Ignacio Serantes
Registered Member
Posts
453
Karma
1
OS

Akonadi and MySQL  Topic is solved

Sat Dec 12, 2009 8:26 pm
I read http://pim.kde.org/akonadi/ but information about using MySQL was:

Can Akonadi use a normal MySQL server running on my system?
Yes, it can. You find the corresponding settings in ~/.config/akonadi/akonadiserverrc.

I open this file and contents are the next:

-----------------------
[%General]
Driver=QMYSQL
SizeThreshold=4096
ExternalPayload=false

[QMYSQL]
Name=akonadi
User=
Password=
Options="UNIX_SOCKET=/home/ignacio/.local/share/akonadi/db_misc/mysql.socket"
ServerPath=/usr/sbin/mysqld
StartServer=true
Host=

[Debug]
Tracer=null
-----------------------

Does anyone can help me configuring Akonadi to use my running MySQL server?


Ignacio Serantes, proud to be a member of KDE forums since 2008-Nov.
User avatar
bcooksley
Administrator
Posts
19765
Karma
87
OS

Re: Akonadi and MySQL

Sat Dec 12, 2009 10:47 pm
Assuming you are using a localhost MySQL server, create the database "akonadi" and a user for it, assigning that user a password, then alter the file as follows:

Code: Select all
[QMYSQL]
Name=akonadi
User=<put your akonadi database username here>
Password=<put you akonadi database user password here>
Options=""
ServerPath=/usr/sbin/mysqld
StartServer=false
Host=localhost


KDE Sysadmin
[img]content/bcooksley_sig.png[/img]
User avatar
Ignacio Serantes
Registered Member
Posts
453
Karma
1
OS

Re: Akonadi and MySQL

Sat Dec 12, 2009 11:19 pm
Thank you so much, it works fine and I spend less system resources :D.


Ignacio Serantes, proud to be a member of KDE forums since 2008-Nov.
User avatar
vbatts
Registered Member
Posts
102
Karma
0
OS

Re: Akonadi and MySQL

Sat Dec 19, 2009 6:20 am
additionally, on the Akonadi Configuration of the Advanced tab in the `systemsettings` panel, you can configure the akondai server properties to use a mysql installation through a GUI rather than hacking on the *rc files.


vbatts, proud to be a member of KDE forums since 2008-Sep.

http://hashbangbash.com/
User avatar
Ignacio Serantes
Registered Member
Posts
453
Karma
1
OS

Re: Akonadi and MySQL

Sat Dec 19, 2009 9:07 am
vbatts wrote:additionally, on the Akonadi Configuration of the Advanced tab in the `systemsettings` panel, you can configure the akondai server properties to use a mysql installation through a GUI rather than hacking on the *rc files.
This option is not available in openSUSE 11.1 KDE 4.4 Beta 1 packages.


Ignacio Serantes, proud to be a member of KDE forums since 2008-Nov.
User avatar
dpalacio
Registered Member
Posts
240
Karma
2
OS

Re: Akonadi and MySQL

Sat Dec 19, 2009 1:09 pm
It disappeared from Systemsettings but it is still accesible from krunner typing «akonadi».


connect(post, SIGNAL(readSignature()), qapp, SLOT(quit()));
User avatar
Ignacio Serantes
Registered Member
Posts
453
Karma
1
OS

Re: Akonadi and MySQL

Sat Dec 19, 2009 3:02 pm
dpalacio wrote:It disappeared from Systemsettings but it is still accesible from krunner typing «akonadi».
Very user friendly :D.


Ignacio Serantes, proud to be a member of KDE forums since 2008-Nov.
User avatar
vbatts
Registered Member
Posts
102
Karma
0
OS

Re: Akonadi and MySQL

Sat Dec 19, 2009 3:06 pm
now that is curious. i see that as well.
while the kdepim-runtime package owns the kcm_akonadi*so's, there doesn't appear to be a way to access them.
/var/log/packages/kdepim-runtime-4.3.80-x86_64-1_vb:usr/lib64/kde4/kcm_akonadi_resources.so
/var/log/packages/kdepim-runtime-4.3.80-x86_64-1_vb:usr/lib64/kde4/kcm_akonadi_server.so
/var/log/packages/kdepim-runtime-4.3.80-x86_64-1_vb:usr/lib64/kde4/kcm_akonadi.so


even running
kcmshell4 --list | grep -i akon

does not return anything. i will have to continue looking around for this.


vbatts, proud to be a member of KDE forums since 2008-Sep.

http://hashbangbash.com/
User avatar
vbatts
Registered Member
Posts
102
Karma
0
OS

Re: Akonadi and MySQL

Sat Dec 19, 2009 3:10 pm
meh, even though it is not listed, if you execute
Code: Select all
kcmshell4 kcm_akonadi

then you will get the akonadi configuration window. mind you i had to go to the server settings, uncheck "use internal MYSQL server" -> apply -> re-check the box -> apply -> then click "start" to get it to start. and at that, it complains that the nepomuk server is not able to start, so i have something else to investigate.


vbatts, proud to be a member of KDE forums since 2008-Sep.

http://hashbangbash.com/
User avatar
bcooksley
Administrator
Posts
19765
Karma
87
OS

Re: Akonadi and MySQL

Sat Dec 19, 2009 11:02 pm
This is because the KDE PIM team views the Akonadi configuration as an "advanced" setting, so the graphical configuration was moved from System Settings to AkonadiConsole.


KDE Sysadmin
[img]content/bcooksley_sig.png[/img]
User avatar
anda_skoa
KDE Developer
Posts
783
Karma
4
OS

Re: Akonadi and MySQL

Mon Dec 21, 2009 7:03 pm
bcooksley wrote:This is because the KDE PIM team views the Akonadi configuration as an "advanced" setting, so the graphical configuration was moved from System Settings to AkonadiConsole.


As far as I understand it, the removal from system settings is twofold:
- the server tab contains things that should not be easy to change since especially external server setup requires quite some knowledge (there have been reports on this forum and on other channels where users had changed to an external database setup without having a clue what that actually implied, making it really hard to do decent user support)

- the agent setup tab is available from each application but with pre-filtering for the respective data type(s), address book resources in KAddressBook

I will discuss the re-introduction of the agent tab at the KDE PIM meeting in January, because I think it is still useful additionally to having it in applications (just like we have now with "KDE Resources")

Cheers,
_


anda_skoa, proud to be a member of KDE forums since 2008-Oct.
User avatar
vbatts
Registered Member
Posts
102
Karma
0
OS

Re: Akonadi and MySQL

Mon Dec 21, 2009 8:28 pm
thanks anda_skoa. i for one would prefer to have it in the System Settings panel, on the advanced tab. one more step towards a unified places for configuring the desktop environment experience.

Take care,


vbatts, proud to be a member of KDE forums since 2008-Sep.

http://hashbangbash.com/
User avatar
anda_skoa
KDE Developer
Posts
783
Karma
4
OS

Re: Akonadi and MySQL

Mon Dec 21, 2009 8:39 pm
Right.

I think it should return to where it was, just removing the server tab or showing the server tab only when a certain commandline parameter has been specified or a configuration setting which can only be set through a text editor is present.

Cheers,
_


anda_skoa, proud to be a member of KDE forums since 2008-Oct.
User avatar
vbatts
Registered Member
Posts
102
Karma
0
OS

Re: Akonadi and MySQL

Mon Dec 21, 2009 9:42 pm
Personally i don't think its out of place. a server configuration on an item from the advanced menu. maybe a warning or disclaimer that tampering with settings in the server tab can and void their [free] warranty ;)


vbatts, proud to be a member of KDE forums since 2008-Sep.

http://hashbangbash.com/
User avatar
anda_skoa
KDE Developer
Posts
783
Karma
4
OS

Re: Akonadi and MySQL

Mon Dec 21, 2009 10:00 pm
We didn't see any problem with this either but reality proved us wrong :)

My take is that we better provide this in a different way, e.g. a separate tool. This would also have advantages for adding support for more database backends, e.g. a tab for internal MySQL, a tab for external, one for Postgres, etc. or an assistant/wizard setup.

Systemsettings should really just contain things one is likely to interact with. The Akonadi server setup is either something one should not bother about at all or just do it once.

Cheers,
_


anda_skoa, proud to be a member of KDE forums since 2008-Oct.


Bookmarks



Who is online

Registered users: abc72656, Bing [Bot], Google [Bot], lockheed, Yahoo [Bot]