Author Topic: globaladdressbook and Roundcube 1.2.0 (synology NAS)  (Read 3800 times)

Offline gleon

  • Newbie
  • *
  • Posts: 1
globaladdressbook and Roundcube 1.2.0 (synology NAS)
« on: November 08, 2016, 06:06:53 PM »
Hello

When i am trying to install globaladdressbook 1.10-git on Roundcube 1.2.0

in globaladdressbook.php

if (!($user = rcube_user::query($this->user_name, $this->host))) {
allways return null $user

DB Error: [7] ERROR:  duplicate key value violates unique constraint "users_username_key"
DETAIL:  Key (username, mail_host)=(liste_globale, localhost) already exists. (SQL Query: INSERT INTO "users" ("created", "last_login", "username", "mail_host", "language") VALUES (now(), now(), 'liste_globale', 'localhost', 'fr_FR')) in /volume1/@appstore/MailStation/mail/program/lib/Roundcube/rcube_db.php on line 539 (GET /mail/?_task=settings&_action=plugin.syno_admin)
[08-Nov-2016 22:15:12 +0100]: <m03ipoci> DB Error: [7] ERROR:  insert or update on table "identities" violates foreign key constraint "identities_user_id_fkey"
DETAIL:  Key (user_id)=(61) is not present in table "users". (SQL Query: INSERT INTO "identities" ("changed", "email", "name", "standard", "user_id") VALUES (now(), 'liste_globale@du-man.net', 'liste_globale', '1', '61')) in /volume1/@appstore/MailStation/mail/program/lib/Roundcube/rcube_db.php on line 539 (GET /mail/?_task=settings&_action=plugin.syno_admin)
[08-Nov-2016 22:15:12 +0100]: <m03ipoci> DB Error: [7] ERROR:  insert or update on table "identities" violates foreign key constraint "identities_user_id_fkey"
DETAIL:  Key (user_id)=(61) is not present in table "users". (GET /mail/?_task=settings&_action=plugin.syno_admin)

i am looking for the records in pgsql (tables users and identities) and the records was well created.

Is there a solution to that? What am I doing wrong?
Thanks

Offline rm13

  • Full Member
  • ***
  • Posts: 129
Re: globaladdressbook and Roundcube 1.2.0 (synology NAS)
« Reply #1 on: November 10, 2016, 04:58:49 PM »
You're getting a duplicate key error. Did you already create the global addressbook user in the database?

Does the Global Addressbook show up when you login to Roundcube?