Menu
▾
▴
openinteract-help — For new and current users, we offer support, troubleshooting and assistance.
You can subscribe to this list here.
| 2001 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
(35) |
Nov
(38) |
Dec
(112) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2002 |
Jan
(20) |
Feb
(24) |
Mar
(47) |
Apr
(18) |
May
(28) |
Jun
(17) |
Jul
(15) |
Aug
(40) |
Sep
(14) |
Oct
(5) |
Nov
(26) |
Dec
(31) |
| 2003 |
Jan
(8) |
Feb
(14) |
Mar
(38) |
Apr
(34) |
May
(33) |
Jun
(32) |
Jul
(24) |
Aug
(9) |
Sep
|
Oct
(20) |
Nov
(43) |
Dec
(22) |
| 2004 |
Jan
(23) |
Feb
(25) |
Mar
(15) |
Apr
(3) |
May
(31) |
Jun
(13) |
Jul
(3) |
Aug
(3) |
Sep
(13) |
Oct
(15) |
Nov
(3) |
Dec
(5) |
| 2005 |
Jan
|
Feb
|
Mar
(16) |
Apr
(24) |
May
|
Jun
(2) |
Jul
|
Aug
(5) |
Sep
(4) |
Oct
|
Nov
(3) |
Dec
(2) |
| 2006 |
Jan
|
Feb
(1) |
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
From: Chris W. <ch...@cw...> - 2002-12-18 20:27:51
|
Chris McDaniel wrote:
> Thanks again - much appreciated! I will look into the JDBC option further -
> trust perl to have everything!
Just for kicks (and I work with MS SQL a lot) I decided to see
how FreeTDS worked. FYI, I compiled this on Linux and am
connecting to a MS SQL 2000 server:
* Grab the latest CVS sources from FreeTDS (this fixes a
problem when using DBD::Sybase)
* Install FreeTDS with:
./configure --with-tdsver=7.0 --with-ssl \
--prefix=/usr/local/freetds
make
make install
* Download the latest DBD::Sybase (0.95)
* Edit DBD-Sybase-0.95/CONFIG with:
EXTRA_LIBS= -ltds -linsck
(I think for Solaris you need -ltds -ltli)
* set SYBASE=/usr/local/freetds (or whatever the configure
prefix is)
* perl Makefile.PL, make, make install
Now you need to edit /usr/local/freetds/etc/freetds.conf with
your server entry. (They have examples, it's pretty simple.) The
entry name is what you use as the server name in your DBI DSN:
freetds.conf:
[foo]
host=my.server.com
port=1433
DBI connection:
DBI->connect( 'DBI:Sybase:server=foo', ... )
All that works great. But the name/type information doesn't seem
to be retrieved in the same manner ($sth->{NAME}, $sth->{TYPE})
so SPOPS won't work without a little massaging. Namely, you need
to tell SPOPS what the field names and types are. Here's an example:
#!/usr/bin/perl
use strict;
use SPOPS::Initialize;
{
my %config = (
doodad => {
class => 'My::Doodad',
isa => [ 'SPOPS::DBI::Sybase', 'SPOPS::DBI' ],
rules_from => [ 'SPOPS::Tool::DBI::Datasource' ],
field => [ 'doodad_id', 'name', 'action' ],
id_field => 'doodad_id',
increment_field => 'yes',
no_insert => [ 'doodad_id' ],
no_update => [ 'doodad_id' ],
base_table => 'cw_doodad',
dbi_type_info => { doodad_id => 'int',
name => 'char',
action => 'char' },
dbi_config => { dsn =>
'DBI:Sybase:server=foo;database=foo',
username => 'foo',
password => 'foo' },
},
);
SPOPS::Initialize->process({ config => \%config });
My::Doodad->new({ doodad_id => 1,
name => 'foo',
action => 'run' })->save();
My::Doodad->new({ doodad_id => 2,
name => 'bar',
action => 'crawl' })->save();
my $doodads = My::Doodad->fetch_group();
foreach my $doodad ( @{ $doodads } ) {
print Dumper( $doodad );
}
}
The 'dbi_type_info' field is where we need to specify the
name/type mapping since we cannot discover it automatically (yet).
So it would *seem* to work. I haven't tried a full OI install
with this but I'm pretty sure the only sticky point would be
SPOPS, which should be ok with the workaround posted above.
I see that DBD::Sybase supports the DBI column_info method for
retrieving column metadata. I haven't listened in on the DBI
mailing list for a while so I don't know if this is replacing
{NAME}/{TYPE} or what. If so I'll build support into SPOPS.
Have fun!
Chris
--
Chris Winters (ch...@cw...)
Building enterprise-capable snack solutions since 1988.
|
|
From: Chris M. <Chr...@te...> - 2002-12-18 18:21:16
|
Thanks again - much appreciated! I will look into the JDBC option further - trust perl to have everything! -----Original Message----- From: John Sequeira [mailto:jo...@po...] Sent: December 18, 2002 11:01 AM To: Chris McDaniel Cc: ope...@li... Subject: Re:proxying to mssql server Chris, Just to clarify, I would definitely not add to your security woes by installing proxy software on the SQL Server. In my xml-rpc scenario, the client had an existing web farm of IIS-only boxes, with a single SQL Server database/hot-spare in the back tier. It was easy for me to drop the XML-RPC scripts on the existing IIS boxes. If doing something similar: allocating a middle tier between your solaris app and the SQL Server is possibile, the dbd::proxy approach becomes viable. 1U rackmounts are probably going to be cheaper than the Openlink license, but otoh I guess maintaining it might not be. Also, MS gives away Openlink's Type 4 JDBC drivers IIRC. Using them, you could run DBD::JDBC only on your Solaris box, and you should be golden. Anyway, good luck with freetds - that's probably simplest. JS Chris McDaniel wrote: >The admin of the MS SQL box wants to avoid installing anything on it - it is >a vendor turnkey type system, and he's very wary of breakage as it is a main >component in a high-volume production teleconferencing system... Even a >.exe service built using activestate's PDK (which I've done before - worked >pretty good) is too much for their comfort. > >I'd imagine the xml-rpc approach requires server-side stuff too... > >Funny you should mention freetds - the vendor driver I'm evaluating >(Openlink) encorporates it. I've tried compiling freetds myself, but it >seems to hate my Solaris box. I am getting some support on the freetds >mailing list though, so hopefully it will all work out. > >Thanks for the reply - much appreciated. > >-----Original Message----- >From: John Sequeira [mailto:jo...@po...] >Sent: December 17, 2002 4:52 PM >To: ope...@li... >Subject: [Openinteract-help] Re: openinteract-help digest, Vol 1 #186 -3 >msgs > > >Chris McD, > >Are you sure you have to purchase a driver? > >Have you looked at the freetds project (freetds.org) or considered a >proxy approach (DBD::Proxy or DBD::JDBC >http://www.cwinters.com/News/show/?news_id=238)? > >FWIW, I've used xml-rpc proxies from linux-to-mssql server before to >avoid licensing hassles like this for a low volume application, but not >the aforementioned approaches. I hear good things about freetds, however. > >JS > > > >>Message: 1 >>From: "Chris McDaniel" <Chr...@te...> >>To: "'ope...@li...'" >> <ope...@li...> >>Date: Tue, 17 Dec 2002 02:09:54 -0700 >>Subject: [Openinteract-help] database connection question (concurrent >> >> >users) > > >>Hello, >> >>I just wanted to clarify something about DB connections before I go off >>spending my company's money. I'm encountering a situation where I need to >>purchase a db driver (for MS SQL - surprise) to interact with a remote >>datasource for a certain package I'm working on. Worse, it is per-user >>licensing. So, I read Openinteract::DBI and it seems to me that if I >> >> >figure > > >>out a way to make OI make the DB connection at the beginning as it does for >>my main DB, it would show as only one user. Is that correct? or is it one >>per httpd child? >> >>Also, any tips on a good way to do this? >> >>Thanks, >> >>Chris McDaniel >> >> >> >> > > > > >------------------------------------------------------- >This sf.net email is sponsored by: >With Great Power, Comes Great Responsibility >Learn to use your power at OSDN's High Performance Computing Channel >http://hpc.devchannel.org/ >_______________________________________________ >openinteract-help mailing list >ope...@li... >https://lists.sourceforge.net/lists/listinfo/openinteract-help > > > > > |
|
From: John S. <jo...@po...> - 2002-12-18 15:58:58
|
Chris, Just to clarify, I would definitely not add to your security woes by installing proxy software on the SQL Server. In my xml-rpc scenario, the client had an existing web farm of IIS-only boxes, with a single SQL Server database/hot-spare in the back tier. It was easy for me to drop the XML-RPC scripts on the existing IIS boxes. If doing something similar: allocating a middle tier between your solaris app and the SQL Server is possibile, the dbd::proxy approach becomes viable. 1U rackmounts are probably going to be cheaper than the Openlink license, but otoh I guess maintaining it might not be. Also, MS gives away Openlink's Type 4 JDBC drivers IIRC. Using them, you could run DBD::JDBC only on your Solaris box, and you should be golden. Anyway, good luck with freetds - that's probably simplest. JS Chris McDaniel wrote: >The admin of the MS SQL box wants to avoid installing anything on it - it is >a vendor turnkey type system, and he's very wary of breakage as it is a main >component in a high-volume production teleconferencing system... Even a >.exe service built using activestate's PDK (which I've done before - worked >pretty good) is too much for their comfort. > >I'd imagine the xml-rpc approach requires server-side stuff too... > >Funny you should mention freetds - the vendor driver I'm evaluating >(Openlink) encorporates it. I've tried compiling freetds myself, but it >seems to hate my Solaris box. I am getting some support on the freetds >mailing list though, so hopefully it will all work out. > >Thanks for the reply - much appreciated. > >-----Original Message----- >From: John Sequeira [mailto:jo...@po...] >Sent: December 17, 2002 4:52 PM >To: ope...@li... >Subject: [Openinteract-help] Re: openinteract-help digest, Vol 1 #186 -3 >msgs > > >Chris McD, > >Are you sure you have to purchase a driver? > >Have you looked at the freetds project (freetds.org) or considered a >proxy approach (DBD::Proxy or DBD::JDBC >http://www.cwinters.com/News/show/?news_id=238)? > >FWIW, I've used xml-rpc proxies from linux-to-mssql server before to >avoid licensing hassles like this for a low volume application, but not >the aforementioned approaches. I hear good things about freetds, however. > >JS > > > >>Message: 1 >>From: "Chris McDaniel" <Chr...@te...> >>To: "'ope...@li...'" >> <ope...@li...> >>Date: Tue, 17 Dec 2002 02:09:54 -0700 >>Subject: [Openinteract-help] database connection question (concurrent >> >> >users) > > >>Hello, >> >>I just wanted to clarify something about DB connections before I go off >>spending my company's money. I'm encountering a situation where I need to >>purchase a db driver (for MS SQL - surprise) to interact with a remote >>datasource for a certain package I'm working on. Worse, it is per-user >>licensing. So, I read Openinteract::DBI and it seems to me that if I >> >> >figure > > >>out a way to make OI make the DB connection at the beginning as it does for >>my main DB, it would show as only one user. Is that correct? or is it one >>per httpd child? >> >>Also, any tips on a good way to do this? >> >>Thanks, >> >>Chris McDaniel >> >> >> >> > > > > >------------------------------------------------------- >This sf.net email is sponsored by: >With Great Power, Comes Great Responsibility >Learn to use your power at OSDN's High Performance Computing Channel >http://hpc.devchannel.org/ >_______________________________________________ >openinteract-help mailing list >ope...@li... >https://lists.sourceforge.net/lists/listinfo/openinteract-help > > > > > |
|
From: Chris M. <Chr...@te...> - 2002-12-18 07:43:36
|
The admin of the MS SQL box wants to avoid installing anything on it - it is a vendor turnkey type system, and he's very wary of breakage as it is a main component in a high-volume production teleconferencing system... Even a .exe service built using activestate's PDK (which I've done before - worked pretty good) is too much for their comfort. I'd imagine the xml-rpc approach requires server-side stuff too... Funny you should mention freetds - the vendor driver I'm evaluating (Openlink) encorporates it. I've tried compiling freetds myself, but it seems to hate my Solaris box. I am getting some support on the freetds mailing list though, so hopefully it will all work out. Thanks for the reply - much appreciated. -----Original Message----- From: John Sequeira [mailto:jo...@po...] Sent: December 17, 2002 4:52 PM To: ope...@li... Subject: [Openinteract-help] Re: openinteract-help digest, Vol 1 #186 -3 msgs Chris McD, Are you sure you have to purchase a driver? Have you looked at the freetds project (freetds.org) or considered a proxy approach (DBD::Proxy or DBD::JDBC http://www.cwinters.com/News/show/?news_id=238)? FWIW, I've used xml-rpc proxies from linux-to-mssql server before to avoid licensing hassles like this for a low volume application, but not the aforementioned approaches. I hear good things about freetds, however. JS >Message: 1 >From: "Chris McDaniel" <Chr...@te...> >To: "'ope...@li...'" > <ope...@li...> >Date: Tue, 17 Dec 2002 02:09:54 -0700 >Subject: [Openinteract-help] database connection question (concurrent users) > > >Hello, > >I just wanted to clarify something about DB connections before I go off >spending my company's money. I'm encountering a situation where I need to >purchase a db driver (for MS SQL - surprise) to interact with a remote >datasource for a certain package I'm working on. Worse, it is per-user >licensing. So, I read Openinteract::DBI and it seems to me that if I figure >out a way to make OI make the DB connection at the beginning as it does for >my main DB, it would show as only one user. Is that correct? or is it one >per httpd child? > >Also, any tips on a good way to do this? > >Thanks, > >Chris McDaniel > > ------------------------------------------------------- This sf.net email is sponsored by: With Great Power, Comes Great Responsibility Learn to use your power at OSDN's High Performance Computing Channel http://hpc.devchannel.org/ _______________________________________________ openinteract-help mailing list ope...@li... https://lists.sourceforge.net/lists/listinfo/openinteract-help |
|
From: John S. <jo...@po...> - 2002-12-17 21:50:16
|
Chris McD, Are you sure you have to purchase a driver? Have you looked at the freetds project (freetds.org) or considered a proxy approach (DBD::Proxy or DBD::JDBC http://www.cwinters.com/News/show/?news_id=238)? FWIW, I've used xml-rpc proxies from linux-to-mssql server before to avoid licensing hassles like this for a low volume application, but not the aforementioned approaches. I hear good things about freetds, however. JS >Message: 1 >From: "Chris McDaniel" <Chr...@te...> >To: "'ope...@li...'" > <ope...@li...> >Date: Tue, 17 Dec 2002 02:09:54 -0700 >Subject: [Openinteract-help] database connection question (concurrent users) > > >Hello, > >I just wanted to clarify something about DB connections before I go off >spending my company's money. I'm encountering a situation where I need to >purchase a db driver (for MS SQL - surprise) to interact with a remote >datasource for a certain package I'm working on. Worse, it is per-user >licensing. So, I read Openinteract::DBI and it seems to me that if I figure >out a way to make OI make the DB connection at the beginning as it does for >my main DB, it would show as only one user. Is that correct? or is it one >per httpd child? > >Also, any tips on a good way to do this? > >Thanks, > >Chris McDaniel > > |
|
From: Chris W. <ch...@cw...> - 2002-12-17 13:19:29
|
Chris McDaniel wrote: > I just wanted to clarify something about DB connections before I go off > spending my company's money. I'm encountering a situation where I need to > purchase a db driver (for MS SQL - surprise) to interact with a remote > datasource for a certain package I'm working on. Worse, it is per-user > licensing. So, I read Openinteract::DBI and it seems to me that if I figure > out a way to make OI make the DB connection at the beginning as it does for > my main DB, it would show as only one user. Is that correct? or is it one > per httpd child? It will create at most one as needed per httpd child. The user for all the connections will be the same. > Also, any tips on a good way to do this? By "do this", do you mean actually make the connection? In SPOPS terms, MS SQL == Sybase, if that helps at all. So if you're using DBD::ODBC you'd do something like: [db_info main] db_owner = username = foo password = bar dsn = DSN=mydsn db_name = driver_name = ODBC sql_install = Sybase long_read_len = 65536 long_trunc_ok = 0 If you haven't already done so, I'd make sure you can use it with Perl/DBI before you purchase the driver. Most companies don't have "Perl-compatibility" high on their feature list :-) Chris |
|
From: Chris M. <Chr...@te...> - 2002-12-17 09:14:36
|
Hello, I just wanted to clarify something about DB connections before I go off spending my company's money. I'm encountering a situation where I need to purchase a db driver (for MS SQL - surprise) to interact with a remote datasource for a certain package I'm working on. Worse, it is per-user licensing. So, I read Openinteract::DBI and it seems to me that if I figure out a way to make OI make the DB connection at the beginning as it does for my main DB, it would show as only one user. Is that correct? or is it one per httpd child? Also, any tips on a good way to do this? Thanks, Chris McDaniel |
|
From: Chris W. <ch...@cw...> - 2002-12-13 13:23:13
|
* Chris McDaniel (Chr...@te...) [021213 03:10]: > Just wondering if it's possible to have a action key with slashes, like > instead of www.oisite.com/NewUser, something like > www.oisite.com/Products/Widgets/NewUser > > I tried just sticking 'products/widgets/newuser' into the action.conf for > the user package (I didn't actually expect it to work, but trying never > hurts...) and as expected it did not work. Can this be done? Not yet. OI2 should support this though. Chris -- Chris Winters (ch...@cw...) Building enterprise-capable snack solutions since 1988 |
|
From: Chris M. <Chr...@te...> - 2002-12-13 07:52:32
|
Hello, Just wondering if it's possible to have a action key with slashes, like instead of www.oisite.com/NewUser, something like www.oisite.com/Products/Widgets/NewUser I tried just sticking 'products/widgets/newuser' into the action.conf for the user package (I didn't actually expect it to work, but trying never hurts...) and as expected it did not work. Can this be done? Thanks, Chris McDaniel |
|
From: Chris M. <Chr...@te...> - 2002-12-13 03:49:56
|
That seems to have worked OK - I'll let you know if it happens again. Thanks for the help! -----Original Message----- From: Chris Winters [mailto:ch...@cw...] Sent: December 11, 2002 10:53 PM To: Chris McDaniel Cc: 'ope...@li...' Subject: Re: [Openinteract-help] error message at random moments... Chris McDaniel wrote: > DBD:: mysql $VERSION = '2.0902'; > > [db_info main] > db_owner = > username = xxxxxxxxxx > password = xxxxxxxxxx > dsn = database= > db_name = commerceDB > driver_name = mysql > sql_install = > long_read_len = 65536 > long_trunc_ok = 0 Just to see what happens, try changing this to: dsn = database=commerceDB db_name = Chris -- Chris Winters (ch...@cw...) Building enterprise-capable snack solutions since 1988. |
|
From: Chris W. <ch...@cw...> - 2002-12-12 03:48:57
|
Chris McDaniel wrote: > DBD:: mysql $VERSION = '2.0902'; > > [db_info main] > db_owner = > username = xxxxxxxxxx > password = xxxxxxxxxx > dsn = database= > db_name = commerceDB > driver_name = mysql > sql_install = > long_read_len = 65536 > long_trunc_ok = 0 Just to see what happens, try changing this to: dsn = database=commerceDB db_name = Chris -- Chris Winters (ch...@cw...) Building enterprise-capable snack solutions since 1988. |
|
From: Chris M. <Chr...@te...> - 2002-12-11 19:49:38
|
DBD:: mysql $VERSION = '2.0902'; [db_info main] db_owner = username = xxxxxxxxxx password = xxxxxxxxxx dsn = database= db_name = commerceDB driver_name = mysql sql_install = long_read_len = 65536 long_trunc_ok = 0 The other children seem to be OK, and usually just refreshing fixes it for a while - it doesn't happen too often, and almost never when I'm looking for it. I have 5 apache children running around by default, and the site is not launched, so I don't see much traffic to it yet either. Thanks, Chris -----Original Message----- From: Chris Winters [mailto:ch...@cw...] Sent: December 11, 2002 8:37 AM To: Chris McDaniel Cc: 'ope...@li...'; BgTA Hotpop Subject: RE: [Openinteract-help] error message at random moments... On Wed, 2002-12-11 at 02:25, Chris McDaniel wrote: > OK, here's what I found - I'm a little confused... > > OpenInteract::setup_theme (340) >> Error! Cannot retrieve theme! ( Class: > commerce::Theme ) with error (DBD::mysql::st execute failed: No Database > Selected at /var/www/localperl/lib/site_perl/5.6.1/SPOPS/DBI/TypeInfo.pm > line 139. > / DBD::mysql::st execute failed: No Database Selected at > /var/www/localperl/lib/site_perl/5.6.1/SPOPS/SQLInterface.pm line 12 > 2.) Help! > --EXITED WITH ERROR from main handler eval block > Error: 0 > > The only thing I can think of is probably dead wrong - but you know how if > you leave the mysql client alone too long the connection 'goes away' - sould > it be something like that (if you leave OI alone too long)? > > Like I said, probably dead wrong... You and Raul seem to be having the same problem so I'll just reply to you both in this message. Your handle is losing the idea of a database altogether while Raul's is defaulting to the system 'mysql' database. This might be the result of different permissions, I'm not sure. I don't think your database has gone away -- the other Apache children keep working, right? So something must be getting stale in the database connection itself. So two questions to see if we can narrow down the problem: - What version of DBD::mysql are you using? - What does the database configuration look like? (Just copy/paste the '[db_info main]' section from your server.ini file, XXXing out the user/;password of course :-) Thanks, Chris -- Chris Winters (ch...@cw...) Building enterprise-capable snack solutions since 1988. |
|
From: Chris W. <ch...@cw...> - 2002-12-11 13:33:01
|
On Wed, 2002-12-11 at 02:25, Chris McDaniel wrote: > OK, here's what I found - I'm a little confused... > > OpenInteract::setup_theme (340) >> Error! Cannot retrieve theme! ( Class: > commerce::Theme ) with error (DBD::mysql::st execute failed: No Database > Selected at /var/www/localperl/lib/site_perl/5.6.1/SPOPS/DBI/TypeInfo.pm > line 139. > / DBD::mysql::st execute failed: No Database Selected at > /var/www/localperl/lib/site_perl/5.6.1/SPOPS/SQLInterface.pm line 12 > 2.) Help! > --EXITED WITH ERROR from main handler eval block > Error: 0 > > The only thing I can think of is probably dead wrong - but you know how if > you leave the mysql client alone too long the connection 'goes away' - sould > it be something like that (if you leave OI alone too long)? > > Like I said, probably dead wrong... You and Raul seem to be having the same problem so I'll just reply to you both in this message. Your handle is losing the idea of a database altogether while Raul's is defaulting to the system 'mysql' database. This might be the result of different permissions, I'm not sure. I don't think your database has gone away -- the other Apache children keep working, right? So something must be getting stale in the database connection itself. So two questions to see if we can narrow down the problem: - What version of DBD::mysql are you using? - What does the database configuration look like? (Just copy/paste the '[db_info main]' section from your server.ini file, XXXing out the user/;password of course :-) Thanks, Chris -- Chris Winters (ch...@cw...) Building enterprise-capable snack solutions since 1988. |
|
From: Chris M. <Chr...@te...> - 2002-12-11 07:57:56
|
OK, here's what I found - I'm a little confused...
OpenInteract::setup_theme (340) >> Error! Cannot retrieve theme! ( Class:
commerce::Theme ) with error (DBD::mysql::st execute failed: No Database
Selected at /var/www/localperl/lib/site_perl/5.6.1/SPOPS/DBI/TypeInfo.pm
line 139.
/ DBD::mysql::st execute failed: No Database Selected at
/var/www/localperl/lib/site_perl/5.6.1/SPOPS/SQLInterface.pm line 12
2.) Help!
--EXITED WITH ERROR from main handler eval block
Error: 0
The only thing I can think of is probably dead wrong - but you know how if
you leave the mysql client alone too long the connection 'goes away' - sould
it be something like that (if you leave OI alone too long)?
Like I said, probably dead wrong...
Chris McDaniel
-----Original Message-----
From: Chris Winters [mailto:ch...@cw...]
Sent: December 10, 2002 1:51 PM
To: Chris McDaniel
Cc: 'ope...@li...'
Subject: Re: [Openinteract-help] error message at random moments...
Chris McDaniel wrote:
> Hi,
>
> Sometimes I get the error message
>
> Fundamental part of OpenInteract (themes) not functioning; please contact
> the system administrator
>
> and sometimes not - themes are definitely working, so I don't get it.
> Anyone know why this is happening? I'm using OI 1.54 with mysql on
Solaris
> 8, perl 5.6.1, modperl_solo config. I have an older OI on the site, so
I'm
> using a local lib directory for the 1.54 install.
Check your error log (in $WEBSITE_DIR/logs) for a message when
this happens, it should tell you why it cannot retrieve the
theme. Here is the code that produces the message so you can have
something to scan for:
if ( $@ ) {
my $ei = SPOPS::Error->get;
OpenInteract::Error->set( $ei );
$R->throw({ code => 404 });
$R->scrib( 0, "Error! Cannot retrieve theme! ( Class: ",
$R->theme, ")",
"with error ($@ / $ei->{system_msg}) Help!" );
....
--
Chris Winters (ch...@cw...)
Building enterprise-capable snack solutions since 1988.
|
|
From: Chris W. <ch...@cw...> - 2002-12-10 18:15:19
|
Chris McDaniel wrote:
> Hi,
>
> Sometimes I get the error message
>
> Fundamental part of OpenInteract (themes) not functioning; please contact
> the system administrator
>
> and sometimes not - themes are definitely working, so I don't get it.
> Anyone know why this is happening? I'm using OI 1.54 with mysql on Solaris
> 8, perl 5.6.1, modperl_solo config. I have an older OI on the site, so I'm
> using a local lib directory for the 1.54 install.
Check your error log (in $WEBSITE_DIR/logs) for a message when
this happens, it should tell you why it cannot retrieve the
theme. Here is the code that produces the message so you can have
something to scan for:
if ( $@ ) {
my $ei = SPOPS::Error->get;
OpenInteract::Error->set( $ei );
$R->throw({ code => 404 });
$R->scrib( 0, "Error! Cannot retrieve theme! ( Class: ",
$R->theme, ")",
"with error ($@ / $ei->{system_msg}) Help!" );
....
--
Chris Winters (ch...@cw...)
Building enterprise-capable snack solutions since 1988.
|
|
From: <ra...@bg...> - 2002-12-10 14:15:14
|
The same thing happens to me exactly. I'm using OI 1.54 with mysql on FreeBSD 4.7, perl 5.8, modperl_solo confi= g. El Lun 09 Dic 2002 18:30, Chris McDaniel escribi=F3: > Hi, > > Sometimes I get the error message > > Fundamental part of OpenInteract (themes) not functioning; please conta= ct > the system administrator > > and sometimes not - themes are definitely working, so I don't get it. > Anyone know why this is happening? I'm using OI 1.54 with mysql on Sol= aris > 8, perl 5.6.1, modperl_solo config. I have an older OI on the site, so= I'm > using a local lib directory for the 1.54 install. > > Thanks, > > Chris McDaniel -- =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D | Ra=FAl Romero=09=09| ra...@bg... | FreeDeveloper ;-)=09| FreeBSD 4.7-STABLE =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D | http://www.bgta.net/=09| ICQ: 162258467 | Jabber: bg...@ja...=09| MSN: bgt...@ho... =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D --=20 =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D | Ra=FAl Romero=09=09| ra...@bg...=09=09 | FreeDeveloper ;-)=09| FreeBSD 4.7-STABLE=09=09=09=09 =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D | http://www.bgta.net/=09| ICQ: 162258467=09 | Jabber: bg...@ja...=09| MSN: bgt...@ho... =09 =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D |
|
From: Chris M. <Chr...@te...> - 2002-12-09 17:35:13
|
Hi, Sometimes I get the error message Fundamental part of OpenInteract (themes) not functioning; please contact the system administrator and sometimes not - themes are definitely working, so I don't get it. Anyone know why this is happening? I'm using OI 1.54 with mysql on Solaris 8, perl 5.6.1, modperl_solo config. I have an older OI on the site, so I'm using a local lib directory for the 1.54 install. Thanks, Chris McDaniel |
|
From: Chris W. <ch...@cw...> - 2002-11-29 14:58:13
|
On Thu, 2002-11-28 at 11:03, Jochen Lillich wrote: > Hi Chris, > > it's been over a year ago when I first brought on the problem of > localization in OI. Now I can present a useable solution. :-) > ... Just a short note here (Thursday/Friday is a holiday in the US, and I'm out the door on a short trip). This is *exactly* the sort of thing I was hoping for. I don't think OI should have any low-level functionality for this, but we can create some bridges so that creating the lexicon can be automated -- read from config/properties files, etc. You should bundle this up and send it to CPAN. Do you have any plans to do so? More later... Chris -- Chris Winters (ch...@cw...) Building enterprise-capable snack solutions since 1988. |
|
From: Jochen L. <jl...@te...> - 2002-11-28 16:04:21
|
Hi Chris,
it's been over a year ago when I first brought on the problem of
localization in OI. Now I can present a useable solution. :-)
You wrote:
> What we really need is a plugin for TT to be able to use one of the
> gettext-like Perl implementations.
In another non-OI project, I achieved this via a TT filter subroutine
that uses Locale::Maketext classes. This filter is used with text in a
default language:
[% |loc %]Hello World![% END %]
Inserting values:
[% |loc( name.last, name.first ) %]Greetings, [_2] [_1].[% END %]
Using a localization function:
[% |loc ( article.date ) %]Written on [dateformat,_1][% END %]
The "loc" filter is implemented via a dynamic filter subroutine. This so
called "filter factory" is then connected to the TT object configuration:
sub maketemplate()
{
my $locFilterFactory = sub {
my ( $context, @args ) = @_;
return sub {
my $text = shift;
# translate text
my $xltext = $self->loc( $text, @args );
...
return $xltext;
};
};
my $config = {
...
FILTERS => {
loc => [ $locFilterFactory, 1 ],
},
}
my $template = Template->new( $config );
...
return $template;
}
The $self->loc() method used in the anonymous sub above has to instantiate
a Locale::Maketext child class (eg. "MyL10N") that has itself a child class
for every language supported (eg. "MyL10N::de", "MyL10N::fr", etc.). These
language classes then contain a simple lexicon
our %Lexicon = {
'Hello World!' => 'Hallo Welt!',
'Greetings, [_2] [_1].' => '[_2] [_1], sei gegruesst.'
}
as well as localization methods (like the dateformat() method in the
example above that converts the ISO date format to a local one).
$self->loc() then finally calls MyL10N::gettext() -- which
automagically dispatches to its correct language child class (see
Locale::Maketext docs) -- and returns the translated text to the
filter. This text then replaces the default text used in the
template.
I think that this concept is very practical and could be integrated
into OpenInteract quite easily.
Best regards,
Jochen
--
----------------------------------------------------------------
*Jochen Lillich*, Dipl.-Inform. (FH)
Consultant/Trainer @ /TeamLinux GbR/
Tel. +49 7254 985187-0 http://www.teamlinux.de
----------------------------------------------------------------
|
|
From: Chris W. <ch...@cw...> - 2002-11-25 14:04:13
|
On Mon, 2002-11-25 at 05:20, Nikollos wrote:
> However, at creation of the new user, value of a field <removal_date>
> in sys_user table is established incorrectly (NULL value).
>
> I'm added the debugging message in NewUser handler:
>
> 83 $new_user->{removal_date} = $R->user->now( { time => $R->{time} + REMOVAL_TIME } );
> warn "NewUser Handler: after get date: $new_user->{removal_date}";
> 84 eval { $new_user->save };
>
> and have received the following message in server errlog:
> SPOPS::AUTOLOAD (602) >> Cannot fill request (now) from class FA_OI::User
> NewUser Handler: after get date: at .../OI/WWW/tmplib/FA_OI/Handler/NewUser.pm line 84.
>
> What I have made not so?
I missed that usage of ->now() when I removed SPOPS::Utility from the
user 'isa' listing. In two minutes there will be a new version of the
base_user package on sourceforge that fixes the problem.
Thanks for the report!
Chris
--
Chris Winters (ch...@cw...)
Building enterprise-capable snack solutions since 1988.
|
|
From: Nikollos <ni...@fb...> - 2002-11-25 10:18:40
|
Chris, many thanks for your great work!
I'm install and running OI 1.54 without problems.
However, at creation of the new user, value of a field <removal_date>
in sys_user table is established incorrectly (NULL value).
I'm added the debugging message in NewUser handler:
83 $new_user->{removal_date} = $R->user->now( { time => $R->{time} + REMOVAL_TIME } );
warn "NewUser Handler: after get date: $new_user->{removal_date}";
84 eval { $new_user->save };
and have received the following message in server errlog:
SPOPS::AUTOLOAD (602) >> Cannot fill request (now) from class FA_OI::User
NewUser Handler: after get date: at .../OI/WWW/tmplib/FA_OI/Handler/NewUser.pm line 84.
What I have made not so?
Thank you, ( and excuse for my bad English )
Nikollos
******************
My environment:
FreeBSD 4.6
perl 5.6.1
Apache 1.3.26
mod_perl 1.27
MySQL 3.23.49
OI 1.54
SPOPS 0.71
base_user 1.58
DBD::mysql 2.0419
|
|
From: Chris M. <Chr...@te...> - 2002-11-25 06:44:02
|
Thanks, Chris - This is very helpful - as is usual for you.
Thanks again!
Chris
-----Original Message-----
From: Chris Winters
To: Chris McDaniel
Cc: 'ope...@li...'
Sent: 11/24/02 9:11 PM
Subject: Re: [Openinteract-help] multiple languages in OI
On Wed, 2002-11-20 at 02:49, Chris McDaniel wrote:
> So to provide to multiple languages for both logged in and not logged
in
> users, I need to have a persistent reference to a users language
selection
> throughout all requests. This language selection needs to be
accessible to
> both handlers and templates/pages.
The session should work -- even if a user isn't logged in they still get
a session. You could also just use a cookie if you like. And the session
data is accessible from the template:
[% lang = OI.session.lang %]
[% IF lang == 'fr' %] ...
> Create a new directive in server.ini like 'fr' for French, and point
it to
> the main template. My understanding is that this would have no other
effect
> than shoving this directive into $R->{ui}{directive} and I'm thinking
I
> should be able to get at that in my handlers and pass it into my
templates
> (and hack it into base_page).
For the main template, it would probably be useful to define the
template name in the theme and then have the template selection routine
available for subclassing. So you could define something like:
package OpenInteract::UI::LanguageChoice;
use base qw( OpenInteract::UI::Main );
my $DEFAULT_LANGUAGE = 'en';
sub choose_template {
my ( $class ) = @_;
my ( $language );
if ( $R->{auth}{is_logged_in} ) {
$language = $R->{auth}{user}->language;
}
$language ||= $R->apache->param( 'lang' )
|| $R->{session}{lang}
|| $DEFAULT_LANGUAGE;
my $R = OpenInteract::Request->instance;
my $template = $R->{theme}->property_value( "template_$language" )
|| $R->{theme}->property_value( 'main_template' );
return $template;
}
I think I'll add that even if you don't find it useful :-)
> I could then have all my templates branch on
> this and have multiple language versions in each template. If I
wanted to
> be really crafty I would use widgets heavily to avoid either
duplicating
> HTML code or having some really untidy branching. The good bit is
that this
> is only needing to be done pages that non-admin types would see. One
> possible issue I see immediately is that I would not be able to use
popup or
> notmpl directives as well as the fr directive, which might prove to be
a bit
> annoying...
(The 'popup' and 'notmpl' directive stuff is an ugly hack. I hate even
thinking about them :-)
Using widgets is helpful but it doesn't really help with the labelling
issue. What we really need is a plugin for TT to be able to use one of
the gettext-like Perl implementations. This way you'd be able to do
something like:
<tr>
<td>[% Gettext.lookup( 'searchform.label.firstname' ) %]</td>
<td>[% PROCESS form_text( name = 'firstname', size = 15 ) %]</td>
</tr>
And the right label gets looked up. We can do better integration but
this first step would be nice.
> I also wondered about putting a ?lang=fr at the end of all my URLs and
> parsing off that instead.... Would that amount to the same thing?
I think so. It would make it a pain to track your URLs though --
sessions (or cookies) are great for this kind of thing.
Later,
Chris
--
Chris Winters (ch...@cw...)
Building enterprise-capable snack solutions since 1988.
|
|
From: Chris W. <ch...@cw...> - 2002-11-25 04:20:33
|
On Mon, 2002-11-18 at 13:18, Steve Sapovits wrote: > Can you point me to some docs or examples for writing that > wrapper? I looked at SPOPS::DBI some already. I don't know that there are any explicit docs for doing this -- the last SPOPS implementation done was SPOPS::LDAP and that was over a year ago. But you basically need to subclass SPOPS and implement a number of methods. Actually, I take that back. There's another implementation I did but it's not really an implementation. SPOPS::Loopback is used in the test suite for testing security, rulesets, etc. It defines the bare minimum of what an SPOPS implementation needs, including the security checks. That would probably be the best place to start. > I'll see about the case study. Not sure how long it will > take to roll this out ... it's mostly a "spare time" thing > for me right now. Sure, I understand. Just wanted to strike while the iron was hot, so to speak. Chris -- Chris Winters (ch...@cw...) Building enterprise-capable snack solutions since 1988. |
|
From: Chris W. <ch...@cw...> - 2002-11-25 04:14:07
|
On Wed, 2002-11-20 at 02:49, Chris McDaniel wrote:
> So to provide to multiple languages for both logged in and not logged in
> users, I need to have a persistent reference to a users language selection
> throughout all requests. This language selection needs to be accessible to
> both handlers and templates/pages.
The session should work -- even if a user isn't logged in they still get
a session. You could also just use a cookie if you like. And the session
data is accessible from the template:
[% lang = OI.session.lang %]
[% IF lang == 'fr' %] ...
> Create a new directive in server.ini like 'fr' for French, and point it to
> the main template. My understanding is that this would have no other effect
> than shoving this directive into $R->{ui}{directive} and I'm thinking I
> should be able to get at that in my handlers and pass it into my templates
> (and hack it into base_page).
For the main template, it would probably be useful to define the
template name in the theme and then have the template selection routine
available for subclassing. So you could define something like:
package OpenInteract::UI::LanguageChoice;
use base qw( OpenInteract::UI::Main );
my $DEFAULT_LANGUAGE = 'en';
sub choose_template {
my ( $class ) = @_;
my ( $language );
if ( $R->{auth}{is_logged_in} ) {
$language = $R->{auth}{user}->language;
}
$language ||= $R->apache->param( 'lang' )
|| $R->{session}{lang}
|| $DEFAULT_LANGUAGE;
my $R = OpenInteract::Request->instance;
my $template = $R->{theme}->property_value( "template_$language" )
|| $R->{theme}->property_value( 'main_template' );
return $template;
}
I think I'll add that even if you don't find it useful :-)
> I could then have all my templates branch on
> this and have multiple language versions in each template. If I wanted to
> be really crafty I would use widgets heavily to avoid either duplicating
> HTML code or having some really untidy branching. The good bit is that this
> is only needing to be done pages that non-admin types would see. One
> possible issue I see immediately is that I would not be able to use popup or
> notmpl directives as well as the fr directive, which might prove to be a bit
> annoying...
(The 'popup' and 'notmpl' directive stuff is an ugly hack. I hate even
thinking about them :-)
Using widgets is helpful but it doesn't really help with the labelling
issue. What we really need is a plugin for TT to be able to use one of
the gettext-like Perl implementations. This way you'd be able to do
something like:
<tr>
<td>[% Gettext.lookup( 'searchform.label.firstname' ) %]</td>
<td>[% PROCESS form_text( name = 'firstname', size = 15 ) %]</td>
</tr>
And the right label gets looked up. We can do better integration but
this first step would be nice.
> I also wondered about putting a ?lang=fr at the end of all my URLs and
> parsing off that instead.... Would that amount to the same thing?
I think so. It would make it a pain to track your URLs though --
sessions (or cookies) are great for this kind of thing.
Later,
Chris
--
Chris Winters (ch...@cw...)
Building enterprise-capable snack solutions since 1988.
|
|
From: Chris M. <Chr...@te...> - 2002-11-20 07:53:22
|
Hello,
I'm trying to think of a way to allow for a language selection in OI. I've
had an idea or two, but I thought it might be best to 'consult the
oracle'... Maybe there is a better way? Maybe my idea is unworkable? Note
that I have finally upgraded to 1.54...
So to provide to multiple languages for both logged in and not logged in
users, I need to have a persistent reference to a users language selection
throughout all requests. This language selection needs to be accessible to
both handlers and templates/pages.
Create a new directive in server.ini like 'fr' for French, and point it to
the main template. My understanding is that this would have no other effect
than shoving this directive into $R->{ui}{directive} and I'm thinking I
should be able to get at that in my handlers and pass it into my templates
(and hack it into base_page). I could then have all my templates branch on
this and have multiple language versions in each template. If I wanted to
be really crafty I would use widgets heavily to avoid either duplicating
HTML code or having some really untidy branching. The good bit is that this
is only needing to be done pages that non-admin types would see. One
possible issue I see immediately is that I would not be able to use popup or
notmpl directives as well as the fr directive, which might prove to be a bit
annoying...
I also wondered about putting a ?lang=fr at the end of all my URLs and
parsing off that instead.... Would that amount to the same thing?
Is there a better way?
Chris McDaniel
Service Development Architect
TELUS Business Solutions
Voice.416.883.4610 Cell.416.676.4654
|
3 messages has been excluded from this view by a project administrator.
