OpenForum RSS: bacula+mysql+apache

bacula+mysql+apache (linkat)

Wed, 23 Jun 2010 09:43:36 GMT

>�� Version.
>�� , ��
>

�� !
��!

bacula+mysql+apache (Michael)

Wed, 23 Jun 2010 09:28:16 GMT

>
>>��, �� /usr/share/bacula/scripts/query.sql ��
>
>�� , �� . ��, �� .
>

�� Version.
�� , ��

bacula+mysql+apache (linkat)

Wed, 23 Jun 2010 09:25:33 GMT

>��, �� /usr/share/bacula/scripts/query.sql ��

�� , �� . ��, �� .

# 1
:List up to 20 places where a File is saved regardless of the directory
*Enter Filename (no path):
SELECT DISTINCT Job.JobId as JobId, Client.Name as Client,
Path.Path,Filename.Name,StartTime,Level,JobFiles,JobBytes
FROM Client,Job,File,Filename,Path WHERE Client.ClientId=Job.ClientId
AND JobStatus='T' AND Job.JobId=File.JobId
AND Path.PathId=File.PathId AND Filename.FilenameId=File.FilenameId
AND Filename.Name='%1'
ORDER BY Job.StartTime LIMIT 20;
# 2
:List where the most recent copies of a file are saved
*Enter path with trailing slash:
*Enter filename:
*Enter Client name:
SELECT DISTINCT Job.JobId,StartTime AS JobStartTime,VolumeName,Client.Name AS ClientName
FROM Job,File,Path,Filename,Media,JobMedia,Client
WHERE File.JobId=Job.JobId
AND Path.Path='%1'
AND Filename.Name='%2'
AND Client.Name='%3'
AND Path.PathId=File.Pat

bacula+mysql+apache (Michael)

Wed, 23 Jun 2010 08:22:19 GMT

4
>| wbVersion |

� �� wbVersion

>� �� ? (�� )
>Query failed: SELECT VersionId FROM Version: ERR=Table 'bacula.Version' doesn't exist

� bacula-dir �� Version.
>�� /usr/share/bacula/scripts/query.sql �� ? ��
>�� ?

��, �� /usr/share/bacula/scripts/query.sql ��

bacula+mysql+apache (linkat)

Wed, 23 Jun 2010 06:24:13 GMT

>��. ��

mysql> show tables from webacula;
+--------------------+
| Tables_in_webacula |
+--------------------+
| wbLogBook |
| wbLogType |
| wbVersion |
| wbtmptablelist |
+--------------------+
4 rows in set (0.00 sec)

mysql>
mysql>
mysql> show tables from bacula;
Empty set (0.00 sec)

mysql>

��????

� ��: �� http://localhost/webacula �� .
�� htpasswd2 -c /etc/apache2/webacula.users admin
� � �� :
[Wed Jun 23 09:26:26 2010] [error] [client 127.0.0.1] MySQL ERROR: Unknown database 'test'
[Wed Jun 23 09:26:26 2010] [error] [client 127.0.0.1] MySQL user admin not found: /webacula

� �� ? (�� )
Query failed: SELECT VersionId FROM Version: ERR=Table 'bacula.Version' doesn't exist
�� /usr/share/bacula/scripts/query.sql �� ? �� ?

bacula+mysql+apache (Michael)

Wed, 23 Jun 2010 05:49:08 GMT

>>�� : ��
>
>�� /etc/bacula/bacula-dir.conf �� ?

��. ��

bacula+mysql+apache (linkat)

Wed, 23 Jun 2010 03:57:23 GMT

>�� : ��

�� /etc/bacula/bacula-dir.conf �� ?

Director { # define myself
Name = dir
DIRport = 9101 # where we listen for UA connections
QueryFile = "/usr/share/bacula/scripts/query.sql"
WorkingDirectory = "/var/lib/bacula"
PidDirectory = "/var/run/bacula"
Maximum Concurrent Jobs = 1
@/etc/bacula/bacula-dir-password.conf
Messages = Daemon
}

# Generic catalog service
Catalog {
Name = MyCatalog
dbname = bacula
dbuser = bacula
dbpassword = "baculapass"
}

#
# Restricted console used by tray-monitor to get the status of the director
#
Console {
Name = localhost-mon
Password = "1"
CommandACL = status, .status
}

@/etc/bacula/job/defaultjob.conf
@/etc/bacula/job/bacula.conf
@/etc/bacula/job/backupcatalog.conf
@/etc/bacula/job/restore.conf

@/etc/bacula/fileset/fullset.conf
@/etc/bacula/fileset/catalog.conf

@/etc/bacula/schedule/weeklycycle.conf
@/etc/bacul

bacula+mysql+apache (Michael)

Tue, 22 Jun 2010 13:06:06 GMT

>[root@comp install]# ./webacula_mysql_create_database.sh -u root -p
>Enter password:
>Creation of webacula database succeeded.
>[root@comp install]# ./webacula_mysql_make_tables.sh -u root -p
>Enter password:
>Creation of webacula MySQL tables succeeded.

��, ��
>[root@comp init.d]# ./bacula-dir start -u root -p
>Starting bacula-dir service: bacula-dir: dird.c:944 Could not open Catalog "MyCatalog", database "webacula".
>
>bacula-dir: dird.c:949 Query failed: SELECT VersionId FROM Version: ERR=Table 'webacula.Version' doesn't exist
>

�� , ��
>22-Jun 16:56 bacula-dir ERROR TERMINATION
>Please correct configuration file: /etc/bacula/bacula-dir.conf

�� : ��

bacula+mysql+apache (linkat)

Tue, 22 Jun 2010 12:29:27 GMT

[root@comp install]# ./webacula_mysql_create_database.sh -u root -p
Enter password:
Creation of webacula database succeeded.
[root@comp install]# ./webacula_mysql_make_tables.sh -u root -p
Enter password:
Creation of webacula MySQL tables succeeded.
[root@comp init.d]# ./bacula-dir start -u root -p
Starting bacula-dir service: bacula-dir: dird.c:944 Could not open Catalog "MyCatalog", database "webacula".
bacula-dir: dird.c:949 Query failed: SELECT VersionId FROM Version: ERR=Table 'webacula.Version' doesn't exist
22-Jun 16:56 bacula-dir ERROR TERMINATION
Please correct configuration file: /etc/bacula/bacula-dir.conf
[FAILED]
[root@comp init.d]#

�� ! ��!