Hi forum,
I use an
JumpBox Version: 1.1.2
JumpBox Platform Version: 1.1-174
otrs Version: 2.3.1
I tried to connect to our CRM MSSQL database and did the following changes in the config.pm:
$Self->{CustomerUser} = {
Name => 'Database Backend',
Module => 'Kernel::System::CustomerUser::DB',
Params => {
DSN => 'DBI:mssql:database=[..]mscrm;host=[..];uid=[..];pwd=[..];',
Table => 'contact',
},
CustomerKey => 'login',
CustomerID => 'customer_id',
CustomerValid => 'valid_id',
CustomerUserListFields => [ 'first_name', 'last_name', 'email' ],
[....]
ReadOnly => 1,
[....]
When I connect to the otrs I get the following error:
install_driver(mssql) failed: Can't locate DBD/mssql.pm in @INC (@INC contains: ../../ /var/data/otrs/Kernel/cpan-lib /var/data/otrs /etc/perl /usr/local/lib/perl/5.8.8 /usr/local/share/perl/5.8.8 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.8 /usr/share/perl/5.8 /usr/local/lib/site_perl . /etc/apache2 /usr/sbin/../.. /usr/sbin/../../Kernel/cpan-lib) at (eval 4417) line 3.
Perhaps the DBD::mssql perl module hasn't been fully installed,
or perhaps the capitalisation of 'mssql' isn't right.
Available drivers: DBM, ExampleP, File, Gofer, Proxy, Sponge, mysql.
at /var/data/otrs/Kernel/System/DB.pm line 216
Is the installation of the DBIx::SQLEngine::Driver::Sybase::MSSQL-module via CPAN the right way to fix this problem or is an other module or way reccomended?
Best regards,
Kai Berninger
Is MSSQL backend possible?
Have you seen someone say that what you are trying to accomplish is possible? Looking specifically at OTRS related resources would probably be helpful. It may not be a trivial task. There may be specific instructions for accomplishing this on the OTRS website. I would dig around there, and once you have a good idea of how it can be accomplished you can come back here and ask some JumpBox specific questions, like how to resolve a specific dependency or something.
Austin
MSSQL customer backend
We try to minimize the download sizes of JumpBoxes so we avoid shipping anything that isn't useful to a large subset of users. Fortunately, as you have mentioned, users with specific needs can generally resolve dependencies on their own if they are cautious and understand the limitations.
In many cases software dependencies, including perl modules can be handled with the native Ubuntu packages. In cases where that is not possible, you can use CPAN. One crucial thing to be aware of though, is any customization you make on the command line will not be backed up*. Only application data is backed up.
See our FAQ on apt-get for details on finding and installing Ubuntu packages.
Austin
* We introduced a basic mechanism for users to specify additional files and directories to be backed up. See the README.txt that came with your JumpBox for details.
Thanks Austin, for your
Thanks Austin, for your reply.
Perhaps you can tell me if it is the right way? Is the config.pm correct?
Params => {
DSN => 'DBI:mssql:database=[..]mscrm;host=[..];uid=[..];pwd=[..];', [.....]
do you know which module I have to install via cpan?
Kai