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?