From: Carlos Perez [mailto:carlos.r.perez AT gmail DOT com]
 # cat /usr/lib64/bacula/query.sql

#

# This file contains sample queries that you can possibly use in

# your query.sql file.  However, please note that these examples

# are not supported. They may or may not work -- in fact, they may

# work with one SQL engine and not another.  As a consequence,

# please do not submit bug reports on either query.sql or 

# sample-query.sql

#

# If you find that they work for MySQL and not for PostgreSQL,

#  then please send us a whole new file corrected for PostgreSQL

#  and we will post it in the examples directory for everyone

#  to use.

#

My query.sql is almost empty, so didn’t know you would have to paste all that. Sorry.

The green must mean executable, and the black a text file. Mine show permissions like this:

rwxr-xr-x 2 root root  4096 Jan 16 02:36 .

drwxr-xr-x 3 root root  4096 Feb 15 15:36 ..

-rwxr-x--- 1 root root  1614 Jan 16 02:36 bacula

-rwxr-x--- 1 root root  2716 Jan 16 02:36 bacula_config

-rwxr-x--- 1 root root  5180 Jan 16 02:36 bacula-ctl-dir

-rwxr-x--- 1 root root  5197 Jan 16 02:36 bacula-ctl-fd

-rwxr-x--- 1 root root  5137 Jan 16 02:36 bacula-ctl-sd

-rwxr-x--- 1 root root   470 Jan 16 02:36 bconsole

-rw-r--r-- 1 root root  1073 Jan 16 02:36 btraceback.dbx

-rw-r--r-- 1 root root   341 Jan 16 02:36 btraceback.gdb

-rw-r--r-- 1 root root   343 Jan 16 02:36 btraceback.mdb

-rwxr-x--- 1 root root   736 Jan 16 02:36 create_bacula_database

-rwxr-x--- 1 root root   291 Jan 16 02:36 create_mysql_database