Install server 1C

Quick start 1C on Ubuntu host

1. Install lxc on host

sudo apt-get update
sudo apt-get install lxc

2. Create servers for DB and 1C in LXC

sudo lxc-create -t download -n srvdb -- -d ubuntu -r xenial -a amd64
sudo lxc-create -t download -n srv1c -- -d ubuntu -r xenial -a i386
sudo lxc-start -n srvdb
sudo lxc-start -n srv1c
sudo lxc-info -n srv1c
sudo lxc-info -n srvdb
#add ip for srv1c to /etc/hosts

3. Install postgres on srvdb

sudo lxc-attach -n srvdb
locale-gen ru_RU.UTF-8
update-locale LANG=ru_RU.UTF-8
locale
sh -c 'echo "deb http://1c.postgrespro.ru/deb/ $(lsb_release -cs) main" > /etc/apt/sources.list.d/postgrespro-1c.list'
wget --quiet -O - http://1c.postgrespro.ru/keys/GPG-KEY-POSTGRESPRO-1C | sudo apt-key add - && sudo apt-get update
apt-get install postgresql-pro-1c-9.6
/etc/init.d/postgresql start
su - postgres
psql
postgres=# \password postgres
\q
exit

Database is ready. For tuning see Configure PostgreSQL

4. Install 1C server from deb packages

sudo lxc-attach -n srv1c
apt-get update
apt-get install apache2 openssh-server
apt-get install imagemagick-6.q16:i386
apt-get install imagemagick:i386

#Downloads deb to 1c
dpkg -i 1c/* 

#Public demo on server
/opt/1C/v8.3/i386/webinst -apache24 -wsdir demo -dir '/var/www/html/demo' -connStr 'Srvr="localhost";Ref="demo";'
service apache2 restart
service srv1cv83 restart

## Look ports for 1C 
netstat -ltpn 

#add ip for srvdb to /etc/hosts
exit

5. Configure NGINX.

Get keys for nginx from www.sslforfree.com

sudo apt-get install nginx

# Move ca_bundle.crt, certificate.crt and private.key to /etc/nginx/ssl/

Add to /etc/nginx/nginx.conf

    server {
              #listen 80;
    	      listen 443 ssl;
              server_name host;

              # location of key and certificate files
              ssl_certificate /etc/nginx/ssl/certificate.crt;
              ssl_certificate_key /etc/nginx/ssl/private.key;

              # cache ssl sessions 
              ssl_session_cache  builtin:1000  shared:SSL:10m;    

              # prefer server ciphers (safer)
              ssl_prefer_server_ciphers on;

         
              location / {
                proxy_pass http://srv1c;
        	    proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
         	    proxy_set_header X-Forwarded-Proto $scheme;
         	    proxy_set_header X-Real-IP $remote_addr;
         	    proxy_set_header Host $http_host;
                proxy_cache_bypass $http_upgrade;
              }
	}

Reload nginx

sudo nginx -s reload

6. Create tunnel to 1C server on PC with 1C Platform (see ports step #4)

ssh -gL 1540:srv1c:1540 1541:srv1c:1541 1560:srv1c:1640 host

Install 1C configuration on 1C server

7. Try to connect from firefox:

 https://host/demo

Backup and restore

1. Backup database

sudo lxc-attach -n srvdb
# Choose folder for backups: 
chown postgres:postgres /mnt/backup

su - postgres
psql

# Get list of databases - \l. Our DB is demo
\q
pg_dump -U postgres -Fc -Z9 demo -f /mnt/backup/demo.dump

where

-U (user)
-F (format of file) с (custom — format of zipping pg_dump, also possible tar and plain text)
-Z (mode of zipping) 0 — 9 (0 — without compressing, 9 — max compressing)
-f (to file)

2. Restore database

new database

su - postgres
createdb -T template0 newdb
pg_restore -d newdb /mnt/backup/demo.dump

replace database

su - postgres
dropdb demo
pg_restore -C -d postgres  /mnt/backup/demo.dump

Backup on google drive

See https://www.experts-exchange.com/articles/29279/Backup-Linux-Servers-to-Google-Drive.html

1. Install drive

wget -O drive https://drive.google.com/uc?id=0B3X9GlR6EmbnMHBMVWtKaEZXdDg 
mv drive /usr/sbin/drive 
chmod 755 /usr/sbin/drive
drive

You will see a link in your terminal, which you can paste into your browser. You may be prompted to login to Google. Next give Gdrive allow permissions, then Copy/Paste the code from the page into the terminal. Google drive command is now ready.

2. Add backup.sh in cron

crontab -e

For example: 0 4 * * * bash /root/backup.sh

mav96/server_1c