sql-ledger-users — SQL-Ledger users

Re: Apache denied access problem.

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

German,
I have tried putting an absolute path in the sql-ledger.conf and the
relative path as shown below.  Both do not work.

I don't understand what the sql-ledger path has to do with the windows path
it is not windows having problems access the members file it it is Apache
through the Sql-Ledger perl program.  Can you explain further what it is you
believe I need to do.

Regards Jess

----- Original Message -----
From: "German Duenas" <g_d...@ya...>
To: <sql...@li...>
Sent: Sunday, 17 June, 2001 3:57 PM
Subject: Re: Apache denied access problem.


> Jess:  By looking at your error.log it tells me that
> the URL is being rerouted and that the old one is no
> longer available. On your apache config you need to
> provide the new path or as part of your settings in
> windows add sql-ledger/users/members as part of your
> path. Good luck  Jerry
> --- Jess <je...@oz...> 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
> >
> > ----- Original Message -----
> > From: "Dieter Simader" <dsi...@sq...>
> > To: <sql...@li...>
> > Sent: Sunday, 17 June, 2001 2:31 AM
> > Subject: Re: Apache denied access problem.
> >
> >
> > > Do you have a members file, if so, where is it?
> > >
> > > sql-ledger.conf has a variable
> > >
> > > $memberfile = "path/filename";
> > >
> > > to specify the location and name for the file.
> > >
> > >
> > > 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, Jess wrote:
> > >
> > > > Hi People,
> > > > I am trying to determine why Apache is giving an
> > ERROR! Permission
> > Denied
> > > > message when there is no access restriction in
> > the file system which a
> > > > standard WIN98 FAT32 Partitioned drive running
> > Windoze 2000 Pro.  As far
> > as
> > > > I can tell there is no restriction in Apache
> > httpd.conf file that would
> > > > disallow access to the users/members directory
> > or file.
> > > >
> > > > So can Dieter or someone who is more intimate
> > with the Perl Code of
> > > > SQL-Ledger tell me where in the code exactly
> > does the admin.pl attempt
> > to
> > > > open the "members" file so I can check to see if
> > the is something in the
> > way
> > > > the file is called or even using a linux based
> > command that may not
> > exist in
> > > > Windoze 2000 pro.
> > > >
> > > > Anyone happy to assist would be welcome.
> > > >
> > > > Regards Jess.
> > > >
> > > >
> > >
> > >
> > >
> > >
> >
> >
>
>
> __________________________________________________
> Do You Yahoo!?
> Spot the hottest trends in music, movies, and more.
> http://buzz.yahoo.com/
>
>

Re: Apache denied access problem.

[German D. <g_d...@ya...>]

Jess:  By looking at your error.log it tells me that
the URL is being rerouted and that the old one is no
longer available. On your apache config you need to
provide the new path or as part of your settings in
windows add sql-ledger/users/members as part of your
path. Good luck  Jerry
--- Jess <je...@oz...> 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
> 
> ----- Original Message -----
> From: "Dieter Simader" <dsi...@sq...>
> To: <sql...@li...>
> Sent: Sunday, 17 June, 2001 2:31 AM
> Subject: Re: Apache denied access problem.
> 
> 
> > Do you have a members file, if so, where is it?
> >
> > sql-ledger.conf has a variable
> >
> > $memberfile = "path/filename";
> >
> > to specify the location and name for the file.
> >
> >
> > 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, Jess wrote:
> >
> > > Hi People,
> > > I am trying to determine why Apache is giving an
> ERROR! Permission
> Denied
> > > message when there is no access restriction in
> the file system which a
> > > standard WIN98 FAT32 Partitioned drive running
> Windoze 2000 Pro.  As far
> as
> > > I can tell there is no restriction in Apache
> httpd.conf file that would
> > > disallow access to the users/members directory
> or file.
> > >
> > > So can Dieter or someone who is more intimate
> with the Perl Code of
> > > SQL-Ledger tell me where in the code exactly
> does the admin.pl attempt
> to
> > > open the "members" file so I can check to see if
> the is something in the
> way
> > > the file is called or even using a linux based
> command that may not
> exist in
> > > Windoze 2000 pro.
> > >
> > > Anyone happy to assist would be welcome.
> > >
> > > Regards Jess.
> > >
> > >
> >
> >
> >
> >
> 
> 


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

Re: Receipts not posting to acc_trans table

[Michael B. <Mi...@di...>]

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

Re: Apache denied access problem.

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

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

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


> Do you have a members file, if so, where is it?
>
> sql-ledger.conf has a variable
>
> $memberfile = "path/filename";
>
> to specify the location and name for the file.
>
>
> 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, Jess wrote:
>
> > Hi People,
> > I am trying to determine why Apache is giving an ERROR! Permission
Denied
> > message when there is no access restriction in the file system which a
> > standard WIN98 FAT32 Partitioned drive running Windoze 2000 Pro.  As far
as
> > I can tell there is no restriction in Apache httpd.conf file that would
> > disallow access to the users/members directory or file.
> >
> > So can Dieter or someone who is more intimate with the Perl Code of
> > SQL-Ledger tell me where in the code exactly does the admin.pl attempt
to
> > open the "members" file so I can check to see if the is something in the
way
> > the file is called or even using a linux based command that may not
exist in
> > Windoze 2000 pro.
> >
> > Anyone happy to assist would be welcome.
> >
> > Regards Jess.
> >
> >
>
>
>
>

Receipts not posting to acc_trans table

[Michael B. <Mi...@di...>]

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

Re: Apache denied access problem.

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

Do you have a members file, if so, where is it?

sql-ledger.conf has a variable

$memberfile = "path/filename";

to specify the location and name for the file.


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, Jess wrote:

> Hi People,
> I am trying to determine why Apache is giving an ERROR! Permission Denied
> message when there is no access restriction in the file system which a
> standard WIN98 FAT32 Partitioned drive running Windoze 2000 Pro.  As far as
> I can tell there is no restriction in Apache httpd.conf file that would
> disallow access to the users/members directory or file.
> 
> So can Dieter or someone who is more intimate with the Perl Code of
> SQL-Ledger tell me where in the code exactly does the admin.pl attempt to
> open the "members" file so I can check to see if the is something in the way
> the file is called or even using a linux based command that may not exist in
> Windoze 2000 pro.
> 
> Anyone happy to assist would be welcome.
> 
> Regards Jess.
> 
> 

Re: Apache denied access problem.

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

Hi People,
I am trying to determine why Apache is giving an ERROR! Permission Denied
message when there is no access restriction in the file system which a
standard WIN98 FAT32 Partitioned drive running Windoze 2000 Pro.  As far as
I can tell there is no restriction in Apache httpd.conf file that would
disallow access to the users/members directory or file.

So can Dieter or someone who is more intimate with the Perl Code of
SQL-Ledger tell me where in the code exactly does the admin.pl attempt to
open the "members" file so I can check to see if the is something in the way
the file is called or even using a linux based command that may not exist in
Windoze 2000 pro.

Anyone happy to assist would be welcome.

Regards Jess.


----- Original Message -----
From: "Jess" <je...@oz...>
To: <sql...@li...>
Sent: Friday, 15 June, 2001 5:09 PM
Subject: Re: Apache denied access problem.


> Hi German,
> The access log file for this website is here:
> 192.168.1.3 - - [15/Jun/2001:01:16:57 +1000] "GET /sqll/login.pl HTTP/1.1"
> 200 1090
> 192.168.1.3 - - [15/Jun/2001:01:16:58 +1000] "GET /sqll/sql-ledger.gif
> HTTP/1.1" 304 -
> 192.168.1.3 - - [15/Jun/2001:01:17:14 +1000] "GET /sqll/admin.pl HTTP/1.1"
> 200 713
> 192.168.1.3 - - [15/Jun/2001:01:17:14 +1000] "GET /sqll/sql-ledger.gif
> HTTP/1.1" 304 -
> 192.168.1.3 - - [15/Jun/2001:01:17:21 +1000] "POST /sqll/admin.pl
HTTP/1.1"
> 200 119
> 192.168.1.3 - - [15/Jun/2001:12:46:12 +1000] "GET /sqll/login.pl HTTP/1.1"
> 200 1090
> 192.168.1.3 - - [15/Jun/2001:12:46:13 +1000] "GET /sqll/sql-ledger.gif
> HTTP/1.1" 304 -
> 192.168.1.3 - - [15/Jun/2001:12:46:21 +1000] "GET /sqll/admin.pl HTTP/1.1"
> 200 713
> 192.168.1.3 - - [15/Jun/2001:12:46:21 +1000] "GET /sqll/sql-ledger.gif
> HTTP/1.1" 304 -
> 192.168.1.3 - - [15/Jun/2001:12:46:24 +1000] "POST /sqll/admin.pl
HTTP/1.1"
> 200 119
> There was no entry in the error log file at all.
> What does the codes 200 119 & 200 713 mean?
>
> I am not sure what is happening.  What was the change between 1.2.10  and
> 1.4.* in its security coding.  I remember Dieter saying something about
not
> needing to use cookies in 1.4.*.
>
> Regards Jess
>
>
>
>
> ----- Original Message -----
> From: "German Duenas" <g_d...@ya...>
> To: <sql...@li...>
> Sent: Friday, 15 June, 2001 4:01 PM
> Subject: Re: Apache denied access problem.
>
>
> > FAT32 and NTFS have different restrictions as you have
> > mentioned. I encountered the same problem with apache
> > and yes you have to have full access to the directory
> > otherwise it will give you error 403. If you go into
> > the directory where apache keeps its logs files and
> > check file error.log or error1.log you can see the
> > actual problem why the file is being locked and
> > preventing you access. Jerry
> > --- Jess <je...@oz...> wrote:
> > > Thanks for the reply Alexander.
> > >
> > > But as I mentioned below this is on a Windoze 2000
> > > Pro on a FAT32 partition
> > > that does not support file system level permissions,
> > > so as far as W2K pro is
> > > concerned all files on a FAT32 are available to
> > > anyone who has user access
> > > to that computer.  So in this situation I don't
> > > believe W2K is restricting
> > > access to the users/members.
> > >
> > > Any other ideas I could persue.
> > >
> > > Regards Jess
> > >
> > >
> > > ----- Original Message -----
> > > From: "Alexander Orozco" <ao...@pr...>
> > > To: <sql...@li...>
> > > Sent: Thursday, 14 June, 2001 8:51 PM
> > > Subject: RE: Apache denied access problem.
> > >
> > >
> > > > that means that directory is not accessible
> > > through apache
> > > > you might have to change permissions
> > > > start with:
> > > > chmod 0777 users/members
> > > > chmod 0777 users/members/*
> > > >
> > > > change to 0777 just to make sure that was the
> > > problem,
> > > > then tweak the permissions to your desired
> > > security level
> > > >
> > > > -----Original Message-----
> > > > From: sql...@li...
> > > >
> > >
> > [mailto:sql...@li...]On
> > > Behalf Of Jess
> > > > Sent: Thursday, June 14, 2001 3:52 AM
> > > > To: sql...@li...
> > > > Subject: Apache denied access problem.
> > > >
> > > >
> > > > On version 1.4.5 of SQL-Ledger.
> > > >
> > > > When I run the admin.pl script I get this error
> > > after I press submit with
> > > or
> > > > without a password.
> > > > -----------------
> > > > Error!
> > > > Permission denied: users/members
> > > > -----------------
> > > > The file in users/members/ is the default
> > > "members" that comes with
> > > > SQL-Ledger.
> > > >
> > > > Now this is running under Windoze 2000 Pro but on
> > > a FAT32 partition so
> > > there
> > > > is no direct support for file permissions where
> > > the files are.  (This is
> > > > just a development system, so I can understand how
> > > the security system in
> > > > Apache works which is currently eluding me.).
> > > > So I believe it is Apache restricting access to
> > > this area.  The virtual
> > > host
> > > > section is set as:
> > > > -----------------------------------------
> > > > <VirtualHost 192.168.10.13>
> > > > ServerAdmin me...@oz...
> > > > DocumentRoot /www/websites/bookmen
> > > > ServerName 192.168.10.13
> > > > ScriptAlias   /cgi-bin/
> > > /www/websites/bookmen/cgi-bin/
> > > >     <Directory /www/websites/bookmen>
> > > >         Options FollowSymLinks Includes Multiviews
> > > >         Order allow,deny
> > > >         Allow from all
> > > >     </Directory>
> > > > Alias    /sqll/    /www/websites/bookmen/sqll/
> > > >     <Directory /www/websites/bookmen/sqll>
> > > >         Options FollowSymLinks ExecCGI Includes
> > > Multiviews
> > > >     </Directory>
> > > > ErrorLog /www/websites/bookmen/logs/error_log
> > > > TransferLog /www/websites/bookmen/logs/access_log
> > > > </VirtualHost>
> > > > ----------------------------------------
> > > >
> > > > /www/websites/bookmen/sqll is the path to
> > > SQL-Ledger tree hierarchy.
> > > >
> > > > Can anyone see a problem why I would get :
> > > > -----------------
> > > > Error!
> > > > Permission denied: users/members
> > > > -----------------
> > > >
> > > > Regards Jess
> > > >
> > > >
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Spot the hottest trends in music, movies, and more.
> > http://buzz.yahoo.com/
> >
> >
>
>
>

Re: Internal Server Configuration

[German D. <g_d...@ya...>]

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/

Internal Server Configuration

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

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

Re: Apache denied access problem.

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

Hi German,
The access log file for this website is here:
192.168.1.3 - - [15/Jun/2001:01:16:57 +1000] "GET /sqll/login.pl HTTP/1.1"
200 1090
192.168.1.3 - - [15/Jun/2001:01:16:58 +1000] "GET /sqll/sql-ledger.gif
HTTP/1.1" 304 -
192.168.1.3 - - [15/Jun/2001:01:17:14 +1000] "GET /sqll/admin.pl HTTP/1.1"
200 713
192.168.1.3 - - [15/Jun/2001:01:17:14 +1000] "GET /sqll/sql-ledger.gif
HTTP/1.1" 304 -
192.168.1.3 - - [15/Jun/2001:01:17:21 +1000] "POST /sqll/admin.pl HTTP/1.1"
200 119
192.168.1.3 - - [15/Jun/2001:12:46:12 +1000] "GET /sqll/login.pl HTTP/1.1"
200 1090
192.168.1.3 - - [15/Jun/2001:12:46:13 +1000] "GET /sqll/sql-ledger.gif
HTTP/1.1" 304 -
192.168.1.3 - - [15/Jun/2001:12:46:21 +1000] "GET /sqll/admin.pl HTTP/1.1"
200 713
192.168.1.3 - - [15/Jun/2001:12:46:21 +1000] "GET /sqll/sql-ledger.gif
HTTP/1.1" 304 -
192.168.1.3 - - [15/Jun/2001:12:46:24 +1000] "POST /sqll/admin.pl HTTP/1.1"
200 119
There was no entry in the error log file at all.
What does the codes 200 119 & 200 713 mean?

I am not sure what is happening.  What was the change between 1.2.10  and
1.4.* in its security coding.  I remember Dieter saying something about not
needing to use cookies in 1.4.*.

Regards Jess




----- Original Message -----
From: "German Duenas" <g_d...@ya...>
To: <sql...@li...>
Sent: Friday, 15 June, 2001 4:01 PM
Subject: Re: Apache denied access problem.


> FAT32 and NTFS have different restrictions as you have
> mentioned. I encountered the same problem with apache
> and yes you have to have full access to the directory
> otherwise it will give you error 403. If you go into
> the directory where apache keeps its logs files and
> check file error.log or error1.log you can see the
> actual problem why the file is being locked and
> preventing you access. Jerry
> --- Jess <je...@oz...> wrote:
> > Thanks for the reply Alexander.
> >
> > But as I mentioned below this is on a Windoze 2000
> > Pro on a FAT32 partition
> > that does not support file system level permissions,
> > so as far as W2K pro is
> > concerned all files on a FAT32 are available to
> > anyone who has user access
> > to that computer.  So in this situation I don't
> > believe W2K is restricting
> > access to the users/members.
> >
> > Any other ideas I could persue.
> >
> > Regards Jess
> >
> >
> > ----- Original Message -----
> > From: "Alexander Orozco" <ao...@pr...>
> > To: <sql...@li...>
> > Sent: Thursday, 14 June, 2001 8:51 PM
> > Subject: RE: Apache denied access problem.
> >
> >
> > > that means that directory is not accessible
> > through apache
> > > you might have to change permissions
> > > start with:
> > > chmod 0777 users/members
> > > chmod 0777 users/members/*
> > >
> > > change to 0777 just to make sure that was the
> > problem,
> > > then tweak the permissions to your desired
> > security level
> > >
> > > -----Original Message-----
> > > From: sql...@li...
> > >
> >
> [mailto:sql...@li...]On
> > Behalf Of Jess
> > > Sent: Thursday, June 14, 2001 3:52 AM
> > > To: sql...@li...
> > > Subject: Apache denied access problem.
> > >
> > >
> > > On version 1.4.5 of SQL-Ledger.
> > >
> > > When I run the admin.pl script I get this error
> > after I press submit with
> > or
> > > without a password.
> > > -----------------
> > > Error!
> > > Permission denied: users/members
> > > -----------------
> > > The file in users/members/ is the default
> > "members" that comes with
> > > SQL-Ledger.
> > >
> > > Now this is running under Windoze 2000 Pro but on
> > a FAT32 partition so
> > there
> > > is no direct support for file permissions where
> > the files are.  (This is
> > > just a development system, so I can understand how
> > the security system in
> > > Apache works which is currently eluding me.).
> > > So I believe it is Apache restricting access to
> > this area.  The virtual
> > host
> > > section is set as:
> > > -----------------------------------------
> > > <VirtualHost 192.168.10.13>
> > > ServerAdmin me...@oz...
> > > DocumentRoot /www/websites/bookmen
> > > ServerName 192.168.10.13
> > > ScriptAlias   /cgi-bin/
> > /www/websites/bookmen/cgi-bin/
> > >     <Directory /www/websites/bookmen>
> > >         Options FollowSymLinks Includes Multiviews
> > >         Order allow,deny
> > >         Allow from all
> > >     </Directory>
> > > Alias    /sqll/    /www/websites/bookmen/sqll/
> > >     <Directory /www/websites/bookmen/sqll>
> > >         Options FollowSymLinks ExecCGI Includes
> > Multiviews
> > >     </Directory>
> > > ErrorLog /www/websites/bookmen/logs/error_log
> > > TransferLog /www/websites/bookmen/logs/access_log
> > > </VirtualHost>
> > > ----------------------------------------
> > >
> > > /www/websites/bookmen/sqll is the path to
> > SQL-Ledger tree hierarchy.
> > >
> > > Can anyone see a problem why I would get :
> > > -----------------
> > > Error!
> > > Permission denied: users/members
> > > -----------------
> > >
> > > Regards Jess
> > >
> > >
> > >
> > >
> > >
> >
> >
>
>
> __________________________________________________
> Do You Yahoo!?
> Spot the hottest trends in music, movies, and more.
> http://buzz.yahoo.com/
>
>

(no subject)

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

Dieter,

Find attached some interesting (?) modifications to the Invoicing
code.

1. The 'Update Form' now (basically) does the same thing as the 'Add
   Item'. I just used a wrapper. This was a user request, because they
   couldn't understand the process. Now they can happily press 'Update
   Form' instead of 'Add Item' and it'll all still work.

2. The 'Due Date' is recalculated on 'Update Form'. This is also just
   as useless because most of the time you post today. Oh well.

Patch if you like (made against 1.4.5).

Apologies for the colour changes...

perl -pi -e 's|\Q#000066\E|336666|g;'



--=20
B.      http://makelinux.org/    "Always real."    http://realthought.net/
__________________________________________________________________________
Man 1:	Ask me the what the most important thing about telling a good joke i=
s.

Man 2:	OK, what is the most impo --

Man 1:	______=08=08=08=08=08=08TIMING!

Re: Apache denied access problem.

[German D. <g_d...@ya...>]

FAT32 and NTFS have different restrictions as you have
mentioned. I encountered the same problem with apache
and yes you have to have full access to the directory
otherwise it will give you error 403. If you go into
the directory where apache keeps its logs files and
check file error.log or error1.log you can see the
actual problem why the file is being locked and
preventing you access. Jerry
--- Jess <je...@oz...> wrote:
> Thanks for the reply Alexander.
> 
> But as I mentioned below this is on a Windoze 2000
> Pro on a FAT32 partition
> that does not support file system level permissions,
> so as far as W2K pro is
> concerned all files on a FAT32 are available to
> anyone who has user access
> to that computer.  So in this situation I don't
> believe W2K is restricting
> access to the users/members.
> 
> Any other ideas I could persue.
> 
> Regards Jess
> 
> 
> ----- Original Message -----
> From: "Alexander Orozco" <ao...@pr...>
> To: <sql...@li...>
> Sent: Thursday, 14 June, 2001 8:51 PM
> Subject: RE: Apache denied access problem.
> 
> 
> > that means that directory is not accessible
> through apache
> > you might have to change permissions
> > start with:
> > chmod 0777 users/members
> > chmod 0777 users/members/*
> >
> > change to 0777 just to make sure that was the
> problem,
> > then tweak the permissions to your desired
> security level
> >
> > -----Original Message-----
> > From: sql...@li...
> >
>
[mailto:sql...@li...]On
> Behalf Of Jess
> > Sent: Thursday, June 14, 2001 3:52 AM
> > To: sql...@li...
> > Subject: Apache denied access problem.
> >
> >
> > On version 1.4.5 of SQL-Ledger.
> >
> > When I run the admin.pl script I get this error
> after I press submit with
> or
> > without a password.
> > -----------------
> > Error!
> > Permission denied: users/members
> > -----------------
> > The file in users/members/ is the default
> "members" that comes with
> > SQL-Ledger.
> >
> > Now this is running under Windoze 2000 Pro but on
> a FAT32 partition so
> there
> > is no direct support for file permissions where
> the files are.  (This is
> > just a development system, so I can understand how
> the security system in
> > Apache works which is currently eluding me.).
> > So I believe it is Apache restricting access to
> this area.  The virtual
> host
> > section is set as:
> > -----------------------------------------
> > <VirtualHost 192.168.10.13>
> > ServerAdmin me...@oz...
> > DocumentRoot /www/websites/bookmen
> > ServerName 192.168.10.13
> > ScriptAlias   /cgi-bin/    
> /www/websites/bookmen/cgi-bin/
> >     <Directory /www/websites/bookmen>
> >         Options FollowSymLinks Includes Multiviews
> >         Order allow,deny
> >         Allow from all
> >     </Directory>
> > Alias    /sqll/    /www/websites/bookmen/sqll/
> >     <Directory /www/websites/bookmen/sqll>
> >         Options FollowSymLinks ExecCGI Includes
> Multiviews
> >     </Directory>
> > ErrorLog /www/websites/bookmen/logs/error_log
> > TransferLog /www/websites/bookmen/logs/access_log
> > </VirtualHost>
> > ----------------------------------------
> >
> > /www/websites/bookmen/sqll is the path to
> SQL-Ledger tree hierarchy.
> >
> > Can anyone see a problem why I would get :
> > -----------------
> > Error!
> > Permission denied: users/members
> > -----------------
> >
> > Regards Jess
> >
> >
> >
> >
> >
> 
> 


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

datepaid column data missing from ar.pl

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

In 1.4.5, sub ar_transactions in ar.pl is missing the data for the
datepaid column (around line 456).


    $column_data{datepaid} = "<td>$ar->{datepaid}&nbsp;</td>";


or the way I like it ;-)

    $column_data{datepaid} = qq|<td class="list_item">$ar->{datepaid}&nbsp;</td>|;



-- 
B.      http://makelinux.org/    "Always real."    http://realthought.net/
__________________________________________________________________________
The wise man seeks everything in himself; the ignorant man tries to get
everything from somebody else.

Re: Apache denied access problem.

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

Thanks for the reply Alexander.

But as I mentioned below this is on a Windoze 2000 Pro on a FAT32 partition
that does not support file system level permissions, so as far as W2K pro is
concerned all files on a FAT32 are available to anyone who has user access
to that computer.  So in this situation I don't believe W2K is restricting
access to the users/members.

Any other ideas I could persue.

Regards Jess


----- Original Message -----
From: "Alexander Orozco" <ao...@pr...>
To: <sql...@li...>
Sent: Thursday, 14 June, 2001 8:51 PM
Subject: RE: Apache denied access problem.


> that means that directory is not accessible through apache
> you might have to change permissions
> start with:
> chmod 0777 users/members
> chmod 0777 users/members/*
>
> change to 0777 just to make sure that was the problem,
> then tweak the permissions to your desired security level
>
> -----Original Message-----
> From: sql...@li...
> [mailto:sql...@li...]On Behalf Of Jess
> Sent: Thursday, June 14, 2001 3:52 AM
> To: sql...@li...
> Subject: Apache denied access problem.
>
>
> On version 1.4.5 of SQL-Ledger.
>
> When I run the admin.pl script I get this error after I press submit with
or
> without a password.
> -----------------
> Error!
> Permission denied: users/members
> -----------------
> The file in users/members/ is the default "members" that comes with
> SQL-Ledger.
>
> Now this is running under Windoze 2000 Pro but on a FAT32 partition so
there
> is no direct support for file permissions where the files are.  (This is
> just a development system, so I can understand how the security system in
> Apache works which is currently eluding me.).
> So I believe it is Apache restricting access to this area.  The virtual
host
> section is set as:
> -----------------------------------------
> <VirtualHost 192.168.10.13>
> ServerAdmin me...@oz...
> DocumentRoot /www/websites/bookmen
> ServerName 192.168.10.13
> ScriptAlias   /cgi-bin/     /www/websites/bookmen/cgi-bin/
>     <Directory /www/websites/bookmen>
>         Options FollowSymLinks Includes Multiviews
>         Order allow,deny
>         Allow from all
>     </Directory>
> Alias    /sqll/    /www/websites/bookmen/sqll/
>     <Directory /www/websites/bookmen/sqll>
>         Options FollowSymLinks ExecCGI Includes Multiviews
>     </Directory>
> ErrorLog /www/websites/bookmen/logs/error_log
> TransferLog /www/websites/bookmen/logs/access_log
> </VirtualHost>
> ----------------------------------------
>
> /www/websites/bookmen/sqll is the path to SQL-Ledger tree hierarchy.
>
> Can anyone see a problem why I would get :
> -----------------
> Error!
> Permission denied: users/members
> -----------------
>
> Regards Jess
>
>
>
>
>

RE: Apache denied access problem.

[Alexander O. <ao...@pr...>]

that means that directory is not accessible through apache
you might have to change permissions
start with:
chmod 0777 users/members
chmod 0777 users/members/*

change to 0777 just to make sure that was the problem,
then tweak the permissions to your desired security level

-----Original Message-----
From: sql...@li...
[mailto:sql...@li...]On Behalf Of Jess
Sent: Thursday, June 14, 2001 3:52 AM
To: sql...@li...
Subject: Apache denied access problem.


On version 1.4.5 of SQL-Ledger.

When I run the admin.pl script I get this error after I press submit with or
without a password.
-----------------
Error!
Permission denied: users/members
-----------------
The file in users/members/ is the default "members" that comes with
SQL-Ledger.

Now this is running under Windoze 2000 Pro but on a FAT32 partition so there
is no direct support for file permissions where the files are.  (This is
just a development system, so I can understand how the security system in
Apache works which is currently eluding me.).
So I believe it is Apache restricting access to this area.  The virtual host
section is set as:
-----------------------------------------
<VirtualHost 192.168.10.13>
ServerAdmin me...@oz...
DocumentRoot /www/websites/bookmen
ServerName 192.168.10.13
ScriptAlias   /cgi-bin/     /www/websites/bookmen/cgi-bin/
    <Directory /www/websites/bookmen>
        Options FollowSymLinks Includes Multiviews
        Order allow,deny
        Allow from all
    </Directory>
Alias    /sqll/    /www/websites/bookmen/sqll/
    <Directory /www/websites/bookmen/sqll>
        Options FollowSymLinks ExecCGI Includes Multiviews
    </Directory>
ErrorLog /www/websites/bookmen/logs/error_log
TransferLog /www/websites/bookmen/logs/access_log
</VirtualHost>
----------------------------------------

/www/websites/bookmen/sqll is the path to SQL-Ledger tree hierarchy.

Can anyone see a problem why I would get :
-----------------
Error!
Permission denied: users/members
-----------------

Regards Jess

Apache denied access problem.

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

On version 1.4.5 of SQL-Ledger.

When I run the admin.pl script I get this error after I press submit with or
without a password.
-----------------
Error!
Permission denied: users/members
-----------------
The file in users/members/ is the default "members" that comes with
SQL-Ledger.

Now this is running under Windoze 2000 Pro but on a FAT32 partition so there
is no direct support for file permissions where the files are.  (This is
just a development system, so I can understand how the security system in
Apache works which is currently eluding me.).
So I believe it is Apache restricting access to this area.  The virtual host
section is set as:
-----------------------------------------
<VirtualHost 192.168.10.13>
ServerAdmin me...@oz...
DocumentRoot /www/websites/bookmen
ServerName 192.168.10.13
ScriptAlias   /cgi-bin/     /www/websites/bookmen/cgi-bin/
    <Directory /www/websites/bookmen>
        Options FollowSymLinks Includes Multiviews
        Order allow,deny
        Allow from all
    </Directory>
Alias    /sqll/    /www/websites/bookmen/sqll/
    <Directory /www/websites/bookmen/sqll>
        Options FollowSymLinks ExecCGI Includes Multiviews
    </Directory>
ErrorLog /www/websites/bookmen/logs/error_log
TransferLog /www/websites/bookmen/logs/access_log
</VirtualHost>
----------------------------------------

/www/websites/bookmen/sqll is the path to SQL-Ledger tree hierarchy.

Can anyone see a problem why I would get :
-----------------
Error!
Permission denied: users/members
-----------------

Regards Jess

Re: Problems with 1.4.?

[Andrew S. <an...@ne...>]

On windoze, I've always had good luck getting the windows "shortcut"
concept to work in the place of unix symlinks.  I don't know how to
create shortcuts from the DOS command line, but they are easy enough
to create with the UI.

a

Dieter Simader wrote:
> 
> A symlink is a link to another file. To substitute for the symlinks you
> can do the following.
> 
> Thanks to Martin Lillepuu who patched 1.4.5 to work with Win2K
> 
> Here is a manual patch.
> 
> Edit login.pl and am.pl and change the first line
> #!/usr/bin/perl to #!c:/perl/bin/perl.exe
> 
> Substitute c:/perl/bin with wherever your perl is installed. I suppose
> #!perl will work too as long as the path is included in the PATH
> environment variable
> 
> copy login.pl to admin.pl
> 
> copy am.pl to
> ap.pl
> ar.pl
> ca.pl
> rp.pl
> ct.pl
> gl.pl
> ic.pl
> ir.pl
> is.pl
> menu.pl
> 
> Edit SL/Form.pm and change line 158 to
> 
>     exec "c:/perl/bin/perl.exe", $argv;
> 
> 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, 10 Jun 2001, Jess wrote:
> 
> > Hi Dieter,
> > What is a symlink? I don't believe that exists in Windows 2000 Pro does it.?
> > How can I set it up to work under W2K-Pro?
> >
> > Thankyou for your help.
> >
> > Regards Jess

request - more sub-total details on invoices

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

Dieter,

If you happen to be poking around in the is/ir code... ;-) Would it be
possible to have a 'sub-total' column added to the end of each row
(after Price and Disc)?

Also, any plans for more date calculations, e.g. in invoices click
Update Form, and the due date is recalculated (since the user may
change the issued date)?

You can tell me to stop asking and do it myself of course! Heheh...

However, one thing that is more core, and probably better for you to
take a look at is the term 'Number' in the invoices (both cust. and
vend.). I was informed that a better term would be 'Item Number'
... and this makes sense to me because when one translates for a
different locale -- 'Number' in the invoices isn't equivalent to say
'Number' somewhere else, e.g. Setup -- Tax Account -- Number.

Of course, maybe the Setup page just needs 'Account Number' instead of
'Number'... now I'm babbling. ;-P

Later,
Ben.

-- 
B.      http://makelinux.org/    "Always real."    http://realthought.net/
__________________________________________________________________________
It's hard to get ivory in Africa, but in Alabama the Tuscaloosa.
		-- Groucho Marx

Re: adding CSS to customise fonts and colours

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

Heya Dieter,

Find the diff attached for ar.pl (against 1.4.5).

You'll notice that I've left the various <FONT> tags intact as much as
possible, for the moment, to allow for backwards compatibility (the
old look?).

The really only added HTML code is the outer table (which can be used
for a nice border) and the coloured lines trickery. The rest is just
replacement of " with qq|, and the class= stuff.

FYI, these are the current classes.
perl -n -e 'if ( m/class=\"[^\"]*\"/ ) { print $& . "\n"; }' < ar.pl | sort | uniq

class="list_heading"
class="list_inner_table"
class="list_item"
class="list_outer_table"
class="list_row_1"
class="list_row_2"
class="list_total"

list_inner_table, list_outer_table are only placeholders at the
moment.

I'm thinking there'll soon be a need for list_sub_total. Anyway,
that's for later.

Here's the stylesheet I've been using. I just put it in Form.pm.


<style type="text/css">
<!--
body { background-color: #ffffff; }

.list_inner_table { }
.list_outer_table { }

.list_heading { 
  font-family: arial, helvetica, san-serif; 
  font-size: 13px; font-weight: bold; 
  color: #003399; background-color: #000066; padding-top: 1px; 
  }

.list_item { 
  font-family: arial, helvetica, san-serif; 
  font-size: 12px; 
  padding-top: 1px; padding-left: 2px; padding-right: 2px; 
  }

.list_row_1 { background-color: #eeeeee; }
.list_row_2 { background-color: #ddddee; }

.list_total { 
  font-family: arial, helvetica, san-serif; 
  font-size: 13px; font-weight: bold; 
  color: #ffffff; background-color: #000000; padding-top: 1px;
  }

-->
</style>


As for RTL stuff, I think it's just a matter of adding the 'direction:
rtl;' attribute. I must admit, I'm unfamiliar with this setting. ;-O

Cheers!
Ben.

P.S. I think I forgot to attach the screenshots... I always forget
attachments.


On Tue, Jun 12, 2001 at 10:08:06AM -0600, Dieter Simader wrote:
> Hi Ben!
> 
> I think adding CSS is an excellent idea. While we are at it can you
> mirror image the display to read from right to left. This would come 
> in handy to fix the display issues for Arabic languages.
> 
> Yes, send me a diff of your hack.
> 
> 
> 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, 12 Jun 2001, Benjamin Lee wrote:
> 
> > Whilst in the process of beautifying some other things, I found myself
> > beginning to hack away at the HTML parts of SL.
> > 
> > I attach screenshots of the AR transactions search as an example of
> > adding CSS to SL. With CSS (although it's certainly by no means
> > perfect), it's quite straight forward enough to customise fonts and
> > colours for an individual / company.
> > 
> > Anyway, Dieter, if you're interested I'll send you a diff of the hack
> > in progress.
> > 
> > Cheers all,
> > Ben.
> > 
> > 

-- 
B.      http://makelinux.org/    "Always real."    http://realthought.net/
__________________________________________________________________________
One advantage of talking to yourself is that you know at least somebody's
listening.
		-- Franklin P. Jones

Re: User guide

[Glenn R. <gl...@co...>]

Dieter Simader wrote:
> 
> A user's manual is in the works.

Who is doing it? Do they want any help? Can we get a preview?

g

-- 
Glenn Ramsey
gl...@co...

adding CSS to customise fonts and colours

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

Whilst in the process of beautifying some other things, I found myself
beginning to hack away at the HTML parts of SL.

I attach screenshots of the AR transactions search as an example of
adding CSS to SL. With CSS (although it's certainly by no means
perfect), it's quite straight forward enough to customise fonts and
colours for an individual / company.

Anyway, Dieter, if you're interested I'll send you a diff of the hack
in progress.

Cheers all,
Ben.

-- 
B.      http://makelinux.org/    "Always real."    http://realthought.net/
__________________________________________________________________________
Carson's Consolation:
	Nothing is ever a complete failure.
	It can always be used as a bad example.

SQL-Ledger data dump issue

[Michael B. <Mi...@di...>]

In an effort to isolate a SQL-Ledger query issue, I was trying to do a 
pg_dumpall command to export and reimport my data.  I keep getting the error 
below when trying to do any dumps.

dumpRules(): SELECT failed for table openrec.  Explanation from backend: 
'ERROR:  cache lookup of attribute 1 in relation 19013 failed
'.

Does anyone have any ideas how to fix this issue?

Thanks in advance.

Regards,

Michael Bush
-- 
Digital Minds International
http://www.DigitalMinds.net
Tel: 615-661-7900
Fax: 615-661-7949

Re: User guide

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

A user's manual is in the works.

When it will be done, I don't know yet.


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, 10 Jun 2001, Glenn Ramsey wrote:

> 
> Are there any plans to make a user guide for sql-ledger? I
> remember seeing this near the top of a TO DO list on the web site
> a while ago but I can't find it now. 
> 
> If no-one is working on this then I'll start it, however since my
> accounting knowledge is quite limited I'd need a bit of help from
> people on this list.
> 
> If there is already a manual started, then can someone please
> direct me to it?
> 
> g
> 
> 

Re: Problems with 1.4.?

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

A symlink is a link to another file. To substitute for the symlinks you
can do the following.

Thanks to Martin Lillepuu who patched 1.4.5 to work with Win2K

Here is a manual patch.

Edit login.pl and am.pl and change the first line
#!/usr/bin/perl to #!c:/perl/bin/perl.exe

Substitute c:/perl/bin with wherever your perl is installed. I suppose
#!perl will work too as long as the path is included in the PATH
environment variable

copy login.pl to admin.pl

copy am.pl to
ap.pl
ar.pl
ca.pl
rp.pl
ct.pl
gl.pl
ic.pl
ir.pl
is.pl
menu.pl


Edit SL/Form.pm and change line 158 to

    exec "c:/perl/bin/perl.exe", $argv;


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

> Hi Dieter,
> What is a symlink? I don't believe that exists in Windows 2000 Pro does it.?
> How can I set it up to work under W2K-Pro?
> 
> Thankyou for your help.
> 
> Regards Jess

Error trying to delete or update a transaction

[Glenn R. <gl...@co...>]

Hi,

Using sql-ledger 1.4.5 I started with a fresh install and a clean
database.  I added a single vendor and a single transaction using
the AP Add Transaction function.  Now when I try to delete or
change that transaction it I get this error in the browser window:

ERROR: parser: parse error at or near "" SELECT balance FROM chart
WHERE accno = 

Is this a bug or have I done something wrong?

g

-- 
Glenn Ramsey
gl...@co...