[SL] Re: database administration failed

  • From: "Alejandro Imass" <ait@xxxxxxxxxxxxx>
  • To: sql-ledger-users@xxxxxxxxxxxxxx
  • Date: Wed, 02 Apr 2003 22:12:44 +0800


You just have to install DBI and the DBD-PG driver.

Username, password, etc. are passed automatically by SL scripts.

When postgres is installed by default is does not authenticate users. You have 
to configure Postgres for this with pg_hba.conf file.




----- Original Message -----
From: "Abrar Hussain Hazarika" <abrar@xxxxxxxxxxxxxxx>
Date: Wed, 02 Apr 2003 11:53:50 +0530 (IST)
To: sql-ledger-users@xxxxxxxxxxxxxx
Subject: [SL] Re: database administration failed

I installed DBI and DBD-PgPP via ppm and i have seen only DBD-PgPP but no 
DBD-Pg in the repository. 


I think I have missed here.


I have created user sql-ledger with password xxxx for postgresql. where do i 
have to put the dbname,dbuser and dbpasswd in DBI / DBD? If so what will be 
the dbname?










Dieter Simader wrote:


>


>


>The PgPP driver is not enabled, use DBD-Pg instead.


>


>


>Dieter Simader    http://www.sql-ledger.com   (780) 472-8161


>DWS Systems Inc.     Accounting Software       Fax: 478-5281


>============ On a clear disk you can seek forever ==========


>


>On Tue, 1 Apr 2003, Abrar Hussain Hazarika wrote:


>


>> hi all,


>>


>> i installed sql-ledger on my win2000 server machine and started postgresql


>> created a user database sql-ledger, changed the shebang line and pointed 
my


>> browser to admin.pl


>>


>> The page comes allright and I went to next page with buttons add user,


>> change admin passwd and PgPP Database administration. Added a new user, 
able


>> to change admin password also but clicking DB administration leads to


>> internal server error.


>>


>> The server logs are


>>


>> [Mon Apr 14 18:34:26 2003] [error] [client 127.0.0.1] Premature end of


>> script headers: admin.pl, referer: http://localhost:8080/ledger/admin.pl


>>


>> [Mon Apr 14 18:34:26 2003] [error] [client 127.0.0.1] Undefined subroutine


>> &main::pgpp_database_administration called at bin/mozilla/admin.pl line 
67.,


>> referer: http://localhost:8080/ledger/admin.pl


>>


>> [Mon Apr 14 18:34:26 2003] [error] [client 127.0.0.1] Compilation failed 
in


>> require at D:/sql-ledger/sql-ledger/admin.pl line 91., referer:


>> http://localhost:8080/ledger/admin.pl


>>


>>


>> I didn't understand the second entry also dates are wrong but could this 
be


>> a problem. By going thru the first error Premature end of script header 
the


>> page admin.pl should not have come at all.


>>


>> I am at loss. any help will be appreciated.


>>


>>


>>


>


>


>


>





-- 
______________________________________________
http://www.linuxmail.org/
Now with e-mail forwarding for only US$5.95/yr

Powered by Outblaze

Other related posts: