Re: [Bacula-users] Mysql / status client discrepancy

2018-06-02 Thread Steffen Schwebel
sadface Thanks for your time On 06/02/2018 01:43 PM, Kern Sibbald wrote: > It is impossible. > > On 06/01/2018 01:43 PM, Steffen Schwebel wrote: >> Hello, >> >> thanks. >> >> Do you know any way to query the database to get the same output as >> bconsole "status client"? >> >> regards, >>

Re: [Bacula-users] Mysql / status client discrepancy

2018-06-02 Thread Kern Sibbald
It is impossible. On 06/01/2018 01:43 PM, Steffen Schwebel wrote: Hello, thanks. Do you know any way to query the database to get the same output as bconsole "status client"? regards, Steffen On 06/01/2018 11:26 AM, Kern Sibbald wrote: Hello, status client and select clients from the

Re: [Bacula-users] Mysql / status client discrepancy

2018-06-01 Thread Steffen Schwebel
Hello, thanks. Do you know any way to query the database to get the same output as bconsole "status client"? regards, Steffen On 06/01/2018 11:26 AM, Kern Sibbald wrote: > Hello, > > status client and select clients from the catalog are two totally > different commands.  Their outputs are

Re: [Bacula-users] Mysql / status client discrepancy

2018-06-01 Thread Kern Sibbald
Hello, status client and select clients from the catalog are two totally different commands.  Their outputs are different and the way they work are totaldifferent.  So trying to compare them is not useful. status client shows you clients to which the Director can connect at that moment as

Re: [Bacula-users] Mysql / status client discrepancy

2018-05-29 Thread Steffen Schwebel
On 05/29/2018 01:29 PM, Tilman Schmidt wrote: > Okay, so your question is really: why are some (the majority) of the removed > machines not detected as "orphaned" by dbcheck? Yes :) Why are there differences between bconsole and the database and what to do about it > I'll have to pass that one on

Re: [Bacula-users] Mysql / status client discrepancy

2018-05-29 Thread Martin Simmons
Yes, that is correct (it keeps a client if Client.ClientId = Job.ClientId for some job). __Martin > On Tue, 29 May 2018 13:29:07 +0200, Tilman Schmidt said: > > Okay, so your question is really: why are some (the majority) of the removed > machines not detected as "orphaned" by dbcheck? >

Re: [Bacula-users] Mysql / status client discrepancy

2018-05-29 Thread Tilman Schmidt
Okay, so your question is really: why are some (the majority) of the removed machines not detected as "orphaned" by dbcheck? I'll have to pass that one on as I don't know about the inner workings of dbcheck's orphaned clients check. Perhaps it is not considering clients as orphaned as long as

Re: [Bacula-users] Mysql / status client discrepancy

2018-05-29 Thread Steffen Schwebel
Thanks for your response. But Im not sure what to tell you. The Mysql Table bacula.Client has ~100 more entires than the output from bconsole. These are mostly machines the got removed from the bacula COnfiguration but linger on in the database. I assume thats why the helper script dbcheck

Re: [Bacula-users] Mysql / status client discrepancy

2018-05-28 Thread Tilman Schmidt
You may want to have a look at the raw result of the two commands mysql bacula -e "select * from Client" -ss echo "status client" | bconsole After saving both to files and massaging them a bit with sed or a similar tool, you should be able to feed them to diff and find out where the difference

[Bacula-users] Mysql / status client discrepancy

2018-05-28 Thread Steffen Schwebel
Hello, Ive been working with Bacula and see a discrepany I cant explain: mysql bacula -e "select * from Client" -ss | wc -l 336 echo "status client" | bconsole | wc -l 241 I tried to use the dbcheck to correct this mismatch. But that is showing me 16 orhpaned clients. It should close to a