Error occured when backuping

juliels · July 14, 2020, 11:48am

Infos:

Used Zammad version: 3.3
Used Zammad installation source: (source, package, …) package
Operating system: centos7
Browser + version: chrome

Expected behavior:

Backup zammad works fine

Actual behavior:

I am trying to backup zammad , but an error occure:

[root@zammad backup]# ./zammad_backup.sh

Zammad backup started - mar. juil. 14 12:24:20 CET 2020!

creating file backup…
creating mysql backup…
mysqldump: Got error: 2002: “Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)” when trying to connect

Zammad backuped successfully - mar. juil. 14 12:24:41 CET 2020!

the file /var/lib/mysql/mysql.sock exist on my mysql server and has the ownership : mysql mysql

PS:

I am using a mysql database on another server (external database)

I have tested conection from my zammad instance to the mysql database :

 mysql -h  ipadresse  -P 3306  -u userh -p
 Enter password:
 Welcome to the MariaDB monitor.  Commands end with ; or \g.
 Your MariaDB connection id is ...........

Steps to reproduce the behavior:

$ vim /opt/zammad/contrib/backup/config

BACKUP_DIR=’/root/backup/z_backup’

HOLD_DAYS=‘5’

DEBUG='no

$ cd /opt/zammad/contrib/backup
$ ./zammad_backup.sh

MrGeneration · July 16, 2020, 1:00pm

That’s the mysql based relevant line:

github.com

zammad/zammad/blob/develop/contrib/backup/functions#L50



function backup_files () {
  echo "creating file backup..."
  tar -C / -czf ${BACKUP_DIR}/${TIMESTAMP}_zammad_files.tar.gz --exclude='tmp' ${ZAMMAD_DIR#/}
  ln -sfn ${BACKUP_DIR}/${TIMESTAMP}_zammad_files.tar.gz ${BACKUP_DIR}/latest_zammad_files.tar.gz
}

function backup_db () {
  if [ "${DB_ADAPTER}" == "mysql2" ]; then
    echo "creating mysql backup..."
    mysqldump --opt --single-transaction -u${DB_USER} -p${DB_PASS} ${DB_NAME} | gzip > ${BACKUP_DIR}/${TIMESTAMP}_zammad_db.mysql.gz
    ln -sfn ${BACKUP_DIR}/${TIMESTAMP}_zammad_db.mysql.gz ${BACKUP_DIR}/latest_zammad_db.mysql.gz
  elif [ "${DB_ADAPTER}" == "postgresql" ]; then
    echo "creating postgresql backup..."
    su -c "pg_dump -c ${DB_NAME} | gzip > /tmp/${TIMESTAMP}_zammad_db.psql.gz" postgres
    mv /tmp/${TIMESTAMP}_zammad_db.psql.gz ${BACKUP_DIR}
    ln -sfn ${BACKUP_DIR}/${TIMESTAMP}_zammad_db.psql.gz ${BACKUP_DIR}/latest_zammad_db.psql.gz
  else
    echo "DB ADAPTER not found. if its sqlite backup is already saved in the filebackup"
  fi
}

So in short, this should be fixable with adjusting your mysql client configuration to tell it it doesn’t want to connect to the local socket by default. If that’s no option, copy the backup directory and adjust backup script.

This backup script expects the installation to be local.

system · November 13, 2020, 1:00pm

This topic was automatically closed 120 days after the last reply. New replies are no longer allowed.