Where can I get error messages?

I've installed Postgres 7.2.2 on Linux SuSE 8.0 Pro.
From other server (SuSE 8.0 Pro + Apache 2.0.39 + PHP 4.2.2) I'm trying
to get access to Postgres database, using PHP-script:







I've no errors messages both in PHP log and Postgres console, but HTML
page was been generated this script are stoped on tag. Where
can I get error messages? That is possible troubles?

Thank You

--
With respect, Andrey Sergeev


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

Re: Where can I get error messages?

Why don't you use the DB::connect instead?

"dr_sad(surguttel)" wrote:
>
> I've installed Postgres 7.2.2 on Linux SuSE 8.0 Pro.
> >From other server (SuSE 8.0 Pro + Apache 2.0.39 + PHP 4.2.2) I'm trying
> to get access to Postgres database, using PHP-script:
>
>
>
>
>
>
>
> I've no errors messages both in PHP log and Postgres console, but HTML
> page was been generated this script are stoped on tag. Where
> can I get error messages? That is possible troubles?
>
> Thank You
>
> --
> With respect, Andrey Sergeev
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Re: Where can I get error messages?

Hi, Jean-Luc.
Can't find any documents about "DB::connect" at www.php.net :(
Give me please any links to that.
And why "pg_connect" does not work properly?
Script ex.:
---- cut ---------


printf("Hello, world!
");
$s="host=dbserv port=5432 dbname=ll user=postgres password=gecnzr";
if (($db=pg_pconnect ($s))===false) {printf("FALSE! No connection!
");}
printf("This is the end of script
");
?>


--- cut -----------
No errors messages... "Hello, world!
" - is the last line in
generated html text :\

with respect, Andrey

Wednesday, August 28, 2002, 9:20:43 PM, you wrote:
JLL> Why don't you use the DB::connect instead?

JLL> "dr_sad(surguttel)" wrote:
>>
>> I've installed Postgres 7.2.2 on Linux SuSE 8.0 Pro.
>> >From other server (SuSE 8.0 Pro + Apache 2.0.39 + PHP 4.2.2) I'm trying
>> to get access to Postgres database, using PHP-script:
>>
>>
>>
>>
>>
>>
>>
>> I've no errors messages both in PHP log and Postgres console, but HTML
>> page was been generated this script are stoped on tag. Where
>> can I get error messages? That is possible troubles?
>>
>> Thank You
>>
>> --
>> With respect, Andrey Sergeev
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 2: you can get off all lists at once with the unregister command
>> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

JLL> ---------------------------(end of broadcast)---------------------------
JLL> TIP 4: Don't 'kill -9' the postmaster


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

Re: Where can I get error messages?

on 8/28/02 9:57 PM, dr_sad@surguttel.ru purportedly said:

> Hi, Jean-Luc.
> Can't find any documents about "DB::connect" at www.php.net :(
> Give me please any links to that.
> And why "pg_connect" does not work properly?
> Script ex.:
> ---- cut ---------
>
>
> > printf("Hello, world!
");
> $s="host=dbserv port=5432 dbname=ll user=postgres password=gecnzr";
> if (($db=pg_pconnect ($s))===false) {printf("FALSE! No connection!
");}
> printf("This is the end of script
");
> ?>
>
>
> --- cut -----------
> No errors messages... "Hello, world!
" - is the last line in
> generated html text :\
>

This would mean that something is interfering with PHP's standard error
reporting mechanism. Look for set_error_handler in any PHP code you invoke
and check your php.ini for any related directive, as well as any auto-append
or auto-prepend scripts if defined.

Keary Suska
Esoteritech, Inc.
"Leveraging Open Source for a better Internet"


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

Re: Where can I get error messages?

Hi Andrey

> Can't find any documents about "DB::connect" at www.php.net :(
So check the pear-doku.

> And why "pg_connect" does not work properly?
You are using a persistent connection in your example, but anyway,
your code is working for me perfectly.
To get errormessages try out pg_last_error() or pg_result_error().

Regards
Conni




---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

Re: Where can I get error messages?

Here is a sample:

Re: Where can I get error messages?

Sorry, but this sample doesn't work... :\
if I change phptype "pgsql" in DSN
(pgsql://$userid:$password@$dbhost/$database)
on "mysql", then get error message:"DB Error: connect failed", but
else if phptype=pqsql (as write in sample) nothing happyness and
result html code is:

Re: Where can I get error messages?

> Why don't you use the DB::connect instead?
>
> "dr_sad(surguttel)" wrote:
>>
>> I've installed Postgres 7.2.2 on Linux SuSE 8.0 Pro.
>> >From other server (SuSE 8.0 Pro + Apache 2.0.39 + PHP 4.2.2) I'm
>> >trying
>> to get access to Postgres database, using PHP-script:

Can you login with the same user and password using pgsql?
Are the database server and webserver running on the same machine?

>>
>>
>>
>>
>>
>>
>>
>> I've no errors messages both in PHP log and Postgres console, but HTML
>> page was been generated this script are stoped on tag. Where
>> can I get error messages? That is possible troubles?

If the script has stopped at pg_connect there are two things:
- the database server isnt running
- the password, login,machine ip you are using arent authorized to connect

Take a look at the log of postgres. For this, i hope you havent sent the
output of the postmaster to /dev/null.
Miguel





---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org