The resource is Monthly Pool, with no quotes :-)
Pool {
Name = "Monthly Pool"
Pool Type = Backup
Recycle = no
AutoPrune = yes
Volume Retention = 1 years
}
On Dec 5, 2007 11:16 AM, Dan Langille <[EMAIL PROTECTED]> wrote:
> On Wed, 5 Dec 2007, Arno Lehmann wrote:
>
> > Hi,
> >
> > 05.12.2007 17:59,, jay wrote::
> >> This was for Bacula 2.2.5 running on RHEL4 with MySQL 4.1.
> >
> > Fairly recent...
> >
> >> I do happen
> >> to have a pool named "Monthly Pool".
> >
> > You meant, the pool is named with the quotes? I don't think Bacula
> > supports that :-)
> >
> >> You are correct, there is a
> >> quoting error. If I adjust the quotes, I can get the query to work.
> Do
> >> I need to rename my pool?
> >
> > That might be one solution... it would be better, though, to ensure
> > all characters that have a meaning in SQL (especially qoutes and ;)
> > are correctly escaped in all cases, though. Don't ask me how much work
> > that would be - I remember a discussion where Dan said he was working
> > on PostrgeSQL-related quoting, and it turned out to be bigger task
> > than I expected...
>
> This may be a bug. Keep looking. Show us your config file where you
> declare the pool in question. Be sure to obscure any passwords before
> giving us the file. Actually, just the Pool resource should be enough,
> not the whole file.
>
> --
> Dan Langille - http://www.langille.org/
> BSDCan - The Technical BSD Conference: http://www.bsdcan.org/
>
>
> -------------------------------------------------------------------------
> SF.Net email is sponsored by: The Future of Linux Business White Paper
> from Novell. From the desktop to the data center, Linux is going
> mainstream. Let it simplify your IT future.
> http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4
> _______________________________________________
> Bacula-users mailing list
> Bacula-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/bacula-users
>
-------------------------------------------------------------------------
SF.Net email is sponsored by: The Future of Linux Business White Paper
from Novell. From the desktop to the data center, Linux is going
mainstream. Let it simplify your IT future.
http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
