| View previous topic :: View next topic |
| Author |
Message |
feamsr00
-
Joined: 04 Jun 2002
Posts: 138
Location: Phila PA
|
 Posted: Tue Jun 25, 2002 4:55 am Post subject: mysql |
 |
|
I am very confused about mysql, it does not seem to work 4 me, all I get to is making a db, but it always says it cant connect. Can anyone point me to a walk through or help me themselves?
If anyknows of a msg board that doesnt need mysql that would be great too. |
|
| Back to top |
       |
 |
TheLinker
-
Joined: 05 Apr 2002
Posts: 165
Location: Oslo, Norway
|
| Posted: Tue Jun 25, 2002 5:43 am Post subject: Re: mysql |
|
|
| feamsr00 wrote: | I am very confused about mysql, it does not seem to work 4 me, all I get to is making a db, but it always says it cant connect. Can anyone point me to a walk through or help me themselves?
If anyknows of a msg board that doesnt need mysql that would be great too. |
phpBB doesn't require MySQL to work... |
|
| Back to top |
|
|
feamsr00
-
Joined: 04 Jun 2002
Posts: 138
Location: Phila PA
|
| Posted: Tue Jun 25, 2002 7:11 am Post subject: |
|
|
| how? its wont let you continue the instalatoin with out filling out the database part of the form |
|
| Back to top |
|
|
TheLinker
-
Joined: 05 Apr 2002
Posts: 165
Location: Oslo, Norway
|
| Posted: Tue Jun 25, 2002 1:21 pm Post subject: |
|
|
| feamsr00 wrote: | | how? its wont let you continue the instalatoin with out filling out the database part of the form |
In Windows environment phpBB supports both Microsoft SQL Server 7/2000 and Microsoft Access (via ODBC).
You can find more on phpBB features on this link: http://www.phpbb.com/features.php |
|
| Back to top |
|
|
feamsr00
-
Joined: 04 Jun 2002
Posts: 138
Location: Phila PA
|
| Posted: Tue Jun 25, 2002 3:20 pm Post subject: |
|
|
| ok correction, i have NO DBs installed, is there a board that will NOT need a DB? |
|
| Back to top |
|
|
TheLinker
-
Joined: 05 Apr 2002
Posts: 165
Location: Oslo, Norway
|
| Posted: Tue Jun 25, 2002 3:51 pm Post subject: Windows version ?? |
|
|
| feamsr00 wrote: | | ok correction, i have NO DBs installed, is there a board that will NOT need a DB? |
What version of Windows do you run ?? ... Both on Windows XP and Windows 2000 (and I guess also for Windows 98/ME) there is an ODBC icon on your control panel... because phpBB supports Access databases through ODBC, you can use the included Access datafile in phpBB. This means that you don't need a database server, only the included files in the phpBB archive.
However, this is not a recommended solution if you expect heavy traffic on your board... |
|
| Back to top |
|
|
feamsr00
-
Joined: 04 Jun 2002
Posts: 138
Location: Phila PA
|
| Posted: Tue Jun 25, 2002 4:29 pm Post subject: |
|
|
ok, I THINK I see what you are saying, but how exactly is odbc configured to serve, or is it for phpbb to use whatever ODBC is using?
I run W98SE(4.10.2222) and W2K:AS(5.00.2195)SP1 |
|
| Back to top |
|
|
TheLinker
-
Joined: 05 Apr 2002
Posts: 165
Location: Oslo, Norway
|
| Posted: Tue Jun 25, 2002 6:24 pm Post subject: |
|
|
| feamsr00 wrote: | ok, I THINK I see what you are saying, but how exactly is odbc configured to serve, or is it for phpbb to use whatever ODBC is using?
I run W98SE(4.10.2222) and W2K:AS(5.00.2195)SP1 |
Open Database Connectivity (ODBC) is an application programming interface (API) for database access. This means that you must have an ODBC driver for whatever database connection you want to use, in this case an Access driver.
If you click on the ODBC icon in your Control Panel, you will open the configuration panel for ODBC. Click the Add... button. Here you will see a list over installed ODBC drivers on your computer, and among them is Microsoft Access Driver.
If you follow the install guide for phpBB, they will guide you through the process of making an successfull ODBC database through the Microsoft Access Driver. The needed Access databasefile is included in the phpBB archive. |
|
| Back to top |
|
|
feamsr00
-
Joined: 04 Jun 2002
Posts: 138
Location: Phila PA
|
| Posted: Tue Jun 25, 2002 7:19 pm Post subject: |
|
|
| phpBB User's Guide wrote: | | Before you install phpBB 2.0, you need to create a Data Source Name. The exact way to do this will depend on your hosting provider; if you are unsure you should check with them before proceeding. |
Now if i am my own host, what am i supposed to know???
Last edited by feamsr00 on Wed Jun 26, 2002 3:34 am; edited 2 times in total |
|
| Back to top |
|
|
aprelium
-
Joined: 22 Mar 2002
Posts: 6800
|
| Posted: Wed Jun 26, 2002 12:36 am Post subject: |
|
|
| feamsr00 wrote: | | [quote=phpBB Users Guide]Before you install phpBB 2.0, you need to create a Data Source Name. The exact way to do this will depend on your hosting provider; if you are unsure you should check with them before proceeding. |
Now if i am my own host, what am i supposed to know???[/quote]
You musr run mysql command line and create manually a database. More information about the SQL commands can be found in the MySQL documentation.
_________________
Support Team
Aprelium - http://www.aprelium.com |
|
| Back to top |
 |
|
TheLinker
-
Joined: 05 Apr 2002
Posts: 165
Location: Oslo, Norway
|
| Posted: Wed Jun 26, 2002 7:36 am Post subject: |
|
|
| feamsr00 wrote: | | phpBB User's Guide wrote: | | Before you install phpBB 2.0, you need to create a Data Source Name. The exact way to do this will depend on your hosting provider; if you are unsure you should check with them before proceeding. |
Now if i am my own host, what am i supposed to know??? |
That is correct... and the rest of the install guide, reads:
In general though you should create a System DSN which points to the location where you have stored an unarchived copy of the ms_access_primer.mdb file (this is contained in the ms_access_primer.zip which can be found in db/schemas/). The name you give this DSN will be used during installation.
This step-by-step guide will help you create your ODBC.
1. Open the ODBC config program in your control panel.
2. Click the System DSN tab.
3. Click the Add... button and select Microsoft Access Driver.
4. Write phpBB in Data Source Name: textfield.
5. Click the Select... button and located the included ms_access_primer.mdb access file in the phpBB archive.
During the installation process of phpBB, you must select ODBC Access Database as your database for the forum. In the database hostname field, you enter phpBB.
This should create the need configuration data in the forum, and you should be able to continue the installation process...
Regards... :) |
|
| Back to top |
|
|
feamsr00
-
Joined: 04 Jun 2002
Posts: 138
Location: Phila PA
|
| Posted: Fri Jul 05, 2002 6:48 pm Post subject: |
|
|
| Thank you for that. I have been using it for a couple weeks now and it works fine in testing. However when I put it to some use in sept, Im not liking the prospect of only a few users at once. Mysql seems to be working corectly on my system. Im using the 3.23.51-max-nt verision and using MyCC as a nice frontend. From there at least, evertying is in working order. So why is it nothing connects? |
|
| Back to top |
|
|
gengar56
-
Joined: 02 Aug 2002
Posts: 15
|
| Posted: Sun Aug 25, 2002 11:38 pm Post subject: |
|
|
There is a limit on the number of users when using ODBC? What is it?
_________________
New user of Abyss Web Server |
|
| Back to top |
|
|
|
