> Hi Heitor,
> > Hey Tim: it seems that the make_mysql_tables scripts isn't creating the
> > Version table for some reason. I would suggest you to download Bacula
> > 5.2.13
> > code and run the database creation scripts from there.
>
> > Ps.: I really like your posts at US Govmnt list.
>
> > Regards,
>
> Thanks for your input. However, the tables are there in the database. I can
> do the select that the error is complaining about, with no isse!
> The error from the log is saying:
> 27-Mar 00:14 bacula-dir JobId 0: Fatal error: Query failed: SELECT VersionId
> FROM Version: ERR=no such table: Version
> And yet, I can connect to the database, and do the select:
> mysql> use bacula
> Reading table information for completion of table and column names
> You can turn off this feature to get a quicker startup with -A
> Database changed
> mysql> SELECT VersionId FROM Version;
> +-----------+
> | VersionId |
> +-----------+
> | 14 |
> +-----------+
> 1 row in set (0.00 sec)
> Here's a list of the tables:
> mysql> show tables;
> +------------------+
> | Tables_in_bacula |
> +------------------+
> | BaseFiles |
> | CDImages |
> | Client |
> | Counters |
> | Device |
> | File |
> | FileSet |
> | Filename |
> | Job |
> | JobHisto |
> | JobMedia |
> | Location |
> | LocationLog |
> | Log |
> | Media |
> | MediaType |
> | Path |
> | PathHierarchy |
> | PathVisibility |
> | Pool |
> | RestoreObject |
> | Status |
> | Storage |
> | UnsavedFiles |
> | Version |
> +------------------+
> 25 rows in set (0.00 sec)
> It also seems that most of the tables are empty at this stage. However I can
> do a select on this table as well:
> mysql> select * from Status;
> +-----------+---------------------------------+----------+
> | JobStatus | JobStatusLong | Severity |
> +-----------+---------------------------------+----------+
> | A | Canceled by user | 90 |
> | B | Blocked | 15 |
> | C | Created, not yet running | 15 |
> | D | Verify found differences | 15 |
> | E | Terminated with errors | 25 |
> | F | Waiting for Client | 15 |
> | M | Waiting for media mount | 15 |
> | R | Running | 15 |
> | S | Waiting for Storage daemon | 15 |
> | T | Completed successfully | 10 |
> | a | SD despooling attributes | 15 |
> | c | Waiting for client resource | 15 |
> | d | Waiting on maximum jobs | 15 |
> | e | Non-fatal error | 20 |
> | f | Fatal error | 100 |
> | i | Doing batch insert file records | 15 |
> | j | Waiting for job resource | 15 |
> | m | Waiting for new media | 15 |
> | p | Waiting on higher priority jobs | 15 |
> | s | Waiting for storage resource | 15 |
> | t | Waiting on start time | 15 |
> +-----------+---------------------------------+----------+
> 21 rows in set (0.00 sec)
> Any other thoughts?
I can see in your dir.conf that you are using an "admin" user to connect to
your database.
Did you try the bacula user? This is the one created by the grant_x_privileges
script.
Regards,
============================================================
Heitor Medrado de Faria - LPIC-III | ITIL-F
Need Bacula training?
https://www.udemy.com/bacula-backup-software/?couponCode=bacula-users
+55 61 8268-4220
Site: www.bacula.com.br | Facebook: heitor.faria | Gtalk: heitorfa...@gmail.com
============================================================
------------------------------------------------------------------------------
Dive into the World of Parallel Programming The Go Parallel Website, sponsored
by Intel and developed in partnership with Slashdot Media, is your hub for all
things parallel software development, from weekly thought leadership blogs to
news, videos, case studies, tutorials and more. Take a look and join the
conversation now. http://goparallel.sourceforge.net/
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
