Micke Nordin
|
e0139b0765
|
BAckups: Fix db backups
DB backup dir clashed with statistics script storage location, and also
some permission errors.
diff --git a/templates/script/backupdb.erb.sh b/templates/script/backupdb.erb.sh
index b35acbc..1eb7992 100644
--- a/templates/script/backupdb.erb.sh
+++ b/templates/script/backupdb.erb.sh
@@ -6,11 +6,16 @@ sleep $((16#$(ip a | grep "link/ether" | head -1 | awk -F ':' '{print $6}' | awk
number_of_full_to_keep="<%= @full_backup_retention %>"
backup="${1}"
+if [[ -z ${backup} ]]; then
+ backup="backup1.$(hostname -d)"
+fi
if ! [[ ${backup} =~ backup1.*sunet.se$ ]]; then
echo "Usage: ${0} <fqdn of backup server>"
echo "Example: ${0} backup1.sunet.drive.sunet.se"
fi
backup_dir="/opt/backups"
+backup_dir_long="${backup_dir}/backups"
+mkdir -p ${backup_dir}
bucket="db-backups"
mirror="<%= @customer %>-<%= @environment %>-mirror"
if [[ ${mirror} =~ common-(test|prod)-mirror ]]; then
@@ -23,11 +28,8 @@ ssh ${backup} "sudo /home/script/bin/backup_db.sh"
echo "Cleaning up old backups for ${backup}"
ssh ${backup} "sudo /home/script/bin/purge_backups.sh /opt/mariadb_backup/backups/"
echo "Copying backups here"
-mkdir -p ${backup_dir}
-scp script@${backup}:/opt/mariadb_backup/backups/$(date +%Y/%m/%d)/*.gz ${backup_dir}
+scp script@${backup}:/opt/mariadb_backup/backups/$(date +%Y/%m/%d)/*.gz ${backup_dir_long}
echo "Copying backups to remote bucket"
rclone mkdir ${mirror}:${bucket}
duplicity --full-if-older-than 1M --tempdir /mnt --archive-dir /mnt --no-encryption ${backup_dir} rclone://${mirror}:/${bucket}
duplicity remove-all-but-n-full ${number_of_full_to_keep} --tempdir /mnt --archive-dir /mnt --force rclone://${mirror}:/${bucket}
-echo "cleaning up"
-rm -r ${backup_dir}
diff --git a/templates/scriptreceiver/backup_db.erb.sh b/templates/scriptreceiver/backup_db.erb.sh
index 025a338..3e15f25 100644
--- a/templates/scriptreceiver/backup_db.erb.sh
+++ b/templates/scriptreceiver/backup_db.erb.sh
@@ -11,5 +11,7 @@ else
fi
docker exec ${container} /do_backup.sh ${customer}
+chown root:script /opt/mariadb_backup/
+chmod 750 /opt/mariadb_backup/
chmod 755 ${backupdir}
chown -R script:root ${backupdir}
|
2023-06-13 12:15:19 +02:00 |
|
Micke Nordin
|
0f8f27773b
|
Add support for replicating from multinode dbs
|
2023-06-12 09:31:41 +02:00 |
|
Micke Nordin
|
e7ffd6fac3
|
Add nordu.net
|
2023-06-08 16:43:05 +02:00 |
|
Micke Nordin
|
3531be828e
|
Add nordu.net
|
2023-06-08 16:32:43 +02:00 |
|
Micke Nordin
|
24b0b1eedc
|
Revert "Use nce image"
This reverts commit 20471ebaa8 .
|
2023-06-01 11:47:16 +02:00 |
|
Micke Nordin
|
20471ebaa8
|
Use nce image
|
2023-06-01 11:44:50 +02:00 |
|
Fredrik Kjellman
|
3dab127050
|
Merge branch 'main' into stable
|
2023-05-08 09:15:12 +02:00 |
|
Fredrik Kjellman
|
fc4b51b4ac
|
update mapping file to fix problems for shh.se
|
2023-05-08 09:14:00 +02:00 |
|
Fredrik Kjellman
|
a14a71f5d6
|
Merge branch 'main' into stable
|
2023-05-03 15:32:38 +02:00 |
|
Fredrik Kjellman
|
52c11917ce
|
modify mappingfile for GSS to help SHH to login.
|
2023-05-03 15:00:24 +02:00 |
|
Micke Nordin
|
ca2cf7e3f2
|
Allow file locks to be debug logged for sunet test
|
2023-04-27 16:44:06 +02:00 |
|
Micke Nordin
|
75f75732e7
|
Fix repair command
|
2023-04-26 11:22:25 +02:00 |
|
Micke Nordin
|
8ca66c10ad
|
Add more repair commands and use tty for occ
|
2023-04-26 09:26:46 +02:00 |
|
Micke Nordin
|
7d10d168bd
|
Fix nc_upgrade_command
|
2023-04-25 17:48:13 +02:00 |
|
Micke Nordin
|
036dcf010c
|
Add gss
|
2023-04-24 16:39:09 +02:00 |
|
Micke Nordin
|
3b5d14a189
|
Try again
|
2023-04-24 16:34:37 +02:00 |
|
Micke Nordin
|
e840903eae
|
Can I force string
|
2023-04-24 16:30:12 +02:00 |
|
Micke Nordin
|
db516e3b72
|
New name
|
2023-04-24 16:27:21 +02:00 |
|
Micke Nordin
|
a9695aeee1
|
Two passes
|
2023-04-24 16:25:37 +02:00 |
|
Micke Nordin
|
713f12e1d4
|
Terminate regex
|
2023-04-24 16:23:01 +02:00 |
|
Micke Nordin
|
568cb87ad6
|
Trim version
|
2023-04-24 16:21:22 +02:00 |
|
Micke Nordin
|
709d2165ac
|
Gsub
|
2023-04-24 16:13:11 +02:00 |
|
Micke Nordin
|
37e419cf75
|
Try regsubst
|
2023-04-24 16:06:55 +02:00 |
|
Micke Nordin
|
54868e8518
|
Yet another try
|
2023-04-24 15:59:47 +02:00 |
|
Micke Nordin
|
20d1558866
|
Yet another try
|
2023-04-24 15:56:22 +02:00 |
|
Micke Nordin
|
f1276d52d3
|
Fingers crossed
|
2023-04-24 15:51:49 +02:00 |
|
Micke Nordin
|
9b44a99135
|
Print debug to file
|
2023-04-24 15:47:56 +02:00 |
|
Micke Nordin
|
9ec76cfc7f
|
Yet another try
|
2023-04-24 15:39:32 +02:00 |
|
Micke Nordin
|
71fd8a3287
|
Yet another try
|
2023-04-24 15:34:02 +02:00 |
|
Micke Nordin
|
f95675f6ee
|
Yet another try
|
2023-04-24 15:27:51 +02:00 |
|
Micke Nordin
|
e06b7ffb1c
|
Try to lookup fact yet another way
|
2023-04-24 15:23:57 +02:00 |
|
Micke Nordin
|
1045898d40
|
Diffent fact syntax
|
2023-04-24 15:13:10 +02:00 |
|
Micke Nordin
|
4af4a23d1b
|
Use new facts in template
|
2023-04-24 15:06:51 +02:00 |
|
Micke Nordin
|
c5e5279f0e
|
Add reference to self
|
2023-04-24 12:10:30 +02:00 |
|
Micke Nordin
|
165415b725
|
Less dangerous pruning script
|
2023-04-24 10:47:36 +02:00 |
|
Micke Nordin
|
f2f919a59c
|
Lower further
|
2023-04-05 14:20:52 +02:00 |
|
Micke Nordin
|
801c5a2e85
|
Lower interned string value
|
2023-04-05 14:13:00 +02:00 |
|
Micke Nordin
|
4948ada609
|
Use facter
|
2023-04-05 12:26:11 +02:00 |
|
Micke Nordin
|
e220a1b1c6
|
Fix htaccess complaint
|
2023-04-05 08:55:41 +02:00 |
|
Micke Nordin
|
bf5e5adf10
|
Apache would not start with 128mb
|
2023-04-05 08:27:53 +02:00 |
|
Micke Nordin
|
0b267c07c5
|
Fix warning about interned strings on some nodes
|
2023-04-05 08:08:31 +02:00 |
|
Micke Nordin
|
e3dbe10187
|
Sort config and add entries to disable spurious warnings
|
2023-04-04 14:29:20 +02:00 |
|
Micke Nordin
|
d93cce4fc0
|
Handle mau
|
2023-04-03 14:11:28 +02:00 |
|
Micke Nordin
|
6dfe1496a4
|
Purge binlogs regularly
|
2023-03-24 16:26:56 +01:00 |
|
Micke Nordin
|
8386df91de
|
Fix for multinode
|
2023-03-24 14:36:07 +01:00 |
|
Micke Nordin
|
6de5312e7c
|
Support editable config
|
2023-03-24 13:24:23 +01:00 |
|
Micke Nordin
|
af020c77aa
|
New image
|
2023-03-24 11:47:55 +01:00 |
|
Micke Nordin
|
cdfd3b9126
|
Clear scriptherder script
|
2023-03-22 08:28:28 +01:00 |
|
Micke Nordin
|
4be1448dab
|
Remove swap
|
2023-03-22 08:01:18 +01:00 |
|
Micke Nordin
|
38807e62a5
|
Try to configure all customer
|
2023-03-21 18:26:23 +01:00 |
|