dynamic ip address & apache

[xyle_one]

I'm not sure what you mean by adding modules to the user. Do you mean database permissions? I just created a database "forums" and a user "forums@localhost" and put a password on it, no permissions. Then used that information in the phpBB configuration.

nevermind
i created a databse called "artforms" but i did not see an option to create a user.
(edit: playing around some more)
under postgreSQL i was able to create a database called 'forum" & a user "forum".

[Void Main]

Ok, one more thing you are going to need. You will need to edit the FORUMHOME/includes/page_header.php. Near the bottom of the page you will find a couple of lines that look like this:

Code: Select all

header ('Expires: ' . gmdate('D, d M Y H:i:s', time()) . ' GMT');
header ('Last-Modified: ' . gmdate('D, d M Y H:i:s') . ' GMT');


Comment those two lines out and add the following lines right below them:

Code: Select all

header ('Pragma: no-cache');
header ('Cache-Control: no-cache, no-store, must-revalidate');
header ('Last-Modified: ' . gmdate('D, d M Y H:i:s') . ' GMT');
header ('Expires: ' . gmdate('D, d M Y H:i:s', time()) . ' GMT');


Your BBS will not work properly until you do this (only a problem on Apache 2.x).

[xyle_one]

for the config i used the postgreSql 7.x database type. after i press install, it says "The PHP configuration on your server doesnt support the database that you chose". but if i choose mysql it cant connect (no user ??? )
thanks for the help by the way

[Void Main]

Well I gotta tell you that I use PostgreSQL for most everything, however I had trouble trying to get the phpBB installed on PosgreSQL. I had no trouble getting it installed on MySQL. MySQL is usually faster than PostgreSQL for small databases like this anyway.

[xyle_one]

well i created a user ecsyle@localhost for mysql, but i can not connect to the database.

[Void Main]

Can you connect to the database on the command line?

$ mysql -u user -h localhost database -p

And

$ mysqlshow -u user -h localhost database -p

[xyle_one]

no. access denied.

[xyle_one]

i have a user setup "ecsyle" with a password, no permissions. i restarted the sql server, and still nothing.

[Void Main]

You *do* have mysql-server installed right? And it *is* started right? I'm trying to think if there is anything I changed to the setup from a default install and I don't believe I did. Are there any messages in the /var/log/mysqld.log file? Reset the password in webmin just to make sure... Also you might try setting the password option to "none" and see if that works (then don't use the "-p" on the command line).

[xyle_one]

its installed and running. here is something wierd. i can connect with the user root and no password. that doesnt sit right to me....

[Void Main]

I'm an idiot, you need to set up database permissions (I just now looked at mine). Right next to the user permissions button, there should be a database permissions button. Click it and do a "create new database permissions" and use the "forums" database with your user id and grant everything to it.

forums | ecsyle | localhost | All

[xyle_one]

should i give the user the same permissions, or just the database permissions?? and, on the phpBB install page, for domain name, should i use ecsyle.is-a-geek.net?? or does it really matter?

[Void Main]

User Permissions:

ecsyle | localhost | o982u34jsdfjo | None

[xyle_one]

Very nice. Thaks Void Main. now its time to add some content.

[xyle_one]

this kinda sucks. im at work, and tried to go to my site, and now its asking for a user name & password. shitty.