I’m in the process of installing 1.8.2 and trying to get the copied over Database from my 1.7.8 install to be recognized in the new version. I’ve done Truncate Log from m,y existing install and copied the file import.sql tothe location var/www/backup
I can get to the xibo login screen but can’t get it to recognize my login credentials from the old database
Followed the steps to set the Database
UPDATE `setting` SET `value`="/var/www/cms/library/", userSee=0, userChange=0 WHERE `setting`="LIBRARY_LOCATION";
UPDATE `setting` SET `value`="tcp://cms-xmr:50001", userSee=0, userChange=0 WHERE `setting`="XMR_ADDRESS";
UPDATE `setting` SET `value`="Apache" WHERE `setting`="SENDFILE_MODE";
exit
I’ve copied the files from my old install to the location var/www/cms/library.
The new install has put files in the location opt/xibo/shared/cms/library
My Database is showing as cms and not the mao-xibo copied over from my old program
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| cms |
My custom ports file is set as (password removed)
version: "2.1"
services:
cms-db:
image: mysql:5.6
volumes:
- "./shared/db:/var/lib/mysql"
restart: always
environment:
- MYSQL_DATABASE=mao-xibo
- MYSQL_USER=admin
- MYSQL_RANDOM_ROOT_PASSWORD=
mem_limit: 1g
env_file: config.env
cms-xmr:
image: xibosignage/xibo-xmr:release_1.8.2
ports:
- "65500:9505"
restart: always
mem_limit: 256m
env_file: config.env
cms-web:
image: xibosignage/xibo-cms:release_1.8.2
volumes:
- "./shared/cms/custom:/var/www/cms/custom"
- "./shared/backup:/var/www/backup"
- "./shared/cms/web/theme/custom:/var/www/cms/web/theme/custom"
- "./shared/cms/library:/var/www/cms/library"
- "./shared/cms/web/userscripts:/var/www/cms/web/userscripts"
restart: always
links:
- cms-db:mysql
- cms-xmr:50001
environment:
- XMR_HOST=cms-xmr
env_file: config.env
ports:
- "81:80"
mem_limit: 1g