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

Re: [Openinteract-help] Bulk SPOPS security checks?

[Andreas N. <an...@kl...>]

> Ok, good to hear. I was thinking about a three web server cluster connected 
> with a 1GB lan together, where server 1 operates as a lightweight reverse 
> proxy / static webserver / buffer for dynamic content, server 2 with lots of 
> memory serving dynamic content from the OI backend and server 3 as the mysql 
> database server with fast IO access. If I need load balancing I could add 
> more servers that generate dynamic content. 
This sounds reasonable. We use a setup, where both front and backend
httpd are on the same host, because we thought the local throughput
might be worth it. Also, since we serve multiple applications on this
site, we wanted to be able to route some apps to special servers for
processing - but this was never needed, except for debugging. We had
some problems on the Oracle side ( now we replace Oracle ;-) )
> 
> I'm going to run several these kind of setups serving each up to 3000 users.
Whoa - this is interesting and like lots of fun ;-)

...
> More like 2.6 GHz P4 =) The speed problems I have had so far are about SPOPS 
> security checking when fetching lots of data and from several different 
> tables. Turning off object security and using handler security instead sure 
> speeds things a lot.
Did you already try? 
> 
> > Since I am curious: what type of app are you thinking about ?
> 
> What I have built so far is a school (student) management system. Some 
> screenshots here (shots in finnish, sorry): http://www.mimerdesk.org/RX/oi/
Although I did not understand a word ( only finish I know is from my
stay in the US with 16 years of age, where a girl from Pori tought me
minarakastanasinua ). We are thinking about a callcenter staffing tool (
only prototypes so far ), and this looks similar, but grown up.
> 
> The next application I'm building at the moment is a collaborative learning 
> environment. You could compare such systems to groupware solutions to get an 
> idea how heavy the application will be.
Sounds really interesting.
> 
> These applications will be available under the GPL once we have the first 
> public versions ready.
even better. We have problems making documentation good enough to
publish some apps - time is to scarce...
> 
> Special technical details are the XHTML interface with complete layout control 
> through CSS and modified OI themes. The templates we created for the XHTML 
> are very generic and allow object oriented approach to web interface design 
> (especially useful with some programmers who don't understand how to create 
> good user interfaces =) ). We have built an object oriented "Tool" library 
> which in the end outputs data structures to be passed for template toolkit, 
> which produces the resulting XHTML pages. The system allows creating web 
> pages through an object oriented interface similar to Tk/GTK etc. you use to 
> build desktop applications. No HTML or anything involved in creating the 
> interface.
I`d like to see the results - sounds like a solid promising approach !
> 
> The benefit in the above example (see link) is that we didn't have to write 
> templates for any of the applications we created. We programmers used the 
> code to generate tools, the designers optimized the presentation. Everything 
> looks uniform. Once we had the interface framework ready we didn't have to 
> control layout at all or touch the templates. It was pretty nice to write a 
> new application and when you call $R->template->handler that's it. No 
> presentation to worry about.
I like code that can be deleted, because some intelligent code does
things behind the scenes!
> 
> The disadvantage was that the number of TT templates used on each page was 
> relatively big (average was something like 100), so generating the page had a 
> slight performance hit despite the TT precompiling abilities. We decided to 
> heavily use OI page caching features. Still miss the ability to clear cache 
> for a different handler output.
If you have enough RAM: the amount of cached TTs is tunable somewhere in
the code. I think it was in OpenInteract::Template
> 
> Another thing we are working on is a localization system that allows 
> translations to be stored separately. We probably use the standard unix 
> gettext and .po files for translations and hook that into OpenInteract.

Just a note: there are ideas in OI2 for this.

Re: [Openinteract-help] Bulk SPOPS security checks?

[Teemu <te...@io...>]

Dear Andreas,

> we use a cluster of two dual athlon servers for the webservers ( which
> do loadleveling), with one large mysql for most databases, but also a
> Netware cluster for LDAP and fileservices ( the HTML and perl files are
> pulled in via NFS ) and a few oracle and ms-sql databases. This serves
> up 1000 Intranet users. But this is not a regular internet website type
> of usage, but at least 200 users are using this as their main callcenter
> application, so the OI applications are rather heavy weight.

Ok, good to hear. I was thinking about a three web server cluster connected 
with a 1GB lan together, where server 1 operates as a lightweight reverse 
proxy / static webserver / buffer for dynamic content, server 2 with lots of 
memory serving dynamic content from the OI backend and server 3 as the mysql 
database server with fast IO access. If I need load balancing I could add 
more servers that generate dynamic content. 

I'm going to run several these kind of setups serving each up to 3000 users.

> Remember the most important tuning rule here: keep your systems from
> swapping ! ( under Linux install sysstat package, have sac runnig and
> use sar -r, here you should never see more then a few % of swapping. If
> you really want to make it fast, keep the system from swapping more than
> 1 % constantly - 30/40 % constant swapping is already overkill ! )

Good to know. I was also thinking about using a fast journaling filesystem for 
databases and cache. Also there are performance reasons why to use the 
reverse proxy strategy described above.

> You should not worry about this ! ( If you are not using a 486-SX 25 MHz
> ;-) )

More like 2.6 GHz P4 =) The speed problems I have had so far are about SPOPS 
security checking when fetching lots of data and from several different 
tables. Turning off object security and using handler security instead sure 
speeds things a lot.

> Since I am curious: what type of app are you thinking about ?

What I have built so far is a school (student) management system. Some 
screenshots here (shots in finnish, sorry): http://www.mimerdesk.org/RX/oi/

The next application I'm building at the moment is a collaborative learning 
environment. You could compare such systems to groupware solutions to get an 
idea how heavy the application will be.

These applications will be available under the GPL once we have the first 
public versions ready.

Special technical details are the XHTML interface with complete layout control 
through CSS and modified OI themes. The templates we created for the XHTML 
are very generic and allow object oriented approach to web interface design 
(especially useful with some programmers who don't understand how to create 
good user interfaces =) ). We have built an object oriented "Tool" library 
which in the end outputs data structures to be passed for template toolkit, 
which produces the resulting XHTML pages. The system allows creating web 
pages through an object oriented interface similar to Tk/GTK etc. you use to 
build desktop applications. No HTML or anything involved in creating the 
interface.

The benefit in the above example (see link) is that we didn't have to write 
templates for any of the applications we created. We programmers used the 
code to generate tools, the designers optimized the presentation. Everything 
looks uniform. Once we had the interface framework ready we didn't have to 
control layout at all or touch the templates. It was pretty nice to write a 
new application and when you call $R->template->handler that's it. No 
presentation to worry about.

The disadvantage was that the number of TT templates used on each page was 
relatively big (average was something like 100), so generating the page had a 
slight performance hit despite the TT precompiling abilities. We decided to 
heavily use OI page caching features. Still miss the ability to clear cache 
for a different handler output.

Another thing we are working on is a localization system that allows 
translations to be stored separately. We probably use the standard unix 
gettext and .po files for translations and hook that into OpenInteract.

-- 
Sincerely,

Teemu Arina

Ionstream Oy / Dicole
Komeetankuja 4 A
02210 Espoo
FINLAND
Tel: +358-(0)50 - 555 7636
http://www.dicole.fi
http://www.palaveriaika.com

Re: [Openinteract-help] Bulk SPOPS security checks?

[Andreas N. <an...@kl...>]

On Tue, 2003-11-18 at 13:03, Teemu Arina wrote:
> > Both methods described above are performant and stable. Method 2 is
> > cleaner and should be preferred, if possible.
> 
> Hi Andreas,
> 
> do you have any other good advices based on your experience how to make
> OpenInteract+SPOPS perform better? How many concurrent users you have run
> on a single server without problems?
Hi Teemu, 

we use a cluster of two dual athlon servers for the webservers ( which
do loadleveling), with one large mysql for most databases, but also a
Netware cluster for LDAP and fileservices ( the HTML and perl files are
pulled in via NFS ) and a few oracle and ms-sql databases. This serves
up 1000 Intranet users. But this is not a regular internet website type
of usage, but at least 200 users are using this as their main callcenter
application, so the OI applications are rather heavy weight.
> For example, if I run several websites, should I use a separate apache
> process for each one of them or should I run them on the same server with
> the stash trick?
You should separate them, I guess. If this is smallscale stuff, then
keep the spawn server settings etc. low. 

Remember the most important tuning rule here: keep your systems from
swapping ! ( under Linux install sysstat package, have sac runnig and
use sar -r, here you should never see more then a few % of swapping. If
you really want to make it fast, keep the system from swapping more than
1 % constantly - 30/40 % constant swapping is already overkill ! )
> I'm building a quite heavy application with OI and I'm a little bit
> concerned about the speed when we have something like 100 concurrent
> users.
You should not worry about this ! ( If you are not using a 486-SX 25 MHz
;-) )

Since I am curious: what type of app are you thinking about ? 

later,

Andreas

PS: this is my private eMail, the other one is my business eMail..

Re: [Openinteract-help] Package 'hooks'

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

Stathy G. Touloumis wrote:
> I was wondering open_interact has built in support for packages 
> interacting with each other.  More specifically I would like to add 
> 'links' to the 'box' of one application from another application.  This 
> would be similar to how you can do this with boxes in general.

Nothing is built-in. Packages communicate with each other like 
everything else in OI, through common names of registered 
components. This is normally seen in two ways:

  - SPOPS object name-to-class mappings
    1.x: my $object_class = $R->object_name
    2.x: my $object_class = CTX->lookup_object( 'object_name' )

  - Action handler name-to-class mappings
    1.x: my $action_info_hash =
             $R->lookup_action( 'action_name',
                                { return => 'info } );
    1.x: my ( $action_class, $method ) =
             $R->lookup_action( 'action_name' );
    2.x: my $action_obj = CTX->lookup_action( 'action_name' );
         my $action_name = CTX->lookup_action_name( 'url' );
         my $action_info_hash =
             CTX->lookup_action_info( 'action_name' );

In 1.x you can also use $R to pass around information as 
necessary. It's a little hackish (that is, not built-in) but it's 
fairly easy to do, and all your packages need to agree on is what 
name to use ('tmp_box_links' in the example below). For instance, 
in your box handler you could have:

sub handler {
     my ( $class, $params ) = @_;

     # These are the links used in the box call
     my $my_links    = $params->{links} || [];

     # These are the links added by other people
     my $other_links = $R->{tmp_box_links} || [];

     my @all_links = ( @{ $my_links }, @{ $other_links } );
     return $R->template->handler(
       {}, { links => \@all_links }, { name => 'mypkg::tmpl' } );
}

Since OI 2.x represents all actions, including boxes, as objects 
you can store state in them from anywhere you wish. Much more 
flexible.

Hope this helps,

Chris

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

Re: [Openinteract-help] Bulk SPOPS security checks?

[Teemu A. <te...@io...>]

> Both methods described above are performant and stable. Method 2 is
> cleaner and should be preferred, if possible.

Hi Andreas,

do you have any other good advices based on your experience how to make
OpenInteract+SPOPS perform better? How many concurrent users you have run
on a single server without problems?
For example, if I run several websites, should I use a separate apache
process for each one of them or should I run them on the same server with
the stash trick?
I'm building a quite heavy application with OI and I'm a little bit
concerned about the speed when we have something like 100 concurrent
users.
-- 
Sincerely,

Teemu Arina

Ionstream Oy / Dicole
Komeetankuja 4 A
02210 Espoo
FINLAND
Tel: +358-(0)50 - 555 7636
http://www.dicole.fi
http://www.mimerdesk.org

AW: [Openinteract-help] Bulk SPOPS security checks?

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

Hi Simon,

This is a problem, which we tackled with the following 2 methods:

- using security with skip_security
This one sounds weird, but it works. The idea is, to issue the =
fetch_group
with the skip_security=3D1 parameter and instead join in the security =
table
with the appropriate object_class and object_id params. Here, only one
select is done and only one fetch. Works like it should

- using handler security and a config table
Here, we are only using SPOPS for security to the handler, not the
application data . This is then done within the app itself. To make =
this
easy to configure, we sometimes use a configuration table ( limited =
amount
of entries ), with standard SPOPS security on. Before the select on the
application data is issued, you make a standard fetch_group on the =
config
table and get the information you need to fetch only the data from the
application data tables, which the user may see.

In general, SPOPS is great for small tables, but the more data and the =
more
groups you have, it finds breaks performance in standard mode.

Both methods described above are performant and stable. Method 2 is =
cleaner
and should be preferred, if possible.

Later,

Andreas

-----Urspr=FCngliche Nachricht-----
Von: Chris Winters [mailto:ch...@cw...]=20
Gesendet: Dienstag, 11. November 2003 00:19
An: Vsevolod (Simon) Ilyushchenko
Cc: ope...@li...
Betreff: Re: [Openinteract-help] Bulk SPOPS security checks?


* Vsevolod (Simon) Ilyushchenko (si...@cs...) [031110 17:59]:
> I noticed that SPOPS security is invoked by retrieving the object=20
> first
> and checking its security later. Is there a way to shift the security =

> checks down to the SQL level so that only objects readable by the=20
> current user are selected from the database?

The folks at bertelsmann implemented something like this. Andreas?

Chris

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


-------------------------------------------------------
This SF.Net email sponsored by: ApacheCon 2003,
16-19 November in Las Vegas. Learn firsthand the latest developments in
Apache, PHP, Perl, XML, Java, MySQL, WebDAV, and more!
http://www.apachecon.com/ =
_______________________________________________
openinteract-help mailing list ope...@li...
https://lists.sourceforge.net/lists/listinfo/openinteract-help

[Openinteract-help] Package 'hooks'

[Stathy G. T. <st...@ed...>]

I was wondering open_interact has built in support for packages interacting 
with each other.  More specifically I would like to add 'links' to the 
'box' of one application from another application.  This would be similar 
to how you can do this with boxes in general.

Thanks,

Re: [Openinteract-help] Relationship config

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

Stathy G. Touloumis wrote:
> So would you recommend rolling my own relationship config to prevent 
> upgrade conflicts?  Are there samples or code I could be pointed to for 
> doing this in the SPOPS config?

I'm going to put out SPOPS 0.80 shortly (next day or two). But 
the configuration will look like this:

  # old way, still works
  links_to => { 'Other::Object' => 'link_table' },

  # optional new way
  links_to => { 'Other::Object' =>
                    { table         => 'link_table',
                      to_id_field   => 'my_id',
                      from_id_field => 'your_id',
                      alias         => 'othername' },
   },

If you look in CVS you can see the docs for this:

http://cvs.sourceforge.net/viewcvs.py/spops/SPOPS/doc/Manual/Relationships.pod?rev=3.2&view=auto

Chris

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

[Openinteract-help] Relationship config

[Stathy G. T. <st...@ed...>]

So would you recommend rolling my own relationship config to prevent 
upgrade conflicts?  Are there samples or code I could be pointed to for 
doing this in the SPOPS config?

Thanks,

>>In a 'links-to' relationship is it possible to specify the id field of 
>>the linking table as is possible in a 'has-a' relationship?
>
>Not right now. It's a fairly easy add, so I'll do so for 0.80. (The whole 
>configuration for relationships is a mess tho, and may be seriously 
>revamped in the future...)

Re: [Openinteract-help] Per-field permissions in SPOPS?

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

Stathy G. Touloumis wrote:
> In a 'links-to' relationship is it possible to specify the id field of 
> the linking table as is possible in a 'has-a' relationship?

Not right now. It's a fairly easy add, so I'll do so for 0.80. 
(The whole configuration for relationships is a mess tho, and may 
be seriously revamped in the future...)

Chris

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

Re: [Openinteract-help] My::CommonResources?

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

Vsevolod (Simon) Ilyushchenko wrote:
> I am going through the users and groups example in SPOPS/eg (version 
> 0.79). However, the *.pm files in eg/My refer to My::CommonResources 
> which is not included in the discribution. Is it a bug or a feature?

Definitely a bug. It's attached, you should be able to just drop 
it into the eg/My/ directory. Sorry for the trouble.

Chris

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

[Openinteract-help] My::CommonResources?

[Vsevolod (S. I. <si...@cs...>]

Hi again,

I am going through the users and groups example in SPOPS/eg (version 
0.79). However, the *.pm files in eg/My refer to My::CommonResources 
which is not included in the discribution. Is it a bug or a feature?

Thanks,
Simon
-- 

Simon (Vsevolod ILyushchenko)   si...@cs...
				http://www.simonf.com

America's business leaders simply don't want to think
about complex technology issues - they want to think
about golf. Microsoft promises them that.
			Andrew Grygus, www.aaxnet.com

Re: [Openinteract-help] Per-field permissions in SPOPS?

[Stathy G. T. <st...@ed...>]

In a 'links-to' relationship is it possible to specify the id field of the 
linking table as is possible in a 'has-a' relationship?

Re: [Openinteract-help] Bulk SPOPS security checks?

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

* Vsevolod (Simon) Ilyushchenko (si...@cs...) [031110 17:59]:
> I noticed that SPOPS security is invoked by retrieving the object first 
> and checking its security later. Is there a way to shift the security 
> checks down to the SQL level so that only objects readable by the 
> current user are selected from the database?

The folks at bertelsmann implemented something like this. Andreas?

Chris

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

[Openinteract-help] Bulk SPOPS security checks?

[Vsevolod (S. I. <si...@cs...>]

Hi,

(I guess, Hi, Chris :)

I noticed that SPOPS security is invoked by retrieving the object first 
and checking its security later. Is there a way to shift the security 
checks down to the SQL level so that only objects readable by the 
current user are selected from the database?

Thanks,
Simon
-- 

Simon (Vsevolod ILyushchenko)   si...@cs...
				http://www.simonf.com

America's business leaders simply don't want to think
about complex technology issues - they want to think
about golf. Microsoft promises them that.
			Andrew Grygus, www.aaxnet.com

Re: [Openinteract-help] Per-field permissions in SPOPS?

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

* Vsevolod (Simon) Ilyushchenko (si...@cs...) [031107 14:27]:
> 	
> >One separate thing to think about -- model groups of fields in the
> >same DB record as separate objects. You can do this by  specifying the
> >'field' elements for only certain parts of the object in each class.
> 
> Chris,
> 
> Never mind my request - I think I get it. But this won't work together 
> with field_discover, right?

Correct. You'd have to specify the fields manually. Fortunately this
is a one-time operation :-)

Chris

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

Re: [Openinteract-help] Per-field permissions in SPOPS?

[Vsevolod (S. I. <si...@cs...>]

	
> One separate thing to think about -- model groups of fields in the
> same DB record as separate objects. You can do this by  specifying the
> 'field' elements for only certain parts of the object in each class.

Chris,

Never mind my request - I think I get it. But this won't work together 
with field_discover, right?

Simon
-- 

Simon (Vsevolod ILyushchenko)   si...@cs...
				http://www.simonf.com

America's business leaders simply don't want to think
about complex technology issues - they want to think
about golf. Microsoft promises them that.
			Andrew Grygus, www.aaxnet.com

Re: [Openinteract-help] Per-field permissions in SPOPS?

[Vsevolod (S. I. <si...@cs...>]

Chris,

Thanks for the answer.

> I've actually actively campaigned *against* this. I had a bad
> experience with this about five years ago and (possibly) never
> recovered. IME if you're doing field-level security it's probably
> better to split off certain fields into separate objects.

This will probably work for me.

> One separate thing to think about -- model groups of fields in the
> same DB record as separate objects. You can do this by  specifying the
> 'field' elements for only certain parts of the object in each class.
> 
> Hope this makes sense,

Sorry, the last advice does not - I am pretty new to SPOPS. Can you give 
me a short example?

Thanks,
Simon
-- 

Simon (Vsevolod ILyushchenko)   si...@cs...
				http://www.simonf.com

America's business leaders simply don't want to think
about complex technology issues - they want to think
about golf. Microsoft promises them that.
			Andrew Grygus, www.aaxnet.com

Re: [Openinteract-help] Per-field permissions in SPOPS?

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

* Vsevolod (Simon) Ilyushchenko (si...@cs...) [031106 16:22]:
> Has anyone tried to implement in SPOPS giving different users different 
> write permissions on different fields. Say, if we have a table of 
> employees, a) the owner of each record is allowed to update his phone 
> number, b) people in HR are allowed to update most other fields, but c) 
> no one is allowed to update the employee number as it's autogenerated.

I've actually actively campaigned *against* this. I had a bad
experience with this about five years ago and (possibly) never
recovered. IME if you're doing field-level security it's probably
better to split off certain fields into separate objects.

Part of this is because it's a HUGE PITA for non=devlopers to maintain
the necessary security to make this happen. Another part is just
pragmatic -- it's a PITA to track this stuff. 

One separate thing to think about -- model groups of fields in the
same DB record as separate objects. You can do this by  specifying the
'field' elements for only certain parts of the object in each class.

Hope this makes sense,

Chris

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

[Openinteract-help] add users in desired groups and controll the actions based on the group

[Arva, A. <ar...@cs...>]

Hi Simon,

You can control what group a user belongs to and determine if the desired
action should be allowed to happen.

Adrian

[Openinteract-help] Per-field permissions in SPOPS?

[Vsevolod (S. I. <si...@cs...>]

Hi,

Has anyone tried to implement in SPOPS giving different users different 
write permissions on different fields. Say, if we have a table of 
employees, a) the owner of each record is allowed to update his phone 
number, b) people in HR are allowed to update most other fields, but c) 
no one is allowed to update the employee number as it's autogenerated.

I have not found anything like this in the code or in the mailing list 
archives. If this functionality is absent in SPOPS, but would be desired 
and easy to implement, I would not mind adding it.

The reason this came up is that in my web apps I try to be generic in 
how I translate HTML form fields into objects. For a given table, the 
form fields describing objects in this table have the same name as table 
column names. However, depending on who is logged in, not all fields 
should always be saved. This contradicts somewhat the idea of 
schema-independent persistent code, but I think it's necessary in the 
real world.

Thanks,
Simon
-- 

Simon (Vsevolod ILyushchenko)   si...@cs...
				http://www.simonf.com

America's business leaders simply don't want to think
about complex technology issues - they want to think
about golf. Microsoft promises them that.
			Andrew Grygus, www.aaxnet.com

Re: [Openinteract-help] sync-ing users on 2 machines

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

* Stathy G. Touloumis (st...@ed...) [031104 15:59]:
> I have created a custom theme which utilizes it's own base_main 
> template.  How do I pass data to this template when it gets called?  Is the 
> data passed to the calling template get passed on to the base_main template?

Add stuff to $R->{main_template_vars}, as in:

 $R->{main_template_vars}{current_weather} = 'Hurricane!';

And in your custom main template:

 The current weather: [% current_weather %]

See OpenInteract::UI::Main for details.

Chris

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

Re: [Openinteract-help] sync-ing users on 2 machines

[Stathy G. T. <st...@ed...>]

I have created a custom theme which utilizes it's own base_main 
template.  How do I pass data to this template when it gets called?  Is the 
data passed to the calling template get passed on to the base_main template?

Re: [Openinteract-help] sync-ing users on 2 machines

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

* Andrew Hurst (hur...@ll...) [031031 18:34]:
> So you want to migrate the users only?  I assumed you wanted to 
> mirror the whole database...
> 
> For users only, I'm not sure.  I'm cc'ing this back to the 
> openinteract-help list so someone more knowledgeable (Chris) can 
> clear that up.

** Adrian Arva wrote:
> >that would be the easy way, proovided that
> >there are not other tables that I would have to update based on user ids 
> >and
> >groups and other settings.
> >Actually my question is at this level: to import the user from one set-up 
> >to
> >another one (let's assume I have two OI sites siteA on machineA and siteB 
> >on
> >machineB) do I have to take care of something else than just the sys_user
> >sys_group tables?
> >Do I have to update other tables too?

I'm not sure why you'd just want to update the user tables, but off
the top of my head you should just need to update:

 sys_user
 sys_group
 sys_group_user

Periodically dumping the database and scp'ing that to the remote
machine will probably do the trick for quick-n-dirty replication as
well, depending on how big your site is. The best possibility is to
rely on whatever the database may use for replication, leaving out
frequently-updated tables like 'sessions'.

Chris

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

RE: [Openinteract-help] sync-ing users on 2 machines

[Andrew H. <hur...@ll...>]

So you want to migrate the users only?  I assumed you wanted to 
mirror the whole database...

For users only, I'm not sure.  I'm cc'ing this back to the 
openinteract-help list so someone more knowledgeable (Chris) can 
clear that up.

-Andrew

>that would be the easy way, proovided that
>there are not other tables that I would have to update based on user ids and
>groups and other settings.
>Actually my question is at this level: to import the user from one set-up to
>another one (let's assume I have two OI sites siteA on machineA and siteB on
>machineB) do I have to take care of something else than just the sys_user
>sys_group tables?
>Do I have to update other tables too?
>
>thanks for helping,
>Adrian
>
>_____________________________________________________
>Adrian Arva
>Dolan DNA Learning Center
>phone (5196)
>http://www.dnalc.org/
>
>
>-----Original Message-----
>From: Andrew Hurst [mailto:hur...@ll...]
>Sent: Friday, October 31, 2003 6:12 PM
>To: Arva, Adrian; 'ope...@li...'
>Subject: Re: [Openinteract-help] sync-ing users on 2 machines
>
>
>
>
>Assuming you're using mysql, why not just nightly run a mysqldump job
>to update the standby server?
>
>(on standby server)
>$ mysqldump -u backup_user -h prod_host -p prod_database > backup_db.sql
>$ mysql -u backup_user -h backup_host -p backup_database < backup-db.sql
>
>You could even run that hourly, but I'm not sure of the affect of
>that on site performance.  I'm sure it depends on the size of the
>database.
>
>Or you could use mysql replication, which I think slashdot uses to good
>effect.
>
>Or you could use Oracle, which provides standby functionality out of
>the box for 8i and up.
>
>I think the first would be best for most small to mid-size sites.
>
>-Andrew
>
>
>At 3:54 PM -0500 10/31/03, Arva, Adrian wrote:
>>Hi,
>>
>>I have to systems, based on OI1, set up and the second one should act as
>>standby server.
>>But that means I would need to be able to mirror the users I have in first
>>system to the second one.
>>I let users register, so on a daily basis I would have to mirror their data
>>from the live site to the standby one but
>>I am worried that it won't be enough to just simply sync the sys_user
>>tables.
>>
>>Thanks for your inputs,
>>Adrian
>>
>>
>>
>>
>>-------------------------------------------------------
>>This SF.net email is sponsored by: SF.net Giveback Program.
>>Does SourceForge.net help you be more productive?  Does it
>>help you create better code?   SHARE THE LOVE, and help us help
>>YOU!  Click Here: http://sourceforge.net/donate/
>>_______________________________________________
>>openinteract-help mailing list
>>ope...@li...
>>https://lists.sourceforge.net/lists/listinfo/openinteract-help