sql-ledger-users — SQL-Ledger users

Re: Problems with 1.4.?

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

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




----- Original Message -----
From: "Dieter Simader" <dsi...@sq...>
To: <sql...@li...>
Sent: Sunday, 10 June, 2001 2:00 AM
Subject: Re: Problems with 1.4.?


> symlink admin.pl to login.pl
>
>
> 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:
> >
> > Now there is no http://localhost/cgi-bin/sql-ledger/admin.pl in that
> > directory there is only login.pl and am.pl
>
>
>

User guide

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

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

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

Re: Problems with 1.4.?

[Neil J. <ne...@jo...>]

On June  9, 2001 09:04 am, you wrote:
> Hi Dieter,
>
> Just to make this clear straight of the bat prior to version 1.4 of
> SQL-Ledger I had no problems running SQL-Ledger in the 1.2.* variety.
>
> I clean installed SQL ledger.
>
> Now I cleaned out all the SQL tables and downloaded SQL-Ledger 1.4.4 from
> your Web Site unpacked it and recreated the tables from the acc-PG.sql
> file. I removed any traces of the previous SQL-LEDGER 1.2.* which was
> working. I then move the SQL-Ledger directory with the login.pl and
> sql-ledger.conf file and all subdirectories to the web document root called
> /www/websites/bookmen/sqll  I also created any directories that where
> called in the sql-ledger.conf file so that it could find anything it was
> looking for.
> I read the FAQ and the README and it said to:
>
SNIP

I had the same problems trying to move from 1.2 to a fresh install of 1.4.4. 
Grab the latest version (1.4.5), and try it. I had no problems whatsoever 
with 1.4.5.

Neil

Re: Problems with 1.4.?

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

symlink admin.pl to login.pl


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:
> 
> Now there is no http://localhost/cgi-bin/sql-ledger/admin.pl in that
> directory there is only login.pl and am.pl

Problems with 1.4.?

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

Hi Dieter,

Just to make this clear straight of the bat prior to version 1.4 of
SQL-Ledger I had no problems running SQL-Ledger in the 1.2.* variety.

I clean installed SQL ledger.

Now I cleaned out all the SQL tables and downloaded SQL-Ledger 1.4.4 from
your Web Site unpacked it and recreated the tables from the acc-PG.sql file.
I removed any traces of the previous SQL-LEDGER 1.2.* which was working.
I then move the SQL-Ledger directory with the login.pl and sql-ledger.conf
file and all subdirectories to the web document root called
/www/websites/bookmen/sqll  I also created any directories that where called
in the sql-ledger.conf file so that it could find anything it was looking
for.
I read the FAQ and the README and it said to:

SETUP A USER:
-------------
Load your web browser and enter the URL
http://localhost/cgi-bin/sql-ledger/admin.pl and add a user. If you specify
a different database then the one you just created
in the previous step, make sure the database and tables exist.
(see previous step) LOAD THE ACCOUNTING PROGRAM:
----------------------------
Load your web browser and enter the URL
http://localhost/cgi-bin/sql-ledger/login.pl


Now there is no http://localhost/cgi-bin/sql-ledger/admin.pl in that
directory there is only login.pl and am.pl

If I open the admin.pl in the "bin/mozilla" directory the is no shebang line
or "require" command for the .conf file on any of these files which leads me
to believe that these files are read into a calling .pl file probably
login.pl.

How do you add or create a user?    What .pl file in what directory needs to
be run and what needs to be entered in the Browser URL to call it?

There is something fundamental I am not aware of that must be causing these
problems?
Your assistence is needed.

SQL Ledger is being run on W2K Pro with PG 703 and perl5, apache 1.3.14.

Regards Jess

Re: NEED taxes on taxes here

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

Hi Dieter,

Just to make this clear straight of the bat prior to version 1.4 of
SQL-Ledger I had no problems running SQL-Ledger in the 1.2.* variety.

I clean installed SQL ledger.

Now I cleaned out all the SQL tables and downloaded SQL-Ledger 1.4.4 from
your Web Site unpacked it and recreated the tables from the acc-PG.sql file.
I removed any traces of the previous SQL-LEDGER 1.2.* which was working.
I then move the SQL-Ledger directory with the login.pl and sql-ledger.conf
file and all subdirectories to the web document root called
/www/websites/bookmen/sqll  I also created any directories that where called
in the sql-ledger.conf file so that it could find anything it was looking
for.
I read the FAQ and the README and it said to:

SETUP A USER:
-------------
Load your web browser and enter the URL
http://localhost/cgi-bin/sql-ledger/admin.pl and add a user. If you specify
a different database then the one you just created
in the previous step, make sure the database and tables exist.
(see previous step) LOAD THE ACCOUNTING PROGRAM:
----------------------------
Load your web browser and enter the URL
http://localhost/cgi-bin/sql-ledger/login.pl


Now there is no http://localhost/cgi-bin/sql-ledger/admin.pl in that
directory there is only login.pl and am.pl

If I open the admin.pl in the "bin/mozilla" directory the is no shebang line
or "require" command for the .conf file on any of these files which leads me
to believe that these files are read into a calling .pl file probably
login.pl.

How do you add or create a user?    What .pl file in what directory needs to
be run and what needs to be entered in the Browser URL to call it?

There is something fundamental I am not aware of that must be causing these
problems?
Your assistence is needed.

SQL Ledger is being run on W2K Pro with PG 703 and perl5, apache 1.3.14.

Regards Jess

----- Original Message -----
From: "Dieter Simader" <dsi...@sq...>
To: <sql...@li...>
Sent: Tuesday, 05 June, 2001 5:22 AM
Subject: Re: NEED taxes on taxes here


> Tax on tax can be managed by adding the tax to the tax.
>
> i.e first tax @ 7% second tax @ 8%
> 8% would effectively be 8.56%
>
> If taxes are tax on tax as well as tax included you'll have to adjust the
> tax rates accordingly.
>
> Tax included applies to all taxes and not just one or the other.
>
>
> 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, 2 Jun 2001, Andre Felipe Machado wrote:
>
> > Hello, Dieter:
> > I just had send out messages to many brazilian linux lists asking for
> > accountant help and found your message below.
> >
> > Here, in Brazil, we have a real  tax hell.
> > We have TAXES ON TAXES at different points of price setup process,
> > feeding multiple taxes accounts to balance at month end.
> >
> > I am not an accountant, so I can not explain right this complex subject.
> > But in order to other people help to customize tables, sql-ledger will
> > have to allow multiple taxes on taxes, included and on top, at different
> > points of price.
> >
> > Two significant taxes here: IPI is "on top", aaaaaaannnnnd ICMS "is
> > included".
> > And they are only two of many, many other taxes, some included, other on
> > top of others!
> > Cascading taxes!!!
> > And these taxes depends on WHAT product or service is to be invoiced.
> >
> > Please, are there other brazilian people in this list?
> > Any accountant to help?
> > Many thanks.
> > Andre Felipe Machado
> >
> >
> >
> > >>>>>>>>>>>>>>>>>> Mensagem anterior <<<<<<<<<<<<<<<<<<
> >
> > No dia 28/05/01, 13:58:06, Dieter Simader <dsi...@sq...>
> > escreveu o seguinte sobre o tema About Taxes:
> >
> >
> > > Taxes are calculated differently if included in price or shown on top.
> > > i.e.  $100 item, taxable at 7%
> > >  tax included -> net price is 93.46, tax portion is 6.54
> > >  tax on top -> net price is 100.00, tax is 7.00
> >
> > > multiple taxes are always additive and not calculated tax on tax.
> > > So, the same $100 item at 7% and 8%
> > >  tax included -> net price is 86.96, tax is 13.04
> > >  tax on top -> net price is 100.00, tax is 15.00
> >
> >
> >
>
>
>
>
>

Re: Setup a user fails

[Pedro A. G. P. <pp...@ya...>]

Hi Rick

Same thing happened to me when installing new version 1.44. What I did (as
suggested by the FAQ) was to convert all the symlinks into hardlinks. After
that, the main menu or the admin menu came up with no problem.
Hope this helps.
Regards
Pedro

On Thu, 07 Jun 2001, you wrote:
> I'm trying to install SQL-Ledger 1.4.4 on a new Redhat 7.1 system.  Things 
> went fine until I got to the Setup a User step. First time I tried to 
> access admin.pl I got a page not found. Finding it existed in bin/mozilla I 
> created a link to it in the sql-ledger directory.When I try to access 
> admin.pl now I get: Error!  No such file or directory. The error_log file 
> entry shows: Died at SL/User.pm line 261.
> Can anyone help with this?
> Also, I installed phpPgAdmin and created a user: rick   If I try to login 
> as rick I get Error! rick is not a member. I tried manually editing the 
> users/members file to add it there and got the same response.
> Thanks
> -------------------------------
> Rick Seibel
> Seibel Technologies
> Tel    215-997-7998
> Fax   215-997-8745
> Web  www.seibel.net

_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

Setup a user fails

[Rick S. <ri...@se...>]

I'm trying to install SQL-Ledger 1.4.4 on a new Redhat 7.1 system.  Things 
went fine until I got to the Setup a User step. First time I tried to 
access admin.pl I got a page not found. Finding it existed in bin/mozilla I 
created a link to it in the sql-ledger directory.When I try to access 
admin.pl now I get: Error!  No such file or directory. The error_log file 
entry shows: Died at SL/User.pm line 261.
Can anyone help with this?
Also, I installed phpPgAdmin and created a user: rick   If I try to login 
as rick I get Error! rick is not a member. I tried manually editing the 
users/members file to add it there and got the same response.
Thanks
-------------------------------
Rick Seibel
Seibel Technologies
Tel    215-997-7998
Fax   215-997-8745
Web  www.seibel.net

Re: Best way of adding corporate taxes?

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

Hi Jaco.

Jaco van Staden wrote:

> Hi
>
> What is the best way of inserting corporate taxes to be paid. And taxes
> already paid.
>
> I tried a ledger entry, but that does not work.

It should.  Book the following when you calculate your tax liability
(hypothetical amounts):

debit: 5680 - Income tax expense 10,000
     credit: 2160 - Corporate taxes payable 10,000

when you pay it, book:

debit: 2160 - Corporate taxes payable 10,000
     credit: 1061 - Checking Account 1 10,000 (or whatever cash account
you use to pay them)

As with any accrual account, you should have a good feel for what's left
in the ending balance, because you'll rarely get to zero it out due to
timing differences of accruals vs. payments.

>
>
> Furthermore, I cannot determine from the online demo how it was done.

Sql-ledger has the option to enter an opening balance when you set up an
account.  The balance in Corporate Taxes Payable was entered as an opening
balance, so no detail is available in Sql-ledger.  It's also entered as a
negative amount which wouldn't be appropriate for most payables accounts.
In the real world you presumably would have support for that opening
balance from your previous system.

I hope that clarifies things.
Steve

>
>
> Regards
>
> --
> Jaco van Staden
> Cyber Seal Information Systems Development
> Tel: +27 12 998 5674, Fax: +27 12 998 0249,
> Cell: +27 82 927 5513, http://www.cyberseal.co.za

Best way of adding corporate taxes?

[Jaco v. S. <ja...@cy...>]

Hi

What is the best way of inserting corporate taxes to be paid. And taxes
already paid.

I tried a ledger entry, but that does not work. 

Furthermore, I cannot determine from the online demo how it was done.

Regards

-- 
Jaco van Staden
Cyber Seal Information Systems Development
Tel: +27 12 998 5674, Fax: +27 12 998 0249,
Cell: +27 82 927 5513, http://www.cyberseal.co.za

Re: NEED taxes on taxes here

[Andre F. M. <and...@te...>]

Hello, Dieter:
Many thanks for your answer.
As I am not an accountant, I will "try" to explain the insane complexity=
.
In Brasil, until yesterday, we suffer 57 different taxes (help!), at=20
city, state, country level.
Not all of them apply to all products or services.
The ones that apply to a certain product or service, must be applied at =

an exact order.
Lets say,=20
value 1 =3D cost with tax 1 and tax 2 included.
Value 2 =3D value1 + tax 3 on top.
Value 3 =3D value 2 with tax 3 and tax 4 included.
Value 4 =3D value 3 + tax 5 on top
value 5 =3D value 4 + tax 6 on top
etc, etc, etc....
Final price =3D value x + tax y on top (or included).

They apply tax on tax, included and on top at a fixed sequence for each =

kind of product or service.
Each tax must have an account, with closed balance at fiscal month end.
When a component is purchased, all applied taxes go to a tax account.
When the product is finished product is selled, the suitable applied=20
taxes go to the taxes account. Each tax have a balance sheet.
At fiscal month end, we all have to pay the tax balance dues....

Is there an easier way to configure this tax nightmare?
This tax adjust seems to be very error prone...
Any help from a brazilian accountant here?

Many thanks
Andr=E9 Felipe




>>>>>>>>>>>>>>>>>> Mensagem anterior <<<<<<<<<<<<<<<<<<

No dia 04/06/01, 16:22:42, Dieter Simader <dsi...@sq...>=20
escreveu o seguinte sobre o tema Re: NEED taxes on taxes here :


> Tax on tax can be managed by adding the tax to the tax.

> i.e first tax @ 7% second tax @ 8%
> 8% would effectively be 8.56%

> If taxes are tax on tax as well as tax included you'll have to adjust =
the
> tax rates accordingly.

> Tax included applies to all taxes and not just one or the other.


> Dieter Simader    http://www.sql-ledger.org   (780) 472-8161
> DWS Systems Inc.     Accounting Software       Fax: 478-5281

Re: NEED taxes on taxes here

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

Tax on tax can be managed by adding the tax to the tax.

i.e first tax @ 7% second tax @ 8%
8% would effectively be 8.56%

If taxes are tax on tax as well as tax included you'll have to adjust the
tax rates accordingly.

Tax included applies to all taxes and not just one or the other.


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, 2 Jun 2001, Andre Felipe Machado wrote:

> Hello, Dieter:
> I just had send out messages to many brazilian linux lists asking for 
> accountant help and found your message below.
> 
> Here, in Brazil, we have a real  tax hell.
> We have TAXES ON TAXES at different points of price setup process, 
> feeding multiple taxes accounts to balance at month end.
> 
> I am not an accountant, so I can not explain right this complex subject. 
> But in order to other people help to customize tables, sql-ledger will 
> have to allow multiple taxes on taxes, included and on top, at different 
> points of price.
> 
> Two significant taxes here: IPI is "on top", aaaaaaannnnnd ICMS "is 
> included".
> And they are only two of many, many other taxes, some included, other on 
> top of others!
> Cascading taxes!!! 
> And these taxes depends on WHAT product or service is to be invoiced.
> 
> Please, are there other brazilian people in this list?
> Any accountant to help?
> Many thanks.
> Andre Felipe Machado
> 
> 
> 
> >>>>>>>>>>>>>>>>>> Mensagem anterior <<<<<<<<<<<<<<<<<<
> 
> No dia 28/05/01, 13:58:06, Dieter Simader <dsi...@sq...> 
> escreveu o seguinte sobre o tema About Taxes:
> 
> 
> > Taxes are calculated differently if included in price or shown on top.
> > i.e.  $100 item, taxable at 7%
> >  tax included -> net price is 93.46, tax portion is 6.54
> >  tax on top -> net price is 100.00, tax is 7.00
> 
> > multiple taxes are always additive and not calculated tax on tax.
> > So, the same $100 item at 7% and 8%
> >  tax included -> net price is 86.96, tax is 13.04
> >  tax on top -> net price is 100.00, tax is 15.00
> 
> 
> 

Upgrading 1.4.2 to 1.4.4 ...

[Bryan J. S. <b.j...@ie...>]

Upgrading 1.4.2 to 1.4.4 ...

Hmmm, having trouble upgrading here.  What's the best course of
action?  What directories should I be dumping in?

-- TheBS

-- 
Bryan J. Smith, President        mailto:b.j...@ie...
(407)366-7013 pager:(888)694-5793 chat:thebs413@AOL/MS/Yho
==========================================================
SmithConcepts, Inc.           http://www.SmithConcepts.com
        Consulting Engineers and IT Professionals

NEED taxes on taxes here

[Andre F. M. <and...@te...>]

Hello, Dieter:
I just had send out messages to many brazilian linux lists asking for=20
accountant help and found your message below.

Here, in Brazil, we have a real  tax hell.
We have TAXES ON TAXES at different points of price setup process,=20
feeding multiple taxes accounts to balance at month end.

I am not an accountant, so I can not explain right this complex subject.=
=20
But in order to other people help to customize tables, sql-ledger will=20
have to allow multiple taxes on taxes, included and on top, at different=
=20
points of price.

Two significant taxes here: IPI is "on top", aaaaaaannnnnd ICMS "is=20
included".
And they are only two of many, many other taxes, some included, other on=
=20
top of others!
Cascading taxes!!!=20
And these taxes depends on WHAT product or service is to be invoiced.

Please, are there other brazilian people in this list?
Any accountant to help?
Many thanks.
Andre Felipe Machado



>>>>>>>>>>>>>>>>>> Mensagem anterior <<<<<<<<<<<<<<<<<<

No dia 28/05/01, 13:58:06, Dieter Simader <dsi...@sq...>=20
escreveu o seguinte sobre o tema About Taxes:


> Taxes are calculated differently if included in price or shown on top.=

> i.e.  $100 item, taxable at 7%
>  tax included -> net price is 93.46, tax portion is 6.54
>  tax on top -> net price is 100.00, tax is 7.00

> multiple taxes are always additive and not calculated tax on tax.
> So, the same $100 item at 7% and 8%
>  tax included -> net price is 86.96, tax is 13.04
>  tax on top -> net price is 100.00, tax is 15.00

Bug 1.4.4 - Retained Earnings position in Balance Sheet

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

In reference to v1.4.4, I think there is a small bug in rp.pl, where
the Retained Earnings should be the last equity account, so should be
pushed after the call to ->balance_sheet, not before.

In this order:

  $form->{period} = $form->current_date(\%myconfig);

  RP->balance_sheet(\%myconfig, \%$form);

  # define Retained Earnings account
  push(@{$form->{equity_account}}, $locale->text('Retained Earnings'));



Not this:

  # define Retained Earnings account
  push(@{$form->{equity_account}}, $locale->text('Retained Earnings'));
  
  $form->{period} = $form->current_date(\%myconfig);

  RP->balance_sheet(\%myconfig, \%$form);



-- 
B.      http://makelinux.org/    "Always real."    http://realthought.net/
__________________________________________________________________________
He who despises himself nevertheless esteems himself as a self-despiser.
		-- Friedrich Nietzsche

Re: Driver name in Create user?

[Martin L. <ma...@li...>]

----- Original Message -----
From: "Jaco van Staden" <ja...@cy...>
To: <sql...@li...>
Sent: Thursday, May 31, 2001 9:14 PM
Subject: Driver name in Create user?


> Hi
>
> What is the driver name, database username, password when I create user?
> Is it necessary to fill this in?

Driver name is Pg (reference to DBD::Pg). set username to 'postgres' and
leave password blank, if using default install. that should do it in
single-user machines and trusted environments. however, if you want to
restrict db access with username and password, here's one way to do it:

1. Connect to sql-ledger database as user postgres:

   psql database -U postgres

2. Assign user postgres a password:

   ALTER USER postgres WITH PASSWORD 'admin_password';

3. Create new user:

   CREATE USER user WITH PASSWORD 'password';

4. Assign appropriate permissions to all sql-ledger tables

   GRANT SELECT,INSERT,DELETE,UPDATE ON
    acc_trans, ap, ar, chart, customer,
    customertax, defaults, gl, invoice, makemodel,
    parts, partstax, tax, vendor, vendortax
   TO user;

5. Enable postgresql password check:
    set access levels in pg_hba.conf from trust to crypt

6. set new db username and password in sql-ledger admin.

--
martin

Driver name in Create user?

[Jaco v. S. <ja...@cy...>]

Hi

What is the driver name, database username, password when I create user?
Is it necessary to fill this in?

-- 
Jaco van Staden
Cyber Seal Information Systems Development
Tel: +27 12 998 5674, Fax: +27 12 998 0249,
Cell: +27 82 927 5513, http://www.cyberseal.co.za

Re: Compilation errors

[Rod R. <ro...@su...>]

See my post to this list from 5/22: 
http://www.geocrawler.com/lists/3/SourceForge/7966/0/5805077/

-- Rod

On Wednesday 30 May 2001 23:02, nyk wrote:
>     Thanks for the much help rendered thus far. I have figured out
> the problems. The problem actually liaised within the Postgresql. It
> look like Postgresql 7.1 give problems with RedHat 6.2. After
> reinstall Postgresql 7.0.2 on my RedHat 6.2, SQL-Ledger is running
> without any problems.
>
>
> ----- Original Message -----
> From: "Ian (the webguy)" <ia...@in...>
> To: <sql...@li...>
> Sent: Wednesday, May 30, 2001 7:34 PM
> Subject: Re: Compilation errors
>
> > Is PostGreSQL running?
> >
> >
> > (in case you don't know, this should be what you need to type in)
> >
> > % su - (postgresql user)
> > % postmaster -i
> >
> >
> > Ian
> >
> > nyk writes:
> > >     I downloaded your SQL-Ledger 1.4.3 and trying to install
> > > onto my
>
> RedHat linux box running RedHat 6.2. There were no problems in
> getting the users created but when I wanted to login into the
> system, following message
>
> appears in my server error log:
> > > Unknown error
> > > Compilation failed in require at
>
> /home/paging2.easycall.com.my/htdocs/sql-ledger/login.pl line 61.
>
> > > [Mon May 28 22:22:59 2001] [error] [client 172.1.1.20] Premature
> > > end of
>
> script headers:
> /home/paging2.easycall.com.my/htdocs/sql-ledger/login.pl
>
> > >     Is there anything else that I have missed out in configuring
> > > the
>
> system? To my knowledge, I have correctly installed the DBD::Pg
> drivers as well as the DBI
>
> > >     I appreciate if any help can be rendered.
> > >
> > >
> > > Regards
> > >
> > > Ng Yit Khuang
> > > ny...@ru...
> >
> >  ----
> > Ian W., MCSE, MCSE+I, MCSD, CNE, CNA, LNA, EMT-B.
> > Webmaster, Internationalsportsagency.com
> > A division of Remani International
> > Web Division
> > P.O. Box 304
> > Ada, Ohio 45810
> >
> > (419) 634-2286
> > (419) 634-2289 FAX
> > (419) 204-0874 CELL
> > (888) 218-3996 PAGER
> >
> > "Network Administration:  It's a dirty job, but someone made me do
> > it." "Knowledge unburdened by Ignorance is shallow; Ignorance
> > ungiven to Knowledge is the only kind for which to apologize."

Re: Compilation errors

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

Yes there is a users directory and there are files in there something like:

user.conf
user:chart

Regards Jess

----- Original Message -----
From: "Dieter Simader" <dsi...@sq...>
To: <sql...@li...>
Sent: Thursday, 31 May, 2001 4:01 AM
Subject: Re: Compilation errors


> check if there are any files in the users directory.
>
> You probably forgot to make the users directory writable.
>
>
> 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 Wed, 30 May 2001, nyk wrote:
>
> >     I downloaded your SQL-Ledger 1.4.3 and trying to install onto my
RedHat linux box running RedHat 6.2. There were no problems in getting the
users created but when I wanted to login into the system, following message
appears in my server error log:
> >
> > Unknown error
> > Compilation failed in require at
/home/paging2.easycall.com.my/htdocs/sql-ledger/login.pl line 61.
> > [Mon May 28 22:22:59 2001] [error] [client 172.1.1.20] Premature end of
script headers: /home/paging2.easycall.com.my/htdocs/sql-ledger/login.pl
> >
> >     Is there anything else that I have missed out in configuring the
system? To my knowledge, I have correctly installed the DBD::Pg drivers as
well as the DBI
> >
> >     I appreciate if any help can be rendered.
> >
> >
> > Regards
> >
> > Ng Yit Khuang
> > ny...@ru...
> >
>
>
>

Re: Compilation errors

[nyk <ny...@ru...>]

    Thanks for the much help rendered thus far. I have figured out the
problems. The problem actually liaised within the Postgresql. It look like
Postgresql 7.1 give problems with RedHat 6.2. After reinstall Postgresql
7.0.2 on my RedHat 6.2, SQL-Ledger is running without any problems.


----- Original Message -----
From: "Ian (the webguy)" <ia...@in...>
To: <sql...@li...>
Sent: Wednesday, May 30, 2001 7:34 PM
Subject: Re: Compilation errors


> Is PostGreSQL running?
>
>
> (in case you don't know, this should be what you need to type in)
>
> % su - (postgresql user)
> % postmaster -i
>
>
> Ian
>
>
>
> nyk writes:
>
> >     I downloaded your SQL-Ledger 1.4.3 and trying to install onto my
RedHat linux box running RedHat 6.2. There were no problems in getting the
users created but when I wanted to login into the system, following message
appears in my server error log:
> >
> > Unknown error
> > Compilation failed in require at
/home/paging2.easycall.com.my/htdocs/sql-ledger/login.pl line 61.
> > [Mon May 28 22:22:59 2001] [error] [client 172.1.1.20] Premature end of
script headers: /home/paging2.easycall.com.my/htdocs/sql-ledger/login.pl
> >
> >     Is there anything else that I have missed out in configuring the
system? To my knowledge, I have correctly installed the DBD::Pg drivers as
well as the DBI
> >
> >     I appreciate if any help can be rendered.
> >
> >
> > Regards
> >
> > Ng Yit Khuang
> > ny...@ru...
>
>
>
>  ----
> Ian W., MCSE, MCSE+I, MCSD, CNE, CNA, LNA, EMT-B.
> Webmaster, Internationalsportsagency.com
> A division of Remani International
> Web Division
> P.O. Box 304
> Ada, Ohio 45810
>
> (419) 634-2286
> (419) 634-2289 FAX
> (419) 204-0874 CELL
> (888) 218-3996 PAGER
>
> "Network Administration:  It's a dirty job, but someone made me do it."
> "Knowledge unburdened by Ignorance is shallow; Ignorance ungiven to
> Knowledge is the only kind for which to apologize."
>
>
>

Re: [SQL-Ledger-users] Spanish version

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

All this talk on the variations of language inclines me to reiterate
my personal opinion on application langauge support. I believe the old
standard model, used by SQL-Ledger, is quickly reaching then end of its
life-span. The new approach, to replace the old model, will stand completely
apart from the actual development of an application. Rather, translation
will occur at runtime, preformed by a seperate "software appliance".
Much like the Babel Fish on AltaVista does to web pages currently. If
fact, the technology behind the Babel Fish will probably be the first
of these type of "software appliances". They arn't rigid either, but
can be tweked for personal, or regional, tastes.


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



---- "Maria Gabriela Fong" <mg...@ma...> wrote:
> I agree with Antonio and German, one version in spanish is enough for
> me,
> even though I can see Dieter's point when he thought of country versions
> for
> the language modules.
> 
> For example, I am no accountant, but a consultant, so technology and
> changing terms come easily to me...
> Accountants tend to be very picky about their terminology and how you
> call
> this and that, and even though I know that they do get used over time
> as
> anyone else with new programs and new terms, it's nice to know I can
> get a
> template made exactly to my country and work with it...
> 
> For example, Tax names changes thru the countries, I think the standard
> name
> is IVA, but one country is called IGV, in mine is ITBM, and so on...
> Other terms that do change are related to "Spanglish".  In my country,
> the
> term "postear" is very commons since we had a strong influence with
> Americans all over the place, so we have hacked the english/spanish
> language
> more than most countries.
> And about Spaniards, they do tend to call things in a very unique way
> that
> sometimes even they don't like.
> 
> So, even though one spanish version seems like enough, maybe our users
> will
> not think the same.
> So, how about we make sure the standard "es" template is the most correct
> of
> all as Antonio suggests, and we keep the country templates as a
> customization template for our terms. ;)
> 
> Regards,
> Gaby
> 
> ----------------------------------------------------------------------------
> --
>     Mantenimiento - Computadoras - Redes - Consultoria - Linux - Seguridad
> ----------------------------------------------------------------------------
> --
> Tecno Parque Internacional, Edificio 218, Planta Baja, Clayton
> Maria Gabriela Fong - Aptitudes, S.A.
> mg...@ap...
> 
> Panama:   Apdo 87-2472, Zona 7, Panama
>           Tel: +507-317-0145 / 46, Fax: +507-317-0145  [507 country
> code]
> 
> USA Mail: 1601 N.W. 97th Ave., PTY-823, Unit C-102, Miami, FL 33172,
> USA
> 
> ----- Original Message -----
> From: <ag...@ib...>
> To: <sql...@li...>
> Sent: Wednesday, May 16, 2001 5:13 PM
> Subject: [SQL-Ledger-users] Spanish version
> 
> 
> > Hi everybody!
> >
> > Please excuse me for this mail written in Spanish, but we want to
> find a
> way to know how many spanish version of SQL-Ledger will exist.
> >
> > Estimados usuario de SQL-Ledger en Español:
> >
> > Recientemente se ha abierto una discusion acerca de la localizacion
> de
> SQL-Ledger (SQLL) para cada pais de habla hispana.
> >
> > Esperando llegar a un acuerdo entre los hispano parlantes acerca
> de
> cuantas versiones de SQLL existiran, escribo este mensaje.
> >
> > Actualmente existen dos opiniones:
> >
> > 1- Mantener una version unica de SQL-Ledger en español.
> > 2- Crear una version especial para cada pais. (Actualmente esta es
> la
> tendencia que lleva SQL-Ledger).
> >
> > Yo estoy de acuerdo con la primera opcion porque:
> >
> > 1-Aunque entiendo muy bien lo que son los regionalismos y particularidades
> de cada pais. Creo que es muy bueno que podamos comunicarnos todos
> en el
> mismo idioma.
> >
> > 2-No soy un experto en contabilidad, pero creo que entre los contadores
> de
> todos los paises hispanos utilizan los mismo terminos. (Apelo a los
> terminos
> correctos en español, no a los anglicismos empleados en algunos paises).
> >
> > 3-Por otro creo que la realidad lationamericana es un poco diferente
> de
> España, según lo planteado por el Eugenio en un correo enviado. Pero
> a nivel
> latinoamericano se usan los mismos terminos. Debido a esto es posible
> que
> pueda existir una version para España (Aunque tengo mis dudas).
> >
> > 4-La ventaja de mantener un solo lenguaje ahorra esfuerzos. En lugar
> de
> utilizar esfuerzos en regionalizar para cada pais, podemos unir esfuerzos
> y
> mejorar la calidad de la documentacion en español.
> >
> > Bueno, estos son algunos de los motivos que tengo ahora en mente.
> Espero
> sus comentarios y les agradezco de antemano su colaboracion para hacer
> mejor
> este sistema del que nos beneficiamos todos.
> >
> > Saludos,
> >
> > Ing. Antonio Gallardo
> > AG Software
> > Managua, NICARAGUA.
> >
> >
> >
> 
> 
> 

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

Re: [SQL-Ledger-users] Spanish version

[Antonio G. <ag...@ib...>]

Thanks Grabriela for your comments!

Now the vote are:

One Spanish Version:  3 votes.
Spanish Version for each country: 1 vote.

I also think why Microsoft dont have a localizated version for each Spani=
sh
spoken country? This is because:

1- Save Financial Costs.
2- All of us understand the spanish version of any application, even if t=
he
application is high oriented like CAD, CASE, etc.

Regards,

Ing. Antonio Gallardo.
AG Software, S. A.
Managua, NICARAGUA



----- Original Message -----
From: "Maria Gabriela Fong" <mg...@ma...>
To: <sql...@li...>
Sent: Wednesday, May 30, 2001 10:09 AM
Subject: Re: [SQL-Ledger-users] Spanish version


> I agree with Antonio and German, one version in spanish is enough for m=
e,
> even though I can see Dieter's point when he thought of country version=
s
for
> the language modules.
>
> For example, I am no accountant, but a consultant, so technology and
> changing terms come easily to me...
> Accountants tend to be very picky about their terminology and how you c=
all
> this and that, and even though I know that they do get used over time a=
s
> anyone else with new programs and new terms, it's nice to know I can ge=
t a
> template made exactly to my country and work with it...
>
> For example, Tax names changes thru the countries, I think the standard
name
> is IVA, but one country is called IGV, in mine is ITBM, and so on...
> Other terms that do change are related to "Spanglish".  In my country, =
the
> term "postear" is very commons since we had a strong influence with
> Americans all over the place, so we have hacked the english/spanish
language
> more than most countries.
> And about Spaniards, they do tend to call things in a very unique way t=
hat
> sometimes even they don't like.
>
> So, even though one spanish version seems like enough, maybe our users
will
> not think the same.
> So, how about we make sure the standard "es" template is the most corre=
ct
of
> all as Antonio suggests, and we keep the country templates as a
> customization template for our terms. ;)
>
> Regards,
> Gaby
>
> -----------------------------------------------------------------------=
---
--
> --
>     Mantenimiento - Computadoras - Redes - Consultoria - Linux - Seguri=
dad
> -----------------------------------------------------------------------=
---
--
> --
> Tecno Parque Internacional, Edificio 218, Planta Baja, Clayton
> Maria Gabriela Fong - Aptitudes, S.A.
> mg...@ap...
>
> Panama:   Apdo 87-2472, Zona 7, Panama
>           Tel: +507-317-0145 / 46, Fax: +507-317-0145  [507 country cod=
e]
>
> USA Mail: 1601 N.W. 97th Ave., PTY-823, Unit C-102, Miami, FL 33172, US=
A
>
> ----- Original Message -----
> From: <ag...@ib...>
> To: <sql...@li...>
> Sent: Wednesday, May 16, 2001 5:13 PM
> Subject: [SQL-Ledger-users] Spanish version
>
>
> > Hi everybody!
> >
> > Please excuse me for this mail written in Spanish, but we want to fin=
d a
> way to know how many spanish version of SQL-Ledger will exist.
> >
> > Estimados usuario de SQL-Ledger en Espa=F1ol:
> >
> > Recientemente se ha abierto una discusion acerca de la localizacion d=
e
> SQL-Ledger (SQLL) para cada pais de habla hispana.
> >
> > Esperando llegar a un acuerdo entre los hispano parlantes acerca de
> cuantas versiones de SQLL existiran, escribo este mensaje.
> >
> > Actualmente existen dos opiniones:
> >
> > 1- Mantener una version unica de SQL-Ledger en espa=F1ol.
> > 2- Crear una version especial para cada pais. (Actualmente esta es la
> tendencia que lleva SQL-Ledger).
> >
> > Yo estoy de acuerdo con la primera opcion porque:
> >
> > 1-Aunque entiendo muy bien lo que son los regionalismos y
particularidades
> de cada pais. Creo que es muy bueno que podamos comunicarnos todos en e=
l
> mismo idioma.
> >
> > 2-No soy un experto en contabilidad, pero creo que entre los contador=
es
de
> todos los paises hispanos utilizan los mismo terminos. (Apelo a los
terminos
> correctos en espa=F1ol, no a los anglicismos empleados en algunos paise=
s).
> >
> > 3-Por otro creo que la realidad lationamericana es un poco diferente =
de
> Espa=F1a, seg=FAn lo planteado por el Eugenio en un correo enviado. Per=
o a
nivel
> latinoamericano se usan los mismos terminos. Debido a esto es posible q=
ue
> pueda existir una version para Espa=F1a (Aunque tengo mis dudas).
> >
> > 4-La ventaja de mantener un solo lenguaje ahorra esfuerzos. En lugar =
de
> utilizar esfuerzos en regionalizar para cada pais, podemos unir esfuerz=
os
y
> mejorar la calidad de la documentacion en espa=F1ol.
> >
> > Bueno, estos son algunos de los motivos que tengo ahora en mente. Esp=
ero
> sus comentarios y les agradezco de antemano su colaboracion para hacer
mejor
> este sistema del que nos beneficiamos todos.
> >
> > Saludos,
> >
> > Ing. Antonio Gallardo
> > AG Software
> > Managua, NICARAGUA.
> >
> >
> >
>
>
>

Re: Compilation errors

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

Is PostGreSQL running?
 

(in case you don't know, this should be what you need to type in) 

% su - (postgresql user)
% postmaster -i 


Ian 

 

nyk writes: 

>     I downloaded your SQL-Ledger 1.4.3 and trying to install onto my RedHat linux box running RedHat 6.2. There were no problems in getting the users created but when I wanted to login into the system, following message appears in my server error log: 
> 
> Unknown error
> Compilation failed in require at /home/paging2.easycall.com.my/htdocs/sql-ledger/login.pl line 61.
> [Mon May 28 22:22:59 2001] [error] [client 172.1.1.20] Premature end of script headers: /home/paging2.easycall.com.my/htdocs/sql-ledger/login.pl 
> 
>     Is there anything else that I have missed out in configuring the system? To my knowledge, I have correctly installed the DBD::Pg drivers as well as the DBI 
> 
>     I appreciate if any help can be rendered. 
> 
> 
> Regards 
> 
> Ng Yit Khuang
> ny...@ru...
 


 ----
Ian W., MCSE, MCSE+I, MCSD, CNE, CNA, LNA, EMT-B.
Webmaster, Internationalsportsagency.com
A division of Remani International
Web Division
P.O. Box 304
Ada, Ohio 45810 

(419) 634-2286
(419) 634-2289 FAX
(419) 204-0874 CELL
(888) 218-3996 PAGER 

"Network Administration:  It's a dirty job, but someone made me do it."
"Knowledge unburdened by Ignorance is shallow; Ignorance ungiven to 
Knowledge is the only kind for which to apologize." 

Re: Compilation errors

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

check if there are any files in the users directory.

You probably forgot to make the users directory writable.


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 Wed, 30 May 2001, nyk wrote:

>     I downloaded your SQL-Ledger 1.4.3 and trying to install onto my RedHat linux box running RedHat 6.2. There were no problems in getting the users created but when I wanted to login into the system, following message appears in my server error log:
> 
> Unknown error
> Compilation failed in require at /home/paging2.easycall.com.my/htdocs/sql-ledger/login.pl line 61.
> [Mon May 28 22:22:59 2001] [error] [client 172.1.1.20] Premature end of script headers: /home/paging2.easycall.com.my/htdocs/sql-ledger/login.pl
> 
>     Is there anything else that I have missed out in configuring the system? To my knowledge, I have correctly installed the DBD::Pg drivers as well as the DBI
> 
>     I appreciate if any help can be rendered.
> 
> 
> Regards
> 
> Ng Yit Khuang
> ny...@ru...
> 

Re: Help Please!

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

Version 1.4.4 is tarred up from a working system. All you need to do is
ungzip/untar, move the sql-ledger directory to your cgi-bin directory,
read the FAQ and the files in the doc directory and follow the
instruction.


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 Wed, 30 May 2001, Jess wrote:

> Hi People,
> Could some kind sole send me the following in a tar or zip file from a
> working system, Please?
> 
> The whole directory under:
>     sql-ledger/bin
> 
> And these individual files.
>     sql-ledger/admin.pl
>     sql-ledger/login.pl
>     sql-ledger/sql-ledger.conf
> 
> 
> Where is setup/pl supposed to be, on what I have it is in the
> "sql-ledger/bin" is this right?
> 
> Thankyou to those who can help.
> 
> I can't believe how much trouble I am having getting this to run.
> I had no problem with the 1.2.* versions.
> 
> Regards Jess
> 
> 
>