Cannot Restore using Script

tmswr · March 5, 2019, 11:32pm

I cannot get the restore script with Zammad to work. It does not look for the type of database (psgl). Essentially when I try to restore, the script is looking for zammad_db…gz, not zammad_db.psgl.gz. Any help?

Used Zammad version: Latest
Operating system: CentOS 7
Browser + version: Cmder

Expected behavior:

Restore Backup

Actual behavior:

Not inserting databse type

Steps to reproduce the behavior:

Backup
Attempt to restore on new install

MrGeneration · March 6, 2019, 8:48am

Do you have some more information?

E.g. does the script return any messages like errors?

With the information up there it’s impossible to help you.
If you’ve already taken a look into our documentation ( https://docs.zammad.org/en/latest/appendix-backup-and-restore.html ) you should be able to use the scripts.

Most important question is if your database servers are identical (also known as “are you trying to mix MySQL with PostgreSQL?”)

tmswr · March 6, 2019, 3:08pm

I’m sorry for the lack of info. I was at work past time and got a little tired.

We are attempting to migrate our Zammad install from one place to another which has an identical installation. I created a backup of our current Zammad install using PostgreSQL.

I’ve written the files and edited the config file of the new Zammad install. When I attempt to restore the backup, I get the following:

Essentially, the only thing I can find wrong is the script is looking for “_zammad_db…gz” for the database backup instead of “_zammad_db.psql.gz” (missing the database type). After this, the restore aborts.

I have triple checked that all backup files are within the directory.

MrGeneration · March 6, 2019, 5:16pm

Thanks for the input.
That’s really odd, it looks like the script is not able to determine what database you’re using.

This information gets collected on Line 23 in functions:

github.com

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


if [ "${DEBUG}" == "yes" ]; then
  echo "timestamp is ${TIMESTAMP}"
fi
}


function delete_old_backups () {
test -d ${BACKUP_DIR} && find ${BACKUP_DIR}/*_zammad_*.gz -type f -mtime +${HOLD_DAYS} -exec rm {} \;
}


function get_db_credentials () {
DB_ADAPTER="$(grep 'adapter:' < ${ZAMMAD_DIR}/config/database.yml | sed -e 's/.*adapter:\(\| \)//g')"
DB_NAME="$(grep 'database:' < ${ZAMMAD_DIR}/config/database.yml | sed -e 's/.*database:\(\| \) //g')"
DB_USER="$(grep 'username:' < ${ZAMMAD_DIR}/config/database.yml | sed -e 's/.*username:\(\| \)//g')"
DB_PASS="$(grep 'password:' < ${ZAMMAD_DIR}/config/database.yml | sed -e 's/.*password:\(\| \)//g')"


if [ "${DEBUG}" == "yes" ]; then
  echo "adapter=${DB_ADAPTER} dbname=${DB_NAME} dbuser=${DB_USER} dbpass=${DB_PASS}"
fi
}


function backup_dir_create () {

and then will be called on Line 89 in functions:

github.com

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




if [ "${CHOOSE_RESTORE}" != "yes" ]; then
  echo "Restore aborted!"
  exit 1
fi
}


function get_restore_dates () {
RESTORE_FILE_DATES="$(find ${BACKUP_DIR} -type f -iname '*_zammad_files.tar.gz' | sed -e "s#${BACKUP_DIR}/##g" -e "s#_zammad_files.tar.gz##g" | sort)"


if [ "${DB_ADAPTER}" == "postgresql" ]; then
  DB_FILE_EXT="psql"
elif [ "${DB_ADAPTER}" == "mysql2" ]; then
  DB_FILE_EXT="mysql"
fi


RESTORE_DB_DATES="$(find ${BACKUP_DIR} -type f -iname "*_zammad_db.${DB_FILE_EXT}.gz" | sed -e "s#${BACKUP_DIR}/##g" -e "s#_zammad_db.${DB_FILE_EXT}.gz##g" | sort)"
}


function choose_restore_date () {
if [ -n "${1}" ]; then

Could you please check if the config file /opt/zammad/config/database.yml contains exactly the line adapter: postgresql ?
My guess is that your config is somehow wrong and this is the reason why the script fails.
It would be interesting if the Zammad service itself is running on your destination system?

Maybe an incomplete installation. Hope this helps.

tmswr · March 6, 2019, 5:23pm

This is what the destination database.yml looks like:

I installed Zammad originally myself but had someone else install Zammad on the destination.

MrGeneration · March 6, 2019, 5:48pm

Thanks for that.
I guess there’s your problem.

If this is the file being found at /opt/zammad/config/ (without further subfolders) then someone just copied the template file without doing usefull stuff to it.

I guess this is not a package installation but a installation from source?
Doesn’t look intended. :x

system · July 4, 2019, 5:48pm

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