[Openinteract-help] OI 1.41 + PgSQL Issue

[Eric R. <er...@1s...>]

Greetings. .

I'm attempting to get OI 1.41 up and running w/ PgSQL, and am having a few
issues.  I have the program working fine with MySQL, but would prefer to
use PgSQL.

System Info:
Slackware Linux 7
Perl 5.6.1
Apache 1.3.26 + mod_perl 1.27
PostgreSQL 7.2.1
DBD::Pg 1.13

************************************************
************************************************

Here's my datasource from the server.ini:

[db_info main]
db_owner      =
username      = oi_intranet
password      = <passwordhere>
dsn           = dbname=oi_intranet
db_name       =
driver_name   = Pg
sql_install   =
long_read_len = 65536
long_trunc_ok = 0

And my session_info class:

class       = Apache::Session::Postgres

I have created an override_spops.perl in my site's conf dir, and have also
run "oi_manage change_spops_driver --driver=SPOPS::DBI::Pg", just to be
safe.

test_db and install_sql both ran without a hitch (after I re-read the
docs, and figured out what to do with the dsn & db_name for a Pg
connection).

************************************************
************************************************

Error log entry:

Found item: DBI::db
OpenInteract::Error::System::cannot_create_session (335) >> Cannot create
session -- someone is probably using a  defunct key or something.
>> Error with code 310 thrown. Info: Object does not exist in the data
store at
/usr/local/lib/perl5/site_perl/5.6.1/Apache/Session/Store/Postgres.pm line
81.

OpenInteract::Error::System::log_and_return('Intranet::ErrorObject=HASH(0x8e520b0)')
called at
/usr/local/lib/perl5/site_perl/5.6.1/OpenInteract/Error/System.pm line 342

OpenInteract::Error::System::cannot_create_session('Intranet::ErrorObject=HASH(0x8e520b0)')
called at /usr/local/lib/perl5/site_perl/5.6.1/OpenInteract/Error/Main.pm
line 38
        OpenInteract::Error::Main::catch('OpenInteract::Error::Main',
'Intranet::ErrorObject=HASH(0x8e520b0)') called at (eval 402) line 39
        Intranet::ErrorObject::throw('Intranet::ErrorObject',
'HASH(0x9589d30)') called at
/usr/local/lib/perl5/site_perl/5.6.1/OpenInteract/Error.pm line 94
        OpenInteract::Error::throw('OpenInteract::Error',
'HASH(0x9589d30)') called at
/usr/local/lib/perl5/site_perl/5.6.1/OpenInteract/Request.pm line 124

OpenInteract::Request::throw('OpenInteract::Request=HASH(0x9380940)',
'HASH(0x9589d30)') called at
/usr/local/lib/perl5/site_perl/5.6.1/OpenInteract/Session/DBI.pm line 31

OpenInteract::Session::DBI::_create_session('OpenInteract::Session::DBI',
'fb014562f8776e2ac4e3aaa482c4abf7') called at
/usr/local/lib/perl5/site_perl/5.6.1/OpenInteract/Session.pm line 27
        OpenInteract::Session::parse('OpenInteract::Session::DBI') called
at /usr/local/lib/perl5/site_perl/5.6.1/OpenInteract.pm line 256
        eval {...} called at
/usr/local/lib/perl5/site_perl/5.6.1/OpenInteract.pm line 251
        OpenInteract::setup_cookies_and_session('OpenInteract',
'OpenInteract::Request=HASH(0x9380940)') called at
/usr/local/lib/perl5/site_perl/5.6.1/OpenInteract.pm line 52
        eval {...} called at
/usr/local/lib/perl5/site_perl/5.6.1/OpenInteract.pm line 46
        OpenInteract::handler('OpenInteract', 'Apache=SCALAR(0x85f52a0)')
called at /dev/null line 0
        eval {...} called at /dev/null line 0
 Cannot save error 310: DBD::Pg::st execute failed: ERROR:  value too long
for type character varying(60) at
/usr/local/lib/perl5/site_perl/5.6.1/SPOPS/SQLInterface.pm line 288.
 at /usr/local/lib/perl5/site_perl/5.6.1/OpenInteract/Error/System.pm line
394
OpenInteract::Session::DBI::_create_session (36) >> Error thrown. Now
clear the cookie
 --EXITED WITH ERROR from main handler eval block
Error: Can't call method "discover_properties" on an undefined value at
/usr/local/lib/perl5/site_perl/5.6.1/OpenInteract.pm line 348.

************************************************
************************************************

I'm suspecting "Cannot save error 310..." is the issue.

Any assistance in tracking this one down would be greatly appreciated.
Let me know if there's any additional info I can provide that might be
helpful.

Chris, thanks for the all time & effort you've put in to OI, and I hope
all went well with your move last month.  (=

Thanks in advance. .

-----
 Eric Reeves - Network / Systems Administrator
 1st Contact Technologies - 281.333.1444