sql-ledger-users — SQL-Ledger users

Re: Postgresql and ODBC > MsAccess

[Martin L. <m-l...@le...>]

"Oscar Buijten" <os...@el...> writes:

> I currently have information stored in a Access97 database.
> 
> Part of this information I would need to transfer to Postgresql (on a
> linux box (Mandrake 8.0) to use it in the SQL-ledger.
> 
> Question is: how to do this?

The "easiest" way is to export your tables from access with a
delimiter (i.e. ";") and reimport this data to postgres using the "copy from"
command. Look at the SQL-Reference which is part of the Reference Manual.

> I assume I would need to do it using ODBC, but I have no clue what to
> install (as a driver) and where to install it (on the linux box or on
> the wondoze box).

There exists a ODBC-Driver you can use for accessing PG-Databases via
i.e. access. But IMHO the way described above is the faster way, if you
don't want to access the PG-Database permanently via M$-access.

In any cases you have to rebuild constraints and relations between
tables by hand, it is not possible to export/import them.

HTH, Martin

BTW: Could you please post plain-text instead of HTML next time? Thx

Re: Searching the mailinglist archive

[Jonas S. <jo...@jo...>]

On Wed, 20 Jun 2001, Oscar Buijten wrote:

> > Searching for a simple term like "ledger" at the search option for the
> > sourceforge mailinglist archive didn't work for me.
> >
> > So I scanned the archive myself. It is here, if any of you would like to
> > use it as well: http://search.jones.dk/

> Maybe it's me, but searching for 'ledger' on http://search.jones.dk/ gives
> me:
>
> No matches were found for '(ledger or ledge or ledges or ledgers)'

Well, I thought it would be obvious: The page is a generic one for several
sites I index separately: Choose "SQL-Ledger" in the "Target" popup
menu...

The index is updated every 24 hours.

:-)

Jonas


P.S.

Please write below quoted text, and strip irrelevant quotes...

-- 
Jonas Smedegaard   <jo...@jo...>   http://www.jones.dk/~jonas/
IT-guide dr. Jones    <dr...@jo...>   http://dr.jones.dk/    +45 40843136
Debian GNU/Linux    <js...@de...>   http://www.debian.org/
GnuPG(1024D/C02440B8): 9A98 C6EB C098 9ED0 3085  ECA9 9FB0 DB32 C024 40B8

GNU GPL: "The source will be with you... always."

Re: Searching the mailinglist archive

[Oscar B. <os...@el...>]

Hello Jonas,

Great idea!

Maybe it's me, but searching for 'ledger' on http://search=2Ejones=2Edk/ giv=
es
me:

No matches were found for '(ledger or ledge or ledges or ledgers)'


Regards,

Oscar

----- Message d'origine -----
De : "Jonas Smedegaard" <jonas@jones=2Edk>
=C0 : <sql-ledger-users@lists=2Esourceforge=2Enet>
Cc : <dsimader@sql-ledger=2Eorg>
Envoy=E9 : mercredi 20 juin 2001 03:28
Objet : Searching the mailinglist archive


> Hi all,
>
> Searching for a simple term like "ledger" at the search option for the
> sourceforge mailinglist archive didn't work for me=2E
>
> So I scanned the archive myself=2E It is here, if any of you would like to
> use it as well: http://search=2Ejones=2Edk/
>
>  - Jonas
>
> --
> Jonas Smedegaard   <jonas@jones=2Edk>   http://www=2Ejones=2Edk/~jonas/
> IT-guide dr=2E Jones    <dr@jones=2Edk>   http://dr=2Ejones=2Edk/    +45 4=
0843136
> Debian GNU/Linux    <js@debian=2Eorg>   http://www=2Edebian=2Eorg/
> GnuPG(1024D/C02440B8): 9A98 C6EB C098 9ED0 3085  ECA9 9FB0 DB32 C024 40B8
>
> GNU GPL: "The source will be with you=2E=2E=2E always=2E"
>
>
>

Postgresql and ODBC > MsAccess

[Oscar B. <os...@el...>]

Hello all,

Realising that thismay not be the perfect place to ask my question I =
want to give it a try anyway.
I currently have information stored in a Access97 database.
Part of this information I would need to transfer to Postgresql (on a =
linux box (Mandrake 8.0) to use it in the SQL-ledger.

Question is: how to do this?

I assume I would need to do it using ODBC, but I have no clue what to =
install (as a driver) and
where to install it (on the linux box or on the wondoze box).

Does anyone has a good answer on this?

Thanks in advance!

Regards,

Oscar
________________________________________________________________________

Oscar Buijten

Tel:     +33.4.67.57.97.45
Fax:    +33.4.67.57.97.46
GSM: +33.6.20.84.15.22
Email: os...@el...

http://www.elbie.com

Re: Version 1.4.4 installation problems ( IT WORKS ! )

[Oscar B. <os...@el...>]

Thanks to all the people replying to my 'crying out for help!'

For the person that may benifit from it:

To start Postgresql with the -i flag (to enable TCP/IP connections) on
Mandrake 8=2E0 do the following:

cd /etc/init=2Ed
emacs postgresql

Look for the line containing: echo -n "Starting postgresql service: "
(probably line 82)
The next line is then:
su -l postgres -c "/usr/bin/pg_ctl  -D $PGDATA -p /usr/bin/postmaster  start
>/dev/null 2>&1"

Change it to:

su -l postgres -c "/usr/bin/pg_ctl  -D $PGDATA -p /usr/bin/postmaster -o -i
start >/dev/null 2>&1"

Notice the "-o -i" between postmaster and start=2E

I assume the -o means 'options you want to give to the postmaster when
starting it'=2E
-i enables the TCP/IP connections=2E

Enjoy,

Oscar


----- Message d'origine -----
De : "Tomas Kuliavas" <tokul@bigfoot=2Ecom>
? : <sql-ledger-users@lists=2Esourceforge=2Enet>
Envoy=E9 : mardi 19 juin 2001 20:22
Objet : Re: Version 1=2E4=2E4 installation problems (nearly there now ! )


> > Oscar Buijten wrote:
> >
> > Hello again dear helpers,
> >
> > I have been trying several things=2E Changed this line;
> > postgres -c "/usr/bin/pg_ctl  -D  $PGDATA -p  /usr/bin/postmaster
> > start >/dev/null 2>&1
> > in several ways=2E Can't get it to work with this=2E
> >
> > Have tried to add : su postgres -c  'postmaster -i'   to /etc/profile
> > as well but no succes either=2E
> >
> > When I use; su postgres -c  'postmaster -i'    from the command line
> > postmaster switches on and I can use the SQL-ledger application=2E
> >
>
> You don't need to modify init=2Ed script if you want to make postgresql
> listen to tcp
>
> all you need is valid configuration file=2E
>
> "tcpip_socket =3D true" and "port =3D 5432" options=2E
>
> and postgres listens to tcp port=2E I did it with postgres build from
> sources and with postgres on Debian=2E :)
> --
> Tomas Kuliavas
>

New danish translation and english suggestion

[Jonas S. <jo...@jo...>]

Hi,

Attached is yet another danish locale improvement.

Also, now that I've figured out just how to deal with tax being
automatically added, I have a suggestion for the original wording of a
phrase:

Now:

Include this account on the customer/vendor forms to flag customer/vendor
as taxable?

Suggested ned wording:

Make this account selectable as tax account when creating customers and
vendors?


The suggested wording makes it more obvious IMHO where and when exactly to
enable tax. I built a Chart of Accounts from scratch last night, and spent
hours trying all sorts of combinations of adding CT_all and creating AR/AP
transactions without realizing that "customer/vendor forms" includes "Add
Customer" but _not_ "Add Customer Invoice"...

Kind regards,

Jonas

-- 
Jonas Smedegaard   <jo...@jo...>   http://www.jones.dk/~jonas/
IT-guide dr. Jones    <dr...@jo...>   http://dr.jones.dk/    +45 40843136
Debian GNU/Linux    <js...@de...>   http://www.debian.org/
GnuPG(1024D/C02440B8): 9A98 C6EB C098 9ED0 3085  ECA9 9FB0 DB32 C024 40B8

GNU GPL: "The source will be with you... always."

Searching the mailinglist archive

[Jonas S. <jo...@jo...>]

Hi all,

Searching for a simple term like "ledger" at the search option for the
sourceforge mailinglist archive didn't work for me.

So I scanned the archive myself. It is here, if any of you would like to
use it as well: http://search.jones.dk/

 - Jonas

-- 
Jonas Smedegaard   <jo...@jo...>   http://www.jones.dk/~jonas/
IT-guide dr. Jones    <dr...@jo...>   http://dr.jones.dk/    +45 40843136
Debian GNU/Linux    <js...@de...>   http://www.debian.org/
GnuPG(1024D/C02440B8): 9A98 C6EB C098 9ED0 3085  ECA9 9FB0 DB32 C024 40B8

GNU GPL: "The source will be with you... always."

Re: Version 1.4.4 installation problems (nearly there now ! )

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

Hi Oscar.  I'm on Debian, so I do it through the postmaster.init file.

I think you need to get what's below into your startup script or check
the configuration file for the distribution that you're on.  Your docs
also might have more info.

Sorry I can't be of more assistance.
Steve

>  Try a:
> postgres -c "/usr/bin/pg_ctl -0 '-i' -D  $PGDATA -p
> /usr/bin/postmaster
> start >/dev/null 2>&1
>
>

Re: Version 1.4.4 installation problems (nearly there now ! )

[Tomas K. <to...@bi...>]

> Oscar Buijten wrote:
> 
> Hello again dear helpers,
> 
> I have been trying several things. Changed this line;
> postgres -c "/usr/bin/pg_ctl  -D  $PGDATA -p  /usr/bin/postmaster
> start >/dev/null 2>&1
> in several ways. Can't get it to work with this.
> 
> Have tried to add : su postgres -c  'postmaster -i'   to /etc/profile
> as well but no succes either.
> 
> When I use; su postgres -c  'postmaster -i'    from the command line
> postmaster switches on and I can use the SQL-ledger application.
> 

You don't need to modify init.d script if you want to make postgresql
listen to tcp

all you need is valid configuration file.

"tcpip_socket = true" and "port = 5432" options.

and postgres listens to tcp port. I did it with postgres build from
sources and with postgres on Debian. :) 
-- 
Tomas Kuliavas

unsubscribe

[Kevin H. <kh...@bi...>]

----- Original Message -----
From: "Jonas Smedegaard" <jo...@jo...>
To: <sql...@li...>
Sent: Tuesday, June 19, 2001 11:05 AM
Subject: RE: Version 1.4.4 installation problems (nearly there now ! )


> On Tue, 19 Jun 2001, Oscar Buijten wrote:
>
> > When I use; su postgres -c 'postmaster -i' from the command line
> > postmaster switches on and I can use the SQL-ledger application.
> >
> > Wooow !!!
> >
> > So the I can get the application work but would REALLY appreciate some
> > help on switching on postgress at boot-time with the -i flag.
>
> On the unofficial Debian Woody (with PostgreSQL 7.1) there's a separate
> file called /etc/postgresql/postmaster.init where you have to add the line
> "PGALLOWTCPIP=yes". Maybe it is similar on your system...
>
>  - Jonas
>
> P.S.
>
> Please write _below_ quoted text and only quote what is relevant for your
> reply (cut off the rest) - for greater reading pleasure :-)
>
> --
> Jonas Smedegaard   <jo...@jo...>   http://www.jones.dk/~jonas/
> IT-guide dr. Jones    <dr...@jo...>   http://dr.jones.dk/    +45 40843136
> Debian GNU/Linux    <js...@de...>   http://www.debian.org/
> GnuPG(1024D/C02440B8): 9A98 C6EB C098 9ED0 3085  ECA9 9FB0 DB32 C024 40B8
>
> GNU GPL: "The source will be with you... always."
>
>

RE: Version 1.4.4 installation problems (nearly there now ! )

[Jonas S. <jo...@jo...>]

On Tue, 19 Jun 2001, Oscar Buijten wrote:

> When I use; su postgres -c 'postmaster -i' from the command line
> postmaster switches on and I can use the SQL-ledger application.
>
> Wooow !!!
>
> So the I can get the application work but would REALLY appreciate some
> help on switching on postgress at boot-time with the -i flag.

On the unofficial Debian Woody (with PostgreSQL 7.1) there's a separate
file called /etc/postgresql/postmaster.init where you have to add the line
"PGALLOWTCPIP=yes". Maybe it is similar on your system...

 - Jonas

P.S.

Please write _below_ quoted text and only quote what is relevant for your
reply (cut off the rest) - for greater reading pleasure :-)

-- 
Jonas Smedegaard   <jo...@jo...>   http://www.jones.dk/~jonas/
IT-guide dr. Jones    <dr...@jo...>   http://dr.jones.dk/    +45 40843136
Debian GNU/Linux    <js...@de...>   http://www.debian.org/
GnuPG(1024D/C02440B8): 9A98 C6EB C098 9ED0 3085  ECA9 9FB0 DB32 C024 40B8

GNU GPL: "The source will be with you... always."

RE: Version 1.4.4 installation problems (nearly there now ! )

[Oscar B. <os...@el...>]

Hello again dear helpers,

I have been trying several things. Changed this line;
postgres -c "/usr/bin/pg_ctl  -D  $PGDATA -p  /usr/bin/postmaster start =
>/dev/null 2>&1
in several ways. Can't get it to work with this.

Have tried to add : su postgres -c  'postmaster -i'   to /etc/profile as =
well but no succes either.

When I use; su postgres -c  'postmaster -i'    from the command line =
postmaster switches on and I can use the SQL-ledger application.=20

Wooow !!!

So the I can get the application work but would REALLY appreciate some =
help on switching on postgress at boot-time with the -i flag.

Thanks,


Oscar


Try a:
postgres -c "/usr/bin/pg_ctl -0 '-i' -D  $PGDATA -p  /usr/bin/postmaster
start >/dev/null 2>&1



-----Original Message-----
From: sql...@li...
[mailto:sql...@li...]On Behalf Of Oscar
Buijten
Sent: Tuesday, June 19, 2001 11:29 AM
To: sql...@li...
Subject: Re: Version 1.4.4 installation problems (desperate by now)


Hi Steve,

It indeed sems to be that I need to start Postgresql with the -i option.
Question is how to do that?

In my "/etc/init.d/postgresql" I have the following line to start the
postmaster.

postgres -c "/usr/bin/pg_ctl  -D  $PGDATA -p  /usr/bin/postmaster start
>/dev/null 2>&1

I have tried to add '-i' in several places in this line and to execute =
it
from the command line, but so far I have not been lucky.

Can you please advise me?

Thanks,

Oscar


PS: the error in httpd/error_log indicates the following:

DBI->connect(dbname=3Dfaicom;host=3D192.168.1.12;port=3D5432) failed:
PQconnectPoll() -- connect() failed: Connection refused
        Is the postmaster running (with -i) at '192.168.1.12'
        and accepting connections on TCP/IP port '5432'?
 at SL/User.pm line 110



----- Message d'origine -----
De : "Steve Doerr" <sd...@sw...>
=C0 : <sql...@li...>
Envoy=E9 : mardi 19 juin 2001 18:05
Objet : Re: Version 1.4.4 installation problems (desperate by now)


> Hi Oscar.
>
> Do you have postgres starting with the -i flag (tcp/ip connection)?
>
> try from the command line:
> psql -d yourdbname -h 127.0.0.1
>
> If you can't make a tcp/ip connection through the localhost, you need =
to
start
> the postmaster with the -i flag.
>
> Good luck,
> Steve
>
> Oscar Buijten wrote:
>
> > Bloody ...  You are a GENIUS !!
> >
> > Now it says:
> >
> > Error!
> > Database is offline; please try again later
> >
> > You know the answer to that as well??
> >
> > Thanks,
> >
> > Oscar
> >
> > ----- Message d'origine -----
> > De : "Flavio Curti" <lis...@no...>
> > =C0 : <os...@el...>
> > Envoy=E9 : mardi 19 juin 2001 15:26
> > Objet : Re: Version 1.4.4 installation problems (desperate by now)
> >
> > > hi
> > >
> > > i had the same problem and were looking for all kind of things, =
when
it
> > simply was a typo... make sure the database type in the user record =
is
'Pg'
> > (note the uppercase 'p')... this was it for me...
> > >
> > > greetz & hope it helps
> > >
> > > Flavio
> > >
> > > On Tue, 19 Jun 2001 15:00:55 +0200 "Oscar Buijten" =
<os...@el...>
> > wrote:
> > >
> > > > Hi,
> > > >
> > > > I am trying to install V1.4.4 for many days now. I keep having
errors
> > and trat to be desparate.
> > > > I would Higly appreciate a bit of help. Please see below all the
details
> > (let me know if more is required)
> > > >
> > > > Main error visible is: http://192.168.1.12/sql-ledger/login.pl
provoking
> > an Internal server Error after submitting a User ID and Passwd
> > > >
> > > > I am running Mandrake 8.0 on a standard Intel PII machine.
> > > > Apache: Apache-AdvancedExtranetServer/1.3.19 Server at euro.host
Port 80
> > > > SQL is Postgress 7.0xxxx as it comes with Mandrake 8.0
> > > >
> > > > In order to install BDI and DBD:pg I have used (after trying to
install
> > from the sources):
> > > > perl-DBI-1.14-4mdk.i586.rpm
> > > > and
> > > > perl-DBD-Pg-0.91-2mdk.i586.rpm
> > > > (One of the issues I had installing the DBD::Pg sources were the
> > environment varaiables.
> > > > POSTGRES_INCLUDE=3D/usr/include
> > > > PGDATA=3D/var/lib/pgsql/data
> > > > POSTGRES_LIB=3D/usr/lib/pgsql
> > > >
> > > > Of which the include one is the issue according to me. I can't =
find
any
> > other include directories..... that could relate to Postgresql.
> > > >
> > > > Tail of apache error log gives:
> > > > Unknown error
> > > > Compilation failed in require at /var/www/sql-ledger/login.pl =
line
65.
> > > > [Tue Jun 19 13:55:49 2001] [error] [client 192.168.1.4] =
Premature
end of
> > script headers: /var/www/sql-ledger/login.pl
> > > >
> > > >
> > > > Changing the first line of login.pl to #!/usr/bin/perl -w gives =
the
> > following result in the httpd error_log
> > > >
> > > > Use of uninitialized value in split at =
/var/www/sql-ledger/login.pl
line
> > 53.
> > > > Use of uninitialized value in read at SL/Form.pm line 44.
> > > > Unknown error
> > > > Compilation failed in require at /var/www/sql-ledger/login.pl =
line
65.
> > > > [Tue Jun 19 14:03:42 2001] [error] [client 192.168.1.4] =
Premature
end of
> > script headers: /var/www/sql-ledger/login.pl
> > > >
> > > >
> > > > The creation of the databases went fine and I can acces, modify
without
> > any problems using webmin.
> > > >
> > > > So in short, I need Heeeeeeeeeeeeeeeelp.
> > > >
> > > > Thanks in advance, to you, kind person helping me out.
> > > >
> > > > Regards,
> > > >
> > > > Oscar
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
________________________________________________________________________
> > > >
> > > > Oscar Buijten
> > > >
> > > > Tel:     +33.4.67.57.97.45
> > > > Fax:    +33.4.67.57.97.46
> > > > GSM: +33.6.20.84.15.22
> > > > Email: os...@el...
> > > >
> > > > http://www.elbie.com
> > > >
> > >
> > >
> > > --
> > > http://no-way.org/~fcu/
> > >
>
>
>




________________________________________________________________________

Oscar Buijten

Tel:     +33.4.67.57.97.45
Fax:    +33.4.67.57.97.46
GSM: +33.6.20.84.15.22
Email: os...@el...

http://www.elbie.com

RE: Version 1.4.4 installation problems (desperate by now)

[Ian \(t. webguy\) <ia...@in...>]

Try a:
postgres -c "/usr/bin/pg_ctl -0 '-i' -D  $PGDATA -p  /usr/bin/postmaster
start >/dev/null 2>&1



-----Original Message-----
From: sql...@li...
[mailto:sql...@li...]On Behalf Of Oscar
Buijten
Sent: Tuesday, June 19, 2001 11:29 AM
To: sql...@li...
Subject: Re: Version 1.4.4 installation problems (desperate by now)


Hi Steve,

It indeed sems to be that I need to start Postgresql with the -i option.
Question is how to do that?

In my "/etc/init.d/postgresql" I have the following line to start the
postmaster.

postgres -c "/usr/bin/pg_ctl  -D  $PGDATA -p  /usr/bin/postmaster start
>/dev/null 2>&1

I have tried to add '-i' in several places in this line and to execute it
from the command line, but so far I have not been lucky.

Can you please advise me?

Thanks,

Oscar


PS: the error in httpd/error_log indicates the following:

DBI->connect(dbname=faicom;host=192.168.1.12;port=5432) failed:
PQconnectPoll() -- connect() failed: Connection refused
        Is the postmaster running (with -i) at '192.168.1.12'
        and accepting connections on TCP/IP port '5432'?
 at SL/User.pm line 110



----- Message d'origine -----
De : "Steve Doerr" <sd...@sw...>
À : <sql...@li...>
Envoyé : mardi 19 juin 2001 18:05
Objet : Re: Version 1.4.4 installation problems (desperate by now)


> Hi Oscar.
>
> Do you have postgres starting with the -i flag (tcp/ip connection)?
>
> try from the command line:
> psql -d yourdbname -h 127.0.0.1
>
> If you can't make a tcp/ip connection through the localhost, you need to
start
> the postmaster with the -i flag.
>
> Good luck,
> Steve
>
> Oscar Buijten wrote:
>
> > Bloody ...  You are a GENIUS !!
> >
> > Now it says:
> >
> > Error!
> > Database is offline; please try again later
> >
> > You know the answer to that as well??
> >
> > Thanks,
> >
> > Oscar
> >
> > ----- Message d'origine -----
> > De : "Flavio Curti" <lis...@no...>
> > À : <os...@el...>
> > Envoyé : mardi 19 juin 2001 15:26
> > Objet : Re: Version 1.4.4 installation problems (desperate by now)
> >
> > > hi
> > >
> > > i had the same problem and were looking for all kind of things, when
it
> > simply was a typo... make sure the database type in the user record is
'Pg'
> > (note the uppercase 'p')... this was it for me...
> > >
> > > greetz & hope it helps
> > >
> > > Flavio
> > >
> > > On Tue, 19 Jun 2001 15:00:55 +0200 "Oscar Buijten" <os...@el...>
> > wrote:
> > >
> > > > Hi,
> > > >
> > > > I am trying to install V1.4.4 for many days now. I keep having
errors
> > and trat to be desparate.
> > > > I would Higly appreciate a bit of help. Please see below all the
details
> > (let me know if more is required)
> > > >
> > > > Main error visible is: http://192.168.1.12/sql-ledger/login.pl
provoking
> > an Internal server Error after submitting a User ID and Passwd
> > > >
> > > > I am running Mandrake 8.0 on a standard Intel PII machine.
> > > > Apache: Apache-AdvancedExtranetServer/1.3.19 Server at euro.host
Port 80
> > > > SQL is Postgress 7.0xxxx as it comes with Mandrake 8.0
> > > >
> > > > In order to install BDI and DBD:pg I have used (after trying to
install
> > from the sources):
> > > > perl-DBI-1.14-4mdk.i586.rpm
> > > > and
> > > > perl-DBD-Pg-0.91-2mdk.i586.rpm
> > > > (One of the issues I had installing the DBD::Pg sources were the
> > environment varaiables.
> > > > POSTGRES_INCLUDE=/usr/include
> > > > PGDATA=/var/lib/pgsql/data
> > > > POSTGRES_LIB=/usr/lib/pgsql
> > > >
> > > > Of which the include one is the issue according to me. I can't find
any
> > other include directories..... that could relate to Postgresql.
> > > >
> > > > Tail of apache error log gives:
> > > > Unknown error
> > > > Compilation failed in require at /var/www/sql-ledger/login.pl line
65.
> > > > [Tue Jun 19 13:55:49 2001] [error] [client 192.168.1.4] Premature
end of
> > script headers: /var/www/sql-ledger/login.pl
> > > >
> > > >
> > > > Changing the first line of login.pl to #!/usr/bin/perl -w gives the
> > following result in the httpd error_log
> > > >
> > > > Use of uninitialized value in split at /var/www/sql-ledger/login.pl
line
> > 53.
> > > > Use of uninitialized value in read at SL/Form.pm line 44.
> > > > Unknown error
> > > > Compilation failed in require at /var/www/sql-ledger/login.pl line
65.
> > > > [Tue Jun 19 14:03:42 2001] [error] [client 192.168.1.4] Premature
end of
> > script headers: /var/www/sql-ledger/login.pl
> > > >
> > > >
> > > > The creation of the databases went fine and I can acces, modify
without
> > any problems using webmin.
> > > >
> > > > So in short, I need Heeeeeeeeeeeeeeeelp.
> > > >
> > > > Thanks in advance, to you, kind person helping me out.
> > > >
> > > > Regards,
> > > >
> > > > Oscar
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
________________________________________________________________________
> > > >
> > > > Oscar Buijten
> > > >
> > > > Tel:     +33.4.67.57.97.45
> > > > Fax:    +33.4.67.57.97.46
> > > > GSM: +33.6.20.84.15.22
> > > > Email: os...@el...
> > > >
> > > > http://www.elbie.com
> > > >
> > >
> > >
> > > --
> > > http://no-way.org/~fcu/
> > >
>
>
>

Re: Version 1.4.4 installation problems (desperate by now)

[Oscar B. <os...@el...>]

Hi Steve,

It indeed sems to be that I need to start Postgresql with the -i option=2E
Question is how to do that?

In my "/etc/init=2Ed/postgresql" I have the following line to start the
postmaster=2E

postgres -c "/usr/bin/pg_ctl  -D  $PGDATA -p  /usr/bin/postmaster start
>/dev/null 2>&1

I have tried to add '-i' in several places in this line and to execute it
from the command line, but so far I have not been lucky=2E

Can you please advise me?

Thanks,

Oscar


PS: the error in httpd/error_log indicates the following:

DBI->connect(dbname=3Dfaicom;host=3D192=2E168=2E1=2E12;port=3D5432) failed:
PQconnectPoll() -- connect() failed: Connection refused
        Is the postmaster running (with -i) at '192=2E168=2E1=2E12'
        and accepting connections on TCP/IP port '5432'?
 at SL/User=2Epm line 110



----- Message d'origine -----
De : "Steve Doerr" <sdoerr@swbell=2Enet>
=C0 : <sql-ledger-users@lists=2Esourceforge=2Enet>
Envoy=E9 : mardi 19 juin 2001 18:05
Objet : Re: Version 1=2E4=2E4 installation problems (desperate by now)


> Hi Oscar=2E
>
> Do you have postgres starting with the -i flag (tcp/ip connection)?
>
> try from the command line:
> psql -d yourdbname -h 127=2E0=2E0=2E1
>
> If you can't make a tcp/ip connection through the localhost, you need to
start
> the postmaster with the -i flag=2E
>
> Good luck,
> Steve
>
> Oscar Buijten wrote:
>
> > Bloody =2E=2E=2E  You are a GENIUS !!
> >
> > Now it says:
> >
> > Error!
> > Database is offline; please try again later
> >
> > You know the answer to that as well??
> >
> > Thanks,
> >
> > Oscar
> >
> > ----- Message d'origine -----
> > De : "Flavio Curti" <lists=2Efcu@no-way=2Eorg>
> > =C0 : <oscar@elbie=2Ecom>
> > Envoy=E9 : mardi 19 juin 2001 15:26
> > Objet : Re: Version 1=2E4=2E4 installation problems (desperate by now)
> >
> > > hi
> > >
> > > i had the same problem and were looking for all kind of things, when
it
> > simply was a typo=2E=2E=2E make sure the database type in the user recor=
d is
'Pg'
> > (note the uppercase 'p')=2E=2E=2E this was it for me=2E=2E=2E
> > >
> > > greetz & hope it helps
> > >
> > > Flavio
> > >
> > > On Tue, 19 Jun 2001 15:00:55 +0200 "Oscar Buijten" <oscar@elbie=2Ecom>
> > wrote:
> > >
> > > > Hi,
> > > >
> > > > I am trying to install V1=2E4=2E4 for many days now=2E I keep having
errors
> > and trat to be desparate=2E
> > > > I would Higly appreciate a bit of help=2E Please see below all the
details
> > (let me know if more is required)
> > > >
> > > > Main error visible is: http://192=2E168=2E1=2E12/sql-ledger/login=2E=
pl
provoking
> > an Internal server Error after submitting a User ID and Passwd
> > > >
> > > > I am running Mandrake 8=2E0 on a standard Intel PII machine=2E
> > > > Apache: Apache-AdvancedExtranetServer/1=2E3=2E19 Server at euro=2Eho=
st
Port 80
> > > > SQL is Postgress 7=2E0xxxx as it comes with Mandrake 8=2E0
> > > >
> > > > In order to install BDI and DBD:pg I have used (after trying to
install
> > from the sources):
> > > > perl-DBI-1=2E14-4mdk=2Ei586=2Erpm
> > > > and
> > > > perl-DBD-Pg-0=2E91-2mdk=2Ei586=2Erpm
> > > > (One of the issues I had installing the DBD::Pg sources were the
> > environment varaiables=2E
> > > > POSTGRES_INCLUDE=3D/usr/include
> > > > PGDATA=3D/var/lib/pgsql/data
> > > > POSTGRES_LIB=3D/usr/lib/pgsql
> > > >
> > > > Of which the include one is the issue according to me=2E I can't fin=
d
any
> > other include directories=2E=2E=2E=2E=2E that could relate to Postgresql=
=2E
> > > >
> > > > Tail of apache error log gives:
> > > > Unknown error
> > > > Compilation failed in require at /var/www/sql-ledger/login=2Epl line
65=2E
> > > > [Tue Jun 19 13:55:49 2001] [error] [client 192=2E168=2E1=2E4] Premat=
ure
end of
> > script headers: /var/www/sql-ledger/login=2Epl
> > > >
> > > >
> > > > Changing the first line of login=2Epl to #!/usr/bin/perl -w gives th=
e
> > following result in the httpd error_log
> > > >
> > > > Use of uninitialized value in split at /var/www/sql-ledger/login=2Ep=
l
line
> > 53=2E
> > > > Use of uninitialized value in read at SL/Form=2Epm line 44=2E
> > > > Unknown error
> > > > Compilation failed in require at /var/www/sql-ledger/login=2Epl line
65=2E
> > > > [Tue Jun 19 14:03:42 2001] [error] [client 192=2E168=2E1=2E4] Premat=
ure
end of
> > script headers: /var/www/sql-ledger/login=2Epl
> > > >
> > > >
> > > > The creation of the databases went fine and I can acces, modify
without
> > any problems using webmin=2E
> > > >
> > > > So in short, I need Heeeeeeeeeeeeeeeelp=2E
> > > >
> > > > Thanks in advance, to you, kind person helping me out=2E
> > > >
> > > > Regards,
> > > >
> > > > Oscar
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
________________________________________________________________________
> > > >
> > > > Oscar Buijten
> > > >
> > > > Tel:     +33=2E4=2E67=2E57=2E97=2E45
> > > > Fax:    +33=2E4=2E67=2E57=2E97=2E46
> > > > GSM: +33=2E6=2E20=2E84=2E15=2E22
> > > > Email: oscar@elbie=2Ecom
> > > >
> > > > http://www=2Eelbie=2Ecom
> > > >
> > >
> > >
> > > --
> > > http://no-way=2Eorg/~fcu/
> > >
>
>
>

RE: Internal Server Configuration

[Jonathan G. <jgo...@br...>]

Ok German,

     I make the corrections and check the apache subdirectories and is
fine... but still displaying the Server error... do you have any other idea
about this...
Thanks...

-----Original Message-----
From: sql...@li...
[mailto:sql...@li...]On Behalf Of German
Duenas
Sent: Viernes, 15 de Junio de 2001 11:35 p.m.
To: sql...@li...
Subject: Re: Internal Server Configuration

You have added the settings to the wrong file. These
seetings are to be added to the
/etc/httpd/conf/httpd.conf. Once you add these lines
you can check against your configuration files. In
Mandrake if you run Drakconf and go to networks then
servers and then Apache server under subdirectories
you will find these settingts already listed. If they
are not listed go back and enter them. Good luck
Jerry
--- Jonathan Gonzalez <jgo...@br...>
wrote:
> Dear sql-ledger support
>
> I have been traying to configure the sql-ledger
> following the steps
> written on the sql-ledger web page... a can't make
> it work, i received
> an error message...
>
>
>   Internal Server Error
>
> The server encountered an internal error or
> misconfiguration and was
> unable to complete your request.
>
> Please contact the server administrator,
> root@localhost and inform them
> of the time the error occurred, and anything you
> might have done that
> may have caused the error.
>
> More information about this error may be available
> in the server error log.
>
>
------------------------------------------------------------------------
> Apache-AdvancedExtranetServer/1.3.19 Server at
> johny.cwpanama.net Port 80
>
>
>
> i verify the Apache Web server configuration.. and
> is fine.... the only
> thing that i noticed is that when i try to run the
> login.pl on console
> sent me this error:
>
---------------------------------------------------------------
> [root@johny sql-ledger]# ./login.pl
> Bareword found where operator expected at
> sql-ledger.conf line 24, near
> "www/sql"
>                   (Missing operator before ql?)
> syntax error at sql-ledger.conf line 24, near
> "/www/sql"
> BEGIN not safe after errors--compilation aborted at
> sql-ledger.conf line 27.
> Compilation failed in require at ./login.pl line 37.
> [root@johny sql-ledger]#
>
----------------------------------------------------------------
> Now here is a copy of what i add on the
> sql-ledger.conf file
>
> #22AddHandler cgi-script .pl
> #23
> #24Alias /sql-ledger/  /usr/local/www/sql-ledger/
> #25<Directory /usr/local/www/sql-ledger>;
> #26     Options ExecCGI Includes FollowSymlinks
> #27</Directory>;
>
> I'm using Linux Mandrake 8.0 if you need any other
> information just ask me.
> thanks
>
> Jonathan Gonzalez
>
>
>
>


__________________________________________________
Do You Yahoo!?
Spot the hottest trends in music, movies, and more.
http://buzz.yahoo.com/

Re: Version 1.4.4 installation problems (desperate by now)

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

Hi Oscar.

Do you have postgres starting with the -i flag (tcp/ip connection)?

try from the command line:
psql -d yourdbname -h 127.0.0.1

If you can't make a tcp/ip connection through the localhost, you need=
 to start
the postmaster with the -i flag.

Good luck,
Steve

Oscar Buijten wrote:

> Bloody ...  You are a GENIUS !!
>
> Now it says:
>
> Error!
> Database is offline; please try again later
>
> You know the answer to that as well??
>
> Thanks,
>
> Oscar
>
> ----- Message d'origine -----
> De : "Flavio Curti" <lis...@no...>
> =C0 : <os...@el...>
> Envoy=E9 : mardi 19 juin 2001 15:26
> Objet : Re: Version 1.4.4 installation problems (desperate by now)
>
> > hi
> >
> > i had the same problem and were looking for all kind of things, w=
hen it
> simply was a typo... make sure the database type in the user record=
 is 'Pg'
> (note the uppercase 'p')... this was it for me...
> >
> > greetz & hope it helps
> >
> > Flavio
> >
> > On Tue, 19 Jun 2001 15:00:55 +0200 "Oscar Buijten" <oscar@elbie.c=
om>
> wrote:
> >
> > > Hi,
> > >
> > > I am trying to install V1.4.4 for many days now. I keep having =
errors
> and trat to be desparate.
> > > I would Higly appreciate a bit of help. Please see below all th=
e details
> (let me know if more is required)
> > >
> > > Main error visible is: http://192.168.1.12/sql-ledger/login.pl =
provoking
> an Internal server Error after submitting a User ID and Passwd
> > >
> > > I am running Mandrake 8.0 on a standard Intel PII machine.
> > > Apache: Apache-AdvancedExtranetServer/1.3.19 Server at euro.hos=
t Port 80
> > > SQL is Postgress 7.0xxxx as it comes with Mandrake 8.0
> > >
> > > In order to install BDI and DBD:pg I have used (after trying to=
 install
> from the sources):
> > > perl-DBI-1.14-4mdk.i586.rpm
> > > and
> > > perl-DBD-Pg-0.91-2mdk.i586.rpm
> > > (One of the issues I had installing the DBD::Pg sources were th=
e
> environment varaiables.
> > > POSTGRES_INCLUDE=3D/usr/include
> > > PGDATA=3D/var/lib/pgsql/data
> > > POSTGRES_LIB=3D/usr/lib/pgsql
> > >
> > > Of which the include one is the issue according to me. I can't =
find any
> other include directories..... that could relate to Postgresql.
> > >
> > > Tail of apache error log gives:
> > > Unknown error
> > > Compilation failed in require at /var/www/sql-ledger/login.pl l=
ine 65.
> > > [Tue Jun 19 13:55:49 2001] [error] [client 192.168.1.4] Prematu=
re end of
> script headers: /var/www/sql-ledger/login.pl
> > >
> > >
> > > Changing the first line of login.pl to #!/usr/bin/perl -w gives=
 the
> following result in the httpd error_log
> > >
> > > Use of uninitialized value in split at /var/www/sql-ledger/logi=
n.pl line
> 53.
> > > Use of uninitialized value in read at SL/Form.pm line 44.
> > > Unknown error
> > > Compilation failed in require at /var/www/sql-ledger/login.pl l=
ine 65.
> > > [Tue Jun 19 14:03:42 2001] [error] [client 192.168.1.4] Prematu=
re end of
> script headers: /var/www/sql-ledger/login.pl
> > >
> > >
> > > The creation of the databases went fine and I can acces, modify=
 without
> any problems using webmin.
> > >
> > > So in short, I need Heeeeeeeeeeeeeeeelp.
> > >
> > > Thanks in advance, to you, kind person helping me out.
> > >
> > > Regards,
> > >
> > > Oscar
> > >
> > >
> > >
> > >
> > >
> > > _______________________________________________________________=
_________
> > >
> > > Oscar Buijten
> > >
> > > Tel:     +33.4.67.57.97.45
> > > Fax:    +33.4.67.57.97.46
> > > GSM: +33.6.20.84.15.22
> > > Email: os...@el...
> > >
> > > http://www.elbie.com
> > >
> >
> >
> > --
> > http://no-way.org/~fcu/
> >

Re: Version 1.4.4 installation problems (desperate by now)

[Jonas S. <jo...@jo...>]

On Tue, 19 Jun 2001, Oscar Buijten wrote:

> Now it says:
>
> Error!
> Database is offline; please try again later

Let me try this time - it might be along the same line as last one:

host: localhost

And while we're at it, put in these as well:

Name (PostgreSQL database name)
Port (5432 on my setup)
User (PostgreSQL login name)
Password (PostgreSQL password - empty if you don't need a password)

Good luck!

 - Jonas

-- 
Jonas Smedegaard   <jo...@jo...>   http://www.jones.dk/~jonas/
IT-guide dr. Jones    <dr...@jo...>   http://dr.jones.dk/    +45 40843136
Debian GNU/Linux    <js...@de...>   http://www.debian.org/
GnuPG(1024D/C02440B8): 9A98 C6EB C098 9ED0 3085  ECA9 9FB0 DB32 C024 40B8

GNU GPL: "The source will be with you... always."

Re: Version 1.4.4 installation problems (desperate by now)

[Oscar B. <os...@el...>]

Bloody =2E=2E=2E  You are a GENIUS !!

Now it says:

Error!
Database is offline; please try again later


You know the answer to that as well??

Thanks,

Oscar



----- Message d'origine -----
De : "Flavio Curti" <lists=2Efcu@no-way=2Eorg>
=C0 : <oscar@elbie=2Ecom>
Envoy=E9 : mardi 19 juin 2001 15:26
Objet : Re: Version 1=2E4=2E4 installation problems (desperate by now)


> hi
>
> i had the same problem and were looking for all kind of things, when it
simply was a typo=2E=2E=2E make sure the database type in the user record is=
 'Pg'
(note the uppercase 'p')=2E=2E=2E this was it for me=2E=2E=2E
>
> greetz & hope it helps
>
> Flavio
>
> On Tue, 19 Jun 2001 15:00:55 +0200 "Oscar Buijten" <oscar@elbie=2Ecom>
wrote:
>
> > Hi,
> >
> > I am trying to install V1=2E4=2E4 for many days now=2E I keep having err=
ors
and trat to be desparate=2E
> > I would Higly appreciate a bit of help=2E Please see below all the detai=
ls
(let me know if more is required)
> >
> > Main error visible is: http://192=2E168=2E1=2E12/sql-ledger/login=2Epl p=
rovoking
an Internal server Error after submitting a User ID and Passwd
> >
> > I am running Mandrake 8=2E0 on a standard Intel PII machine=2E
> > Apache: Apache-AdvancedExtranetServer/1=2E3=2E19 Server at euro=2Ehost P=
ort 80
> > SQL is Postgress 7=2E0xxxx as it comes with Mandrake 8=2E0
> >
> > In order to install BDI and DBD:pg I have used (after trying to install
from the sources):
> > perl-DBI-1=2E14-4mdk=2Ei586=2Erpm
> > and
> > perl-DBD-Pg-0=2E91-2mdk=2Ei586=2Erpm
> > (One of the issues I had installing the DBD::Pg sources were the
environment varaiables=2E
> > POSTGRES_INCLUDE=3D/usr/include
> > PGDATA=3D/var/lib/pgsql/data
> > POSTGRES_LIB=3D/usr/lib/pgsql
> >
> > Of which the include one is the issue according to me=2E I can't find an=
y
other include directories=2E=2E=2E=2E=2E that could relate to Postgresql=2E
> >
> > Tail of apache error log gives:
> > Unknown error
> > Compilation failed in require at /var/www/sql-ledger/login=2Epl line 65=
=2E
> > [Tue Jun 19 13:55:49 2001] [error] [client 192=2E168=2E1=2E4] Premature =
end of
script headers: /var/www/sql-ledger/login=2Epl
> >
> >
> > Changing the first line of login=2Epl to #!/usr/bin/perl -w gives the
following result in the httpd error_log
> >
> > Use of uninitialized value in split at /var/www/sql-ledger/login=2Epl li=
ne
53=2E
> > Use of uninitialized value in read at SL/Form=2Epm line 44=2E
> > Unknown error
> > Compilation failed in require at /var/www/sql-ledger/login=2Epl line 65=
=2E
> > [Tue Jun 19 14:03:42 2001] [error] [client 192=2E168=2E1=2E4] Premature =
end of
script headers: /var/www/sql-ledger/login=2Epl
> >
> >
> > The creation of the databases went fine and I can acces, modify without
any problems using webmin=2E
> >
> > So in short, I need Heeeeeeeeeeeeeeeelp=2E
> >
> > Thanks in advance, to you, kind person helping me out=2E
> >
> > Regards,
> >
> > Oscar
> >
> >
> >
> >
> >
> > ________________________________________________________________________
> >
> > Oscar Buijten
> >
> > Tel:     +33=2E4=2E67=2E57=2E97=2E45
> > Fax:    +33=2E4=2E67=2E57=2E97=2E46
> > GSM: +33=2E6=2E20=2E84=2E15=2E22
> > Email: oscar@elbie=2Ecom
> >
> > http://www=2Eelbie=2Ecom
> >
>
>
> --
> http://no-way=2Eorg/~fcu/
>

Re: Version 1.4.4 installation problems (desperate by now)

[Flavio C. <fc...@no...>]

hi

i had the same problem and were looking for all kind of things, when it simply was a typo... make sure the database type in the user record is 'Pg' (note the uppercase 'p')... this was it for me...

greetz & hope it helps

Flavio

On Tue, 19 Jun 2001 15:00:55 +0200 "Oscar Buijten" <os...@el...> wrote:

> Hi,
> 
> I am trying to install V1.4.4 for many days now. I keep having errors and trat to be desparate.
> I would Higly appreciate a bit of help. Please see below all the details (let me know if more is required)
> 
> Main error visible is: http://192.168.1.12/sql-ledger/login.pl provoking an Internal server Error after submitting a User ID and Passwd
> 
> I am running Mandrake 8.0 on a standard Intel PII machine.
> Apache: Apache-AdvancedExtranetServer/1.3.19 Server at euro.host Port 80
> SQL is Postgress 7.0xxxx as it comes with Mandrake 8.0
> 
> In order to install BDI and DBD:pg I have used (after trying to install from the sources):
> perl-DBI-1.14-4mdk.i586.rpm
> and
> perl-DBD-Pg-0.91-2mdk.i586.rpm
> (One of the issues I had installing the DBD::Pg sources were the environment varaiables.
> POSTGRES_INCLUDE=/usr/include
> PGDATA=/var/lib/pgsql/data
> POSTGRES_LIB=/usr/lib/pgsql
> 
> Of which the include one is the issue according to me. I can't find any other include directories..... that could relate to Postgresql.
> 
> Tail of apache error log gives: 
> Unknown error
> Compilation failed in require at /var/www/sql-ledger/login.pl line 65.
> [Tue Jun 19 13:55:49 2001] [error] [client 192.168.1.4] Premature end of script headers: /var/www/sql-ledger/login.pl
> 
> 
> Changing the first line of login.pl to #!/usr/bin/perl -w gives the following result in the httpd error_log
> 
> Use of uninitialized value in split at /var/www/sql-ledger/login.pl line 53.
> Use of uninitialized value in read at SL/Form.pm line 44.
> Unknown error
> Compilation failed in require at /var/www/sql-ledger/login.pl line 65.
> [Tue Jun 19 14:03:42 2001] [error] [client 192.168.1.4] Premature end of script headers: /var/www/sql-ledger/login.pl
> 
> 
> The creation of the databases went fine and I can acces, modify without any problems using webmin.
> 
> So in short, I need Heeeeeeeeeeeeeeeelp.
> 
> Thanks in advance, to you, kind person helping me out.
> 
> Regards,
> 
> Oscar
> 
> 
> 
> 
> 
> ________________________________________________________________________
> 
> Oscar Buijten
> 
> Tel:     +33.4.67.57.97.45
> Fax:    +33.4.67.57.97.46
> GSM: +33.6.20.84.15.22
> Email: os...@el...
> 
> http://www.elbie.com
> 


-- 
http://no-way.org/~fcu/

Version 1.4.4 installation problems (desperate by now)

[Oscar B. <os...@el...>]

Hi,

I am trying to install V1.4.4 for many days now. I keep having errors =
and trat to be desparate.
I would Higly appreciate a bit of help. Please see below all the details =
(let me know if more is required)

Main error visible is: http://192.168.1.12/sql-ledger/login.pl provoking =
an Internal server Error after submitting a User ID and Passwd

I am running Mandrake 8.0 on a standard Intel PII machine.
Apache: Apache-AdvancedExtranetServer/1.3.19 Server at euro.host Port 80
SQL is Postgress 7.0xxxx as it comes with Mandrake 8.0

In order to install BDI and DBD:pg I have used (after trying to install =
from the sources):
perl-DBI-1.14-4mdk.i586.rpm
and
perl-DBD-Pg-0.91-2mdk.i586.rpm
(One of the issues I had installing the DBD::Pg sources were the =
environment varaiables.
POSTGRES_INCLUDE=3D/usr/include
PGDATA=3D/var/lib/pgsql/data
POSTGRES_LIB=3D/usr/lib/pgsql

Of which the include one is the issue according to me. I can't find any =
other include directories..... that could relate to Postgresql.

Tail of apache error log gives:=20
Unknown error
Compilation failed in require at /var/www/sql-ledger/login.pl line 65.
[Tue Jun 19 13:55:49 2001] [error] [client 192.168.1.4] Premature end of =
script headers: /var/www/sql-ledger/login.pl


Changing the first line of login.pl to #!/usr/bin/perl -w gives the =
following result in the httpd error_log

Use of uninitialized value in split at /var/www/sql-ledger/login.pl line =
53.
Use of uninitialized value in read at SL/Form.pm line 44.
Unknown error
Compilation failed in require at /var/www/sql-ledger/login.pl line 65.
[Tue Jun 19 14:03:42 2001] [error] [client 192.168.1.4] Premature end of =
script headers: /var/www/sql-ledger/login.pl


The creation of the databases went fine and I can acces, modify without =
any problems using webmin.

So in short, I need Heeeeeeeeeeeeeeeelp.

Thanks in advance, to you, kind person helping me out.

Regards,

Oscar





________________________________________________________________________

Oscar Buijten

Tel:     +33.4.67.57.97.45
Fax:    +33.4.67.57.97.46
GSM: +33.6.20.84.15.22
Email: os...@el...

http://www.elbie.com

Re: Receipts not posting to acc_trans table

[Benjamin L. <ben...@co...>]

I'm no authority on the code, although I have poked around a bit. ;-)

Firstly, I've honestly never seen this bug before.

Secondly, I suggest turning on the debugging of your SQL server
(e.g. Postgresql) and watch the SQL statements that are logged when
you click 'Process Receipts'... this will definitely show you where
the problem is.


On Sat, Jun 16, 2001 at 09:29:07PM -0500, Michael Bush wrote:
> Hi Everyone:
> 
> Does anyone know where in the SQL-Ledger AR code (i.e. filename, line 
> number) the receipts posting is done so I might track down my issue below?  
> Sorry, I am a little rusty on Perl coding and the program flow of 
> SQL-Ledger.
> 
> Thanks in advance.
> 
> Michael Bush
> -- 
> Digital Minds International
> http://www.DigitalMinds.net
> Tel: 615-661-7900
> Fax: 615-661-7949
> 
> > Hi Dieter:
> > 
> > Just following up our previous e-mail posts, it appears that when
> > posting  receipts under the Receipts menu they are not posting to the
> > acc_trans  table.
> > 
> > We are selecting all open receipts under the Receipts menu and then
> > getting  the results back.  Next, entering in the amounts from the
> > payment received  (note:  not all payments may have been received) we
> > click on Process  Receipts.  No errors messages appear and all looks
> > good.  However, when you  go to Account 1061 in the Account List and
> > search for receipts for the date  you received them on there are no
> > transactions.  I have viewed the acc_trans  table for the transactions
> > and they are not there.  To further confirm this  issue, the Checking
> > Account 1061 balance does not change.
> > 
> > Another note, the acc_trans table will be update if you edit an invoice
> >  payment amount to 0 and then put the amount back. However, the payment
> > date  is the date of the invoice.
> > 
> > Any quick ideas on how to track down and solve this issue?  It did not 
> > appear until upgrading from 1.2.9 to 1.4.3.  It is still happening on
> > 1.4.5.
> > 
> > Regards,
> > 
> > Michael Bush
> > -- 
> > Digital Minds International
> > http://www.DigitalMinds.net
> > Tel: 615-661-7900
> > Fax: 615-661-7949
> 
> 
> 
> 

-- 
B.      http://makelinux.org/    "Always real."    http://realthought.net/
__________________________________________________________________________
The trouble with telling a good story is that it invariably reminds
the other fellow of a dull one.
		-- Sid Caesar

AR problems

[Luca V. <lu...@ye...>]

Hi.

I try to explain my problem: In our company we
receive a lot of payments. A lot of them is not
exactly linked to an invoice. The situation
of a customer is then like a single ledger account:
a lot of invoices and a lot of payments without any
link between the invoices and the payments.

To use the AR module, I need to work a lot to
understand the links between payments and invoices.
Is it somehow possible to tell the module that
I received a payment without link it to an invoice?

Second problem: we have a lot of customer and
the pull down list is huge to handle. We prefer
something like a 'grep' between the customers to
reach a single customer. (i.e. I write in a search
box just 'Imag' and I can add a transaction with
a pull down menu containing just three customers:
'Image Communications', 'New Image' and 'Imaging')

Someone has seen the same problems? Is someone
working on them?

Thanks.

Luca

Re: Apache denied access problem.

[Jess <je...@oz...>]

Aaaaaaaaaahhhhhhhhhh!

I was under the belief that these were paths to the files and SQL-Ledger was
coded to look for the "members" file.
I knew that it did not seem correct the errors that I was getting.  Because
no access restrictions where set.
That is why I wanted to know where exactly in the Perl code did SQL-Ledger
call the members file, so I could see what exactly it was looking for.

So if the file called "membersship.dat" then the
$membersfile variable would be set like this?

$memberfile = "users/members/membersship.dat";
or
$memberfile = "users/membersship.dat";
Depending where you want to store the file!

Put this in the FAQ and Installation instructions so it is clear that the
file itself has to be included in the path for the $memberfile.

I've tried it so it works Peeeerrrrrfectly.

Thank you everyone.

Jess

----- Original Message -----
From: "Dieter Simader" <dsi...@sq...>
To: <sql...@li...>
Sent: Monday, 18 June, 2001 2:53 AM
Subject: Re: Apache denied access problem.


> You answered your own question.
>
> change memberfile to
>
> $memberfile = "users/members/members";
>                ^^^^^^^^^^^^^ ^^^^^^^
>                    path      filename
>
>
> 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 Sun, 17 Jun 2001, Jess wrote:
>
> > Yes, the one supplied with 1.4.5 called members.default was renamed to
> > members, the path is:-
> >
> > |---------- path----------|---file---|
> > sql-ledger/users/members/members
> >
> >
> > sql-ledger.conf variable was modified to:
> > $memberfile = "users/members";
> >
> > The members file contains:-
> > -------------------------------------------------------
> > # members file format is as follows:
> > # username enclosed in square brackets
> > # label= line for setting up hash in signon script
> > # everything up to eof or next [ is read in
> > # ignore anything past a hash mark and empty lines
> >
> > [root login]
> > password=
> > ------------------------------------------------------
> > Regards Jess
>
>
>

Re: Receipts not posting to acc_trans table

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

The date bug was introduced when we added the trial balance. The balances
didn't zero out when the original AP/AR amounts were reduced by the amount
of the payment so I basically recorded the payment date as the invoice
date.

It's all fixed now in version 1.4.6

Instead of reducing the original AR/AP amount an offsetting transaction is
added to keep the balance zero.


When you edit the original transaction and enter a payment the payment
date is assumed to be the invoice date. The only deviation you could
possibly have is when you accept a postdated check for payment.


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, 16 Jun 2001, Michael Bush wrote:

> Hi Dieter:
> 
> Just following up our previous e-mail posts, it appears that when posting 
> receipts under the Receipts menu they are not posting to the acc_trans 
> table.
> 
> We are selecting all open receipts under the Receipts menu and then getting 
> the results back.  Next, entering in the amounts from the payment received 
> (note:  not all payments may have been received) we click on Process 
> Receipts.  No errors messages appear and all looks good.  However, when you 
> go to Account 1061 in the Account List and search for receipts for the date 
> you received them on there are no transactions.  I have viewed the acc_trans 
> table for the transactions and they are not there.  To further confirm this 
> issue, the Checking Account 1061 balance does not change.
> 
> Another note, the acc_trans table will be update if you edit an invoice 
> payment amount to 0 and then put the amount back. However, the payment date 
> is the date of the invoice.
> 
> Any quick ideas on how to track down and solve this issue?  It did not 
> appear until upgrading from 1.2.9 to 1.4.3.  It is still happening on 1.4.5.
> 
> Regards,
> 
> Michael Bush
> 

Re: Apache denied access problem.

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

You answered your own question.

change memberfile to

$memberfile = "users/members/members";
               ^^^^^^^^^^^^^ ^^^^^^^
                   path      filename


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 Sun, 17 Jun 2001, Jess wrote:

> Yes, the one supplied with 1.4.5 called members.default was renamed to
> members, the path is:-
> 
> |---------- path----------|---file---|
> sql-ledger/users/members/members
> 
> 
> sql-ledger.conf variable was modified to:
> $memberfile = "users/members";
> 
> The members file contains:-
> -------------------------------------------------------
> # members file format is as follows:
> # username enclosed in square brackets
> # label= line for setting up hash in signon script
> # everything up to eof or next [ is read in
> # ignore anything past a hash mark and empty lines
> 
> [root login]
> password=
> ------------------------------------------------------
> Regards Jess