This is an old revision of the document!
WARNING: TVIP TMS in BETA stage, please report all bugs to support@tvip.ru
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:
apt-get install openjdk-8-jre
apt-get install postgresql
Install TVIP TMS:
apt-get install tvip-tms
Supported version: 7
Add repository to system:
cd /etc/yum.repos.d/ wget http://rpm.packages.tvip.ru/tvip-tms.repo
Install dependencies:
Install TVIP TMS:
yum install tvip-tms
root@tms:~# su postgres
postgres@tms:~# createuser -s 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
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/.
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
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
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