v-3.3.9 SetPassword fails, as do connects

Moderator: crythias

Locked
ikzelf
Znuny newbie
Posts: 8
Joined: 21 Oct 2014, 16:21
Znuny Version: 3.3.12
Real Name: Ronald
Company: Ciber
Contact:

v-3.3.9 SetPassword fails, as do connects

Post by ikzelf »

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.
ikzelf
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

Post by ikzelf »

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.
:D
Locked