Once more, again blacklisted...
this gets interesting ;-)
And once more because I sent this to the wrong list...
resend, because my mail provider managed to get one of his mailers onto
a blacklist...
Hello,
you wrote a very nice mail - only I think many list-readers will not
bother to read that long text ;-)
On 2/28/2006 11:39 PM, Christopher Mills wrote:
I searched the archive for an answer to this question. I found it asked
but never answered:
The bconsole command 'list jobs' gives me a list of runs from all jobs.
I want to narrow it to all job runs from a particular job. The bconsole
doc under "list" seems to imply that would be done with:
list job=My-Job
This doesn't work (I am running mysql under Gentoo Linux).
The same here. Either the manual is wrong or this is a bug, I say.
I tried ...
Alas, my suspicion is this query just doesn't function.
By now, I suspect the same.
Since I believe
that this is a very fundemental query, and since out of the corner of my
eye while searching the archives for an answer I seem to have noticed
questions about formulating sql queries against the Bacula database
tables, I have a broader question in regard to what I should expect in
diving into Bacula:
Should I expect that the Bacula development community is focusing on the
more critical areas of this highly complex and powerful opensource
project?
That's what it looks like, and even though I understand the question
behind what you wrote :-) I don't think this should remain unfixed.
Should I bite the bullet, and bone up on my sql skills on the
assumption that these relatively benign (but from a practical
perspective of a Bacula implimentation, important) queries may not be
fully debugged and tested as of yet? Should I assume that I will "become
one" with the product more quickly if I just accept this, and learn to
write my own queries as needed?
Well, if you want to get more fluent in SQL this could be just the right
project :-)
I am really hoping the answer is "no." But I can understand if it is
"yes," as I certainly haven't been the one contributing to this
monumental project :) (Although, if it is "yes" I will confess to being
a little disappointed as I was hoping query writing would only come up
in future fine-tuning of my implimentation).
I'd even say that in many cases you don't need to write any SQL at all.
If this is the case, then I am just wondering where I should start. I
haven't really tried to delve into the source although I have taken a
peek at "query.sql." What is not clear to me is where all the queries
forming the 'list' commands are hiding. Do I need to get my hands on
some source to get started on examples of useful queries? Should the
task be to simply tack new queries onto query.sql as I need them?
Yes and no.
The SQL behind the commands like list is indeed hiding in the source
code. You can, however, achieve what you want by using queries in
query.sql, which I'd recommend.
Parameter passing is done in a dialog there, but it's obviously much
easier to try out queries - no need to recompile, install and restart
the binaries, only saving the file and issueing the query command from
bconsole.
Or am I getting paranoid, all documented queries work great, and I am
just being clueless, having missed the obvious (which wouldn't be the
first time)? :)
Not this time, I'm afraid...
Thanks in advance for any help and advice.
-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live
webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
--
IT-Service Lehmann [EMAIL PROTECTED]
Arno Lehmann http://www.its-lehmann.de
--
IT-Service Lehmann [EMAIL PROTECTED]
Arno Lehmann http://www.its-lehmann.de
-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
_______________________________________________
Bacula-devel mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/bacula-devel
--
IT-Service Lehmann [EMAIL PROTECTED]
Arno Lehmann http://www.its-lehmann.de
--
IT-Service Lehmann [EMAIL PROTECTED]
Arno Lehmann http://www.its-lehmann.de
-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
