| View previous topic :: View next topic |
| Author |
Message |
toothlesrooster
-
Joined: 23 Jul 2005
Posts: 1
|
 Posted: Sat Jul 23, 2005 7:10 am Post subject: php, phpBB and MySQL |
 |
|
I have an issue. I am totally new to PHP and MySQL and am trying to set up phpBB for my website. This is a low key, low traffic personal site for friends and family that runs on a server in my house. Here is my issue.
I have installed Abyss X1 (v 2.0.0.20). It is configured and is currently running my website.
I have installed both MySQL 4.1 and 4.0 (not at the same time)
I have installed PHP 5.0.4 and configured it with Abyss X1 2.0.0.20 just as the instructions say. PHP seems to be working fine as I can pull up the install.php for the phpBB software and it will let me input all of the information it requires.
The problem is that when I finish and tell it to install it gives me this error:
"The PHP configuration on your server doesn't support the database type that you chose"
I have tried it with both MySQL versions 4.1 and 4.0 and selected the 4.x setting my phpBB. What am I doing wrong?
Thanks in advance.
Gavin |
|
| Back to top |
   |
 |
AbyssUnderground
-
Joined: 31 Dec 2004
Posts: 3855
|
|
| Back to top |
|
|
aprelium
-
Joined: 22 Mar 2002
Posts: 6800
|
|
| Back to top |
 |
|
SinclairZX81
-
Joined: 25 Jan 2005
Posts: 11
|
| Posted: Sat Nov 05, 2005 12:59 am Post subject: Re: php, phpBB and MySQL |
|
|
I also have tried to install phpBB (the latest rev). Using your recommendation, I have installed PHP 5 and MySQL 4.x. I can get the install to work fine. But when I try to use functions like....
-Log in
-Log out
-Admin Menu
The browser will time out with the message "cannot find server". The odd thing is, if I enter my admin name to log in, let the browser time out, then back up, it says that I have indeed logged in! Same thing for logging out. But other functions, like user profile, register, all see to allow navigation to to those features....any ideas?? |
|
| Back to top |
|
|
AbyssUnderground
-
Joined: 31 Dec 2004
Posts: 3855
|
| Posted: Sat Nov 05, 2005 1:00 am Post subject: |
|
|
You need to go into the admin panel and change the domain to your IP address or if its dynamic to your domain name. This is a common problem.
_________________
Andy (AbyssUnderground) (previously The Inquisitor)
www.abyssunderground.co.uk |
|
| Back to top |
|
|
SinclairZX81
-
Joined: 25 Jan 2005
Posts: 11
|
| Posted: Sat Nov 05, 2005 3:27 am Post subject: |
|
|
| The Inquisitor wrote: | | You need to go into the admin panel and change the domain to your IP address or if its dynamic to your domain name. This is a common problem. |
Inquisitor,
Thats just it. I cannot get to the admin panel (if you mean the one in PHPBB). My IP is dynamic. I am using no-ip with a port 80 redirect. When I set up PHPBB I put in my dns name from no-ip, instead of the dynamic IP address, thinking that if it changed I would be out of luck. I will try to re-install using the IP, but, please let me know if you have any further suggestions, or how to get to the admin panel in a case like this...thanks :) |
|
| Back to top |
|
|
SinclairZX81
-
Joined: 25 Jan 2005
Posts: 11
|
| Posted: Sat Nov 05, 2005 3:58 am Post subject: |
|
|
| The Inquisitor wrote: | | You need to go into the admin panel and change the domain to your IP address or if its dynamic to your domain name. This is a common problem. |
Okay, I went back, and try to reinstall PHPBB. When asked for the domain, I tried to leave it, this time, set to the IP address, instead of the no-ip dns name. When I did that, and tried to install, I get a critical error: Could not connect to database message. Please note: I am use port 9999 instead of 80, that is detected automatically by the install program. Ideas??? |
|
| Back to top |
|
|
SinclairZX81
-
Joined: 25 Jan 2005
Posts: 11
|
| Posted: Sat Nov 05, 2005 5:15 am Post subject: |
|
|
| The Inquisitor wrote: | | You need to go into the admin panel and change the domain to your IP address or if its dynamic to your domain name. This is a common problem. |
...more updates on testing......
I installed the same config on another pc, but "locally" (127.0.0.1), port 80. This goes for Abyss as well (running on port 80). This installation works. So I know the "config" of packages (PHP, MySQL, etc) is good. Could it be the port 9999 redirect? Or, could it have something to do with the PHPBB install not accepting the IP instead of the dns name from no-ip?? |
|
| Back to top |
|
|
AbyssUnderground
-
Joined: 31 Dec 2004
Posts: 3855
|
| Posted: Sat Nov 05, 2005 10:19 am Post subject: |
|
|
You need to use your no-ip name otherwise it will only work on localhost.
_________________
Andy (AbyssUnderground) (previously The Inquisitor)
www.abyssunderground.co.uk |
|
| Back to top |
|
|
SinclairZX81
-
Joined: 25 Jan 2005
Posts: 11
|
| Posted: Sat Nov 05, 2005 4:50 pm Post subject: |
|
|
| The Inquisitor wrote: | | You need to use your no-ip name otherwise it will only work on localhost. |
That is the way I have been installing it. PHPBB will only let me install using the no-ip name. That is where I am at right now, with the problem I've been having. I have a Cisco modem which does NAT, and a Linksys wireless router. I have opened the port up on the modem to allow traffic from port 9999 so my web server works. I've also done the same for the router, as far as port forwarding.
The thought just occurred to me: When I set up MySQL, it said it needed port 3306. And norton firewall threw up a flag when it tried to start the service. I let it go ahead, but, does this port also need to be opened in the NAT of the modem and router? Also, do you know if, when the server is running, I should be able to see it using the web site www.canyouseeme.org ?? |
|
| Back to top |
|
|
AbyssUnderground
-
Joined: 31 Dec 2004
Posts: 3855
|
| Posted: Sat Nov 05, 2005 4:52 pm Post subject: |
|
|
You need to forward all the ports for all the services and yes you should be able to access it with your domain but you should install using your main domain (if you have one) not the no-ip address.
_________________
Andy (AbyssUnderground) (previously The Inquisitor)
www.abyssunderground.co.uk |
|
| Back to top |
|
|
jibbajabba
-
Joined: 06 Sep 2005
Posts: 241
Location: England, Doncaster
|
| Posted: Sat Nov 05, 2005 5:19 pm Post subject: |
|
|
do you have the no-ip DUC software.. it what i use to automatically update my ip since my ip changes everytime i disconnect and reconnect to the net.. i do sometimes have to wait a few minutes or maybe abit longer for it to update my ip but you should be able to enter your no-ip domain in the phpbb install aslong as no-ip has your updated ip
if you don't have the no-ip DUC software you can get it here.. its free to download and use
http://www.no-ip.com/downloads.php
_________________
http://www.jibba-jabba.net | http://www.mosthauntedforum.com
Last edited by jibbajabba on Sat Nov 05, 2005 5:22 pm; edited 1 time in total |
|
| Back to top |
|
|
AbyssUnderground
-
Joined: 31 Dec 2004
Posts: 3855
|
| Posted: Sat Nov 05, 2005 5:20 pm Post subject: |
|
|
| jibbajabba wrote: | | do you have the no-ip DUC software.. it what i use to automatically update my ip since my ip changes everytime i disconnect and reconnect to the net.. i do sometimes have to wait a few minutes or maybe abit longer for it to update my ip but you should be able to enter your no-ip domain in the phpbb install aslong as no-ip has your updated ip |
But then when you try to access with your normal .com or such it wont work. I know because Ive had these problems myself.
_________________
Andy (AbyssUnderground) (previously The Inquisitor)
www.abyssunderground.co.uk |
|
| Back to top |
|
|
jibbajabba
-
Joined: 06 Sep 2005
Posts: 241
Location: England, Doncaster
|
| Posted: Sat Nov 05, 2005 5:35 pm Post subject: |
|
|
well off course if you have a .com .net or any other domain then you enter that in the phpbb installation.. what you have to do then is to setup your real domain to use the no-ip domain so your real domain goes to the website/phpbb
for example this is what i use so my real domain goes to my website
www 10 cname something.no-ip.com.
i'll shut up now i'm making myself confused lol
_________________
http://www.jibba-jabba.net | http://www.mosthauntedforum.com |
|
| Back to top |
|
|
AbyssUnderground
-
Joined: 31 Dec 2004
Posts: 3855
|
| Posted: Sat Nov 05, 2005 5:36 pm Post subject: |
|
|
Chances are the domain will already be set up otherwise he wouldnt have the domain...
Maybe you should be quiet!! lol
_________________
Andy (AbyssUnderground) (previously The Inquisitor)
www.abyssunderground.co.uk |
|
| Back to top |
|
|
SinclairZX81
-
Joined: 25 Jan 2005
Posts: 11
|
| Posted: Sat Nov 05, 2005 5:59 pm Post subject: |
|
|
| The Inquisitor wrote: | Chances are the domain will already be set up otherwise he wouldnt have the domain...
Maybe you should be quiet!! lol |
Sorry to cause all the fuse :). I opened up port 3306. I did this in the modem (Cisco 677), for tcp data. I also added the port forwarding in the linksys for the same port, for all protocals. Rebooted the modem, and had the same result. :( I verified that I could see the open port 3306 on using the canyouseeme site. Yes, I do have the NO-IP software applet running upon start up to update no-ip.com with my chosen domain from them.
This setup is running on a home pc. My isp is blocking port 80, so I am using port 9999 for the web server (Abyss). I'm using no-ip for my domain. My site right now is: rcfun.no-ip.org If I go to the site the web server works fine. If I try somthing like http://rcfun-no-ip.org/phpbb2/index.php I can get to the board.
When I installed PHPBB, I loaded rcfun-no-ip.org in place of the IP address it detected, and left the detected port 9999. Sorry to provide "information overload" but I thought it might help determine the problem........any other ideas??? |
|
| Back to top |
|
|
SinclairZX81
-
Joined: 25 Jan 2005
Posts: 11
|
| Posted: Sat Nov 05, 2005 6:06 pm Post subject: |
|
|
| The Inquisitor wrote: | Chances are the domain will already be set up otherwise he wouldnt have the domain...
Maybe you should be quiet!! lol |
From a "programmers" perspective, are there any logs I can check to see what each of the servers (PHP or MySql, PHPBB) are doing, or the errors they have encountered?? |
|
| Back to top |
|
|
jibbajabba
-
Joined: 06 Sep 2005
Posts: 241
Location: England, Doncaster
|
|
| Back to top |
|
|
SinclairZX81
-
Joined: 25 Jan 2005
Posts: 11
|
| Posted: Sun Nov 06, 2005 3:46 am Post subject: |
|
|
Thanks for correcting the link.....here is another question......
I'm using MySQL Front to configure the users and such in MySQL. For PHPBB what rights options does a user need? Also, if port 3306 is really open on the server for MySQL, shouldn't I be able to connect to it from my other PC, if I use the proper user name and password? The reason I ask this, is I get an access denied message from MySQL Front when I try and do this. The other odd thing I notice is that when I try to log in to PHPBB, if I use the WRONG password, the script will come back and tell me as such. Its when I use the right password that the browser says it cannot display the page. Does this indicate a port issue with MySQL? To me it sounds like PHP is working........ Another question, when I look at mySQL Front it says the host that is present is "Localhost". Do I need to add a host rcfun.no-ip.org to mySQL?? confuse...... |
|
| Back to top |
|
|
jibbajabba
-
Joined: 06 Sep 2005
Posts: 241
Location: England, Doncaster
|
|
| Back to top |
|
|
SinclairZX81
-
Joined: 25 Jan 2005
Posts: 11
|
| Posted: Mon Nov 07, 2005 10:36 pm Post subject: |
|
|
| jibbajabba wrote: | | i wouldn't have a clue as i've only just started using php and mysql for my website and phpbb and that. |
I think I found the problem. It looks like it is definitely the no-ip.org routing. I re-installed PHPBB just using my currently dynamic IP. Doing this makes everything work. I'm thinking of just writing either a VFP program or Winbatch program to pull the IP address on start up and then update the MySQL Config table PHPBB uses with the current IP in the server_name field of the phpbb_config table. Might even be able to do this with a PHP script I think...... |
|
| Back to top |
|
|
|
