Is Shopizer docker-image work with docker-compose and PostgreSQL DB?

115 views
Skip to first unread message

Aleks Nozzy

unread,
Sep 19, 2022, 9:47:57 AM9/19/22
to Shopizer
Hi all!
I try to run shopizer with docker-compose changed to work with postgres.
My docker-compose.yml is:
###########################################
---
services:
  shopizer-db:
    environment:
      - POSTGRES_PASSWORD=shopizer123
      - POSTGRES_DATABASE=salesmanager
      - POSTGRES_USER=salesmanager
#      - MYSQL_PASSWORD=shopizer_db_password
#      - MYSQL_ROOT_PASSWORD=shopizer123
#      - MYSQL_DATABASE=SALESMANAGER
#      - MYSQL_USER=shopizer_db_user
#      - MYSQL_PASSWORD=shopizer_db_password
    image: postgres
    container_name: shopizer-db
    networks:
      - shopizer-network
    ports:
      - "5432:5432"
#    volumes:
#      - $PWD/db:/var/lib/postgresql/data/pgdata
  #Infinispan image management
  shopizer:
    depends_on:
      - shopizer-db
    image: shopizerecomm/shopizer:latest
    container_name: shopizer
    environment:
    - "SPRING_PROFILES_ACTIVE=postgres"
    - "db.jdbcUrl=jdbc:postgresql://shopizer-db:5432/salesmanager"
#    - "db.jdbcUrl=jdbc:postgresql://shopizer-db:5432/salesmanager?autoReconnect=true&useUnicode=true&characterEncoding=UTF-8"
    - "db.driverClass=org.postgresql.Driver"
    - "hibernate.dialect=org.hibernate.dialect.PostgreSQLDialect"
    - "db.preferredTestQuery=SELECT 1"
    - "db.schema=salesmanager"
    - "hibernate.hbm2ddl.auto=update"
    - "db.user=salesmanager"
    - "db.password=shopizer123"
    - "elasticsearch.security.password=NOTREQUIRED"
    - "config.cms.contentUrl=http://shopizer.my-domain.com:8080"
    - "config.cms.method=default"
    - "elasticsearch.server.host=http://shopizer.my-domain.com"
    - "elasticsearch.server.port=9200"
    mem_limit: 2048m
    networks:
      - shopizer-network
    links:
      - shopizer-db
    ports:
      - "8080:8080"
    volumes:
      - $PWD/files:/files
  shopizer-admin:
    image: shopizerecomm/shopizer-admin:latest
    container_name: shopizer-admin
    environment:
    - "APP_BASE_URL=http://shopizer.my-domain.com:8080/api"
    networks:
      - shopizer-network
    ports:
      - "4200:80"
  shopizer-shop:
    image: shopizerecomm/shopizer-shop-reactjs:latest
    container_name: shopizer-shop
    environment:
    - "APP_MERCHANT=DEFAULT"
    - "APP_BASE_URL=http://shopizer.my-domain.com:8080"
    networks:
      - shopizer-network
    ports:
      - "80:80"
version: "2.2"
###################################################

But container after "docker-compose up -d" return error in logs:

root@gt-01:/srv/shopizer# docker logs shopizer
 _____  _                    _                  
/  ___|| |                  (_)                
\ `--. | |__    ___   _ __   _  ____  ___  _ __
 `--. \| '_ \  / _ \ | '_ \ | ||_  / / _ \| '__|
/\__/ /| | | || (_) || |_) || | / / |  __/| |  
\____/ |_| |_| \___/ | .__/ |_|/___| \___||_|  
                     | |                        
                     |_|                        
Shopizer 3.2.0 [based on Spring Boot version 2.5.12]

2022-09-19 13:37:57.520  INFO 1 --- [           main] c.s.shop.application.ShopApplication     : Starting ShopApplication v3.2.0 using Java 11.0.16.1 on 1be5d01f1d16 with PID 1 (/opt/app/shopizer.jar started by root in /)
2022-09-19 13:37:57.532  INFO 1 --- [           main] c.s.shop.application.ShopApplication     : The following 1 profile is active: "postgres"
2022-09-19 13:38:03.660 ERROR 1 --- [           main] o.s.boot.SpringApplication               : Application run failed

org.springframework.beans.factory.BeanDefinitionStoreException: Invalid bean definition with name 'secretKey' defined in class path resource [spring/shopizer-core-config.xml]: Could not resolve placeholder 'secretKey' in value "${secretKey}"; nested exception is java.lang.IllegalArgumentException: Could not resolve placeholder 'secretKey' in value "${secretKey}"
        at org.springframework.beans.factory.config.PlaceholderConfigurerSupport.doProcessProperties(PlaceholderConfigurerSupport.java:230) ~[spring-beans-5.3.18.jar!/:5.3.18]
        at org.springframework.context.support.PropertySourcesPlaceholderConfigurer.processProperties(PropertySourcesPlaceholderConfigurer.java:198) ~[spring-context-5.3.18.jar!/:5.3.18]
        at org.springframework.context.support.PropertySourcesPlaceholderConfigurer.postProcessBeanFactory(PropertySourcesPlaceholderConfigurer.java:173) ~[spring-context-5.3.18.jar!/:5.3.18]
        at org.springframework.context.support.PostProcessorRegistrationDelegate.invokeBeanFactoryPostProcessors(PostProcessorRegistrationDelegate.java:325) ~[spring-context-5.3.18.jar!/:5.3.18]
        at org.springframework.context.support.PostProcessorRegistrationDelegate.invokeBeanFactoryPostProcessors(PostProcessorRegistrationDelegate.java:183) ~[spring-context-5.3.18.jar!/:5.3.18]
        at org.springframework.context.support.AbstractApplicationContext.invokeBeanFactoryPostProcessors(AbstractApplicationContext.java:746) ~[spring-context-5.3.18.jar!/:5.3.18]
        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:564) ~[spring-context-5.3.18.jar!/:5.3.18]
        at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:145) ~[spring-boot-2.5.12.jar!/:2.5.12]
        at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:775) ~[spring-boot-2.5.12.jar!/:2.5.12]
        at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:448) ~[spring-boot-2.5.12.jar!/:2.5.12]
        at org.springframework.boot.SpringApplication.run(SpringApplication.java:339) ~[spring-boot-2.5.12.jar!/:2.5.12]
        at org.springframework.boot.SpringApplication.run(SpringApplication.java:1365) ~[spring-boot-2.5.12.jar!/:2.5.12]
        at org.springframework.boot.SpringApplication.run(SpringApplication.java:1354) ~[spring-boot-2.5.12.jar!/:2.5.12]
        at com.salesmanager.shop.application.ShopApplication.main(ShopApplication.java:14) ~[classes!/:3.2.0]
        at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:na]
        at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:na]
        at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:na]
        at java.base/java.lang.reflect.Method.invoke(Method.java:566) ~[na:na]
        at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:49) ~[shopizer.jar:3.2.0]
        at org.springframework.boot.loader.Launcher.launch(Launcher.java:108) ~[shopizer.jar:3.2.0]
        at org.springframework.boot.loader.Launcher.launch(Launcher.java:58) ~[shopizer.jar:3.2.0]
        at org.springframework.boot.loader.JarLauncher.main(JarLauncher.java:88) ~[shopizer.jar:3.2.0]
Caused by: java.lang.IllegalArgumentException: Could not resolve placeholder 'secretKey' in value "${secretKey}"
Reply all
Reply to author
Forward
0 new messages