Install and configure MySQL / PostgreSQL for Bacula 7

Install and configure MySQL / PostgreSQL for Bacula 7

    
Step 1:

A : -   MySQL Installation

         # yum install mariadb-server
OR

B : -  Postgresql Installation

# yum install  postgresql-devel


Step 2:

Set MySQL Lib to use Bacula

# alternatives --config libbaccats.so

There are 3 programs which provide 'libbaccats.so'.

Selection Command
-----------------------------------------------
1 /usr/lib64/libbaccats-mysql.so
2 /usr/lib64/libbaccats-sqlite3.so
*+ 3 /usr/lib64/libbaccats-postgresql.so

Enter to keep the current selection[+], or type selection number:

Type 1 and hit the enter for select mysql



Step 3:

Create Bacula Database

Note: Script file may be “/usr/libexec/bacula” OR “/etc/bacula/script” OR “/etc/bacula”

For Mysql :
       
# /usr/libexec/bacula/create_mysql_database -u root -p
OR

For postgresql :    

# /usr/libexec/bacula/create_bacula_database -u root -p


Step 4:

Create Tables

For Mysql :   
   
# /usr/libexec/bacula/make_mysql_tables -u root -p
OR

For Postgresql :       

# /usr/libexec/bacula/make_bacula_tables -u root -p


Step 5:
Grant Privileges:

This Command Create a MySQL user “ bacula “ with “No Password”

for MySQL :       

# /usr/libexec/bacula/grant_mysql_privileges -u root -p
OR

For Postgresql:
       
# /usr/libexec/bacula/grant_bacula_privileges -u root -p


Database configuration Finish

Previous
Next Post »