Bonjour Didier3L,
Je suis totalement novice et j’ai suivi le super tuto, mais je suis vraiment débutant et suis bloqué sur :
" rajouter ces lignes :
deb-src http://deb.debian.org/debian stretch main non-free
deb-src http://deb.debian.org/debian stretch-updates main non-free
deb-src http://security.debian.org stretch/updates main non-free
Lancer ces 3 commandes: (durée de la compilation 15 minutes !) : apt-get update && apt-get upgrade -y && apt-get -y build-dep pam
(durée 5 minutes !)"
Je n’ai vu nulpart dans la doc https://doc.jeedom.com/fr_FR/installation/synology qu’il fallait aussi installer le container MySQL et faire la création de la Database…
Où as-tu trouvé cette information?
Edit 1 : je viens de me rendre compte que la documentation vient de changer entre le moment où je l’avait ouverte et maintenant…
Un nouveau volume est à créer pour la DB dans le container Jeedom…
Effectivement je coince maintenant sur cette page :
A la création du container MySQL (ou MariaDB) avez-vous créé les variables d’environnement suivantes: MYSQL_ROOT_PASSWORD, MYSQL_ALLOW_EMPTY_PASSWORD and MYSQL_RANDOM_ROOT_PASSWORD? pour setter le mot de passe root de la base par exemple?
Merci!
Edit 2 : J’ai l’impression que la mise à jour du container Docker il y a 16 jours integre maintenant la base MySQL dans le container…?
Edit 3 : a priori non, il me demande encore les paramètres de connexion à la base MySQL:
Merci @Loic !
Tu me confirmes qu’il faut quand même installer en plus du container Jeedom, un container MySQL (ou MariaDB) et procéder manuellement à la création de la base Jeedom?
Merci d’avance, cette partie n’est pas encore très claire pour moi…
Et que l’installation du container Jeedom a tiré celle de MySQL?
Donc je ne comprend pas:
Soit la base est packagée avec le Jeedom dans le container et tout est pré-paramétré, soit ce n’est pas le cas…???
Merci de ton aide, je suis perdu!!
Edit 1 : question subsidiaire:
n’est-il pas possible de packager Jeedom jusqu’au bout pour que nous n’ayons pas à faire les manipulations suivantes:
sudo su -
echo « * * * * * www-data /usr/bin/php /var/www/html/core/php/jeeCron.php >> /dev/null » > /etc/cron.d/jeedom
max_execution_time must be >= 600, edit /etc/php/7.3/apache2/php.ini and change this value (current 30)
upload_max_filesize must be = 1G, edit /etc/php/7.3/apache2/php.ini and change this value (current 2M)
post_max_size must be = 1G, edit /etc/php/7.3/apache2/php.ini and change this value (current 8M)
Supprime tout et repars de 0 la tu es sur une ancienne version ou n’a pas fait la doc correctement, je l’ai fait la semaine dernière et j’ai rien eu de tout ce que tu montres.
@Loic ok je vais le refaire une nième fois.
J’ai pris soin hier en voyant que la documentation avait évolué de recharger la dernière image Docker Jeedom… (latest modifiée il y a 16 jours)
Mais peut-être l’ancienne était toujours en cache sur mon Synology.
Mais tu confirmes donc bien que maintenant la base est intégrée au container (juste pour être sûr de bien comprendre)?
Merci
Regarde la doc tout est dedans j’ai passé des heures dessus faut la lire si dans la doc ya pas marqué installer un docker mysql alors c’est qu’il ne faut pas en mettre tout simplement
Merci
Ce n’est pas pour t’embêter, mais j’ai passé au moins 2 à 3h hier à essayer d’installer Jeedom sous forme de container sur mon NAS car j’ai des plantages avec mon actuelle version sur VM Freebo Delta (voir un autre thead de message: SQLSTATE[HY000] [2002] Connection refused plantage régulier Jeedom)
et je me suis assuré d’avoir justement bien lu la documentation plusieurs fois (j’étais au départ sur l’ancienne version avant de me rendre compte qu’elle avait évoluée, je peux même te dire où exactement tellement je l’ai lue! ;-))
donc je retente aujourd’hui et te tiens au courant (je vais prendre de copies d’écran pour partager les étapes ce sera pus simple)
Merci encore de ta patience!
Je crois que je viens de comprendre!
J’avais encore les 2 images dans mon registre d’image Docker sur le Syno:
Et je n’ai pas du repartir de la bonne versio quand j’ai retenté (je pensais qu’il me remplacerai l’ancienne image latest de 1Go par la nouvelle image latest (2Go) , mais en fait non!
Donc attention si vous êtes dans mon cas à bien supprimer l’ancienne pour être s^pur de redémarrer sur la nouvelle!
Quelques petites suggestions pour améliorer encore la documentation sur ce sujet:
Préciser qu’il faut créer les répertoires sur le Synology
/docker/jeedom/db
/docker/jeedom/html
Et les réinitialiser probablement si on refait une installation.
Et remettre textuellement dans la doc les paramètres (pour faciliter le copier-coller et éviter les erreurs de resaisie par exemple)
/docker/jeedom/db /var/lib/mysql
/docker/jeedom/html /var/www/html
Merci
Sinon @Loic je confirme que la procédure fonctionne dans ces conditions, j’arrive bien à ma mire de login:
Je vais voir pour les remarque mais pas oublier qu’il n’y a pas de support officiel docker c’est juste la en best effort pour vous aider. On a pas vraiment de temps a consacrer la dessus malheureusement
Cette image ne s’installera pas correctement si vous choisissez le mode Host
Start init
Start jeedom installation
--2020-06-12 16:12:17-- https://raw.githubusercontent.com/jeedom/core/alpha/install/install.sh
Resolving raw.githubusercontent.com (raw.githubusercontent.com)... 151.101.120.133
Connecting to raw.githubusercontent.com (raw.githubusercontent.com)|151.101.120.133|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 15297 (15K) [text/plain]
Saving to: '/root/install.sh'
/root/install.sh 0%[ ] 0 --.-KB/s
/root/install.sh 100%[===================>] 14.94K --.-KB/s in 0.003s
2020-06-12 16:12:18 (5.73 MB/s) - '/root/install.sh' saved [15297/15297]
Welcome to Jeedom installer
Jeedom version : V4-stable
Web folder : /var/www/html
Installation type : standard
---------------------------------------------------------------------
Commence l'étape 6 téléchargement de jeedom
--2020-06-12 16:12:18-- https://github.com/jeedom/core/archive/V4-stable.zip
Resolving github.com (github.com)... 140.82.118.3
Connecting to github.com (github.com)|140.82.118.3|:443... connected.
HTTP request sent, awaiting response... 302 Found
Location: https://codeload.github.com/jeedom/core/zip/V4-stable [following]
--2020-06-12 16:12:18-- https://codeload.github.com/jeedom/core/zip/V4-stable
Resolving codeload.github.com (codeload.github.com)... 140.82.112.10
Connecting to codeload.github.com (codeload.github.com)|140.82.112.10|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 44873438 (43M) [application/zip]
368 éléments.
Start init
Start jeedom installation
--2020-06-12 16:12:17-- https://raw.githubusercontent.com/jeedom/core/alpha/install/install.sh
Resolving raw.githubusercontent.com (raw.githubusercontent.com)... 151.101.120.133
Connecting to raw.githubusercontent.com (raw.githubusercontent.com)|151.101.120.133|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 15297 (15K) [text/plain]
Saving to: '/root/install.sh'
/root/install.sh 0%[ ] 0 --.-KB/s
/root/install.sh 100%[===================>] 14.94K --.-KB/s in 0.003s
2020-06-12 16:12:18 (5.73 MB/s) - '/root/install.sh' saved [15297/15297]
Welcome to Jeedom installer
Jeedom version : V4-stable
Web folder : /var/www/html
Installation type : standard
---------------------------------------------------------------------
Commence l'étape 6 téléchargement de jeedom
--2020-06-12 16:12:18-- https://github.com/jeedom/core/archive/V4-stable.zip
Resolving github.com (github.com)... 140.82.118.3
Connecting to github.com (github.com)|140.82.118.3|:443... connected.
HTTP request sent, awaiting response... 302 Found
Location: https://codeload.github.com/jeedom/core/zip/V4-stable [following]
--2020-06-12 16:12:18-- https://codeload.github.com/jeedom/core/zip/V4-stable
Resolving codeload.github.com (codeload.github.com)... 140.82.112.10
Connecting to codeload.github.com (codeload.github.com)|140.82.112.10|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 44873438 (43M) [application/zip]
Saving to: '/tmp/jeedom.zip'
/tmp/jeedom.zip 0%[ ] 0 --.-KB/s
/tmp/jeedom.zip 0%[ ] 64.16K 268KB/s
/tmp/jeedom.zip 0%[ ] 209.56K 435KB/s
/tmp/jeedom.zip 1%[ ] 480.27K 664KB/s
/tmp/jeedom.zip 2%[ ] 1.27M 1.31MB/s
/tmp/jeedom.zip 7%[> ] 3.24M 2.68MB/s
/tmp/jeedom.zip 19%[==> ] 8.25M 5.45MB/s
/tmp/jeedom.zip 36%[======> ] 15.74M 8.96MB/s
/tmp/jeedom.zip 55%[==========> ] 23.75M 11.9MB/s
/tmp/jeedom.zip 75%[==============> ] 32.11M 14.3MB/s
/tmp/jeedom.zip 94%[=================> ] 40.63M 16.7MB/s
/tmp/jeedom.zip 100%[===================>] 42.79M 17.0MB/s in 2.5s
2020-06-12 16:12:21 (17.0 MB/s) - '/tmp/jeedom.zip' saved [44873438/44873438]
étape 6 téléchargement de jeedom réussie
WARNING: The host 'jeedom' could not be looked up with /usr//bin/resolveip.
This probably means that your libc libraries are not 100 % compatible
with this binary MariaDB version. The MariaDB daemon, mysqld, should work
normally with the exception that host name resolving will not work.
This means that you should use IP addresses instead of hostnames
when specifying MariaDB privileges !
Installing MariaDB/MySQL system tables in '/var/lib/mysql/' ...
OK
To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system
PLEASE REMEMBER TO SET A PASSWORD FOR THE MariaDB root USER !
To do so, start the server, then issue the following commands:
'/usr//bin/mysqladmin' -u root password 'new-password'
'/usr//bin/mysqladmin' -u root -h 127.0.0.1
127.0.0.1 password 'new-password'
Alternatively you can run:
'/usr//bin/mysql_secure_installation'
368 éléments.
HTTP request sent, awaiting response... 200 OK
Length: 44873438 (43M) [application/zip]
Saving to: '/tmp/jeedom.zip'
/tmp/jeedom.zip 0%[ ] 0 --.-KB/s
/tmp/jeedom.zip 0%[ ] 64.16K 268KB/s
/tmp/jeedom.zip 0%[ ] 209.56K 435KB/s
/tmp/jeedom.zip 1%[ ] 480.27K 664KB/s
/tmp/jeedom.zip 2%[ ] 1.27M 1.31MB/s
/tmp/jeedom.zip 7%[> ] 3.24M 2.68MB/s
/tmp/jeedom.zip 19%[==> ] 8.25M 5.45MB/s
/tmp/jeedom.zip 36%[======> ] 15.74M 8.96MB/s
/tmp/jeedom.zip 55%[==========> ] 23.75M 11.9MB/s
/tmp/jeedom.zip 75%[==============> ] 32.11M 14.3MB/s
/tmp/jeedom.zip 94%[=================> ] 40.63M 16.7MB/s
/tmp/jeedom.zip 100%[===================>] 42.79M 17.0MB/s in 2.5s
2020-06-12 16:12:21 (17.0 MB/s) - '/tmp/jeedom.zip' saved [44873438/44873438]
étape 6 téléchargement de jeedom réussie
WARNING: The host 'jeedom' could not be looked up with /usr//bin/resolveip.
This probably means that your libc libraries are not 100 % compatible
with this binary MariaDB version. The MariaDB daemon, mysqld, should work
normally with the exception that host name resolving will not work.
This means that you should use IP addresses instead of hostnames
when specifying MariaDB privileges !
Installing MariaDB/MySQL system tables in '/var/lib/mysql/' ...
OK
To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system
PLEASE REMEMBER TO SET A PASSWORD FOR THE MariaDB root USER !
To do so, start the server, then issue the following commands:
'/usr//bin/mysqladmin' -u root password 'new-password'
'/usr//bin/mysqladmin' -u root -h 127.0.0.1
127.0.0.1 password 'new-password'
Alternatively you can run:
'/usr//bin/mysql_secure_installation'
which will also give you the option of removing the test
databases and anonymous user created by default. This is
strongly recommended for production servers.
See the MariaDB Knowledgebase at http://mariadb.com/kb or the
MySQL manual for more instructions.
You can start the MariaDB daemon with:
cd '/usr/' ; /usr//bin/mysqld_safe --datadir='/var/lib/mysql/'
You can test the MariaDB daemon with mysql-test-run.pl
cd '/usr//mysql-test' ; perl mysql-test-run.pl
Please report any problems at http://mariadb.org/jira
The latest information about MariaDB is available at http://mariadb.org/.
You can find additional information about the MySQL part at:
http://dev.mysql.com
Consider joining MariaDB's strong and vibrant community:
https://mariadb.org/get-involved/
[....] Stopping MariaDB database server: mysqld[ ok .
[....] Starting MariaDB database server: mysqld . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .[FAIL failed!
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Welcome to Jeedom installer
Jeedom version : V4-stable
368 éléments.
'/usr//bin/mysql_secure_installation'
which will also give you the option of removing the test
databases and anonymous user created by default. This is
strongly recommended for production servers.
See the MariaDB Knowledgebase at http://mariadb.com/kb or the
MySQL manual for more instructions.
You can start the MariaDB daemon with:
cd '/usr/' ; /usr//bin/mysqld_safe --datadir='/var/lib/mysql/'
You can test the MariaDB daemon with mysql-test-run.pl
cd '/usr//mysql-test' ; perl mysql-test-run.pl
Please report any problems at http://mariadb.org/jira
The latest information about MariaDB is available at http://mariadb.org/.
You can find additional information about the MySQL part at:
http://dev.mysql.com
Consider joining MariaDB's strong and vibrant community:
https://mariadb.org/get-involved/
[....] Stopping MariaDB database server: mysqld[ ok .
[....] Starting MariaDB database server: mysqld . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .[FAIL failed!
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Welcome to Jeedom installer
Jeedom version : V4-stable
Web folder : /var/www/html
Installation type : standard
---------------------------------------------------------------------
Commence l'étape 10 installation de jeedom
[START INSTALL]
****Install jeedom at (2020-06-12 18:13:05)****
Installation de Jeedom
Installation de la base de données...***ERREUR*** SQLSTATE[HY000] [2002] No such file or directory
SQLSTATE[HY000] [2002] No such file or directory
SQLSTATE[HY000] [2002] No such file or directory
SQLSTATE[HY000] [2002] No such file or directory
SQLSTATE[HY000] [2002] No such file or directory
SQLSTATE[HY000] [2002] No such file or directory
SQLSTATE[HY000] [2002] No such file or directory
SQLSTATE[HY000] [2002] No such file or directory
SQLSTATE[HY000] [2002] No such file or directory
SQLSTATE[HY000] [2002] No such file or directory
SQLSTATE[HY000] [2002] No such file or directory
SQLSTATE[HY000] [2002] No such file or directory
SQLSTATE[HY000] [2002] No such file or directory
SQLSTATE[HY000] [2002] No such file or directory
SQLSTATE[HY000] [2002] No such file or directory
SQLSTATE[HY000] [2002] No such file or directory
SQLSTATE[HY000] [2002] No such file or directory
SQLSTATE[HY000] [2002] No such file or directory
SQLSTATE[HY000] [2002] No such file or directory
SQLSTATE[HY000] [2002] No such file or directory
SQLSTATE[HY000] [2002] No such file or directory
368 éléments.
Welcome to Jeedom installer
Jeedom version : V4-stable
Web folder : /var/www/html
Installation type : standard
---------------------------------------------------------------------
Commence l'étape 10 installation de jeedom
[START INSTALL]
****Install jeedom at (2020-06-12 18:13:05)****
Installation de Jeedom
Installation de la base de données...***ERREUR*** SQLSTATE[HY000] [2002] No such file or directory
SQLSTATE[HY000] [2002] No such file or directory
SQLSTATE[HY000] [2002] No such file or directory
SQLSTATE[HY000] [2002] No such file or directory
SQLSTATE[HY000] [2002] No such file or directory
SQLSTATE[HY000] [2002] No such file or directory
SQLSTATE[HY000] [2002] No such file or directory
SQLSTATE[HY000] [2002] No such file or directory
SQLSTATE[HY000] [2002] No such file or directory
SQLSTATE[HY000] [2002] No such file or directory
SQLSTATE[HY000] [2002] No such file or directory
SQLSTATE[HY000] [2002] No such file or directory
SQLSTATE[HY000] [2002] No such file or directory
SQLSTATE[HY000] [2002] No such file or directory
SQLSTATE[HY000] [2002] No such file or directory
SQLSTATE[HY000] [2002] No such file or directory
SQLSTATE[HY000] [2002] No such file or directory
SQLSTATE[HY000] [2002] No such file or directory
SQLSTATE[HY000] [2002] No such file or directory
SQLSTATE[HY000] [2002] No such file or directory
SQLSTATE[HY000] [2002] No such file or directory
SQLSTATE[HY000] [2002] No such file or directory
SQLSTATE[HY000] [2002] No such file or directory
SQLSTATE[HY000] [2002] No such file or directory
SQLSTATE[HY000] [2002] No such file or directory
SQLSTATE[HY000] [2002] No such file or directory
SQLSTATE[HY000] [2002] No such file or directory
SQLSTATE[HY000] [2002] No such file or directory
OK
PHP Fatal error: Uncaught PDOException: SQLSTATE[HY000] [2002] No such file or directory in /var/www/html/core/class/DB.class.php:40
Stack trace:
#0 /var/www/html/core/class/DB.class.php(40): PDO->__construct('mysql:host=loca...', 'jeedom', 'cb462b52d013b5b', Array)
#1 /var/www/html/core/class/DB.class.php(50): DB::initConnection()
#2 /var/www/html/core/class/DB.class.php(82): DB::getConnection()
#3 /var/www/html/core/class/config.class.php(173): DB::Prepare('SELECT `key`,`v...', Array, 1)
#4 /var/www/html/core/class/translate.class.php(34): config::byKeys(Array)
#5 /var/www/html/core/class/translate.class.php(151): translate::getConfig('language', 'fr_FR')
#6 /var/www/html/core/class/translate.class.php(75): translate::getLanguage()
#7 /var/www/html/core/class/translate.class.php(54): translate::exec('{{Chauffage}}', '/var/www/html/c...', false)
#8 /var/www/html/core/class/translate.class.php(165): translate::sentence('Chauffage', '/var/www/html/c...', false)
#9 /var/www/html/core/config/jeedom.config.php(23): __('Chauffage' in /var/www/html/core/class/DB.class.php on line 40
Erreur durant l'installation : SQLSTATE[HY000] [2002] No such file or directoryDétails : Array
(
[0] => Array
(
[file] => /var/www/html/core/class/DB.class.php
[line] => 40
[function] => __construct
[class] => PDO
368 éléments.
SQLSTATE[HY000] [2002] No such file or directory
SQLSTATE[HY000] [2002] No such file or directory
SQLSTATE[HY000] [2002] No such file or directory
SQLSTATE[HY000] [2002] No such file or directory
SQLSTATE[HY000] [2002] No such file or directory
SQLSTATE[HY000] [2002] No such file or directory
SQLSTATE[HY000] [2002] No such file or directory
SQLSTATE[HY000] [2002] No such file or directory
SQLSTATE[HY000] [2002] No such file or directory
OK
PHP Fatal error: Uncaught PDOException: SQLSTATE[HY000] [2002] No such file or directory in /var/www/html/core/class/DB.class.php:40
Stack trace:
#0 /var/www/html/core/class/DB.class.php(40): PDO->__construct('mysql:host=loca...', 'jeedom', 'cb462b52d013b5b', Array)
#1 /var/www/html/core/class/DB.class.php(50): DB::initConnection()
#2 /var/www/html/core/class/DB.class.php(82): DB::getConnection()
#3 /var/www/html/core/class/config.class.php(173): DB::Prepare('SELECT `key`,`v...', Array, 1)
#4 /var/www/html/core/class/translate.class.php(34): config::byKeys(Array)
#5 /var/www/html/core/class/translate.class.php(151): translate::getConfig('language', 'fr_FR')
#6 /var/www/html/core/class/translate.class.php(75): translate::getLanguage()
#7 /var/www/html/core/class/translate.class.php(54): translate::exec('{{Chauffage}}', '/var/www/html/c...', false)
#8 /var/www/html/core/class/translate.class.php(165): translate::sentence('Chauffage', '/var/www/html/c...', false)
#9 /var/www/html/core/config/jeedom.config.php(23): __('Chauffage' in /var/www/html/core/class/DB.class.php on line 40
Erreur durant l'installation : SQLSTATE[HY000] [2002] No such file or directoryDétails : Array
(
[0] => Array
(
[file] => /var/www/html/core/class/DB.class.php
[line] => 40
[function] => __construct
[class] => PDO
[type] => ->
[args] => Array
(
[0] => mysql:host=localhost;port=3306;dbname=jeedom
[1] => jeedom
[2] => cb462b52d013b5b
[3] => Array
(
[1002] => SET NAMES utf8
[12] => 1
)
)
)
[1] => Array
(
[file] => /var/www/html/core/class/DB.class.php
[line] => 50
[function] => initConnection
[class] => DB
[type] => ::
[args] => Array
(
)
)
[2] => Array
368 éléments.
)
[12] => Array
(
[file] => /var/www/html/install/install.php
[line] => 53
[args] => Array
(
[0] => /var/www/html/core/php/core.inc.php
)
[function] => require_once
)
)
[END INSTALL ERROR]
Ne peut installer jeedom - Annulation
Welcome to Jeedom installer
Jeedom version : V4-stable
Web folder : /var/www/html
Installation type : standard
---------------------------------------------------------------------
Commence l'étape 11 post jeedom
no crontab for root
étape 11 post jeedom réussie
Start atd
[....] Stopping deferred execution scheduler: atd[ ok .
[....] Starting deferred execution scheduler: atd[ ok .
Starting mysql
[....] Stopping MariaDB database server: mysqld[ ok .
[....] Starting MariaDB database server: mysqld . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .[FAIL failed!
All init complete
Start apache2
[....] Starting Apache httpd web server: apache2AH00557: apache2: apr_sockaddr_info_get() failed for jeedom
AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 127.0.0.1. Set the 'ServerName' directive globally to suppress this message
(98)Address already in use: AH00072: make_sock: could not bind to address [::]:80
(98)Address already in use: AH00072: make_sock: could not bind to address 0.0.0.0:80
no listening sockets available, shutting down
AH00015: Unable to open logs
Action 'start' failed.
The Apache error log may have more information.
[ ok .
