Welcome to ISAserver.org

PHPBB bulletin Board/forum

Users viewing this topic: none

Logged in as: Guest

Printable Version

All Forums >> [ISA Server 2000 General] >> Server Publishing >> PHPBB bulletin Board/forum

Page: [1] 2 next > >>

Message

<< Older Topic Newer Topic >>

PHPBB bulletin Board/forum - 10.Jan.2003 7:47:00 PM

Kaj Drost

Posts: 167
Joined: 9.Jul.2002
From: Netherlands
Status: offline

Hi all,

Does anyone here know how to get a PHPBB message board available from behind ISA. PHPBB works with MYSQL and I would like to know how to publish this board and maybe even publish MYSQL.
Anyone know about this?

Post #: 1

RE: PHPBB bulletin Board/forum - 11.Jan.2003 9:55:00 AM

jmjarvis

Posts: 136
Joined: 17.Jun.2002
From: UK
Status: offline

Kaj,

I have an Invision board published which also uses MySQL as its back end. [Smile]

You need to reverse publish it with a Web Publishing rule. There are some great articles on how to do this on this site. Start with these two:

http://www.isaserver.org/tutorials/A_Web_Site_Using_ISA_Server_Part_1_Preparing_To_Publish_Your_Site.html

http://www.isaserver.org/tutorials/Publishing_A_Web_Site_Using_ISA_Server_Part_2.html

If you have any problems then give me a shout.

HTH

Jas

(in reply to Kaj Drost)

Post #: 2

RE: PHPBB bulletin Board/forum - 11.Jan.2003 10:49:00 AM

Kaj Drost

Posts: 167
Joined: 9.Jul.2002
From: Netherlands
Status: offline

Hi Jason,

I got it published, thx.
Now I don't know a lot about SQL, but what do I need to do to get a database up in MYSQl. I can access the install page, but I need to specify a database. I tried to fill in test, because it seems to be on MYSQL standard, but when I fill everything in it says cannot connect to database, any ideas?
I am a complete newbie on MYSQL.

(in reply to Kaj Drost)

Post #: 3

RE: PHPBB bulletin Board/forum - 11.Jan.2003 5:26:00 PM

jmjarvis

Posts: 136
Joined: 17.Jun.2002
From: UK
Status: offline

Hey Kaj,

No problem.Take a peek at this:

http://www.mysql.com/doc/en/mysqladmin.html

Its command line but will get you started.

Run phpmyadmin through google too. This allows you to maintain and administer your MySQL databases through the web.

HTH

Jas

[ January 11, 2003, 05:27 PM: Message edited by: Jason Jarvis ]

(in reply to Kaj Drost)

Post #: 4

RE: PHPBB bulletin Board/forum - 11.Jan.2003 6:11:00 PM

Kaj Drost

Posts: 167
Joined: 9.Jul.2002
From: Netherlands
Status: offline

yes I have seen it and I have setup the mysqladmin and it says the server is up, but I cannot connect. Where do i find the prompt to type in these things?

(in reply to Kaj Drost)

Post #: 5

RE: PHPBB bulletin Board/forum - 11.Jan.2003 9:58:00 PM

Kaj Drost

Posts: 167
Joined: 9.Jul.2002
From: Netherlands
Status: offline

Ok I found, major Duh, just the command prompt [Smile]

)

But it still says that it cannot connect to the database, what am I doing wrong?

(in reply to Kaj Drost)

Post #: 6

RE: PHPBB bulletin Board/forum - 11.Jan.2003 10:00:00 PM

jmjarvis

Posts: 136
Joined: 17.Jun.2002
From: UK
Status: offline

Hey Kaj,

Was just about to explain when I scrolled down to find you'd replied with the last few seconds. [Big Grin]

So just to confirm are you running the commands on the machine where mysql is installed or another ?

Jas

(in reply to Kaj Drost)

Post #: 7

RE: PHPBB bulletin Board/forum - 11.Jan.2003 10:11:00 PM

jmjarvis

Posts: 136
Joined: 17.Jun.2002
From: UK
Status: offline

Hey Kaj,

Finally reminded myself of a GUI that will help - mysqlmanager.exe. Should be in the mysql directory. Any problems then give me a shout.

HTH

Jas

(in reply to Kaj Drost)

Post #: 8

RE: PHPBB bulletin Board/forum - 11.Jan.2003 11:09:00 PM

Kaj Drost

Posts: 167
Joined: 9.Jul.2002
From: Netherlands
Status: offline

Hi jason

Can't seem to locate mysqlmanager.exe.
I have the databse up, at least the program says so. Do I need to open prts to connect to it?
Or do I need to fill the database with info, the MYSQl databse has a lot of lines, users etc, the forum daatbase is empty, what should I do?

(in reply to Kaj Drost)

Post #: 9

RE: PHPBB bulletin Board/forum - 13.Jan.2003 4:29:00 PM

jmjarvis

Posts: 136
Joined: 17.Jun.2002
From: UK
Status: offline

Hey Kaj,

Are the SQL server and IIS server on the same network and inside of ISA ?

Jas

(in reply to Kaj Drost)

Post #: 10

RE: PHPBB bulletin Board/forum - 14.Jan.2003 10:18:00 AM

Kaj Drost

Posts: 167
Joined: 9.Jul.2002
From: Netherlands
Status: offline

Hi jason,

Yes both are on the same machine even.
If you want you can take a look:

http:www.moralltach.d2g.biz/install.php

a database should be up test, mysql or forum.
If you have suggestions, feel free to spill them here.

(in reply to Kaj Drost)

Post #: 11

RE: PHPBB bulletin Board/forum - 14.Jan.2003 11:14:00 AM

jmjarvis

Posts: 136
Joined: 17.Jun.2002
From: UK
Status: offline

Hey Kaj,

If the mysql and IIS are on the inside of ISA then you don't need to open up any ports.

I'd suggest picking the Forum database as its empty and has a descriptive name for its purpose. You can clean up old databases later.

When you installed mysql it asks you for a username and password. Think its root or something like this as default if I remember.

Just out of curiosity what topics are you going to run with ? I have one up and running but with Invision Board (Seriously recommend this one to anyone) [Big Grin]

HTH,

Jas

(in reply to Kaj Drost)

Post #: 12

RE: PHPBB bulletin Board/forum - 14.Jan.2003 12:28:00 PM

Kaj Drost

Posts: 167
Joined: 9.Jul.2002
From: Netherlands
Status: offline

Ok jason,

So I have to use the usernmae and password provided when I installed MYSQl and the username and password to connect to the database?
and what should I fill in at the administrator name and password, or is that something I can make up now?
How did you see the forum datbase was empty?
Did you check the page.
All help appreciated.
I am not yet sure what to publish there. I would have to get it up and running first.

(in reply to Kaj Drost)

Post #: 13

RE: PHPBB bulletin Board/forum - 14.Jan.2003 1:07:00 PM

Kaj Drost

Posts: 167
Joined: 9.Jul.2002
From: Netherlands
Status: offline

Hi jason,

I got it to wrok, had to do with the username and password I provided that were wrong. (major Duh)

Now that I got it working, I checked the email function from within the board. I fails to send an email because the connection to the smtp server is timed out. Do i need to do something special or should it just work?

(in reply to Kaj Drost)

Post #: 14

RE: PHPBB bulletin Board/forum - 14.Jan.2003 1:57:00 PM

jmjarvis

Posts: 136
Joined: 17.Jun.2002
From: UK
Status: offline

Hey Kaj,

Where is the SMTP server that the board software is trying to talk to ?

Jas.

(in reply to Kaj Drost)

Post #: 15

RE: PHPBB bulletin Board/forum - 14.Jan.2003 4:01:00 PM

Kaj Drost

Posts: 167
Joined: 9.Jul.2002
From: Netherlands
Status: offline

Hi jason,

The SMTP server is not my own but the server from my provider, which is ofcourse on the other side of my ISA server. I was wondering I should do something special, because my forum on my internal network card.
Any ideas?

(in reply to Kaj Drost)

Post #: 16

RE: PHPBB bulletin Board/forum - 14.Jan.2003 4:18:00 PM

jmjarvis

Posts: 136
Joined: 17.Jun.2002
From: UK
Status: offline

Hey Kaj,

You'll need to create a protocol rule for SMTP (port 25) on your ISA to allow this through.

Are you using an internal SMTP relay or have you specified the IP address of the ISP smart host in the board config ?

Jas

(in reply to Kaj Drost)

Post #: 17

RE: PHPBB bulletin Board/forum - 14.Jan.2003 4:37:00 PM

Kaj Drost

Posts: 167
Joined: 9.Jul.2002
From: Netherlands
Status: offline

Ok,

I use mail from behind my firewall on multiple computers and there it runs smoothly. So where do I configure SMTP relay?
I just entered the SMtp.xxx.xxx.nl
But it won't send emails. :(9

(in reply to Kaj Drost)

Post #: 18

RE: PHPBB bulletin Board/forum - 15.Jan.2003 1:24:00 PM

Kaj Drost

Posts: 167
Joined: 9.Jul.2002
From: Netherlands
Status: offline

Hi jason,

Tried all the option with mail from the PHPBB board, but it juts won't send, even tried typing the SMTP server IP adrss, but still no luck, can you tell me how PHPBB handles it's email?

(in reply to Kaj Drost)

Post #: 19

RE: PHPBB bulletin Board/forum - 15.Jan.2003 2:29:00 PM