Page 1 of 1

db.php line 41 -- undefined function pg_connect()

Posted: 23 Oct 2013, 01:29
by daleoffret
I setup and am running TT-RSS. I completed that 2 weeks ago. So I am familiar with the base and requirements setup.

I re-installed the tt-irc master folder contents from GitHub. I also have a successfully compiled backend.jar. It also connects without errors to my PgSQL database.

My problem is the following error from /var/log/apache2/error.log.

Code: Select all

[Tue Oct 22 16:19:16 2013] [error] [client x.x.x.x] PHP Fatal error:  Call to undefined function pg_connect() in /var/www/tt-irc/include/db.php on line 41


I have looked around and played with the username and password. I don't think it is even getting that far. Ideas? I do have an underscore in my username. Could that cause a problem?

Re: db.php line 41 -- undefined function pg_connect()

Posted: 23 Oct 2013, 04:53
by sleeper_service
it sounds like you've got a problem with the php that ttirc is using.

Re: db.php line 41 -- undefined function pg_connect()

Posted: 23 Oct 2013, 09:02
by fox
I'm sure you googled this error before posting here.

Re: db.php line 41 -- undefined function pg_connect()

Posted: 23 Oct 2013, 15:15
by daleoffret
Rookie mistake. After searching Google a second round, I found from StackOverflow I needed the php5-pgsql object bridging Apache to Postgres.

I figured running TT-IRC next to TT-RSS would get me in good shape. Well, I didn't realize that the php5-<insert database> is needed. So I have mysql and Postgres on the same box with Apache.

Code: Select all

apt-get install php5-pgsql


My problem was getting a blank page during the initial load. My first round of Google searches kept pointing to a db.php file not properly "included" in php.

Sorry for the mistake. I do enjoy the Tiny Tiny line of products.