Menu
▾
▴
sql-ledger-users
|
From: Noel C. <NO...@mi...> - 2001-08-11 00:21:03
|
Hi, I think I have successfully installed sql ledger and required components. In the readme under SETUP A DATABASE AND THE TABLES there is an instruction to select the Database Administration link.. I don't see that link. I created a user and filled in the relevant information, dbname port etc, I manually created a database at the command line that I referenced here. Regarding the tables in the database, do I need to create these manually too, or does the script do this? Apologies if I am missing something obvious here. Thanks Noel Running Redhat Linux 7.0 P.S. Login works fine, but selecting links on the left results in errors. There are no tables in the database to query, so this is predictable I guess. eg ERROR: Relation 'chart' does not exist SELECT accno, description FROM chart WHERE link LIKE '%CT_tax%' AND chart.id = tax.chart_id ORDER BY accno |
|
From: Dieter S. <dsi...@sq...> - 2001-08-11 00:39:41
|
The README file in the doc section has the right info. schema scripts are in the sql directory. to setup the tables $ psql dbname < acc-Pg.sql Dieter Simader http://www.sql-ledger.org (780) 472-8161 DWS Systems Inc. Accounting Software Fax: 478-5281 =========== On a clear disk you can seek forever =========== On Sat, 11 Aug 2001, Noel Cordell wrote: > Hi, > > I think I have successfully installed sql ledger and required > components. > > In the readme under SETUP A DATABASE AND THE TABLES there is an > instruction to select the Database Administration link.. I don't see > that link. I created a user and filled in the relevant information, > dbname port etc, I manually created a database at the command line that > I referenced here. > > Regarding the tables in the database, do I need to create these manually > too, or does the script do this? > > Apologies if I am missing something obvious here. > > Thanks > > Noel Running Redhat Linux 7.0 > > P.S. Login works fine, but selecting links on the left results in > errors. There are no tables in the database to query, so this is > predictable I guess. > > eg > ERROR: Relation 'chart' does not exist SELECT accno, description FROM > chart WHERE link LIKE '%CT_tax%' AND chart.id = tax.chart_id ORDER BY > accno > > > > > > > |
|
From: Noel C. <NO...@mi...> - 2001-08-11 07:16:32
|
well... that worked .. I printed the readme off the website which is a little different to the one in ./sql-ledger/docs Thanks for the quick response Dieter. ----- Original Message ----- From: "Dieter Simader" <dsi...@sq...> To: <sql...@li...> Sent: Saturday, August 11, 2001 10:09 AM Subject: Re: newbie question > The README file in the doc section has the right info. > > schema scripts are in the sql directory. > > to setup the tables > > $ psql dbname < acc-Pg.sql > > > Dieter Simader http://www.sql-ledger.org (780) 472-8161 > DWS Systems Inc. Accounting Software Fax: 478-5281 > =========== On a clear disk you can seek forever =========== > > On Sat, 11 Aug 2001, Noel Cordell wrote: > > > Hi, > > > > I think I have successfully installed sql ledger and required > > components. > > > > In the readme under SETUP A DATABASE AND THE TABLES there is an > > instruction to select the Database Administration link.. I don't see > > that link. I created a user and filled in the relevant information, > > dbname port etc, I manually created a database at the command line that > > I referenced here. > > > > Regarding the tables in the database, do I need to create these manually > > too, or does the script do this? > > > > Apologies if I am missing something obvious here. > > > > Thanks > > > > Noel Running Redhat Linux 7.0 > > > > P.S. Login works fine, but selecting links on the left results in > > errors. There are no tables in the database to query, so this is > > predictable I guess. > > > > eg > > ERROR: Relation 'chart' does not exist SELECT accno, description FROM > > chart WHERE link LIKE '%CT_tax%' AND chart.id = tax.chart_id ORDER BY > > accno > > > > > > > > > > > > > > > > |
|
From: Nicolas L. <nla...@pe...> - 2001-08-13 16:31:20
|
I was wondering if i can use miniserv to run sql-ledger? I have had numerous problems installing sql-ledger and have yet to get it working. dnhttpd.pl creates many zombie processes and it was suggested by the admin to look into using miniserv. Thanks, Nick |
|
From: Dieter S. <dsi...@sq...> - 2001-08-13 17:17:13
|
Any web server capable of running perl scripts should work.
here is a fix for the zombie processes.
edit dnhttpd.pl
after $SIG{HUP} = \&recompile;
add
$SIG{CHLD} = IGNORE;
Dieter Simader http://www.sql-ledger.org (780) 472-8161
DWS Systems Inc. Accounting Software Fax: 478-5281
=========== On a clear disk you can seek forever ===========
On Mon, 13 Aug 2001, Nicolas Lafferty wrote:
> I was wondering if i can use miniserv to run sql-ledger? I have had numerous
> problems installing sql-ledger and have yet to get it working. dnhttpd.pl
> creates many zombie processes and it was suggested by the admin to look into
> using miniserv.
>
> Thanks,
>
> Nick
>
>
>
|
|
From: Kal K. <lan...@cy...> - 2001-08-11 00:48:59
|
Kal Kolberg wrote: > Instead of login.pl use admin.pl to set up your users, reply back if you > are > still having problems. > > Lando > > Noel Cordell wrote: > > > Hi, > > > > I think I have successfully installed sql ledger and required > > components. > > > > In the readme under SETUP A DATABASE AND THE TABLES there is an > > instruction to select the Database Administration link.. I don't see > > that link. I created a user and filled in the relevant information, > > dbname port etc, I manually created a database at the command line that > > I referenced here. > > > > Regarding the tables in the database, do I need to create these manually > > too, or does the script do this? > > > > Apologies if I am missing something obvious here. > > > > Thanks > > > > Noel Running Redhat Linux 7.0 > > > > P.S. Login works fine, but selecting links on the left results in > > errors. There are no tables in the database to query, so this is > > predictable I guess. > > > > eg > > ERROR: Relation 'chart' does not exist SELECT accno, description FROM > > chart WHERE link LIKE '%CT_tax%' AND chart.id = tax.chart_id ORDER BY > > accno |
|
From: keith <kei...@ba...> - 2004-01-16 05:00:14
|
How do I add AUD to the system? Keith |
|
From: keith <kei...@ba...> - 2004-01-16 05:25:33
|
For those who use pgsql update defaults set curr =3D 'AUD:USD:CAD:EUR' ; Keith ----- Original Message -----=20 From: keith=20 To: sql...@sq...=20 Sent: Friday, January 16, 2004 3:56 PM Subject: [SL] newbie question How do I add AUD to the system? Keith |
Thanks for helping keep SourceForge clean.
X