sql-ledger-users

[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] 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

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

[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
>
>

[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] 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] 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?
>
>