--with-pgsql=WHERE?

PHP Installation With Pgsql
I got PostgreSQL installed and now I'm trying to get PHP installed too. I do ./configure --with-pgsql and everything works fine. But when I do make, I get this error:

ext/mysql/libmysql/my_lib.o(.text+0x37a): In function `my_dir':
/home/marc/extract/php-4.3.1/ext/mysql/libmysql/my_lib.c:169: undefined reference to `errno'
ext/mysql/libmysql/my_lib.o(.text+0x546): In function `my_stat':
/home/marc/extract/php-4.3.1/ext/mysql/libmysql/my_lib.c:588: undefined reference to `errno'
ext/mysql/libmysql/my_tempnam.o(.text+0x79):/home/marc/extract/php-4.3.1/ext/mysql/libmysql/my_tempnam.c:108: more undefined references to `errno' follow
collect2: ld returned 1 exit status
make: *** [sapi/cgi/php] Error 1

I need php installed soon. I don't know what is causing this error to occur.

View Replies !

---

Hosting PHP And PGSQL DB
Can anyone recommend somewhere that offers cheap or even free web hosting for PHP scripting with a PGSQL database? I am looking to build a small website with some images and dynamic content, such as a forum/message board and wondered what it would cost me for this? I used to use themooseisloose for hosting (one-off payment of £2.77 GBP), but have been alerted that have gone bust (at some point at the end of last year). I've have googled, but was just wondering if anyone had any positive experiences of hosts that will allow this setup mentioned cheaply.

View Replies !

---

Error Management : Php-pgsql.
My goal : obtain the error message if the connection fail.

## my code :

<?php

$cnxString = "host=localhost port=5432 dbname=toto user=atlante
password=aiThoo3g";

$pgsql_conn = pg_connect($cnxString, PGSQL_CONNECT_FORCE_NEW);

if ($pgsql_conn) {
print "Connexion réussie à : " . pg_host($pgsql_conn) . "<br/>
";
} else {
echo pg_last_notice($pgsql_conn);
exit;
}
?>

## if «php_value display_errors 1» the screen result is this one :

Warning: pg_connect() [function.pg-connect]: Unable to connect to
PostgreSQL server: FATAL: la base de données «toto» n'existe pas in
/home/willou/public_html/atlanpolis/wwws/tools/checkdb.php on line 5

Warning: pg_last_notice() expects parameter 1 to be resource, boolean
given in /home/willou/public_html/atlanpolis/wwws/tools/checkdb.php on
line 10

## If not, i haven't got any result. The message just appears in my
logs

The return of pg_connect not seems to be an connection resource when
the connection fails.

View Replies !

---

My Dad Wants PHP & MySQL Or PgSQL Hosting
To my surprise last month, my dad wanted to start dabbling in PHP and
MySQL or pgSQL. I've been helping him out a bit. He's into athletic
medicine and wants to have a website to help athletes and physical
therapists improve performance. His current web hosting provider --
Earthlink -- doesn't give him anything but PHP 3.0.x. I want to get
him at least on PHP 4.2.x (or better) along with either MySQL or
PostgreSQL (pgSQL) support.

I've done some googling on this, but I wanted real user opinions on
cost, customer support, uptime, etc. At this point he's just looking
at something that suits him somewhere between hobbyist and early sole
proprietorship strength. Shared web hosting would suit him fine. Cost
might be an issue for him initially.

He's going to need some sort of simplistic web interface to be able to
create databases, tables, and user accounts.

View Replies !

---

Pgsql Socket Timeout
I am encountering a problem with PHP5 and postgresql on a fedora core 3 box. I have a database driven report application written in PHP5 on a remote server. This application allows a user to submit a sql statement created by php based on user input parameters to the postgresql server. The application works great as long as the database server can return the result set within what appears to be 2 minutes. If the query takes longer than two minutes to execute the database server will eventually finish the work *but* no rows of data appear on the web page.

I am thinking that the network socket connection between the php engine and the postgresql database server gets dropped after two minutes and that is way the results never arrive at the php page. If you think this might be a plausible explanation can you provide some assistance as to how I can go about adressing this problem?

View Replies !

---

Ubuntu Php4-pgsql
I found some strange kind of mild install bug when installing Ubuntu 5.04 php4-pgsql module (the module that connects PHP4 to PostgreSQL). You may encounter the error:

Call to undefined function: pg_connect()

No amount of using Synaptic Package Manager would fix this for me. The solution was all at command line under 'root' account:

$ apt-get update
$ apt-get install php4-pgsql
$ /etc/init.d/postgresql restart
$ /etc/init.d/apache2 restart

View Replies !

---

How To Increase PHP/pgsql Develop. Performance?
Can anyone give me recomendations on software that can increase my performance when devenlopping Php and Postgres applications?
I'm currently working on a big project and its taking too long (3 people working on it).

View Replies !

---

MySQL And PGSQL And Hostname Question
i would like the thoughts of some folks with more experience
than i have.

i want to learn pgsql. i have some vb and msaccess experience and
would like to learn how to use php and pgsql to develop some nice
website / application functionality.

however, i'm not sure the hurdle of relatively miniscule documentation
and tutorials is worth the effort. i'm now thinking i should just use
mysql to start and, if the need really arises, move over to pgsql.

i'm busy with a lot of stuff right now - regular job, starting a
business, developing a web site for the business, learning graphics
programs, living life, blah, blah, blah.

what is your opinion? go with the better documented db and develop
more quickly but have to possibly switch over later when time may be
more available and retain my hair or bite the bullet and go with
pgsql?

differing opinions are appreciated and encouraged so i can evaluate
them based on my own set of values.

also i am trying to set up localhost as my url so my hardcoded links
work on my local win98 machine (actual webserve is linux).

host.sam is as follows...

127.0.0.1 localhost www.easyautodeals.com

my apache httpd.conf file shows the following for ServerName:

ServerName www.easyautodeals.com

however, when i type easyautodeals into my web browser, i go straight
to my actual web server and not to my "localhost" location.

View Replies !

---

Irritating Warning On ->PEAR->DB->PGSQL
I am getting following message from pear. I am running RedHat 8.0, PostgreSQL is 7.3.2 PHP Version 4.2.2 and pear:db 1.6.5.

Warning: pg_errormessage(): supplied argument is not a valid
PostgreSQL link resource in /usr/share/pear/DB/pgsql.php on line 449

Any idea.

View Replies !

---

PGSQL 7.4.8 PHP 4.3.4 & Apache 2.0.49 Segmentation Fault With Client Certs
Having an issue that is specific to PHP compiled with PGSQL support
with versions noted in subject line. I understand that there are many
variables to consider here but believe I have narrowed down the Apache
Client Cert failures to my PHP/PGSQL build.

1. Apache PHP without PGSQL works as expected using client certificates

2. Apache PHP with PGSQL works fine with standard SSL connections

3 Apache PHP with PGSQL fails with client certificates - no output

other than Segmentation faults in the apache error logs as follows:

[Wed Nov 30 23:26:57 2005] [notice] suEXEC mechanism enabled (wrapper:
/usr/sbin/suexec2)....

I also performed same tests on another instance of Apache/PHP/PGSQL
which was version 2.0.54 of apache and PHP/PGSQL versions same as
subject line with same exact results.

Any ideas as to the source of this problem and suggestions for
tests/fixes are greatly appreciated. There are no errors in any of the
logs other than what I have included so it's very difficult to see what
is wrong. All I know for sure is that I am able to reproduce the
results on more than one machine.

View Replies !

---