Fatal Error Call To Undefined Function Pg_connect Apache
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site
Call To Undefined Function Pg_connect() Wamp
About Us Learn more about Stack Overflow the company Business Learn more about fatal error call to undefined function pg_connect() in xampp hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join
Call To Undefined Function Pg_connect() Windows
the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Fatal error: Call to undefined php fatal error call to undefined function pg_connect() linux function pg_connect() up vote 17 down vote favorite 6 I am trying to connect to my database (remote server) which has PostgreSQL installed in it. My PHP code is trying to connect to the database using pg_connect(), but I get the error saying:- "Fatal error: Call to undefined function pg_connect() in /var/www/website/functions.php on line 82". The line 82 simply is: $db = pg_connect($conn_string); where $conn_string call to undefined function pg_connect() ubuntu = "host=".$hostname." port=5432 dbname=".$dbname." user=".$db_user." password=".$db_password."" (all variables defined earlier) I checked many forums and the only solution suggested was locating the php.ini file which contains a line:- extension = pgsql.so (for UNIX) and extension = php_pgsql.dll (for Windows). This statement is supposed to be commented and the solution is to uncomment it. I have tried it but still does not change the situation. The remote server has a version later than PostgreSQL v9.0.4 installed. I then installed PostgreSQL v8.4.8 on to my laptop and ran the website locally using MAMP. At first, Apache crashed for some odd reason, I fixed that problem but again I ended up with the same error as before i.e. Fatal error: Call to undefined function pg_connect().... I also ran the phpinfo() and it showed that the php version does support the PostgreSQL module.I have spent an entire day searching for the solution but have been unsuccessful. This is my first project developing a website and I am out of wits. Any kinda help will be highly appreciated. phpinfo() gives me a huge list of things at the terminal but the listings relevant to PostgreSQL are as follows:- pdo_pgsql PDO
there Pages: 1 #1 2011-06-07 04:04:42 xangelux Member Registered: 2010-05-29 Posts: 73 [SOLVED] pg_connect() undefined fatal even when all is there I'm trying to get php, postgresql and apache2 working
Call To Undefined Function Pg_connect() Mac
but when i try to connect throug pg_connect() the apache server codeigniter call to undefined function pg_connect() complains:Fatal error: Call to undefined function pg_connect()I've been throug all forums and wikis and I'm shure i have
Call To Undefined Function Pg_connect() Centos
the correct settings. php.ini has the extension=pgsql.so thing, phpinfo() displays '--with-pdo-pgsql=shared' '--with-pdo-sqlite=shared,/usr' '--with-pgsql=shared' on the configuration part and php-pgsql is installed. Nowhere says what to do in this case, http://stackoverflow.com/questions/7438059/fatal-error-call-to-undefined-function-pg-connect can anyone help?Thanks in advance. Last edited by xangelux (2011-07-06 01:53:55) Offline #2 2011-07-06 01:53:28 xangelux Member Registered: 2010-05-29 Posts: 73 Re: [SOLVED] pg_connect() undefined fatal even when all is there Fuuuuuuuuuuuuuuuuuuuuu"#$% finally i found the answer, the problem is PHP is looking for extensions in the EXTENSIONS directory but... here it comes... "THEY CHANGED THE EXTENSIONS TO DIR https://bbs.archlinux.org/viewtopic.php?id=120384 MODULES!!!!!!!!!!!!!" WTF?????? HUGGEE BUG.Ok so, the workarround is:$ su - Password: # ln -s /usr/lib/php/modules /usr/lib/php/extensionsAnd then edit your /etc/php/php.ini and change the extension_dir to "/usr/lib/php/extensions/"That's it, this is for every extension that doesn't work (I've tryed uncomment others with the same result until i did this)If someone tryed to search for it, thanks for your effort, for those who suffered like me, here is your answer. If this doesn't work let me know, maybe i did something else to my system too. Offline Pages: 1 Index »Networking, Server, and Protection »[SOLVED] pg_connect() undefined fatal even when all is there Board footer Jump to Newbie Corner Installation Kernel & Hardware Applications & Desktop Environments Laptop Issues Networking, Server, and Protection Multimedia and Games System Administration Other Architectures Announcements, Package & Security Advisories Arch Discussion Forum & Wiki discussion Pacman & Package Upgrade Issues [testing] Repo Forum Creating & Modifying Packages AUR Issues, Discussion & PKGBUILD Requests GNU/Linux Discussion Community Contributions Programming & Scripting Other Languages Artwork and Screenshots Atom topic feed Powered by FluxBB
pgsql-announce pgsql-bugs pgsql-docs pgsql-general pgsql-interfaces pgsql-jobs pgsql-novice pgsql-performance pgsql-php pgsql-sql pgsql-students Developer lists Regional lists Associations User groups Project https://www.postgresql.org/message-id/OFD667D637.1D62587D-ON85257730.006AE38B-85257730.006B2BA8@isn.rtss.qc.ca lists Inactive lists IRC Local User Groups Featured Users https://bytes.com/topic/apache/answers/835863-fatal-error-call-undefined-function-pg_connect International Sites Propaganda Resources Weekly News Fatal error: Call to undefined function pg_connect() From: Steve(dot)Toutant(at)inspq(dot)qc(dot)ca To: pgsql-php(at)postgresql(dot)org Subject: Fatal error: Call to undefined function pg_connect() Date: 2010-05-27 19:30:35 Message-ID: OFD667D637.1D62587D-ON85257730.006AE38B-85257730.006B2BA8@isn.rtss.qc.ca (view raw or whole thread) Thread: 2010-05-27 19:30:35 from call to Steve(dot)Toutant(at)inspq(dot)qc(dot)ca 2010-05-27 22:50:55 from Chris
Ask a Question Need help? Post your question and get tips & solutions from a community of 418,550 IT Pros & Developers. It's quick & easy. Fatal error: Call to undefined function pg_connect() in 100+ P: 274 creative1 I get following error: Fatal error: Call to undefined function pg_connect() in C:\www\desiorb.dev\public_html\httpdocs\index.php on line 18 said line is to connect to postres pg_Connect.... I also want to tell that: I am setting up virtual host on my computer, apache works for projects that don't have database support. I uncomment php.ini file for postgres. Apache runs fine there is no error. I have right user name and password entered i am sure about that part. I re-installed postgres to make sure it works. I started the database. I can see databse conenctivtivity in pgAdmin any other suggestions? Thanks in advance. Sep 5 '08 #1 Post Reply Share this Question 2 Replies Expert 5K+ P: 5,058 Atli Hi. This happens when the PostgreSQL module is missing. Make sure that you uncomment / create the extension line in you php.ini. Like: Expand|Select|Wrap|Line Numbers extension=pgsql.so;ForUnix extension=pgsql.dll;ForWindows Also, make sure that the file actually exist in the directory specified by the extension_dir directive. You can look for the PostgreSQL info in the phpinfo() output to see if it has been loaded properly. If you can't find it, it hasn't been loaded. Sep 11 '08 #2 reply 100+ P: 274 creative1 thanks, I actually I was wrong in specifying version number for the php I have installed. I fixed it . Regards Oct 27 '08 #3 reply Message Cancel Changes Post your reply Join Now >> Sign in to post your reply or Sign up for a free account. Similar topics Fatal error: Call to undefined function pg_connect() Fatal error: Call to undefined function fe() Upgarding php4 to php5 leads to: PHP Fatal error: Call to undefined function ... Fatal error undefin