Re: [SL] (no subject)

[Hugh E. <he...@re...>]

And more to the point of your question I think, once you have created the pg user sql-ledger and given it the ability to create databases, you can handle all the other steps from within the sql-ledger browser admin.pl interface.  SL users are distinct from postgres users are distinct from system users.  An SL user is associated with one and only one SL dataset.  

-- Hugh 

On Mon, 17 Oct 2005 11:08:38 -0400
"James P. Kinney III" <jk...@lo...> wrote:

> You can use the same postgresql user for all datasets. The sql-ledger
> user determines which dataset is being accessed.
> 
> Create a dataset for your real stuff (called businessname) and then
> create a dataset fro the test stuff called businessname-test.
> 
> Now create a sql-ledger user that will access businessname and another
> to access businessname-test. 
> 
> On Mon, 2005-10-17 at 11:26 +0200, Colin Raven wrote:
> > Greetings all,
> > I just installed 2.6.1 (via setup.pl) and got it up and running. It's on
> > a FreeBSD server in the house, which also handles mail etc, so the box
> > is visible to the world.
> > ---------------------------
> > 
> > Side note:
> > A most useful general tip BTW, is to *additionally* password protect the
> > entire sql-ledger directory using .htaccess.
> >  
> > More information on .htaccess protection, and how to implement it, can
> > be found here:
> > http://www.freewebmasterhelp.com/tutorials/htaccess/1
> > 
> > And additional reading here:
> > http://www.apacheweek.com/features/userauth
> > 
> > ---------------------------
> > 
> > OK my question concerns "datasets". In my scenario I intend to create a
> > valid company db *and* a test company. The purpose of the test company
> > is to create a valid environment to test stuff without risking actual
> > company data.
> > 
> > (I assume "dataset" in our context refers to a db populated with
> > necessary tables and skeleton data based on preferences)
> > 
> > My problem is that I cannot see how to easily create additional
> > datasets. 
> > Should I:
> > 1) create a db first in postgresql admin (webmin in this case) and then
> > go ahead and attempt to create a dataset? I ask this because I have one
> > (fairly obvious from the FAQ) user 'sql-ledger'...
> > Or should I: 
> > 2) create another db_user for the second dataset and *THEN* "Create
> > Dataset" in admin.pl? 
> > 
> > The README is sort of ambiguous on this point.
> > 
> > Sorry for the exceptionally basic nature of the questions, and TIA for
> > any advice and suggestions from the gurus. 
> > 
> > Regards,
> > -Colin
> > 
> > 
> > 
> > 
> > -------------------------------------------------------
> > This SF.Net email is sponsored by:
> > Power Architecture Resource Center: Free content, downloads, discussions,
> > and more. http://solutions.newsforge.com/ibmarch.tmpl
> > _______________________________________________
> > sql-ledger-users mailing list
> > sql...@li...
> > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> -- 
> James P. Kinney III          \Changing the mobile computing world/
> CEO & Director of Engineering \          one Linux user         /
> Local Net Solutions,LLC        \           at a time.          /
> 770-493-8244                    \.___________________________./
> http://www.localnetsolutions.com
> 
> GPG ID: 829C6CA7 James P. Kinney III (M.S. Physics)
> <jk...@lo...>
> Fingerprint = 3C9E 6366 54FC A3FE BA4D 0659 6190 ADC3 829C 6CA7
> 


-- 
--
Hugh Esco 
250-352-9361
he...@re...
RCK Computer Services 
http://reclaimedcomputers.ca/