Orpington Astronomical Society

Back Room => Updates and Upsets => Topic started by: Mike on May 27, 2002, 20:03:00

Title: Version
Post by: Mike on May 27, 2002, 20:03:00
Is this new forum using the version 2 of phpBB ??
Title: Version
Post by: Ian on May 27, 2002, 20:24:00
no. that is still w.i.p. Stay tuned :smile:
Title: Version
Post by: Rick on Jun 05, 2002, 03:36:00
As an educational exercise, I set up phpBB2 on my home system using PostgreSQL. There are a few bugs in the install procedure at the moment, at least with the PostgreSQL option. I applied at least one fix manually. The security implications of some of the things, particularly those relating to PostgreSQL, are quite scary, but at the moment there's supposed to be no way in from the Big Bad Net.

[ This Message was edited by: Rick on 2002-06-04 19:37 ]
Title: Version
Post by: Ian on Jun 05, 2002, 19:02:00
let me know how you get on. phpBB2 looks pretty good, but at the moment I'm having fun getting the look right. I am in discussions with Greg, to see if there is anything he can help with (although it is slow going, I haven't been answering his emails, sorry Greg)

Any particular reason you are playing with postgres? To be honest, the only reason I am using mySQL is coz I was playing with a home security system that uses mySQL as a backend, so it was already installed and running.
Title: Version
Post by: Rick on Jun 06, 2002, 00:12:00
There's no particularly strong reason I installed it with postgress rather than mysql. I think one or two of the packages I installed preferred postgress, but at one stage I had them both installed. Mysql got the boot when I was thinning things out, 'cos it had no dependants I wanted to keep.

Havn't actually done anything with the packages that wanted postgress yet though.

What's the access control on mysql like?
Title: Version
Post by: Rick on Jun 06, 2002, 05:56:00
Hmmm... PhpBB 2.0.1 seems to have some significant problems with user registration. My test system won't accept any users, and, judging by the PhpBB support board, it's a common problem...
Title: Version
Post by: Ian on Jun 06, 2002, 17:50:00
thats interesting. I've had no problems with 2.0.0 looks like they have introduced a problem. What sort of problem are you having?
Title: Version
Post by: Rick on Jun 06, 2002, 19:22:00
There's only one registered user, and all attempts to add another fail, but without actually revealing any useful information about why they fail. A little hunting on the PhpBB site reveals this comment (http://www.phpbb.com/phpBB/viewtopic.php?t=10263) about a missing database column. I didn't spot that last night, so maybe I'll have another try tomorrow...
Title: Version
Post by: Ian on Jun 06, 2002, 20:07:00
fairy fluff.

My install isn't an upgrade, so I guess the missing column exists.
Title: Version
Post by: Rick on Jun 06, 2002, 20:42:00
Mine isn't either. Did you get 2.0 or 2.0.1? At least one of the things I've had to patch was postgress-specific, but that missing column seems to affect mysql as well. I can't test to see whether the fix works as my web server's on the other side of a firewall as seen from here, and I've got some NAT issues to resolve before it can be seen from outside.
Title: Version
Post by: Rick on Jun 07, 2002, 08:44:00
The problems seem to relate to the "avatars" options. Turn them all off, and things start to work after a fashion (though I still had to fix the schema for the phpbb_users table). More work needed...
Title: Version
Post by: Rick on Jun 17, 2002, 22:10:00
There's definitely something odd about phpBB2. Those problems I've been having with allowing users to register just vanished. I don't think I did anything in particular to fix them, except maybe turning the avatars off and then back on again. I'm sure there's a bug there that they havn't yet found though.
Title: Version
Post by: Rick on Jun 18, 2002, 00:02:00
...and now my ADSL seems to have fallen over... :sad: