Details
-
Bug
-
Resolution: Fixed
-
Blocker
-
12.5.1, 11.10.6, 12.6
-
Unknown
-
N/A
-
N/A
-
Description
First, you need to have VirtualBox and Vagrant installed, then:
- Create a new directory, and go inside
mkdir stretch && cd stretch
- Create a file called Vagrantfile, with the following content
# -*- mode: ruby -*- # vi: set ft=ruby : Vagrant.configure("2") do |config| config.vm.box = "debian/stretch64" # To access XWiki from the outside on the port 8081 config.vm.network "forwarded_port", guest: 8080, host: 8081 # Configure the amount of memory on the VM config.vm.provider "virtualbox" do |vb| vb.memory = "3192" end end
- Create and start the machine
vagrant up
- Connect to that machine
vagrant ssh
- That's it, you're logged into your new virtual machine with a fresh Debian Stretch install!
- Note that you can browse to your wiki with your regular browser using the url http://localhost:8081/xwiki (there is a port redirection)
- Make sure the timezone is a "problematic" one
vagrant@stretch:~$ timedatectl | grep "Time zone" Time zone: GMT+0 (GMT, +0000)
- Install the needed dependency to handle HTTPS repositories
sudo apt-get install apt-transport-https
- Now install Oracle MySQL repositories ; create the file /etc/apt/sources.list.d/mysql.list with the following content:
deb http://repo.mysql.com/apt/debian/ stretch mysql-5.7
- Install the Oracle's key
wget -q "https://keyserver.ubuntu.com/pks/lookup?search=0x5072E1F5&op=get" -O- | sudo apt-key add -
- Now install XWiki repository:
sudo wget "https://maven.xwiki.org/stable/xwiki-stable.list" -P /etc/apt/sources.list.d/ wget -q "https://maven.xwiki.org/public.gpg" -O- | sudo apt-key add - sudo apt-get update
- Install XWiki 12.6.5 and CURL
sudo apt-get install xwiki-tomcat8-mysql=12.6.5 xwiki-tomcat8-common=12.6.5 xwiki-mysql-common=12.6.5 xwiki-common=12.6.5 curl
- Wait a bit, wake up xwiki
curl http://localhost:8080/xwiki/bin/view/Main/
- Wait until xwiki is initialized
curl http://localhost:8080/xwiki/bin/view/Main/
You end up with the following error in the page:
java.sql.SQLException: Cannot create PoolableConnectionFactory (No timezone mapping entry for 'GMT 00:00')
Attachments
Issue Links
- is related to
-
XWIKI-17494 The MySQL Debian setup does not work out of the box with some timezones
- Closed