search

oliveiraped / Reportula

Reportula is a php based web program that provides you a summarized output stats of Bacula Backups jobs, clients, volumes and director that have already run. It obtains its information from your catalog database. This is a fairly high level bacula management tool. Here are a few points that one user made concerning this important tool. It is web-based so can be accessed from anywhere. It packs a phenomenal amount of information into a single web-page – that I credit as being very good design! Features Display last jobs status Display volumes usage by pool Full supported MySQL, PostgreSQL databases. Show Jobs which executed with errors last day, week, month Show a condition of your Volumes Show terminated Jobs Search Jobs on several conditions The detailed information on Pools, Volumes, Storages and Clients Search options List the files stored on job Acl Supports and Login users support Integration with Active Directory or Ldap servers
http://www.reportula.org
GNU General Public License v3.0
25 stars 9 forks source link

Getting the below error when running the BaculaStats:collect from the crontab manually #24

Open metalcated opened 9 years ago

metalcated commented 9 years ago

MySQL Server 5.5 It also doesn't matter if the database tables/columns are all lowecase, I have tried both ways and get the same results. But instead of "bacula.job' doesn't exist" it says "bacula.Job' doesn't exist"

[root@gnsyrbac01] /bacula/mounts$ php /var/www/html/reportula/artisan BaculaStats:collect -vvv [Illuminate\Database\QueryException] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'bacula.job' doesn't exist (SQL: select (max(starttime) - min(starttime)) AS timediff from job where starttime >= 2015-01-13 18:29 and endtime <= 2015-01-14 18:29)

Exception trace: () at /var/www/html/reportula/vendor/laravel/framework/src/Illuminate/Database/Connection.php:625 Illuminate\Database\Connection->runQueryCallback() at /var/www/html/reportula/vendor/laravel/framework/src/Illuminate/Database/Connection.php:581 Illuminate\Database\Connection->run() at /var/www/html/reportula/vendor/laravel/framework/src/Illuminate/Database/Connection.php:304 Illuminate\Database\Connection->select() at /var/www/html/reportula/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:1359 Illuminate\Database\Query\Builder->runSelect() at /var/www/html/reportula/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:1349 Illuminate\Database\Query\Builder->getFresh() at /var/www/html/reportula/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:1336 Illuminate\Database\Query\Builder->get() at /var/www/html/reportula/app/commands/BaculaStatsCommand.php:81 BaculaStatsCommand->fire() at /var/www/html/reportula/vendor/laravel/framework/src/Illuminate/Console/Command.php:112 Illuminate\Console\Command->execute() at /var/www/html/reportula/vendor/symfony/console/Symfony/Component/Console/Command/Command.php:252 Symfony\Component\Console\Command\Command->run() at /var/www/html/reportula/vendor/laravel/framework/src/Illuminate/Console/Command.php:100 Illuminate\Console\Command->run() at /var/www/html/reportula/vendor/symfony/console/Symfony/Component/Console/Application.php:889 Symfony\Component\Console\Application->doRunCommand() at /var/www/html/reportula/vendor/symfony/console/Symfony/Component/Console/Application.php:193 Symfony\Component\Console\Application->doRun() at /var/www/html/reportula/vendor/symfony/console/Symfony/Component/Console/Application.php:124 Symfony\Component\Console\Application->run() at /var/www/html/reportula/artisan:59

[PDOException]
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'bacula.job' doesn't exist

Exception trace: () at /var/www/html/reportula/vendor/laravel/framework/src/Illuminate/Database/Connection.php:299 PDO->prepare() at /var/www/html/reportula/vendor/laravel/framework/src/Illuminate/Database/Connection.php:299 Illuminate\Database\Connection->Illuminate\Database{closure}() at /var/www/html/reportula/vendor/laravel/framework/src/Illuminate/Database/Connection.php:617 Illuminate\Database\Connection->runQueryCallback() at /var/www/html/reportula/vendor/laravel/framework/src/Illuminate/Database/Connection.php:581 Illuminate\Database\Connection->run() at /var/www/html/reportula/vendor/laravel/framework/src/Illuminate/Database/Connection.php:304 Illuminate\Database\Connection->select() at /var/www/html/reportula/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:1359 Illuminate\Database\Query\Builder->runSelect() at /var/www/html/reportula/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:1349 Illuminate\Database\Query\Builder->getFresh() at /var/www/html/reportula/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:1336 Illuminate\Database\Query\Builder->get() at /var/www/html/reportula/app/commands/BaculaStatsCommand.php:81 BaculaStatsCommand->fire() at /var/www/html/reportula/vendor/laravel/framework/src/Illuminate/Console/Command.php:112 Illuminate\Console\Command->execute() at /var/www/html/reportula/vendor/symfony/console/Symfony/Component/Console/Command/Command.php:252 Symfony\Component\Console\Command\Command->run() at /var/www/html/reportula/vendor/laravel/framework/src/Illuminate/Console/Command.php:100 Illuminate\Console\Command->run() at /var/www/html/reportula/vendor/symfony/console/Symfony/Component/Console/Application.php:889 Symfony\Component\Console\Application->doRunCommand() at /var/www/html/reportula/vendor/symfony/console/Symfony/Component/Console/Application.php:193 Symfony\Component\Console\Application->doRun() at /var/www/html/reportula/vendor/symfony/console/Symfony/Component/Console/Application.php:124 Symfony\Component\Console\Application->run() at /var/www/html/reportula/artisan:59

BaculaStats:collect