Problem z własną instancją Supli

jaku2k
Posts: 920
Joined: Sun May 24, 2020 8:40 pm
Has thanked: 1 time

Post

lesny8 wrote: Mon Feb 21, 2022 9:03 pm Zobacz jeszcze dlaczego robi te restarty

Code: Select all

docker logs --tail=50 supla-db

Code: Select all

error: database is uninitialized and password option is not specified
  You need to specify one of MYSQL_ROOT_PASSWORD, MYSQL_ALLOW_EMPTY_PASSWORD and MYSQL_RANDOM_ROOT_PASSWORD
Pozdrawiam
Jakub
User avatar
lesny8
Posts: 3132
Joined: Mon Dec 11, 2017 9:43 pm
Has thanked: 10 times
Been thanked: 9 times

Post

A w pliku .env masz hasło wygenerowane pod zmienną DB_PASSWORD ?

To hasło jest dodane do zmiennych kontenera podczas jego tworzenia. Poniżej wycinek z docker-compose.yml

Code: Select all

 supla-db:
    container_name: ${COMPOSE_PROJECT_NAME}-db
    restart: unless-stopped
    image: mysql:5.7.20
    env_file:
      - .env.default
      - .env
    environment:
      MYSQL_ROOT_PASSWORD: ${DB_PASSWORD}
      MYSQL_DATABASE: supla
      MYSQL_USER: supla
      MYSQL_PASSWORD: ${DB_PASSWORD}
    volumes:
      - ${VOLUME_DATA}/mysql:/var/lib/mysql:z


To by było dziwne, jeśli hasło masz ustawione i taki komunikat :roll:
SOP 2023 :heavy_check_mark:
SOP 2024 :heavy_check_mark:
Czekam na kolejne Supla Offline Party :upside_down_face:
🧩: 🔑cz->b ⛴️+ila
jaku2k
Posts: 920
Joined: Sun May 24, 2020 8:40 pm
Has thanked: 1 time

Post

lesny8 wrote: Mon Feb 21, 2022 9:24 pm A w pliku .env masz hasło wygenerowane pod zmienną DB_PASSWORD ?

To hasło jest dodane do zmiennych kontenera podczas jego tworzenia. Poniżej wycinek z docker-compose.yml

Code: Select all

 supla-db:
    container_name: ${COMPOSE_PROJECT_NAME}-db
    restart: unless-stopped
    image: mysql:5.7.20
    env_file:
      - .env.default
      - .env
    environment:
      MYSQL_ROOT_PASSWORD: ${DB_PASSWORD}
      MYSQL_DATABASE: supla
      MYSQL_USER: supla
      MYSQL_PASSWORD: ${DB_PASSWORD}
    volumes:
      - ${VOLUME_DATA}/mysql:/var/lib/mysql:z


To by było dziwne, jeśli hasło masz ustawione i taki komunikat :roll:
W pliku .env nie mam DB_PASSWORD :!:

Mogę je dopisać manualnie? Należy skorzystać z jakiegoś generatora czy może być tam wpisany dowolny ciąg znaków?
Pozdrawiam
Jakub
User avatar
pzygmunt
Posts: 20302
Joined: Tue Jan 19, 2016 9:26 am
Location: Paczków
Been thanked: 59 times

Post

Postaw od nowa serwer i przywróć tam katalog var ze starego
SUPLA.... Nareszcie w domu.
jaku2k
Posts: 920
Joined: Sun May 24, 2020 8:40 pm
Has thanked: 1 time

Post

pzygmunt wrote: Mon Feb 21, 2022 10:10 pm Postaw od nowa serwer i przywróć tam katalog var ze starego
Dziękuję za odpowiedź - tak zrobię.
Pozdrawiam
Jakub
jaku2k
Posts: 920
Joined: Sun May 24, 2020 8:40 pm
Has thanked: 1 time

Post

Tak zrobiłem i napotkałem jeszcze jeden błąd

Code: Select all

In ConnectionFactory.php line 79:

  An exception occured while establishing a connection to figure out your pla
  tform version.
  You can circumvent this by setting a 'server_version' configuration value

  For further information have a look at:
  https://github.com/doctrine/DoctrineBundle/issues/673


In AbstractMySQLDriver.php line 112:

  An exception occurred in driver: SQLSTATE[HY000] [2002] Connection refused


In Exception.php line 18:

  SQLSTATE[HY000] [2002] Connection refused


In PDOConnection.php line 40:

  SQLSTATE[HY000] [2002] Connection refused



In ConnectionFactory.php line 79:

  An exception occured while establishing a connection to figure out your pla
  tform version.
  You can circumvent this by setting a 'server_version' configuration value

  For further information have a look at:
  https://github.com/doctrine/DoctrineBundle/issues/673


In AbstractMySQLDriver.php line 112:

  An exception occurred in driver: SQLSTATE[HY000] [2002] Connection refused


In Exception.php line 18:

  SQLSTATE[HY000] [2002] Connection refused


In PDOConnection.php line 40:

  SQLSTATE[HY000] [2002] Connection refused



In ConnectionFactory.php line 79:

  An exception occured while establishing a connection to figure out your pla
  tform version.
  You can circumvent this by setting a 'server_version' configuration value

  For further information have a look at:
  https://github.com/doctrine/DoctrineBundle/issues/673


In AbstractMySQLDriver.php line 112:

  An exception occurred in driver: SQLSTATE[HY000] [2002] Connection refused


In Exception.php line 18:

  SQLSTATE[HY000] [2002] Connection refused


In PDOConnection.php line 40:

  SQLSTATE[HY000] [2002] Connection refused



In ConnectionFactory.php line 79:

  An exception occured while establishing a connection to figure out your pla
  tform version.
  You can circumvent this by setting a 'server_version' configuration value

  For further information have a look at:
  https://github.com/doctrine/DoctrineBundle/issues/673


In AbstractMySQLDriver.php line 128:

  An exception occurred in driver: SQLSTATE[HY000] [1130] Host '172.18.0.3' i
  s not allowed to connect to this MySQL server


In Exception.php line 18:

  SQLSTATE[HY000] [1130] Host '172.18.0.3' is not allowed to connect to this
  MySQL server


In PDOConnection.php line 40:

  SQLSTATE[HY000] [1130] Host '172.18.0.3' is not allowed to connect to this
  MySQL server



In ConnectionFactory.php line 79:

  An exception occured while establishing a connection to figure out your pla
  tform version.
  You can circumvent this by setting a 'server_version' configuration value

  For further information have a look at:
  https://github.com/doctrine/DoctrineBundle/issues/673


In AbstractMySQLDriver.php line 128:

  An exception occurred in driver: SQLSTATE[HY000] [1130] Host '172.18.0.3' i
  s not allowed to connect to this MySQL server


In Exception.php line 18:

  SQLSTATE[HY000] [1130] Host '172.18.0.3' is not allowed to connect to this
  MySQL server


In PDOConnection.php line 40:

  SQLSTATE[HY000] [1130] Host '172.18.0.3' is not allowed to connect to this
  MySQL server



In ConnectionFactory.php line 79:

  An exception occured while establishing a connection to figure out your pla
  tform version.
  You can circumvent this by setting a 'server_version' configuration value

  For further information have a look at:
  https://github.com/doctrine/DoctrineBundle/issues/673


In AbstractMySQLDriver.php line 128:

  An exception occurred in driver: SQLSTATE[HY000] [1130] Host '172.18.0.3' i
  s not allowed to connect to this MySQL server


In Exception.php line 18:

  SQLSTATE[HY000] [1130] Host '172.18.0.3' is not allowed to connect to this
  MySQL server


In PDOConnection.php line 40:

  SQLSTATE[HY000] [1130] Host '172.18.0.3' is not allowed to connect to this
  MySQL server



In ConnectionFactory.php line 79:

  An exception occured while establishing a connection to figure out your pla
  tform version.
  You can circumvent this by setting a 'server_version' configuration value

  For further information have a look at:
  https://github.com/doctrine/DoctrineBundle/issues/673


In AbstractMySQLDriver.php line 128:

  An exception occurred in driver: SQLSTATE[HY000] [1130] Host '172.18.0.3' i
  s not allowed to connect to this MySQL server


In Exception.php line 18:

  SQLSTATE[HY000] [1130] Host '172.18.0.3' is not allowed to connect to this
  MySQL server


In PDOConnection.php line 40:

  SQLSTATE[HY000] [1130] Host '172.18.0.3' is not allowed to connect to this
  MySQL server



In ConnectionFactory.php line 79:

  An exception occured while establishing a connection to figure out your pla
  tform version.
  You can circumvent this by setting a 'server_version' configuration value

  For further information have a look at:
  https://github.com/doctrine/DoctrineBundle/issues/673


In AbstractMySQLDriver.php line 128:

  An exception occurred in driver: SQLSTATE[HY000] [1130] Host '172.18.0.3' i
  s not allowed to connect to this MySQL server


In Exception.php line 18:

  SQLSTATE[HY000] [1130] Host '172.18.0.3' is not allowed to connect to this
  MySQL server


In PDOConnection.php line 40:

  SQLSTATE[HY000] [1130] Host '172.18.0.3' is not allowed to connect to this
  MySQL server



In ConnectionFactory.php line 79:

  An exception occured while establishing a connection to figure out your pla
  tform version.
  You can circumvent this by setting a 'server_version' configuration value

  For further information have a look at:
  https://github.com/doctrine/DoctrineBundle/issues/673


In AbstractMySQLDriver.php line 128:

  An exception occurred in driver: SQLSTATE[HY000] [1130] Host '172.18.0.3' i
  s not allowed to connect to this MySQL server


In Exception.php line 18:

  SQLSTATE[HY000] [1130] Host '172.18.0.3' is not allowed to connect to this
  MySQL server


In PDOConnection.php line 40:

  SQLSTATE[HY000] [1130] Host '172.18.0.3' is not allowed to connect to this
  MySQL server



In ConnectionFactory.php line 79:

  An exception occured while establishing a connection to figure out your pla
  tform version.
  You can circumvent this by setting a 'server_version' configuration value

  For further information have a look at:
  https://github.com/doctrine/DoctrineBundle/issues/673


In AbstractMySQLDriver.php line 128:

  An exception occurred in driver: SQLSTATE[HY000] [1130] Host '172.18.0.3' i
  s not allowed to connect to this MySQL server


In Exception.php line 18:

  SQLSTATE[HY000] [1130] Host '172.18.0.3' is not allowed to connect to this
  MySQL server


In PDOConnection.php line 40:

  SQLSTATE[HY000] [1130] Host '172.18.0.3' is not allowed to connect to this
  MySQL server



In ConnectionFactory.php line 79:

  An exception occured while establishing a connection to figure out your pla
  tform version.
  You can circumvent this by setting a 'server_version' configuration value

  For further information have a look at:
  https://github.com/doctrine/DoctrineBundle/issues/673


In AbstractMySQLDriver.php line 128:

  An exception occurred in driver: SQLSTATE[HY000] [1130] Host '172.18.0.3' i
  s not allowed to connect to this MySQL server


In Exception.php line 18:

  SQLSTATE[HY000] [1130] Host '172.18.0.3' is not allowed to connect to this
  MySQL server


In PDOConnection.php line 40:

  SQLSTATE[HY000] [1130] Host '172.18.0.3' is not allowed to connect to this
  MySQL server



In ConnectionFactory.php line 79:

  An exception occured while establishing a connection to figure out your pla
  tform version.
  You can circumvent this by setting a 'server_version' configuration value

  For further information have a look at:
  https://github.com/doctrine/DoctrineBundle/issues/673


In AbstractMySQLDriver.php line 128:

  An exception occurred in driver: SQLSTATE[HY000] [1130] Host '172.18.0.3' i
  s not allowed to connect to this MySQL server


In Exception.php line 18:

  SQLSTATE[HY000] [1130] Host '172.18.0.3' is not allowed to connect to this
  MySQL server


In PDOConnection.php line 40:

  SQLSTATE[HY000] [1130] Host '172.18.0.3' is not allowed to connect to this
  MySQL server



In ConnectionFactory.php line 79:

  An exception occured while establishing a connection to figure out your pla
  tform version.
  You can circumvent this by setting a 'server_version' configuration value

  For further information have a look at:
  https://github.com/doctrine/DoctrineBundle/issues/673


In AbstractMySQLDriver.php line 128:

  An exception occurred in driver: SQLSTATE[HY000] [1130] Host '172.18.0.3' i
  s not allowed to connect to this MySQL server


In Exception.php line 18:

  SQLSTATE[HY000] [1130] Host '172.18.0.3' is not allowed to connect to this
  MySQL server


In PDOConnection.php line 40:

  SQLSTATE[HY000] [1130] Host '172.18.0.3' is not allowed to connect to this
  MySQL server
Pozdrawiam
Jakub
User avatar
lesny8
Posts: 3132
Joined: Mon Dec 11, 2017 9:43 pm
Has thanked: 10 times
Been thanked: 9 times

Post

jaku2k wrote: Mon Feb 21, 2022 9:36 pm
W pliku .env nie mam DB_PASSWORD :!:

Mogę je dopisać manualnie? Należy skorzystać z jakiegoś generatora czy może być tam wpisany dowolny ciąg znaków?
:o :shock:

Powinno być https://github.com/SUPLA/supla-docker/b ... efault#L46
Czy ta baza to jest baza produkcyjna Twojej instancji? Musiałeś mieć w .env ustawione jakieś hasło, co się z nim stało?
Masz dwa wyjścia, albo stawiasz od nowa jak pisze @pzygmunt i przenosisz /var albo walcz ;)

Przepis na ustawienie nowego hasła dla użytkowników root i supla

Ustaw w pliku .env jakieś hasło dla zmiennej

Code: Select all

DB_PASSWORD=MOJEHASLO
Dodaj entrypoint (ostatnia linijka) do kontenera supla-db w pliku docker-compose.yml

Code: Select all

  supla-db:
    container_name: ${COMPOSE_PROJECT_NAME}-db
    restart: unless-stopped
    image: mysql:5.7.20
    env_file:
      - .env.default
      - .env
    environment:
      MYSQL_ROOT_PASSWORD: ${DB_PASSWORD}
      MYSQL_DATABASE: supla
      MYSQL_USER: supla
      MYSQL_PASSWORD: ${DB_PASSWORD}
    volumes:
      - ${VOLUME_DATA}/mysql:/var/lib/mysql:z
    entrypoint: mysqld_safe --skip-grant-tables --user=mysql 
Zrób restart kontenerom

Code: Select all

./supla.sh restart
Wejdź do środka kontenera supla-db

Code: Select all

docker exec -it supla-db bash
Wpisz i klepnij enter przy prośbie o hasło

Code: Select all

mysql -u root -p
Nadaj nowe hasło i wyjdź

Code: Select all

ALTER USER 'root'@'localhost' IDENTIFIED BY 'MOJEHASLO';
ALTER USER 'supla' IDENTIFIED BY 'MOJEHASLO';
FLUSH PRIVILEGES;
exit
Wyjdź z kontenera

Code: Select all

exit
Usuń wcześniej dodanego entrypointa z docker-compose.yml i zrób restart

Code: Select all

./supla.sh restart
SOP 2023 :heavy_check_mark:
SOP 2024 :heavy_check_mark:
Czekam na kolejne Supla Offline Party :upside_down_face:
🧩: 🔑cz->b ⛴️+ila
jaku2k
Posts: 920
Joined: Sun May 24, 2020 8:40 pm
Has thanked: 1 time

Post

lesny8 wrote: Mon Feb 21, 2022 11:14 pm
jaku2k wrote: Mon Feb 21, 2022 9:36 pm
W pliku .env nie mam DB_PASSWORD :!:

Mogę je dopisać manualnie? Należy skorzystać z jakiegoś generatora czy może być tam wpisany dowolny ciąg znaków?
:o :shock:

Powinno być https://github.com/SUPLA/supla-docker/b ... efault#L46
Czy ta baza to jest baza produkcyjna Twojej instancji? Musiałeś mieć w .env ustawione jakieś hasło, co się z nim stało?
Masz dwa wyjścia, albo stawiasz od nowa jak pisze @pzygmunt i przenosisz /var albo walcz ;)
Nie jestem pewien, czy dobrze rozumiem pojęcie baza produkcyjna. Używam jej (a bardziej jej używałem dotychczas) na co dzień razem z supla_cloud i supla_server jako Clouda dla modułów Supli (mam nadzieję, że jest to zrozumiałe).

Jak ostatnio zaglądałem do env-a, to hasło tam było. Być może wymazałem je przypadkowo (przed zaistnieniem problemu jak chciałem edytować plik .env, to dostawałem powiadomienie o utworzeniu pliku tymczasowego .env.swp, ale z tym problemem sobie poradziłem - chyba skutecznie).

Dziękuję bardzo za instrukcję (i oczywiście za odpowiedź). Pospiesznie podążyłem jednak za radą od @pzygmunt i obecnie borykam się z takim problemem:
jaku2k wrote: Mon Feb 21, 2022 11:10 pm Tak zrobiłem i napotkałem jeszcze jeden błąd

Code: Select all

In ConnectionFactory.php line 79:

  An exception occured while establishing a connection to figure out your pla
  tform version.
  You can circumvent this by setting a 'server_version' configuration value

  For further information have a look at:
  https://github.com/doctrine/DoctrineBundle/issues/673


In AbstractMySQLDriver.php line 112:

  An exception occurred in driver: SQLSTATE[HY000] [2002] Connection refused


In Exception.php line 18:

  SQLSTATE[HY000] [2002] Connection refused


In PDOConnection.php line 40:

  SQLSTATE[HY000] [2002] Connection refused



In ConnectionFactory.php line 79:

  An exception occured while establishing a connection to figure out your pla
  tform version.
  You can circumvent this by setting a 'server_version' configuration value

  For further information have a look at:
  https://github.com/doctrine/DoctrineBundle/issues/673


In AbstractMySQLDriver.php line 112:

  An exception occurred in driver: SQLSTATE[HY000] [2002] Connection refused


In Exception.php line 18:

  SQLSTATE[HY000] [2002] Connection refused


In PDOConnection.php line 40:

  SQLSTATE[HY000] [2002] Connection refused



In ConnectionFactory.php line 79:

  An exception occured while establishing a connection to figure out your pla
  tform version.
  You can circumvent this by setting a 'server_version' configuration value

  For further information have a look at:
  https://github.com/doctrine/DoctrineBundle/issues/673


In AbstractMySQLDriver.php line 112:

  An exception occurred in driver: SQLSTATE[HY000] [2002] Connection refused


In Exception.php line 18:

  SQLSTATE[HY000] [2002] Connection refused


In PDOConnection.php line 40:

  SQLSTATE[HY000] [2002] Connection refused



In ConnectionFactory.php line 79:

  An exception occured while establishing a connection to figure out your pla
  tform version.
  You can circumvent this by setting a 'server_version' configuration value

  For further information have a look at:
  https://github.com/doctrine/DoctrineBundle/issues/673


In AbstractMySQLDriver.php line 128:

  An exception occurred in driver: SQLSTATE[HY000] [1130] Host '172.18.0.3' i
  s not allowed to connect to this MySQL server


In Exception.php line 18:

  SQLSTATE[HY000] [1130] Host '172.18.0.3' is not allowed to connect to this
  MySQL server


In PDOConnection.php line 40:

  SQLSTATE[HY000] [1130] Host '172.18.0.3' is not allowed to connect to this
  MySQL server



In ConnectionFactory.php line 79:

  An exception occured while establishing a connection to figure out your pla
  tform version.
  You can circumvent this by setting a 'server_version' configuration value

  For further information have a look at:
  https://github.com/doctrine/DoctrineBundle/issues/673


In AbstractMySQLDriver.php line 128:

  An exception occurred in driver: SQLSTATE[HY000] [1130] Host '172.18.0.3' i
  s not allowed to connect to this MySQL server


In Exception.php line 18:

  SQLSTATE[HY000] [1130] Host '172.18.0.3' is not allowed to connect to this
  MySQL server


In PDOConnection.php line 40:

  SQLSTATE[HY000] [1130] Host '172.18.0.3' is not allowed to connect to this
  MySQL server



In ConnectionFactory.php line 79:

  An exception occured while establishing a connection to figure out your pla
  tform version.
  You can circumvent this by setting a 'server_version' configuration value

  For further information have a look at:
  https://github.com/doctrine/DoctrineBundle/issues/673


In AbstractMySQLDriver.php line 128:

  An exception occurred in driver: SQLSTATE[HY000] [1130] Host '172.18.0.3' i
  s not allowed to connect to this MySQL server


In Exception.php line 18:

  SQLSTATE[HY000] [1130] Host '172.18.0.3' is not allowed to connect to this
  MySQL server


In PDOConnection.php line 40:

  SQLSTATE[HY000] [1130] Host '172.18.0.3' is not allowed to connect to this
  MySQL server



In ConnectionFactory.php line 79:

  An exception occured while establishing a connection to figure out your pla
  tform version.
  You can circumvent this by setting a 'server_version' configuration value

  For further information have a look at:
  https://github.com/doctrine/DoctrineBundle/issues/673


In AbstractMySQLDriver.php line 128:

  An exception occurred in driver: SQLSTATE[HY000] [1130] Host '172.18.0.3' i
  s not allowed to connect to this MySQL server


In Exception.php line 18:

  SQLSTATE[HY000] [1130] Host '172.18.0.3' is not allowed to connect to this
  MySQL server


In PDOConnection.php line 40:

  SQLSTATE[HY000] [1130] Host '172.18.0.3' is not allowed to connect to this
  MySQL server



In ConnectionFactory.php line 79:

  An exception occured while establishing a connection to figure out your pla
  tform version.
  You can circumvent this by setting a 'server_version' configuration value

  For further information have a look at:
  https://github.com/doctrine/DoctrineBundle/issues/673


In AbstractMySQLDriver.php line 128:

  An exception occurred in driver: SQLSTATE[HY000] [1130] Host '172.18.0.3' i
  s not allowed to connect to this MySQL server


In Exception.php line 18:

  SQLSTATE[HY000] [1130] Host '172.18.0.3' is not allowed to connect to this
  MySQL server


In PDOConnection.php line 40:

  SQLSTATE[HY000] [1130] Host '172.18.0.3' is not allowed to connect to this
  MySQL server



In ConnectionFactory.php line 79:

  An exception occured while establishing a connection to figure out your pla
  tform version.
  You can circumvent this by setting a 'server_version' configuration value

  For further information have a look at:
  https://github.com/doctrine/DoctrineBundle/issues/673


In AbstractMySQLDriver.php line 128:

  An exception occurred in driver: SQLSTATE[HY000] [1130] Host '172.18.0.3' i
  s not allowed to connect to this MySQL server


In Exception.php line 18:

  SQLSTATE[HY000] [1130] Host '172.18.0.3' is not allowed to connect to this
  MySQL server


In PDOConnection.php line 40:

  SQLSTATE[HY000] [1130] Host '172.18.0.3' is not allowed to connect to this
  MySQL server



In ConnectionFactory.php line 79:

  An exception occured while establishing a connection to figure out your pla
  tform version.
  You can circumvent this by setting a 'server_version' configuration value

  For further information have a look at:
  https://github.com/doctrine/DoctrineBundle/issues/673


In AbstractMySQLDriver.php line 128:

  An exception occurred in driver: SQLSTATE[HY000] [1130] Host '172.18.0.3' i
  s not allowed to connect to this MySQL server


In Exception.php line 18:

  SQLSTATE[HY000] [1130] Host '172.18.0.3' is not allowed to connect to this
  MySQL server


In PDOConnection.php line 40:

  SQLSTATE[HY000] [1130] Host '172.18.0.3' is not allowed to connect to this
  MySQL server



In ConnectionFactory.php line 79:

  An exception occured while establishing a connection to figure out your pla
  tform version.
  You can circumvent this by setting a 'server_version' configuration value

  For further information have a look at:
  https://github.com/doctrine/DoctrineBundle/issues/673


In AbstractMySQLDriver.php line 128:

  An exception occurred in driver: SQLSTATE[HY000] [1130] Host '172.18.0.3' i
  s not allowed to connect to this MySQL server


In Exception.php line 18:

  SQLSTATE[HY000] [1130] Host '172.18.0.3' is not allowed to connect to this
  MySQL server


In PDOConnection.php line 40:

  SQLSTATE[HY000] [1130] Host '172.18.0.3' is not allowed to connect to this
  MySQL server



In ConnectionFactory.php line 79:

  An exception occured while establishing a connection to figure out your pla
  tform version.
  You can circumvent this by setting a 'server_version' configuration value

  For further information have a look at:
  https://github.com/doctrine/DoctrineBundle/issues/673


In AbstractMySQLDriver.php line 128:

  An exception occurred in driver: SQLSTATE[HY000] [1130] Host '172.18.0.3' i
  s not allowed to connect to this MySQL server


In Exception.php line 18:

  SQLSTATE[HY000] [1130] Host '172.18.0.3' is not allowed to connect to this
  MySQL server


In PDOConnection.php line 40:

  SQLSTATE[HY000] [1130] Host '172.18.0.3' is not allowed to connect to this
  MySQL server



In ConnectionFactory.php line 79:

  An exception occured while establishing a connection to figure out your pla
  tform version.
  You can circumvent this by setting a 'server_version' configuration value

  For further information have a look at:
  https://github.com/doctrine/DoctrineBundle/issues/673


In AbstractMySQLDriver.php line 128:

  An exception occurred in driver: SQLSTATE[HY000] [1130] Host '172.18.0.3' i
  s not allowed to connect to this MySQL server


In Exception.php line 18:

  SQLSTATE[HY000] [1130] Host '172.18.0.3' is not allowed to connect to this
  MySQL server


In PDOConnection.php line 40:

  SQLSTATE[HY000] [1130] Host '172.18.0.3' is not allowed to connect to this
  MySQL server
Szukałem poruszanego w podlinkowanych wątkach z Github odpowiednika pliku config, celem manualnego ustawienia "server_version", ale niestety takowego nie znalazłem.
Pozdrawiam
Jakub
User avatar
lesny8
Posts: 3132
Joined: Mon Dec 11, 2017 9:43 pm
Has thanked: 10 times
Been thanked: 9 times

Post

Ja mam w domu 4 maliny w różnych wersjach i QNAPa, pracuje na Ubuntu i tylko na RPi ZeroW nie mam serwera Supli, ale tylko jedna instancja służy mi jako wersja produkcyjna. Tylko do jednej podłączone mam sterowniki, reszta to testowe instancje.

Pomijając już wszystko co tam Ci się pokazuje, powiedz jak instalujesz tą swoją instancję?
Co robisz krok po kroku, bo ewidentnie coś tam przekombinowujesz ;)
SOP 2023 :heavy_check_mark:
SOP 2024 :heavy_check_mark:
Czekam na kolejne Supla Offline Party :upside_down_face:
🧩: 🔑cz->b ⛴️+ila
jaku2k
Posts: 920
Joined: Sun May 24, 2020 8:40 pm
Has thanked: 1 time

Post

lesny8 wrote: Tue Feb 22, 2022 9:54 pm Ja mam w domu 4 maliny w różnych wersjach i QNAPa, pracuje na Ubuntu i tylko na RPi ZeroW nie mam serwera Supli, ale tylko jedna instancja służy mi jako wersja produkcyjna. Tylko do jednej podłączone mam sterowniki, reszta to testowe instancje.
OK, w takim razie jest to baza produkcujna.
Pomijając już wszystko co tam Ci się pokazuje, powiedz jak instalujesz tą swoją instancję?
Co robisz krok po kroku, bo ewidentnie coś tam przekombinowujesz ;)
Przy pierwszej instalacji wykonałem krok po kroku polecenia z poradnika autorstwa @_aro_ .
jaku2k wrote: Fri Feb 18, 2022 10:04 pm [...] dodałem grupę docker, do której dodałem swojego użytkownika.

Code: Select all

Utworzyłem grupę docker [code]sudo synogroup --add docker
dodałem do niej użytkownika

Code: Select all

sudo synogroup --member docker Jakub
i zmieniłem uprawnienia (te trzy kroki wykonałem wg poradnika: https://davejansen.com/manage-docker-wi ... ology-nas/).

Code: Select all

sudo chown root:docker /var/run/docker.sock
Jeśli chodzi o kroki, jakie wykonałem wczoraj, to były to:
  • usunięcie kontenerów i obrazów związanych z Suplą (pomijając działające skrypty) z poziomu GUI dockera na NAS-ie
  • usunięcie zawartości folderu supla (w którym mieszczą się pliki; lokalizacja: /volume1/docker/supla)
  • wpisanie ./supla.sh
  • podmiana pliku .env
  • utworzenie ścieżek, które nie są tworzone automatycznie (bez ich utworzenia wyskakiwał błąd):
    xyz@DS716:/volume1/docker/supla$ mkdir /volume1/docker/supla/var/mysql
    xyz@DS716:/volume1/docker/supla$ mkdir /volume1/docker/supla/var/cloud-local
    xyz@DS716:/volume1/docker/supla$ mkdir /volume1/docker/supla/var/cloud-logs
  • wystartowanie kontenerów ./supla.sh start
  • zatrzymanie kontenerów
  • podmiana plików z /var
  • wystartowanie kontenerów
Pozdrawiam
Jakub

Return to “Pomoc”