PDA

View Full Version : Problem with installing and connecting to my database


The Akatsuki
8-9-09, 11:19 PM
I am trying toistall a vbulletin community forums on my powweb hosted wesite. I followed vbulletins proses and I got to the last part were problem occrued. I contacted vbulletin support and they detuminded that the must be a problem with the ysql database. This is what they said;
We can only say with certainty that either the MySQL information is wrong, there is a problem with the MySQL configuration on the server, or the information is entered wrong in the file. You need to contact your host to confirm the correct info, make sure the MySQL database is setup properly, and then refer to my previous post where I gave a detailed example of exactly how to fill out the file.
I already made sure that information is correct so there has to be a prblem with the database, right?
I created a database by goig to the mysql manager in my control panel,named it ccgworldforums and gave it a username and password,
witch I checked and thats what I entered into te file. So I was wondering is the something I am doing wrong and is there a way to verify the inforumation and is there a database error I am unaware of/ Sorry if this agenst the rules or in the wrong secion but I realy need the help.

Croc Hunter
8-10-09, 10:06 AM
Make sure you don't have any spaces before or after the 'info' eg; 'info '

You could run a simple test script to check if your database works, first try re-setting the database password.

Dbrazzell
8-10-09, 04:54 PM
Most likely you have the mysql server name wrong.

Make sure its username.powwebmysql.com and not something like 'localhost'

You already mentioned that you double checked the user name and password. So this is the only thing left that could be an issue.

Croc Hunter
8-10-09, 05:36 PM
Yeah that's kinda what I was thinking Dbrazzel. Often when a username or MySQL database name is copy/pasted from OPS it will include a space at the end. Akatsuki, you can PM me your code if you would like me to check it.

Surely your CGI MySQL is compiled correctly as you get past the enter user/pass screen.

The Akatsuki
8-10-09, 08:36 PM
I think I might know what is wrong, I don't have the code copyed or pasted into the part of my site were I want the forum. If you could, please tell me what I should do. I allready know how to generate the code but do I just go to the template and pase it there then republish the tempate? or is there some thing else I should do?

Croc Hunter
8-10-09, 11:36 PM
You have to install it before you need worry about templates. Rename the config.php.new file as config.php and upload the tools.php file into the admincp folder then run install again.

http://www.vbulletin.com/docs/html/install

The Akatsuki
8-11-09, 09:47 AM
I allrady did that I am talking about the mysql database code tat you need to copy then past t the part of yu site were you want to conect with the database. I know how to enerate the coe for the database and that I need to fill in the passwd but do I just past it to the template then reublish it or is there a diffferent wa hat I should do?

Croc Hunter
8-12-09, 12:20 AM
The config.php is not a template it's simply a file. Yes open it and paste your username, password, database name, and host username.powwebmysql.com, making sure you have no spaces and republish it.

If you're still unsure post the code you're trying to complete.

axar1
8-14-09, 03:43 PM
I am having the same issue as the OP. I'm trying to install the simple machines forums software. I was able to upload it and kick off the installation, and I've arrived at a page that is asking me to fill in several fields, including the MySQL server name. My username on POWWEB is Axar1, just like my forum name here, so I assumed that the MySQL server name would be axar1.powwebmysql.com

However, after entering that information and my correct username and password, I am taken to a screen with an error message that says

Unknown MySQL server host 'axar1.powwebmysql.com' (2)

snowmaker
8-14-09, 05:39 PM
Hmm.. Check your MySQL here, MySQL Management Tool (http://ops.powweb.com/webControl/mysql/manage.bml), to make sure the servername is correct.

axar1
8-14-09, 06:44 PM
It is. I tried to get some help from tech support, and they claimed to fix the issue, but in fact I am still having the problem. Only now I get a different error message that says:

Access denied for user 'axar1'@'cgi1001.int.bizland.net' (using password: YES)

I am utterly lost :)

IanS
8-15-09, 05:44 AM
Try support again (re-open ticket), make sure you point out that you're a Powweb customer! and that their fix broke it! (but do it politely).

Croc Hunter
8-15-09, 05:54 AM
Reset your database password. Click my name and Private Message me your OPS user/pass if you like. Simple Machines is easy to problem solve.

pangea
8-22-09, 10:48 PM
I have this same problem as OP. Any fix yet? I changed evrtrything the localhost and all still nothing im trying again for 3rd time..

Croc Hunter
8-23-09, 10:09 AM
Change localhost to your username.powwebmysql.com