RE: [PHP-DB] PHP and PostgreSQL
I think from binary; it was installed as a part of Slackware, and I made no special efforts to compile. Version of PHP is 4.3.7 (thanks Mychael) Other: Linux kernel is 2.4.26 Apache version is 1.3.31 Looks like MySQL may already be configured in PHP (saw that in phpinfo() ) When installing PostgreSQL, I am fairly certain I made no attempt to configure anything in the database to permit use of PHP, as that was not a consideration at that time. In fact, not sure it even asked; it did ask about some languages (stored procedure language, TCL, etc). -Original Message- From: Mychael Scribner [mailto:[EMAIL PROTECTED] Sent: Thu 3/10/2005 2:40 PM To: Van Ingen, Lane; php-db@lists.php.net Cc: Subject: RE: [PHP-DB] PHP and PostgreSQL save this to a php file and run it. I a attached file just in case. This will give you all of the information you will need for you php installation. -Original Message- From: Stephen Johnson [mailto:[EMAIL PROTECTED] Sent: Thu 3/10/2005 2:37 PM To: Van Ingen, Lane; php-db@lists.php.net Cc: Subject: Re: [PHP-DB] PHP and PostgreSQL Did you compile php or did you install from a binary? If you compiled -- did you configure the PHP module --with-pgsql? I have not installed a binary in the past so I am not sure how you activate the pgsql module in that regard. The problem though is that the version of PHP you are running is not configured to support pgsql and you will need to do that to get it recognize the pgsql specific functions. http://www.thelonecoder.com [EMAIL PROTECTED] 562.924.4454 (office) 562.924.4075 (fax) continuing the struggle against bad code */ ?> > From: "Van Ingen, Lane" <[EMAIL PROTECTED]> > Date: Thu, 10 Mar 2005 14:32:39 -0500 > To: > Subject: [PHP-DB] PHP and PostgreSQL > > I am new to PHP. Trying to install it and PostgreSQL 8.0 on Slackware Linux > 10.0.0 . I am getting > the following error out of Apache: > Fatal Error: Call to undefined function: pg_connect() > > After browsing your web site, I found http://us2.php.net/pgsql . But am unable > to proceed because I > am not sure what to do. Specific questions: > (1) How do I determine what version of PHP I have? Browsed PHP directories, > but couldn't find it. > (2) The information I found said I could use a "shared object module" and/or > (I think) alter php.ini . > > I don't think this is hard to fix, but I need to find a blow-by-blow of what > to do. Can somebody help me? >
RE: [PHP-DB] PHP and PostgreSQL
save this to a php file and run it. I a attached file just in case. This will give you all of the information you will need for you php installation. -Original Message- From: Van Ingen, Lane [mailto:[EMAIL PROTECTED] Sent: Thursday, March 10, 2005 2:33 PM To: php-db@lists.php.net Subject: [PHP-DB] PHP and PostgreSQL I am new to PHP. Trying to install it and PostgreSQL 8.0 on Slackware Linux 10.0.0 . I am getting the following error out of Apache: Fatal Error: Call to undefined function: pg_connect() After browsing your web site, I found http://us2.php.net/pgsql . But am unable to proceed because I am not sure what to do. Specific questions: (1) How do I determine what version of PHP I have? Browsed PHP directories, but couldn't find it. (2) The information I found said I could use a "shared object module" and/or (I think) alter php.ini . I don't think this is hard to fix, but I need to find a blow-by-blow of what to do. Can somebody help me? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] PHP and PostgreSQL
Did you compile php or did you install from a binary? If you compiled -- did you configure the PHP module --with-pgsql? I have not installed a binary in the past so I am not sure how you activate the pgsql module in that regard. The problem though is that the version of PHP you are running is not configured to support pgsql and you will need to do that to get it recognize the pgsql specific functions. http://www.thelonecoder.com [EMAIL PROTECTED] 562.924.4454 (office) 562.924.4075 (fax) continuing the struggle against bad code */ ?> > From: "Van Ingen, Lane" <[EMAIL PROTECTED]> > Date: Thu, 10 Mar 2005 14:32:39 -0500 > To: > Subject: [PHP-DB] PHP and PostgreSQL > > I am new to PHP. Trying to install it and PostgreSQL 8.0 on Slackware Linux > 10.0.0 . I am getting > the following error out of Apache: > Fatal Error: Call to undefined function: pg_connect() > > After browsing your web site, I found http://us2.php.net/pgsql . But am unable > to proceed because I > am not sure what to do. Specific questions: > (1) How do I determine what version of PHP I have? Browsed PHP directories, > but couldn't find it. > (2) The information I found said I could use a "shared object module" and/or > (I think) alter php.ini . > > I don't think this is hard to fix, but I need to find a blow-by-blow of what > to do. Can somebody help me? > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] PHP and PostgreSQL
I am new to PHP. Trying to install it and PostgreSQL 8.0 on Slackware Linux 10.0.0 . I am getting the following error out of Apache: Fatal Error: Call to undefined function: pg_connect() After browsing your web site, I found http://us2.php.net/pgsql . But am unable to proceed because I am not sure what to do. Specific questions: (1) How do I determine what version of PHP I have? Browsed PHP directories, but couldn't find it. (2) The information I found said I could use a "shared object module" and/or (I think) alter php.ini . I don't think this is hard to fix, but I need to find a blow-by-blow of what to do. Can somebody help me?
[PHP-DB] PHP and PostgreSQL: Cannot create new link. Too many open links (0)
Hi All! After working with PHP and MySQL and Firebird quite a while I need to install PostgreSQL. After installation I made a new build of PHP to support PostgreSQL. I looked over the ini files and re-started Apache. With psql I can connect like: "psql -h localhost ...". But not any chancen seen with PHP. I even just made a small script with just two echo lines and a pg_pconnect() / pg_connect(). This is the error Message I get: "Warning: pg_pconnect(): Cannot create new link. Too many open links (0). in /www/test.php on line 5". I get this message no matter what connection string I use. Even if I leave it totally blank or put some nonsense in, I get the same error. Any hint appreciate - Thanks in advance! Johannes Configuration: Red Hat 9 PHP Version 4.3.4 Apache 2.0.48 PostgreSQL 7.3.4 PostgreSQL libpq 7.3.4 pg_hba.conf: local all all trust host all all 127.0.0.1 255.255.255.255 trust -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php