Having BIG Problems

[masterpaladin]

yes I made one called root am I supposed to put the vblite folder in the folder public html ?

[andrewpfeifer]

Yes, everything has to be in public_html. Note, the name of the database will be: <youraccountname>_<thenameyouchose>

[masterpaladin]

lots of progress now it's trying to load but now I get a message that my ip is not allowed to access mysql . I tripple checked the ip addy and it's right

[BillaBongUSA]

Looks like you don't have a MySQL database set up...

[andrewpfeifer]

You should have the server field in the config.php set to 'localhost', not the IP of your server.

[masterpaladin]

but I do . I named one freewareforum . it's refusing my ip addy . what else is there to set up ? I have a user name and opened the data base

[Steve Machol]

Post the complete error message.

[masterpaladin]

Attempting to connect...

Connect failed: unexpected error from the database.

Error number: 1044

Error description: Access denied for user: 'ttbforum@localhost' to database 'freewareforum'

Please ensure that the database and server is correctly configured and try again.

Click to go to the vBulletin website

[Steve Machol]

Generally that error is due to one or more of the following settings being wrong in config.php:

$dbusername
$dbpassword
$dbname

[andrewpfeifer]

The username and database name will have <youraccount>_ in front of them, so your database would be <youraccount>_freewareforum. Make sure you're doing this for the user, and not just the database. Also, make sure that you have that user permission to access that database.

[masterpaladin]

Connection Strings
Perl $dbh = DBI->connect("DBI:mysql:ttbforum_freewareforum:localhost","ttbforum_ttbforu","<PASSWORD HERE>");
PHP $dbh=mysql_connect ("localhost", "ttbforum_ttbforu", "<PASSWORD HERE>") or die ('I cannot connect to the database.');
mysql_select_db ("ttbforum_freewareforum");
JDBC (may not be avalible) <%@ page import="java.sql.*" %>
Connection connection = null;
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
connection = DriverManager.getConnection(
"jdbc:mysql://localhost/ttbforum_freewareforum?user=ttbforum_ttbforu&password=<PASSWORD HERE>");


thats what my database reads and I still can't get in I don't understand why I am denied access

[Steve Machol]

I'm not sure what that is that you just posted but if you are getting the same error then my previous message still applies. You need to put the correct variables in config.php.

Moving to the vB Lite forum.

[Andy Z]

[QUOTE][i]Originally posted by masterpaladin [/i]
[B]Connection Strings
Perl $dbh = DBI->connect("DBI:mysql:ttbforum_freewareforum:localhost","ttbforum_ttbforu","<PASSWORD HERE>");
PHP $dbh=mysql_connect ("localhost", "ttbforum_ttbforu", "<PASSWORD HERE>") or die ('I cannot connect to the database.');
mysql_select_db ("ttbforum_freewareforum");
JDBC (may not be avalible) <%@ page import="java.sql.*" %>
Connection connection = null;
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
connection = DriverManager.getConnection(
"jdbc:mysql://localhost/ttbforum_freewareforum?user=ttbforum_ttbforu&password=<PASSWORD HERE>");


thats what my database reads and I still can't get in I don't understand why I am denied access [/B][/QUOTE]
@Steve: This is CPanel's sample code that is listed next to each created DB in the MySQL section.

@masterpaladin: According to that your settings should be as follows in your config.php file:
[php]
$dbhost = "localhost";
$dbusername = "ttbforum_ttbforu";
$dbpassword = "<put password here>";
$dbname="ttbforum_freewareforum";
[/php]
Note: MySQL does limit username lengths so the last "m" in your $dbusername is cut off.

[masterpaladin]

ok it loaded but I can't see it I get this now
Warning: Cannot add header information - headers already sent by (output started at /home/ttbforum/public_html/vblite/admin/config.php:35) in /home/ttbforum/public_html/vblite/admin/global.php on line 195

[Steve Machol]

Being answered here:

[url]http://www.vbulletin.com/forum/showthread.php?s=&threadid=48771[/url]