[wplug] MySQL and phpBBS

Wise, Jeremey jeremey.wise at agilysys.com
Mon Nov 28 16:58:01 EST 2005


Well update .. I just figured "what the heck" and tried to point to the
default "test" database and use the credentials of the master DBA admin
account (which I made as msdba ->old Microsoft sql habit:P ) and it
succeded. 

Sooooo.... uh... now I have it up.. but done wrong. I will post once I
monkey around to figure out how to correct apparently how I am creating
the database or phpBB installation.

-----Original Message-----
From: wplug-bounces+jeremey.wise=agilysys.com at wplug.org
[mailto:wplug-bounces+jeremey.wise=agilysys.com at wplug.org] On Behalf Of
Wise, Jeremey
Sent: Monday, November 28, 2005 4:48 PM
To: General user list
Subject: RE: [wplug] MySQL and phpBBS

So I installed php-mysql
mysql-3.23.58-16.FC3.1
php-mysql-4.3.11-2.8
mysql-server-3.23.58-16.FC3.1

I got farther this time and based on the error I am now getting:
"phpBB:Critical Error Could not connect to the database"

I thought it was a ODBC connection issue. So I installed 
unixODBC-2.2.9-1
MyODBC-2.50.39-25.FC3.1

And modify /etc/odbc.ini 
[root at venus /]# cat /etc/odbc.ini
[mywebsite]
Description     = MySQL mywebsite database
Driver          = MySQL
Server          = localhost
Database        = mywebsite
Port            = 3306

[test]
Description     = MySQL test database
Driver          = MySQL
Server          = localhost
Database        = test
Port            = 3306

This should have allowed me to test the database access to verify that
the ODBC listener was functioning:
isql test test
[ISQL]ERROR: Could not SQLConnect

So I tried the local test via:
[root at venus /]# mysqlcheck test
[root at venus /]# mysqlcheck mywebsite

Then:
[root at venus /]# mysql -u mywebsite
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 43 to server version: 3.23.58

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> select version();
+-----------+
| version() |
+-----------+
| 3.23.58   |
+-----------+
1 row in set (0.00 sec)

mysql>

So I am figured the database was ok and the engine was ok. The only
thing left was that that the ODBC listener was ok.

[root at venus /]# telnet localhost 3306
Trying 127.0.0.1...
Connected to localhost.localdomain (127.0.0.1).
Escape character is '^]'.
(
3.23.58,6ajniCU_,


Which means the listener is up and active. Now I am running out of
ideas.

-----Original Message-----
From: wplug-bounces+jeremey.wise=agilysys.com at wplug.org
[mailto:wplug-bounces+jeremey.wise=agilysys.com at wplug.org] On Behalf Of
Drew from Zhrodague
Sent: Monday, November 28, 2005 11:54 AM
To: General user list
Subject: RE: [wplug] MySQL and phpBBS

> Fedora Core release 3 (Heidelberg)
>
> And I looked into a few articles about enabling phpMySQL client and it
> looks a but complex. http://us3.php.net/mysqli
>
> There seems to be a few front ends for management of this but they are
> all referring to MySQL4 or greater which FC3 does not support.
> http://www.phpmyadmin.net/home_page/index.php
>
> And there are reasons I went with FC3 at the time (clustering was the
> primary reason).

 	yum install php-mysql

you could also

 	rpm -qa | grep mysql

and

 	rpm -qa | grep php

to see which things you have installed. I find it easier to use 
already-installed bits of Red Hat flavored things, rather than building 
from source.

 	YOu shouldn't have to worry about those things with phpBB,
though 
I will warn you that kiddies will pwn your box within minutes unless you

take steps to secure yourself -- I've been barraged with
porn-referer-spam 
over the last two weeks for b2evolution. They request like 500k pages
all 
at once, which drags my box into the ground, with the referer page being

some porn spam crap. I replaced b2e with a single google ad.


-- 

Drew from Zhrodague
drew at zhrodague.net
http://www.WiFiMaps.com
http://moblog.zhrodague.net
_______________________________________________
wplug mailing list
wplug at wplug.org
http://www.wplug.org/mailman/listinfo/wplug

_______________________________________________
wplug mailing list
wplug at wplug.org
http://www.wplug.org/mailman/listinfo/wplug



More information about the wplug mailing list