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?
Thanks,
Tim
On Fri, Mar 27, 2015 at 9:13 AM, Heitor Faria <hei...@bacula.com.br> wrote:
> So, just to be thorough, I dropped the database again and ran these
> commands again!
>
> [root@ops:/etc/bacula] #./create_mysql_database
> Creation of bacula database succeeded.
>
> [root@ops:/etc/bacula] #./make_mysql_tables
> Creation of Bacula MySQL tables succeeded.
>
> [root@ops:/etc/bacula] #./grant_mysql_privileges
> ....
> Privileges for user bacula granted on database bacula.
>
> And went to start the director again!
>
> [root@ops:~] #service bacula-dir start
> Starting bacula-dir: [ OK ]
>
> Checked to see if it was running:
>
> [root@ops:~] #service bacula-dir status
> bacula-dir dead but subsys locked
>
> Hmmm... NOPE!!
>
> And checked the log file:
>
> [root@ops:~] #tail /var/log/bacula/bacula.log
> 27-Mar 00:14 bacula-dir JobId 0: Fatal error: Query failed: SELECT
> VersionId FROM Version: ERR=no such table: Version
> 27-Mar 00:14 bacula-dir JobId 0: Fatal error: Could not open Catalog
> "JokefireCatalog", database "bacula".
> 27-Mar 00:14 bacula-dir JobId 0: Fatal error: Query failed: SELECT
> VersionId FROM Version: ERR=no such table: Version
> 27-Mar 00:14 bacula-dir ERROR TERMINATION
> Please correct configuration file: /etc/bacula/bacula-dir.conf
> You have new mail in /var/spool/mail/root
>
> 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,
> ============================================================
> Heitor Medrado de Faria - LPIC-III | ITIL-F
> Need Bacula training?
> https://www.udemy.com/bacula-backup-software/?couponCode=bacula-users
> +55 61 <%2B55%2061%202021-8260>8268-4220 <%2B55%2061%208268-4220>
> Site: www.bacula.com.br | Facebook: heitor.faria
> <http://www.facebook.com/heitor.faria> | Gtalk: heitorfa...@gmail.com
> ============================================================
>
>
>
--
GPG me!!
gpg --keyserver pool.sks-keyservers.net --recv-keys F186197B
------------------------------------------------------------------------------
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
