bloody forums... and lack of knowledge
-
- guru
- Posts: 562
- Joined: Thu Jan 09, 2003 8:25 pm
bloody forums... and lack of knowledge
I just downloaded phpBB. I have postgresql isntalled (i barely know how to use it). I created my database and started the postgresql server and added a pgsql user.
Now i tried installing phpBB and it said "your version of PHP doesnt support postgresql".
I'm almost postive my PHP works on my server.
So, is there some sort of package i must installed to get php to work with postgresql??
Now i tried installing phpBB and it said "your version of PHP doesnt support postgresql".
I'm almost postive my PHP works on my server.
So, is there some sort of package i must installed to get php to work with postgresql??
Like always, it could be extremely helpful to know which distro/version, Apache/version, PHP/version, PostgreSQL/version, etc. It would also be helpful to know if the previous packages were compiled from scratch or prebuilt packages. If prebuild where they are from, if compiled from scratch, what options were used, etc.
Having said the above I ended up going with MySQL as the backend for my phpBB rather than PostgreSQL. I am a huge fan of PostgreSQL (prefer it over MySQL actually) but I ran into a couple of snags with phpBB. When I tested it on MySQL, which I also had installed, I didn't have any trouble so I just left it running on MySQL. I believe the phpBB people favor MySQL so if you have that installed you might try it.
Having said the above I ended up going with MySQL as the backend for my phpBB rather than PostgreSQL. I am a huge fan of PostgreSQL (prefer it over MySQL actually) but I ran into a couple of snags with phpBB. When I tested it on MySQL, which I also had installed, I didn't have any trouble so I just left it running on MySQL. I believe the phpBB people favor MySQL so if you have that installed you might try it.
-
- guru
- Posts: 562
- Joined: Thu Jan 09, 2003 8:25 pm
i will try mysql because i do have it installed. I like PostgreSQL better (even tho i have little experieince with either).
For when i cant get mysql/pgsql working.... slackware9 (or 8.1... but i think its 9), installed with OS (everything), pgsql 7.3, mysql ver11.18 dis.3.23.51 , php 4.2.1, apache 1.3.24
For when i cant get mysql/pgsql working.... slackware9 (or 8.1... but i think its 9), installed with OS (everything), pgsql 7.3, mysql ver11.18 dis.3.23.51 , php 4.2.1, apache 1.3.24
Last edited by Master of Reality on Mon Jun 16, 2003 2:49 pm, edited 1 time in total.
-
- guru
- Posts: 562
- Joined: Thu Jan 09, 2003 8:25 pm
That's a really old version of Apache and not one that comes with Slack 8.1 or 9.0. Slackware 8.1 comes with apache-1.3.26 and Slackware 9.0 comes with apache-1.3.27. The PHP version you are running is the same version that ships with Slack 8.1, 9.0 ships with 4.3.1. Slack 8.1 ships with MySQL 3.23.51 and 9.0 ships with 3.23.56. I didn't see PostgreSQL in the list for either distro version, which might explain the error message. If it doesn't ship with PostgreSQL then there is no reason to compile in PostgreSQL support in the PHP package.
I would suggest determining the actual Slackware version you have installed and get the slackware packages for Apache, PHP, PostgreSQL, and MySQL that match that distro:
I would suggest determining the actual Slackware version you have installed and get the slackware packages for Apache, PHP, PostgreSQL, and MySQL that match that distro:
-
- guru
- Posts: 562
- Joined: Thu Jan 09, 2003 8:25 pm
I don't know about Slackware but on Red Hat when you upgrade your Apache it will put the new config file in as "httpd.conf.rpmnew" so as not to mess up your existing configuration. I would make backup copies of your config files and your web site just in case. Maybe someone here that runs Slack can give you more definitive advice.
-
- guru
- Posts: 562
- Joined: Thu Jan 09, 2003 8:25 pm
oops i must have edited since you posted. I did upgrade and apache is working fine. But i do get "phpBB : Critical Error Could not connect to the database" when i try to use MySQL.
What permissions should i set for the mysql user?
I created a user and a database ("phpbb") in mysql through webmin. I'm not sure what else i have to do in mysql.
What permissions should i set for the mysql user?
I created a user and a database ("phpbb") in mysql through webmin. I'm not sure what else i have to do in mysql.
Is the MySQL server actually running? "netstat -a | grep mysql" should show a line starting with "tcp" and part of the line should be either "*:mysql" or "localhost:mysql".
As far as the MySQL user and database I created a user called "forum" and under "MySQL user permissions" in webmin that user is restricted to host "localhost" with an encrypted password of my choice and no permissions. I created a database called "forum" and under "Database Permissions" user "forum" has "All" permissions on database forum from localhost. Then in the phpBB setup I just used the database name, database username and password and that was that.
As far as the MySQL user and database I created a user called "forum" and under "MySQL user permissions" in webmin that user is restricted to host "localhost" with an encrypted password of my choice and no permissions. I created a database called "forum" and under "Database Permissions" user "forum" has "All" permissions on database forum from localhost. Then in the phpBB setup I just used the database name, database username and password and that was that.
-
- guru
- Posts: 562
- Joined: Thu Jan 09, 2003 8:25 pm
-
- guru
- Posts: 562
- Joined: Thu Jan 09, 2003 8:25 pm