what happens:
bin/otrs.SetPassword.pl root@localhost boe
ERROR: OTRS-otrs.SetPassword.pl-48 Perl: 5.10.1 OS: linux Time: Wed Oct 22 03:13:54 2014
Message: No Valid for valid found!
Traceback (15628):
Module: Kernel::System::Valid::ValidLookup (OTRS 3.3.9) Line: 166
Module: Kernel::System::Valid::ValidIDsGet (OTRS 3.3.9) Line: 187
Module: Kernel::System::User::UserSearch (OTRS 3.3.9) Line: 632
Module: bin/otrs.SetPassword.pl (unknown version) Line: 82
DBD::Oracle::db prepare failed: ORA-00936: missing expression (DBD ERROR: error possibly near <*> indicator at char 128 in 'SELECT id , login, first_name, last_name FROM users WHERE LOWER(login) LIKE LOWER('root@localhost') ESCAPE '\'AND valid_id IN (<*>)') [for Statement "SELECT id , login, first_name, last_name FROM users WHERE LOWER(login) LIKE LOWER('root@localhost') ESCAPE '\'AND valid_id IN ()"] at /opt/otrs/Kernel/System/DB.pm line 630.
ERROR: OTRS-otrs.SetPassword.pl-48 Perl: 5.10.1 OS: linux Time: Wed Oct 22 03:13:54 2014
Message: ORA-00936: missing expression (DBD ERROR: error possibly near <*> indicator at char 128 in 'SELECT id , login, first_name, last_name FROM users WHERE LOWER(login) LIKE LOWER('root@localhost') ESCAPE '\'AND valid_id IN (<*>)'), SQL: 'SELECT id , login, first_name, last_name FROM users WHERE LOWER(login) LIKE LOWER('root@localhost') ESCAPE '\'AND valid_id IN ()'
Traceback (15628):
Module: Kernel::System::User::UserSearch (OTRS 3.3.9) Line: 637
Module: bin/otrs.SetPassword.pl (unknown version) Line: 82
No user found with login 'root@localhost'!
This looks very much like the problem that occurs during login, the value for Valid has not yet been set. I think this is a nasty bug.
How can I work around this, or is a fix already present?
BTW: in this case the database is Oracle but I think this is a more common error. I also saw this in MSSQL (In the German part)
thanks,
Ronald.
v-3.3.9 SetPassword fails, as do connects
Moderator: crythias
-
- Znuny newbie
- Posts: 8
- Joined: 21 Oct 2014, 16:21
- Znuny Version: 3.3.12
- Real Name: Ronald
- Company: Ciber
- Contact:
Re: v-3.3.9 SetPassword fails, as do connects
I finally got this working. did a fresh clone from github
git clone https://github.com/OTRS/otrs
adjusted Kernel/Modules/Installer.pm and Kernel/config.pm for the database connection (in my case Oracle)
added an export LD_LIBRARY_PATH to /etc/init.d/httpd and /etc/init.d/otrs
manually executed the stepd listed in scripts/rhel6-otrs.spec
removed the objects from the otrs schema in the database
ran the web installer et voila, I was able to connect.
I think the steps in the rhel6-otrs.spec are important.
I am happy now.

git clone https://github.com/OTRS/otrs
adjusted Kernel/Modules/Installer.pm and Kernel/config.pm for the database connection (in my case Oracle)
added an export LD_LIBRARY_PATH to /etc/init.d/httpd and /etc/init.d/otrs
manually executed the stepd listed in scripts/rhel6-otrs.spec
removed the objects from the otrs schema in the database
ran the web installer et voila, I was able to connect.
I think the steps in the rhel6-otrs.spec are important.
I am happy now.
