OTRS，SetPassword，未找到用户

Question

我安装了OTRS6，正在尝试登录。在Debian中，我想使用otrs.Console.pl在OTRS中创建新的用户和密码。在创建用户之后，我想使用Admin:: user ::SetPassword帐户密码来设置密码，但是我得到了这个错误：

    ERROR: OTRS-otrs.Console.pl-Admin::User::SetPassword-10 Perl: 5.24.1 OS: linux Time: Sun Mar  4 16:41:12 2018

 Message: No Valid for valid found!

 Traceback (11786):
   Module: Kernel::System::Valid::ValidLookup Line: 139
   Module: Kernel::System::Valid::ValidIDsGet Line: 160
   Module: Kernel::System::User::UserSearch Line: 728
   Module: Kernel::System::Console::Command::Admin::User::SetPassword::Run Line: 47
   Module: (eval) Line: 460
   Module: Kernel::System::Console::BaseCommand::Execute Line: 454
   Module: Kernel::System::Console::InterfaceConsole::Run Line: 80
   Module: /opt/otrs/bin/otrs.Console.pl Line: 38

[Sun Mar  4 16:41:12 2018] otrs.Console.pl: DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 2 at /opt/otrs/Kernel/System/DB.pm line 694.
ERROR: OTRS-otrs.Console.pl-Admin::User::SetPassword-10 Perl: 5.24.1 OS: linux Time: Sun Mar  4 16:41:12 2018

 Message: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 2, SQL: 'SELECT id, login
                   FROM users WHERE  (login) LIKE ? AND valid_id IN ()'

 Traceback (11786):
   Module: Kernel::System::User::UserSearch Line: 737
   Module: Kernel::System::Console::Command::Admin::User::SetPassword::Run Line: 47
   Module: (eval) Line: 460
   Module: Kernel::System::Console::BaseCommand::Execute Line: 454
   Module: Kernel::System::Console::InterfaceConsole::Run Line: 80
   Module: /opt/otrs/bin/otrs.Console.pl Line: 38

Error: No user found with login 'admin@localhost'!

..。在新创建的帐户上...

在MySQL数据库中，我看到所有用户，所以他们是存在的。帮帮忙？

Answer 1

在这种情况下，otrs数据库中valid表的内容是空的；这可能是因为您在安装过程中没有加载otrs-initial_insert.mysql.sql文件。通常这是由web安装程序执行的。

最好的建议可能是删除您的数据库并再次运行web安装程序。