Upgrading Tableau Server Version from 2024.03.04 to 2024.02.03¶

This section provides details on upgrading Tableau Server from version 2024.03.04 to 2024.02.03 on multiple servers, including installing the required PostgreSQL JDBC driver and updating server packages. It also covers configuring the Tableau Ticket Provider with Python 3.12 and ensuring the service is running.

1. On Tableau Server 01, stop the server, set environment variables, update the PostgreSQL driver and install the Tableau Server package.

   tsm stop
   
   USERNAME="veservice"
   PASSWORD="clcm"
   TECHUSER_PWD="clcm"
   DATAVOLUME="/home/sdb"                  
   TSM_ACTIVATED="not_yet"
   PACKAGE_PATH="/tmp/tableau/"
   TBLSRV_INSTALLER="2023.2.3"
   TBLSRV_PACKAGE="tableau-server-2024-2-3.x86_64.rpm"
   TBL_PGSQL_DRIVER="postgresql-42.7.4.jar"
   
   curl -sS https://jdbc.postgresql.org/download/$TBL_PGSQL_DRIVER -o /opt/tableau/tableau_driver/jdbc/$TBL_PGSQL_DRIVER
   rm -rf postgresql-42.7.3.jar
   yum install /tmp/tableau/tableau-server-2024-2-3.x86_64.rpm  -y
   

2. On Tableau Server 02 and 03, configure environment variables, update the PostgreSQL driver and install the Tableau Server package.

   USERNAME="veservice"
   PASSWORD="clcm"
   TECHUSER_PWD="clcm"
   DATAVOLUME="/home/sdb"                  
   TSM_ACTIVATED="not_yet"
   PACKAGE_PATH="/tmp/tableau/"
   TBLSRV_INSTALLER="2023.2.3"
   TBLSRV_PACKAGE="tableau-server-2024-2-3.x86_64.rpm"
   TBL_PGSQL_DRIVER="postgresql-42.7.4.jar"
   
   curl -sS https://jdbc.postgresql.org/download/$TBL_PGSQL_DRIVER -o /opt/tableau/tableau_driver/jdbc/$TBL_PGSQL_DRIVER
   rm -rf postgresql-42.7.3.jar
   yum install /tmp/tableau/tableau-server-2024-2-3.x86_64.rpm  -y
   

3. On Tableau Server 01, upgrade TSM, configure the Tableau Ticket Provider and verify the installation.

   echo clcm > /tmp/tableau/pwd_file
   /opt/tableau/tableau_server/packages/scripts.20242.24.0910.0334/upgrade-tsm --accepteula -u veservice --password-file=/tmp/tableau/pwd_file --no-prompt
   tsm start
   PUBLIC_KEY_URL="https://.<domain>.com/token_keys"
   TCKTPRVDR_INSTALLER="tableau_ticket_provider.tgz"
   mkdir tmp_tcktprvdr
   tar zxvf ${TCKTPRVDR_INSTALLER} -C ./tmp_tcktprvdr
   sed -i -e "s~<PUBLIC_KEY_URL>~${PUBLIC_KEY_URL}~g" ./tmp_tcktprvdr/tableau-ticket-provider.service
   #Update python version in install.sh and tableau-ticket-provider.service as python version
   +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
   python3.12 -m venv ${VENV}
   pip3.12 install --upgrade pip
   pip3.12 install *.whl
   SITE_PACKAGES=${VENV}/lib/python3.12/site-packages
   ExecStart=/opt/tableau-ticket-provider/tableauenv/bin/python3.12 -m tableau_ticket_provider
   +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
   cd tmp_tcktprvdr && bash install.sh && cd ..
   rm -rf ./tmp_tcktprvdr
   systemctl | grep tableau-ticket-provider.service