Hi Stefan,
For a simple connection with MS-SQL from Linux you could use DBD::Sybase.
Here's a sample configuration for a Customer Database on Windows / MS-SQL :
# CustomerUser
# (customer user database backend and settings)
$Self->{CustomerUser} = {
Name => 'Customer DB',
Module => 'Kernel::System::CustomerUser::DB',
Params => {
DSN => 'DBI:Sybase:server=192.168.60.1',
User => 'database_user',
Password => 'password',
Table => 'customer_user',
},
# customer unique id
CustomerKey => 'login',
# customer #
CustomerID => 'customer_id',
CustomerValid => 'valid_id',
CustomerUserListFields => ['first_name', 'last_name', 'email'],
CustomerUserSearchFields => ['login', 'last_name', 'customer_id'],
CustomerUserSearchPrefix => '',
CustomerUserSearchSuffix => '*',
CustomerUserSearchListLimit => 250,
CustomerUserPostMasterSearchFields => ['email'],
CustomerUserNameFields => ['salutation','first_name','last_name'],
CustomerUserEmailUniqCheck => 1,
Map => [
# note: Login, Email and CustomerID needed!
# var, frontend, storage, shown (1=always,2=lite), required,
storage-type, http-link, readonly
[ 'UserSalutation', 'Salutation', 'salutation', 1, 0, 'var',
'', 0 ],
[ 'UserFirstname', 'Firstname', 'first_name', 1, 1, 'var',
'', 0 ],
[ 'UserLastname', 'Lastname', 'last_name', 1, 1, 'var',
'', 0 ],
[ 'UserLogin', 'Username', 'login', 1, 1, 'var',
'', 0 ],
[ 'UserPassword', 'Password', 'pw', 0, 1, 'var',
'', 0 ],
[ 'UserEmail', 'Email', 'email', 0, 1, 'var',
'', 0 ],
[ 'UserCustomerID', 'CustomerID', 'customer_id', 0, 1, 'var',
'', 0 ],
[ 'UserComment', 'Comment', 'comments', 1, 0, 'var',
'', 0 ],
[ 'ValidID', 'Valid', 'valid_id', 0, 1, 'int',
'', 0 ],
],
# default selections
Selections => {
UserSalutation => {
'Mr.' => 'Mr.',
'Mrs.' => 'Mrs.',
},
},
};
Just install the package libdbd-sybase-perl and you're good to go!
Kind regards,
--
Michiel Beijen
Software Consultant
+31 6 - 457 42 418
Bee Free IT + http://beefreeit.nl
On Thu, Jul 9, 2009 at 09:53, Stefan-Michael Guenther <[email protected]>wrote:
> Hi Afshar,
>
> >We are using OTRS in MS Windows platform with MS SQL database and have
> >not any problem till now. What's your problem with MS SQL?
>
> just to make sure that we are talking about the same configuration:
>
> The OTRS is currently running on a debian server. Did you install OTRS on
> the windows machine, too?
>
> Stefan
>
>
>> Hello,
>>
>> are there any members on this mailing list who store the OTRS agents in a
>> MS SQL database?
>>
>> We have used different OTRS installations on Debian, SuSE, Redhat
>> and Ubuntu but always get the same login error message which obviously has
>> something to do with the DBD::ODBC module.
>>
>> It would be helpful if we could get the version numbers MS
>> SQL, DBD::ODBC and OTRS of such a successful installation.
>>
>> Thanks in advance,
>>
>> Stefan-Michael G?nther
>>
>
> ---------------------------------------------------------------------
> OTRS mailing list: otrs - Webpage: http://otrs.org/
> Archive: http://lists.otrs.org/pipermail/otrs
> To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
>
> NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW!
> http://www.otrs.com/en/support/enterprise-subscription/
>
---------------------------------------------------------------------
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW!
http://www.otrs.com/en/support/enterprise-subscription/
