You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cloudstack.apache.org by an...@apache.org on 2020/05/06 20:43:32 UTC
[cloudstack-documentation] branch master updated: Timezone
requirements for 4.14+ (#112)
This is an automated email from the ASF dual-hosted git repository.
andrijapanic pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/cloudstack-documentation.git
The following commit(s) were added to refs/heads/master by this push:
new 0cbf0c0 Timezone requirements for 4.14+ (#112)
0cbf0c0 is described below
commit 0cbf0c04861b528ffd32a8b71daf9dc437f6e1b6
Author: Andrija Panic <45...@users.noreply.github.com>
AuthorDate: Wed May 6 22:43:22 2020 +0200
Timezone requirements for 4.14+ (#112)
* Create _timezone.rst
* Update upgrade-4.13.rst
* Update upgrade-4.13.rst
* Update upgrade-4.12.rst
* Update upgrade-4.11.rst
* Update upgrade-4.10.rst
* Update upgrade-4.9.rst
* Update upgrade-4.8.rst
* Update upgrade-4.7.rst
* Update upgrade-4.6.rst
* Update upgrade-4.5.rst
* Update upgrade-4.4.rst
* Update upgrade-4.3.rst
* Update upgrade-4.2.rst
* Update _timezone.rst
---
source/upgrading/upgrade/_timezone.rst | 32 +++++++++++++++++++++++++++++++
source/upgrading/upgrade/upgrade-4.10.rst | 2 ++
source/upgrading/upgrade/upgrade-4.11.rst | 2 ++
source/upgrading/upgrade/upgrade-4.12.rst | 2 ++
source/upgrading/upgrade/upgrade-4.13.rst | 2 ++
source/upgrading/upgrade/upgrade-4.2.rst | 4 ++++
source/upgrading/upgrade/upgrade-4.3.rst | 4 ++++
source/upgrading/upgrade/upgrade-4.4.rst | 4 ++++
source/upgrading/upgrade/upgrade-4.5.rst | 4 ++++
source/upgrading/upgrade/upgrade-4.6.rst | 4 ++++
source/upgrading/upgrade/upgrade-4.7.rst | 4 ++++
source/upgrading/upgrade/upgrade-4.8.rst | 4 ++++
source/upgrading/upgrade/upgrade-4.9.rst | 2 ++
13 files changed, 70 insertions(+)
diff --git a/source/upgrading/upgrade/_timezone.rst b/source/upgrading/upgrade/_timezone.rst
new file mode 100644
index 0000000..1c00863
--- /dev/null
+++ b/source/upgrading/upgrade/_timezone.rst
@@ -0,0 +1,32 @@
+.. Licensed to the Apache Software Foundation (ASF) under one
+ or more contributor license agreements. See the NOTICE file
+ distributed with this work for additional information#
+ regarding copyright ownership. The ASF licenses this file
+ to you under the Apache License, Version 2.0 (the
+ "License"); you may not use this file except in compliance
+ with the License. You may obtain a copy of the License at
+ http://www.apache.org/licenses/LICENSE-2.0
+ Unless required by applicable law or agreed to in writing,
+ software distributed under the License is distributed on an
+ "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+ KIND, either express or implied. See the License for the
+ specific language governing permissions and limitations
+ under the License.
+
+.. sub-section included in upgrade notes.
+
+Time zone requirements
+######################
+
+As of CloudStack 4.14, you must explicitly configure time zone either in the MySQL server or JDBC driver (db.properties).
+In previous CloudStack versions, UTC time zone was assumed by default (all event's have UTC time stamps), so
+the same UTC time zone should now be explicitly configured.
+
+You can do this by editing the /etc/cloudstack/management/db.properties file and adding "serverTimezone=UTC"
+to the "db.cloud.url.params=" and "db.usage.url.params=" lines. Example lines, from a clean 4.14 installation, are given below:
+
+.. parsed-literal::
+
+ db.cloud.url.params=prepStmtCacheSize=517&cachePrepStmts=true&sessionVariables=sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'&serverTimezone=UTC
+ db.usage.url.params=serverTimezone=UTC
+
diff --git a/source/upgrading/upgrade/upgrade-4.10.rst b/source/upgrading/upgrade/upgrade-4.10.rst
index 527f851..a0070cd 100644
--- a/source/upgrading/upgrade/upgrade-4.10.rst
+++ b/source/upgrading/upgrade/upgrade-4.10.rst
@@ -114,6 +114,8 @@ Backup current database
Management Server
-----------------
+.. include:: _timezone.rst
+
Ubuntu
######
diff --git a/source/upgrading/upgrade/upgrade-4.11.rst b/source/upgrading/upgrade/upgrade-4.11.rst
index 599cb54..a7d91e0 100644
--- a/source/upgrading/upgrade/upgrade-4.11.rst
+++ b/source/upgrading/upgrade/upgrade-4.11.rst
@@ -110,6 +110,8 @@ Backup current database
Management Server
-----------------
+.. include:: _timezone.rst
+
Ubuntu
######
diff --git a/source/upgrading/upgrade/upgrade-4.12.rst b/source/upgrading/upgrade/upgrade-4.12.rst
index 0ad46c7..c7df566 100644
--- a/source/upgrading/upgrade/upgrade-4.12.rst
+++ b/source/upgrading/upgrade/upgrade-4.12.rst
@@ -108,6 +108,8 @@ Backup current database
Management Server
-----------------
+.. include:: _timezone.rst
+
Ubuntu
######
diff --git a/source/upgrading/upgrade/upgrade-4.13.rst b/source/upgrading/upgrade/upgrade-4.13.rst
index 39135a7..fbcce2b 100644
--- a/source/upgrading/upgrade/upgrade-4.13.rst
+++ b/source/upgrading/upgrade/upgrade-4.13.rst
@@ -109,6 +109,8 @@ Backup current database
Management Server
-----------------
+.. include:: _timezone.rst
+
Ubuntu
######
diff --git a/source/upgrading/upgrade/upgrade-4.2.rst b/source/upgrading/upgrade/upgrade-4.2.rst
index 564e886..596245f 100644
--- a/source/upgrading/upgrade/upgrade-4.2.rst
+++ b/source/upgrading/upgrade/upgrade-4.2.rst
@@ -96,6 +96,8 @@ Management Server Ubuntu
If you are using Ubuntu, follow this procedure to upgrade your packages. If
not, skip to step :ref:`rhel42`.
+.. include:: _timezone.rst
+
.. note::
**Community Packages:** This section assumes you're using the community
supplied packages for CloudStack. If you've created your own packages and
@@ -164,6 +166,8 @@ Management Server CentOS/RHEL
If you are using CentOS or RHEL, follow this procedure to upgrade your
packages. If not, skip to hypervisors section :ref:`upg_hyp_42`.
+.. include:: _timezone.rst
+
.. note::
**Community Packages:** This section assumes you're using the community
supplied packages for CloudStack. If you've created your own packages and
diff --git a/source/upgrading/upgrade/upgrade-4.3.rst b/source/upgrading/upgrade/upgrade-4.3.rst
index 08aa3d0..4c7e79a 100644
--- a/source/upgrading/upgrade/upgrade-4.3.rst
+++ b/source/upgrading/upgrade/upgrade-4.3.rst
@@ -100,6 +100,8 @@ Management Server on Ubuntu
If you are using Ubuntu, follow this procedure to upgrade your packages. If
not, skip to step :ref:`rhel43`.
+.. include:: _timezone.rst
+
.. note::
**Community Packages:** This section assumes you're using the community
supplied packages for CloudStack. If you've created your own packages and
@@ -169,6 +171,8 @@ Management Server on CentOS/RHEL
If you are using CentOS or RHEL, follow this procedure to upgrade your
packages. If not, skip to hypervisors section :ref:`upg_hyp_43`.
+.. include:: _timezone.rst
+
.. note::
**Community Packages:** This section assumes you're using the community
supplied packages for CloudStack. If you've created your own packages and
diff --git a/source/upgrading/upgrade/upgrade-4.4.rst b/source/upgrading/upgrade/upgrade-4.4.rst
index df1b2f7..0be2e86 100644
--- a/source/upgrading/upgrade/upgrade-4.4.rst
+++ b/source/upgrading/upgrade/upgrade-4.4.rst
@@ -100,6 +100,8 @@ Management Server on Ubuntu
If you are using Ubuntu, follow this procedure to upgrade your packages. If
not, skip to step :ref:`rhel44`.
+.. include:: _timezone.rst
+
.. note::
**Community Packages:** This section assumes you're using the community
supplied packages for CloudStack. If you've created your own packages and
@@ -169,6 +171,8 @@ Management Server on CentOS/RHEL
If you are using CentOS or RHEL, follow this procedure to upgrade your
packages. If not, skip to hypervisors section :ref:`upg_hyp_44`.
+.. include:: _timezone.rst
+
.. note::
**Community Packages:** This section assumes you're using the community
supplied packages for CloudStack. If you've created your own packages and
diff --git a/source/upgrading/upgrade/upgrade-4.5.rst b/source/upgrading/upgrade/upgrade-4.5.rst
index 92fc4b9..da6102b 100644
--- a/source/upgrading/upgrade/upgrade-4.5.rst
+++ b/source/upgrading/upgrade/upgrade-4.5.rst
@@ -109,6 +109,8 @@ Management Server on Ubuntu
If you are using Ubuntu, follow this procedure to upgrade your packages. If
not, skip to step :ref:`rhel45`.
+.. include:: _timezone.rst
+
.. note::
**Community Packages:** This section assumes you're using the community
supplied packages for CloudStack. If you've created your own packages and
@@ -181,6 +183,8 @@ Management Server on CentOS/RHEL
If you are using CentOS or RHEL, follow this procedure to upgrade your
packages. If not, skip to hypervisors section :ref:`upg_hyp_45`.
+.. include:: _timezone.rst
+
.. note::
**Community Packages:** This section assumes you're using the community
supplied packages for CloudStack. If you've created your own packages and
diff --git a/source/upgrading/upgrade/upgrade-4.6.rst b/source/upgrading/upgrade/upgrade-4.6.rst
index 1cb4d26..eca297b 100644
--- a/source/upgrading/upgrade/upgrade-4.6.rst
+++ b/source/upgrading/upgrade/upgrade-4.6.rst
@@ -98,6 +98,8 @@ Management Server on Ubuntu
If you are using Ubuntu, follow this procedure to upgrade your packages. If
not, skip to step :ref:`rhel46`.
+.. include:: _timezone.rst
+
.. note::
**Community Packages:** This section assumes you're using the community
supplied packages for CloudStack. If you've created your own packages and
@@ -167,6 +169,8 @@ Management Server on CentOS/RHEL
If you are using CentOS or RHEL, follow this procedure to upgrade your
packages. If not, skip to hypervisors section :ref:`upg_hyp_46`.
+.. include:: _timezone.rst
+
.. note::
**Community Packages:** This section assumes you're using the community
supplied packages for CloudStack. If you've created your own packages and
diff --git a/source/upgrading/upgrade/upgrade-4.7.rst b/source/upgrading/upgrade/upgrade-4.7.rst
index c1115f6..6cec9d8 100644
--- a/source/upgrading/upgrade/upgrade-4.7.rst
+++ b/source/upgrading/upgrade/upgrade-4.7.rst
@@ -97,6 +97,8 @@ Management Server on Ubuntu
If you are using Ubuntu, follow this procedure to upgrade your packages. If
not, skip to step :ref:`rhel47`.
+.. include:: _timezone.rst
+
.. note::
**Community Packages:** This section assumes you're using the community
supplied packages for CloudStack. If you've created your own packages and
@@ -166,6 +168,8 @@ Management Server on CentOS/RHEL
If you are using CentOS or RHEL, follow this procedure to upgrade your
packages. If not, skip to hypervisors section :ref:`upg_hyp_47`.
+.. include:: _timezone.rst
+
.. note::
**Community Packages:** This section assumes you're using the community
supplied packages for CloudStack. If you've created your own packages and
diff --git a/source/upgrading/upgrade/upgrade-4.8.rst b/source/upgrading/upgrade/upgrade-4.8.rst
index 2400b53..64e05c4 100644
--- a/source/upgrading/upgrade/upgrade-4.8.rst
+++ b/source/upgrading/upgrade/upgrade-4.8.rst
@@ -98,6 +98,8 @@ Management Server on Ubuntu
If you are using Ubuntu, follow this procedure to upgrade your packages. If
not, skip to step :ref:`rhel48`.
+.. include:: _timezone.rst
+
.. note::
**Community Packages:** This section assumes you're using the community
supplied packages for CloudStack. If you've created your own packages and
@@ -167,6 +169,8 @@ Management Server on CentOS/RHEL
If you are using CentOS or RHEL, follow this procedure to upgrade your
packages. If not, skip to hypervisors section :ref:`upg_hyp_48`.
+.. include:: _timezone.rst
+
.. note::
**Community Packages:** This section assumes you're using the community
supplied packages for CloudStack. If you've created your own packages and
diff --git a/source/upgrading/upgrade/upgrade-4.9.rst b/source/upgrading/upgrade/upgrade-4.9.rst
index 780a0d0..13ae88f 100644
--- a/source/upgrading/upgrade/upgrade-4.9.rst
+++ b/source/upgrading/upgrade/upgrade-4.9.rst
@@ -111,6 +111,8 @@ Backup current database
Management Server
-----------------
+.. include:: _timezone.rst
+
Ubuntu
######