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
