Results 1 to 4 of 4

Thread: create database using libre base from akonadi socket

  1. #1

    Default create database using libre base from akonadi socket

    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
    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
    DESKTOP: Home built OS: opensuse 13.2 64 bit
    Asus p8h61-M LE/CSM | Intel i5-2500k 3.3Ghz Sandy Bridge | 4gb DDR3 | Intel integrated Video
    LAPTOP: Acer Aspire 4730z OS: opensuse 13.2 32 bit
    Intel Pentium dual-core 2.16Ghz T3400 | 3gb DDR2 | Intel Video

  2. #2
    Join Date
    May 2010
    Location
    Space Colony Lagrange Point 22° à, 77° Ƅ, 56° ɤ, 99° ɜ
    Posts
    3,166

    Default Re: create database using libre base from akonadi socket

    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.

    2) 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.
    source :- http://blogs.kde.org/node/4503

    --
    Version 3.10.2
    openSUSE 13.1 (Bottle) (x86_64) 64-bit
    Kernel Linux 3.11.6-4-desktop
    Where are my penguins :- https://features.opensuse.org/316767

  3. #3

    Default Re: create database using libre base from akonadi socket

    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
    DESKTOP: Home built OS: opensuse 13.2 64 bit
    Asus p8h61-M LE/CSM | Intel i5-2500k 3.3Ghz Sandy Bridge | 4gb DDR3 | Intel integrated Video
    LAPTOP: Acer Aspire 4730z OS: opensuse 13.2 32 bit
    Intel Pentium dual-core 2.16Ghz T3400 | 3gb DDR2 | Intel Video

  4. #4

    Default Re: create database using libre base from akonadi socket

    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.
    DESKTOP: Home built OS: opensuse 13.2 64 bit
    Asus p8h61-M LE/CSM | Intel i5-2500k 3.3Ghz Sandy Bridge | 4gb DDR3 | Intel integrated Video
    LAPTOP: Acer Aspire 4730z OS: opensuse 13.2 32 bit
    Intel Pentium dual-core 2.16Ghz T3400 | 3gb DDR2 | Intel Video

Posting Permissions

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