juanluisbaptiste / docker-otrs

The unofficial Znuny/OTRS Ticketing System docker image
https://www.juanbaptiste.tech/category/otrs
GNU Lesser General Public License v3.0
175 stars 105 forks source link

Table 'otrs.process_id' doesn't exist #78

Closed pavelsr closed 4 years ago

pavelsr commented 4 years ago

If I just make cp .env.example .env then run docker-compose up from original repo I got

DBD::mysql::st execute failed: Table 'otrs.process_id' doesn't exist

OTRS starts normally only when I uncomment and set OTRS_INSTALL=yes

But in case when I set OTRS_INSTALL=yes I have 404 Not found at http://localhost/otrs/install.pl and see login screen http://localhost/otrs/index.pl (hover I can not login using root@localhost and OTRS_ROOT_PASSWORD

Full log message:

[Wed Dec  4 00:17:34 2019] otrs.Console.pl: DBD::mysql::st execute failed: Table 'otrs.process_id' doesn't exist at /opt/otrs/Kernel/System/DB.pm line 694.
otrs_1     | ERROR: OTRS-otrs.Console.pl-Maint::Config::Rebuild-10 Perl: 5.16.3 OS: linux Time: Tue Dec 3 21:17:34 2019
otrs_1     | 
otrs_1     |  Message: Table 'otrs.process_id' doesn't exist, SQL: '
otrs_1     |             SELECT process_name, process_id, process_host, process_create, process_change
otrs_1     |             FROM process_id
otrs_1     |             WHERE process_name = ? LIMIT 1'
otrs_1     | 
otrs_1     |  Traceback (74): 
otrs_1     |    Module: Kernel::System::PID::PIDGet Line: 156
otrs_1     |    Module: Kernel::System::Console::Command::Maint::Config::Rebuild::PreRun Line: 72
otrs_1     |    Module: (eval) Line: 446
otrs_1     |    Module: Kernel::System::Console::BaseCommand::Execute Line: 446
otrs_1     |    Module: Kernel::System::Console::InterfaceConsole::Run Line: 80
otrs_1     |    Module: /opt/otrs/bin/otrs.Console.pl Line: 36
juanluisbaptiste commented 4 years ago

Something must have gone wrong on the initial database seed, please check your volumes permissions and that they are correct on the docker-compose.yml file.

juanluisbaptiste commented 4 years ago

Is the issue still going on ?