Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Error: Matomo is already installed. Original error was "Mysqli prepare error: Table 'matomo.matomo_option' doesn't exist". #340

Open
FuckingToasters opened this issue Dec 1, 2023 · 0 comments

Comments

@FuckingToasters
Copy link

FuckingToasters commented Dec 1, 2023

Hello, i had an issue where i wanted to update portainer so i downloaded the backup first but it not seem to have successfully downloaded and i only noticed that after the update, all containers were still running but i couldn't manage the stacks within the new portainer installation due to the error "this stack was created outside of portainer, control over it is limited"

Now i copy the env info etc shown in the running containers and make a new compose file out of it to add in an new stack.

Now i tried to do this process with matomo, which then after visiting the site caused following issue:
image

There are no erros shown in matomo or database logs, i guess i somehow need to set it so it uses the matomo files from the existing installation and not try to start a new installation process; i don't know how to do so tho.

Note: the go back to matomo just refresh the homepage on which the error happens, statuscode in netrequests is 400

Here the docker-compose.yml file:

version: '3.0'

services:
  matomo:
    image: matomo:latest
    command: apache2-foreground
    entrypoint: /entrypoint.sh
    environment:
      - APACHE_CONFDIR=/etc/apache2
      - APACHE_ENVVARS=/etc/apache2/envvars
      - GPG_KEYS=528995BFEDFBA7191D46839EF9BA0ADA31CBD89E 39B641343D8C104B2B146DC3F9C39DC0B9698544 F1F692238FBC1666E5A5CCD4199F9DFEF6FFBAFD
      - MATOMO_DATABASE_ADAPTER=MYSQLI
      - MATOMO_DATABASE_CHARSET=utf8mb4
      - MATOMO_DATABASE_CONNECT_TIMEOUT=60
      - MATOMO_DATABASE_DBNAME=matomo
      - MATOMO_DATABASE_ENABLE_SSL=0
      - MATOMO_DATABASE_HOST=db
      - MATOMO_DATABASE_PASSWORD=REDACTED
      - MATOMO_DATABASE_PORT=3306
      - MATOMO_DATABASE_TABLES_PREFIX=matomo_
      - MATOMO_DATABASE_USERNAME=InfinityMonster
    volumes:
       # - ./config:/var/www/html/config:z
       # - ./logs:/var/www/html/logs:z
      - data:/var/www/html:z
    restart: always
    networks:
      webproxy:
        ipv4_address: 172.26.0.10

  db:
    image: jc21/mariadb-aria:latest
    command: null
    entrypoint: /scripts/run.sh
    environment:
      - MYSQL_DATABASE=matomo
      - MYSQL_PASSWORD=REDACTED
      - MYSQL_ROOT_PASSWORD=REDACTED
      - MYSQL_USER=InfinityMonster
    volumes:
      - db:/var/lib/mysql:Z
    networks:
      webproxy:
        ipv4_address: 172.26.0.202

networks:
  webproxy:
    external: true

volumes:
  db:
  data:
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant