Re: Hi!, and a Question
От | Frank Bax |
---|---|
Тема | Re: Hi!, and a Question |
Дата | |
Msg-id | 5.2.1.1.0.20040608081521.033bd310@pop6.sympatico.ca обсуждение исходный текст |
Ответ на | Re: Hi!, and a Question (David Cruz <davidcrmail@yahoo.com>) |
Список | pgsql-php |
Check your apache log to see if error messages are being logged there. I'll make a guess anyway. With a connect statement like: $db = pg_connect("dbname=cdtaller4_3"); You should also have user=xxxxx inside the quotes. You may or may not have more success by adding host=localhost. Frank At 02:17 AM 6/8/04, David Cruz wrote: >Hi!, about this, I'm using it local, in the same >server is postgresql and the database and the apache >web server too. I have downloaded the php-pgsql again >and install it again, it was an rpm and i have knoppix >(debian), so I did it with #alien -i, I have this in >my php.ini > >------ >;;;;;;;;;;;;;;;;;;;;;; >; Dynamic Extensions ; >;;;;;;;;;;;;;;;;;;;;;; >; >; If you wish to have an extension loaded >automatically, use the following >; syntax: >; >; extension=modulename.extension >; >; For example, on Windows: >; >; extension=msql.dll >; >; ... or under UNIX: >; >; extension=msql.so >; >; Note that it should be the name of the module only; >no directory information >; needs to go here. Specify the location of the >extension with the >; extension_dir directive above. >extension=pgsql.so > >------ > >I have pgsql.so in /usr/lib/php4/20020429 which is the >place where phpinfo(); says it's searching for >extensions > > >------- >and my /etc/postgresql/pg_hba.conf says: > ># ># TYPE DATABASE USER IP-ADDRESS >IP-MASK METHOD ># Database administrative login by UNIX sockets >local all all > trust ># ># All other connections by UNIX sockets >local all all > trust ># ># All IPv4 connections from localhost >host all all 127.0.0.1 >255.255.255.0 trust ># ># All IPv6 localhost connections >host all all ::1 >ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff trust >host all all ::ffff:127.0.0.1/128 > trust ># ># reject all other connection attempts >localhost all all 192.168.1.6 > 255.255.255.0 trust > >------- >and the phpinfo page shows: > >pgsql >PostgreSQL Support enabled >Active Persistent Links 0 >Active Links 0 > >Directive Local Value Master Value >pgsql.allow_persistent On On >pgsql.auto_reset_persistent Off Off >pgsql.max_links Unlimited Unlimited >pgsql.max_persistent Unlimited Unlimited > >----- >I don't know what am I doing but it doesn't work, when >I execute the php web page: > ><?php $db = pg_connect("dbname=cdtaller4_3"); $query = "select * from >empleados"; $result = pg_exec($db, $query); if (!$result) { printf >("ERROR"); $errormessage = pg_errormessage($db); echo $errormessage; exit; >} ?> <index3.htm>a index3 >It doesn't shows any error or something it stays on >the same page it was, and do nothing... > >Thanks...if somebody knows another configuration I'm >forgetting.. (PHP 4, Apache, PostgreSQL 7.4.2, Knoppix >3.4) > >thanks!
В списке pgsql-php по дате отправления: