sql-ledger-users — SQL-Ledger users

[SL] Numbers

[Florian R. <fl...@re...>]

Hi,

i've to deploy sql-ledger to my company.. and i've read the manual, and
changed some of the german translations. (if there is some intrest in this,
to whom can i send them?)

the number, like 'order number', 'Invoice Number', 'Quotation Number' .. are
these generated automatic? or semi automatic? And how can this numbers
controlled, so is it possible to change/jump number by year? or are these
just counters?


e.g. we want .. 

year 2006
starting by 1000

year 2007
starting by 5000

.
.

or

year 2006 
2006-<invoice number>

year 2007
2007-<invoice number>
.
.

I hadn't the time to experiment much (or look into the code),
so this may be a silly question (and request).

-- 
Florian Reitmeir

Re: [SL] CSV files and importing

[Jerome J. A. <jer...@bo...>]

Hi Jeff,

Some time ago, I had to deal with .DBF files and I used the Perl modules 
in this link:  http://search.cpan.org/search?query=DBF&mode=all

There are more than one option so just try which one fits your need.  
You might have to write a short script to do this.

jerome

Jeff Roberts wrote:

>Hello People
>
>My name is Jeff and I've been playing with SQL-Ledger for a few years 
>but have decided this year I'd get it fully running in my business 
>(electronic repair). I've got it installed on a server running BSD 5.3 
>with PgSql 7.4.5 and Apache 2.0, everything seems to be running OK and 
>I've already entered all of my GL accounts in.
>
>My next step is to import my customers, vendors and inventory 
>items(services).
>
>I downloaded the import script but it says that I must have my data in 
>tab delineated fixed length format and I'm having trouble finding a 
>program that will save in fixed length format. My current data is in 
>.DBF format and I've tried Paradox and Star Office 6.0 but neither gives 
>an option to save in a fixed length. My workstation computers are Linux 
>so a solution from EMS is out of the question, any suggestions?
>
>Jeff Roberts
>JR Electronics
>
>-------------------------------------------------------------------------
>Take Surveys. Earn Cash. Influence the Future of IT
>Join SourceForge.net's Techsay panel and you'll get the chance to share your
>opinions on IT & business topics through brief surveys - and earn cash
>http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
>_______________________________________________
>sql-ledger-users mailing list
>sql...@li...
>https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>  
>

Re: [SL] Archive?

[Jonas B. N. <jo...@io...>]

Hi George,

The archive is located at:
http://sourceforge.net/mailarchive/forum.php?forum_id=7140

As mentioned on:
http://www.sql-ledger.org/cgi-bin/nav.pl?page=misc/ 
mailinglist.html&title=Mailing%20Lists

jonasbn

On 04/01/2007, at 11.43, George James wrote:

> Hi
> Where's the archive for this list?
>
> George
> ---------------------------------------------------------------------- 
> ---
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to  
> share your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php? 
> page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>

[SL] Archive?

[George J. <Ge...@ge...>]

Hi
Where's the archive for this list?
 
George

Re: [SL] Various Problems SL 2.4.11/PGSQL 8.1.3

[Jason K. <ja...@no...>]

Okay, good.  That's what I did.

I'm going to look at some of my older backups (from before I messed
everything up) to see if I can find some values for the invoiceid and
orderitemsid sequences and see what that does.

Thanks,

Jason Kay.


On 1/2/07, Dieter Simader <dsi...@sq...> wrote:
>
> Do not edit Pg-tables.sql, it has nothing to do with a backup. Edit the
> backup file only.
>
> --
> Dieter Simader       http://www.sql-ledger.com   Tel: (780) 472-8161
> DWS Systems Inc.        Accounting Software      Fax: (780) 478-5281
> ============== On a clear disk you can seek forever ================
>

Re: [SL] Sql-Ledger 2.6.22/PostgreSQL 8.1.5

[Adrian B. <adr...@ie...>]

Peter,

I did the same a few days ago. see Enrique's comments. Was the SQL-Ledger the latest version or near latest?

Adrian

Peter Dabrowski wrote:
> Hi,
> I just updated my system with Mandriva 2007 which comes with Postgresql 8.x. 
> My previous db was postgresql 7.4.4
> Before rebuilding my system checked with sql-ledger FAQ which mention about some problems with older versions.
> So I done global backup of my db's using pg_dumpall
> After restoring the dump onto new system and connecting Sql-Ledger to it I encountered a problem during trying
> to create sales order. (it was my first transaction after restore)
> 
> DBD::Pg::st execute failed: ERROR: column "oid" does not exist
> Error!
> SELECT oid AS oid, qty,
>  (SELECT SUM(qty) FROM inventory
>  WHERE trans_id = 10559
>  AND orderitems_id = ?) AS total
>  FROM inventory
>  WHERE trans_id = 10559
>  AND orderitems_id = ?
> ERROR: column "oid" does not exist
> 
> What will be the best approach in this case to correct this?
> 
> Thanks
> Peter
> 

-- 
Adrian Blake
Molonglo Radio Observatory
University of Sydney
1152 Hoskinstown Rd
Bungendore 2621
ph. 02 80042212  mobile 0407 232 978

http://150.101.125.30

[SL] CSV files and importing

[Jeff R. <Jef...@te...>]

Hello People

My name is Jeff and I've been playing with SQL-Ledger for a few years 
but have decided this year I'd get it fully running in my business 
(electronic repair). I've got it installed on a server running BSD 5.3 
with PgSql 7.4.5 and Apache 2.0, everything seems to be running OK and 
I've already entered all of my GL accounts in.

My next step is to import my customers, vendors and inventory 
items(services).

I downloaded the import script but it says that I must have my data in 
tab delineated fixed length format and I'm having trouble finding a 
program that will save in fixed length format. My current data is in 
.DBF format and I've tried Paradox and Star Office 6.0 but neither gives 
an option to save in a fixed length. My workstation computers are Linux 
so a solution from EMS is out of the question, any suggestions?

Jeff Roberts
JR Electronics

Re: [SL] Sql-Ledger 2.6.22/PostgreSQL 8.1.5

[Dirk E. S. <ds...@ca...>]

> Hi,
> I just updated my system with Mandriva 2007 which comes with Postgresql

>
> DBD::Pg::st execute failed: ERROR: column "oid" does not exist
> Error!
> SELECT oid AS oid, qty,
>    (SELECT SUM(qty) FROM inventory
>    WHERE trans_id =3D 10559
>    AND orderitems_id =3D ?) AS total
>    FROM inventory
>    WHERE trans_id =3D 10559
>    AND orderitems_id =3D ?
> ERROR: column "oid" does not exist
>
> What will be the best approach in this case to correct this?

You will have to edit your backups by hand as described in the FAQ:

http://www.sql-ledger.org/cgi-bin/nav.pl?page=3Dmisc/faq.html&title=3DFAQ

Check for the section PostgreSQL 8.0+

Good luck

Enrique

>
> Thanks
> Peter
>




--=20
Dirk Enrique Seiffert - Lintec S.A.
Ed. Torre del Reloj - Of. 401
Plaza de los Coches, Centro
Cartagena - Colombia
http://www.lintecsa.com

[SL] Sql-Ledger 2.6.22/PostgreSQL 8.1.5

[Peter D. <mer...@ma...>]

Hi,
I just updated my system with Mandriva 2007 which comes with Postgresql 8.x=
.=20
My previous db was postgresql 7.4.4
Before rebuilding my system checked with sql-ledger FAQ which mention about=
 some problems with older versions.
So I done global backup of my db's using pg_dumpall
After restoring the dump onto new system and connecting Sql-Ledger to it I =
encountered a problem during trying
to create sales order. (it was my first transaction after restore)

DBD::Pg::st execute failed: ERROR: column "oid" does not exist
Error!
SELECT oid AS oid, qty,
 (SELECT SUM(qty) FROM inventory
 WHERE trans_id =3D 10559
 AND orderitems_id =3D ?) AS total
 FROM inventory
 WHERE trans_id =3D 10559
 AND orderitems_id =3D ?
ERROR: column "oid" does not exist

What will be the best approach in this case to correct this?

Thanks
Peter

--=20
Low Prices, Wide Selection of Gas Masks
Everyday low price guarantee. We offer special police discounts and an extr=
emely wide selection of gas masks, filters and huge selection of preparedne=
ss gear.
http://a8-asy.a8ww.net/a8-ads/adftrclick?redirectid=3D24e08df2353d2e6cb9bae=
3a0e3c8c61e

[SL] Sql-Ledger 2.6.22/PostgreSQL 8.1.5

[Peter D. <mer...@ma...>]

Hi,
I just updated my system with Mandriva 2007 which comes with Postgresql 8.x.
My previous db was postgresql 7.4.4
Before rebuilding my system checked with sql-ledger FAQ which mention=20
about some problems with older versions.
So I done global backup of my db's using pg_dumpall
After restoring the dump onto new system and connecting Sql-Ledger to=20
it I encountered a problem during trying
to create sales order. (it was my first transaction after restore)

DBD::Pg::st execute failed: ERROR: column "oid" does not exist
Error!
SELECT oid AS oid, qty,
   (SELECT SUM(qty) FROM inventory
   WHERE trans_id =3D 10559
   AND orderitems_id =3D ?) AS total
   FROM inventory
   WHERE trans_id =3D 10559
   AND orderitems_id =3D ?
ERROR: column "oid" does not exist

What will be the best approach in this case to correct this?

Thanks
Peter


--=20
Low Prices, Wide Selection of Gas Masks
Everyday low price guarantee. We offer special police discounts and an extr=
emely wide selection of gas masks, filters and huge selection of preparedne=
ss gear.
http://a8-asy.a8ww.net/a8-ads/adftrclick?redirectid=3D24e08df2353d2e6cb9bae=
3a0e3c8c61e

Re: [SL] Various Problems SL 2.4.11/PGSQL 8.1.3

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

Do not edit Pg-tables.sql, it has nothing to do with a backup. Edit the
backup file only.

-- 
Dieter Simader       http://www.sql-ledger.com   Tel: (780) 472-8161
DWS Systems Inc.        Accounting Software      Fax: (780) 478-5281
============== On a clear disk you can seek forever ================
On Mon, 1 Jan 2007, Jason Kay wrote:

> > You have to edit the backup and adjust the tables as per FAQ and add
> > WITH OIDS before you restore. You also have to add a "SELECT
> > SETVAL('sequence', sequencenumber);" after the "DROP SEQUENCE" lines
> > and remove the "DROP SEQUENCE" lines.
>
> Thank you Dieter.  I did this and it has fixed the problem I had with
> printing assemblies.  I made a new invoice just now, and when I ran a
> report for outstanding invoices for the client, two invoices were
> displayed, with the same invoice number, date, total, etc.  When I
> opened one of them, I noticed that an old inventory item and payment
> were added to the invoice along with what I had entered.
>
> When I was editing the backup file, I had no trouble adding WITH OIDS to
> the correct locations, but when I was replacing the DROP SEQUENCE --
> Pg-tables.sqlentries with SELECT SETVAL entries I only had a
> 'sequencenumber' for SEQUENCE id.  The invoiceid and orderitemsid
> SEQUENCES each did not have one:
>
> ***Snip from backup file:
> ...
> DROP SEQUENCE id ;
> DROP SEQUENCE invoiceid ;
> DROP SEQUENCE orderitemsid ;
> --
> ...
>
> ...
> -- Pg-tables.sql
> CREATE SEQUENCE id start 10000;
> SELECT nextval ('id');
> CREATE SEQUENCE invoiceid;
> SELECT nextval ('invoiceid');
> CREATE SEQUENCE orderitemsid MAXVALUE 100000 CYCLE;
> SELECT nextval ('orderitemsid');
> ...
> ***End Snip from backup file.
>
> I put the following just after the DROP SEQUENCE entries, then deleted
> the DROP SEQUENCE entries:
>
> SELECT SETVAL('id',10000);
> SELECT SETVAL('invoiceid');
> SELECT SETVAL('orderitemsid');
>
> (So, the SELECT SETVAL entries are still above the '-- Pg-tables.sql'
> line.)  Is the lack of a 'sequencenumber' for the invoiceid and
> orderitemsid SEQUENCES the cause of this problem?  If so, how do I
> determine what values to put in?
>
>
> Jason Kay.
>
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>

[SL] AR Aging problem / was Re: problem processing recurring transactions

[Andi S. <as...@ac...>]

hi,

thank you for the quick reply - meanwhile I found out myself:

in templates/.../invoice.html I used a construct <%if fax%>kein Telefax

which worked with 2.6.3. Even <%if fax%><!-- kein Telefax --> gives an 
error ;-))

Quite simple but not mentioned neither in debian changelog nor on 
sql-ledger.org.

The one thing I did not find out was the following:

selecting AR aging, selecting only overdue AR and trying to print / email 
all statements

  by selecting all and pressing print or email

  only prints/mails the first statement

is this a bug or a feature?

regards

A.
On Mon, 1 Jan 
2007, Seneca Cunningham wrote:

> On Tue, Jan 02, 2007 at 01:46:25AM +0100, Andi Stern wrote:
>> when trying to process recurring transactions (to AR) I get
>>
>> Posting Ausgangsrechnung 7057 ..... fertig
>> Sending Bitte um Bezahlung 7057Content-Type: text/html
>> Error!
>>
>> Can't locate object method "kein" via package "Telefax" (perhaps you
>> forgot to load "Telefax"?) at (eval 10) line 1.
>> ..... fertig
>>
>> and nothing is sent via mail.
>
> Two quick questions... Do you have a file called Telefax.pl or
> Telefax.pm anywhere that SL could find it?  And in bin/mozilla/am.pl
> there is a call to system that is what tells SL to email the sales
> invoice (line 3229 in 2.6.22) which succeeds.  What are the values
> of $form->{script}, $form->{module}, and $form->{type} at that point?
>
>

Re: [SL] problem processing recurring transactions

[Seneca C. <te...@gm...>]

On Tue, Jan 02, 2007 at 01:46:25AM +0100, Andi Stern wrote:
> when trying to process recurring transactions (to AR) I get
> 
> Posting Ausgangsrechnung 7057 ..... fertig
> Sending Bitte um Bezahlung 7057Content-Type: text/html
> Error!
> 
> Can't locate object method "kein" via package "Telefax" (perhaps you 
> forgot to load "Telefax"?) at (eval 10) line 1.
> ..... fertig
> 
> and nothing is sent via mail.

Two quick questions... Do you have a file called Telefax.pl or 
Telefax.pm anywhere that SL could find it?  And in bin/mozilla/am.pl
there is a call to system that is what tells SL to email the sales
invoice (line 3229 in 2.6.22) which succeeds.  What are the values
of $form->{script}, $form->{module}, and $form->{type} at that point?

-- 
Seneca
te...@gm...

[SL] problem processing recurring transactions

[Andi S. <as...@ac...>]

hi,

when trying to process recurring transactions (to AR) I get

Posting Ausgangsrechnung 7057 ..... fertig
Sending Bitte um Bezahlung 7057Content-Type: text/html
Error!

Can't locate object method "kein" via package "Telefax" (perhaps you 
forgot to load "Telefax"?) at (eval 10) line 1.
..... fertig

and nothing is sent via mail.

last year (I think that was 2.6.3 prior to 2.6.19 / debian version) that 
worked.

Any help would be appreciated!

regards

A.

P.S.: Has anybody succeeded in mailing more than one statement to more 
than one customer at one time?

Re: [SL] Various Problems SL 2.4.11/PGSQL 8.1.3

[Jason K. <ja...@no...>]

> You have to edit the backup and adjust the tables as per FAQ and add
> WITH OIDS before you restore. You also have to add a "SELECT
> SETVAL('sequence', sequencenumber);" after the "DROP SEQUENCE" lines
> and remove the "DROP SEQUENCE" lines.

Thank you Dieter.  I did this and it has fixed the problem I had with
printing assemblies.  I made a new invoice just now, and when I ran a
report for outstanding invoices for the client, two invoices were
displayed, with the same invoice number, date, total, etc.  When I
opened one of them, I noticed that an old inventory item and payment
were added to the invoice along with what I had entered.

When I was editing the backup file, I had no trouble adding WITH OIDS to
the correct locations, but when I was replacing the DROP SEQUENCE --
Pg-tables.sqlentries with SELECT SETVAL entries I only had a
'sequencenumber' for SEQUENCE id.  The invoiceid and orderitemsid
SEQUENCES each did not have one:

***Snip from backup file:
...
DROP SEQUENCE id ;
DROP SEQUENCE invoiceid ;
DROP SEQUENCE orderitemsid ;
--
...

...
-- Pg-tables.sql
CREATE SEQUENCE id start 10000;
SELECT nextval ('id');
CREATE SEQUENCE invoiceid;
SELECT nextval ('invoiceid');
CREATE SEQUENCE orderitemsid MAXVALUE 100000 CYCLE;
SELECT nextval ('orderitemsid');
...
***End Snip from backup file.

I put the following just after the DROP SEQUENCE entries, then deleted
the DROP SEQUENCE entries:

SELECT SETVAL('id',10000);
SELECT SETVAL('invoiceid');
SELECT SETVAL('orderitemsid');

(So, the SELECT SETVAL entries are still above the '-- Pg-tables.sql'
line.)  Is the lack of a 'sequencenumber' for the invoiceid and
orderitemsid SEQUENCES the cause of this problem?  If so, how do I
determine what values to put in?


Jason Kay.

Re: [SL] Ubuntu sql-ledger install

[Vladimir B. <vl...@bo...>]

Hello,

<answer investment=long-term>
try and connect to the database from the command prompt with psql.

$ man psql
$ psql database user

If this works use the data (database,user,password) in sql-ledger 
configuration.
</answer>

Cheers, -vlado


On Sun, 31 Dec 2006, Oliver Devoogdt wrote:

> Hi,
>
>
> What I did:
> -installed sql-ledger with apt-get
> -installed postgresql-8.1 with apt-get
> -createuser -d sql-ledger
> -createlang plpgsql template1
>
> -changed /etc/postgresql/8.1/main/pg_hba.conf to reflect "local all all
> trust"
> -restarted postgresql-8.1
>
> I am still receiving "FATAL: IDENT authentication failed for user
> "sql-ledger"
>
> Can someone point me in the good direction ?
>
>
> Thanks,
>
>
> Oliver
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>

Re: [SL] DBD; failed to initialise

[Adrian <adr...@ie...>]

I created a new user as suggested by Torben. I could then access an empty 
dataset. Then a restore:

psql -U sql-ledger dbname < backup.sql

Bingo! everything works.

Adrian

On Sunday 31 December 2006 21:06, you wrote:
> Adrian,
>
> SL saves passwords in files, if you did not copy over the files from the
> original server, you might not have any users. If possible, start your
> new installation by using your old SL files, and then upgrade (if
> needed). That's the only way I know of to restore old users.  If that
> doesn't work for you, you could probably safely add new ones (with
> different login spelling) without affecting the original ones while you
> find a solution in the interim.
>
> If you have a blank user slate, try logging into the admin area without
> a password..
>
> Adrian wrote:
> > I am submitting this a second time as the previous post was possibly
> > forgotten in the Christmas e-mails.
> >
> > The details:
> >  Mandriva 2007
> >  Postgres 8.1
> >  Latest SQL-Ledger
> >  Backed up on one computer and restored on new machine
> >
> >  Error message in bowser is:
> >  Error
> >  Access Denied
> >
> >  # tail /var/log/httpd/error_log
> >  [Sat Dec 23 05:05:19 2006] [crit] (20019)DSO load failed: DBD: failed to
> >  initialise
> >  [Sat Dec 23 05:05:19 2006] [crit] (20019)DSO load failed: DBD: can't
> > find driver for [DBDriver unset]
> >
> >  Is it a permissions problem or a software problem or database user
> > problem. Either something is missing or I have forgotten something in the
> > installation.
> >
> > Adrian

-- 
Adrian Blake
Molonglo Radio Observatory
1152 Hoskinstown Rd
Bungendore
NSW, 2621, Australia
ph 02 62382262 mobile 0407 232 978 skype vk2alf

[SL] DBD; failed to initialise

[Adrian <adr...@ie...>]

I am submitting this a second time as the previous post was possibly forgotten 
in the Christmas e-mails.

The details:
 Mandriva 2007
 Postgres 8.1
 Latest SQL-Ledger
 Backed up on one computer and restored on new machine
 
 Error message in bowser is:
 Error
 Access Denied
 
 # tail /var/log/httpd/error_log
 [Sat Dec 23 05:05:19 2006] [crit] (20019)DSO load failed: DBD: failed to
 initialise
 [Sat Dec 23 05:05:19 2006] [crit] (20019)DSO load failed: DBD: can't find
 driver for [DBDriver unset]
 
 Is it a permissions problem or a software problem or database user problem. 
Either something is missing or I have forgotten something in the 
installation.
 
Adrian
-- 
Adrian Blake
Molonglo Radio Observatory
1152 Hoskinstown Rd
Bungendore
NSW, 2621, Australia
ph 02 62382262 mobile 0407 232 978 skype vk2alf

Re: [SL] Ubuntu sql-ledger install

[Seneca C. <te...@gm...>]

On Sun, Dec 31, 2006 at 11:22:46AM +0100, Oliver Devoogdt wrote:
> What I did:
> -installed sql-ledger with apt-get
> -installed postgresql-8.1 with apt-get
> -createuser -d sql-ledger
> -createlang plpgsql template1
> 
> -changed /etc/postgresql/8.1/main/pg_hba.conf to reflect "local all all 
> trust"
> -restarted postgresql-8.1
> 
> I am still receiving "FATAL: IDENT authentication failed for user 
> "sql-ledger"
> 
> Can someone point me in the good direction ?

The local line in pg_hba.conf only applies to connections through Unix
sockets, not TCP/IP.  My recommendation is to convert your local line 
to "md5" or "ident sameuser" and add a host line for 127.0.0.1/32 that 
sets md5 auth as a permissible manner with which you can connect to the
SL database and as the SL db user.  My dislike for trust is for security
and data preservation reasons... don't see why non-dba Joe User or his 
confused cron job should be able to access the entire cluster.

Also, if you have postgresql-server-7.4 installed, you could be querying
the wrong cluster, so check the port numbers involved.

Read the PostgreSQL documentation chapter about client authentication[1]
for more details about how it works and how to correctly configure it 
for your needs.

[1] <http://www.postgresql.org/docs/8.1/static/client-authentication.html>

-- 
Seneca
te...@gm...

Re: [SL] Ubuntu sql-ledger install

[John W. F. <joh...@ve...>]

On Sunday 31 December 2006 04:22 am, Oliver Devoogdt wrote:
> Hi,
>
>
> What I did:
> -installed sql-ledger with apt-get
> -installed postgresql-8.1 with apt-get
> -createuser -d sql-ledger
> -createlang plpgsql template1
>
> -changed /etc/postgresql/8.1/main/pg_hba.conf to reflect "local all all
> trust"
> -restarted postgresql-8.1
>
> I am still receiving "FATAL: IDENT authentication failed for user
> "sql-ledger"
>
> Can someone point me in the good direction ?
That resets your 'UNIX SOCKETS' locally so that PG recognizes them. You also 
need to set PG up to recognize you 'host' settings since it is a 'web app'
look for the line below in  /etc/postgresql/8.1/main/pg_hba.conf   edit to 
your needs and place and uncommented copy in 
your /etc/postgresql/8.1/main/pg_hba.conf 

#IPV4 style local connections
#host	all	all	127.0.0.1		255.255.255.255	trust

You may also need to restart your your webserver as well as PG after making 
this change.
Happy New Year!!

-- 
John W. Foster

[SL] Ubuntu sql-ledger install

[Oliver D. <ol...@ol...>]

Hi,


What I did:
-installed sql-ledger with apt-get
-installed postgresql-8.1 with apt-get
-createuser -d sql-ledger
-createlang plpgsql template1

-changed /etc/postgresql/8.1/main/pg_hba.conf to reflect "local all all 
trust"
-restarted postgresql-8.1

I am still receiving "FATAL: IDENT authentication failed for user 
"sql-ledger"

Can someone point me in the good direction ?


Thanks,


Oliver

Re: [SL] Various Problems SL 2.4.11/PGSQL 8.1.3

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

found it.

You have to edit the backup and adjust the tables as per FAQ and add WITH
OIDS before you restore. You also have to add a "SELECT SETVAL('sequence',
sequencenumber);" after the "DROP SEQUENCE" lines and remove the "DROP
SEQUENCE" lines.

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

On Sat, 30 Dec 2006, Jason Kay wrote:

> > On Fri, 29 Dec 2006, Jason Kay wrote:
> > >
> > > I have been reading the SQL-Ledger FAQ, the SQL-Ledger manual, the
> >
> > I have no record that you ever purchased the manual from DWS.
> >
>
> I did.  Invoice J041205 dated April 12, 2005.  I did not realize that I
> had used a different e-mail address when I purchased it.  Sorry for the
> confusion.
>
> Jason Kay.

Re: [SL] Various Problems SL 2.4.11/PGSQL 8.1.3

[Jason K. <ja...@no...>]

> On Fri, 29 Dec 2006, Jason Kay wrote:
> >
> > I have been reading the SQL-Ledger FAQ, the SQL-Ledger manual, the
>
> I have no record that you ever purchased the manual from DWS.
>

I did.  Invoice J041205 dated April 12, 2005.  I did not realize that I
had used a different e-mail address when I purchased it.  Sorry for the
confusion.

Jason Kay.

Re: [SL] Various Problems SL 2.4.11/PGSQL 8.1.3

[Adrian B. <bla...@gm...>]

Suggestion:

Go to your backup of your SQL-Ledger data. copy. untar the copy if
required. Grep for "orderitems" and locate "CREATE TABLE orderitems (
....." as in the second item of the FAQ. Check it has the same format
as in the FAQ and hand edit if necessary.  Do the same for inventory
and assembly.
Also check your data that is the same as in the first item of the FAQ.
Now restore using this modified data.

It is important that you know how to backup, restore and drop a
database in Postgres. It may be worth purchasing the O'Reilly book. A
small price for valuable data.

Adrian


On 12/30/06, Jason Kay <ja...@no...> wrote:
> Hello.  I am currently trying to fix some problems I am having with SL
> 2.4.11 on Postgresql 8.1.3 (migrated to another machine with 8.2.0 while
> I try and fix it):
>
> 1) When I try to print an invoice containing an assembly, I get the
> following error:
>
> DBD::Pg::st execute failed: ERROR: column a.oid does not exist
> LINE 8: ORDER BY a.oid
> ^
> Error!
> SELECT p.partnumber, p.description, p.unit, a.qty, 			pg.partsgroup,
> p.partnumber AS sku FROM assembly a JOIN parts p ON (a.parts_id = p.id)
> LEFT JOIN partsgroup pg ON (p.partsgroup_id = pg.id) WHERE a.bom = '1'
> AND a.id = '10151' ORDER BY a.oid ERROR: column a.oid does not exist
> LINE 8: ORDER BY a.oid ^
>
> 2) When I create a new inventory item, duplicate inventory items are
> sometimes created (and when I add or remove stock of such, it is
> duplicated as well).
>
> 3) When I create a new invoice, (very) old inventory items and payments
> are sometimes shown on the new invoice along with what I have entered,
> after the invoice is posted.
>
> I have been reading the SQL-Ledger FAQ, the SQL-Ledger manual, the
> Postgresql FAQ and Online Documentation and Googling the internet in
> general in an attempt to determine how to fix my SL installation.  I've
> especially been paying attention to any information regarding OID's.  I
> have also been learning how to do basic querying in Postgresql.
>
> I have looked at the assembly table and it has the following columns:
> id   | parts_id | qty | bom | adj
> Can I add the missing a.oid column to the table?  If so, how do I
> populate it with the correct values?
>
> In the FAQ, it states:
>
> If you already built a dataset without this change (referring to
> creating the orderitems, inventory and assembly tables WITH OIDS) you
> will get an error when you try to save a PO or assembly.
>
> "ERROR: column "oid" does not exist"
>
> Drop the tables and rebuild WITH OIDS.
>
> I attempted this (even though I can create and save an assembly without
> a problem -- I just can't print an invoice that contains an assembly) by
> using the COPY TO command to send the contents of each table to file,
> dropping each table, creating each table as per the FAQ and then using
> the COPY FROM command to repopulate the tables.  This did not help with
> my first problem.  I will be testing to see if the second and third
> issues are still present or not.
>
> I believe this started (at least the assembly-related issues) when I
> attempted to upgrade to SL 2.6.19 a few months ago.  I'm pretty sure I
> didn't lock the database prior to untarring the upgrade file (and fixing
> the file permissions).  The database was upgraded and I ended up with an
> unusable mess!  Since I did not have the time to play around, I restored
> a backup of the SQL-Ledger directory and restored a backup of the
> database that I had made just prior.  Unfortunately, I don't recall
> changing the DROP SEQUENCE entries to SELECT SETVAL entries as per the
> FAQ.  Since I don't use assemblies very often, I didn't notice anything
> wrong until recently.  The second and third problems that I listed above
> didn't show up until much later.
>
> If anyone has any wisdom to share, I would be most appreciative!!  Thanks!
>
> Jason Kay.
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>

Re: [SL] Various Problems SL 2.4.11/PGSQL 8.1.3

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

On Fri, 29 Dec 2006, Jason Kay wrote:
>
> I have been reading the SQL-Ledger FAQ, the SQL-Ledger manual, the

I have no record that you ever purchased the manual from DWS.

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