Roundcube planté

Salut à tous,

J’ai tenté de suivre le tutoriel suivant : https://yunohost.org/#/app_roundcube_fr
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 ?

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

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

[07-Nov-2015 23:06:54 Europe/Berlin] (TRYLATER) “Internal error occured. Refer t o server log for more information. [2015-11-07 23:06:54]” (3):
[07-Nov-2015 23:06:54 Europe/Berlin] (NONEXISTENT) “Script does not exist.” (3):
[08-Nov-2015 23:13:03 Europe/Berlin] PHP Warning: fopen(/5533a6f128749550b3af00 595e2468fa.orig.jpeg): failed to open stream: Permission non accordée in /var/ww w/roundcube/program/steps/mail/get.inc on line 87
[08-Nov-2015 23:13:03 Europe/Berlin] PHP Warning: fopen(/3cda326cec4da83f534aba 01b393ce68.orig.jpeg): failed to open stream: Permission non accordée in /var/ww w/roundcube/program/steps/mail/get.inc on line 87
[08-Nov-2015 23:13:03 Europe/Berlin] PHP Warning: fopen(/137adac64897f3ba869159 d276f1b78a.orig.jpeg): failed to open stream: Permission non accordée in /var/ww w/roundcube/program/steps/mail/get.inc on line 87
[08-Nov-2015 23:13:03 Europe/Berlin] PHP Warning: fopen(/f463f2ad36388bd2d7acd7 6359d2f5e0.orig.jpeg): failed to open stream: Permission non accordée in /var/ww w/roundcube/program/steps/mail/get.inc on line 87
[08-Nov-2015 23:13:03 Europe/Berlin] PHP Warning: fopen(/e7ef16588b4f415f6fd9f4 431a32a681.orig.jpeg): failed to open stream: Permission non accordée in /var/ww w/roundcube/program/steps/mail/get.inc on line 87
[08-Nov-2015 23:13:03 Europe/Berlin] PHP Warning: fopen(/0c975d62b7a42b27d1f610 b649e2d374.orig.jpeg): failed to open stream: Permission non accordée in /var/ww w/roundcube/program/steps/mail/get.inc on line 87
[08-Nov-2015 23:13:03 Europe/Berlin] PHP Warning: fopen(/5533a6f128749550b3af00 595e2468fa.orig.jpeg): failed to open stream: Permission non accordée in /var/ww w/roundcube/program/steps/mail/get.inc on line 87
[09-Nov-2015 12:28:36 Europe/Berlin] PHP Warning: fopen(/f1cfa63500f8732703135a bd58456b20.orig.jpeg): failed to open stream: Permission non accordée in /var/ww w/roundcube/program/steps/mail/get.inc on line 87
[09-Nov-2015 12:28:36 Europe/Berlin] PHP Warning: fopen(/1a15059605a9e041086995 0119ae1b86.orig.jpeg): failed to open stream: Permission non accordée in /var/ww w/roundcube/program/steps/mail/get.inc on line 87
[09-Nov-2015 12:28:36 Europe/Berlin] PHP Warning: fopen(/2de7d7fff03f4dbee3da50 d5a2562edc.orig.jpeg): failed to open stream: Permission non accordée in /var/ww w/roundcube/program/steps/mail/get.inc on line 87
[09-Nov-2015 12:28:36 Europe/Berlin] PHP Warning: fopen(/fc84bf4de1cdeaa43a54b1 c6d01c9509.orig.jpeg): failed to open stream: Permission non accordée in /var/ww w/roundcube/program/steps/mail/get.inc on line 87
[09-Nov-2015 12:28:36 Europe/Berlin] PHP Warning: fopen(/3a678d857dbcb8d579e287 7612fec20b.orig.jpeg): failed to open stream: Permission non accordée in /var/ww w/roundcube/program/steps/mail/get.inc on line 87
[09-Nov-2015 23:17:37 Europe/Berlin] PHP Warning: fopen(/739c584e59d193e05f99ca 1f233eb456.orig.jpeg): failed to open stream: Permission non accordée in /var/ww w/roundcube/program/steps/mail/get.inc on line 87
[09-Nov-2015 23:17:37 Europe/Berlin] PHP Warning: fopen(/6b6985e40194d76ce1e551 7ac8d6acd6.orig.jpeg): failed to open stream: Permission non accordée in /var/ww w/roundcube/program/steps/mail/get.inc on line 87
[09-Nov-2015 23:17:37 Europe/Berlin] PHP Warning: fopen(/148ff896c01553c52a2208 8f73ed8106.orig.jpeg): failed to open stream: Permission non accordée in /var/ww w/roundcube/program/steps/mail/get.inc on line 87
[09-Nov-2015 23:17:37 Europe/Berlin] PHP Warning: fopen(/f7a6af407ed2787cbd24ce be723e77cc.orig.jpeg): failed to open stream: Permission non accordée in /var/ww w/roundcube/program/steps/mail/get.inc on line 87
[09-Nov-2015 23:17:37 Europe/Berlin] PHP Warning: fopen(/c4f945cd9188f13fa129e5 79e8a86df9.orig.jpeg): failed to open stream: Permission non accordée in /var/ww w/roundcube/program/steps/mail/get.inc on line 87
[09-Nov-2015 23:17:37 Europe/Berlin] PHP Warning: fopen(/a325c3d751642be6d10131 3fce0365f1.orig.jpeg): failed to open stream: Permission non accordée in /var/ww w/roundcube/program/steps/mail/get.inc on line 87
[09-Nov-2015 23:17:38 Europe/Berlin] PHP Warning: fopen(/148ff896c01553c52a2208 8f73ed8106.orig.jpeg): failed to open stream: Permission non accordée in /var/ww w/roundcube/program/steps/mail/get.inc on line 87
[09-Nov-2015 23:17:38 Europe/Berlin] PHP Warning: fopen(/f7a6af407ed2787cbd24ce be723e77cc.orig.jpeg): failed to open stream: Permission non accordée in /var/ww w/roundcube/program/steps/mail/get.inc on line 87
[09-Nov-2015 23:17:38 Europe/Berlin] PHP Warning: fopen(/739c584e59d193e05f99ca 1f233eb456.orig.jpeg): failed to open stream: Permission non accordée in /var/ww w/roundcube/program/steps/mail/get.inc on line 87
[09-Nov-2015 23:17:38 Europe/Berlin] PHP Warning: fopen(/c4f945cd9188f13fa129e5 79e8a86df9.orig.jpeg): failed to open stream: Permission non accordée in /var/ww w/roundcube/program/steps/mail/get.inc on line 87
[09-Nov-2015 23:17:38 Europe/Berlin] PHP Warning: fopen(/6b6985e40194d76ce1e551 7ac8d6acd6.orig.jpeg): failed to open stream: Permission non accordée in /var/ww w/roundcube/program/steps/mail/get.inc on line 87
[09-Nov-2015 23:17:38 Europe/Berlin] PHP Warning: fopen(/a325c3d751642be6d10131 3fce0365f1.orig.jpeg): failed to open stream: Permission non accordée in /var/ww w/roundcube/program/steps/mail/get.inc on line 87
[10-Nov-2015 00:14:01 +0100]: IMAP Error: Login failed for jeremy from 192.168.0 .254. Empty startup greeting (localhost:143) in /var/www/roundcube/program/lib/R oundcube/rcube_imap.php on line 184 (GET /webmail/)
[10-Nov-2015 00:14:05 +0100]: IMAP Error: Login failed for jeremy from 192.168.0 .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)
[10-Nov-2015 00:14:05 +0100]: IMAP Error: Login failed for jeremy from 192.168.0 .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)
[10-Nov-2015 00:14:13 +0100]: IMAP Error: Login failed for jeremy from 192.168.0 .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)
[10-Nov-2015 01:31:17 +0100]: IMAP Error: Login failed for jeremy from 192.168.0 .254. Empty startup greeting (localhost:143) in /var/www/roundcube/program/lib/R oundcube/rcube_imap.php on line 184 (GET /webmail/)
[10-Nov-2015 01:32:18 +0100]: IMAP Error: Login failed for jeremy from 192.168.0 .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)
[10-Nov-2015 07:23:02 +0100]: IMAP Error: Login failed for jeremy from 193.50.17 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)
[10-Nov-2015 13:15:54 +0100]: IMAP Error: Login failed for jeremy from 193.50.17 5.34. Empty startup greeting (localhost:143) in /var/www/roundcube/program/lib/R oundcube/rcube_imap.php on line 184 (GET /webmail/)
[10-Nov-2015 13:23:41 +0100]: IMAP Error: Login failed for jeremy from 193.50.17 5.34. Empty startup greeting (localhost:143) in /var/www/roundcube/program/lib/R oundcube/rcube_imap.php on line 184 (GET /webmail/)
[10-Nov-2015 13:25:42 +0100]: IMAP Error: Login failed for jeremy from 193.50.17 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)
[11-Nov-2015 01:10:45 +0100]: DB Error: [1146] Table ‘roundcube.carddav_addressb 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/)
[11-Nov-2015 01:10:45 +0100]: DB Error: [1146] Table ‘roundcube.carddav_addressb ooks’ doesn’t exist (GET /webmail/)
[11-Nov-2015 01:10:51 +0100]: DB Error: [1146] Table ‘roundcube.carddav_addressb 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/)
[11-Nov-2015 01:10:51 +0100]: DB Error: [1146] Table ‘roundcube.carddav_addressb ooks’ doesn’t exist (GET /webmail/)
[11-Nov-2015 01:10:59 +0100]: DB Error: [1146] Table ‘roundcube.carddav_addressb 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/)
[11-Nov-2015 01:10:59 +0100]: DB Error: [1146] Table ‘roundcube.carddav_addressb ooks’ doesn’t exist (GET /webmail/)
[11-Nov-2015 01:13:35 +0100]: DB Error: [1146] Table ‘roundcube.carddav_addressb 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/)
[11-Nov-2015 01:13:35 +0100]: DB Error: [1146] Table ‘roundcube.carddav_addressb ooks’ doesn’t exist (GET /webmail/)
[11-Nov-2015 01:16:32 +0100]: DB Error: [1146] Table ‘roundcube.carddav_addressb 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/)
[11-Nov-2015 01:16:32 +0100]: DB Error: [1146] Table ‘roundcube.carddav_addressb ooks’ doesn’t exist (GET /webmail/)
[11-Nov-2015 01:27:40 +0100]: DB Error: [1146] Table ‘roundcube.carddav_addressb 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/)
[11-Nov-2015 01:27:40 +0100]: DB Error: [1146] Table ‘roundcube.carddav_addressb ooks’ doesn’t exist (GET /webmail/)

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'

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.

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 ;).

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

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

le contexte serait pas du luxe…

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)

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

Si, roundcube marche :slight_smile:

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