[Bacula-users] make_catalog_backup authentication error

Hi @all,

make_catalog_backup works fine if i start it manually as bacula User. But with a Backup Schedule I always get the follow Error Msg:

FATAL: password authentication failed for user "bacula"

/etc/postgresql/8.4/main/pg_hba.conf:

local   bacula bacula         127.0.0.1/32   trust

/var/lib/bacula/.pgpass:
127.0.0.1:5432:bacula:bacula:PASSWORD
localhost:5432:bacula:bacula:PASSWORD

make_catalog_backup:

BINDIR=/usr/bin

cd /var/lib/bacula
rm -f $1.sql
if test xsqlite = xpostgresql ; then
echo ".dump" | ${BINDIR}/sqlite $1.db >$1.sql
else
if test xmysql = xpostgresql ; then
    if test $# -gt 2; then
      MYSQLPASSWORD=" --password=$3"
    else
      MYSQLPASSWORD=""
    fi
    if test $# -gt 3; then
      MYSQLHOST=" --host=$4"
    else
      MYSQLHOST=""
    fi
    ${BINDIR}/mysqldump -u ${2}${MYSQLPASSWORD}${MYSQLHOST} -f --opt $1 >$1.sql
else
    if test xpostgresql = xpostgresql ; then
      if test $# -gt 2; then
        PGPASSWORD=$1
        export PGPASSWORD
      fi
      if test $# -gt 3; then
        PGHOST=" --host=$4"
      else
        PGHOST=""
      fi
      # you could also add --compress for compression. See man pg_dump
      #exec ${BINDIR}/pg_dump -c $PGHOST -U $2 $1 >$1.sql
      exec ${BINDIR}/pg_dump -h localhost bacula |bzip2 -9 -f -c > bacula.sql.bz2
    else
      echo ".dump" | ${BINDIR}/sqlite3 $1.db >$1.sql
    fi
fi
fi

Thanks and regards

Tobias

------------------------------------------------------------------------------
What Every C/C++ and Fortran developer Should Know!
Read this article and learn how Intel has extended the reach of its 
next-generation tools to help Windows* and Linux* C/C++ and Fortran 
developers boost performance applications - including clusters. 
http://p.sf.net/sfu/intel-dev2devmay

_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users