sql-ledger-users — SQL-Ledger users

Re: [SL] Chart of Accounts for Norway

[Jonas S. <jo...@jo...>]

On Thu, 4 Apr 2002, Bj=F8rn Rasmussen wrote:

> I was happy when I saw there where a Norwegian Chart of Accounts for
> SQL-Ledger version 1.8.3.

1) $ cp sql/Danish_Default-chart.sql sql/Norwegian_Default-chart.sql

2) Translate and correct to your own country from within SQL-Ledger

3) See if the attached script still works (it was written for 1.6.x):

  3a) Edit dump-chart.sh to correct tax accounts and values.

  3b) $ dump-chart.sh name_of_your_DB > sql/your-own-Default-chart.sql

3c) Look at the result and compare to canadian chart (Dieter probably
knows best) especially the lines in the end, to see if it technically (no=
t
numbers, but the SQL codes) look alike.

 - Jonas

--=20
Jonas Smedegaard (+45 40843136)          http://dr.jones.dk/~jonas/
Spiff ApS (=3D IT-guide dr. Jones ApS)     http://dr.jones.dk/
Debian GNU/Linux developer               http://people.debian.org/~js/

Re: [SL] RedHat Linux 5.2

[Keith M. <km...@be...>]

You replace tha hardware and use a monitor on your servers? LOL, I'm still using
a headless P133 w/ 92 MB EDO RAM & 2x4GB SCSI hard disks for my main server. :)

Quoting Kenneth Gonsalves from [04/04/02 13:24 +0530]:
> my server started with rh 4.0-4.1-suse 6.0-rh 5.0-5.2 and now 7.1
> except for the monitor, keyboard, motherboard, harddisk and mouse it is the 
> same machine!
> 
> kg
> On Wednesday 03 April 2002 23:56, Sergio A. Kessler wrote:
> 
> >
> > I have a machine that once upon a time it was a redhat 4.0,
> > then 4.2, then changue hardware, then 5.0, etc, etc
> > nowdays, the same machine is a redhat 7.1, upgrade over upgrade...
> >
> > /sergio
-- 
Keith Mastin	     km...@be...
BeechTree Information Technology Services Inc.
137 Laird Drive    M4G 3V5    Tel(416)696-6070
	   http://www.beechtree.ca

RE: [SL] Chart of Accounts for Norway

[<fi...@be...>]

I Guess You read what you wanted to see instead of what it says:=20

There is an updated translation, not a chart.

I am updating the European Chart section at the moment, but do not know
if Norway uses another kind of scheme than
Germany or Holland for example. Holland is done, Germany on the way,
once the people in the EU make up their minds we=20
MIGHT end up with a European Standard Scheme. They should look at
Canada, ;-)

Adding a customized chart is quite simple once you have stumbled upon
it, if you have an existing scheme to start from:
Open the *_chart.sql in /var/www/html/sql-ledger/sql or somewhere
similar in your favourite text editor and off you go ;-)

Good luck,=20

Paul

> -----Original Message-----
> From: sql...@sq...=20
> [mailto:sql...@sq...] On Behalf Of=20
> Bj=F8rn Rasmussen
> Sent: donderdag 4 april 2002 23:54
> To: sql...@sq...
> Subject: [SL] Chart of Accounts for Norway
>=20
>=20
> Hi!
>=20
> I was happy when I saw there where a Norwegian Chart of Accounts for=20
> SQL-Ledger version 1.8.3.
>=20
>=20
> From the SQL-Ledger's web-page:
>=20
> SQL-Ledger Accounting News=20
> Mar. 11, 2002
> =20
> 12. Chart of Accounts for Austria, Turkish translation,=20
> updated Danish,=20
> Norwegian and Spanish translations.
>=20
>=20
> It's just that I can't find it :-( .  I don't get the choice when I=20
> create a new database, and there is no file for Norway under=20
> /usr/local/sql-ledger/sql.
>=20
>=20
> Is there anybody who know where to find this Chart of Accounts for=20
> Norway?
>=20
>=20
> Best regards!
>=20
> --=20
> Bj=F8rn Rasmussen                         Tel:     +47 38 04 09=20
> 55, +47 911=20
> 27367
> Bj=F8rn Rasmussen Nettverkstjenester	    E-mail:  =20
> bj...@se...
> Moneheia 47,
> Kristiansand,  4656                     Org.nr.  981 646 770
>=20
> RHCE:  http://www.redhat.com/rhce/rhce807001641802868.html
> MCSE, MCP, MCP+I:  NT 4.0
>=20
>=20

Re: [SL] Chart of Accounts for Norway

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

You misread that. The translation was updated. There is no chart of
accounts for Norway included.


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

On Thu, 4 Apr 2002, Bj=F8rn Rasmussen wrote:

> Hi!
>=20
> I was happy when I saw there where a Norwegian Chart of Accounts for=20
> SQL-Ledger version 1.8.3.
>=20
>=20
> >From the SQL-Ledger's web-page:
>=20
> SQL-Ledger Accounting News=20
> Mar. 11, 2002
> =20
> 12. Chart of Accounts for Austria, Turkish translation, updated Danish,=
=20
> Norwegian and Spanish translations.
>=20
>=20
> It's just that I can't find it :-( .  I don't get the choice when I=20
> create a new database, and there is no file for Norway under=20
> /usr/local/sql-ledger/sql.
>=20
>=20
> Is there anybody who know where to find this Chart of Accounts for=20
> Norway?
>=20
>=20
> Best regards!
>=20
>=20

Re: [SL] Need Help w/Debian Install

[kevin b. <kev...@bi...>]

hi there,

i've successfully installed SL on debian - i think the instructions are 
not quite right so i made some notes - i'm in a rush at the moment but 
i'll attach the notes as they are - if they need correcting then please 
do so and post them up.

i run woody as far as i remember i used standard packages including 
postgresql.

the notes are originally from the sql-ledger install instructions - my 
added comments are after the '#' marks

----------------------------------8<------------------------------------
Debian Installation
unpack sql-ledger into /var/www/sql-ledger

install postgresql (Dselect)

install apache

# this did not seem to be necessary
install libpg-dev (Dselect)


# these were the debina packages i installed

libdib-perl libdbd-pg-perl libpgperl




modify /etc/postgresql/postmaster.init
# should be /etc/postgresql/postmaster.conf

PGALLOWTCPIP=yes

PGPORT=5432
# this produced an error when restarting postgres - i left it out cos 
this port seems to be the default anyway.



create a user for managing SQL-Ledger databases
from root
su postgres
$ createuser
name of user- (create a postgres user who is also a Linux user
this user will be an account manager. Enable this user to create db and 
users)

# section not required cos of the packages installed earlier. 
---------------------------------------
install DBI
perl Makefile.PL
make
make test
login as root
make install

$ export POSTGRES_INCLUDE=/usr/include/postgresql
$ export POSTGRES_LIB=/var/lib/postgres

install DBD-Pg
login as account manager (above)
perl Makefile.PL
make
make test
login as root
make install

# and of not required 
bit--------------------------------------------------------------------

change /etc/apache/httpd.conf and add
AddHandler cgi-script .pl
ScriptAlias /sql-ledger/ /var/www/sql-ledger/
<Directory /var/www/sql-ledger>
   Options ExecCGI Includes FollowSymlinks
</Directory> restart apache


# the apahce server on woody runs under the user www-data - so use

chown www-data: users templates users/members

the ':' means that the default group for www-data is set.


Make sure the web server has write permission to write to the following

users/
templates/
users/members

# chown nobody:nogroup users templates users/members



users/members might not exist. Not to worry, the file will be created
when you use admin.pl for the first time.
Of course, the permission has to be set correctly for the users directory.
# i found the file was not created automatically - i 'touched' it and 
then set the ownership to www-data


# finally the settings in pg_hba.conf were too restrictive and i set 
them to
host         all         127.0.0.1     255.0.0.0           trust

obviously this should be tighter but it was late at the time!!!


 From browser enter http://my_domain/sql-ledger/admin.pl
Login as the postgres user (account manager) you have created (above)
Create a DB
Create users

then enter http://my_domain/sql-ledger/login.pl



----------------------------------8<------------------------------------

HTH

kev bailey


JC Boursiquot wrote:
> I am still running the version before last for SL on a woody box.  I have
> no problem so far.
> 
> I will attempt to update my system tonight and will email you.  If your
> problem persist, I will try my best to assist you.  Make sure you have the
> correct version of Postgressql installed.
> 
> I beleive the version of Postgressql that you need is not on the package
> list like you said, I downloaded the latest Postgressql source and compile
> a deb file using checkinstall.
> 
> Until later....  have a nice day.
> 
> 
>>Jonas Smedegaard wrote:
>>I am a Debian user and there are as yet no .deb installation files
>>available. I have managed to get SL installed and it seems to run up to
>>the point where I try to create databases or login to the accounting
>>system. I tried SL several versions ago & decided to wait for it to
>>mature. I want to try it now to see if will meet my needs. Is there any
>>body here with experience with Debian that I can correspond with to get
>>SL working? I have it installed on a Woody box that is currently up to
>>date. I also do not normally use postgres but MySQL, which is easier to
>>manage but does not perform transaction accounting. I need to swithc
>>over and currently not sure where the error is. It seems to be that SL
>>will communicate with the postgresql server but is refused admittance
>>to the database that I created using psql command line  instructions. I
>>did create a postrgres user that is also a linux user and I added the
>>www-data user to postgres as well. I did read & follow the Debian
>>installation instructions in the FAQ. The error that I get is below;
>>
>>Error!
>>
>>IDENT authentication failed for user 'fred'
>>--
>>John Foster
>>
> 
> 
> 
> 
> 
> 
> JC Boursiquot, Chief Architect
> TekMD, Incorporated
> Tel.  908-412-8511
> Fax   908-412-8581
> Pager 908-323-1200
> 
> 
> 
> 
> 
> 

Re: [SL] Installation prob. - Internal Server Error

[Julien L. <jul...@it...>]

On Thu, Apr 04, 2002 at 10:02:58AM +0200, klavs klavsen wrote:
> I'm running RedHat 7.2, Perl 5.6.1 (they upgraded to it - look in
> updates), apache 1.3.22 (you should upgrade) and postgresql 7.2 - all
> from redhat rpms.

Upgrading perl and postgres solved the problem, which is somehow strange
because both were "recent" (younger than 10 months) and already
installed from RPMs (only apache had a strange home-made
compilation/configuration)...

So thanks again Klavs and everybody who helped, and for Tom, you can
find the packages at rpmfind.net, I downloaded the packages called
"RedHat 7.2 Updates for i386" to have the latest version of everything,
except for postgres I downloaded the packages from "RawHide 1.0". Also,
be sure to download perl-DBD-Pg and perl-DBI.

Once more, thank you!

Julien

[SL] Chart of Accounts for Norway

[R. <bj...@se...>]

Hi!

I was happy when I saw there where a Norwegian Chart of Accounts for=20
SQL-Ledger version 1.8.3.


From the SQL-Ledger's web-page:

SQL-Ledger Accounting News=20
Mar. 11, 2002
=20
12. Chart of Accounts for Austria, Turkish translation, updated Danish, =

Norwegian and Spanish translations.


It's just that I can't find it :-( .  I don't get the choice when I=20
create a new database, and there is no file for Norway under=20
/usr/local/sql-ledger/sql.


Is there anybody who know where to find this Chart of Accounts for=20
Norway?


Best regards!

--=20
Bj=F8rn Rasmussen                         Tel:     +47 38 04 09 55, +47 =
911=20
27367
Bj=F8rn Rasmussen Nettverkstjenester	    E-mail:   bj...@se...=

Moneheia 47,
Kristiansand,  4656                     Org.nr.  981 646 770

RHCE:  http://www.redhat.com/rhce/rhce807001641802868.html
MCSE, MCP, MCP+I:  NT 4.0

[SL] print order and invoices

[Valter V. <vi...@ts...>]

Hello,

I=B4m trying to print orders and invoices, show the message;
sales_order.html : No such file or directory
invoice.htm: No such file or directory.

How could solve this problem.

Thanks

Valter

Re: [SL] RedHat Linux 5.2

[kevin b. <kev...@bi...>]

hi omar,

its *upgrading* the libraries/packages which may cause problems.

on internet facing servers it is necessary to install security updates - 
and on workstations you obviously want the latest version of apps - but 
i agree - if the server is a print/file/etc server then it may not need 
updating and therefore can be left in peace,

also - whilst we're on the subject - it is possible to update ALL the 
packages on a debian m/c with

#apt-get update    // to update the list of packages

and

#apt-get upgrade    // to fetch, install and configure all packages on

the m/c.

i've not used RH for a while so i don't know - but - is this possible on RH?

kev bailey

BTW i know of servers which run these commands every night as a cron job 
so the servers are always up to date.



Omar BaheyEldin wrote:
> I have redhat 5.2 installed on a server for about three years or more , 
> and this server does not even have a keyboard,
> nobody have "touched" it for more than three years
> 
> At 07:57 Õ 01/04/02 +0530, Kenneth Gonsalves wrote:
> 
>> this was a problem in rh 5.2 - have you heard similar reports on 6.2 
>> and 7.2?
>> kg
>> On Sunday 31 March 2002 19:52, kevin bailey wrote:
>> > hi omar,
>> >
>> > might be time to check out debian if you are going to reinstall - i
>> > found that after RH has been installed for a year or so the 
>> dependencies
>> > get mixed up and become so much of a mess that further RPM installation
>> > becomes impossible.
>> >
> 
> 
> 
> _________________________________________________________
> Do You Yahoo!?
> Get your free @yahoo.com address at http://mail.yahoo.com
> 
> 
> 
> 

Re: [SL] Installation prob. - Internal Server Error

[Julien L. <jul...@it...>]

On Thu, Apr 04, 2002 at 10:02:58AM +0200, klavs klavsen wrote:
> On Wed, 2002-04-03 at 19:24, Julien Lajeunesse wrote:
> > Postgresql was installed from the RPMs, I did the modifications you
> > mentionned (though it doesn't seem to make much difference, I was
> > already able to connect via tcp/ip (telnet localhost 5432)).
> are you running Redhat? which version of distro?

It was originally a RedHat 7.0, but has been heavily patched/updated
over time, so I would say it's now the equivalent of a 7.1 and more.

> > By the way, the versions currently installed are:
> > perl 5.6.0 (from rpms)
> > apache 1.3.17 (compiled with lots of extras ;)
> > postgresql 7.0.3 (from rpms)
> I'm running RedHat 7.2, Perl 5.6.1 (they upgraded to it - look in
> updates), apache 1.3.22 (you should upgrade) and postgresql 7.2 - all
> from redhat rpms.

Unfortunately I'm kinda "locked" for the apache and postgresql for
various configuration reasons (notably drivers to postgres for an older
systems which seem to work only with 7.0.x). Since this is an internal
server it was not so critical to update to newer versions. I'll try it
on a different one though, where I can update those.

> Try running the perl-script from the command prompt and see if you get
> any error messages..

I'll also try this if the new versions aren't any help.

> [mod_perl causing problemes with SQL-Ledger]

I only have mod_cgi installed, could it cause any problem?

Once again, many many thanks!

Julien

Re: [SL] RedHat Linux 5.2

[Kenneth G. <la...@th...>]

my server started with rh 4.0-4.1-suse 6.0-rh 5.0-5.2 and now 7.1
except for the monitor, keyboard, motherboard, harddisk and mouse it is the 
same machine!

kg
On Wednesday 03 April 2002 23:56, Sergio A. Kessler wrote:

>
> I have a machine that once upon a time it was a redhat 4.0,
> then 4.2, then changue hardware, then 5.0, etc, etc
> nowdays, the same machine is a redhat 7.1, upgrade over upgrade...
>
> /sergio

Re: [SL] Need Help w/Debian Install

[JC B. <jc...@te...>]

I am still running the version before last for SL on a woody box.  I have
no problem so far.

I will attempt to update my system tonight and will email you.  If your
problem persist, I will try my best to assist you.  Make sure you have the
correct version of Postgressql installed.

I beleive the version of Postgressql that you need is not on the package
list like you said, I downloaded the latest Postgressql source and compile
a deb file using checkinstall.

Until later....  have a nice day.

> Jonas Smedegaard wrote:
> I am a Debian user and there are as yet no .deb installation files
> available. I have managed to get SL installed and it seems to run up to
> the point where I try to create databases or login to the accounting
> system. I tried SL several versions ago & decided to wait for it to
> mature. I want to try it now to see if will meet my needs. Is there any
> body here with experience with Debian that I can correspond with to get
> SL working? I have it installed on a Woody box that is currently up to
> date. I also do not normally use postgres but MySQL, which is easier to
> manage but does not perform transaction accounting. I need to swithc
> over and currently not sure where the error is. It seems to be that SL
> will communicate with the postgresql server but is refused admittance
> to the database that I created using psql command line  instructions. I
> did create a postrgres user that is also a linux user and I added the
> www-data user to postgres as well. I did read & follow the Debian
> installation instructions in the FAQ. The error that I get is below;
>
> Error!
>
> IDENT authentication failed for user 'fred'
> --
> John Foster






JC Boursiquot, Chief Architect
TekMD, Incorporated
Tel.  908-412-8511
Fax   908-412-8581
Pager 908-323-1200

Re: [SL] Installation prob. - Internal Server Error

[klavs k. <kl...@vs...>]

On Wed, 2002-04-03 at 19:24, Julien Lajeunesse wrote:
> Hi Klavs,
>=20
> Postgresql was installed from the RPMs, I did the modifications you
> mentionned (though it doesn't seem to make much difference, I was
> already able to connect via tcp/ip (telnet localhost 5432)).
are you running Redhat? which version of distro?

> Unfortunately I still have the same Internal Server Error when trying to
> login or click on "Create Dataset".
>=20
> By the way, the versions currently installed are:
> perl 5.6.0 (from rpms)
> apache 1.3.17 (compiled with lots of extras ;)
> postgresql 7.0.3 (from rpms)
I'm running RedHat 7.2, Perl 5.6.1 (they upgraded to it - look in
updates), apache 1.3.22 (you should upgrade) and postgresql 7.2 - all
from redhat rpms.
=20
> Thanks again for the help, I'm still investigating the probleme on my
> own in the meantime!
your welcome.

The response you get in your apache logs, just means that the perl script d=
oesn't respond with correct html.
Try running the perl-script from the command prompt and see if you get
any error messages.. (this is the problem with cgi-perl - error messages
are thrown away). Otherwise you could install mod_perl module - just for
a while, mod-perl cathes the errormsgs and logs them to apache's
errorlog - because the perl is embedded in the apache process..(be aware
that mod_perl might cause problems with sql-ledger - atleast on the
second run of a perl-script :-)=20

=20
--=20
Regards,
Klavs Klavsen

-------------| This mail has been sent to you by: |------------
              Klavs Klavsen - OpenSource Consultant=20
                 kl...@vs... - http://www.vsen.dk

    Get PGP key from www.keyserver.net - Key ID: 0x586D5BCA=20
Fingerprint =3D A95E B57B 3CE0 9131 9D15 94DA E1CD 641E 586D 5BCA
--------------------[ I believe that... ]-----------------------
It is a myth that people resist change. People resist what other
people make them do, not what they themselves choose to do...
That's why companies that innovate successfully year after year
seek their peopl's ideas, let them initiate new projects and
encourage more experiments.            -- Rosabeth Moss Kanter

Re: [SL] Installation prob. - Internal Server Error

[Julien L. <jul...@it...>]

Hi Klavs,

On Wed, Apr 03, 2002 at 09:28:56AM +0200, klavs klavsen wrote:
> I just installed sql-ledger too.. I found that the following add-on to
> the readme would have gotten me through the process:
> 
> If you just installed postgresql (as rpm only?) then do:
> 
> [snip technical details]

Postgresql was installed from the RPMs, I did the modifications you
mentionned (though it doesn't seem to make much difference, I was
already able to connect via tcp/ip (telnet localhost 5432)).

Unfortunately I still have the same Internal Server Error when trying to
login or click on "Create Dataset".

By the way, the versions currently installed are:
perl 5.6.0 (from rpms)
apache 1.3.17 (compiled with lots of extras ;)
postgresql 7.0.3 (from rpms)

Thanks again for the help, I'm still investigating the probleme on my
own in the meantime!

Regards,

Julien

Re: [SL] latex dilemma

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

Hi Keith.

Keith Mastin wrote:

> Thanks Dieter.
>
> I now have the radio button for latex showing. Next: whan I try to print an
> invoice, I get this:
>         Error!
>         latex : 1017868610.invoice.tex
> This occurs in either pdf or postscript, whether I send it to the printer or the
> screen. I did chown -R apache.apache /usr/local/sql-ledgers, so the permissions
> are correct within the program root directory. I take it this is a LaTex error?

I had this problem w/ dvipdfm installed (Debian system).  When I installed dvipdf
it worked.  Jonas posted something on March 22 that may be helpful.

Good luck.
Steve

>
>
> Thanks again for the pointer.
> BTW- sending clients emails of the invoices is sweet.
>
> Regards,
>
> Quoting Dieter Simader from [03/04/02 11:05 -0700]:
> > To enable latex you must set $latex = 1 in sql-ledger.conf.
> >
> --
> Keith Mastin         km...@be...
> BeechTree Information Technology Services Inc.
> 137 Laird Drive    M4G 3V5    Tel(416)696-6070
>            http://www.beechtree.ca

Re: [SL] latex dilemma

[Keith M. <km...@be...>]

Thanks Dieter.

I now have the radio button for latex showing. Next: whan I try to print an
invoice, I get this: 
	Error!
	latex : 1017868610.invoice.tex
This occurs in either pdf or postscript, whether I send it to the printer or the
screen. I did chown -R apache.apache /usr/local/sql-ledgers, so the permissions
are correct within the program root directory. I take it this is a LaTex error?

Thanks again for the pointer.
BTW- sending clients emails of the invoices is sweet. 

Regards,

Quoting Dieter Simader from [03/04/02 11:05 -0700]:
> To enable latex you must set $latex = 1 in sql-ledger.conf.
> 
-- 
Keith Mastin	     km...@be...
BeechTree Information Technology Services Inc.
137 Laird Drive    M4G 3V5    Tel(416)696-6070
	   http://www.beechtree.ca

Re: [SL] RedHat Linux 5.2

[Sergio A. K. <ser...@ho...>]

----- Original Message -----
From: "Kenneth Gonsalves" <la...@th...>


> i also have a server in 5.2 up for over three years, havent touched it
since
> setting it up. the problem of dependencies arises when continually
installing
> new software and upgrading the old

I have a machine that once upon a time it was a redhat 4.0,
then 4.2, then changue hardware, then 5.0, etc, etc
nowdays, the same machine is a redhat 7.1, upgrade over upgrade...

/sergio

Re: [SL] latex dilemma

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

To enable latex you must set $latex = 1 in sql-ledger.conf.


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

On Tue, 2 Apr 2002, Keith Mastin wrote:

> Hi,
> 
> I installed LaTex in hopes of getting invoices printed the way I want them to.
> I also blasted away my /usr/local/sql-ledger except for the users/kmastin.conf
> file and the sql-ledger.conf files (and the templates that I've customized) as I
> noted from the mailing list archives. I re-installed the sql-ledger program,
> mv'ed the saved files back to their original state and brought up the program in
> Opera.
> 
> Sql-Ledger Version 1.8.3
> Redhat 7.1
> 2.4.3-12 (stock Redhat) kernel
> tetex-latex-1.0.7-15
> 
> Is there something I have to do to initiate LaTex? I ran latex and was requested
> to type the name of my input file, so I *think* it's working.
> 
> If all that is running as expected, then I'm back to un-installing/re-installing?
> If so, can I keep my templates and user.conf and sql-ledger.conf file?
> 
> There is one line in Deiter's reply on the mailing list that I did not fully
> understand: "If you have modified sql-ledger.conf merge the changes from the
> default file rather than copying over top." I expect that does not apply to my
> case as I did not upgrade and am using a "virgin" version 1.8.3 install?
> 
> Thanks for any help.
> 

Re: [SL] RedHat Linux 5.2

[Omar B. <ob...@ya...>]

yes it is true the news software will need newer libs ... etc
At 11:27 =D5 03/04/02 +0530, Kenneth Gonsalves wrote:
>i also have a server in 5.2 up for over three years, havent touched it=
 since
>setting it up. the problem of dependencies arises when continually=
 installing
>new software and upgrading the old
>kg
>On Tuesday 02 April 2002 00:26, Omar BaheyEldin wrote:
> > I have redhat 5.2 installed on a server for about three years or more ,=
 and
> > this server does not even have a keyboard,
> > nobody have "touched" it for more than three years
> >
> > At 07:57 =D5 01/04/02 +0530, Kenneth Gonsalves wrote:
> > >this was a problem in rh 5.2 - have you heard similar reports on 6.2=
 and
> > > 7.2? kg
> > >
> > >On Sunday 31 March 2002 19:52, kevin bailey wrote:
> > > > hi omar,
> > > >
> > > > might be time to check out debian if you are going to reinstall - i
> > > > found that after RH has been installed for a year or so the
> > > > dependencies get mixed up and become so much of a mess that further=
 RPM
> > > > installation becomes impossible.
> >
> > _________________________________________________________
> > Do You Yahoo!?
> > Get your free @yahoo.com address at http://mail.yahoo.com


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

Re: [SL] problem: postgres IDENT

[Keld S. <ke...@dk...>]

Thanks, that solved the problem:-)

Keld

On Tue, Apr 02, 2002 at 03:39:29PM -0700, Dieter Simader wrote:
>=20
> change password protection from IDENT to PASSWORD in pg_hba.conf.
>=20
> If you don't use a password set to TRUST.
>=20
>=20
> Dieter Simader    http://www.sql-ledger.org   (780) 472-8161
> DWS Systems Inc.     Accounting Software       Fax: 478-5281
> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D On a clear disk you can seek forever =
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
>=20
> On Tue, 2 Apr 2002, Keld J=F8rn Simonsen wrote:
>=20
> > When I try to create a new database, or connect to an
> > existing one I get the follwing error message:
> > FATAL 1: IDENT authentication failed for user "postgres"
> >=20
> > I can see the dbs when running psql as postgres.
> > Could it be a firewall problem, or networking problem
> > or some passwd problem?
> >=20
> > This is just after moving from postgres 7.1 to 7.2=20
> > under Mandrake 8.2 and loading the databases.
> >=20
> > keld
> >=20
> >=20
>=20
>=20

Re: [SL] Installation prob. - Internal Server Error

[klavs k. <kl...@vs...>]

Hi Julien,

I just installed sql-ledger too.. I found that the following add-on to
the readme would have gotten me through the process:


If you just installed postgresql (as rpm only?) then do:

createuser sqlledger -W
> say yes to both questions and select a password.

edit /etc/rc.d/init.d/postgresql (RH/MDK specific)
so that the pg_ctl gets an extra option "-o -i" to tell postmaster
process to listen on standard tcp port 5432.

edit /var/lib/pgsql/data/pg_hba.conf and add line=20
> host       all         127.0.0.1     255.255.255.255     password
(this works if your httpd and postgresql are on the same server
otherwise put your webservers IP instead of 127.0.0.1)

I had done all the other stuff, mentioned in the readme.

After this, I could log in create a new dataset and a user for this
dataset and voila.

I hope it helps..
=20
--=20
Regards,
Klavs Klavsen

-------------| This mail has been sent to you by: |------------
              Klavs Klavsen - Open Source Consultant=20
                 kl...@vs... - http://www.vsen.dk

    Get PGP key from www.keyserver.net - Key ID: 0x586D5BCA=20
Fingerprint =3D A95E B57B 3CE0 9131 9D15 94DA E1CD 641E 586D 5BCA
--------------------[ I believe that... ]-----------------------
It is a myth that people resist change. People resist what other
people make them do, not what they themselves choose to do...
That's why companies that innovate successfully year after year
seek their peopl's ideas, let them initiate new projects and
encourage more experiments.            -- Rosabeth Moss Kanter

Re: [SL] RedHat Linux 5.2

[Kenneth G. <la...@th...>]

i also have a server in 5.2 up for over three years, havent touched it since 
setting it up. the problem of dependencies arises when continually installing 
new software and upgrading the old
kg
On Tuesday 02 April 2002 00:26, Omar BaheyEldin wrote:
> I have redhat 5.2 installed on a server for about three years or more , and
> this server does not even have a keyboard,
> nobody have "touched" it for more than three years
>
> At 07:57 Õ 01/04/02 +0530, Kenneth Gonsalves wrote:
> >this was a problem in rh 5.2 - have you heard similar reports on 6.2 and
> > 7.2? kg
> >
> >On Sunday 31 March 2002 19:52, kevin bailey wrote:
> > > hi omar,
> > >
> > > might be time to check out debian if you are going to reinstall - i
> > > found that after RH has been installed for a year or so the
> > > dependencies get mixed up and become so much of a mess that further RPM
> > > installation becomes impossible.
>
> _________________________________________________________
> Do You Yahoo!?
> Get your free @yahoo.com address at http://mail.yahoo.com

Re: [SL] Installation prob. - Internal Server Error

[Julien L. <jul...@it...>]

On Tue, Apr 02, 2002 at 03:42:13PM -0700, Dieter Simader wrote:
> You are condradicting yourself.
> 
> Does admin.pl run or not?

I'm sorry if I'm a bit unclear (english is not my usual language)...

I'll try to be more precise:

The script runs for this:

- getting the "login screen" (text inputs for username and password)
- entering a wrong username and/or password (normal error message)
- getting the "admin login screen" (password input)
- getting to the basic admin screen where you can add/remove users
- change admin password
- go to the "Pg Database Administration" screen

But if I:
- try to login as a valid user
- click on "Create Dataset" or "Delete Dataset" (with various user,
  password, etc. and also with and without database created in postgres)

I get an Internal Server Error:

Unknown error
Compilation failed in require at /usr/local/sql-ledger/admin.pl line 86.
[Tue Apr  2 12:19:44 2002] [error] [client 192.168.1.103] Premature end
of script headers: /usr/local/sql-ledger/admin.pl

So therefore I cannot "enter" into the application (as a user) and try
things out.

Thanks again for the help,

Julien Lajeunesse

Re: [SL] Installation prob. - Internal Server Error

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

Julien,

You are condradicting yourself.

Does admin.pl run or not?

The only other way to add a user to the members file is to add one with a 
text editor.

To start from scratch, delete all the files in the users directory. Then
load admin.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 Tue, 2 Apr 2002, Julien Lajeunesse wrote:

> Hi everybody,
> 
> sorry to bother you with such a basic question, but I can't seem to get
> SQL-Ledger working. I followed the steps outlined in the README file,
> but now all I can get is an internal server error (with Apache on Linux,
> everything compiled by ourselves and running well for over a year).
> 
> The exact error message in the error log is:
> 
> Unknown error
> Compilation failed in require at /usr/local/sql-ledger/admin.pl line 86.
> [Tue Apr  2 12:19:57 2002] [error] [client 192.168.1.103] Premature end
> of script headers: /usr/local/sql-ledger/admin.pl
> 
> when I try to configure the database or the same message with login.pl
> when I try to login with an existing user (I can add users).
> Permissions, etc. seem to be correct as far as I can tell, because
> everything runs up to this point.
> 
> I tried with Mozilla 0.9.9, Netscape 4.7x and Lynx too, because the
> error occurs on a "require" line. I printed the content of this require
> line and everything seems normal ("bin/mozilla/login.pl" for example,
> which exists and is readable).
> 
> Any help would be *greatly* appreciated since I cannot even begin to try
> out the software without this!
> 
> Thanks in advance,
> 
> Julien Lajeunesse
> 
> 
> 

Re: [SL] problem: postgres IDENT

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

change password protection from IDENT to PASSWORD in pg_hba.conf.

If you don't use a password set to TRUST.


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

On Tue, 2 Apr 2002, Keld J=F8rn Simonsen wrote:

> When I try to create a new database, or connect to an
> existing one I get the follwing error message:
> FATAL 1: IDENT authentication failed for user "postgres"
>=20
> I can see the dbs when running psql as postgres.
> Could it be a firewall problem, or networking problem
> or some passwd problem?
>=20
> This is just after moving from postgres 7.1 to 7.2=20
> under Mandrake 8.2 and loading the databases.
>=20
> keld
>=20
>=20