trunk/doc/Search.pod

=head1 BackupPC search and archival extension

BackupPC search and archival extension is used to:

=over 4

=item *

find files in C<pool> by substring of filename

=item *

see state of one or all of your shares in some particular point in time
(file creation date on clients or backup date is supported as filter)

=item *

archive selected backups (per host, share and increment) to archival
medium (CD, DVD, tape etc.) with rich descriptions, archival locations,
multiple copies and so on.

=back

=head2 Requirements

This extension is based on PostgreSQL RDBMS and Hyper Estraier full-text
search engine (and it's perl bindings).

If you are using Debian, you are in luck. All required packages are
allready part of C<unstable> distribution and can be installed with:

  # apt-get install postgresql
  # apt-get install hyperestraier libestraier-dev libqdbm-dev

Now you can skip to installation of L<Hyper Estraier perl bindings> below.

If you don't have pre-packaged binaries for your installation, you will
need to install additional packages by hand.

=head3 PostgreSQL

You can use packages provided by your distribution or follow installation
instructions on PostgreSQL site.

=head3 QDBM

First, you need qdbm on which Hyper Estraier depends. Installation is simple.

  $ tar xvfz qdbm-1.8.31.tar.gz 
  $ cd qdbm-1.8.31
  $ ./configure --enable-zlib
  $ make
  $ sudo make install

=head3 Hyper Estraier

Also quite simple.

  $ tar xvfz hyperestraier-0.5.4.tar.gz
  $ cd hyperestraier-0.5.4
  $ ./configure
  $ make
  $ sudo make install

Then you will have to install perl bindings for Hyper Estraier.

=head3 Hyper Estraier perl bindings

Just use C<cpan> shell to install C<Search::Estraier> module

  $ sudo cpan Search::Estraier

There was awaful long procedure about installing perl C bindings, but it's all gone now.

=head3 CPAN modules

You will also need a few additional cpan modules

=over 4

=item File::Pid
=item File::Which
=item File::Path
=item File::Slurp
=item Search::Estraier

=item Spreadsheet::WriteExcel

=item Term::Menus
=item XML::Writer
=item Algorithm::Diff
=item Archive::Tar::Stream
=item Filesys::Df

=back

Last module, C<Spreadsheet::WriteExcel> is needed only if you want to use
C<BackupPC_xls_report> to generate Excel reports from your backup data.

Easiest way to install them is using C<cpan> shell.

  $ sudo cpan File::Pid Spreadsheet::WriteExcel ...

=head1 Creation of initial database

Once you have all components installed, you should initially create data
about increments in RDBMS and full-text search engine index.

First, edit C<config.pl> and setup C<SearchDSN> to valid perl DSN (for example,
C<dbi:Pg:dbname=backuppc> and C<SearchUser> to database user which has priviledges
over that database. You might need to add additional directives in PostgreSQL's
C<pg_hba.conf> so that selected user can be connected without password (I know, it's not
perfect, but I trust local users on backuppc machine).

Then, create new database for backuppc.

  $ createdb backuppc

Then invoke C<BackupPC_updatedb> for the first time with argument to create database
schema:

  $ sudo -u backuppc /data/backuppc/bin/BackupPC_updatedb -c

You can also force full-text reindex by C<-i> flag. This will add all files which are in
database but for some reason are missing in full-text index.

Now, you can setup cron job which will daily check your backups and update database
and full-text index. This is as simple as invoking

  /data/backuppc/bin/BackupPC_updatedb

As C<backuppc> user and redirecting output to log file.

B<Documentation is still incomplete>.

Now that you finished installation, you can select new options from
menu on the left and example search and archival.

=head1 Reporting in Excel

Often, it is useful to be able to present report about your BackupPC hosts, number
of snapshots, total size and other useful info. While all those information can
be accessed using web browser, for analysis it's useful to have them in spreadsheet
form. With this data, you can monitor changes on your backup cycle, effects of changes
on your server or network to your BackupPC installation and so on.

You can create Excel spreadsheet (which works perfectly with Gnumeric also) using
following command:

  $ sudo -u backuppc /data/backuppc/bin/BackupPC_xls_report

=head1 Additional requirements

You will also need several other command-line utilities to make
C<BackupPC_burnArchiveCLI> run. Those include:

=over 4

=item mkisofs

=item cdrecord

Or equivavalent utility, on Debian you might want to use C<dvdrecord>.

=item eject

Please make a symlink from C</dev/cdrom> to you CD/DVD burner.

=item split

=back

=head1 Troubleshoting

=head2 md5sum problems on Debian

If you are running Debian stable and expiriencing error message like

 -: No such file or directory

your C<md5sum> comes from C<coreutils> (which doesn't know how to handle C<->
as input) as opposed to C<md5sum> which comes with C<textutils> (which does).

Fix is simple, correct md5sum is allready installed, you just have to do:

 sudo cp /usr/bin/md5sum.textutils /usr/bin/md5sum

=head1 Related projects

BackupPC allready has archival host which might suit your needs better (and
it's quite easier to install).

=over 4

=item PostgreSQL

L<http://www.postgresql.org/>

=item HyperEstraier

L<http://hyperestraier.sourceforge.net/>

=back

=head1 Authors

Ivan Klaric C<< <iklaric@gmail.com> >>

Dobrica Pavlinusic C<< <dpavlin@rot13.org> >>

=head1 Licence

This extension is released under GPL licence, same as BackupPC.

1	dpavlin	94	=head1 BackupPC search and archival extension
2
3			BackupPC search and archival extension is used to:
4
5			=over 4
6
7			=item *
8
9			find files in C<pool> by substring of filename
10
11			=item *
12
13			see state of one or all of your shares in some particular point in time
14			(file creation date on clients or backup date is supported as filter)
15
16			=item *
17
18			archive selected backups (per host, share and increment) to archival
19	dpavlin	105	medium (CD, DVD, tape etc.) with rich descriptions, archival locations,
20			multiple copies and so on.
21	dpavlin	94
22			=back
23
24			=head2 Requirements
25
26	dpavlin	303	This extension is based on PostgreSQL RDBMS and Hyper Estraier full-text
27	dpavlin	94	search engine (and it's perl bindings).
28
29	dpavlin	96	If you are using Debian, you are in luck. All required packages are
30			allready part of C<unstable> distribution and can be installed with:
31	dpavlin	94
32	dpavlin	96	# apt-get install postgresql
33			# apt-get install hyperestraier libestraier-dev libqdbm-dev
34
35	dpavlin	303	Now you can skip to installation of L<Hyper Estraier perl bindings> below.
36	dpavlin	96
37			If you don't have pre-packaged binaries for your installation, you will
38			need to install additional packages by hand.
39
40	dpavlin	105	=head3 PostgreSQL
41	dpavlin	94
42			You can use packages provided by your distribution or follow installation
43			instructions on PostgreSQL site.
44
45	dpavlin	105	=head3 QDBM
46	dpavlin	94
47	dpavlin	303	First, you need qdbm on which Hyper Estraier depends. Installation is simple.
48	dpavlin	94
49			$ tar xvfz qdbm-1.8.31.tar.gz
50			$ cd qdbm-1.8.31
51			$ ./configure --enable-zlib
52			$ make
53			$ sudo make install
54
55	dpavlin	303	=head3 Hyper Estraier
56	dpavlin	94
57			Also quite simple.
58
59			$ tar xvfz hyperestraier-0.5.4.tar.gz
60			$ cd hyperestraier-0.5.4
61			$ ./configure
62			$ make
63			$ sudo make install
64
65	dpavlin	303	Then you will have to install perl bindings for Hyper Estraier.
66	dpavlin	94
67	dpavlin	303	=head3 Hyper Estraier perl bindings
68	dpavlin	105
69	dpavlin	303	Just use C<cpan> shell to install C<Search::Estraier> module
70	dpavlin	105
71	dpavlin	303	$ sudo cpan Search::Estraier
72	dpavlin	94
73	dpavlin	303	There was awaful long procedure about installing perl C bindings, but it's all gone now.
74	dpavlin	94
75	dpavlin	105	=head3 CPAN modules
76
77			You will also need a few additional cpan modules
78
79			=over 4
80
81			=item File::Pid
82	dpavlin	235	=item File::Which
83			=item File::Path
84			=item File::Slurp
85	dpavlin	303	=item Search::Estraier
86	dpavlin	105
87	dpavlin	108	=item Spreadsheet::WriteExcel
88
89	dpavlin	177	=item Term::Menus
90	dpavlin	198	=item XML::Writer
91	dpavlin	217	=item Algorithm::Diff
92			=item Archive::Tar::Stream
93	dpavlin	338	=item Filesys::Df
94	dpavlin	177
95	dpavlin	94	=back
96
97	dpavlin	108	Last module, C<Spreadsheet::WriteExcel> is needed only if you want to use
98			C<BackupPC_xls_report> to generate Excel reports from your backup data.
99
100	dpavlin	105	Easiest way to install them is using C<cpan> shell.
101	dpavlin	94
102	dpavlin	303	$ sudo cpan File::Pid Spreadsheet::WriteExcel ...
103	dpavlin	105
104			=head1 Creation of initial database
105
106	dpavlin	94	Once you have all components installed, you should initially create data
107			about increments in RDBMS and full-text search engine index.
108
109	dpavlin	105	First, edit C<config.pl> and setup C<SearchDSN> to valid perl DSN (for example,
110			C<dbi:Pg:dbname=backuppc> and C<SearchUser> to database user which has priviledges
111			over that database. You might need to add additional directives in PostgreSQL's
112			C<pg_hba.conf> so that selected user can be connected without password (I know, it's not
113			perfect, but I trust local users on backuppc machine).
114	dpavlin	94
115	dpavlin	105	Then, create new database for backuppc.
116	dpavlin	94
117	dpavlin	105	$ createdb backuppc
118	dpavlin	94
119	dpavlin	105	Then invoke C<BackupPC_updatedb> for the first time with argument to create database
120			schema:
121
122			$ sudo -u backuppc /data/backuppc/bin/BackupPC_updatedb -c
123
124			You can also force full-text reindex by C<-i> flag. This will add all files which are in
125			database but for some reason are missing in full-text index.
126
127			Now, you can setup cron job which will daily check your backups and update database
128			and full-text index. This is as simple as invoking
129
130			/data/backuppc/bin/BackupPC_updatedb
131
132			As C<backuppc> user and redirecting output to log file.
133
134			B<Documentation is still incomplete>.
135
136	dpavlin	94	Now that you finished installation, you can select new options from
137			menu on the left and example search and archival.
138
139	dpavlin	108	=head1 Reporting in Excel
140
141			Often, it is useful to be able to present report about your BackupPC hosts, number
142			of snapshots, total size and other useful info. While all those information can
143			be accessed using web browser, for analysis it's useful to have them in spreadsheet
144			form. With this data, you can monitor changes on your backup cycle, effects of changes
145			on your server or network to your BackupPC installation and so on.
146
147			You can create Excel spreadsheet (which works perfectly with Gnumeric also) using
148			following command:
149
150			$ sudo -u backuppc /data/backuppc/bin/BackupPC_xls_report
151
152	dpavlin	177	=head1 Additional requirements
153
154			You will also need several other command-line utilities to make
155			C<BackupPC_burnArchiveCLI> run. Those include:
156
157			=over 4
158
159			=item mkisofs
160
161	dpavlin	199	=item cdrecord
162
163			Or equivavalent utility, on Debian you might want to use C<dvdrecord>.
164
165			=item eject
166
167	dpavlin	204	Please make a symlink from C</dev/cdrom> to you CD/DVD burner.
168
169	dpavlin	199	=item split
170
171	dpavlin	177	=back
172
173	dpavlin	255	=head1 Troubleshoting
174	dpavlin	177
175	dpavlin	255	=head2 md5sum problems on Debian
176
177			If you are running Debian stable and expiriencing error message like
178
179			-: No such file or directory
180
181			your C<md5sum> comes from C<coreutils> (which doesn't know how to handle C<->
182			as input) as opposed to C<md5sum> which comes with C<textutils> (which does).
183
184			Fix is simple, correct md5sum is allready installed, you just have to do:
185
186			sudo cp /usr/bin/md5sum.textutils /usr/bin/md5sum
187
188	dpavlin	94	=head1 Related projects
189
190			BackupPC allready has archival host which might suit your needs better (and
191			it's quite easier to install).
192
193			=over 4
194
195			=item PostgreSQL
196
197			L<http://www.postgresql.org/>
198
199			=item HyperEstraier
200
201			L<http://hyperestraier.sourceforge.net/>
202
203			=back
204
205			=head1 Authors
206
207			Ivan Klaric C<< <iklaric@gmail.com> >>
208
209			Dobrica Pavlinusic C<< <dpavlin@rot13.org> >>
210
211			=head1 Licence
212
213			This extension is released under GPL licence, same as BackupPC.
214