Sakaio Manoa wrote:
I tried running the make_mysql_tables however I got this
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)
Creation of Bacula MySQL tables failed.
I have created the database bacula using phpMyAdmin and I can see the
bacula database but creating the tables.
I think the problem here is running the script as I don't have the
permissions. I can log into mysql but it just won't let me run the
scripts to create the tables.
As requested:
Here is my make_mysql_table script
#!/bin/sh
#
# shell script to create Bacula MySQL tables
#
bindir=/usr/bin
if $bindir/mysql $* -f <<END-OF-DATA
USE bacula;
CREATE TABLE Filename (
FilenameId INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
Name BLOB NOT NULL,
PRIMARY KEY(FilenameId),
INDEX (Name(255))
);
CREATE TABLE Path (
PathId INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
Path BLOB NOT NULL,
PRIMARY KEY(PathId),
INDEX (Path(255))
);
Cheers
Sakaio P Manoa
THis is a step forward. Now it comes down to a MySQL user/permission
problem.
I believe that Bacula will generally be accessing it's database as the
user 'bacula', so you will need to grant sufficient permissions to that
user to the database. Something like this (you will need to login to
MySQL as the user you used to create the database):
grant all on bacula.* to [EMAIL PROTECTED] identified by 'password';
Replace 'password' with the password you wish to use - it should be a
quoted string. Also this assumes that MySQL and Bacula are running on
the same server - if not then replace [EMAIL PROTECTED] with
[EMAIL PROTECTED] (where servername is the name or IP address of the
machine running Bacula).
Then you can run the make_mysql_tables script and pass it the
appropriate parameters:
./make_mysql_tables -u bacula -p
This will prompt you for the password (safest).
Or, if you are absolutely sure no-one else will be watching the
processes on your system, you can pass the password on the command line:
./make_mysql_tables -u bacula -ppassword
Note that there is no space between -p and password - this is a MySQL
convention.
Nearly there :)
Rowdy
-------------------------------------------------------
SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
from IBM. Find simple to follow Roadmaps, straightforward articles,
informative Webcasts and more! Get everything you need to get up to
speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
