sql-ledger-users — SQL-Ledger users

[SQL-Ledger-users] Database Design?

[Hal D. <ha...@fa...>]

Do many of us use pgaccess to modify and extend our PostgreSQL databases? If
not? then What are you using?

Well, reading the README file answered one of my nagging question on how to
'Auto Build' my PostgreSQL database tables and preload some default data.

My current Progress based project has over five-hundered tables with only eight
of which exceed a 35K schema size.

I was pleased to find in the PostgreSQL documentation the ability to create
fields as array. Really comes in handy for inventory MTD information,
general ledger bugetary data as well as payroll deductions and earnings options
for employees.

--Hal. 
===========================================================
Hal Davison		     Internet Petroleum  Gateway
Davison Consulting	       Caldera 2.2.14  eServer
6850 Myakka Valley Tr    PostgreSQL 7.03 - Sun Forte - JAVA
Sarasota, Florida 34241         Phone: (941) 921-6578
http://faams.net	         eFAX: (419) 821-5999
===========================================================

Re: [SQL-Ledger-users] Drop Column?

[Hal D. <ha...@fa...>]

On Thu, 15 Feb 2001, you wrote:
> Hal-
> 
> Thats okay, I like details :)
> 
> So are you looking to port the Progress 4GL product or enhance an existing
> product like SQL-Ledger to meet your requirements?
> 
> 11 taxes! Man, they get you coming, going, and every way in between!
> I was thinking about the taxes in SQL-Ledger, and to create a better,
> highly flexible system. I can't figure out a way to take in every tax
> possibility in a straight foward non-complex fashion. How do you handle
> it now?

Tom,

Prolly the best way for you to see how our excise taxes are structured is visit
my web thinggy at http://www.faams.net

There is an entire section devoted to the EXCISE Tax feature. This is a
presentation from a users point of view. If you would like further progromatic
detail and concepts, I can do that as well.

Should we take this discussion 'Off-List' or keep it here? Don't want to munge
the Signal/Noise ratio because I like everyone else am a guest here.


--Hal. 
===========================================================
Hal Davison		     Internet Petroleum  Gateway
Davison Consulting	       Caldera 2.2.14  eServer
6850 Myakka Valley Tr    PostgreSQL 7.03 - Sun Forte - JAVA
Sarasota, Florida 34241         Phone: (941) 921-6578
http://faams.net	         eFAX: (419) 821-5999
===========================================================

Re: [SQL-Ledger-users] Long time lurker...

[Hal D. <ha...@fa...>]

On Thu, 15 Feb 2001, you wrote:
> Hal Davison wrote:
> > 
> 
> 
> Dude,
> 
> I thought you had given up on this?
> 

Well kinda, sorta. I still need the experience and the interaction with other
PostgreSQL Gurus like yourself that have ALL the answers.

'Member, I'm just a babe in the woods when it comes to the SQL world..<<GRIN>>

You can see what we have already done with our Progress implementation of our
product at http://www.faams.net

The site if far from finizhed, but it will give you a rather simple overfiew of
the current deployed product.

--Hal.
==========================================================
Hal Davison		     Internet Petroleum  Gateway
Davison Consulting	       Caldera 2.2.14  eServer
6850 Myakka Valley Tr    PostgreSQL 7.03 - Sun Forte - JAVA
Sarasota, Florida 34241         Phone: (941) 921-6578
http://faams.net	         eFAX: (419) 821-5999
===========================================================

[SQL-Ledger-users] please cancel my subscription

[disley <di...@21...>]

DQo=

Re: [SQL-Ledger-users] Long time lurker...

[Designer <wir...@ta...>]

Hal Davison wrote:
> 


Dude,

I thought you had given up on this?

James



> Greetings !!
> 
> I've been a long time lurker and passive observer of this list.
> 
> Am at a point with my new server to begin the installation and adding ny $0.02
> worth to the project.
> 
> Current System:
>   Caldera Linux 2.2.14
>   Apache 1.3.9-4
>   Perl 5.005_03
>   PostgreSQL 7.0.3
> 
> What need to be upgraded, what are the available resources fro the upgrades?
> 
> --Hal.
> ===========================================================
> Hal Davison                  Internet Petroleum  Gateway
> Davison Consulting             Caldera 2.2.14  eServer
> 6850 Myakka Valley Tr    PostgreSQL 7.03 - Sun Forte - JAVA
> Sarasota, Florida 34241         Phone: (941) 921-6578
> http://faams.net                 eFAX: (419) 821-5999
> ===========================================================

Re: [SQL-Ledger-users] Drop Column?

[Thomas S. <ps...@on...>]

Hal-

Thats okay, I like details :)

So are you looking to port the Progress 4GL product or enhance an existing
product like SQL-Ledger to meet your requirements?

11 taxes! Man, they get you coming, going, and every way in between!
I was thinking about the taxes in SQL-Ledger, and to create a better,
highly flexible system. I can't figure out a way to take in every tax
possibility in a straight foward non-complex fashion. How do you handle
it now?

-- 
Thomas Sawyer
ps...@on... - email
(303) 285-3487 x1594 - voicemail/fax



---- Hal Davison <ha...@fa...> wrote:
> On Thu, 15 Feb 2001, you wrote:
> > Nice!
> > 
> > That's right, I remember now...Postgresql doesn't have a simple means
> > for dropping columns. I think you did the only thing you could do.
> This
> > transfers your data I take it? Hopefully this will be simplified
> in future
> > versions of Postgresql. By the way, what are you working on?
> > 
> Well,
> 
> I have a current product done in the Progress 4GL product(NON-SQL)
> with the
> servers running Caldera 2.3(2.2.14) boxes. Clients connect from Win95/98
> boxes
> by TCP/IP and NetTerm over 100BaseT networks.
> 
> The product is designed for petroleum and lubricant distribution jobbers
> including a 'BackOffice' package for their C-Stores.
> 
> I has all of the accounting packages including multi-state US payrolls.
> 
> This market is odd in that all unit pricing is done to 5 decimal places.
> On any
> particular invoice there could be as many as 11 different taxes that
> might have
> to be computed, added and displayed individually.
> 
> Moving to PostgreSQL so that we can use the various SQL report writers
> and the
> GUI garbage that the users think they want.
> 
> 
> Sorry for the long reply..:(
> 
> --Hal.  
> ===========================================================
> Hal Davison		     Internet Petroleum  Gateway
> Davison Consulting	       Caldera 2.2.14  eServer
> 6850 Myakka Valley Tr    PostgreSQL 7.03 - Sun Forte - JAVA
> Sarasota, Florida 34241         Phone: (941) 921-6578
> http://faams.net	         eFAX: (419) 821-5999
> ===========================================================
> 
> 

__________________________________________________
FREE voicemail, email, and fax...all in one place.
Sign Up Now! http://www.onebox.com

Re: [SQL-Ledger-users] Drop Column?

[Hal D. <ha...@fa...>]

On Thu, 15 Feb 2001, you wrote:
> Nice!
> 
> That's right, I remember now...Postgresql doesn't have a simple means
> for dropping columns. I think you did the only thing you could do. This
> transfers your data I take it? Hopefully this will be simplified in future
> versions of Postgresql. By the way, what are you working on?
> 
Well,

I have a current product done in the Progress 4GL product(NON-SQL) with the
servers running Caldera 2.3(2.2.14) boxes. Clients connect from Win95/98 boxes
by TCP/IP and NetTerm over 100BaseT networks.

The product is designed for petroleum and lubricant distribution jobbers
including a 'BackOffice' package for their C-Stores.

I has all of the accounting packages including multi-state US payrolls.

This market is odd in that all unit pricing is done to 5 decimal places. On any
particular invoice there could be as many as 11 different taxes that might have
to be computed, added and displayed individually.

Moving to PostgreSQL so that we can use the various SQL report writers and the
GUI garbage that the users think they want.


Sorry for the long reply..:(

--Hal.  
===========================================================
Hal Davison		     Internet Petroleum  Gateway
Davison Consulting	       Caldera 2.2.14  eServer
6850 Myakka Valley Tr    PostgreSQL 7.03 - Sun Forte - JAVA
Sarasota, Florida 34241         Phone: (941) 921-6578
http://faams.net	         eFAX: (419) 821-5999
===========================================================

Re: [SQL-Ledger-users] Drop Column?

[Thomas S. <ps...@on...>]

Nice!

That's right, I remember now...Postgresql doesn't have a simple means
for dropping columns. I think you did the only thing you could do. This
transfers your data I take it? Hopefully this will be simplified in future
versions of Postgresql. By the way, what are you working on?

-- 
Thomas Sawyer
ps...@on... - email
(303) 285-3487 x1594 - voicemail/fax



---- "Pati Davison" <pa...@se...> wrote:
> Well Tom,
> 
> Answer ain't there..but..did find:
> 
> SELECT (..All columns except the one that you drop...)
> INTO TABLE  tmp_name
> FROM old_table;
> DROP TABLE old_table;
> ALTER TABLE  tmp_table RENAME TO old_table;
> 
> This will do the trick..!!
> 
> 
> 
> ----- Original Message ----- 
> From: Thomas Sawyer <ps...@on...>
> To: <sql...@li...>
> Sent: Thursday, February 15, 2001 5:19 PM
> Subject: Re: [SQL-Ledger-users] Drop Column?
> 
> 
> | As the postgres user, run "psql". At the psql prompt type \h to see
> help.
> | type \h {command_name} to get more specific help.
> | 
> | -- 
> | Thomas Sawyer
> | ps...@on... - email
> | (303) 285-3487 x1594 - voicemail/fax
> | 
> | 
> | 
> | ---- Hal Davison <ha...@fa...> wrote:
> | > 
> | > If there is a column that one creates by mistake, what is the PostgeSQL
> | > function/command that is used to DROP the COLUNM?
> | > 
> | > 
> | > --Hal. 
> | > ===========================================================
> | > Hal Davison      Internet Petroleum  Gateway
> | > Davison Consulting        Caldera 2.2.14  eServer
> | > 6850 Myakka Valley Tr    PostgreSQL 7.03 - Sun Forte - JAVA
> | > Sarasota, Florida 34241         Phone: (941) 921-6578
> | > http://faams.net          eFAX: (419) 821-5999
> | > ===========================================================
> | > 
> | > 
> | 
> | __________________________________________________
> | FREE voicemail, email, and fax...all in one place.
> | Sign Up Now! http://www.onebox.com
> | 
> 
> 
> 

__________________________________________________
FREE voicemail, email, and fax...all in one place.
Sign Up Now! http://www.onebox.com

Re: [SQL-Ledger-users] Drop Column?

[Pati D. <pa...@se...>]

Well Tom,

Answer ain't there..but..did find:

SELECT (..All columns except the one that you drop...)
INTO TABLE  tmp_name
FROM old_table;
DROP TABLE old_table;
ALTER TABLE  tmp_table RENAME TO old_table;

This will do the trick..!!



----- Original Message ----- 
From: Thomas Sawyer <ps...@on...>
To: <sql...@li...>
Sent: Thursday, February 15, 2001 5:19 PM
Subject: Re: [SQL-Ledger-users] Drop Column?


| As the postgres user, run "psql". At the psql prompt type \h to see help.
| type \h {command_name} to get more specific help.
| 
| -- 
| Thomas Sawyer
| ps...@on... - email
| (303) 285-3487 x1594 - voicemail/fax
| 
| 
| 
| ---- Hal Davison <ha...@fa...> wrote:
| > 
| > If there is a column that one creates by mistake, what is the PostgeSQL
| > function/command that is used to DROP the COLUNM?
| > 
| > 
| > --Hal. 
| > ===========================================================
| > Hal Davison      Internet Petroleum  Gateway
| > Davison Consulting        Caldera 2.2.14  eServer
| > 6850 Myakka Valley Tr    PostgreSQL 7.03 - Sun Forte - JAVA
| > Sarasota, Florida 34241         Phone: (941) 921-6578
| > http://faams.net          eFAX: (419) 821-5999
| > ===========================================================
| > 
| > 
| 
| __________________________________________________
| FREE voicemail, email, and fax...all in one place.
| Sign Up Now! http://www.onebox.com
| 

Re: [SQL-Ledger-users] Drop Column?

[Thomas S. <ps...@on...>]

As the postgres user, run "psql". At the psql prompt type \h to see help.
type \h {command_name} to get more specific help.

-- 
Thomas Sawyer
ps...@on... - email
(303) 285-3487 x1594 - voicemail/fax



---- Hal Davison <ha...@fa...> wrote:
> 
> If there is a column that one creates by mistake, what is the PostgeSQL
> function/command that is used to DROP the COLUNM?
> 
> 
> --Hal. 
> ===========================================================
> Hal Davison		     Internet Petroleum  Gateway
> Davison Consulting	       Caldera 2.2.14  eServer
> 6850 Myakka Valley Tr    PostgreSQL 7.03 - Sun Forte - JAVA
> Sarasota, Florida 34241         Phone: (941) 921-6578
> http://faams.net	         eFAX: (419) 821-5999
> ===========================================================
> 
> 

__________________________________________________
FREE voicemail, email, and fax...all in one place.
Sign Up Now! http://www.onebox.com

[SQL-Ledger-users] Drop Column?

[Hal D. <ha...@fa...>]

If there is a column that one creates by mistake, what is the PostgeSQL
function/command that is used to DROP the COLUNM?


--Hal. 
===========================================================
Hal Davison		     Internet Petroleum  Gateway
Davison Consulting	       Caldera 2.2.14  eServer
6850 Myakka Valley Tr    PostgreSQL 7.03 - Sun Forte - JAVA
Sarasota, Florida 34241         Phone: (941) 921-6578
http://faams.net	         eFAX: (419) 821-5999
===========================================================

Re: [SQL-Ledger-users] Two Lists

[Matt B. <ma...@li...>]

I assume that means we could use a/the development list for sql-ledger, if
we do want to discuss development issues and exchange patches as
attachments?

The sourceforge Lists site for sql-ledger only shows the users list.  I'm
quite interested in having a development list, as well.


Matt


Matt Benjamin President/CTO

The Linux Box
206 South Fifth Ave. Suite 150
Ann Arbor, MI  48104

tel. 734-761-4689
fax. 734-769-8938
pgr. 734-431-0118

On Thu, 15 Feb 2001, Dieter Simader wrote:

> The users list is to help out others with the setup and use of sql-ledger.
>
> So, please keep development issues or sending code as attachments off the
> list.
>
>
> 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 Thu, 15 Feb 2001, Thomas Sawyer wrote:
>
> > Is there or should there be two mailing lists, perhaps?
> >
> > 1) general/newbie/user list
> >
> > 2) developer/documentor/bug-killer list
> >
> > Just a Thought.
> >
> > -Tom Sawyer
> > ps...@on...
> >
> >
> > __________________________________________________
> > FREE voicemail, email, and fax...all in one place.
> > Sign Up Now! http://www.onebox.com
> >
> >
> >
>
>
>

Re: [SQL-Ledger-users] Two Lists

[Dieter S. <dsi...@sq...>]

The users list is to help out others with the setup and use of sql-ledger.

So, please keep development issues or sending code as attachments off the
list.


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 Thu, 15 Feb 2001, Thomas Sawyer wrote:

> Is there or should there be two mailing lists, perhaps?
> 
> 1) general/newbie/user list
> 
> 2) developer/documentor/bug-killer list
> 
> Just a Thought.
> 
> -Tom Sawyer
> ps...@on...
> 
> 
> __________________________________________________
> FREE voicemail, email, and fax...all in one place.
> Sign Up Now! http://www.onebox.com
> 
> 
> 

RE: [SQL-Ledger-users] DBI::errstr

[Thomas S. <ps...@on...>]

Opps! Just noticed it should be:

  psql {database_name} < Pg-acc.sql

But I guess you probably caught that already.

-- 
Thomas Sawyer
ps...@on... - email
(303) 285-3487 x1594 - voicemail/fax



---- "Andreas Ott" <an...@sc...> wrote:
> Gee, how could I overlook this!!
> 
> I guess I have misinterpreted the docs at this point.
> 
> Thanks, Andreas
> 
> > -----Original Message-----
> > From: sql...@li...
> > [mailto:sql...@li...]On Behalf Of
> Thomas
> > Sawyer
> > Sent: Thursday, February 15, 2001 10:16 AM
> > To: sql...@li...
> > Subject: Re: [SQL-Ledger-users] DBI::errstr
> > 
> > 
> > did you run "psql < Pg-acc.sql" as the postgres user?
> > 
> > need to populate the database; pg-acc.sql is in /admin.
> > 
> > -- 
> > Thomas Sawyer
> > ps...@on... - email
> > (303) 285-3487 x1594 - voicemail/fax
> > 
> > 
> > 
> > ---- "Andreas Ott" <an...@sc...> wrote:
> > > Hello
> > > 
> > > I'm new to the list and new to sql-ledger. I managed to install
> 
> > sql-ledger,
> > > created a database in PostgreSQL, and I also created myself as
> a user
> > > in
> > > sql-ledger.
> > > But when I try to log on, I get a DBI::errstr error. In the error_log
> > > there's something about a missing table.
> > > Any ideas?
> > > 
> > > TIA,
> > > Andreas
> > > 
> > > 
> > > 
> > 
> > __________________________________________________
> > FREE voicemail, email, and fax...all in one place.
> > Sign Up Now! http://www.onebox.com
> > 
> > 
> 
> 

__________________________________________________
FREE voicemail, email, and fax...all in one place.
Sign Up Now! http://www.onebox.com

RE: [SQL-Ledger-users] DBI::errstr

[Andreas O. <an...@sc...>]

Gee, how could I overlook this!!

I guess I have misinterpreted the docs at this point.

Thanks, Andreas

> -----Original Message-----
> From: sql...@li...
> [mailto:sql...@li...]On Behalf Of Thomas
> Sawyer
> Sent: Thursday, February 15, 2001 10:16 AM
> To: sql...@li...
> Subject: Re: [SQL-Ledger-users] DBI::errstr
> 
> 
> did you run "psql < Pg-acc.sql" as the postgres user?
> 
> need to populate the database; pg-acc.sql is in /admin.
> 
> -- 
> Thomas Sawyer
> ps...@on... - email
> (303) 285-3487 x1594 - voicemail/fax
> 
> 
> 
> ---- "Andreas Ott" <an...@sc...> wrote:
> > Hello
> > 
> > I'm new to the list and new to sql-ledger. I managed to install 
> sql-ledger,
> > created a database in PostgreSQL, and I also created myself as a user
> > in
> > sql-ledger.
> > But when I try to log on, I get a DBI::errstr error. In the error_log
> > there's something about a missing table.
> > Any ideas?
> > 
> > TIA,
> > Andreas
> > 
> > 
> > 
> 
> __________________________________________________
> FREE voicemail, email, and fax...all in one place.
> Sign Up Now! http://www.onebox.com
> 
> 

[SQL-Ledger-users] Two Lists

[Thomas S. <ps...@on...>]

Is there or should there be two mailing lists, perhaps?

1) general/newbie/user list

2) developer/documentor/bug-killer list

Just a Thought.

-Tom Sawyer
ps...@on...


__________________________________________________
FREE voicemail, email, and fax...all in one place.
Sign Up Now! http://www.onebox.com

[SQL-Ledger-users] BUG

[Thomas S. <ps...@on...>]

Tracking down a bug. So far I've determined that there's something going
wrong with posting tax to the tax accounts. (Not with deleting after
all.)

My clients books are about $20 out of balance because no tax amounts
are there.

Will keep hunting.

P.S. Orders module is nearing completion.

-- 
Thomas Sawyer
ps...@on... - email
(303) 285-3487 x1594 - voicemail/fax


---- "Thomas Sawyer" <ps...@on...> wrote:
> I just found a bug with one of the delete routines. I don't know where
> it is exactly, but I went back and deleted all my dummy transactions
> in the A/R and the Accounts List got out of balance. Very bad :( Then
> I went and deleted all my A/P transaction so there should be nothing
> in the Accounts List at all (I did not enter any G/L) and what was
> left
> was some money in the tax account and in the A/R account. So this needs
> to be fixed real bad like.
> 
> -- 
> Thomas Sawyer
> ps...@on... - email
> 
> 
> __________________________________________________
> FREE voicemail, email, and fax...all in one place.
> Sign Up Now! http://www.onebox.com
> 
> 
> 

__________________________________________________
FREE voicemail, email, and fax...all in one place.
Sign Up Now! http://www.onebox.com

Re: [SQL-Ledger-users] DBI::errstr

[Thomas S. <ps...@on...>]

did you run "psql < Pg-acc.sql" as the postgres user?

need to populate the database; pg-acc.sql is in /admin.

-- 
Thomas Sawyer
ps...@on... - email
(303) 285-3487 x1594 - voicemail/fax



---- "Andreas Ott" <an...@sc...> wrote:
> Hello
> 
> I'm new to the list and new to sql-ledger. I managed to install sql-ledger,
> created a database in PostgreSQL, and I also created myself as a user
> in
> sql-ledger.
> But when I try to log on, I get a DBI::errstr error. In the error_log
> there's something about a missing table.
> Any ideas?
> 
> TIA,
> Andreas
> 
> 
> 

__________________________________________________
FREE voicemail, email, and fax...all in one place.
Sign Up Now! http://www.onebox.com

[SQL-Ledger-users] DBI::errstr

[Andreas O. <an...@sc...>]

Hello

I'm new to the list and new to sql-ledger. I managed to install sql-ledger,
created a database in PostgreSQL, and I also created myself as a user in
sql-ledger.
But when I try to log on, I get a DBI::errstr error. In the error_log
there's something about a missing table.
Any ideas?

TIA,
Andreas

[SQL-Ledger-users] Long time lurker...

[Hal D. <ha...@fa...>]

Greetings !!

I've been a long time lurker and passive observer of this list.

Am at a point with my new server to begin the installation and adding ny $0.02
worth to the project.

Current System:
  Caldera Linux 2.2.14
  Apache 1.3.9-4
  Perl 5.005_03
  PostgreSQL 7.0.3

What need to be upgraded, what are the available resources fro the upgrades?


--Hal.
===========================================================
Hal Davison		     Internet Petroleum  Gateway
Davison Consulting	       Caldera 2.2.14  eServer
6850 Myakka Valley Tr    PostgreSQL 7.03 - Sun Forte - JAVA
Sarasota, Florida 34241         Phone: (941) 921-6578
http://faams.net	         eFAX: (419) 821-5999
===========================================================

Re: [SQL-Ledger-users] internal error, but getting closer

[Steve D. <sd...@sw...>]

The Postgresql postmaster has to be started w/ the -i option to listen
on port 5432.  You may also have to edit your pg_hba.conf depending on
your system/network.

Open postgresql to the internet and you should be fine.
Steve

Richard Eicher II wrote:

> Ok I think I have this setup, but still have an
> internal error on the login.cgi. Here is the log
> for apache:
>
> [Mon Feb 12 20:38:20 2001] [error] [client
> 192.168.10.2] Premature end of script headers:
> /home/httpd/sql-ledger/login.cgi
> DBI->connect(dbname=account;host=localhost;port=5432)
> failed: PQconnectPoll() -- connect() failed:
> Connection refused
>         Is the postmaster running (with -i) at
> 'localhost'
>         and accepting connections on TCP/IP port '5432'?
>  at /home/httpd/sql-ledger/login.cgi line 66
> Can't call method "prepare" on an undefined value
> at /home/httpd/sql-ledger/login.cgi line 79.
> [Tue Feb 13 19:16:43 2001] [error] [client
> 192.168.10.2] Premature end of script headers:
> /home/httpd/sql-ledger/login.cgi
> DBI->connect(dbname=accounting;host=localhost;port=5432)
> failed: PQconnectPoll() -- connect() failed:
> Connection refused
>         Is the postmaster running (with -i) at
> 'localhost'
>         and accepting connections on TCP/IP port '5432'?
>  at /home/httpd/sql-ledger/login.cgi line 66
> Can't call method "prepare" on an undefined value
> at /home/httpd/sql-ledger/login.cgi line 79.
> [Tue Feb 13 19:19:15 2001] [error] [client
> 192.168.10.2] Premature end of script headers:
> /home/httpd/sql-ledger/login.cgi
>
> Am I close?
> rick
>
> __________________________________________________
> Do You Yahoo!?
> Get personalized email addresses from Yahoo! Mail - only $35
> a year!  http://personal.mail.yahoo.com/

[SQL-Ledger-users] internal error, but getting closer

[Richard E. II <win...@ya...>]

Ok I think I have this setup, but still have an
internal error on the login.cgi. Here is the log
for apache:

[Mon Feb 12 20:38:20 2001] [error] [client
192.168.10.2] Premature end of script headers:
/home/httpd/sql-ledger/login.cgi
DBI->connect(dbname=account;host=localhost;port=5432)
failed: PQconnectPoll() -- connect() failed:
Connection refused
	Is the postmaster running (with -i) at
'localhost'
	and accepting connections on TCP/IP port '5432'?
 at /home/httpd/sql-ledger/login.cgi line 66
Can't call method "prepare" on an undefined value
at /home/httpd/sql-ledger/login.cgi line 79.
[Tue Feb 13 19:16:43 2001] [error] [client
192.168.10.2] Premature end of script headers:
/home/httpd/sql-ledger/login.cgi
DBI->connect(dbname=accounting;host=localhost;port=5432)
failed: PQconnectPoll() -- connect() failed:
Connection refused
	Is the postmaster running (with -i) at
'localhost'
	and accepting connections on TCP/IP port '5432'?
 at /home/httpd/sql-ledger/login.cgi line 66
Can't call method "prepare" on an undefined value
at /home/httpd/sql-ledger/login.cgi line 79.
[Tue Feb 13 19:19:15 2001] [error] [client
192.168.10.2] Premature end of script headers:
/home/httpd/sql-ledger/login.cgi

Am I close?
rick

__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35 
a year!  http://personal.mail.yahoo.com/

Re: [SQL-Ledger-users] Internal error?

[Hernan L. C. <hl...@co...>]

Hi all!

El Mar 13 Feb 2001 13:26, Thomas Sawyer escribi=F3:
> First off, what Distribution of Linux are you using? I had the worst
> time trying to get mine to work under Mandrake 7.1 (99% Red Hat) and
> fianlly gave it up. I switched to Debian. Thank God for APT! Now instal=
ling
> new packages is as easy as pie. (well almost).

Or try Conectiva Linux, it uses rpm's and have a really cool port of debi=
an's=20
APT

http://www.conectiva.com


Sorry for the off topic.
--=20

_______________________________________________________________
=09=09=09Hernan Lucar Cuculiza
=09=09=09     Conectiva Peru
=09=09   Conectiva, comunidad sin fronteras
=09=09       Calle Los Halcones 386 - Lima 34
=09=09=09   Telf. +511 4422875
=09=09        http://www.conectiva.com.pe

Re: [SQL-Ledger-users] Internal error?

[Dieter S. <dsi...@sq...>]

Rick,

There is a README file which covers a basic installation. You could also
check out the FAQ for more clues.

All the required parts needed to successfully run SQL-Ledger are listed on
the source code page with links pointing to the websites where you can
retrieve the source code.


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 Tue, 13 Feb 2001, Richard Eicher II wrote:

> no I guess I have not. I will look into that. Are
> there any efforts to a how to on this? If not any
> one interested it working on one?
> 
> Rick
> 
> __________________________________________________
> Do You Yahoo!?
> Get personalized email addresses from Yahoo! Mail - only $35 
> a year!  http://personal.mail.yahoo.com/
> 
> 

[SQL-Ledger-users] Dieter?

[Thomas S. <ps...@on...>]

Dieter! Where are you? Whats the good word?

-- 
Thomas Sawyer
ps...@on... - email


__________________________________________________
FREE voicemail, email, and fax...all in one place.
Sign Up Now! http://www.onebox.com