Menu
▾
▴
sql-ledger-users
|
From: Jim M. <jim...@wo...> - 2001-08-01 14:04:15
|
We are also looking at GNUe as a method for processing. Has there been any consideration to using the current sql-ledger backend to work within the GNUe forms frontend environment? This may support the ability to have multiple frontend types (browser , GTK, etc)? |
|
From: Roderick A. A. <raa...@ti...> - 2001-08-01 17:04:36
|
On Wed, 1 Aug 2001, Jim McLaughlin wrote:
> We are also looking at GNUe as a method for processing.
> Has there been any consideration to using the current sql-ledger backend to
> work within the GNUe forms frontend environment?
I was looking at GNUe as part of another project and thinking of
SQL-Ledger also. I have a few reservations about the GNUe forms
definition but haven't had the time to address them to the project.
> This may support the ability to have multiple frontend types (browser ,
> GTK, etc)?
Great idea.
Cheers,
Rod
--
Remove the word 'try' from your vocabulary ...
Don't try. Do it or don't do it ...
Steers try!
Don Aslett
|
|
From: Nicolas L. <nla...@pe...> - 2001-08-01 17:24:21
|
Is there a difference between DBD-Pg and DBD::Pg. I thought that they where the same. But if not, that's why i can't get the program working. Nick Lafferty |
|
From: Nicolas L. <nla...@pe...> - 2001-08-01 17:50:03
|
Well. I modified the "Content-length" variable in dnhttpd to "Content-Length" and got to the point where http://blah.com:8000/admin.pl works. But not the login.pl script. I try and it simply returns a blank screen. And i Still get the compilation error on line 65. I'm stumped. ----- Original Message ----- From: "Nicolas Lafferty" <nla...@pe...> To: <sql...@li...> Sent: Wednesday, August 01, 2001 1:16 PM Subject: DBD::Pg...what I need? > Is there a difference between DBD-Pg and DBD::Pg. I thought that they where > the same. But if not, that's why i can't get the program working. > > Nick Lafferty > > |
|
From: Thomas G. <to...@ad...> - 2001-08-01 18:02:16
|
On Wed, 1 Aug 2001, Nicolas Lafferty wrote:
> Is there a difference between DBD-Pg and DBD::Pg. I thought that they where
> the same. But if not, that's why i can't get the program working.
>
> Nick Lafferty
Hey Nick,
DBD::Pg looks like a fully qualified package::variable...
DBI is the toplevel perl module for database access, it is generic.
Into it you plug 'drivers' that are specific to the various SQL
implementations. So to run sql-ledger you'd need the DBI module
which is available from CPAN as: DBI-version_number.tar.gz
You'd also need DBD-Pg:
DBD-Pg is the driver used in accessing Pg from perl routines that
use a type of syntax similar to ESQL/C. Not to muddy the waters
but Edmund Mergl has two different modules to access Pg databases
and DBD-Pg is the one designed for DBI that has more familiar
syntax...at least more familiar to me! ;-)
DBD::Pg is a Package Name::variable so it does not refer to a
downloadable module. I expect you want a module that looks like:
DBD-Pg-0.95.tar.gz or something similar (newer version number perhaps).
Cheers,
Tom
--------------------------------------------------------------------
SVCMC - Center for Behavioral Health
--------------------------------------------------------------------
Thomas Good tomg@ { admin | q8 } .nrnet.org
Programmer/Analyst Phone: 718-354-5528
Residential Services Mobile: 917-282-7359
--------------------------------------------------------------------
/* Die Wahrheit Ist Irgendwo Da Draussen... */
--------------------------------------------------------------------
|
|
From: Nicolas L. <nla...@pe...> - 2001-08-01 19:09:18
|
Well. I have DBI installed. And Pg. Still no dice. See my just posted
Subject "Pg not the problem" on the list. Hrmph. This is driving me nuts.
----- Original Message -----
From: "Thomas Good" <to...@ad...>
To: <sql...@li...>
Sent: Wednesday, August 01, 2001 2:03 PM
Subject: Re: DBD::Pg...what I need?
> On Wed, 1 Aug 2001, Nicolas Lafferty wrote:
>
> > Is there a difference between DBD-Pg and DBD::Pg. I thought that they
where
> > the same. But if not, that's why i can't get the program working.
> >
> > Nick Lafferty
>
> Hey Nick,
>
> DBD::Pg looks like a fully qualified package::variable...
>
> DBI is the toplevel perl module for database access, it is generic.
> Into it you plug 'drivers' that are specific to the various SQL
> implementations. So to run sql-ledger you'd need the DBI module
> which is available from CPAN as: DBI-version_number.tar.gz
>
> You'd also need DBD-Pg:
> DBD-Pg is the driver used in accessing Pg from perl routines that
> use a type of syntax similar to ESQL/C. Not to muddy the waters
> but Edmund Mergl has two different modules to access Pg databases
> and DBD-Pg is the one designed for DBI that has more familiar
> syntax...at least more familiar to me! ;-)
>
> DBD::Pg is a Package Name::variable so it does not refer to a
> downloadable module. I expect you want a module that looks like:
> DBD-Pg-0.95.tar.gz or something similar (newer version number perhaps).
>
> Cheers,
> Tom
>
> --------------------------------------------------------------------
> SVCMC - Center for Behavioral Health
> --------------------------------------------------------------------
> Thomas Good tomg@ { admin | q8 } .nrnet.org
> Programmer/Analyst Phone: 718-354-5528
> Residential Services Mobile: 917-282-7359
> --------------------------------------------------------------------
> /* Die Wahrheit Ist Irgendwo Da Draussen... */
> --------------------------------------------------------------------
>
>
>
|
|
From: Oscar B. <os...@el...> - 2001-08-01 19:36:52
|
Nicolas,
Your issues remind me of those that I had installing SQL-ledger.
You may want to consider looking for my name (oscar buijten) in the history
of posts.
I have published all problems and solutions I found.
Good luck!
PS: be carefull with your nuts...
----- Message d'origine -----
De : "Nicolas Lafferty" <nla...@pe...>
À : <sql...@li...>
Envoyé : mercredi 1 août 2001 20:58
Objet : Re: DBD::Pg...what I need?
> Well. I have DBI installed. And Pg. Still no dice. See my just posted
> Subject "Pg not the problem" on the list. Hrmph. This is driving me nuts.
>
>
> ----- Original Message -----
> From: "Thomas Good" <to...@ad...>
> To: <sql...@li...>
> Sent: Wednesday, August 01, 2001 2:03 PM
> Subject: Re: DBD::Pg...what I need?
>
>
> > On Wed, 1 Aug 2001, Nicolas Lafferty wrote:
> >
> > > Is there a difference between DBD-Pg and DBD::Pg. I thought that they
> where
> > > the same. But if not, that's why i can't get the program working.
> > >
> > > Nick Lafferty
> >
> > Hey Nick,
> >
> > DBD::Pg looks like a fully qualified package::variable...
> >
> > DBI is the toplevel perl module for database access, it is generic.
> > Into it you plug 'drivers' that are specific to the various SQL
> > implementations. So to run sql-ledger you'd need the DBI module
> > which is available from CPAN as: DBI-version_number.tar.gz
> >
> > You'd also need DBD-Pg:
> > DBD-Pg is the driver used in accessing Pg from perl routines that
> > use a type of syntax similar to ESQL/C. Not to muddy the waters
> > but Edmund Mergl has two different modules to access Pg databases
> > and DBD-Pg is the one designed for DBI that has more familiar
> > syntax...at least more familiar to me! ;-)
> >
> > DBD::Pg is a Package Name::variable so it does not refer to a
> > downloadable module. I expect you want a module that looks like:
> > DBD-Pg-0.95.tar.gz or something similar (newer version number perhaps).
> >
> > Cheers,
> > Tom
> >
> > --------------------------------------------------------------------
> > SVCMC - Center for Behavioral Health
> > --------------------------------------------------------------------
> > Thomas Good tomg@ { admin | q8 } .nrnet.org
> > Programmer/Analyst Phone: 718-354-5528
> > Residential Services Mobile: 917-282-7359
> > --------------------------------------------------------------------
> > /* Die Wahrheit Ist Irgendwo Da Draussen... */
> > --------------------------------------------------------------------
> >
> >
> >
>
|
|
From: <ro...@su...> - 2001-08-01 19:44:05
|
> Well. I have DBI installed. And Pg. Still no dice. See my just posted > Subject "Pg not the problem" on the list. Hrmph. This is driving me > nuts. Did you upgrade PostgreSQL? If so you may also need to rebuild DBD-Pg. -- Rod http://www.sunsetsystems.com/ |
|
From: Thomas G. <to...@ad...> - 2001-08-01 19:59:48
|
On Wed, 1 Aug 2001, Nicolas Lafferty wrote:
> Well. I have DBI installed. And Pg. Still no dice. See my just posted
> Subject "Pg not the problem" on the list. Hrmph. This is driving me nuts.
So, I'm unclear. Can you connect to Pg using DBI at all?
If not sure save the following as test.pl, make executable (chmod 755 test.pl)
and run it from the shell prompt: ./test.pl
#!/usr/bin/perl
use DBI;
$dbh = DBI->connect("dbi:Pg:dbname=template1", '', '') || die "$DBI::errstr";
$query = qq |select usename from pg_user|;
$sth=$dbh->prepare($query);
$sth->execute || die "$DBI::errstr";
@row=$sth->fetchrow_array;
$sth->finish;
$dbh->disconnect;
print "\n@row\n\n";
|
|
From: Nicolas L. <nla...@pe...> - 2001-08-01 22:03:16
|
Well. I ran the nifty lil script. I gave me the feedback "posgres" Does that
mean that it's working fine?
----- Original Message -----
From: "Thomas Good" <to...@ad...>
To: <sql...@li...>
Sent: Wednesday, August 01, 2001 4:02 PM
Subject: Re: DBD::Pg...what I need?
> On Wed, 1 Aug 2001, Nicolas Lafferty wrote:
>
> > Well. I have DBI installed. And Pg. Still no dice. See my just posted
> > Subject "Pg not the problem" on the list. Hrmph. This is driving me
nuts.
>
> So, I'm unclear. Can you connect to Pg using DBI at all?
> If not sure save the following as test.pl, make executable (chmod 755
test.pl)
> and run it from the shell prompt: ./test.pl
>
> #!/usr/bin/perl
> use DBI;
>
> $dbh = DBI->connect("dbi:Pg:dbname=template1", '', '') || die
"$DBI::errstr";
> $query = qq |select usename from pg_user|;
> $sth=$dbh->prepare($query);
> $sth->execute || die "$DBI::errstr";
> @row=$sth->fetchrow_array;
> $sth->finish;
> $dbh->disconnect;
>
> print "\n@row\n\n";
>
>
>
|
|
From: Thomas G. <to...@ad...> - 2001-08-02 11:51:37
|
On Wed, 1 Aug 2001, Nicolas Lafferty wrote:
> Well. I ran the nifty lil script. I gave me the feedback "posgres" Does that
> mean that it's working fine?
Roger that! So that means that the problem lies in the web server
itself - most likely.
If you run this from a shell prompt:
psql -c "\d" DBNAME
where DBNAME is the name of the database into which you installed
sql ledger, you will see table names like: ar ap tax
and so on. If these tables are present then we have ruled out
Pg and Perl DBI being the problem and we zoom in on the web server.
> ----- Original Message -----
> From: "Thomas Good" <to...@ad...>
> To: <sql...@li...>
> Sent: Wednesday, August 01, 2001 4:02 PM
> Subject: Re: DBD::Pg...what I need?
>
>
> > On Wed, 1 Aug 2001, Nicolas Lafferty wrote:
> >
> > > Well. I have DBI installed. And Pg. Still no dice. See my just posted
> > > Subject "Pg not the problem" on the list. Hrmph. This is driving me
> nuts.
> >
> > So, I'm unclear. Can you connect to Pg using DBI at all?
> > If not sure save the following as test.pl, make executable (chmod 755
> test.pl)
> > and run it from the shell prompt: ./test.pl
> >
> > #!/usr/bin/perl
> > use DBI;
> >
> > $dbh = DBI->connect("dbi:Pg:dbname=template1", '', '') || die
> "$DBI::errstr";
> > $query = qq |select usename from pg_user|;
> > $sth=$dbh->prepare($query);
> > $sth->execute || die "$DBI::errstr";
> > @row=$sth->fetchrow_array;
> > $sth->finish;
> > $dbh->disconnect;
> >
> > print "\n@row\n\n";
> >
> >
> >
>
>
--------------------------------------------------------------------
SVCMC - Center for Behavioral Health
--------------------------------------------------------------------
Thomas Good tomg@ { admin | q8 } .nrnet.org
Programmer/Analyst Phone: 718-354-5528
Residential Services Mobile: 917-282-7359
--------------------------------------------------------------------
/* Die Wahrheit Ist Irgendwo Da Draussen... */
--------------------------------------------------------------------
|
|
From: Nicolas L. <nla...@pe...> - 2001-08-02 19:54:27
|
Yep, All the tables are in place. I'm using the included. dnhttpd server in
my home directory.
----- Original Message -----
From: "Thomas Good" <to...@ad...>
To: <sql...@li...>
Sent: Thursday, August 02, 2001 7:54 AM
Subject: Re: DBD::Pg...what I need?
> On Wed, 1 Aug 2001, Nicolas Lafferty wrote:
>
> > Well. I ran the nifty lil script. I gave me the feedback "posgres" Does
that
> > mean that it's working fine?
>
> Roger that! So that means that the problem lies in the web server
> itself - most likely.
>
> If you run this from a shell prompt:
>
> psql -c "\d" DBNAME
>
> where DBNAME is the name of the database into which you installed
> sql ledger, you will see table names like: ar ap tax
> and so on. If these tables are present then we have ruled out
> Pg and Perl DBI being the problem and we zoom in on the web server.
>
> > ----- Original Message -----
> > From: "Thomas Good" <to...@ad...>
> > To: <sql...@li...>
> > Sent: Wednesday, August 01, 2001 4:02 PM
> > Subject: Re: DBD::Pg...what I need?
> >
> >
> > > On Wed, 1 Aug 2001, Nicolas Lafferty wrote:
> > >
> > > > Well. I have DBI installed. And Pg. Still no dice. See my just
posted
> > > > Subject "Pg not the problem" on the list. Hrmph. This is driving me
> > nuts.
> > >
> > > So, I'm unclear. Can you connect to Pg using DBI at all?
> > > If not sure save the following as test.pl, make executable (chmod 755
> > test.pl)
> > > and run it from the shell prompt: ./test.pl
> > >
> > > #!/usr/bin/perl
> > > use DBI;
> > >
> > > $dbh = DBI->connect("dbi:Pg:dbname=template1", '', '') || die
> > "$DBI::errstr";
> > > $query = qq |select usename from pg_user|;
> > > $sth=$dbh->prepare($query);
> > > $sth->execute || die "$DBI::errstr";
> > > @row=$sth->fetchrow_array;
> > > $sth->finish;
> > > $dbh->disconnect;
> > >
> > > print "\n@row\n\n";
> > >
> > >
> > >
> >
> >
>
>
> --------------------------------------------------------------------
> SVCMC - Center for Behavioral Health
> --------------------------------------------------------------------
> Thomas Good tomg@ { admin | q8 } .nrnet.org
> Programmer/Analyst Phone: 718-354-5528
> Residential Services Mobile: 917-282-7359
> --------------------------------------------------------------------
> /* Die Wahrheit Ist Irgendwo Da Draussen... */
> --------------------------------------------------------------------
>
>
|
|
From: Thomas G. <to...@ad...> - 2001-08-02 20:57:31
|
On Thu, 2 Aug 2001, Nicolas Lafferty wrote:
> Yep, All the tables are in place. I'm using the included. dnhttpd server in
> my home directory.
Ok, I've never used this as I run apache. So I'll have a look.
Give me some time, I'll have to stick it on a test box and fire it
up. I'll get back to ya.
--------------------------------------------------------------------
SVCMC - Center for Behavioral Health
--------------------------------------------------------------------
Thomas Good tomg@ { admin | q8 } .nrnet.org
Programmer/Analyst Phone: 718-354-5528
Residential Services Mobile: 917-282-7359
--------------------------------------------------------------------
/* Die Wahrheit Ist Irgendwo Da Draussen... */
--------------------------------------------------------------------
|
|
From: Nicolas L. <nla...@pe...> - 2001-08-06 14:23:25
|
Sounds good. Thanks. I'll be watching the list for a post from you then
Thanks,
Nick
----- Original Message -----
From: "Thomas Good" <to...@ad...>
To: <sql...@li...>
Sent: Thursday, August 02, 2001 5:00 PM
Subject: Re: DBD::Pg...what I need?
> On Thu, 2 Aug 2001, Nicolas Lafferty wrote:
>
> > Yep, All the tables are in place. I'm using the included. dnhttpd server
in
> > my home directory.
>
> Ok, I've never used this as I run apache. So I'll have a look.
> Give me some time, I'll have to stick it on a test box and fire it
> up. I'll get back to ya.
>
> --------------------------------------------------------------------
> SVCMC - Center for Behavioral Health
> --------------------------------------------------------------------
> Thomas Good tomg@ { admin | q8 } .nrnet.org
> Programmer/Analyst Phone: 718-354-5528
> Residential Services Mobile: 917-282-7359
> --------------------------------------------------------------------
> /* Die Wahrheit Ist Irgendwo Da Draussen... */
> --------------------------------------------------------------------
>
>
|
|
From: Thomas G. <to...@ad...> - 2001-08-06 18:53:09
|
On Mon, 6 Aug 2001, Nicolas Lafferty wrote:
> Sounds good. Thanks. I'll be watching the list for a post from you then
>
> Thanks,
>
> Nick
Nick -
As you noted, admin.pl works fine and I created an account for myself.
However, when I try to login in Netscape there is no stderr offered and
the connection never happens...
The story is different, in lynx. Here is the stderror I get:
Odd number of elements in hash list at ./fileio.pl line 142 <FD> chunk 12.
I also get this:
Processing request from 127.0.0.1:23672
But the process never finishes. In fact, dnhttpd spawns a legion of
zombie processes. Is this what you experienced?
If so, we should report the problem to Dieter.
I'll look at the scripts and see if there is a quick fix in the interim.
Tom
> ----- Original Message -----
> From: "Thomas Good" <to...@ad...>
> To: <sql...@li...>
> Sent: Thursday, August 02, 2001 5:00 PM
> Subject: Re: DBD::Pg...what I need?
>
>
> > On Thu, 2 Aug 2001, Nicolas Lafferty wrote:
> >
> > > Yep, All the tables are in place. I'm using the included. dnhttpd server
> in
> > > my home directory.
> >
> > Ok, I've never used this as I run apache. So I'll have a look.
> > Give me some time, I'll have to stick it on a test box and fire it
> > up. I'll get back to ya.
> >
> > --------------------------------------------------------------------
> > SVCMC - Center for Behavioral Health
> > --------------------------------------------------------------------
> > Thomas Good tomg@ { admin | q8 } .nrnet.org
> > Programmer/Analyst Phone: 718-354-5528
> > Residential Services Mobile: 917-282-7359
> > --------------------------------------------------------------------
> > /* Die Wahrheit Ist Irgendwo Da Draussen... */
> > --------------------------------------------------------------------
> >
> >
>
>
--------------------------------------------------------------------
SVCMC - Center for Behavioral Health
--------------------------------------------------------------------
Thomas Good tomg@ { admin | q8 } .nrnet.org
Programmer/Analyst Phone: 718-354-5528
Residential Services Mobile: 917-282-7359
--------------------------------------------------------------------
/* Die Wahrheit Ist Irgendwo Da Draussen... */
--------------------------------------------------------------------
|
|
From: Nicolas L. <nla...@pe...> - 2001-08-07 15:00:55
|
The Zombie processes is exactly what happens. You seem to know a little more
about describing this problem than I. Could you let Dieter know of this
problem?
Thanks,
Nick
----- Original Message -----
From: "Thomas Good" <to...@ad...>
To: <sql...@li...>
Sent: Monday, August 06, 2001 2:55 PM
Subject: Re: DBD::Pg...what I need?
> On Mon, 6 Aug 2001, Nicolas Lafferty wrote:
>
> > Sounds good. Thanks. I'll be watching the list for a post from you then
> >
> > Thanks,
> >
> > Nick
>
> Nick -
>
> As you noted, admin.pl works fine and I created an account for myself.
> However, when I try to login in Netscape there is no stderr offered and
> the connection never happens...
>
> The story is different, in lynx. Here is the stderror I get:
> Odd number of elements in hash list at ./fileio.pl line 142 <FD> chunk 12.
>
> I also get this:
> Processing request from 127.0.0.1:23672
>
> But the process never finishes. In fact, dnhttpd spawns a legion of
> zombie processes. Is this what you experienced?
>
> If so, we should report the problem to Dieter.
> I'll look at the scripts and see if there is a quick fix in the interim.
>
> Tom
>
> > ----- Original Message -----
> > From: "Thomas Good" <to...@ad...>
> > To: <sql...@li...>
> > Sent: Thursday, August 02, 2001 5:00 PM
> > Subject: Re: DBD::Pg...what I need?
> >
> >
> > > On Thu, 2 Aug 2001, Nicolas Lafferty wrote:
> > >
> > > > Yep, All the tables are in place. I'm using the included. dnhttpd
server
> > in
> > > > my home directory.
> > >
> > > Ok, I've never used this as I run apache. So I'll have a look.
> > > Give me some time, I'll have to stick it on a test box and fire it
> > > up. I'll get back to ya.
> > >
> > > --------------------------------------------------------------------
> > > SVCMC - Center for Behavioral Health
> > > --------------------------------------------------------------------
> > > Thomas Good tomg@ { admin | q8 } .nrnet.org
> > > Programmer/Analyst Phone: 718-354-5528
> > > Residential Services Mobile: 917-282-7359
> > > --------------------------------------------------------------------
> > > /* Die Wahrheit Ist Irgendwo Da Draussen... */
> > > --------------------------------------------------------------------
> > >
> > >
> >
> >
>
>
> --------------------------------------------------------------------
> SVCMC - Center for Behavioral Health
> --------------------------------------------------------------------
> Thomas Good tomg@ { admin | q8 } .nrnet.org
> Programmer/Analyst Phone: 718-354-5528
> Residential Services Mobile: 917-282-7359
> --------------------------------------------------------------------
> /* Die Wahrheit Ist Irgendwo Da Draussen... */
> --------------------------------------------------------------------
>
>
|
|
From: Thomas G. <to...@ad...> - 2001-08-08 12:28:09
|
On Tue, 7 Aug 2001, Nicolas Lafferty wrote:
> The Zombie processes is exactly what happens. You seem to know a little more
> about describing this problem than I. Could you let Dieter know of this
> problem?
>
> Thanks,
> Nick
Hey Nick - Sorry for the delays...Dieter and I are working overtime
on an oracle port of sql-ledger and I am swamped to begin with...but:
I think you and I have this licked. Did you see my second post?
If you send me your nick.config (mainly the fields you completed in
admin.pl) I think we can get you going today. I can also send my
conf files and hacked version of dnhttpd.pl to get you going if need be.
BTW, please send output of 'perl -v' too...this problem appears specific
to which perl version one is running. I had problems with 5.004 but
5.6.1 ran fine. (Incidentally, there isn't that big of a disparity btwn
versions, they changed the version string at 5.006 just to keep things
interesting. ;-)
Cheers,
Tom
--------------------------------------------------------------------
SVCMC - Center for Behavioral Health
--------------------------------------------------------------------
Thomas Good tomg@ { admin | q8 } .nrnet.org
Programmer/Analyst Phone: 718-354-5528
Residential Services Mobile: 917-282-7359
--------------------------------------------------------------------
/* Die Wahrheit Ist Irgendwo Da Draussen... */
--------------------------------------------------------------------
|
|
From: Nicolas L. <nla...@pe...> - 2001-08-08 14:27:07
|
##### BEGIN PERL-V OUTPUT ####### [nick@storm nick]$ perl -v This is perl, v5.6.0 built for i386-linux Copyright 1987-2000, Larry Wall Perl may be copied only under the terms of either the Artistic License or the GNU General Public License, which may be found in the Perl 5.0 source kit. Complete documentation for Perl, including FAQ lists, should be found on this system using `man perl' or `perldoc perl'. If you have access to the Internet, point your browser at http://www.perl.com/, the Perl Home Page. [nick@storm nick]$ #### END PERL -V OUTPUT ####### ####### nick.config ######## # configuration file for nick %myconfig = ( address => '1 Barnard Street\nFrostburg, MD 21532', admin => '', company => 'Mindset Ventures, Inc.', countrycode => '', dateformat => '', dbconnect => 'dbi:Pg:dbname=nick;host=localhost;port=5432', dbdriver => 'Pg', dbhost => 'localhost', dbname => 'nick', dboptions => '', dbpasswd => '\'87)T-&%L;```', dbport => '5432', dbtty => '', dbuser => 'nick', email => 'ni...@mi...', fax => '', name => 'Nick Lafferty', password => 'nirg6ha6I/5GA', printer => '', shippingpoint => '', signature => '', tel => '', templates => 'templates/nick', ); ########end ----- Original Message ----- From: "Thomas Good" <to...@ad...> To: "Nicolas Lafferty" <nla...@pe...> Cc: <sql...@li...> Sent: Wednesday, August 08, 2001 8:31 AM Subject: Re: DBD::Pg...what I need? > On Tue, 7 Aug 2001, Nicolas Lafferty wrote: > > > The Zombie processes is exactly what happens. You seem to know a little more > > about describing this problem than I. Could you let Dieter know of this > > problem? > > > > Thanks, > > Nick > > Hey Nick - Sorry for the delays...Dieter and I are working overtime > on an oracle port of sql-ledger and I am swamped to begin with...but: > I think you and I have this licked. Did you see my second post? > If you send me your nick.config (mainly the fields you completed in > admin.pl) I think we can get you going today. I can also send my > conf files and hacked version of dnhttpd.pl to get you going if need be. > > BTW, please send output of 'perl -v' too...this problem appears specific > to which perl version one is running. I had problems with 5.004 but > 5.6.1 ran fine. (Incidentally, there isn't that big of a disparity btwn > versions, they changed the version string at 5.006 just to keep things > interesting. ;-) > > Cheers, > Tom > > -------------------------------------------------------------------- > SVCMC - Center for Behavioral Health > -------------------------------------------------------------------- > Thomas Good tomg@ { admin | q8 } .nrnet.org > Programmer/Analyst Phone: 718-354-5528 > Residential Services Mobile: 917-282-7359 > -------------------------------------------------------------------- > /* Die Wahrheit Ist Irgendwo Da Draussen... */ > -------------------------------------------------------------------- > > |
|
From: Thomas G. <to...@ad...> - 2001-08-08 15:26:04
|
On Wed, 8 Aug 2001, Nicolas Lafferty wrote:
> This is perl, v5.6.0 built for i386-linux
Right, so this looks good. As you're using redhat (I'd guess 7.0 or
7.1?) going by the shell prompt, I installed sql-ledger on a redhat 6.1
box. dnhttpd ran no problem. So I looked at your conf file for ledger
and this is what stuck out:
> dbpasswd => '\'87)T-&%L;```',
> dbport => '5432',
> dbtty => '',
> dbuser => 'nick',
If you don't need to authenticate yourself with Postgres (the
default is no) I would try zeroing out these two strings in nick.config.
> dbpasswd => '',
...
...
> dbuser => '',
run this in char mode on tty1 or in an xterm:
./dnhttpd.pl
This way you can see the stderr...and send me any complaints
from the server.
If you have lynx installed on your RH box ---
Flip to another terminal or start another xterm and run this:
lynx http://localhost:8000/login.pl
Else, use netscape to dial up this address.
(Then flip back to the xterm to see any stderr it spews out.)
Let's hope this minor hack to nick.config turns the key...
Good luck!
--------------------------------------------------------------------
SVCMC - Center for Behavioral Health
--------------------------------------------------------------------
Thomas Good tomg@ { admin | q8 } .nrnet.org
Programmer/Analyst Phone: 718-354-5528
Residential Services Mobile: 917-282-7359
--------------------------------------------------------------------
/* Die Wahrheit Ist Irgendwo Da Draussen... */
--------------------------------------------------------------------
|
|
From: Nicolas L. <nla...@pe...> - 2001-08-08 17:39:52
|
What if authentication is required by postgres?
----- Original Message -----
From: "Thomas Good" <to...@ad...>
To: <sql...@li...>
Cc: "Nicolas Lafferty" <nla...@pe...>
Sent: Wednesday, August 08, 2001 11:29 AM
Subject: Re: DBD::Pg...what I need?
> On Wed, 8 Aug 2001, Nicolas Lafferty wrote:
>
> > This is perl, v5.6.0 built for i386-linux
>
> Right, so this looks good. As you're using redhat (I'd guess 7.0 or
> 7.1?) going by the shell prompt, I installed sql-ledger on a redhat 6.1
> box. dnhttpd ran no problem. So I looked at your conf file for ledger
> and this is what stuck out:
>
> > dbpasswd => '\'87)T-&%L;```',
> > dbport => '5432',
> > dbtty => '',
> > dbuser => 'nick',
>
> If you don't need to authenticate yourself with Postgres (the
> default is no) I would try zeroing out these two strings in nick.config.
>
> > dbpasswd => '',
> ...
> ...
> > dbuser => '',
>
> run this in char mode on tty1 or in an xterm:
> ./dnhttpd.pl
>
> This way you can see the stderr...and send me any complaints
> from the server.
>
> If you have lynx installed on your RH box ---
> Flip to another terminal or start another xterm and run this:
> lynx http://localhost:8000/login.pl
>
> Else, use netscape to dial up this address.
> (Then flip back to the xterm to see any stderr it spews out.)
>
> Let's hope this minor hack to nick.config turns the key...
> Good luck!
>
> --------------------------------------------------------------------
> SVCMC - Center for Behavioral Health
> --------------------------------------------------------------------
> Thomas Good tomg@ { admin | q8 } .nrnet.org
> Programmer/Analyst Phone: 718-354-5528
> Residential Services Mobile: 917-282-7359
> --------------------------------------------------------------------
> /* Die Wahrheit Ist Irgendwo Da Draussen... */
> --------------------------------------------------------------------
>
>
>
|
|
From: Thomas G. <to...@ad...> - 2001-08-08 18:00:33
|
On Wed, 8 Aug 2001, Nicolas Lafferty wrote:
> What if authentication is required by postgres?
Is Pg using host based authentication? Postgres doesn't require
authentication out of the box, even on redhat where install is
done using canned RPMs. So if you have it turned on we can
temporarily turn it off and see if this is the snag.
In your data directory (/var/lib/pgsql on redhat) look at your
pg_hba.conf file. If the only uncommented lines are the last
two then you don't need pg's host based user authentication.
(See man pg_passwd for more info on hba)
BTW, what web browser are you using? Let's see if you can trap any
error messages. I'm basically working blind...it would help if we
got one of the players to complain a little bit.
check out /var/lib/pgsql/pg_hba.conf and if it is not using
hba, edit your users/nick.config:
You can use admin.pl to do the same thing, if you prefer.
> > > dbpasswd => '\'87)T-&%L;```', #### remove btwn ''
> > > dbport => '5432',
> > > dbtty => '',
> > > dbuser => 'nick', #### same here
--------------------------------------------------------------------
SVCMC - Center for Behavioral Health
--------------------------------------------------------------------
Thomas Good tomg@ { admin | q8 } .nrnet.org
Programmer/Analyst Phone: 718-354-5528
Residential Services Mobile: 917-282-7359
--------------------------------------------------------------------
/* Die Wahrheit Ist Irgendwo Da Draussen... */
--------------------------------------------------------------------
|
|
From: Thomas G. <to...@ad...> - 2001-08-06 20:02:01
|
On Mon, 6 Aug 2001, Nicolas Lafferty wrote:
> Sounds good. Thanks. I'll be watching the list for a post from you then
>
> Thanks,
>
> Nick
Ok Nick, got this going on two boxes. On the newer box (linux kernel
2.2.19) running Perl 5.6.1 I get no complaints at all and can access
the program both locally and remotely (http://999.999.999.999:8000)
On the older box I had to comment out a couple of calls to sub routines
that had syntax perl 5.004_03 found objectionable. Once I did this
it started without complaint and ran fine.
Basically this guy (Doug Neal) is using syntax like:
print $FH " blah " foreach (keys %hash);
and my old version of perl barfs on this.
The other problem might be your config settings in nick.config.
This file creates the connect string to access Pg and if there are
any values that don't work for Pg we are out of luck.
Send me your output from 'perl -v' and the nick.config file from
sql-ledger/users. We should have you on the road pretty quick.
--------------------------------------------------------------------
SVCMC - Center for Behavioral Health
--------------------------------------------------------------------
Thomas Good tomg@ { admin | q8 } .nrnet.org
Programmer/Analyst Phone: 718-354-5528
Residential Services Mobile: 917-282-7359
--------------------------------------------------------------------
/* Die Wahrheit Ist Irgendwo Da Draussen... */
--------------------------------------------------------------------
|
Thanks for helping keep SourceForge clean.
X