sql-ledger-users — SQL-Ledger users

Invoice Dates--in 1.6.3?

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

Dieter and folks,

We updated to 1.6.3, after finding that our invoice dates (%invdate%) and
due dates all printed as "0, 2000" (after updating to 1.6.2).

Unfortunately, we're still seeing this with the 1.6.3 downloaded some
minutes ago.

Is this the same date bug labelled "fixed dates for GL reports?"

Matt

Matt

Matt Benjamin

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

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

Re: out of balance error

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

This error is caused by how numbers are processed by your computer.
Somewhere along the line your machine thinks that the result of adding
11.86 and 1.19 is 13.050000000001 and not 13.05 IMHO this should not
happen but apparently it does.

The workaround. In GL.pm add the following before line 77

$debit = sprintf("%.2f", $debit);
$credit = sprintf("%.2f", $credit);


Dieter Simader    http://www.sql-ledger.org   (780) 472-8161
DWS Systems Inc.     Accounting Software       Fax: 478-5281
=========== On a clear disk you can seek forever ===========

On Mon, 10 Sep 2001, adrian wrote:

> I attampting to post some GL transaction I sometimes get the following
> error:
> 
> Error!
> Debit and credit out of balance!
> 
> I have attached the screen dumps.
> 
> More detail:
> A GL transaction for petty cash, so Petty Cash credit $13.05
> 	Sundry exp $11.86
> 	GST $1.19
> Update form
> Post Transaction   .....
> 
> Error
> 
> The crazy thing is that sometimes it works.  I had one transaction that
> I tried several times, several days later I tried again and  it worked.
> I just tried re-logging in, but no success
> 
> Any thoughts as to why?
> 
> Adrian
> 

out of balance error

[adrian <ad...@sn...>]

I attampting to post some GL transaction I sometimes get the following
error:

Error!
Debit and credit out of balance!

I have attached the screen dumps.

More detail:
A GL transaction for petty cash, so Petty Cash credit $13.05
	Sundry exp $11.86
	GST $1.19
Update form
Post Transaction   .....

Error

The crazy thing is that sometimes it works.  I had one transaction that
I tried several times, several days later I tried again and  it worked.
I just tried re-logging in, but no success

Any thoughts as to why?

Adrian
-- 
Adrian Blake
Snowy Technology Pty Ltd
26b Bombala St
Cooma, NSW 2630
Ph 2-64-524338 mobile 0407 232 978

Re: can't locate /test.conf at SL/user.pm line 115

[Andy F. <and...@ho...>]

I think what Dieter is trying to say is that the files don't have the 
necessary permissions to allow the web server to write to them.

If you change the permissions of the users directory you should be fine.

The command would be something like this:

chown -R nobody.nogroup users

from the directory above the users directory.

Andy


----Original Message Follows----
From: James Cluff <jam...@ya...>
Reply-To: sql...@li...
To: sql...@li...
Subject: Re: can't locate /test.conf at SL/user.pm line 115
Date: Sat, 8 Sep 2001 12:52:42 -0700 (PDT)

Dieter,

I am not sure exactly what you mean.  I read through
the httpd.conf and a linux manual.  I am relatively
new to linux.  I don't want to trouble you, but could
you be more explicit?

Thank you
James

--- Dieter Simader <dsi...@sq...> wrote:
 > the webserver could not write to the users
 > directory.
 >
 > set the directory owner to the one your server runs
 > as (nobody.nogroup)
 >
 >
 > 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 Fri, 7 Sep 2001, James Cluff wrote:
 >
 > > I just installed the software today on Linux 7.1
 > It
 > > all went very well, in fact I was suprised how
 > well it
 > > went.
 > >
 > > However...
 > >
 > > when I try to login from sql-ledger/login.pl
 > > I get the following error
 > > =========================================
 > >
 > > 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/1.3.19 Server at localhost.localdomain Port
 > 80
 > >
 > > ========================================
 > >
 > >
 > > I looked in the server error log and it says:
 > >
 > > computation failed in require at
 > > /var/www/sql-ledger/login.pl line 76.
 > > can't locate /test.conf at SL/user.pm line 115
 > >
 > > compilation failed at /var/www/sql-ledger/login.pl
 > > line 76.
 > > premature end of script headers:
 > > /var/www/sql-ledger/login.pl
 > >
 > > I think I configured something wrong, but can't
 > find
 > > the problem.  Anyone have any ideas?  or had any
 > > problems with redhat 7.1?  The only difference I
 > am
 > > aware of regarding this issue is the location of
 > /www/
 > > from previous versions of Red Hat.
 > >
 > > Thanks
 > > James Cluff
 > > jam...@ya...
 > >
 >
 >


__________________________________________________
Do You Yahoo!?
Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger
http://im.yahoo.com



_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

Re: can't locate /test.conf at SL/user.pm line 115

[James C. <jam...@ya...>]

Dieter,

I am not sure exactly what you mean.  I read through
the httpd.conf and a linux manual.  I am relatively
new to linux.  I don't want to trouble you, but could
you be more explicit?

Thank you
James

--- Dieter Simader <dsi...@sq...> wrote:
> the webserver could not write to the users
> directory.
> 
> set the directory owner to the one your server runs
> as (nobody.nogroup)
> 
> 
> 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 Fri, 7 Sep 2001, James Cluff wrote:
> 
> > I just installed the software today on Linux 7.1 
> It
> > all went very well, in fact I was suprised how
> well it
> > went.
> > 
> > However...
> > 
> > when I try to login from sql-ledger/login.pl
> > I get the following error
> > =========================================
> > 
> > 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/1.3.19 Server at localhost.localdomain Port
> 80
> > 
> > ========================================
> > 
> > 
> > I looked in the server error log and it says:
> > 
> > computation failed in require at
> > /var/www/sql-ledger/login.pl line 76.
> > can't locate /test.conf at SL/user.pm line 115
> > 
> > compilation failed at /var/www/sql-ledger/login.pl
> > line 76.
> > premature end of script headers:
> > /var/www/sql-ledger/login.pl
> > 
> > I think I configured something wrong, but can't
> find
> > the problem.  Anyone have any ideas?  or had any
> > problems with redhat 7.1?  The only difference I
> am
> > aware of regarding this issue is the location of
> /www/
> > from previous versions of Red Hat.
> > 
> > Thanks
> > James Cluff
> > jam...@ya...
> > 
> 
> 


__________________________________________________
Do You Yahoo!?
Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger
http://im.yahoo.com

Re: can't locate /test.conf at SL/user.pm line 115

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

the webserver could not write to the users directory.

set the directory owner to the one your server runs as (nobody.nogroup)


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 Fri, 7 Sep 2001, James Cluff wrote:

> I just installed the software today on Linux 7.1  It
> all went very well, in fact I was suprised how well it
> went.
> 
> However...
> 
> when I try to login from sql-ledger/login.pl
> I get the following error
> =========================================
> 
> 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/1.3.19 Server at localhost.localdomain Port 80
> 
> ========================================
> 
> 
> I looked in the server error log and it says:
> 
> computation failed in require at
> /var/www/sql-ledger/login.pl line 76.
> can't locate /test.conf at SL/user.pm line 115
> 
> compilation failed at /var/www/sql-ledger/login.pl
> line 76.
> premature end of script headers:
> /var/www/sql-ledger/login.pl
> 
> I think I configured something wrong, but can't find
> the problem.  Anyone have any ideas?  or had any
> problems with redhat 7.1?  The only difference I am
> aware of regarding this issue is the location of /www/
> from previous versions of Red Hat.
> 
> Thanks
> James Cluff
> jam...@ya...
> 

Re: database offline error message

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

Leave the host and port field blank.


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, 8 Sep 2001, Pedro Torres wrote:

> i check and the database in up, the port is right,
> 
> someone can help me. 
> 
> and when i try to login, this message appears "error!
> database is offline, try later".
> 
> 
> 
> __________________________________________________
> Do You Yahoo!?
> Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger
> http://im.yahoo.com
> 
> 

database offline error message

[Pedro T. <pet...@ya...>]

i check and the database in up, the port is right,

someone can help me. 

and when i try to login, this message appears "error!
database is offline, try later".



__________________________________________________
Do You Yahoo!?
Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger
http://im.yahoo.com

Re: SQL error, process receipts 1.6.2

[Roderick A. A. <raa...@ti...>]

On Fri, 7 Sep 2001, James Cluff wrote:

> computation failed in require at
> /var/www/sql-ledger/login.pl line 76.
> can't locate /test.conf at SL/user.pm line 115

Did you use the admin.pl script to create the 'test' user and/or
database?

   I've got a similar error except it was "can't locate /.conf ...".  
I'm thinking there may be some form artifacts laying around between
calls to the script that cause the /.conf error so they may also cause
some other non- user/database names to appear.


Cheers,
Rod
-- 
                      A small clue and no money
                      will get you further than
                      lots of money and no clue.

Re: SQL error, process receipts 1.6.2

[James C. <jam...@ya...>]

I just installed the software today on Linux 7.1  It
all went very well, in fact I was suprised how well it
went.

However...

when I try to login from sql-ledger/login.pl
I get the following error
=========================================

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/1.3.19 Server at localhost.localdomain Port 80

========================================


I looked in the server error log and it says:

computation failed in require at
/var/www/sql-ledger/login.pl line 76.
can't locate /test.conf at SL/user.pm line 115

compilation failed at /var/www/sql-ledger/login.pl
line 76.
premature end of script headers:
/var/www/sql-ledger/login.pl

I think I configured something wrong, but can't find
the problem.  Anyone have any ideas?  or had any
problems with redhat 7.1?  The only difference I am
aware of regarding this issue is the location of /www/
from previous versions of Red Hat.

Thanks
James Cluff
jam...@ya...

--- Matt Benjamin <ma...@li...> wrote:
> 
> Since upgrading from 1.4.7 to 1.6.2, we can no
> longer process receipts.
> The proximate cause seems to be a delete on
> acc_trans with an empty
> account number.
> 
> Any info on this?
> 
> Matt
> 
> 
> Matt Benjamin
> 
> The Linux Box
> 206 South Fifth Ave. Suite 150
> Ann Arbor, MI  48104
> 
> tel. 734-761-4689
> fax. 734-769-8938
> pgr. 734-431-0118
> 
> 
> 


__________________________________________________
Do You Yahoo!?
Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger
http://im.yahoo.com

SQL error, process receipts 1.6.2

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

Since upgrading from 1.4.7 to 1.6.2, we can no longer process receipts.
The proximate cause seems to be a delete on acc_trans with an empty
account number.

Any info on this?

Matt


Matt Benjamin

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

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

Arck! Line tems not showing up in invoice.

[Roderick A. A. <raa...@ti...>]

Seems like for ever but a few weeks ago I ran into a problem while
upgrading my system.  RHL 6.1+ to RHL7.1 and PostgreSQL 7.0.3 to 7.1.3
and last but not least SQL-Ledger 1.4 to 1.6.2.  Lots of interesting
complications that appear to be mostly worked out except for one - so
far.
   I get no items showing up in my invoices (old ones).  The correct
invoice number is in the 'ar' table but I don't find the number in the
'invoice' table.  Well maybe I do but it appears to have been munged
about.

What is the relation of Invoice number from the 'ar' table to the
'invoice' table?


TIA,
Rod
-- 
                      A small clue and no money
                      will get you further than
                      lots of money and no clue.

Invoicing for Time

[Brian J. <bjo...@je...>]

As mentioned with some of you before, we're creating module(s) to allow for
the tracking of time for projects associated with customers and the
invoicing of that time to those customers (billing by project)

We have implemented a groupware solution using www.phpgroupware.org and a
modified timetrack module.  This system allows for the users to use a
constant web based interface for email, contact lists, project lists, and
time entry - and keeps them away from the accounting system.

We are customizing sql-ledger by changing it to refer to the phpgroupware
database tables as well as the sql-ledger tables to allow the sharing of
contact, project, and time information

It took us a while to figure out the sql-ledger programming style since we
don't know a thing about perl.

At this point we have project info being retrieved by using a modifed
Form.pm that grabs the info from the second databse that's read from the
user config files.

Invoices are being made by project using a modifed is.pl and IS.pm and we
are currently working on getting the time information.  We've added a button
at the bottom of the invoice screen called "Time Selection".  The intention
is to bring up a screen listing all the time entries associated with the
previously selected project with a pick box beside each entry.  The user
would pick the time entries to be billed (or all of them) and click on a add
to invoice button at the bottom.  The time entries would be added to the
invoice as a separate item for each time entry - pulling the bill out rate
from the phpgroupware database

So - this is where I have to start writing code (instead of just modifying
existing code)

My question is ...

Do I need to create separate files (.pl & .pm) to start this new form?

Re: Inventory Transaction

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

Inventory is added and removed when you purchase and sell the item.

A report can easily be built from the data in the invoice table.


Dieter Simader    http://www.sql-ledger.org   (780) 472-8161
DWS Systems Inc.     Accounting Software       Fax: 478-5281
=========== On a clear disk you can seek forever ===========

On Mon, 27 Aug 2001, Stephen Flynn wrote:

> 
> Does sql-ledger have a report to print inventory transaction logs for
> individual parts? By the way I'm new to this program and have not got it
> working yet.  If it doesn't have this capability then I need to look
> elsewhere.  If the data to print a transaction log is in the database then I
> could write a print routine for it.  I guess what I'm asking is, how does
> the inventory module add and remove parts from the system?
> 
> 
> Thanks,
> 
> Stephen Flynn
> Network Administrator
> AFA Products, Inc
> 

Inventory Transaction

[Stephen F. <Ste...@af...>]

Does sql-ledger have a report to print inventory transaction logs for
individual parts? By the way I'm new to this program and have not got it
working yet.  If it doesn't have this capability then I need to look
elsewhere.  If the data to print a transaction log is in the database then I
could write a print routine for it.  I guess what I'm asking is, how does
the inventory module add and remove parts from the system?


Thanks,

Stephen Flynn
Network Administrator
AFA Products, Inc

Re: Install problem with pg_shadow

[Juha H. <juh...@ni...>]

Thomas Good wrote:

> > SetUserId: user 'juha' is not in 'pg_shadow' at SL/User.pm line 112
>
> As the postgres user:  createuser juha (answer yes twice thereafter)

Thank you for your advice. Now it's working. I also found good advice for
postgres from linux-kontor installation help. (One page is
http://www.cyber-neurones.org/farias/body_postgresql.shtml )

Juha

RE: Could SQL-ledger ever support multiple currencies within a co mpany?

[Leo R M. <Le...@Ne...>]

Perhaps my situation is more relevant.  My corporation is in Canada with
both Canadian and US clients.  Each country's clients are billed in that
country's currency.  Under the Canada-US Tax Treaty, my corporation is 
taxable only in Canada because it doesn't have a permanent base of 
operations in the USA.  Therefore, my books are kept in CAD$ only.

The way I've found to handle this is to have the USD$ invoices include
entries for the exchange to all relevant accounts such as A/R and 
USD$ revenue.  These entries are equal and opposite so that the customer
sees these lines as net zero irrelevant entries.  However, this does
keep the books viable for immediate CAD$ reports.

-----Original Message-----
From: Steve Doerr [mailto:sd...@sw...]
Sent: August 23, 2001 22:11
To: sql...@li...
Subject: Re: Could SQL-ledger ever support multiple currencies within a
company?


Jeff Kowalczyk wrote:

> [Jijo] I just thought I'd raise a concern here. I'm from the Philippines
> and here, believe me, the foreign exchange rates are more volatile than
> the rise and fall of the tides. That would be something quite difficult
> to deal with, although I don't think first world countries experience
> such volatility.
>
> [jeff] If a US company did business there, purchased inventory and sold
> goods in the local currency, but reported back to a US concern, would
> everything be accounted for in Phillipine Dollars or US dollars?

The Phillipine based company would keep their books in Phillipine peso's.
Then the foreign currency financial statements are translated to US dollars
before the parent reports results.

Translation rules are very specific, with some items (i.e. monetary assets
like cash and receivables) translated at current rates, and historical cost
based assets and liabilities at historical rates (like a building).
Revenues and expenses are translated at the rate on the transaction date,
or an average for the period.

The parent would make a journal entry to reflect the net translation
effect.  There isn't really a need to handle multiple currencies, because
each operation would and should keep their books entirely in the local
currency.

Re: Could SQL-ledger ever support multiple currencies within a company?

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

Jeff Kowalczyk wrote:

> [Jijo] I just thought I'd raise a concern here. I'm from the Philippines
> and here, believe me, the foreign exchange rates are more volatile than
> the rise and fall of the tides. That would be something quite difficult
> to deal with, although I don't think first world countries experience
> such volatility.
>
> [jeff] If a US company did business there, purchased inventory and sold
> goods in the local currency, but reported back to a US concern, would
> everything be accounted for in Phillipine Dollars or US dollars?

The Phillipine based company would keep their books in Phillipine peso's.
Then the foreign currency financial statements are translated to US dollars
before the parent reports results.

Translation rules are very specific, with some items (i.e. monetary assets
like cash and receivables) translated at current rates, and historical cost
based assets and liabilities at historical rates (like a building).
Revenues and expenses are translated at the rate on the transaction date,
or an average for the period.

The parent would make a journal entry to reflect the net translation
effect.  There isn't really a need to handle multiple currencies, because
each operation would and should keep their books entirely in the local
currency.

Re: Could SQL-ledger ever support multiple currencies within a company?

[John C. N. y L. <nj...@nt...>]

Jeff Kowalczyk wrote:
> 
> [Jijo] I just thought I'd raise a concern here. I'm from the Philippines
> and here, believe me, the foreign exchange rates are more volatile than
> the rise and fall of the tides. That would be something quite difficult
> to deal with, although I don't think first world countries experience
> such volatility.
> 
> [jeff] If a US company did business there, purchased inventory and sold
> goods in the local currency, but reported back to a US concern, would
> everything be accounted for in Phillipine Dollars or US dollars?

I'm also here in the Philippines, but AFAIK, we don't have Philippine
Dollars, we do have Philippine Peso, however...;-)

And the FOREX Rates are quite volatile, last week it was at around PHP53
to a $, now it's PHP51, perhaps next week it'll be PHP52...;-)

AFAIK, if you haven't converted your money from the local currency, to
that of your company's mother currency (i.e. U.S. dollars), then you
should base it on the current FOREX rates.  Once you have converted the
local currency, however, to that of your desired currency, then you can
start using that figure for the future...;-)

Perhaps you can relate it to the stock market, on having paper
loss/profit and real loss/profit...;-)

At least, that's my 2 centavos worth...;-)


Cheers,


John Clark
-- 
     /) John Clark Naldoza y Lopez                           (\
    / )    Software Design Engineer III                      ( \
  _( (_    _  Web-Application Development                    _) )_
 (((\ \>  /_>    Cable Modem Network Management System <_\  </ /)))
 (\\\\ \_/ /         NEC Telecom Software Phils., Inc.  \ \_/ ////)
  \       /                                              \       /
   \    _/  phone: (+63 32) 233-9142 loc. 3113            \_    /
   /   /  cellphone: (+63 919) 399-4742                     \   \
  /   / email: nj...@nt...                        \   \


"Intelligence is the ability to avoid doing work, yet getting the work
done"
--Linus Torvalds

RE: Could SQL-ledger ever support multiple currencies within a company?

[Jeff K. <jt...@ad...>]

[Jijo] I just thought I'd raise a concern here. I'm from the Philippines
and here, believe me, the foreign exchange rates are more volatile than
the rise and fall of the tides. That would be something quite difficult
to deal with, although I don't think first world countries experience
such volatility.

[jeff] If a US company did business there, purchased inventory and sold
goods in the local currency, but reported back to a US concern, would
everything be accounted for in Phillipine Dollars or US dollars?

Re: Could SQL-ledger ever support multiple currencies within a company?

[Federico S. I. <ji...@le...>]

On Thu, 23 Aug 2001 at 10:04, Jeff Kowalczyk wrote:
> This is a complicated issue, I don't know whether standard practice
> for an international company with remote offices is to convert
> everything to the local currency for each transaction, or to have
> exchange-rate transactions to get things back to the home currency at
> certain points of the fiscal year, or during advantageous exchange
> rates.

I just thought I'd raise a concern here. I'm from the Philippines and
here, believe me, the foreign exchange rates are more volatile than the
rise and fall of the tides. That would be something quite difficult to
deal with, although I don't think first world countries experience such
volatility.

 --> Jijo

--
Federico Sevilla III  :: ji...@le...
Network Administrator :: The Leather Collection, Inc.
GnuPG Key: <http://jijo.leathercollection.ph/jijo.gpg>

Viewing languages on US-eng IE55

[Jeff K. <jt...@ad...>]

I was curious what 'traditional chinese' would look like. Of course, I'm
using the US-english version of Windows and Internet Explorer. I added
the 'languages...' listed below to internet options.

English (United States)[en-us]
Chinese [zh]
Chinese (Tiawan) [zh-tw]

And created a SQL-Ledger user that has the chinese language preference.
I left charset blank. I also left stylesheet blank to avoid font
problems.

With this user, I only see the font-glyphs that are in the same
character-code, not the chinese characters shown in the full chinese
sample on the sql-ledger website.

Is what I'm trying to do possible? Does it have to do with the charset,
or do I need some special chinese font?

Could SQL-ledger ever support multiple currencies within a company?

[Jeff K. <jt...@ad...>]

I realize this is a pretty complicated feature, but is the basic
structure of SQL-ledger conducive to someday having the capability to
take transactions in more than one currency?

This is a complicated issue, I don't know whether standard practice for
an international company with remote offices is to convert everything to
the local currency for each transaction, or to have exchange-rate
transactions to get things back to the home currency at certain points
of the fiscal year, or during advantageous exchange rates.

Re: Install problem with pg_shadow

[Thomas G. <to...@ad...>]

On Thu, 23 Aug 2001, Juha Helminen wrote:

> What I can do for next error message?
> 
> Processing request from 127.0.0.1:32832
> Executing CGI at /home/juha/sql-ledger/dnhttpd/exec/../../login.pl
> DBI->connect(dbname=juha;host=localhost;port=5432) failed: FATAL 1: 
> SetUserId: user 'juha' is not in 'pg_shadow' at SL/User.pm line 112

As the postgres user:  createuser juha (answer yes twice thereafter)

pg_shadow is a view that accesses the pg system catalogue - specifically
that tables that contain user data.  

> Can't call method "disconnect" on an undefined value at SL/User.pm line
> 120.
> Compilation failed in require at
> /home/juha/sql-ledger/dnhttpd/exec/../../login.pl line 65.
> 
> 
> Netscape gives message like: try later... page is not available.

Netscape is somewhat slow on the uptake.  ;-)

Cheers,
Tom
--------------------------------------------------------------------
               SVCMC - Center for Behavioral Health                  
--------------------------------------------------------------------
Thomas Good                          tomg@ { admin | q8 } .nrnet.org
Programmer/Analyst                              Phone:  718-354-5528 
Residential Services                            Mobile: 917-282-7359  
--------------------------------------------------------------------
/*           Die Wahrheit Ist Irgendwo Da Draussen...             */
--------------------------------------------------------------------

Install problem with pg_shadow

[Juha H. <juh...@ni...>]

I have been installing Sql-Ledger 1.6.0 to Linux: Mandrake 8.0. I
downloaded perl-DBD-Pg-0.95-1mdk.i586.rpm from rpmfind.net (as it wasn't
in distribution?). /etc/init.d/postgresql is also modified at line 82
(postmaster is started with -o -i).

Current installation is in single user mode and dnhttpd is used.

What I can do for next error message?

Processing request from 127.0.0.1:32832
Executing CGI at /home/juha/sql-ledger/dnhttpd/exec/../../login.pl
DBI->connect(dbname=juha;host=localhost;port=5432) failed: FATAL 1: 
SetUserId: user 'juha' is not in 'pg_shadow' at SL/User.pm line 112
Can't call method "disconnect" on an undefined value at SL/User.pm line
120.
Compilation failed in require at
/home/juha/sql-ledger/dnhttpd/exec/../../login.pl line 65.


Netscape gives message like: try later... page is not available.

Later I'd line to translate this (locales) to Finnish.

Juha