OTRS 3.1.10 for Linux RHEL x MSSQL

[Cristiano]

Hello

I'm trying to integrate OTRS 3.1.10 on Linux RedHat 6.3 with MSSQL.

I created the database, the test otrs.CheckDB.pl is ok, but when I try to authenticate the user root@localhost error happens "Panic, user authenticated but no user data can be found in OTRS DB!! Perhaps the user is invalid." Suggestions?


[root@test cristiano]# /opt/otrs/bin/otrs.CheckDB.pl
Trying to connect to database
DSN: DBI:ODBC:driver=MSSQL;Server=10.0.0.1;database=otrs;uid=otrs;pwd=test
DatabaseUser: otrs

It looks Ok!



[root@test cristiano]# tail -f /var/log/messages
Sep 12 14:01:30 test OTRS-CGI-10[1616]: [Notice][Kernel::System::Auth::DB::Auth] User: root@localhost authentication ok (REMOTE_ADDR: 10.0.0.1).
Sep 12 14:01:30 test OTRS-CGI-10[1616]: [Error][Kernel::System::User::UserLookup][Line:797]: No UserID found for 'root@localhost'!
Sep 12 14:01:30 test OTRS-CGI-10[1616]: [Error][Kernel::System::User::UserLookup][Line:797]: No UserID found for 'root@localhost'!
Sep 12 14:01:30 test OTRS-CGI-10[1616]: [Notice][Kernel::System::User::GetUserData] Panic! No UserData for user: 'root@localhost'!!!



/opt/otrs/Kernel/Config.pm

# ---------------------------------------------------- #
# database settings #
# ---------------------------------------------------- #
# DatabaseHost
# (The database host.)
$Self->{DatabaseHost} = '10.0.0.1';
# Database
# (The database name.)
$Self->{Database} = 'otrs';
# DatabaseUser
# (The database user.)
$Self->{DatabaseUser} = 'otrs';
# DatabasePw
# (The password of database user. You also can use bin/otrs.CryptPassword.pl
# for crypted passwords.)
$Self->{DatabasePw} = 'test';
# DatabaseDSN
# (The database DSN for MySQL ==> more: "man DBD::mysql")
#$Self->{DatabaseDSN} = "DBI:mysql:database=$Self->{Database};host=$Self->{DatabaseHost};";
$Self->{'DatabaseDSN'} = "DBI:ODBC:driver=MSSQL;Server=$Self->{DatabaseHost};database=$Self->{Database};uid=$Self->{DatabaseUser};pwd=$Self->{DatabasePw}";
$Self->{'Database::Type'} = 'mssql';

[crythias]

It means what it says. There is no userID returned for "root@localhost" in the configured tables.

[tomtom123]

I have the same problem here.

There is an existing Database where we are already use OTRS so there are already a lot of Agents and Customers created.
We use MSSQL Server and now, OTRS is installed on a Windows OS -> I want to change just the Webfrontend to a Debian OS
and the Database itself should stay on the MSSQL Server.

As you can see, I also get a connection to the Database ....

root@Debiantest:/opt/otrs/Kernel/Config# /opt/otrs/bin/otrs.CheckDB.pl
Trying to connect to database
DSN: DBI:ODBC:OTRS
DatabaseUser: otrs

It looks Ok!


.... but if I try to login with my user I get the following Error Message in my otrs logfile (for the existing "Windows OTRS" the user is working fine)

[Thu Oct 4 16:23:15 2012][Notice][Kernel::System::Auth::DB::Auth] User: testuser authentication ok (REMOTE_ADDR: 192.168.123.80).
[Thu Oct 4 16:23:15 2012][Error][Kernel::System::User::UserLookup][797] No UserID found for 'testuser''!
[Thu Oct 4 16:23:15 2012][Error][Kernel::System::User::UserLookup][797] No UserID found for 'testuser'!
[Thu Oct 4 16:23:15 2012][Notice][Kernel::System::User::GetUserData] Panic! No UserData for user: 'testuser'!!!

For this user there is an ID in the Database (SELECT id FROM users WHERE valid_id IN ( 1 ) AND login = 'testuser') returns the ID 22

I think I just need to configure the users Table anywhere... but I don´t know where.
Or is there any other thing I forgot to configure? Maybe I need some mappings?

Sorry guys for my bad english
Thanks
Best Regards

Thomas

[AndySZA]

I have the same problem here.

<snip>
For this user there is an ID in the Database (SELECT id FROM users WHERE valid_id IN ( 1 ) AND login = 'testuser') returns the ID 22

I think I just need to configure the users Table anywhere... but I don´t know where.
Or is there any other thing I forgot to configure? Maybe I need some mappings?

<snip>
Thomas

Hi Thomas.
I saw from my investigations on how to set up a MS-SQL server that the configurations settings were:
(ref: http://faq.otrs.org/otrs/public.pl?Acti ... ItemID=121)

c) Configure OTRS
o) Kernel/Config.pm
[...]
# MSSQL database settings
$Self->{DatabaseDSN} = "DBI:ODBC:driver={SQL Server};Server=localhost,1433;database=otrs;uid=otrs;pwd=password;";
$Self->{"Database::Type"} = 'mssql';
$Self->{DatabaseUserTable} = 'system_user2';
[...]

Although I did not need this on my windows installation to MSSQL, you might need to specify the User table with a value of "users" or "dbo.users" using the directive $Self->{DatabaseUserTable}

Regards,
Andy.

[brown]

What could be doing this every 15 minutes? ... it's either something in your cron or it's a persistent user on your network.