|
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| WoW Raid Manager :: Forums :: Closed Support Questions | |||
|
|||
 Database ?Go to page >> |
| Author | Post |
| crayola121212 |
| ||
 Joined: Tue Sep 30 2008, 04:52AM Posts: 22 | Im not entirely stupid but something is eluding me to al haltering point, in the installation process it wants my MySQL Database: now when i type random things in there it gets mad at me and calls me names, so in a rebuttal state of mind, i say nasty things also and nothing get's accomplished. when it says the database should already exsist, now is this the database for the CMS or the phpNUKE i have installed or is this the server side DB my php is installed into, for example .. i have a table prefix on my php DB _phpBB3 for my boards. I am justn ot sure where the database is comin from for me to come up with a name | ||
| Back to top |
| crayola121212 |
| ||
Joined: Tue Sep 30 2008, 04:52AM Posts: 22 | Assumin i have the right portion of this figured out, i am going to say, i don't have the right support system in place, so i'll take out the Nuke DB and try one of the current via the install.txt i'll see if i can figure out the paths, etc.. based on install .. as im currently getting this error Error installing Query: $sql Reported: No database selected | ||
| Back to top |
| marix |
| ||
 Joined: Wed Sep 24 2008, 02:57AM Posts: 101 | In your databaseserver (mysql or whatever) you need to create a new db, calling it for instance WRM, this is the database you would tell the wrm install to use, along with hostname, login, password, that is allowed to use that db. and then the install will create all nifty tables it needs inside that WRM database. you can call it anything you want, and you should want to keep it seperate from other utils like phpbb and such, and not just throw everything in the same db. | ||
| Back to top |
| crayola121212 |
| ||
Joined: Tue Sep 30 2008, 04:52AM Posts: 22 | i c i c alright, what i'll try is creating a new DB setting a user in it and do that, we'll see if that alleviates the problem for now, im stuck on that last error | ||
| Back to top |
| crayola121212 |
| ||
Joined: Tue Sep 30 2008, 04:52AM Posts: 22 | i made a seperate db for it, and installed it into the main /dir of my host left it in it'd folder, i'm stuck at Error installing Query: $sql Reported: No database selected | ||
| Back to top |
| marix |
| ||
Joined: Wed Sep 24 2008, 02:57AM Posts: 101 | ehm, you created a seperate db and installed it into your main dir? what db server are you using? is this on your box or is it on some buy/free webhosting place? | ||
| Back to top |
| crayola121212 |
| ||
Joined: Tue Sep 30 2008, 04:52AM Posts: 22 | im using siteground it's in my main dir right with the rest of my website info, in it's own folder wrm example wrm website phpbb3 etc.. etc.. in the main dir i created a sepeerate db for the wrm in mySQL i created a user and applied it to the DB the problem is, it doesn't matter what i put in there for a database name it isn't seeing it, like im not even typing it in the bar but i am. | ||
| Back to top |
| TheMuffinMan |
| ||
Joined: Wed Aug 13 2008, 11:56AM Posts: 84 | A folder on your webserver is NOT a database. The one on Drury Lane?? | ||
| Back to top |
| TheMuffinMan |
| ||
Joined: Wed Aug 13 2008, 11:56AM Posts: 84 | Also, are you wanting this to use the same name/passwords as your phpbb3? The one on Drury Lane?? | ||
| Back to top |
| TheMuffinMan |
| ||
Joined: Wed Aug 13 2008, 11:56AM Posts: 84 | And I dont know how else to say this, but your terminology in your above posts is so wrong they sound like gibberish. I am not trying to be a jerk or anything but I cannot figure out what is going on. The one on Drury Lane?? | ||
| Back to top |
| TheMuffinMan |
| ||
Joined: Wed Aug 13 2008, 11:56AM Posts: 84 | If you have siteground, you have everything you need. I use the same hosting. The one on Drury Lane?? | ||
| Back to top |
| marix |
| ||
Joined: Wed Sep 24 2008, 02:57AM Posts: 101 | i'm actually amazed that you got phpbb3 up and running, as it requires the same thing... if you managed to create a user in mysql, then you should know that you dont assocciate that user to a directory on your server structure, but you give it permissions in your database servers structure, ie created databases. seeing that you use siteground, maybe you should read the information they also give you. - Click Here - then after doing that successfully, you dont put in any random thing in the databasefield in the install of wrm, you type in the name corresponding to the database you actually created. | ||
| Back to top |
| Illydth |
| ||
  Joined: Mon Sep 24 2007, 02:51PM Posts: 1886 | Let me try to remediate here for a second and walk through this step by step. First, Terminology: * WRM Directory: A directory on your web server (a place holding physical files) into which you copy the files provided by the WRM installation package. * WebRoot: The "root" directory that you hit when you type "www.myurl.ext" (where myurl.ext is your web address). * Database: A conglomeration of "tables" accessed through a "database server", this is NOT a directory or file on a system, this is a hidden area that is accessed through a "database management package". * Database Management Package: A package like phpMyAdmin or mysqladmin or other mysql tool that allows you to run SQL commands like INSERT, DELETE, UPDATE, etc. Some of these provide you "graphical" representations of what the database and tables look like. Most users have access to phpMyAdmin through their hosting providers. Instructions: First, push up all of the software in the WRM installation into a folder somewhere under your web root directory. In your case it looks like you have Now you have to decide whether you are going to install into a currently existing database or into a new database. * If you are going to select a bridge (i.e. try to integrate it with your user administration system of another Content Management System or Bulletin Board (like phpbb3)) you MUST install into that CMS/BB system's existing database (in your case if you wish to use phpbb3 bridge you would need to install into your phpbb3 database.) * If you do not want to install a bridge it is HIGHLY Recommended that you create a new database for WRM and install into that. Note: Before proceeding forward to the installation you MUST MUST MUST have the database already existing. You must also know the username, password, server and database name you will be installing into. This information all pertains directly to your DATABASE not to any other installation (like phpbb3 or wrm) on your system. Once you have the above information you will start the install, verify that all of the filesystem checks pass, and go to the database installation screen. Type in your database information and continue with the installation. --Illydth - Douglas Wagner - Site Admin | ||
| Back to top |
| crayola121212 |
| ||
Joined: Tue Sep 30 2008, 04:52AM Posts: 22 | I went into mySQL i created a database called WRM. I created a user and a pass for that database in the same mySQL admin area It sees the user and pass fine the prefix for the table selected is also fine when i type in the database name it doesn't see it, gives me the error As far as folders and directories go, no idea what a brdige is, based on the phpbb and what im reading is that the wrm folder needs to be set inside the phpBB folder which it is then i dig out ie7 type in the adress and install the package again with the error. So ill send off the structure for where my phpBB is and where my wrm folder is let's go from there public_html/phpBB3/wrm im assumin that is correct given it is, then im good there and im confused about the database thing. If it isn't then i'll need to sort that out first. I was good till this thing got into technical jargon. If my database already exsists should i put in my phpbb database or the new one i created for wrm | ||
| Back to top |
| crayola121212 |
| ||
Joined: Tue Sep 30 2008, 04:52AM Posts: 22 | Ill also show you a tree for my databases what's where maybe im missing some tech jargon somewhere. I go into phpMyadmin on the left hand side it has a drop down of all my "existing" databases. My board is setup on _phpBB1 My WRM is setup on it's own which i created since these posts _WRM the user/pass are the same for each DB once i applied them. it could be terminology or .. something else im missing | ||
| Back to top |
| marix |
| ||
Joined: Wed Sep 24 2008, 02:57AM Posts: 101 | no, wrm should NOT be inside your phpBB dir it should be something like this: /public_html/index.html <- main website welcome page /public_html/phpBB3 <- da forum /public_html/wrm <- WRM! to install go to whateveryourdomainis.com/wrm/install if what you write is correct, then you type in the user/pass for mysql, the host, prolly locaolhost, but could be something else, atleast its the same you used when you installed phpbb3 and then the database should be "_WRM" (case sensitive, without the "") and it should work. if youve done everything correctly | ||
| Back to top |
| marix |
| ||
Joined: Wed Sep 24 2008, 02:57AM Posts: 101 | Illydth: why would you have to install it into the same db as the thing your bridging? ;) i havent ;) from an sql standpoint you shouldnt even do it in the same database, but keep them seperate. and not just toss all tables into the same huge db. | ||
| Back to top |
| TheMuffinMan |
| ||
Joined: Wed Aug 13 2008, 11:56AM Posts: 84 | For the bridge to work, WRM has to have access to the database your chosen CMS uses. It has to have access to the PHPBB3 tables. The one on Drury Lane?? | ||
| Back to top |
| crayola121212 |
| ||
Joined: Tue Sep 30 2008, 04:52AM Posts: 22 | Ok this is what i have and what i've done My Browser points to - Click Here - ( from my understanding that's wrong ) MySQL databases are these which i made since the postings and applied the "same" user/pass to _WRM _wrm1 It is localhost and my user and pass i use on the install are that of the DB which i created. Here's what im unclear of: Bridging - what the .. phpBB3 was easy to understand it's instructions. This is difficult as i've done what it's told me yet there are problems. Based on the error i get Error installing Query: $sql Reported: No database selected it sounds to me like it's querying the databases to write to, but it's not finding it, which is fine, but i've done what it's told me. Unless there's a pathing problem. when i signed up for hosting with siteground it gave me a username which i can't change, "wowungui" this username is incoroporated into the database names, which i use in correspondance to everything, on that note, i've tried it without etc.. For example DB1 would read "wowungui_WRM" and so forth. Although nowhere does it, ask me im going to try xferring some things over and see if the install picks it up atm i have public_html/index.htm - main site public_html/phpBB3 - forums public_html/wrm - < WRM inside wrm is install/install.php im a try and move it for now over to the main folder /wrm see if it makes a difference although i doubt it. | ||
| Back to top |
| marix |
| ||
Joined: Wed Sep 24 2008, 02:57AM Posts: 101 | ok, so now the millsion dollar question, In the database field for the installation, are you typing _WRM _wrm1 or wowungui_WRM wowungui_wrm1 and pointing your browser to - Click Here - is correct, that is how you start the installation of wrm and begin the whole shebang | ||
| Back to top |
| Moderators: Illydth |
Date / Time Search WoW Raid Manager Chatbox
Neme
andrew11
Illydth
Illydth
Illydth
Illydth
Illydth
Jonneh
Jonneh
ppbash
