[ale] any sql-ledger users out there?

[James P. Kinney III]

What version and what database? I use SL daily. The "sql-ledger" user
must be created first with "createuser" for postgresql. Initially, the
admin user has no password. There is no "main user". The sql-ledger user
is only the owner of the database schema. All access is controlled by SL
itself. In fact, the user sql-ledger should never be able to login to
the SL systems. It is just for DB access.

There are a few "gotcha's" in the new SL/Postgresql setup as PG changed
and dropped something Sl was using. It is noted in the installation
instructions.

Once inside the admin.pl page the admin password can be changed,
datasets can be created and then users can be created to use those
datasets.

If you loose the admin passsword, it can be blanked out in the <path to
SL>users/members file.

On Sun, 2006-03-12 at 13:43 -0500, Jim Philips wrote:
> I've been trying to give it a test run. but so far, getting through the 
> administration page has been a total nightmare. I can create the main user 
> "sql-ledger" and create a dataset on the admin pages. If I go to login as the 
> user "sql-ledger" all I get is "Access Denied". If I go back to the admin 
> pages and try to update the password for sql-ledger, I get:
> 
> Internal Server Error
> The server encountered an internal error or misconfiguration and was unable to 
> complete your request.
> 
> If I check the log for PostgreSQL, I see:
> 
> ERROR:  relation "employee" does not exist
> ERROR:  current transaction is aborted, commands ignored until end of 
> transaction block
> ERROR:  current transaction is aborted, commands ignored until end of 
> transaction block
> ERROR:  database "sql-ledger" already exists
> WARNING:  changing return type of function del_yearend from "opaque" to 
> "trigger"
> WARNING:  changing return type of function del_department from "opaque" to 
> "trigger"
> WARNING:  changing return type of function del_customer from "opaque" to 
> "trigger"
> WARNING:  changing return type of function del_vendor from "opaque" to 
> "trigger"
> WARNING:  changing return type of function del_exchangerate from "opaque" to 
> "trigger"
> WARNING:  changing return type of function check_inventory from "opaque" to 
> "trigger"
> WARNING:  changing return type of function check_department from "opaque" to 
> "trigger"
> WARNING:  changing return type of function del_recurring from "opaque" to 
> "trigger"
> 
> Apparently no database has been created. But that step is not covered well in 
> the Install document. I have tried to reach the sql-ledger mailing list, but 
> my e-mails there seem to go off into the ether (an e-mail from 1 PM yesterday 
> hasn't shown up yet).
> _______________________________________________
> Ale mailing list
> Ale at ale.org
> http://www.ale.org/mailman/listinfo/ale
-- 
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)
<jkinney at localnetsolutions.com>
Fingerprint = 3C9E 6366 54FC A3FE BA4D 0659 6190 ADC3 829C 6CA7
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 191 bytes
Desc: This is a digitally signed message part