PHPBB bulletin Board/forum (Full Version)

All Forums >> [ISA Server 2000 General] >> Server Publishing



Message

Kaj Drost -> PHPBB bulletin Board/forum (10.Jan.2003 7:47:00 PM)

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?



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

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



Kaj Drost -> RE: PHPBB bulletin Board/forum (11.Jan.2003 10:49:00 AM)

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.



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

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 ]



Kaj Drost -> RE: PHPBB bulletin Board/forum (11.Jan.2003 6:11:00 PM)

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?



Kaj Drost -> RE: PHPBB bulletin Board/forum (11.Jan.2003 9:58:00 PM)

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?



jmjarvis -> RE: PHPBB bulletin Board/forum (11.Jan.2003 10:00:00 PM)

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



jmjarvis -> RE: PHPBB bulletin Board/forum (11.Jan.2003 10:11:00 PM)

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



Kaj Drost -> RE: PHPBB bulletin Board/forum (11.Jan.2003 11:09:00 PM)

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?



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

Hey Kaj,

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

Jas



Kaj Drost -> RE: PHPBB bulletin Board/forum (14.Jan.2003 10:18:00 AM)

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.



jmjarvis -> RE: PHPBB bulletin Board/forum (14.Jan.2003 11:14:00 AM)

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] [Big Grin]

HTH,

Jas



Kaj Drost -> RE: PHPBB bulletin Board/forum (14.Jan.2003 12:28:00 PM)

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.



Kaj Drost -> RE: PHPBB bulletin Board/forum (14.Jan.2003 1:07:00 PM)

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?



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

Hey Kaj,

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

Jas.



Kaj Drost -> RE: PHPBB bulletin Board/forum (14.Jan.2003 4:01:00 PM)

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?



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

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



Kaj Drost -> RE: PHPBB bulletin Board/forum (14.Jan.2003 4:37:00 PM)

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



Kaj Drost -> RE: PHPBB bulletin Board/forum (15.Jan.2003 1:24:00 PM)

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?



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

Hey Kaj,

I don't have PHPbb as I use Invision Board but I would imagine it uses sendmail.

Bear with me and I'll take a look.

Back in a bit.

Jas



Page: [1] 2   next >   >>