dynamic ip address & apache

Discuss Networking
User avatar
xyle_one
programmer
programmer
Posts: 129
Joined: Mon Jan 13, 2003 1:02 pm
Contact:

Post by xyle_one »

Void Main wrote: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 :oops:
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".

User avatar
Void Main
Site Admin
Site Admin
Posts: 5716
Joined: Wed Jan 08, 2003 5:24 am
Location: Tuxville, USA
Contact:

Post by 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).

User avatar
xyle_one
programmer
programmer
Posts: 129
Joined: Mon Jan 13, 2003 1:02 pm
Contact:

Post by 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 :P

User avatar
Void Main
Site Admin
Site Admin
Posts: 5716
Joined: Wed Jan 08, 2003 5:24 am
Location: Tuxville, USA
Contact:

Post by 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.

User avatar
xyle_one
programmer
programmer
Posts: 129
Joined: Mon Jan 13, 2003 1:02 pm
Contact:

Post by xyle_one »

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

User avatar
Void Main
Site Admin
Site Admin
Posts: 5716
Joined: Wed Jan 08, 2003 5:24 am
Location: Tuxville, USA
Contact:

Post by 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

User avatar
xyle_one
programmer
programmer
Posts: 129
Joined: Mon Jan 13, 2003 1:02 pm
Contact:

Post by xyle_one »

no. access denied.

User avatar
xyle_one
programmer
programmer
Posts: 129
Joined: Mon Jan 13, 2003 1:02 pm
Contact:

Post by xyle_one »

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

User avatar
Void Main
Site Admin
Site Admin
Posts: 5716
Joined: Wed Jan 08, 2003 5:24 am
Location: Tuxville, USA
Contact:

Post by 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).

User avatar
xyle_one
programmer
programmer
Posts: 129
Joined: Mon Jan 13, 2003 1:02 pm
Contact:

Post by 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....

User avatar
Void Main
Site Admin
Site Admin
Posts: 5716
Joined: Wed Jan 08, 2003 5:24 am
Location: Tuxville, USA
Contact:

Post by 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

User avatar
xyle_one
programmer
programmer
Posts: 129
Joined: Mon Jan 13, 2003 1:02 pm
Contact:

Post by 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?

User avatar
Void Main
Site Admin
Site Admin
Posts: 5716
Joined: Wed Jan 08, 2003 5:24 am
Location: Tuxville, USA
Contact:

Post by Void Main »

User Permissions:

ecsyle | localhost | o982u34jsdfjo | None

User avatar
xyle_one
programmer
programmer
Posts: 129
Joined: Mon Jan 13, 2003 1:02 pm
Contact:

Post by xyle_one »

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

User avatar
xyle_one
programmer
programmer
Posts: 129
Joined: Mon Jan 13, 2003 1:02 pm
Contact:

Post by 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.

Post Reply