?
Solved

Apache/PHP/PostgreSQL Installation Help

Posted on 2002-07-28
7
Medium Priority
?
401 Views
Last Modified: 2013-12-15
I'm building a box to do develpment using Apache/PHP/and PostgreSQL. I have a Windows background, and am floundering some with my first Linux installation (although I'm confident I'm educable :-) )

I'm using Slackware 8.1, Apache 1.3.26, php 4.2.2, and postgres 7.2.1. I have the web server up, and php seems to be working. The problem is that all of the postgres functions seem not to be available to php. (I get message from PHP saying "Fatal Error: Call to undefined function: pg_connect()")

I'm more than happy to lavish points on an answer that gets this up and running!
0
Comment
Question by:rickpaul
  • 3
  • 3
7 Comments
 

Expert Comment

by:housetier
ID: 7186910
Hi!

My first guess is that you need to install the postgresql module for php. On my system the package is called "php4-pgsql" for php4 and "php3-pgsql" for php3.

hope it helps...
---Lasse
0
 

Author Comment

by:rickpaul
ID: 7188651
When I installed PHP, I used the --with-pgsql=shared configuration setting. I also see pgsql.so, which I understand is the shared file.

Is there something I can do to confirm that things are where they're supposed to be?
0
 

Accepted Solution

by:
housetier earned 600 total points
ID: 7188761
what is your distribution? Red Hat, Debian, slackware etc?

and does the output of following script say something about pgsql?

===cut===
<?php
     phpinfo();
?>
===cut==

It should give you lots of information about PHP, your webserver, the environment setting, and modules.

If you're quick you might try this URL

http://217.83.9.207/~housetier/info.php

which is excactly the script from above. (you have to be quick because I use a dial-up internet connection with dynamic IPs and I don't know how long I will have this IP)


Do have ICQ or AIM; so when both of us are online, I can give you the URL...
---Lasse
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 

Author Comment

by:rickpaul
ID: 7189085
distribution and versions of programs are in my initial question.

I was able to see your phpinfo, and my
phpinfo(); shows that I configured with pgsql

If we can chat with icq, that would be great!
0
 

Expert Comment

by:housetier
ID: 7190132
Well, my php has bin configured '--without-pgsql' but still there's output that reads:

PostgreSQL Support enabled




I must say that I've never built PHP from scratch. I always used binary packages for my distribution. That's what I recommend you to do, also. That way you have someone elso going through the hassle of configuring PHP and its modules :-)

Here's my ICQ# 117362350
and my AIM screenname realhousetier

---Lasse
0
 

Expert Comment

by:CleanupPing
ID: 9086589
rickpaul:
This old question needs to be finalized -- accept an answer, split points, or get a refund.  For information on your options, please click here-> http:/help/closing.jsp#1 
EXPERTS:
Post your closing recommendations!  No comment means you don't care.
0
 

Author Comment

by:rickpaul
ID: 9090963
Sorry to have taken so long to get back on this one.

While the answers provided were helpful and generous, they didn't really solve my problem.

While Lasse didn't directly answer my question he/she kept me plugging away on it until I finally tracked down the solution. (I don't remember clearly, but I think the problem had to do with multiple configuration files, and failing to edit the one that was being read by apache on httpd start.)



0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Virtualization software lets you run different versions of Windows, Ubuntu Linux and other versions of Linux all at the same time, rather than running each one directly from your computer's hard drive.
Welcome back to our beginners guide of the popular Unix tool, cron. If you missed part one where we introduced this tool, the link is below. We left off learning how to build a simple script to schedule automatic back ups. Now, we’ll learn how to se…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

568 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question