Tickets :: Comment on [#9151] Kronolith, Nag, Mnemo, Turba don't work with Oracle DB

* Your Email Address
* Spam protection	Enter the letters below: . ..___ __ .__ . . \|\/\|[__ / `[__)\|__\| \| \|\| \__.\| \| \|
Comment	> I spent the whole day debugging and trying out stuff... > The following is as far as I got with the Problem: > > All Database-Connections except one work fine. > It narrows done to the function _connect() in file > horde-webmail-1.2.6/lib/Horde/Share/sql.php > > I added the following check: > $query = 'select sysdate from dual'; > $result = $this->_write_db->query($query); > if (is_a($result, 'PEAR_Error')) { > Horde::logMessage($result, __FILE__, __LINE__, PEAR_LOG_ERR); > Horde::logMessage(sprintf('RMZ: Error _write_db %s', > print_r($this->_write_db, true)), __FILE__, __LINE__, > PEAR_LOG_NOTICE); > return $result; > } > > and it always fails at this point. > > I positive example is the function &listShares in the same file > (roughly line 450..) > This one always works. > > I'm not sure, what's failing, but the main functionality - adding, > modfiying and viewing addresses, events and memos - is available. > So the connection does work most of the time. > > I added a print_r($this->_write_db, true) for both - a working > connection and a failing, but there is not much of a difference... > > If I have to guess, I would say, that there is one more of these > thingies missing: > > switch ($this->_write_db->phptype) { > case 'oci8': > $this->_write_db->setOption('emulate_database', false); > break; > > But I have no idea where. > > So for your debúgging-pleasure, here is a extract from my log, first > working, then failing: > I do use this connect-information: > horde/HORDE@dwo/dbrmz.robbienet.local, where horde is the user, HORDE > the password, dwo the host and dbrmz.robbienet.local the database > service name. > > ------------------------------------------------------------------------------------------- > Working Connection: > cat error-db.txt > Aug 18 18:44:36 HORDE [notice] [kronolith] RMZ: Working _db > MDB2_Driver_oci8 Object > ( > [string_quoting] => Array > ( > [start] => ' > [end] => ' > [escape] => ' > [escape_pattern] => @ > ) > > [identifier_quoting] => Array > ( > [start] => " > [end] => " > [escape] => " > ) > > [uncommitedqueries] => 0 > [db_index] => 1 > [dsn] => Array > ( > [phptype] => oci8 > [dbsyntax] => oci8 > [username] => horde > [password] => HORDE > [protocol] => > [hostspec] => > [port] => > [socket] => > [database] => > [mode] => > [persistent] => > ) > > [connected_dsn] => Array > ( > [phptype] => oci8 > [dbsyntax] => oci8 > [username] => horde > [password] => HORDE > [protocol] => > [hostspec] => > [port] => > [socket] => > [database] => > [mode] => > [persistent] => > ) > > [connection] => Resource id #34 > [opened_persistent] => > [database_name] => dwo/dbrmz.robbienet.local > [connected_database_name] => > [connected_server_info] => > [supported] => Array > ( > [sequences] => 1 > [indexes] => 1 > [affected_rows] => 1 > [summary_functions] => 1 > [order_by_text] => 1 > [transactions] => 1 > [savepoints] => 1 > [current_id] => 1 > [limit_queries] => 1 > [LOBs] => 1 > [replace] => emulated > [sub_selects] => 1 > [triggers] => 1 > [auto_increment] => > [primary_key] => 1 > [result_introspection] => 1 > [prepared_statements] => 1 > [identifier_quoting] => 1 > [pattern_escaping] => 1 > [new_link] => 1 > ) > > [options] => Array > ( > [ssl] => > [field_case] => 0 > [disable_query] => > [result_class] => MDB2_Result_%s > [buffered_result_class] => MDB2_BufferedResult_%s > [result_wrap_class] => > [result_buffering] => 1 > [fetch_class] => stdClass > [persistent] => > [debug] => 1 > [debug_handler] => Array > ( > [0] => Horde_Share_sql Object > ( > [_db] => MDB2_Driver_oci8 Object > RECURSION > [_write_db] => MDB2_Driver_oci8 Object > RECURSION > [_params] => Array > ( > [persistent] => > [username] => horde > [password] => HORDE > [database] => dwo/dbrmz.robbienet.local > [charset] => utf-8 > [phptype] => oci8 > [hostspec] => > ) > > [_table] => kronolith_shares > [_shareObject] => Horde_Share_Object_sql > [_app] => kronolith > [_root] => > [_cache] => Array > ( > ) > > [_shareMap] => Array > ( > ) > > [_listcache] => Array > ( > ) > > [_sortList] => > ) > > [1] => _selectDB > ) > > [debug_expanded_output] => > [default_text_field_length] => 2000 > [lob_buffer_length] => 8192 > [log_line_break] => > > [idxname_format] => %s_idx > [seqname_format] => %s_seq > [savepoint_format] => MDB2_SAVEPOINT_%s > [statement_format] => MDB2_STATEMENT_%1$s_%2$s > [seqcol_name] => id > [quote_identifier] => > [use_transactions] => 1 > [decimal_places] => 2 > [portability] => 81 > [modules] => Array > ( > [ex] => Extended > [dt] => Datatype > [mg] => Manager > [rv] => Reverse > [na] => Native > [fc] => Function > ) > > [emulate_prepared] => > [datatype_map] => Array > ( > ) > > [datatype_map_callback] => Array > ( > ) > > [nativetype_map_callback] => Array > ( > ) > > [lob_allow_url_include] => > [bindname_format] => (?:\d+)\|(?:[a-zA-Z][a-zA-Z0-9_]) > [max_identifiers_length] => 30 > [default_fk_action_onupdate] => RESTRICT > [default_fk_action_ondelete] => RESTRICT > [DBA_username] => > [DBA_password] => > [database_name_prefix] => > [emulate_database] => > [default_tablespace] => > [result_prefetching] => > ) > > [sql_comments] => Array > ( > [0] => Array > ( > [start] => -- > [end] => > > [escape] => > ) > > [1] => Array > ( > [start] => / > [end] => / > [escape] => > ) > > ) > > [wildcards] => Array > ( > [0] => % > [1] => _ > ) > > [as_keyword] => AS > [warnings] => Array > ( > ) > > [debug_output] => > [in_transaction] => > [nested_transaction_counter] => > [has_transaction_error] => > [offset] => 0 > [limit] => 0 > [phptype] => oci8 > [dbsyntax] => oci8 > [last_query] => SELECT DISTINCT s. FROM kronolith_shares s > LEFT JOIN kronolith_shares_users u ON u.share_id = s.share_id WHERE > s.share_owner = 'rmarz' OR (bitand(s.perm_creator, 2) = 2) OR > (bitand(s.perm_default, 2) = 2) OR ( u.user_uid = 'rmarz' AND > (bitand(u.perm, 2) = 2)) ORDER BY s.attribute_name ASC > [fetchmode] => 1 > [modules] => Array > ( > [Datatype] => MDB2_Driver_Datatype_oci8 Object > ( > [valid_default_values] => Array > ( > [text] => > [boolean] => 1 > [integer] => 0 > [decimal] => 0 > [float] => 0 > [timestamp] => 1970-01-01 00:00:00 > [time] => 00:00:00 > [date] => 1970-01-01 > [clob] => > [blob] => > ) > > [lobs] => Array > ( > ) > > [db_index] => 1 > ) > > ) > > [destructor_registered] => 1 > [_debug] => > [_default_error_mode] => > [_default_error_options] => > [_default_error_handler] => > [_error_class] => PEAR_Error > [_expected_errors] => Array > ( > ) > > [datatype] => MDB2_Driver_Datatype_oci8 Object > ( > [valid_default_values] => Array > ( > [text] => > [boolean] => 1 > [integer] => 0 > [decimal] => 0 > [float] => 0 > [timestamp] => 1970-01-01 00:00:00 > [time] => 00:00:00 > [date] => 1970-01-01 > [clob] => > [blob] => > ) > > [lobs] => Array > ( > ) > > [db_index] => 1 > ) > > [loaded_version_modules] => Array > ( > [0] => datatype > ) > > ) > [pid 17321 on line 479 of > "/home/horde/horde-webmail-1.2.6/lib/Horde/Share/sql.php"] > > --------------------------------------------------------------------------------------- > Failing connection: > cat error-db.txt > Aug 18 18:44:36 HORDE [error] [kronolith] MDB2 Error: not found: > [Error message: Could not select the database: > dwo/dbrmz.robbienet.local] > [pid 17321 on line 835 of > "/home/horde/horde-webmail-1.2.6/lib/Horde/Share/sql.php"] > Aug 18 18:44:36 HORDE [notice] [kronolith] RMZ: Error _write_db > MDB2_Driver_oci8 Object > ( > [string_quoting] => Array > ( > [start] => ' > [end] => ' > [escape] => ' > [escape_pattern] => @ > ) > > [identifier_quoting] => Array > ( > [start] => " > [end] => " > [escape] => " > ) > > [uncommitedqueries] => 0 > [db_index] => 1 > [dsn] => Array > ( > [phptype] => oci8 > [dbsyntax] => oci8 > [username] => horde > [password] => HORDE > [protocol] => > [hostspec] => > [port] => > [socket] => > [database] => > [mode] => > [persistent] => > ) > > [connected_dsn] => Array > ( > [phptype] => oci8 > [dbsyntax] => oci8 > [username] => horde > [password] => HORDE > [protocol] => > [hostspec] => > [port] => > [socket] => > [database] => > [mode] => > [persistent] => > ) > > [connection] => Resource id #34 > [opened_persistent] => > [database_name] => dwo/dbrmz.robbienet.local > [connected_database_name] => > [connected_server_info] => > [supported] => Array > ( > [sequences] => 1 > [indexes] => 1 > [affected_rows] => 1 > [summary_functions] => 1 > [order_by_text] => 1 > [transactions] => 1 > [savepoints] => 1 > [current_id] => 1 > [limit_queries] => 1 > [LOBs] => 1 > [replace] => emulated > [sub_selects] => 1 > [triggers] => 1 > [auto_increment] => > [primary_key] => 1 > [result_introspection] => 1 > [prepared_statements] => 1 > [identifier_quoting] => 1 > [pattern_escaping] => 1 > [new_link] => 1 > ) > > [options] => Array > ( > [ssl] => > [field_case] => 0 > [disable_query] => > [result_class] => MDB2_Result_%s > [buffered_result_class] => MDB2_BufferedResult_%s > [result_wrap_class] => > [result_buffering] => 1 > [fetch_class] => stdClass > [persistent] => > [debug] => 1 > [debug_handler] => Array > ( > [0] => Horde_Share_sql Object > ( > [_db] => MDB2_Driver_oci8 Object > RECURSION > [_write_db] => MDB2_Driver_oci8 Object > RECURSION > [_params] => Array > ( > [persistent] => > [username] => horde > [password] => HORDE > [database] => dwo/dbrmz.robbienet.local > [charset] => utf-8 > [phptype] => oci8 > [hostspec] => > ) > > [_table] => kronolith_shares > [_shareObject] => Horde_Share_Object_sql > [_app] => kronolith > [_root] => > [_cache] => Array > ( > ) > > [_shareMap] => Array > ( > ) > > [_listcache] => Array > ( > ) > > [_sortList] => > ) > > [1] => _selectDB > ) > > [debug_expanded_output] => > [default_text_field_length] => 2000 > [lob_buffer_length] => 8192 > [log_line_break] => > > [idxname_format] => %s_idx > [seqname_format] => %s_seq > [savepoint_format] => MDB2_SAVEPOINT_%s > [statement_format] => MDB2_STATEMENT_%1$s_%2$s > [seqcol_name] => id > [quote_identifier] => > [use_transactions] => 1 > [decimal_places] => 2 > [portability] => 81 > [modules] => Array > ( > [ex] => Extended > [dt] => Datatype > [mg] => Manager > [rv] => Reverse > [na] => Native > [fc] => Function > ) > > [emulate_prepared] => > [datatype_map] => Array > ( > ) > > [datatype_map_callback] => Array > ( > ) > > [nativetype_map_callback] => Array > ( > ) > > [lob_allow_url_include] => > [bindname_format] => (?:\d+)\|(?:[a-zA-Z][a-zA-Z0-9_]) > [max_identifiers_length] => 30 > [default_fk_action_onupdate] => RESTRICT > [default_fk_action_ondelete] => RESTRICT > [DBA_username] => > [DBA_password] => > [database_name_prefix] => > [emulate_database] => > [default_tablespace] => > [result_prefetching] => > ) > > [sql_comments] => Array > ( > [0] => Array > ( > [start] => -- > [end] => > > [escape] => > ) > > [1] => Array > ( > [start] => / > [end] => */ > [escape] => > ) > > ) > > [wildcards] => Array > ( > [0] => % > [1] => _ > ) > > [as_keyword] => AS > [warnings] => Array > ( > ) > > [debug_output] => > [in_transaction] => > [nested_transaction_counter] => > [has_transaction_error] => > [offset] => 0 > [limit] => 0 > [phptype] => oci8 > [dbsyntax] => oci8 > [last_query] => ALTER SESSION SET CURRENT_SCHEMA = > "DWO/DBRMZ.ROBBIENET.LOCAL" > [fetchmode] => 1 > [modules] => Array > ( > ) > > [destructor_registered] => 1 > [_debug] => > [_default_error_mode] => > [_default_error_options] => > [_default_error_handler] => > [_error_class] => PEAR_Error > [_expected_errors] => Array > ( > ) > > ) > [pid 17321 on line 836 of > "/home/horde/horde-webmail-1.2.6/lib/Horde/Share/sql.php"] > >
Attachment
Watch this ticket

Saved Queries