[horde] sessions with oci8 problems

[Liam Hoekenga]

> Is anyone working with sessions in Oracle with oci8? I am testing and I have
> many errors in my Apache "error_log".

I'm trying to use the generic SQL session handler as well.  I created the table
using:


    CREATE TABLE horde_sessionhandler (
        session_id             VARCHAR2(32) NOT NULL,
        session_lastmodified   NUMBER NOT NULL,
        session_data           BLOB,
        PRIMARY KEY (session_id)
    );

... and here's what I get in my apache error log:

[Fri Feb 14 11:36:35 2003] [error] PHP Warning:  
    OCIStmtExecute: ORA-00933: SQL command not properly ended
            in /usr/local/horde-2.2.1UM/lib/SQL.php on line 165
[Fri Feb 14 11:36:35 2003] [error] PHP Warning:  
    OCIFetchInto: ORA-24374: define not done before fetch or execute and fetch
            in /usr/local/horde-2.2.1UM/lib/SQL.php on line 166
[Fri Feb 14 11:36:35 2003] [error] PHP Fatal error:  
    Call to a member function on a non-object in
            /usr/local/horde-2.2.1UM/lib/SQL.php on line 167
[Fri Feb 14 11:36:35 2003] [error] PHP Warning:
    Unknown(): A session is active. You cannot change the session module's
            ini settings at this time. in Unknown on line 0

Another weird thing is that IMP's login process is sending log messages to my
horde log, the instances of Horde::logMessage in lib/SQL.php aren't returning
any information.

The database is getting updated..

SQL> select session_id, session_lastmodified from horde_sessionhandler;

SESSION_ID                       SESSION_LASTMODIFIED
-------------------------------- --------------------
2072918e87bd43fbafaae04a761e991f           1045239510
001286b9c78bdfa3092bcc4aee1b919a           1045239635
9360492053d6308c04995889d4cdb8cd           1045240207
fa9d728b8c8f3a26389ba4fb83aa1c73           1045240594

and it appears that SESSION_DATA has some information stored in it.. ie;

    prefs_cache|a:1{s:7:"_filled";a:0:{}}

I'm connecting to an oracle 8.1.7.4 server using php 4.3.0, horde 2.2.1, imp
3.2rc2.  Output from horde/test.php follow message.  Any ideas?  

Liam
---------------------------------------------------------


Horde Versions
    
    * Horde: 2.2.1
    * IMP: 3.2 (run IMP tests)
    * Turba: 1.1

PHP Version

    * View phpinfo() screen
    * PHP Version: 4.3.0
    * PHP Major Version: 4.3
    * PHP Minor Version: 0
    * PHP Version Classification: release
    * You are running a supported version of PHP.

PHP Module Capabilities
    
    * DOM XML Support: Yes
    * Gettext Support: Yes
    * IMAP Support: Yes
    * LDAP Support: Yes
    * MCAL Support: No
    * Mcrypt Support: Yes
    * MySQL Support: No
    * PostgreSQL Support: No
    * XML Support: Yes

Miscellaneous PHP Settings

    * magic_quotes_runtime disabled: Yes
    * file_uploads enabled: Yes
    * safe_mode disabled: Yes
    * trans_sid disabled: Yes

PHP Sessions

    * Session counter: 1
    * To unregister the session: click here

PEAR

    * PEAR - Yes
    * Recent PEAR - Yes
    * Mail - Yes