 |
Linux Format forums
Help, discussion, magazine feedback and more
|
| View previous topic :: View next topic |
| Author |
Message |
fairless
Joined: Sat May 07, 2005 1:31 am
Posts: 27
|
 Posted: Thu May 25, 2006 11:54 am Post subject: phpbb postrgres initial registration problem |
 |
|
Dear All,
I have set-up a test (internal) phpbb and have run in to a number of issues. Have looked at their support, google etc. and although I have fixed some issues am now stuck at the point where I register the 1st none Admin user. The following is the template the phpbb uses for their support but if any of you guys have any ideas it would be appreciated:
Dear Support as per your template:
Your phpBB board URL: Internal test system http://linux.eu.mycompany.net/it/forum/
Template(s) used: Default English SubSilver?
Any and all MODs: None
Do you use a port of phpBB: No
Version of phpBB: 2.0.20
Version of PHP: PHP 4.3.8 (cli) (built: Apr 19 2006 17:22:14) Copyright (c) 1997-2004 The PHP Group Zend Engine v1.3.0, Copyright (c) 1998-2004 Zend Technologies
Which database server and version: PostgresSQL 7.4.8
Host: Suse Linux 9.2 Apache2 - linux.eu.mycompany.net 160.61.252.192 127.0.0.1 localhost?
Did someone install this for you/who: Me
Is this an upgrade/from what to what: Fresh install
Is this a conversion/from what to what: No
Have you searched for your problem: Yes - your forums, knowledgbase and google
If so, what terms did you try: register, registration, postgres and parts of the error messages
State the nature of your problem: I have created a test install with the initial Admin account. I wanted to register a new user to demo the capabilities. On selecting either of the "I agree" options the following error is displayed:
General Error
Could not insert new confirm code information
DEBUG MODE
SQL Error : -1 ERROR: value too long for type character(6)
INSERT INTO phpbb_confirm (confirm_id, session_id, code) VALUES ('57b5a282c73cc7d04021ed86985c4edd', '02f73d14a58ea37c51e220c908b9f737', 'C4A92BCAFO')
Line : 1002
File : usercp_register.php
I initially had problems running the install/config. which appears to be due to the postgres "Ident" login and had to change this to use MD5, I'm not sure if this is causing the problem be encrypting the data and causing the field to expand larger than expected?
Do you have a test account for us: No, internal network access only.
Many thanks, regards Neil  |
|
| Back to top |
|
 |
Steogede
LXF regular
Joined: Thu May 04, 2006 6:39 pm
Posts: 132
|
| Posted: Fri May 26, 2006 6:56 pm Post subject: RE: phpbb postrgres initial registration problem |
|
|
| Quote: |
SQL Error : -1 ERROR: value too long for type character(6)
INSERT INTO phpbb_confirm (confirm_id, session_id, code) VALUES ('57b5a282c73cc7d04021ed86985c4edd', '02f73d14a58ea37c51e220c908b9f737', 'C4A92BCAFO') |
You would need to check the table structure to see which field is limited to 6 characters, but I would expect the confirm_id and session_id to be as long as they are. Not sure about the 'code' field. You can check the table structure using 'psql' i.e. open a kde Konsole, run 'psql databaseName databaseUser -W' once in psql run '\d phpbb_confirm'. Still knowing which fields length is being exceed probably doesn't help much.
| Quote: | | I initially had problems running the install/config. which appears to be due to the postgres "Ident" login and had to change this to use MD5, I'm not sure if this is causing the problem be encrypting the data and causing the field to expand larger than expected? |
Selecting MD5 authentication doesn't encrypt any data, it merely encrypts your password when you log into the server. If you wanted you could try setting it to 'trust' rather than use authentication (shouldn't be a risk is the server isn't available externally), for extra security you can even tell it to only trust connections from localhost.
Forget all that I have just done a little googling. I appears the 'code' field is set too small by default, it should accept 10 characters. Log into postgresql (psql) and alter the column width e.g. 'ALTER phpbb_confirm ALTER COLUMN code TYPE varchar(10)'
A little more googling shows that it might be related to this 'The mbstring PHP extension was not found and you seem to be using a multibyte charset. Without the mbstring extension phpMyAdmin is unable to split strings correctly and it may result in unexpected results.' It might be that becuase you are running an old version of SUSE, you are running an old version of PHP which does not include mbstring. I would recommend that you update to the a newer version of PHP before trying anything else, it should be available in YOU (yast online updater) - the version of PHP you are running probably has many serious security holes. |
|
| Back to top |
|
|
fairless
Joined: Sat May 07, 2005 1:31 am
Posts: 27
|
| Posted: Wed May 31, 2006 9:31 pm Post subject: RE: phpbb postrgres initial registration problem |
|
|
Dear All, the nice people over at the phpbb managed to resolve the issue. For any of you with a similar problem please take a look at: http://www.phpbb.com/phpBB/viewtopic.php?p=2159340#2159340 for the resolution.  |
|
| Back to top |
|
|
| View previous topic :: View next topic |
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
Powered by phpBB © 2001, 2005 phpBB Group
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
