phpBB help

  • butlerboy99
  • Beginner
  • Beginner
  • User avatar
  • Joined: Nov 18, 2003
  • Posts: 60
  • Loc: WA
  • Status: Offline

Post November 24th, 2003, 5:09 pm

I have a website with a forum all ready to go, but I cant figure out how to create a mysql database. I know my host allows it, and I know how to create one. My problem is that my host allows many different types of ODBC drivers, and I can't figure out which one I need to use, what to enter in the "add" page, and which entries correspond to the install page for phpBB. I copied the pages from my webserver and fixed all the links, so you can look at what I'm trying to do. I only included pages for SQL Server, MySQL, and MySQL ODBC 3.51 Driver, so those are the only one that the links work on. I posted the pages here, and any help would be greatly appreciated.
  • Anonymous
  • Bot
  • No Avatar
  • Joined: 25 Feb 2008
  • Posts: ?
  • Loc: Ozzuland
  • Status: Online

Post November 24th, 2003, 5:09 pm

  • ATNO/TW
  • Super Moderator
  • Super Moderator
  • User avatar
  • Joined: May 28, 2003
  • Posts: 23404
  • Loc: Woodbridge VA
  • Status: Offline

Post November 24th, 2003, 5:17 pm

Your host should provide the means to create your database. The phpBB default name for the database is forumdata. Create a MySQL database named forumdata. Your host should also provide the option to add an authorized user for the database. Create a user and password. Then edit your config.php file to make any adjustments to the database name, username and password. Then upload the edited config.php file to your server and run it. That should update everything in less than 2 seconds. You should be ready to roll. There should be no need for ODBC drivers or anything as it is not a DSN-less connection.

If you need to choose, choose a mySQL database.

All this is spelled out very clearly in the install instructions that come with phpBB2
"There's no place like 127.0.0.1 except for ::1."
Alexandria Networks. Leader in IT consulting for associations/non-profits, and small to medium sized businesses around the northern Virginia and Washington D.C. metro area.
  • butlerboy99
  • Beginner
  • Beginner
  • User avatar
  • Joined: Nov 18, 2003
  • Posts: 60
  • Loc: WA
  • Status: Offline

Post November 24th, 2003, 5:23 pm

what I was looking for was someone to look at http://ferndaleband.org/americandiscount/odbc.html and tell me which one to choose, and what to enter in all of the slots. I'm having lots of trouble getting all the general instructions right, so I was looking for very clear and direct help. I have already looked at the intall manual, and it got me as far as I did. I started this project not even knowing about odbc or mysql.
  • ATNO/TW
  • Super Moderator
  • Super Moderator
  • User avatar
  • Joined: May 28, 2003
  • Posts: 23404
  • Loc: Woodbridge VA
  • Status: Offline

Post November 24th, 2003, 5:31 pm

OK -- I thought I was clear, but now I see what you want.

Choose MySQL

I have no clue what to tell you to put in the DSN field - I don't know what they are looking for there.

For the server just type "localhost" (withought the quotation marks)
For the database type "forumdata" w/out the quotes
Description - whatever you want.

See if it will create it without the DSN -- if it doesn't check the help or FAQ's at the host and report back what they are looking for there.

That's probably the most ellaborite way to create a database I've ever seen.

Then in the config.php, you should be able to just leave all the defaults.

It would be preferable if they allowed you the ability to create a user and password for the database, but in those form fields that option is not available. Perhaps some other place.
"There's no place like 127.0.0.1 except for ::1."
Alexandria Networks. Leader in IT consulting for associations/non-profits, and small to medium sized businesses around the northern Virginia and Washington D.C. metro area.
  • butlerboy99
  • Beginner
  • Beginner
  • User avatar
  • Joined: Nov 18, 2003
  • Posts: 60
  • Loc: WA
  • Status: Offline

Post November 24th, 2003, 5:35 pm

the dsn, as far as I can tell, is simply the name of the database. The company itself has absalutely no support, and no help forums or knowledge base. They have a spot for one, but it's completely empty. I guess thats what you get when your host is American Discount Web Hosting!
  • butlerboy99
  • Beginner
  • Beginner
  • User avatar
  • Joined: Nov 18, 2003
  • Posts: 60
  • Loc: WA
  • Status: Offline

Post November 24th, 2003, 5:43 pm

ah, it says on the installation page, Database Server Hostname/ DSN on the very first field, is this possibly what they're looking for?
  • ATNO/TW
  • Super Moderator
  • Super Moderator
  • User avatar
  • Joined: May 28, 2003
  • Posts: 23404
  • Loc: Woodbridge VA
  • Status: Offline

Post November 24th, 2003, 5:53 pm

DSN shouldn't be required for a SQL database. This from my own host's instructions for the field:

Quote:
This field is for choosing the data source name you wish to use. A DSN is essentially a symbolic link on the server pointing to your database file. This field is not required for SQL.


You should be able to create a SQL database without a DSN.

All phpBB2 needs to know is the location of the host of the SQL server which by default is typically localhost, the name of the database, which you need to create forumdata, and an authorized user and password for the database. If you don't have the option to create an authorized user the default user and password info in the config.php file should access the database.
"There's no place like 127.0.0.1 except for ::1."
Alexandria Networks. Leader in IT consulting for associations/non-profits, and small to medium sized businesses around the northern Virginia and Washington D.C. metro area.
  • butlerboy99
  • Beginner
  • Beginner
  • User avatar
  • Joined: Nov 18, 2003
  • Posts: 60
  • Loc: WA
  • Status: Offline

Post November 24th, 2003, 6:17 pm

well, it says on the top of the installation page, If you are installing to a database that uses ODBC, e.g. MS Access you should first create a DSN for it before proceeding. When I'm creating a MySQL Server, it's under the ODBC section, so maybe that has something to do with it. My server wont allow me to create a MySQL Database without a DSN. Should I create some sort of Microsoft server like MS Access or Ms SQL Server?
  • ATNO/TW
  • Super Moderator
  • Super Moderator
  • User avatar
  • Joined: May 28, 2003
  • Posts: 23404
  • Loc: Woodbridge VA
  • Status: Offline

Post November 24th, 2003, 6:24 pm

I'm not sure what to tell you. I just checked the SQL ODBC 3.51 Driver link and I see that one allows you to set up a user. I'd try it first, without the DSN, and set up the user and password and see if that works without the DSN. (SQL shouldn't require an ODBC Driver -- Access needs that, but not SQL)

If that doesn't work, try typing in forumdata in the DSN field and see if that works.

After that I'm out of ideas.
"There's no place like 127.0.0.1 except for ::1."
Alexandria Networks. Leader in IT consulting for associations/non-profits, and small to medium sized businesses around the northern Virginia and Washington D.C. metro area.
  • butlerboy99
  • Beginner
  • Beginner
  • User avatar
  • Joined: Nov 18, 2003
  • Posts: 60
  • Loc: WA
  • Status: Offline

Post November 24th, 2003, 6:30 pm

well, I've tried multiple SQL types, and I've swichedd all the fields around in every combination I can think of. I'll see if I can get a hold of the company. Thanks for your time and help, though
  • ATNO/TW
  • Super Moderator
  • Super Moderator
  • User avatar
  • Joined: May 28, 2003
  • Posts: 23404
  • Loc: Woodbridge VA
  • Status: Offline

Post November 24th, 2003, 6:30 pm

As a side thought -- localhost is typically the default host for sql server, but some hosts are set up to use db.yourdomainname.com (or org or net, whatever)

I just encountered that last week.

You may want to try that for the host if all ese fails.
"There's no place like 127.0.0.1 except for ::1."
Alexandria Networks. Leader in IT consulting for associations/non-profits, and small to medium sized businesses around the northern Virginia and Washington D.C. metro area.
  • ATNO/TW
  • Super Moderator
  • Super Moderator
  • User avatar
  • Joined: May 28, 2003
  • Posts: 23404
  • Loc: Woodbridge VA
  • Status: Offline

Post November 24th, 2003, 6:36 pm

I just noticed...you have an option to turn ODBC service off at the top...what happens when you do that. Do you get different options?
"There's no place like 127.0.0.1 except for ::1."
Alexandria Networks. Leader in IT consulting for associations/non-profits, and small to medium sized businesses around the northern Virginia and Washington D.C. metro area.
  • butlerboy99
  • Beginner
  • Beginner
  • User avatar
  • Joined: Nov 18, 2003
  • Posts: 60
  • Loc: WA
  • Status: Offline

Post November 24th, 2003, 6:45 pm

shutting odbc off simply closes all options and deactivates any databases I have created
  • ATNO/TW
  • Super Moderator
  • Super Moderator
  • User avatar
  • Joined: May 28, 2003
  • Posts: 23404
  • Loc: Woodbridge VA
  • Status: Offline

Post November 24th, 2003, 6:48 pm

That sucks.
Sorry...did the best I could. Surely they have to have something somewhere to tell you what to do with that DSN field.

Best of luck. I can't think of anything else.
"There's no place like 127.0.0.1 except for ::1."
Alexandria Networks. Leader in IT consulting for associations/non-profits, and small to medium sized businesses around the northern Virginia and Washington D.C. metro area.
  • butlerboy99
  • Beginner
  • Beginner
  • User avatar
  • Joined: Nov 18, 2003
  • Posts: 60
  • Loc: WA
  • Status: Offline

Post November 24th, 2003, 6:50 pm

well, I managed to find a support email address, so I'll see if they have any answers
  • Anonymous
  • Bot
  • No Avatar
  • Joined: 25 Feb 2008
  • Posts: ?
  • Loc: Ozzuland
  • Status: Online

Post November 24th, 2003, 6:50 pm

Post Information

  • Total Posts in this topic: 22 posts
  • Users browsing this forum: No registered users and 92 guests
  • You cannot post new topics in this forum
  • You cannot reply to topics in this forum
  • You cannot edit your posts in this forum
  • You cannot delete your posts in this forum
  • You cannot post attachments in this forum
 
 

© 2011 Unmelted, LLC. Ozzu® is a registered trademark of Unmelted, LLC.