I’ve been trying to use libre writer to print out information from contacts from kaddressbook. AFAIK, you must create a database in libre base to do this.My contacts are stored in a DAV groupware resource using owncloud. Because of this, I believe creating a database from an existing database: Kde Addressbook, will not work, and it hasn’t but I don’t remember the actual error. The actual vcf files are stored in /srv/www/owncloud/etc… So I thought maybe I could connect to an existing MySql database and use akonadi’s socket. So I go to libre office and create a database from existing MySql database. I then say connect directly then hit next.
I then type in
Database: akonadi
I deselect server/port and go to socket. I then type in
I hit next
Then type in root for username
check password required
click test connection
put in password for root
comes back successful
click next
yes register
open database for editing
finish
name odb file
I then receive an error “unkown database akonadi”
Now if I do the following, it has no problem connecting to the akonadi database
mysql -u root --socket=/home/<user>/.local/share/akonadi/socket-<host-name>/mysql.socket
then type in
show databases
it shows akonadi, and if I type in
use akonadi
then there is no problem.
I DO have a problem with phpMyAdmin getting akonadi to show.
I added this to my phpMyAdmin config file
/* Server: localhost [1] */
$i++;
$cfg'Servers']$i]'verbose'] = 'akonadi';
$cfg'Servers']$i]'socket'] = '/home/user/.local/share/akonadi/socke-falun/mysql.socket';
$cfg'Servers']$i]'connect_type'] = 'socket';
$cfg'Servers']$i]'extension'] = 'mysql';
$cfg'Servers']$i]'auth_type'] = 'config';
$cfg'Servers']$i]'user'] = 'root';
$cfg'Servers']$i]'password'] = '<password>';
//$cfg'Servers']$i]'nopassword'] = true; //don't need this line since I put in password
$cfg'Servers']$i]'AllowNoPassword'] = true;
and also did the chmod o+x to /tmp/akonadi-<user>.TfmGRa
cw9000 wrote:
>
> I’ve been trying to use libre writer to print out information from
> contacts from kaddressbook. AFAIK, you must create a database in libre
> base to do this.My contacts are stored in a DAV groupware resource
> using owncloud. Because of this, I believe creating a database from an
> existing database: Kde Addressbook, will not work, and it hasn’t but I
> don’t remember the actual error. The actual vcf files are stored in
> /srv/www/owncloud/etc… So I thought maybe I could connect to an
> existing MySql database and use akonadi’s socket. So I go to libre
> office and create a database from existing MySql database. I then say
> connect directly then hit next.
> I then type in
> Code:
> --------------------
> Database: akonadi
> --------------------
>
> I deselect server/port and go to socket. I then type in
>
> Code:
> --------------------
> socket: /home/<user>/.local/share/akonadi/socket-<host name>/mysql.socket
> --------------------
>
> I hit next
> Then type in root for username
> check password required
> click test connection
> put in password for root
> comes back successful
> click next
> yes register
> open database for editing
> finish
> name odb file
> I then receive an error “unkown database akonadi”
>
> Now if I do the following, it has no problem connecting to the akonadi
> database
>
> Code:
> --------------------
> mysql -u root --socket=/home/<user>/.local/share/akonadi/socket-<host-name>/mysql.socket
> --------------------
>
> then type in
>
> Code:
> --------------------
> show databases
> --------------------
>
> it shows akonadi, and if I type in
>
> Code:
> --------------------
> use akonadi
> --------------------
>
> then there is no problem.
>
> I DO have a problem with phpMyAdmin getting akonadi to show.
> I added this to my phpMyAdmin config file
>
>
> Code:
> --------------------
>
> /* Server: localhost [1] */
> $i++;
> $cfg’Servers’]$i]‘verbose’] = ‘akonadi’;
> $cfg’Servers’]$i]‘socket’] = ‘/home/user/.local/share/akonadi/socke-falun/mysql.socket’;
> $cfg’Servers’]$i]‘connect_type’] = ‘socket’;
> $cfg’Servers’]$i]‘extension’] = ‘mysql’;
> $cfg’Servers’]$i]‘auth_type’] = ‘config’;
> $cfg’Servers’]$i]‘user’] = ‘root’;
> $cfg’Servers’]$i]‘password’] = ‘<password>’;
> //$cfg’Servers’]$i]‘nopassword’] = true; //don’t need this line since I put in password
> $cfg’Servers’]$i]‘AllowNoPassword’] = true;
> --------------------
>
> and also did the chmod o+x to /tmp/akonadi-<user>.TfmGRa
>
> both of which was outlined on this site:
> ‘Projects/PIM/Akonadi/Development Tools - KDE TechBase’
> (http://tinyurl.com/6thwyfq)
> but I get a 2002 permission denied error
>
>
> So what am I doing wrong with libre base that it can’t pull in the
> akonadi database?
> Thanks for any and all help
>
>
Akonadi database is NOT your MAIN data storage.
Calendars and contact information: they can be either on a server
(Kolab server, LDAP server) and only cached in Akonadi as explained, or
they can be in local vcard or .ics file. The actual location of these
files again depends on your setup. The new standard place for them is
$HOME/.local/share/contacts.
Thanks for replying. I understand that the main location is somewhere else. I had read that $HOME/.local/share/contacts was the new standard place, however, I’m using a DAV resource and in akonadiconsole it tells me that the vcard files are located at a server address, part of owncloud.
The remote id is: http://<myserver>:<port>/owncloud/remote.php/carddav/addressbooks/<user name>/contacts/<some random letters>.vcf
I don’t have anything except a readme in $HOME/.local/share/contacts. But if I go searching for these .vcf files, nothing comes up in my owncloud folder.
Not only that, but there seems to be a separate vcard for each contact. How do I pull this into a database, or how do I get my contacts into libre writer?
What I CAN do is use kaddressbook and export to csv file with header and put in its own folder. Then make a database out of it by selecting the Text option. Then use that database in libre writer. Of course this is not as efficient as setting up a database that will always be up-to-date. I thought maybe I could get that using akonadi. It seems not the way to go.
Any thoughts?
Thanks for any and all help
so far I’ve gotten to the point where I can point my database to the carddav folder where all the .vcf files are. I went to Tools->Options->LibreOffice->general and select use libre office dialogs.
Then I go to File->New->database and select open existing. Then I am able to connect to a server and use WebDav. After putting in all necessary info I can connect to the folder where the .vcf files are. Of course this isn’t a database, so its useless. But at least I’m able to see the .vcf files. If only there were a dialog when connecting to an existing database and choosing KDE addressbook.