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
SOPAC South Pacific Applied Geoscience Commission
Postal Address: Private Mail Bag, GPO, Suva, Fiji Islands
Street Address : Mead Road, Nabua, Fiji Islands
Tel: +679 338 1377, Fax: +679 337 0040
E-Mail: <mailto:[EMAIL PROTECTED]>: Web site: <http://www.sopac.org/>
Note that the gateway to our mail server limits the size of inwward and
outward messages with attachments to 1.5MB. I you need to send or receive
larger messages apply compression, convert to PDF files or logically split.
This e-mail is intended for its named recipients only. The author is no
longer responsible if you forward this e-mail to other parties. The views
expressed in this e-mail may not be the views of SOPAC.
-----Original Message-----
From: Rowdy [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 16, 2005 9:48 PM
To: Sakaio Manoa
Cc: 'bacula-users@lists.sourceforge.net'
Subject: Re: [Bacula-users] RE: Database creation
Sakaio Manoa wrote:
> As requested I got this
>
> Which mysql
> /usr/bin/mysql
> Echo $PATH
> /sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/bin:/usr/local/bin:/usr/local/sbin
>
> Cheers
>
> Sakaio P Manoa
Thank you.
So, mysql is on your path, however the make_mysql_tables script reports
an error about not being able to find it.
Possibly your make_mysql_tables script has become corrupt. Would it be
possible for you to post the first 10 lines or so here pls.
Mine looks like this:
orange# head -10 make_mysql_tables
#!/bin/sh
#
# shell script to create Bacula MySQL tables
#
bindir=/usr/local/bin
if $bindir/mysql $* -f <<END-OF-DATA
USE bacula;
CREATE TABLE Filename (
FilenameId INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
Btw I am running FreeBSD and my mysql binary is in /usr/local/bin.
Thanx
Rowdy
