OTRS 5 + Oracle driver issue

[piotreksmoq]

Hi,

I try install OTRS with oracle database and i have a really big issue.

Code: Select all

failed: Can't locate object method "driver" via package "DBD::Oracle" at /usr/lib64/perl5/vendor_perl/DBI.pm line 820.

Perhaps the capitalisation of DBD 'Oracle' isn't right. at /opt/otrs//Kernel/Modules/Installer.pm line 1180.

In this machine i have oracle client and newest version of otrs.

[root]

Do you also installed the Perl DBD module for Oracle? What does bin/otrs.CheckModules.pl returns?

[piotreksmoq]

Yes, this module was installed.

Code: Select all

  
  o DBD::mysql.......................Not installed! Use: 'yum install "perl(DBD::mysql)"' (optional - Required to connect to a MySQL database.)
  o DBD::ODBC........................Not installed! (optional - Required to connect to a MS-SQL database.)
  o DBD::Oracle......................ok (undef)
  o DBD::Pg..........................Not installed! Use: 'yum install "perl(DBD::Pg)"' (optional - Required to connect to a PostgreSQL database.)

I olso reinstall dbd::Oracle and status is still undef.

Code: Select all

pm-uninstall DBD::Oracle
pm-install DBD::Oracle

I also tried connect to oracle DB using some perl script and is working, so problem with connection is in otrs, not in perl modules.

[root]

Please show me the database config from Kernel/Config.pm

[piotreksmoq]

I didnt save any configuration.
I tried install otrs using web installer.

After reinstall everything i have another error message:

Code: Select all

Can't connect to database, read comment!
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor (DBD ERROR: OCIServerAttach)

[root]

Looks like a configuration problem. Does bin/otrs.Console.pl Maint::Database::Check work? Or is the shown error from running this?

[piotreksmoq]

Code: Select all

Trying to connect to database 'DBI:mysql:database=otrs;host=127.0.0.1;' with user 'otrs'...
Error: install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC (@INC contains: /srv/otrs/Custom /srv/otrs/Kernel/cpan-lib /srv/otrs /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5 .) at (eval 17) line 3.
Perhaps the DBD::mysql perl module hasn't been fully installed,
or perhaps the capitalisation of 'mysql' isn't right.
Available drivers: DBM, ExampleP, File, Gofer, Oracle, Proxy, SQLite, Sponge, oracle.
 at /srv/otrs/Kernel/System/DB.pm line 190.

But, like i said before - i tried use web installer. In DB configuration step i have this error. So installer was not changed config file.

Code: Select all

Can't connect to database, read comment!
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor (DBD ERROR: OCIServerAttach)

[wurzel]

Hi,

first of all you should be able to connect to your database with your OracleClient. Once you have a successful connection there, you can think to configure OTRS.


For me it seems that you do not have this Oracle Client connection.

regards
Florian

[root]

[quote="piotreksmoq"]

Code: Select all

Trying to connect to database 'DBI:mysql:database=otrs;host=127.0.0.1;' with user 'otrs'...
Error: install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC (@INC contains: /srv/otrs/Custom /srv/otrs/Kernel/cpan-lib /srv/otrs /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5 .) at (eval 17) line 3.
Perhaps the DBD::mysql perl module hasn't been fully installed,
or perhaps the capitalisation of 'mysql' isn't right.
Available drivers: DBM, ExampleP, File, Gofer, Oracle, Proxy, SQLite, Sponge, oracle.
 at /srv/otrs/Kernel/System/DB.pm line 190.

When I read this error message it can only recommend to configure an Oracle database connections. OTRS is complaining about missing the MySQL driver. Check your SysConfig.