prere_debian.sh

#!/bin/bash
set -u

# ----- ----- ----- ----- -----
# Env: debain 12
# Desc: asterisk 20.5+
# 
# Note: user asterisk
#       pass like2024
#
# Date: 2024.2.18
# ----- ----- ----- ----- -----

####################  version  control  ####################
asterisk='21.1.0'

git='2.46.0'
go='1.22.0'
############################################################

# install mariadb connector
install_connector() {
  if [[ $1 != "mariadb" ]]; then return 0
  fi

  local ver="3.2.1"

  local pkgtar="mariadb-connector-odbc-${ver}-debian-bookworm-amd64.tar.gz"
  if [[ `lsb_release -i --short` == "ubuntu" ]]; then 
    if [[ `lsb_release -c --short` == "jammy" ]]; then
      pkgtar="mariadb-connector-odbc-3.2.1-ubuntu-jammy-amd64.tar.gz" # v22.04
    else
      pkgtar="mariadb-connector-odbc-3.2.1-ubuntu-lunar-amd64.tar.gz"
    fi
  fi

  if [ ! -f /opt/$pkgtar ]; then
    sudo wget -P /opt \
      https://downloads.mariadb.com/Connectors/odbc/connector-odbc-${ver}/$pkgtar
    sudo tar -xzf /opt/mariadb-connector-odbc-*.tar.gz -C /usr/local/src
  fi
  cd /usr/local/src/mariadb-connector-odbc-*

  sudo install lib/mariadb/libmaodbc.so /usr/lib/
  sudo install -d /usr/lib/mariadb/
  sudo install -d /usr/lib/mariadb/plugin/
  sudo install lib/mariadb/plugin/* /usr/lib/mariadb/plugin/
}

add_config() {
  if [[ `whoami` == "root" ]]; then
    sudo echo "" > /etc/odbc.ini
    sudo echo "[asterisk-connector]" >> /etc/odbc.ini 
    sudo echo "Description = MySQL connection to 'asterisk' database" >> /etc/odbc.ini 
    sudo echo "Driver = MariaDB" >> /etc/odbc.ini 
    sudo echo "Database = asterisk" >> /etc/odbc.ini 
    sudo echo "Server = localhost" >> /etc/odbc.ini 
    sudo echo "Port = 3306" >> /etc/odbc.ini 
    sudo echo "Socket = /run/mysqld/mysqld.sock" >> /etc/odbc.ini 
    return 0
  fi

  # sudo echo "xxx" >> /x/file have not effect when bash x.sh without sudo
  echo "[asterisk-connector]" | sudo tee -a /etc/odbc.ini 
  echo "Description = MySQL connection to 'asterisk' database" | sudo tee -a /etc/odbc.ini 
  echo "Driver = MariaDB" | sudo tee -a /etc/odbc.ini 
  echo "Database = asterisk" | sudo tee -a /etc/odbc.ini 
  echo "Server = localhost" | sudo tee -a /etc/odbc.ini 
  echo "Port = 3306" | sudo tee -a /etc/odbc.ini 
  echo "Socket = /run/mysqld/mysqld.sock" | sudo tee -a /etc/odbc.ini 
}

# create db asterisk
create_dbuser() {
  sudo mysql -e "create user 'asterisk'@'%' identified by 'like2024';"
  sudo mysql -e "create database IF NOT EXISTS asterisk;"
  sudo mysql -e "GRANT ALL PRIVILEGES ON asterisk.* TO 'asterisk'@'%';"

  sudo mysql -e "flush privileges;"
}

install_mysql8() {
  mysql --version
  if [ $? -ne 127 ]; then return 0
  fi 

  # add sql source
  local pkg="mysql-apt-config_0.8.29-1_all.deb"
  if [ ! -f /opt/$pkg ]; then
    sudo wget -P /opt http://repo.mysql.com/$pkg
    sudo dpkg -i /opt/$pkg
    sudo apt update
  fi

  sudo apt install -y mysql-server
  sudo systemctl enable mysql
  create_dbuser 'asterisk'
}

check_env_db() {
  sudo apt install -y unixodbc unixodbc-dev unixodbc-* # 2.3.11
  sudo apt install -y libltdl-dev
  sudo apt install -y odbcinst

  sudo apt install -y libmariadb-dev

  # libmyodbc8a.so will be put in /usr/lib/x86_64-linux-gnu/odbc/
  sudo apt install -y mysql-connector-odbc

  install_mysql8
  install_connector "mariadb"

  # clean and write config k=v into /etc/odbc.ini
  if [ ! -f /etc/odbc.ini ]; then add_config
  fi

  #local line1=`cat /etc/odbcinst.ini | head --lines=1`
  local line1=`odbcinst -q -d | head --lines=1`
  if [[ $line1 != "[MariaDB]" ]]; then
    # write into /etc/odbcinst.ini
    sudo sed -i '1i [MariaDB]'  /etc/odbcinst.ini
    sudo sed -i '2i Description=ODBC for MariaDB' /etc/odbcinst.ini
    sudo sed -i '3i Driver=/usr/lib/libmaodbc.so' /etc/odbcinst.ini
    sudo sed -i '4i UsageCount=1' /etc/odbcinst.ini
    sudo sed -i '5i  ' /etc/odbcinst.ini
  fi
}

# default:
# python with v3.11 has existed
check_env() {
  sudo apt install -y subversion \
    vim curl wget 

  # default add gcc(v12.2) 
  sudo apt install -y build-essential

  bash ./apps/git_debian.sh $git
  git config --global user.name "wangpeng"
  git config --global user.email "18795975517@163.com"
  git config --global http.sslVerify "false"
  git config --global core.autocrlf input

  sudo apt install -y \
    libnewt-dev libssl-dev libncurses5-dev libsqlite3-dev \
    libjansson-dev libxml2-dev uuid-dev default-libmysqlclient-dev
}

# 3 latest versions exist at the same time in page 
download_asterisk() {
  local ver="21.1.0"
  if [ $# -eq 1 ]; then ver=$1; 
  fi
  local pkg="asterisk-${ver}.tar.gz"

  # curl can not specify dir
  cd /opt
  sudo curl -# -C - -O http://downloads.asterisk.org/pub/telephony/asterisk/$pkg
  ls -al -hog --color=auto # 27M
  sudo tar xvf asterisk-20* -C /usr/local/src
  if [ $? -eq 1 ]; then 
    echo "get source package failure, need download again!"; exit
  fi

  cd /usr/local/src/${pkg%.tar*}

  sudo contrib/scripts/get_mp3_source.sh
  sudo contrib/scripts/install_prereq install
}

build_asterisk() {
  cd /usr/local/src/asterisk-*
  sudo ./configure

  sudo make menuselect

  local op=0
  read -p "make? (default not) [Y/n]" op
  case $op in
    1 | Y | y) sudo make; sudo make install;
      sudo make samples
      sudo make config
      sudo make install-logrotate ;;
    *) exit
  esac

  read -p "need C-API? (default not) [Y/n]" op
  case $op in
    1 | Y | y) 
      sudo make progdocs ;;
    *)
  esac

  sudo ldconfig
}

add_user() {
  local userName="asterisk"
  userName=$1
  sudo groupadd $userName
  sudo useradd -r -d /var/lib/asterisk -g asterisk $userName

  sudo usermod -aG audio,dialout asterisk
  sudo chown -R asterisk:$userName /etc/asterisk
  sudo chown -R asterisk:$userName /var/{lib,log,spool}/asterisk
  sudo chown -R asterisk:$userName /usr/lib/asterisk
}

# install or update go (v1.21+)
install_go() {
  go version 2> /dev/null
  if [ $? -ne 127 ]; then 
    if [[ $1 == `go env GOVERSION` ]]; then 
      return 0; # don't reinstall when their version are consistent
    fi
  fi
  # e.g.  go1.22.3.linux-amd64.tar.gz
  local pkgName=$1.linux-amd64.tar.gz

  if [ ! -f /opt/$pkgName ]; then sudo wget -P /opt  \
    --no-verbose https://go.dev/dl/$pkgName
  fi
  sudo rm -rf /usr/local/etc/go
  sudo tar  -xzf /opt/$pkgName -C /usr/local/etc
  
  cat /etc/profile | grep -i go/bin
  if [ $? -eq 1 ]; then
    echo "export PATH=\$PATH:/usr/local/etc/go/bin" | sudo tee -a /etc/profile
  fi
  echo "remember source /etc/profile, then run this script again!"
  exit
}

# 26 tables will generate in mysql
generate_tables() {
  sudo apt install -y alembic
  # only this can work, not pip install
  sudo apt install -y python3-mysqldb

  cd /usr/local/src/asterisk-2*/contrib/ast-db-manage/
  sudo cp config.ini.sample config.ini
  sudo sed -i '21s/user/asterisk/g'  ../ast-db-manage/config.ini
  sudo sed -i '21s/pass/like2024/g'  ../ast-db-manage/config.ini

  alembic -c ./config.ini upgrade head
}

tip() {
  echo "need any option:"
  echo -e "\t [1] --add-asterisk \n\t [2] --add-go"
  echo -e "\t [3] --no-table     \n\t [4] --no-checkenv"
  exit 
}

# ----- ----- main ----- -----
check_need=1
table_need=1
asterisk_need=0
go_need=0

args=("$@")
# length must exist
if [ ${#args[@]} -eq 0 ]; then tip
fi

for op in "${args[@]}"
do
    case $op in 
      --1 | --add-asterisk) asterisk_need=1 ;;
      --2 | --add-go)       go_need=1    ;;
      --3 | --no-table)     table_need=0 ;;
      --4 | --no-checkenv)  check_need=0 ;;
      *) tip
    esac
done 

if [ $check_need -eq 1 ]; then
  check_env
  check_env_db
fi

if [ $go_need -eq 1 ]; then install_go "go$go"

  go env -w GOPRIVATE=https://go.pfgit.cn
  go env -w GOPROXY=https://proxy.golang.com.cn,direct
  go env -w GO111MODULE=on
  go env -w GOSUMDB=off
  exit
fi

if [ $asterisk_need -eq 1 ]; then
  sudo asterisk -V
  if [ $? -eq 127 ]; then
    download_asterisk $asterisk
    build_asterisk
  fi

  sudo chmod 777 /etc/asterisk/extensions.conf
fi

id asterisk
if [ $? -eq 1 ]; then
  add_user "asterisk"
fi

sudo sed -i '8s/.*/AST_USER="asterisk"/' /etc/default/asterisk 
sudo sed -i '9s/.*/AST_GROUP="asterisk"/' /etc/default/asterisk 
sudo sed -i '75s/.*/runuser = asterisk/' /etc/asterisk/asterisk.conf 
sudo sed -i '76s/.*/rungroup = asterisk/' /etc/asterisk/asterisk.conf

if [ $table_need -eq 0 ]; then exit
fi
# create tables in db
generate_tables

sudo systemctl restart asterisk
sudo systemctl enable asterisk

sudo asterisk -V