openinteract-help — For new and current users, we offer support, troubleshooting and assistance.

[Openinteract-help] typos in oi_manage --man

[Jon <jo...@3e...>]

hi!

Thanks for the help with my other post Chris, am looking into it ATM, in 
the meantime...

In oi_manage --man, where the examples for remove_package are listed, just 
after "if you want to truly eradicate your package" package is spelt 
'pacakage' twice in the shell examples.

jon

Re: [Openinteract-help] oi_manage w/ apply_package, fails 'Website name not set in package object'

[Chris W. <ch...@cw...>]

Jon wrote:
> 2) [documentation/idiot-proofing/functionality tweak]
> 
> Out-of-the-box do Pages > Create.  For location put something a bit 
> silly like oooooohhh 'demopage'.  Add some copy, save it ("Status Object 
> created properly."), view it - 404 error.  Now it can be seen in the 
> list, but can't be edited cos it can't be found, so you can't remove it 
> through the UI as far as I can see.  How do you delete it safely - I 
> assume ripping out of the DB isn't as it would mess up some internal 
> records of OI? (I have no problems using '/demopage.html' etc).

Okay, I got to the bottom of this and seem to have fixed it for both 
the saving and viewing tasks. The new package is up on the 
Sourceforge site (base_page 1.21) and will be in the next OI 
release. Thanks for pointing this out!

Chris

-- 
Chris Winters (ch...@cw...)
Building enterprise-capable snack solutions since 1988.

Re: [Openinteract-help] oi_manage w/ apply_package, fails 'Website name not set in package object'

[Chris W. <ch...@cw...>]

Jon wrote:
> But All Of A Sudden:
> 
> [root@3evtowers demo]# oi_manage --base_dir=/usr/local/OpenInteract 
> --website_dir=/home/httpd/OIdemo --package=demo apply_package
> Running apply_package...
> =========================
> 
> Status of the packages you requested to be applied:
> demo (0.01)
>   FAILED!: Cannot install package to website. Error: Website name not
>            set in package object.
> 
> Hard to trace, as I cannot find this defined anywhere - the error is 
> indeed accurate! :)  Saying where "Website name" is set might make the 
> error msg more useful if that's unproblematic.  FWIW my package.conf the 
> default one spat out by the create_skeleton.  I can give more stats as 
> to my environment as required, not posting 'em now cos I had the whole 
> thing working.  Just can't apply my new package :(

That's very strange... this isn't set in the package itself (that 
is, the 'package.conf' file in the package), it's set into the 
information passed to the relevant OI::Package routine. What's 
strange is that oi_manage should read this information from your 
base configuration file -- sort of a bootstrapping file that gets 
everything up and going. It should be in $WEBSITE_DIR/conf/base.conf 
and have your website name defined. Does yours have this field?

> Out-of-the-box do Pages > Create.  For location put something a bit 
> silly like oooooohhh 'demopage'.  Add some copy, save it ("Status Object 
> created properly."), view it - 404 error.  Now it can be seen in the 
> list, but can't be edited cos it can't be found, so you can't remove it 
> through the UI as far as I can see.  How do you delete it safely - I 
> assume ripping out of the DB isn't as it would mess up some internal 
> records of OI? (I have no problems using '/demopage.html' etc).

Actually you can just delete the database record. I thought I'd 
fixed this... ah, that was something else. There's something deeply 
weird going on here... trying to create a 'demopage' record forced 
my mod_perl process to gobble up every bit of available memory. Not 
good! I'll fix this shortly.

> Failing that, maybe change the "Must be unique; use only letters and 
> numbers, no spaces or other characters" copy by the Location: widget to 
> be more all-inclusive, or surely it's possible not to create the page in 
> the 1st place if OI predicts it will result in a 404 (can't see why this 
> shouldn't be possible).

That's possible... I'm pretty sure this has to do with the lack of a 
file extension and treating it like a directory request... a bit 
more digging to do.

> Apart from that it looks really cool, sitting nicely between bare 
> templating systems and overweight CMS's.  I've been evaluating 
> mod_perl-y things like this for about a month and I'd like to settle 
> with OI.

Cool. The 'page' stuff allows for some very simple CMS operations, 
but you'd probably have to extend it or write your own for anything 
fancier. It works fairly well for creating/editing HTML/text 
documents as well as a browser-based shared filespace.

Good luck!

Chris

-- 
Chris Winters (ch...@cw...)
Building enterprise-capable snack solutions since 1988.

[Openinteract-help] oi_manage w/ apply_package, fails 'Website name not set in package object'

[Jon <jo...@3e...>]

hi!

Recently installed OI, all working fine, looks great, dead chuffed, mum's 
proud.  Two things:

1) [probably a documentation issue]  Following 
http://openinteract.sourceforge.net/docs/developer.shtml

... setting up the 'fruit' package, changing only the name of the demo code 
from 'fruit' to 'demo', and changing the spec of the initial MySQL 
table.  All was going fine, including...

oi_manage --base_dir=/usr/local/OpenInteract 
--package_file=demo-0.01.tar.gz install_package

But All Of A Sudden:

[root@3evtowers demo]# oi_manage --base_dir=/usr/local/OpenInteract 
--website_dir=/home/httpd/OIdemo --package=demo apply_package
Running apply_package...
=========================

Status of the packages you requested to be applied:
demo (0.01)
   FAILED!: Cannot install package to website. Error: Website name not
            set in package object.


Hard to trace, as I cannot find this defined anywhere - the error is indeed 
accurate! :)  Saying where "Website name" is set might make the error msg 
more useful if that's unproblematic.  FWIW my package.conf the default one 
spat out by the create_skeleton.  I can give more stats as to my 
environment as required, not posting 'em now cos I had the whole thing 
working.  Just can't apply my new package :(


2) [documentation/idiot-proofing/functionality tweak]

Out-of-the-box do Pages > Create.  For location put something a bit silly 
like oooooohhh 'demopage'.  Add some copy, save it ("Status Object created 
properly."), view it - 404 error.  Now it can be seen in the list, but 
can't be edited cos it can't be found, so you can't remove it through the 
UI as far as I can see.  How do you delete it safely - I assume ripping out 
of the DB isn't as it would mess up some internal records of OI? (I have no 
problems using '/demopage.html' etc).

Failing that, maybe change the "Must be unique; use only letters and 
numbers, no spaces or other characters" copy by the Location: widget to be 
more all-inclusive, or surely it's possible not to create the page in the 
1st place if OI predicts it will result in a 404 (can't see why this 
shouldn't be possible).

Apart from that it looks really cool, sitting nicely between bare 
templating systems and overweight CMS's.  I've been evaluating mod_perl-y 
things like this for about a month and I'd like to settle with OI.

TIA,
jon

Re: [Openinteract-help] SPOPS-lite for CGI?

[Chris W. <ch...@cw...>]

Chris Hutchinson wrote:
> Is there any 'standard' way to reduce the load/configuration time of
> SPOPS-based classes?
> 
> I'm trying to run an SPOPS-based application under non-mod_perl CGI, and the
> compile/load time of pages is currently quite slow.

Are you sure that the SPOPS initialization is the problem? It very 
well could be, but if/before we do any work I'd like to know that 
it's actually the issue? It's doing a fair amount of work at 
initialization, particularly if you're initializating a lot of 
classes, but I don't think it's doing *that* much work as compared 
with I/O-bound processes like accesing your database.

So how many classes are you initializing? Are there lots of custom 
rules or behaviors? Are you using security?

> I tried defining database fields in the classes, rather than
> discover_fields, but this made no difference to the speed.

Defining everything in the configuration makes sense -- keep 
accesses to the database down.

> Can any specific configuration be made in the class hashes so SPOPS doesn't
> need to run all its configuration work generating accessors, etc.

Not right now. To be honest speed, particularly initialization 
speed, hasn't been a real big priority to this point -- most of the 
people using SPOPS do so in a persistent environment, so 
initialization isn't a big deal.

Later,

Chris

-- 
Chris Winters (ch...@cw...)
Building enterprise-capable snack solutions since 1988.

Re: [Openinteract-help] outputting to the user's browser before t hehandler completes

[Chris W. <ch...@cw...>]

Chris McDaniel wrote:
> I worked around it (wrote wrote to DB, gave a splash page and meta refreshed
> to the long-running handler whit the record id in the URL GET style so that
> I could get at the data I needed.  Anyway, I'm not in a rush anymore, but it
> would still be nice to know if the below is possible.

Your solution is exactly what I would have suggested. With OI you 
build the whole page up and send it at once. This is suitable for 
*almost* every type of web-based operation, but yours is one of the 
ones that doesn't fit the model so a workaround is necessary.

Chris

-- 
Chris Winters (ch...@cw...)
Building enterprise-capable snack solutions since 1988.

[Openinteract-help] SPOPS-lite for CGI?

[Chris H. <ch...@hu...>]

Is there any 'standard' way to reduce the load/configuration time of
SPOPS-based classes?

I'm trying to run an SPOPS-based application under non-mod_perl CGI, and the
compile/load time of pages is currently quite slow.

I tried defining database fields in the classes, rather than
discover_fields, but this made no difference to the speed.

Can any specific configuration be made in the class hashes so SPOPS doesn't
need to run all its configuration work generating accessors, etc.

Thanks for any advice,
Chris Hutchinson

RE: [Openinteract-help] outputting to the user's browser before t hehandler completes

[Chris M. <Chr...@te...>]

I worked around it (wrote wrote to DB, gave a splash page and meta refreshed
to the long-running handler whit the record id in the URL GET style so that
I could get at the data I needed.  Anyway, I'm not in a rush anymore, but it
would still be nice to know if the below is possible.

Thanks,

Chris McDaniel

-----Original Message-----
From: Chris McDaniel 
Sent: March 8, 2003 3:48 AM
To: 'ope...@li...'
Subject: [Openinteract-help] outputting to the user's browser before
thehandler completes



Hello,

just curious to know if it is possible to output some stuff to the user's
browser at the beginning of a handler.  What I'm wanting to do is give the
user a 'processing...' message while a handler of mine works (it takes a
long time...).  When it completes I redirect to another page (which I do
know how to do...) so I'm not concerned about duplicating headers or
anything.

Any thoughts?

Thanks,

Chris McDaniel



-------------------------------------------------------
This SF.net email is sponsored by: Etnus, makers of TotalView, The debugger 
for complex code. Debugging C/C++ programs can leave you feeling lost and 
disoriented. TotalView can help you find your way. Available on major UNIX 
and Linux platforms. Try it free. www.etnus.com
_______________________________________________
openinteract-help mailing list
ope...@li...
https://lists.sourceforge.net/lists/listinfo/openinteract-help

[Openinteract-help] outputting to the user's browser before the handler completes

[Chris M. <Chr...@te...>]

Hello,

just curious to know if it is possible to output some stuff to the user's
browser at the beginning of a handler.  What I'm wanting to do is give the
user a 'processing...' message while a handler of mine works (it takes a
long time...).  When it completes I redirect to another page (which I do
know how to do...) so I'm not concerned about duplicating headers or
anything.

Any thoughts?

Thanks,

Chris McDaniel

Re: [Openinteract-help] SPOPS: fetch with mult attribute limits?

[Chris W. <ch...@cw...>]

Phil R Lawrence wrote:
> My question is about supported usage syntax.  How does one fetch records 
> based on *mutiple* criteria?  I saw this example for fetching based on 
> one criterion:
> 
>   1: my $publisher = My::Publisher->fetch( $pub_id );
>   2: my $books = $publisher->book;
>   3: print "Books published by $publisher->{name}:\n";
>   4: foreach my $book ( @{ $books } ) {
>   5:    print "  $book->{name}\n";
>   6: }
> 
> But I would like to select books based on multiple attribute limits...
> Ex:
>   my $books = My::Book->fetch(
>     publisher => My::Publisher->fetch( name => $pub_name ),
>     pages => ['<' => $pages],
>   );

This would be:

   my $books = My::Book->fetch_group({
                     where => 'name = ? AND pages < ?',
                     value => [ $pub_name, $pages ] });

This uses a DBI/SQL syntax, but SQL isn't very difficult 
(particularly for stuff like this) and most people are familiar 
with it. Besides, who wants to invent another query language? :-)

>   print "Books pub'd by $pub_name with < $pages pages.\n"
>   foreach my $book ( @{ $books } ) {
>     print "  $book->{name}\n";
>   }

This would be the same.

> BIG PICTURE:
> For ad hoc reporting, I ultimately want to offer a series of WWW forms 
> that:
>   1. prompt user to pick 1 of the available objects
>   2. prompt user to choose fields (attributes) of that object
>      for SELECTion
>   3. prompt user with all the available limits (attributes)
>      for that object.  User will set the values with which the
>      object population will be limited.
> 
> Assuming I can programaticly interrogate the schema such that #1-3 are 
> possible, I will need to generate method calls to get the result.  Thus 
> my question above.

Yep, no problem at all. I do this all the time, typically by 
treating the WHERE clause as a list along with all the associated 
values, then doing a join at the end to make the clause into a 
string. For instance, to take a simple case:

  my @search_fields = qw( publisher author publish_year );
  my @where  = ();
  my @values = ();
  foreach my $field ( @search_fields ) {
     # this could be CGI, Apache, whatever
      my $value = get_param_value( $field );
      next unless ( $value );
      push @where ' $field = ? ';
      push @values, $value;
  }
  my $books = My::Book->fetch_group({
                    where => join( ' AND ', @where ),
                    value => \@values });
  ...

Hope this makes sense.

Chris

-- 
Chris Winters (ch...@cw...)
Building enterprise-capable snack solutions since 1988.

[Openinteract-help] SPOPS: fetch with mult attribute limits?

[Phil R L. <prl...@Le...>]

Hi,

This question is about SPOPS...

I want an object abstraction for my existing RDBMS.  SPOPS seems to 
offer a nice way of setting up the schema.  :-)

My question is about supported usage syntax.  How does one fetch records 
based on *mutiple* criteria?  I saw this example for fetching based on 
one criterion:

   1: my $publisher = My::Publisher->fetch( $pub_id );
   2: my $books = $publisher->book;
   3: print "Books published by $publisher->{name}:\n";
   4: foreach my $book ( @{ $books } ) {
   5:    print "  $book->{name}\n";
   6: }

But I would like to select books based on multiple attribute limits...
Ex:
   my $books = My::Book->fetch(
     publisher => My::Publisher->fetch( name => $pub_name ),
     pages => ['<' => $pages],
   );
   print "Books pub'd by $pub_name with < $pages pages.\n"
   foreach my $book ( @{ $books } ) {
     print "  $book->{name}\n";
   }

BIG PICTURE:
For ad hoc reporting, I ultimately want to offer a series of WWW forms that:
   1. prompt user to pick 1 of the available objects
   2. prompt user to choose fields (attributes) of that object
      for SELECTion
   3. prompt user with all the available limits (attributes)
      for that object.  User will set the values with which the
      object population will be limited.

Assuming I can programaticly interrogate the schema such that #1-3 are 
possible, I will need to generate method calls to get the result.  Thus 
my question above.

Comments?
Phil R Lawrence

PS - I'm not yet subscribed, please CC me any response.  Thanks!

Re: [Openinteract-help] Authentication

[Chris W. <ch...@cw...>]

Alex McLintock wrote:
> I may be a bit dim in trying to rtfm, but I am looking to see how 
> OpenInteract handles authentication and authorisation. Ideally I would 
> like a system which stores users, roles, and allows pages to be 
> authorised by role. I'd ideally like there to be a superuser type role 
> which can edit users and roles.
> 
> Does such a thing exist? I assume it is the sort of thing which gets 
> re-written time and time again.

You're not dim. The docs need some re-org (coming in version 2!), 
and I just noticed that the security doc isn't on the documentation 
index page.

Anyway, this is all built-in. Authentication is done through a 
standard user object, and during the 'install_sql' process a 
'superuser' object is created which has rights to do everything. You 
should really only use it to create an admin user and assign that 
user to the 'site admin' group. (The 'site admin' and 'public' 
groups are also created at 'install_sql' time.)

Authorization is done by a fairly flexible security scheme. You can 
assign security on a per-object basis and also assign security to 
particular actions. Additionally, security for pages is implemented 
in a hierarchical fashion: you can set it on a directory and have it 
inherited to subdirectories and pages.

More in the following documents:

  http://openinteract.sourceforge.net/docs/security.shtml
  http://spops.sourceforge.net/doc/SPOPS/Manual/Security.shtml

Chris

-- 
Chris Winters (ch...@cw...)
Building enterprise-capable snack solutions since 1988.

[Openinteract-help] Authentication

[Alex M. <al...@OW...>]

I may be a bit dim in trying to rtfm, but I am looking to see how 
OpenInteract handles authentication and authorisation. Ideally I would like 
a system which stores users, roles, and allows pages to be authorised by 
role. I'd ideally like there to be a superuser type role which can edit 
users and roles.

Does such a thing exist? I assume it is the sort of thing which gets 
re-written time and time again.

Alex


Available for java/perl/C++/web development in London, UK or nearby.
Apache FOP, Cocoon, Turbine, Struts,XSL:FO, XML, Tomcat, JSP
http://www.OWAL.co.uk/

Re: [Openinteract-help] Bad link to manager's guide

[Chris W. <ch...@cw...>]

Barry Hoggard wrote:
> The link on this page:
> 
> http://www.openinteract.org/docs/guides
> 
> to the manager's guide doesn't work.
> 
> Also, the news page (http://www.openinteract.org/news) is blank, and the 
> old news doesn't mention any of the newest releases.  For people like me 
> that are evaluating whether to use it, it makes me nervous to at first 
> think there hasn't been any news since last May.  I know there have been 
> more recent releases because of announcements on the mod_perl list.

Thanks for the pointers. The oi.org site is out-of-date, as you've 
seen. The main site is now http://openinteract.sourceforge.net/, and 
I'll see about getting a redirect from the .org site.

Chris

-- 
Chris Winters (ch...@cw...)
Building enterprise-capable snack solutions since 1988.

[Openinteract-help] Bad link to manager's guide

[Barry H. <ba...@tr...>]

Hello.

The link on this page:

http://www.openinteract.org/docs/guides

to the manager's guide doesn't work.

Also, the news page (http://www.openinteract.org/news) is blank, and 
the old news doesn't mention any of the newest releases.  For people 
like me that are evaluating whether to use it, it makes me nervous to 
at first think there hasn't been any news since last May.  I know there 
have been more recent releases because of announcements on the mod_perl 
list.



--
Barry Hoggard
Tristan Media LLC
e: ba...@tr...
aim: hoggardb

RE: [Openinteract-help] automatically logging in a user aftersign up

[Chris M. <Chr...@te...>]

Works great, thank you!

-----Original Message-----
From: Chris Winters [mailto:ch...@cw...]
Sent: February 26, 2003 7:10 AM
To: Chris McDaniel
Cc: 'ope...@li...'
Subject: Re: [Openinteract-help] automatically logging in a user
aftersignup


Chris McDaniel wrote:
> Any thoughts on how to go about automatically logging in a user and
> redirecting to a non-world-readable location directly after submitting the
> signup for an account form?  I'm not sure where to start...

I'm not sure about the redirecting part (where you want to go, 
etc.), but this sounded like a good idea (and it's easy) so I added 
it to the 'base_user' package. The 'newuser' action now has a key 
'autologin' which is by default set to 'no'. Set it to 'yes' to 
autologin users -- you can do this in a global override file, 
instructions are in doc/package.pod.

Package is available on SF. I haven't tested it yet, so let me know 
how it works :-)

Chris

-- 
Chris Winters (ch...@cw...)
Building enterprise-capable snack solutions since 1988.

Re: [Openinteract-help] automatically logging in a user after signup

[Chris W. <ch...@cw...>]

Chris McDaniel wrote:
> Any thoughts on how to go about automatically logging in a user and
> redirecting to a non-world-readable location directly after submitting the
> signup for an account form?  I'm not sure where to start...

I'm not sure about the redirecting part (where you want to go, 
etc.), but this sounded like a good idea (and it's easy) so I added 
it to the 'base_user' package. The 'newuser' action now has a key 
'autologin' which is by default set to 'no'. Set it to 'yes' to 
autologin users -- you can do this in a global override file, 
instructions are in doc/package.pod.

Package is available on SF. I haven't tested it yet, so let me know 
how it works :-)

Chris

-- 
Chris Winters (ch...@cw...)
Building enterprise-capable snack solutions since 1988.

[Openinteract-help] automatically logging in a user after signup

[Chris M. <Chr...@te...>]

Any thoughts on how to go about automatically logging in a user and
redirecting to a non-world-readable location directly after submitting the
signup for an account form?  I'm not sure where to start...

Thanks,

Chris McDaniel

Re: [Openinteract-help] changing the main template for a particular package

[Chris W. <ch...@cw...>]

Chris McDaniel wrote:
> Thanks for all you help.  I have one more question (for now, anyway...).
> I'm trying to figure out how to change the base template for a given package
> (or handler even).  I've been browsing the docs, but I can't find it.  Is
> there an easy way to do this?

You can't do it from one place for an entire package, but you can do it 
in a handler:

  $R->{page}{_template_name_} = 'mypkg::mytemplate';

(more into in OpenInteract::UI::Main)

Or even in a template:

[% OI.use_main_template( 'mypkg::mytemplate' ) %]

(more info in OpenInteract::Template::Plugin)

Chris

[Openinteract-help] changing the main template for a particular package

[Chris M. <Chr...@te...>]

Hello,

Thanks for all you help.  I have one more question (for now, anyway...).
I'm trying to figure out how to change the base template for a given package
(or handler even).  I've been browsing the docs, but I can't find it.  Is
there an easy way to do this?

Thanks,

Chris McDaniel

Re: [Openinteract-help] second db connection

[Chris W. <ch...@cw...>]

Chris McDaniel wrote:
> Thank you very much!  The datasource in question doesn't house any tables
> that I will access directly, rather I will be running stored procedures, so
> I need to form and execute my sql without using the usual spops objects...
> So do you know of a way I can do this?

Yep, just call $R->db with the datasource name and you'll get back 
your standard everyday DBI handle:

  my $dbh = $R->db( 'datasource_name' );
  my $sql = "EXEC mysp 'foo', 'bar'";
  my $sth = $dbh->prepare( $sql );
  $sth->execute;
  ...

Good luck,

Chris

-- 
Chris Winters (ch...@cw...)
Building enterprise-capable snack solutions since 1988.

RE: [Openinteract-help] second db connection

[Chris M. <Chr...@te...>]

Thank you very much!  The datasource in question doesn't house any =
tables
that I will access directly, rather I will be running stored =
procedures, so
I need to form and execute my sql without using the usual spops =
objects...
So do you know of a way I can do this?

Thanks again,

Chris

-----Original Message-----
From: And...@Be... =
[mailto:And...@Be...]
Sent: February 20, 2003 3:51 AM
To: Chris McDaniel; ope...@li...
Subject: AW: [Openinteract-help] second db connection


Hi Chris,

you are almost right:

- yes,  you can define more datasources in your server.ini / =
server.perl
like this

[db_info seconddb]
db_owner      =3D
username      =3D auser
password      =3D apassword
dsn           =3D host=3Dbigbox.dbs.com
db_name       =3D adbname
driver_name   =3D mysql
sql_install   =3D
long_read_len =3D 65536
long_trunc_ok =3D 0

- to access this, you do not have to do anything special in your =
handler
- all you have to do is add a key to the SPOPS definition ( i.e.
conf/spops.perl ) like this:

'datasource' =3D> 'scounddb',

Hope this gets you up and running,

regards,

Andreas
-----Urspr=FCngliche Nachricht-----
Von: Chris McDaniel [mailto:Chr...@te...]
Gesendet: Donnerstag, 20. Februar 2003 09:20
An: 'ope...@li...'
Betreff: [Openinteract-help] second db connection



Hello,

Hope I'm not making a nuisance of myself, but I have yet another =
question.
In the server.ini it says things like:
[datasource]
default_connection_db   =3D main
and
[db_info main]

which makes me think that you could have other non-default datasources =
and
do a [db_info whatever] type statement.  I'm not sure if this is =
something
that is meant to be done, but if so, are there any docs on it?  If not, =
what
would I need to add to my ini file and how would I access this =
secondary DB
from within a handler?

Thanks!=20

Chris McDaniel



-------------------------------------------------------
This SF.net email is sponsored by: SlickEdit Inc. Develop an edge.
The most comprehensive and flexible code editor you can use.
Code faster. C/C++, C#, Java, HTML, XML, many more. FREE 30-Day Trial.
www.slickedit.com/sourceforge
_______________________________________________
openinteract-help mailing list
ope...@li...
https://lists.sourceforge.net/lists/listinfo/openinteract-help

AW: [Openinteract-help] second db connection

[<And...@Be...>]

Hi Chris,

you are almost right:

- yes,  you can define more datasources in your server.ini / =
server.perl
like this

[db_info seconddb]
db_owner      =3D
username      =3D auser
password      =3D apassword
dsn           =3D host=3Dbigbox.dbs.com
db_name       =3D adbname
driver_name   =3D mysql
sql_install   =3D
long_read_len =3D 65536
long_trunc_ok =3D 0

- to access this, you do not have to do anything special in your =
handler
- all you have to do is add a key to the SPOPS definition ( i.e.
conf/spops.perl ) like this:

'datasource' =3D> 'scounddb',

Hope this gets you up and running,

regards,

Andreas
-----Urspr=FCngliche Nachricht-----
Von: Chris McDaniel [mailto:Chr...@te...]
Gesendet: Donnerstag, 20. Februar 2003 09:20
An: 'ope...@li...'
Betreff: [Openinteract-help] second db connection



Hello,

Hope I'm not making a nuisance of myself, but I have yet another =
question.
In the server.ini it says things like:
[datasource]
default_connection_db   =3D main
and
[db_info main]

which makes me think that you could have other non-default datasources =
and
do a [db_info whatever] type statement.  I'm not sure if this is =
something
that is meant to be done, but if so, are there any docs on it?  If not, =
what
would I need to add to my ini file and how would I access this =
secondary DB
from within a handler?

Thanks!=20

Chris McDaniel



-------------------------------------------------------
This SF.net email is sponsored by: SlickEdit Inc. Develop an edge.
The most comprehensive and flexible code editor you can use.
Code faster. C/C++, C#, Java, HTML, XML, many more. FREE 30-Day Trial.
www.slickedit.com/sourceforge
_______________________________________________
openinteract-help mailing list
ope...@li...
https://lists.sourceforge.net/lists/listinfo/openinteract-help

[Openinteract-help] second db connection

[Chris M. <Chr...@te...>]

Hello,

Hope I'm not making a nuisance of myself, but I have yet another question.
In the server.ini it says things like:
[datasource]
default_connection_db   = main
and
[db_info main]

which makes me think that you could have other non-default datasources and
do a [db_info whatever] type statement.  I'm not sure if this is something
that is meant to be done, but if so, are there any docs on it?  If not, what
would I need to add to my ini file and how would I access this secondary DB
from within a handler?

Thanks! 

Chris McDaniel

Re: [Openinteract-help] sessions table filling up

[Chris W. <ch...@cw...>]

Chris McDaniel wrote:
> At present the vast majority of users visiting my site are not logged in.  I
> noticed that my session table fills up very quickly.  The site's been live
> since mid-January and my session table was huge - almost a gig - I can't
> tell exactly because it ate my disk space and corrupted the table.  Any
> ideas about why this is happening?  Is clearing the session table something
> that I'm supposed to do?

Yes. Version 1.56 includes (among other things) an update to the 'base' 
package with a script 'cleanup_sessions.pl' which will delete old/stale 
sessions from the database. If you don't want to upgrade you can just 
grab the script from CVS and use it -- there aren't any other dependencies.

Sorry about the troubles it caused. It was definitely a deficiency 
before. OI will also create sessions more readily than it used to (even 
if people don't login) since we cache theme and other objects there.

Chris