Roundcube Community Forum

 

globaladdressbook and Roundcube 1.2.0 (synology NAS)

Started by gleon, November 08, 2016, 06:06:53 PM

Previous topic - Next topic

gleon

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(), '[email protected]', '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

rm13

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?