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