Debugging code which deploys DBI: no logfile, no trace. What's a cause?

2005-11-23 Thread Plymouth Rock
http://perl.apache.org/docs/1.0/guide/databases.html#Debugging_code_which_de ploys_DBI PerlSetEnv DBI_TRACE "3=/tmp/dbitrace.log" PerlModule Apache::DBI I tried mod_perl scripts accessed to DB and SELECTed some data. But logfile still doesn't appear. The order and placement the directives ar

Re: connection to PostgreSQL DataBase with Apache::DBI

2005-11-21 Thread Plymouth Rock
> > I tried to set PerlSetEnv/PerlPassEnv variables as described in the guide. > > It was difficult for me to do it properly as I did it for the first time. I > > even could set them incorrectly. Besides that, my mod_perl2 was installed > > and set up properly (it works excellently); but saying abo

Re: Connection to PostgreSQL DataBase with Apache::DBI

2005-11-20 Thread Plymouth Rock
1. You're right, there's no any error if the string is removed. If it's present in startup.pl, then there is no matter if it has any incorrect record or not - Apache won't start up or restart anyway. I can write any blah like: Apache::DBI->connect_on_init("BI:PgPP:mypgdb:localhost:5432","X

Re: Connection to PostgreSQL DataBase with Apache::DBI

2005-11-20 Thread Plymouth Rock
> > Anybody who uses current major versions of pre-built binaries of the: > > > > Apache2 + mod_perl2 + Apache::DBI + PostgreSQL8 > > When asking for help, please be specific about what you're using. > There's a description of what to send here: > http://perl.apache.org/docs/2.0/user/help/help.htm

Re: connection to PostgreSQL DataBase with Apache::DBI

2005-11-20 Thread Plymouth Rock
I tried to set PerlSetEnv/PerlPassEnv variables as described in the guide. It was difficult for me to do it properly as I did it for the first time. I even could set them incorrectly. Besides that, my mod_perl2 was installed and set up properly (it works excellently); but saying about Apache::DBI

Connection to PostgreSQL DataBase with Apache::DBI

2005-11-17 Thread Plymouth Rock
Anybody who uses current major versions of pre-built binaries of the: Apache2 + mod_perl2 + Apache::DBI + PostgreSQL8 and knows how to do "Preopening DBI connections" upon server's start up (not only using a persistent database connection at Perl-script's runnings after server has been already s

connection to PostgreSQL DataBase with Apache::DBI

2005-11-11 Thread Plymouth Rock
Hello. Before Apache::DBI installation I'd using just DBI & PgPP for connecting with my PostgreSQL DataBase: $user = "owner"; $password = "pwd"; $data_source = "dbi:PgPP:mypgdb;localhost;5432"; $dbh = DBI->connect($data_source, $user, $password); $sth = $dbh->prepare( q{ SELECT ... FROM ... });

2. ActivePerl vs mod_perl: unable to open a file

2005-11-08 Thread Plymouth Rock
At using ActivePerl5.8.7 there isn't the problem with file opening, but at using mod_perl2.0.2 it is: print "Content-type: text/html\n\n"; $path = "textdata.txt"; open FH, $path; while() {print} close FH Why and how to solve the problem? Thanx.

1. ActivePerl vs mod_perl: different results (how to clear the variables before restarts?)

2005-11-08 Thread Plymouth Rock
There is the problem: first running time my script gives correct results on mod_perl2.0.2 (Win32, Apache2.0.54, IE6), but after any next restart (F5 in browser) the variables do not clear: print "Content-type: text/html\n\n"; print $char.="*","\n".++$counter unless I restart my Apache webserver

Re: win32, mod_perl/2.0.1, Apache/2.0.54 - ithreads problem

2005-08-04 Thread Plymouth Rock
> Could you post a complete (but minimal) script that > illustrates the problem you're encountering? From what > you wrote above, I tried this Registry script: > Here is a simplest ithread-based perl-script I'd testing. At first, run it just with Perl (or, it's desirable, on win32-platform with A

win32, mod_perl/2.0.1, Apache/2.0.54 - ithreads problem

2005-08-02 Thread Plymouth Rock
I'd using ithreads on ActivePerl 5.8.7 and Apache/2.0.54 (Win32). All scripts with ithreads did working excellent. Since I've installed mod_perl/2.0.1 with 'ppm install', those scripts have ceased to work (there's an initial HTML-table's dumping only). Due to I couldn't find another ways to demons

win32, mod_perl/2.0.1, Apache/2.0.54 - ithreads problem

2005-07-30 Thread Plymouth Rock
 I'd using ithreads on ActivePerl 5.8.7 and Apache/2.0.54 (Win32). All scriptswith ithreads did working excellent. Since I've installed mod_perl/2.0.1 with'ppm install', those scripts have ceased to work (there's an initial HTML-table'sdumping only). Due to I couldn't find another ways to de