Unable to log in after upgrade from 3 to 4

[dtoom]

Hello;

I successfully upgraded from OTRS 3 to 4 on the local machine, but I am now having issues upgrading on the remote server. I had quite a few issues, but the final issue is that I am unable to log in.

When I run:

bin/otrs.SetPassword.pl root@localhost newpassword

It get the following:

Code: Select all

ERROR: OTRS-otrs.SetPassword.pl-10 Perl: 5.10.1 OS: linux Time: Tue Dec 16 14:08:24 2014

 Message: No Valid for valid found!

 Traceback (18165): 
   Module: Kernel::System::Valid::ValidLookup Line: 146
   Module: Kernel::System::Valid::ValidIDsGet Line: 167
   Module: Kernel::System::User::UserSearch Line: 655
   Module: bin/otrs.SetPassword.pl Line: 71

[Tue Dec 16 14:08:24 2014] otrs.SetPassword.pl: DBD::Pg::st execute failed: ERROR:  syntax error at or near ")"
[Tue Dec 16 14:08:24 2014] otrs.SetPassword.pl: LINE 2: ...   FROM users WHERE  LOWER(login) LIKE $1 AND valid_id IN ()
[Tue Dec 16 14:08:24 2014] otrs.SetPassword.pl:                                                                       ^ at /opt/otrs/Kernel/System/DB.pm line 584.
ERROR: OTRS-otrs.SetPassword.pl-10 Perl: 5.10.1 OS: linux Time: Tue Dec 16 14:08:24 2014

 Message: ERROR:  syntax error at or near ")"
LINE 2: ...   FROM users WHERE  LOWER(login) LIKE $1 AND valid_id IN ()
                                                                      ^, SQL: 'SELECT id, login
                   FROM users WHERE  LOWER(login) LIKE ? AND valid_id IN ()'

 Traceback (18165): 
   Module: Kernel::System::User::UserSearch Line: 660
   Module: bin/otrs.SetPassword.pl Line: 71

No user found with login 'root@localhost'!

Is there any other way to get myself logged into the system?

[dtoom]

I should ad a little more information here.

For the database, I am using PostgreSQL.

I have other users, but no one is able to login. No one is able to reset their passwords because the reset emails aren't being sent.