[dev.icinga.com #1857] Icinga-Web: Fetch failed with message Couldn't locate driver named oci8 #478
Comments
Updated by jmosshammer on 2011-08-31 12:21:55 +00:00 Hello, First -> upgrade to 1.5.1, we fixed lot's of minor and major bugs there. What do your dsn look like? More information about the databases.xml can be found in our wiki under: |
Updated by nag_dkg on 2011-09-02 06:54:19 +00:00 Hello, now the description of my problems in English. Environment: Icinga and Icinga-Web: 1.5.01 PHP: 5.3.3 Description: Additional Information: [Fri Sep 2 08:40:45 2011] [fatal] Uncaught AppKitPHPError: PHP Error oci_new_connect(): ORA-12545: Connect failed because target host or object does not exist (/icinga/icinga-web/lib/doctrine/Doctrine.compiled.php:1) (/icinga/icinga-web/app/modules/AppKit/lib/logging/AppKitExceptionHandler.class.php:37) PHP – Configuration summary : php -i | grep -i oci /etc/php.d/oci8.ini, oci8 OCI8 Support => enabled oci8.connection_class => no value => no value oci8.default_prefetch => 100 => 100 oci8.events => Off => Off oci8.max_persistent => -1 => -1 oci8.old_oci_close_semantics => Off => Off oci8.persistent_timeout => -1 => -1 oci8.ping_interval => 60 => 60 oci8.privileged_connect => Off => Off oci8.statement_cache_size => 20 => 20 OCI-PHP-Info: pecl install oci8 pecl/oci8 is already installed and is the same as the released version 1.4.6 We use the following syntax for dsn: Do you need additional Information? Thanks for your help! |
Updated by lew on 2011-09-07 10:22:59 +00:00 Hi All, I have same issue. icinga-web config:
icinga-web 1.5.1 dsn parameter in database.xml:
There is error message in icinga-web.log:
This configuration is working properly with icinga-web-1.4.1. icinga-web 1.4.1 dsn parameter in icinga-io.xml:
Do you have any idea or suggestion? If you need additional info do not hasitate to contact me! Thanks for your help! |
Updated by jmosshammer on 2011-09-07 11:07:24 +00:00
Check your databases.xml (app/config/databases.xml and etc/conf.d/databases.xml), and replace every oci8 entry with oracle, except for the icinga database, here you have to use icingaOracle. |
Updated by nag_dkg on 2011-09-07 12:36:52 +00:00 Hello. I'm little bit confused because of the status of this bug. The Icinga-Web shows no Data from the Oracle database... What is wrong, what informations do you need? |
Updated by jmosshammer on 2011-09-07 13:24:46 +00:00 Your databases.xml(s) (without password) would help |
Updated by nag_dkg on 2011-09-08 06:40:41 +00:00
Hello. In the attachment you will find my databases.xml from /pathto/icinga-web/app/conf. The second databases.xml in /pathto/icinga/etc/conf.d has only one valid line: Everything else is comment out. Additional Information: |
Updated by nag_dkg on 2011-09-09 07:40:56 +00:00 Hello I try to look at the content of the error message: Thanks for your help! |
Updated by nag_dkg on 2011-09-09 10:49:28 +00:00 Hello. We tried a further analysis to this problem. I hope this helps for you to analyze it in more details. |
Updated by jmosshammer on 2011-09-09 12:18:06 +00:00 you can set use_compressed to false on app/modules/AppKit/config/module.xml. Oracle support works afaik (recently helped setting up a bigger enviroment) |
This issue has been migrated from Redmine: https://dev.icinga.com/issues/1857
Created by nag_dkg on 2011-08-29 11:01:17 +00:00
Assignee: (none)
Status: Rejected (closed on 2011-09-07 11:07:24 +00:00)
Target Version: (none)
Last Update: 2011-09-09 12:18:06 +00:00 (in Redmine)
Hallo,
hier eine Kurze Beschreibung meines Icinga-Web-Problems:
Umgebung: OS RH 6 => 2.6.32-131.0.15.el6.x86_64
Icinga und Icinga-Web: 1.5.0
DB.: Oracle 11
PHP: 5.3.3
Beschreibung:
Mit Anmeldung an Icinga-Web werden keine Daten aus der Oracle-DB angezeigt. Die Daten werden aber von Icinga in die Oracle-DB geschrieben.
Wie kann ich Icinga-Web überzeugen, meine Daten auch anzuzeigen?
Vorab vielen Dank für die Unterstützung!
Fehlermeldung: icinga-web/log/debug...:
[Mon Aug 29 12:01:05 2011] [error] Fetch failed with message Couldn't locate driver named oci8
Query: SELECT a.* FROM ( SELECT DISTINCT i.object_id AS i_object_id, i.object_id AS iobject_id, i.name1 AS iname1, i.object_id AS i_object_id, i.name1 A .....
PHP - Installations-/Konfigurationsauszug:
php -i | grep -i oci
/etc/php.d/oci8.ini,
oci8
OCI8 Support => enabled
oci8.connection_class => no value => no value
oci8.default_prefetch => 100 => 100
oci8.events => Off => Off
oci8.max_persistent => -1 => -1
oci8.old_oci_close_semantics => Off => Off
oci8.persistent_timeout => -1 => -1
oci8.ping_interval => 60 => 60
oci8.privileged_connect => Off => Off
oci8.statement_cache_size => 20 => 20
OCI-PHP-Info:
http_proxy=http://proxy.wdr.de:8080/ pecl install oci8
pecl/oci8 is already installed and is the same as the released version 1.4.6
Attachments
The text was updated successfully, but these errors were encountered: