shop-telegram-bot
Shop in telegram with admin panel
Technology stack
Java 17, Maven, Spring 3 (Boot, MVC, Data, Security), Hibernate, Postgresql, Freemarker, HTML, Telegram Bots
Notes before deploy
- Telegram bot sends images as a link, if they are uploaded from the localhost, the bot will not be able to send them
- Telegram bot does not support raw ip address for sending images, you should use domain instead
How to deploy with docker
mvn -f shop-telegram-bot/admin-panel/ package
mvn -f shop-telegram-bot/telegram-bot/ package
docker build -t shop-admin-panel shop-telegram-bot/admin-panel/
docker build -t shop-telegram-bot shop-telegram-bot/telegram-bot/
docker-compose -f shop-telegram-bot/docker-compose.yml up -d
How to deploy manually
- Install software
- Update and upgrade
sudo apt-get update && sudo apt-get upgrade
- Install git
apt-get install git
- Install maven
apt-get install maven
- Install jdk 17
apt-get install openjdk-17-jdk
- Install postgres
apt-get install postgresql postgresql-contrib
- Install nginx
apt-get install nginx
- Clone repository
git clone https://github.com/ivan909020/shop-telegram-bot.git
- Package admin panel
mvn -f shop-telegram-bot/admin-panel/ package
- Package telegram bot
mvn -f shop-telegram-bot/telegram-bot/ package
- Set environment variables
Add database environment variables.
- DATABASE_URL (jdbc:postgresql://localhost:5432/shop_telegram_bot)
- DATABASE_USERNAME (postgres)
- DATABASE_PASSWORD (postgres)
Or you can manually change configuration in properties telegram-bot/src/main/resources/hibernate.cfg.xml
and admin-panel/src/main/resources/application.properties
- Create telegram bot
- Create a telegram bot here and enable inline mode in settings
- Add telegram bot username and token to properties
telegram-bot/src/main/resources/application.properties
- To receive notifications about new orders you need specify your chat id in properties
- Set up database
Replace your-directory
with directory where the cloned repository is located
- Login postgres user
sudo -i -u postgres
- Connect postgres database
psql
- Change password
\password
- Create database
create database shop_telegram_bot;
- Exit from postgres database
\q
- Import database schema
psql -d shop_telegram_bot < /your-directory/shop-telegram-bot/resources/1_db_schema.sql
- Import database data
psql -d shop_telegram_bot < /your-directory/shop-telegram-bot/resources/2_db_data.sql
- Exit from postgres user
exit
- Set up admin panel
Create systemd unit
Replace your-directory
with directory where the cloned repository is located
nano /etc/systemd/system/shop-admin-panel.service
[Unit]
Description=shop-admin-panel
After=syslog.target
[Service]
WorkingDirectory=/your-directory/shop-telegram-bot/
ExecStart=/usr/bin/java -jar /your-directory/shop-telegram-bot/admin-panel/target/admin-panel-1.0.0.jar
StandardOutput=journal
StandardError=journal
SyslogIdentifier=shop-admin-panel
SuccessExitStatus=143
Type=simple
Restart=always
[Install]
WantedBy=multi-user.target reboot.target default.target poweroff.target
systemctl daemon-reload
systemctl enable shop-admin-panel.service
systemctl start shop-admin-panel.service
Nginx configuration
Replace your-domain.com
with your domain (domain is needed for correct sending of product photos)
nano /etc/nginx/conf.d/your-domain.com.conf
server {
listen 80;
server_name your-domain.com;
index index.html;
include conf.d/shop-admin-panel.include;
}
nano /etc/nginx/conf.d/shop-admin-panel.include
location /admin {
proxy_pass http://127.0.0.1:8080;
proxy_set_header Host $host;
proxy_set_header X-Real-IP $remote_addr;
proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
client_max_body_size 1024m;
}
systemctl restart nginx
Web UI is accessible on http://localhost:8080/admin
, default credentials - admin:admin
- Set up telegram bot
Create systemd unit
Replace your-directory
with directory where the cloned repository is located
nano /etc/systemd/system/shop-telegram-bot.service
[Unit]
Description=shop-telegram-bot
After=syslog.target
[Service]
WorkingDirectory=/your-directory/shop-telegram-bot/
ExecStart=/usr/bin/java -jar /your-directory/shop-telegram-bot/telegram-bot/target/telegram-bot-1.0.0-jar-with-dependencies.jar
StandardOutput=journal
StandardError=journal
SyslogIdentifier=shop-telegram-bot
SuccessExitStatus=143
Type=simple
Restart=always
[Install]
WantedBy=multi-user.target reboot.target default.target poweroff.target
systemctl daemon-reload
systemctl enable shop-telegram-bot.service
systemctl start shop-telegram-bot.service