The akonadi-initalisync tool can be used to setup a users account initally and synchronize it in a scripted fashion. This is useful for preparing workstations so they are ready once the user logs in.

The script takes some parameters to adjust the per user settings, and reads the rest of the configuration from configuration-file templates.

After preparing the necessary configuration files, the script automatically starts dbus and akonadi, executes the sync, and then shuts akonadi and dbus down again. The script is fully blocking during this time, so it can easly be included in other scripts.

Please note that the script accesses the users home directory (where the configuration files reside), and thus needs to be run as the respective user.

The script needs to be running as the target user, and all necessary packages need to be installed. The script allso needs to be executed using ipython at requires access to an X11 session.

Required packages:

• ipython
• acl
• dbus-x11
• kontact
• kwalletcli
• libicu48
• python-gobject
• python-dbus

The script is used as follows:

ipython initalsync.py "$NAME" "$MAIL" "$UID" "$PASSWORD" "akonadi_kolab_resource_0"

• NAME: The name of the user. Used for identity configuration.
• MAIL: The email-address of the user. Used for identity configuration and as login for the kolab server.
• UID: The uid of the user. Used for access to the kolab user and as database- and user-name in the MYSQL database (by default). Used as the "{uid}" template parameter.
• PASSWORD: Used as password to access the MYSQL database as well as access to the kolab server. Used as the "{password}" template parameter.

An example use could look like this:

ipython initalsync.py "John Doe" "doe@example.com" "doe" "MyPass1234" "akonadi_kolab_resource_0"

The test.sh script demonstrates usage using a local MYSQL server.

Most configuration options can be adjusted by adjusting the templates in "sync/templates/".

The akonadi MYSQL settings are located in:

sync/templates/.config/akonadi/akonadiserverrc

The kolab server settings are located in:

sync/templates/.kde/share/config/akonadi_kolab_resource_0rc

The ldap server settings are located in:

sync/templates/.kde/share/config/akonadi_ldap_resource_0rc
sync/templates/.kde/share/config/kabldaprc

The database needs to contain a table for every user named by the UID parameter above, so for a user with the UID "doe", a table "doe" has to exist. The script does not setup this table and expects it to having been created alrady, i.e. like so:

USER=doe
PASSWORD=Welcome2KolabSystems

sudo /usr/sbin/mysqld& >/tmp/mysql.log 2>/tmp/mysql.err
sleep 2

sudo mysql --defaults-extra-file=/etc/mysql/debian.cnf <<EOF
CREATE DATABASE $USER;
GRANT ALL  ON $USER.* TO '$USER'@localhost IDENTIFIED BY '$PASSWORD';
FLUSH PRIVILEGES;
EOF

These are the files/directories that need to be removed before retrying a synchronization. Note that this will remove all configuraton & data in akonadi.

rm -R ~/.kde/share/apps/akonadi_migration_agent
rm -R ~/.kde/share/config/akonadi*
rm -R ~/.local/share/akonadi
rm -R ~/.config/akonadi

Additionally the users database table has to be removed.