This is an old revision of the document!


TVIP TMS install guide

WARNING: TVIP TMS in BETA stage, please report all bugs to support@tvip.ru

Ubuntu users

Supported version: 16.04 LTS

First - check your system locale, if your locale is not UTF-8 you might setup correct locale (system locale influence to postgresql cluster).

locale -a

if you not seen UTF-8 entries in output, you need setup (change en_US code to your region):

locale-gen en_US.UTF-8
dpkg-reconfigure locale
dpkg-reconfigure keyboard-configuration
localedef -i en_US -c -f UTF-8 en_US.UTF-8

Locale change after system reboot:

reboot

Add repository to system:

echo "deb http://deb.packages.tvip.ru/ xenial main" >> /etc/apt/sources.list.d/tms.list
wget --quiet -O - http://deb.packages.tvip.ru/deploy/key.asc | apt-key add -
apt-get update

Install dependencies:

  • openjdk-java or oracle java (version 1.8 or above)
apt-get install openjdk-8-jre
  • postgresql server (version 9.2 or above)
apt-get install postgresql

Install TVIP TMS:

apt-get install tvip-tms

CentOS users

Supported version: 7

Add repository to system:

cd /etc/yum.repos.d/
wget http://rpm.packages.tvip.ru/tvip-tms.repo

Install dependencies:

  • openjdk-java or oracle java (version 1.8)
  • postgresql server (version 9.2 or above)

Install TVIP TMS:

yum install tvip-tms

Configure and start

  • Switch to postgres user
root@tms:~# su postgres
  • Create tvip_middleware user:
postgres@tms:~# createuser -s tvip_middleware
  • Create database for tvip_middleware:
createdb tvip_middleware -O tvip_middleware

Configure pg_hba.conf:

On ubuntu this configuration located at /etc/postgresql/<pg_version>/main/pg_hba.conf

On centos this configuration located at /var/lib/pgsql/data/pg_hba.conf

Set access restriction for local, 127.0.0.1/32 ::1/128 to trust:

# "local" is for Unix domain socket connections only
local   all             all                                     trust
# IPv4 local connections:
host    all             all             127.0.0.1/32            trust
# IPv6 local connections:
host    all             all             ::1/128                 trust

This option allow passwordless access to all databases from localhost (not for remote connections).

Restart postgres service

service postgresql restart

Default database configuration (/opt/tvip-tms/application-prod.properties):

server.port=80
server.tomcat.accesslog.enabled=true
server.tomcat.accesslog.directory=/var/log/tms
spring.datasource.tomcat.max-active=70
spring.datasource.tomcat.max-wait=1000
spring.datasource.url=jdbc:postgresql://localhost:5432/tvip_middleware
spring.datasource.username=tvip_middleware
spring.datasource.password=

Enable service:

#autostart
systemctl enable tvip-tms

#start service
service tvip-tms start

Check installation

Admin panel located at

http://<your_server>:<server_port>/admin

Fresh installation contains examples of channels, accounts, etc…

Ubuntu 16.04, CentOS 7: application logs available by:

journalctl -f -u tvip-tms

Ubuntu 14.04: application logs available by:

tail -f /var/log/tvip-tms.log

On all OS access log available in /var/log/tms/.

Migration from TVIP Middleware version 2

For migration to TMS you need fetch dump tvip-middleware database and restore database on new server (see instructions below)

Be careful: database from TMS is not compatible with TVIP Middleware 2, but TVIP Middleware 2 database is allow to use with TVIP TMS

How to backup tvip-middleware (not TMS) database

  • Get database name at /usr/local/etc/tvipmw.yml, usually this name is tvip_middleware
  • Switch to postgres user from root user and change current directory to rw allowed path
root@mw:~# su postgres
postgres@mw:~# cd /var/lib/postgresql/9.3/

Make dump:

postgres@mw:~/9.3$ pg_dump tvip_middleware > tvip_middleware.sql

Transfer generated file to another host ( for backup or migration cases ) For secure copy (over ssh) use command:

postgres@mw:~/9.3$ scp tvip_middleware.sql myname@tms.example.com:/home/myname

How to restore tvip-middleware database to FRESH TVIP TMS

If you use tvip-middleware previously:

postgres@tms:~# psql -u tvip_middleware tvip_middleware < /path/to/dump/tvip-middleware.sql

WARNING: tvip-middleware backup might be restore before FIRST run of tvip-tms


Translations of this page: