[Bacula-users] bconsole "freezes" when running things like list n

2016-01-18 Thread yeomanmonkeyboy
Think I might have this fixed now. There was a rogue TMD file owned by root 
which was preventing repair table from working. I moved that sideways and then 
it went through fine and the errors are gone. Will find out tomorrow morning if 
the backup works. 

Pretty sure I caused that TMD file to be owned by root by running myisamchk as 
root previously.

+--
|This was sent by neilerobe...@gmail.com via Backup Central.
|Forward SPAM to ab...@backupcentral.com.
+--



--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=267308311=/4140
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] bconsole "freezes" when running things like list n

2016-01-18 Thread yeomanmonkeyboy
It appears that the File table may be corrupted. I get the following results 
from various checks. It should be noted that all other tables respond fine with 
these checks. 

mysql> repair table File;
+-++--++
| Table   | Op | Msg_type | Msg_text
   |
+-++--++
| bacula.File | repair | error| Can't create new tempfile: 
'./bacula/File.TMD' |
| bacula.File | repair | status   | Operation failed
   |
+-++--++
2 rows in set (0.00 sec)

skippy:/vol/mysql/bacula# myisamchk File --check
Checking MyISAM file: File
Data records: 46514953   Deleted blocks:   0
myisamchk: warning: Table is marked as crashed and last repair failed
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
- check data record references index: 2
- check data record references index: 3
- check record links
MyISAM-table 'File' is usable but should be fixed


If I try to run isamchk -r -q on this I get a seg fault

+--
|This was sent by neilerobe...@gmail.com via Backup Central.
|Forward SPAM to ab...@backupcentral.com.
+--



--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=267308311=/4140
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] bconsole "freezes" when running things like list n

2016-01-18 Thread yeomanmonkeyboy
Ok. I think I am starting to get somewhere now. The backup on Friday did not 
run and the mysqld process is sitting at 100% cpu. If I run the mysqladmin 
processlist as suggested I get the following. 

This forum won't let me post the whole thing. It thinks I am trying to submit a 
sql injection but this is what it is saying. 

9106  | bacula | localhost | bacula | Query   | 125193 | Waiting for table 
level lock
9107  | bacula | localhost | bacula | Query   | 211592 | executing

The line that is executing is doing a select path.path filename.name 
t1.filindex t1.jobid lstat deltaseq from elect fileid

+--
|This was sent by neilerobe...@gmail.com via Backup Central.
|Forward SPAM to ab...@backupcentral.com.
+--



--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=267308311=/4140
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Help cmd in a restricted console

2016-01-18 Thread Peter Keller
Hello!

On 12/29/2015 03:12 AM, Kern Sibbald wrote:
> The only current possibility is to not permit the help command. Making the 
> help
> command recognized which commands are permitted would be a significant project
> which is not currently on our task list.  However, it would be nice if someone
> would contribute it :-)

I have written the patch and would like to contribute it. I'll give a summary
of the output of the patch and then attach the patch itself. I have also sent
in the CAA document.

I noticed that bconsole takes a lot of its direction from the Director in a
pleasant manner. So, this patch is only in the Director sources and it is
against the 7.2.0 sources.

Here is an example of the regular 'help' command, printed out in full. The
! denotes a command which is NOT available to you in this particular
console, and notice that the help told you that you were in a restricted
console as well.

*help
  Command   Description
  ===   ===
! add   Add media to a pool
  autodisplay   Autodisplay console messages
! automount Automount after label
! cancelCancel a job
! createCreate DB Pool from resource
! deleteDelete volume, pool or job
! disable   Disable a job, attributes batch process
! enableEnable a job, attributes batch process
! estimate  Performs FileSet estimate, listing gives full listing
! exit  Terminate Bconsole session
! gui   Non-interactive gui mode
  help  Print help on specific command
! label Label a tape
  list  List objects from catalog
  llist Full or long list like list command
  messages  Display pending messages
! memoryPrint current memory usage
! mount Mount storage
! prune Prune expired records from catalog
! purge Purge records from catalog
  quit  Terminate Bconsole session
! query Query catalog
  restore   Restore files
! relabel   Relabel a tape
! release   Release storage
! reloadReload conf file
  run   Run a job
! restart   Restart a job
! resumeResume a job
  statusReport status
! stop  Stop a job
! setdebug  Sets debug level
! setbandwidth  Sets bandwidth
! snapshot  Handle snapshots
! setip Sets new client address -- if authorized
  show  Show resource records
! sqlquery  Use SQL to query catalog
! time  Print current time
! trace Turn on/off trace to file
! truncate  Truncate one or more Volumes
! unmount   Unmount storage
! umountUmount - for old-time Unix guys, see unmount
! updateUpdate volume, pool or stats
! use   Use catalog xxx
! var   Does variable expansion
! version   Print Director version
! wait  Wait until no jobs are running

This is a restricted console. Commands marked with ! are invalid.

When at a prompt, entering a period cancels the command.
*


If you ask for help on a specific item, you get this:

*help time
  Command   Description
  ===   ===
! time  Print current time

Arguments:


This is a restricted console. Commands marked with ! are invalid.

When at a prompt, entering a period cancels the command.
*


I also noticed there is a dot command set and I fixed that too. I understand
though that my changes here might be tweaked a little since it is a scripting
interface.

But, I'll demonstrate that this looks like too (but here I'll summarize
appropriately):

*.help all
!add
autodisplay
!automount
!cancel
!create
!delete
!disable
!enable
!estimate
!exit
!gui
help
!label
list
llist
messages
!memory
!mount
!prune
!purge
quit
!query
restore
!relabel
!release
!reload
run
!restart
!resume
status
!stop
!setdebug
!setbandwidth
!snapshot
!setip
show
!sqlquery
!time
!trace
!truncate
!unmount
!umount
!update
!use
!var
!version
!wait


* .help
[snip]
!reload Reload conf file --
run Run a job -- job= client=
fileset= level=
storage= where=
when= pool=
 nextpool= comment= accurate=
spooldata= yes
!restart Restart a job -- incomplete job= client=
fileset= level=
storage=when=
comment= spooldata= jobid=
[snip]

*.help item=reload

The command 'reload' is invalid in this restricted console.

*



So, I figure that it might be requested that I change the dot help command to
have the new feature only in the '.help all' case as opposed to changing
output in the other variants of .help.


Anyways, please let me know if I need to make changes The most important change
for me was the regular help command fixes with which humans interact but it is
pretty nice to have the scriptable interface realize it can't do something too.

I've attached the patch.

Thank you!

-pete


diff --git a/bacula/src/dird/ua_cmds.c b/bacula/src/dird/ua_cmds.c
index ab8d979..33e10e3 100644
--- a/bacula/src/dird/ua_cmds.c
+++ b/bacula/src/dird/ua_cmds.c
@@ -62,6 +62,7 @@ static int 

[Bacula-users] Bacula Release 7.4.0

2016-01-18 Thread Kern Sibbald
Hello,

Yesterday, we released Bacula version 7.4.0.

This version consists of more backports from Bacula Enterprise 8.4 as
well quite a few bug fixes (28) as a number of new features.  For your
convenience, I have included selected parts of the ReleaseNotes below.

Upgrading should be easy since there is no database change and all older
File Daemons should remain compatible with Bacula 7.4.0.

As with the last release, I would like to thank Bacula Systems for
providing the bug fixes and new features. Since the development process
in Bacula Systems is going faster (more programmers), we can expect even
more features in future versions.

In addition to releasing the files to Source Forge as usual, I have
added a new download area on the bacula,.org web site that will permit
you to download all the files for the new version 7.4.0.

Bacula Systems has agreed to permit the personal use of the Bacula
Enterprise Windows binaries, so I have included the Bacula Enteprise
Windows binaries on the bacula.org web site (see Downloads -> Download
Center on the main menu).  If you wish to use the Enterprise Windows
binaries for other than personal use, please download them from:
http://www.baculasystems.com/windows-binaries-for-bacula-community-users

Thank you for using Bacula,

Kern

=

Release Notes for Bacula 7.4.0

Release version 7.4.0

For the most part the changes were contributed to the Bacula project by
Bacula Systems SA.

This is a new release with a new version number. It has been very
thourouly tested, but as always, the new features may not always work as
expected.

The Catalog database format has not changed since version the prior
release (7.2.0).

Compatibility:
–
As always, both the Community Director and Storage daemon(s) must be
upgraded at the same time. Any File daemon unning on the same machine as
a Director or Storage daemon must be of the same version.

Older File Daemons should be compatible with the 7.4.0 Director and
Storage daemons. There should be no need to pgrade older File Daemons.

New features and changes:
Please see the New Features chapter of the manual for documentation on
the new features. The new features are currently only in the New
Features chapter and have not et been integrated into the main chapters
of the manual.

New Features and changes summary:
– Support for KFREEBSD OS
– Improved support for Clang
– Configure SSL connection to MySQL
– New chio-changer-freebase in examples/autochangers
– New directives in bacula-dir.conf in Catalog{} resource for the MySQL
backend (not currently implemented for Postgresql or QLite).
dbsslkey
dbsslcert
dbsslca
dbsslcapath
dbsslcipher
– examples/autochangers/rc-chio-changer removed
– examples/devices/DVD.conf removed
– updated copyrights
– Add “Expires in” to list and llist volumes
– Implement a more efficient Volume selection algorithm between DIR and SD
– Implement new list/llist command keywords:
order=asc|ascending
order=desc|decending
limit=nn
jobstatus=
Client=
JobErrors
– Implement new bconsole @tall command that outputs input and output to
console and terminal. Note, this also outputs bconsole input commands.
– Implement MaxVirtualFullInterval
– Implement VirtualFullPool override
– Pool overrides work better
– Automatic selection of catalog from client where possible.
– Implement VerifyData level type for Verify jobs.

Bugs fixed/closed since last release:
1131 1360 1362 1368 1382 1412 1414 1449 1470 1524 1545 1548 1882 2083
2090 2103 2115 2117 2151 2153 2156 2165 2180 2182 2183 2192 804 898



--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=267308311=/4140
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] [Bacula-devel] Bacula Release 7.4.0

2016-01-18 Thread John Drescher
On Mon, Jan 18, 2016 at 12:50 PM, Kern Sibbald  wrote:
> Hello,
>
> Yesterday, we released Bacula version 7.4.0.
>
> This version consists of more backports from Bacula Enterprise 8.4 as
> well quite a few bug fixes (28) as a number of new features.  For your
> convenience, I have included selected parts of the ReleaseNotes below.
>
> Upgrading should be easy since there is no database change and all older
> File Daemons should remain compatible with Bacula 7.4.0.
>
> As with the last release, I would like to thank Bacula Systems for
> providing the bug fixes and new features. Since the development process
> in Bacula Systems is going faster (more programmers), we can expect even
> more features in future versions.
>
> In addition to releasing the files to Source Forge as usual, I have
> added a new download area on the bacula,.org web site that will permit
> you to download all the files for the new version 7.4.0.
>
> Bacula Systems has agreed to permit the personal use of the Bacula
> Enterprise Windows binaries, so I have included the Bacula Enteprise
> Windows binaries on the bacula.org web site (see Downloads -> Download
> Center on the main menu).  If you wish to use the Enterprise Windows
> binaries for other than personal use, please download them from:
> http://www.baculasystems.com/windows-binaries-for-bacula-community-users
>

Thanks. I installed this on gentoo by bumping the portage ebuilds to
7.4.0. No problems installing although I have not run any jobs yet.

John

--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=267308311=/4140
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] bacula.us January Updates

2016-01-18 Thread Heitor Faria
Bacula Users, FYI: 

New Bacula 7.4 Commands Usage: http://bacula.us/new-bacula-7-4-commands/ 
Case - ESAMC Business School Bacula Community Deploy: 
http://bacula.us/case-esamc-business-school-bacula-community-deploy/ 
Windows Bacula 7.4 Client and Consoles Binaries: 
http://bacula.us/windows-bacula-client-and-consoles-binaries/ 
Easier Bacula Download: http://bacula.us/easy-bacula-download/ 
New Bacula 7.4 Release: http://bacula.us/new-bacula-7-4-release/ 
Windowss VSS Errors Troubleshooting: http://bacula.us/vss-troubleshooting/ 
13th On-line Live Bacula Class Ending: 
http://bacula.us/13th-on-line-live-class-ending/ 
Bacula dbcheck: http://bacula.us/bacula-dbcheck/ 

Regards, 
-- 
=== 
Heitor Medrado de Faria - LPIC-III | ITIL-F | Bacula Systems Certified 
Administrator II 
Do you need Bacula training? http://bacula.us/video-classes/ 
+55 61 8268-4220 
Site: http://bacula.us FB: heitor.faria 
=== 
--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=267308311=/4140___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Bacula Release 7.4.0

2016-01-18 Thread Dan Langille

> On Jan 18, 2016, at 12:50 PM, Kern Sibbald  wrote:


> 
> New features and changes:
> Please see the New Features chapter of the manual for documentation on
> the new features. The new features are currently only in the New
> Features chapter and have not et been integrated into the main chapters
> of the manual.

I'm packaging for FreeBSD now.  I do not see a docs tarball for 7.4

-- 
Dan Langille - BSDCan / PGCon
d...@langille.org


--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=267308311=/4140
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Bacula Release 7.4.0

2016-01-18 Thread compdoc
> Dan Langille - BSDCan / PGCon
>d...@langille.org
> I'm packaging for FreeBSD now.  


I like to install from scratch on Ubuntu Server and try to use the correct
paths, users, permissions, and anything related, etc. by researching the
web. I think I'm getting the hang of it. 

But I've also installed from the Ubuntu repos, which was version 5.2.6 last
I checked. Can anyone create and submit a package, or is it done through
official channels?

I've never created a package, so I'm hoping it's not too difficult. :)




--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=267308311=/4140
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users