blob: 6a2ca85d2807a60c4c85cd40f8d144cd2a6d06fa (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
|
#!/usr/bin/env bash
# Script for basic diagnostics of a Taler regio deployment.
if [ "$(id -u)" -ne 0 ]; then
echo "FATAL: Please run as root." >&2
exit 1
fi
libeufin_bank_db=$(libeufin-bank config get libeufin-bankdb-postgres config)
libeufin_nexus_db=$(libeufin-nexus config get libeufin-nexusdb-postgres config)
if [[ $libeufin_nexus_db != $libeufin_bank_db]]; then
echo "FATAL: libeufin-bank and libeufin-nexus don't share the same database" >&2
exit 1
fi
libeufin_db=$libeufin_bank_db
read -r -d '' sql_check_trigger << EOF
select count(*) from information_schema.triggers
where trigger_schema='libeufin_nexus'
and trigger_name='cashin_link';
EOF
have_conversion_triggers=$(sudo -u postgres psql "$libeufin_db" -t --csv -c "$sql_check_trigger")
echo "have_conversion_triggers" $have_conversion_triggers
|