[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