Roundcube planté

jeremy54 · November 11, 2015, 12:27am

Salut à tous,

J’ai tenté de suivre le tutoriel suivant : YunoHost • index
Cependant, j’ai oublié de faire sudo su, et du coup, j’ai planté la base de données en lien avec Roundcube…
Voici ce que j’ai lorsque je veux me connecté à Roundcube

DATABASE ERROR: CONNECTION FAILED!

Unable to connect to the database!
Please contact your server-administrator.

J’ai réessayé le tutoriel en incluant sudo su, mais lorsque j’entre la commande =

mysql -u root -p roundcube < carddav/Roundcube-CardDAV/SQL/mysql.sql

J’obtiens l’erreur suivante :

ERROR 1005 (HY000) at line 31: Can’t create table ‘roundcube.#sql-b16_4938’ (errno: 121)

Quelqu’un peut-il m’aider à rétablir l’accès à Roundcube ?

n00dl3 · November 11, 2015, 12:38pm

Décidément tu n’as pas de chance, entre ça et openvpn !
Quel est le contenu de /var/www/roundcube/logs/errors ?

jeremy54 · November 11, 2015, 1:49pm

Coucou, ben oui, je n’ai pas de chance Voilà le log :

[07-Nov-2015 23:06:54 Europe/Berlin] (TRYLATER) “Internal error occured. Refer t [07-Nov-2015 23:06:54 Europe/Berlin] (NONEXISTENT) “Script does not exist.” [08-Nov-2015 23:13:03 Europe/Berlin] PHP Warning: fopen(/5533a6f128749550b3af00 [08-Nov-2015 23:13:03 Europe/Berlin] PHP Warning: fopen(/3cda326cec4da83f534aba [08-Nov-2015 23:13:03 Europe/Berlin] PHP Warning: fopen(/137adac64897f3ba869159 [08-Nov-2015 23:13:03 Europe/Berlin] PHP Warning: fopen(/f463f2ad36388bd2d7acd7 [08-Nov-2015 23:13:03 Europe/Berlin] PHP Warning: fopen(/e7ef16588b4f415f6fd9f4 [08-Nov-2015 23:13:03 Europe/Berlin] PHP Warning: fopen(/0c975d62b7a42b27d1f610 [08-Nov-2015 23:13:03 Europe/Berlin] PHP Warning: fopen(/5533a6f128749550b3af00 [09-Nov-2015 12:28:36 Europe/Berlin] PHP Warning: fopen(/f1cfa63500f8732703135a [09-Nov-2015 12:28:36 Europe/Berlin] PHP Warning: fopen(/1a15059605a9e041086995 [09-Nov-2015 12:28:36 Europe/Berlin] PHP Warning: fopen(/2de7d7fff03f4dbee3da50 [09-Nov-2015 12:28:36 Europe/Berlin] PHP Warning: fopen(/fc84bf4de1cdeaa43a54b1 [09-Nov-2015 12:28:36 Europe/Berlin] PHP Warning: fopen(/3a678d857dbcb8d579e287 [09-Nov-2015 23:17:37 Europe/Berlin] PHP Warning: fopen(/739c584e59d193e05f99ca [09-Nov-2015 23:17:37 Europe/Berlin] PHP Warning: fopen(/6b6985e40194d76ce1e551 [09-Nov-2015 23:17:37 Europe/Berlin] PHP Warning: fopen(/148ff896c01553c52a2208 [09-Nov-2015 23:17:37 Europe/Berlin] PHP Warning: fopen(/f7a6af407ed2787cbd24ce [09-Nov-2015 23:17:37 Europe/Berlin] PHP Warning: fopen(/c4f945cd9188f13fa129e5 [09-Nov-2015 23:17:37 Europe/Berlin] PHP Warning: fopen(/a325c3d751642be6d10131 [09-Nov-2015 23:17:38 Europe/Berlin] PHP Warning: fopen(/148ff896c01553c52a2208 [09-Nov-2015 23:17:38 Europe/Berlin] PHP Warning: fopen(/f7a6af407ed2787cbd24ce [09-Nov-2015 23:17:38 Europe/Berlin] PHP Warning: fopen(/739c584e59d193e05f99ca [09-Nov-2015 23:17:38 Europe/Berlin] PHP Warning: fopen(/c4f945cd9188f13fa129e5 [09-Nov-2015 23:17:38 Europe/Berlin] PHP Warning: fopen(/6b6985e40194d76ce1e551 [09-Nov-2015 23:17:38 Europe/Berlin] PHP Warning: fopen(/a325c3d751642be6d10131 [10-Nov-2015 00:14:01 +0100]: IMAP Error: Login failed for jeremy from 192.168.0 [10-Nov-2015 00:14:05 +0100]: IMAP Error: Login failed for jeremy from 192.168.0 [10-Nov-2015 00:14:05 +0100]: IMAP Error: Login failed for jeremy from 192.168.0 [10-Nov-2015 00:14:13 +0100]: IMAP Error: Login failed for jeremy from 192.168.0 [10-Nov-2015 01:31:17 +0100]: IMAP Error: Login failed for jeremy from 192.168.0 [10-Nov-2015 01:32:18 +0100]: IMAP Error: Login failed for jeremy from 192.168.0 [10-Nov-2015 07:23:02 +0100]: IMAP Error: Login failed for jeremy from 193.50.17 [10-Nov-2015 13:15:54 +0100]: IMAP Error: Login failed for jeremy from 193.50.17 [10-Nov-2015 13:23:41 +0100]: IMAP Error: Login failed for jeremy from 193.50.17 [10-Nov-2015 13:25:42 +0100]: IMAP Error: Login failed for jeremy from 193.50.17 [11-Nov-2015 01:10:45 +0100]: DB Error: [1146] Table ‘roundcube.carddav_addressb [11-Nov-2015 01:10:45 +0100]: DB Error: [1146] Table ‘roundcube.carddav_addressb [11-Nov-2015 01:10:51 +0100]: DB Error: [1146] Table ‘roundcube.carddav_addressb [11-Nov-2015 01:10:51 +0100]: DB Error: [1146] Table ‘roundcube.carddav_addressb [11-Nov-2015 01:10:59 +0100]: DB Error: [1146] Table ‘roundcube.carddav_addressb [11-Nov-2015 01:10:59 +0100]: DB Error: [1146] Table ‘roundcube.carddav_addressb [11-Nov-2015 01:13:35 +0100]: DB Error: [1146] Table ‘roundcube.carddav_addressb [11-Nov-2015 01:13:35 +0100]: DB Error: [1146] Table ‘roundcube.carddav_addressb [11-Nov-2015 01:16:32 +0100]: DB Error: [1146] Table ‘roundcube.carddav_addressb [11-Nov-2015 01:16:32 +0100]: DB Error: [1146] Table ‘roundcube.carddav_addressb [11-Nov-2015 01:27:40 +0100]: DB Error: [1146] Table ‘roundcube.carddav_addressb [11-Nov-2015 01:27:40 +0100]: DB Error: [1146] Table ‘roundcube.carddav_addressb o server log for more information. [2015-11-07 23:06:54]” (3):
(3):
595e2468fa.orig.jpeg): failed to open stream: Permission non accordée in /var/ww w/roundcube/program/steps/mail/get.inc on line 87
01b393ce68.orig.jpeg): failed to open stream: Permission non accordée in /var/ww w/roundcube/program/steps/mail/get.inc on line 87
d276f1b78a.orig.jpeg): failed to open stream: Permission non accordée in /var/ww w/roundcube/program/steps/mail/get.inc on line 87
6359d2f5e0.orig.jpeg): failed to open stream: Permission non accordée in /var/ww w/roundcube/program/steps/mail/get.inc on line 87
431a32a681.orig.jpeg): failed to open stream: Permission non accordée in /var/ww w/roundcube/program/steps/mail/get.inc on line 87
b649e2d374.orig.jpeg): failed to open stream: Permission non accordée in /var/ww w/roundcube/program/steps/mail/get.inc on line 87
595e2468fa.orig.jpeg): failed to open stream: Permission non accordée in /var/ww w/roundcube/program/steps/mail/get.inc on line 87
bd58456b20.orig.jpeg): failed to open stream: Permission non accordée in /var/ww w/roundcube/program/steps/mail/get.inc on line 87
0119ae1b86.orig.jpeg): failed to open stream: Permission non accordée in /var/ww w/roundcube/program/steps/mail/get.inc on line 87
d5a2562edc.orig.jpeg): failed to open stream: Permission non accordée in /var/ww w/roundcube/program/steps/mail/get.inc on line 87
c6d01c9509.orig.jpeg): failed to open stream: Permission non accordée in /var/ww w/roundcube/program/steps/mail/get.inc on line 87
7612fec20b.orig.jpeg): failed to open stream: Permission non accordée in /var/ww w/roundcube/program/steps/mail/get.inc on line 87
1f233eb456.orig.jpeg): failed to open stream: Permission non accordée in /var/ww w/roundcube/program/steps/mail/get.inc on line 87
7ac8d6acd6.orig.jpeg): failed to open stream: Permission non accordée in /var/ww w/roundcube/program/steps/mail/get.inc on line 87
8f73ed8106.orig.jpeg): failed to open stream: Permission non accordée in /var/ww w/roundcube/program/steps/mail/get.inc on line 87
be723e77cc.orig.jpeg): failed to open stream: Permission non accordée in /var/ww w/roundcube/program/steps/mail/get.inc on line 87
79e8a86df9.orig.jpeg): failed to open stream: Permission non accordée in /var/ww w/roundcube/program/steps/mail/get.inc on line 87
3fce0365f1.orig.jpeg): failed to open stream: Permission non accordée in /var/ww w/roundcube/program/steps/mail/get.inc on line 87
8f73ed8106.orig.jpeg): failed to open stream: Permission non accordée in /var/ww w/roundcube/program/steps/mail/get.inc on line 87
be723e77cc.orig.jpeg): failed to open stream: Permission non accordée in /var/ww w/roundcube/program/steps/mail/get.inc on line 87
1f233eb456.orig.jpeg): failed to open stream: Permission non accordée in /var/ww w/roundcube/program/steps/mail/get.inc on line 87
79e8a86df9.orig.jpeg): failed to open stream: Permission non accordée in /var/ww w/roundcube/program/steps/mail/get.inc on line 87
7ac8d6acd6.orig.jpeg): failed to open stream: Permission non accordée in /var/ww w/roundcube/program/steps/mail/get.inc on line 87
3fce0365f1.orig.jpeg): failed to open stream: Permission non accordée in /var/ww w/roundcube/program/steps/mail/get.inc on line 87
.254. Empty startup greeting (localhost:143) in /var/www/roundcube/program/lib/R oundcube/rcube_imap.php on line 184 (GET /webmail/)
.254. Empty startup greeting (localhost:143) in /var/www/roundcube/program/lib/R oundcube/rcube_imap.php on line 184 (GET /webmail/?_task=mail&_refresh=1&_mbox=I NBOX&_action=list&_remote=1&unlock=loading1447110846597&=1447110846445)
.254. Empty startup greeting (localhost:143) in /var/www/roundcube/program/lib/R oundcube/rcube_imap.php on line 184 (GET /webmail/?_task=mail&_action=getunread& _remote=1&unlock=0&=1447110846446)
.254. Empty startup greeting (localhost:143) in /var/www/roundcube/program/lib/R oundcube/rcube_imap.php on line 184 (GET /webmail/?_task=mail&_mbox=INBOX&_folde rlist=1&_quota=1&_list=1&_uids=&_action=check-recent&_remote=1&unlock=loading14 47110853748&=1447110846447)
.254. Empty startup greeting (localhost:143) in /var/www/roundcube/program/lib/R oundcube/rcube_imap.php on line 184 (GET /webmail/)
.254. Empty startup greeting (localhost:143) in /var/www/roundcube/program/lib/R oundcube/rcube_imap.php on line 184 (POST /webmail/?_task=login?_task=login&_act ion=login)
5.34. Empty startup greeting (localhost:143) in /var/www/roundcube/program/lib/R oundcube/rcube_imap.php on line 184 (GET /webmail/?sso_login=22602173516202)
5.34. Empty startup greeting (localhost:143) in /var/www/roundcube/program/lib/R oundcube/rcube_imap.php on line 184 (GET /webmail/)
5.34. Empty startup greeting (localhost:143) in /var/www/roundcube/program/lib/R oundcube/rcube_imap.php on line 184 (GET /webmail/)
5.34. Empty startup greeting (localhost:143) in /var/www/roundcube/program/lib/R oundcube/rcube_imap.php on line 184 (POST /webmail/?_task=login?_task=login&_act ion=login)
ooks’ doesn’t exist (SQL Query: SELECT id FROM carddav_addressbooks WHERE user_i d=‘1’ AND active=1) in /var/www/roundcube/program/lib/Roundcube/rcube_db.php on line 467 (GET /webmail/)
ooks’ doesn’t exist (GET /webmail/)
ooks’ doesn’t exist (SQL Query: SELECT id FROM carddav_addressbooks WHERE user_i d=‘1’ AND active=1) in /var/www/roundcube/program/lib/Roundcube/rcube_db.php on line 467 (GET /webmail/)
ooks’ doesn’t exist (GET /webmail/)
ooks’ doesn’t exist (SQL Query: SELECT id FROM carddav_addressbooks WHERE user_i d=‘1’ AND active=1) in /var/www/roundcube/program/lib/Roundcube/rcube_db.php on line 467 (GET /webmail/)
ooks’ doesn’t exist (GET /webmail/)
ooks’ doesn’t exist (SQL Query: SELECT id FROM carddav_addressbooks WHERE user_i d=‘1’ AND active=1) in /var/www/roundcube/program/lib/Roundcube/rcube_db.php on line 467 (GET /webmail/)
ooks’ doesn’t exist (GET /webmail/)
ooks’ doesn’t exist (SQL Query: SELECT id FROM carddav_addressbooks WHERE user_i d=‘1’ AND active=1) in /var/www/roundcube/program/lib/Roundcube/rcube_db.php on line 467 (GET /webmail/)
ooks’ doesn’t exist (GET /webmail/)
ooks’ doesn’t exist (SQL Query: SELECT id FROM carddav_addressbooks WHERE user_i d=‘1’ AND active=1) in /var/www/roundcube/program/lib/Roundcube/rcube_db.php on line 467 (GET /webmail/)
ooks’ doesn’t exist (GET /webmail/)

n00dl3 · November 11, 2015, 2:20pm

ouais, en fait je pense qu’il y a une erreur dans le tuto, car il existe déjà un plugin cardav installé de base…
pour annuler ce que t’as fait, il suffit que tu supprime les tables carddav_server et carddav_contacts.

mysql -u root -p

puis

use roundcube

et

ALTER TABLE `carddav_contacts`    DROP FOREIGN KEY `carddav_contacts_ibfk_1`;
ALTER TABLE `carddav_server`   DROP FOREIGN KEY  `carddav_server_ibfk_1`;
DROP TABLE `carddav_server`;
DROP TABLE `carddav_contacts`;

Ensuite supprimer ‘carddav’ dans l’array, comme on t’as dit de le rajouter dans le tuto. (dans le fichier /var/www/roundcube/config/main.inc.php)

$rcmail_config['plugins'] = array('http_authentication', 'archive', 'new_user_identity'

jeremy54 · November 11, 2015, 3:05pm

Je te remercie ! Tout est rentré dans l’ordre !
Ce serait bien de remettre à jour les tutoriels pour l’utilisateur Yunohost car même le FirefoxSync n’est plus à jour.

n00dl3 · November 11, 2015, 3:25pm

Ouais il y a une chiée de truc qui ne correspondent plus à rien, ici a seule différence c’est qu’il n’y a plus besoin de cloner le dépot git, ni de copier le fichier de conf.
Du coup, si tu veux réinstaller le carddav de roundcube, tu n’as que peu de choses à faire.

mysql -u root -p$(cat /etc/yunohost/mysql) roundcube < /var/www/roundcube/plugins/carddav/dbinit/mysql.sql

et rajouter ‘carddav’ dans le fichier cité plus haut:

$rcmail_config['plugins'] = array('carddav','http_authentication', 'archive', 'new_user_identity'

et là je pense que ça devrait marcher. (en tout cas, j’ai vérifié, ça casse pas roundcube).

Avec ça, tu dois avoir assez d’éléments pour modifier l’article du wiki ;).

jeremy54 · November 11, 2015, 4:00pm

Je préfère que ce soit quelqu’un qui maitrise un minimum les choses sur Linux qui modifie le wiki
Par contre, j’aimerais utiliser CardDav pour faire un lien entre le calendrier de mon Windows Phone et Yunohost.

jeremy54 · November 11, 2015, 4:05pm

ERROR 1005 (HY000) at line 68: Can’t create table ‘roundcube.carddav_group_user’ (errno: 150)

n00dl3 · November 11, 2015, 4:32pm

le contexte serait pas du luxe…

jeremy54 · November 11, 2015, 4:34pm

Lorsque j’entre :

mysql -u root -p$(cat /etc/yunohost/mysql) roundcube < /var/www/roundcube/plugins/carddav/dbinit/mysql.sql

Voilà la réponse :

ERROR 1005 (HY000) at line 68: Can’t create table ‘roundcube.carddav_group_user’ (errno: 150)

n00dl3 · November 11, 2015, 4:59pm

si tu te connecte à roundcube, ça marche pas ?

jeremy54 · November 11, 2015, 6:24pm

Si, roundcube marche

n00dl3 · November 12, 2015, 1:47am

Il a du faire l’import sql comme un grand… Normalement tu dois avoir carddav dans les paramètres…