[ericakadisco]

I’ve just started getting massive spam the last two days as well. I’ve been using reCAPTCHA and it seemed to be working up until recently. I can’t seem to use akismet, I don’t even see it in the list of plugins for my bbpress.

Does anyone know of some type of plugin that would require admin approval for posts with links in them? That would go a long way for me.

[ericakadisco]

Cool, thanks, man. That’s exactly what I wanted to do.

Eric

[ericakadisco]

Okay, the 9rules notes is the coolest bbpress forum I’ve seen yet. It looks almost like a combination of a blog and a forum. Any tips on how to do something like that? The little preview is amazing and the number of responses looks great too.

[ericakadisco]

Hey Chris,

I had created a second bbpress database called bbpress2 to see if that was the problem, which it wasn’t. The error message is an older one. The one I’m getting now is in reference to bbpress, not bbpress2 like above. But everything else is the same:

bbPress database error: [Access denied for user 'disco'@'localhost' to database 'approachanxiety_com_bbpress']

SHOW TABLES;



bbPress database error: [Access denied for user 'disco'@'localhost' to database 'approachanxiety_com_bbpress']

CREATE TABLE bb_forums ( forum_id int(10) NOT NULL auto_increment, forum_name varchar(150) NOT NULL default '', forum_slug varchar(255) NOT NULL default '', forum_desc text NOT NULL, forum_parent int(10) NOT NULL default '0', forum_order int(10) NOT NULL default '0', topics bigint(20) NOT NULL default '0', posts bigint(20) NOT NULL default '0', PRIMARY KEY (forum_id) ) DEFAULT CHARACTER SET utf8



bbPress database error: [Access denied for user 'disco'@'localhost' to database 'approachanxiety_com_bbpress']

CREATE TABLE bb_posts

Question: can I use the same database as my WordPress database?

I may call my hosting provider to see if there is something wrong with the way mysql databases are set up. Perhaps I can connect but can’t create tables?

Thanks for all your work on this!

Eric

[ericakadisco]

Thanks for the response.

Okay, I tried to patch all the files with the changes in that ticket and I seem to get the same error.

Here is my config.php:

<?php



// ** MySQL settings ** //

define('BBDB_NAME', 'approachanxiety_com_bbpress');      // The name of the database

define('BBDB_USER', 'disco');     // Your MySQL username

define('BBDB_PASSWORD', 'xxxx'); // ...and password

define('BBDB_HOST', 'localhost');    // 99% chance you won't need to change these last few



define('BBDB_CHARSET', 'utf8');      // If you are *upgrading*, and your old config.php does

define('BBDB_COLLATE', '');          // not have these two contstants in them, DO NOT define them

// If you are installing for the first time, leave them here



// Change the prefix if you want to have multiple forums in a single database.

$bb_table_prefix = 'bb_'; // Only letters, numbers and underscores please!



// The full URL of your bbPress install

$bb->uri = 'http://approachanxiety.com/bbpress/';



// What are you going to call me?

$bb->name = 'New bbPress Site';



// This must be set before you run the install script.

$bb->admin_email = 'ericmonse@yahoo.com';



// Set to true if you want pretty permalinks, set to 'slugs' if you want to use slug based pretty permalinks.

$bb->mod_rewrite = false;



// The number of topics that show on each page.

$bb->page_topics = 30;



// A user can edit a post for this many minutes after submitting.

$bb->edit_lock = 60;



// Your timezone offset.  Example: -7 for Pacific Daylight Time.

$bb->gmt_offset = 0;



// Change this to localize bbPress.  A corresponding MO file for the

// chosen language must be installed to bb-includes/languages.

// For example, install de.mo to bb-includes/languages and set BBLANG to 'de'

// to enable German language support.

define('BBLANG', '');



// Your Akismet Key.  You do not need a key to run bbPress, but if you want to take advantage

// of Akismet's powerful spam blocking, you'll need one.  You can get an Akismet key at

// http://wordpress.com/api-keys/

$bb->akismet_key = ''; // Example: '0123456789ab'



// The rest is only useful if you are integrating bbPress with WordPress.

// If you're not, just leave it as it is.



$bb->wp_table_prefix = '';  // WordPress table prefix.  Example: 'wp_';

$bb->wp_home = '';  // WordPress - Options->General: Blog address (URL) // Example: 'http://example.com'

$bb->wp_siteurl = '';  // WordPress - Options->General: WordPress address (URL) // Example: 'http://example.com'



/* Stop editing */



if ( !defined('BBPATH') )

define('BBPATH', dirname(__FILE__) . '/' );

require_once( BBPATH . 'bb-settings.php' );



?>

When I run the testdb.php I get

Connection Results

Connection: Successful!

Database Selection: Successful!

Enter Your MySQL Information

MySQL Hostname localhost

MySQL Username disco

MySQL Password xxxx

MySQL Database approachanxiety_com_bbpress

Here is the text php file that connects to the database and works:

<html>

<head>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">

<title>MySQL Test Script</title>

<style>

body { font-family: Verdana; font-size: 10pt; }

td { font-size: 10pt; }

th { font-size: 8pt; }

</style>

</head>

<body>



<?php



if ( isset ( $_POST['submit'] ) ) {

?>

<table border="1" summary="" cellpadding="2" cellspacing="0" style="border-collapse: collapse;">

<tr>

<th bgcolor="#F2F2F2" colspan="2"><center><b>Connection Results</b></center></td>

</tr>

<?



if (!$link = @mysql_connect($_POST['mysql_hostname'], $_POST['mysql_username'], $_POST['mysql_password'])) {

?>

<tr>

<td>Connection:</td>

<td bgcolor="red"><font color="white"><?php echo mysql_error(); ?></font></td>

</tr>

<?

} else {

?>

<tr>

<td>Connection:</td>

<td bgcolor="green"><font color="white">Successful!</font></td>

</tr>

<?

}



if (!$dblink = @mysql_select_db($_POST['mysql_database'], $link)) {

?>

<tr>

<td>Database Selection:</td>

<td bgcolor="red"><font color="white"><?php echo mysql_error(); ?></font></td>

</tr>

<?

} else {

?>

<tr>

<td>Database Selection:</td>

<td bgcolor="green"><font color="white">Successful!</font></td>

</tr>

<?

}



@mysql_close($link);

?>

</table>

<?

}



?>



<form method="post">



<table border="1" summary="" cellpadding="2" cellspacing="0" style="border-collapse: collapse;">

<tr>

<th bgcolor="#F2F2F2" colspan="2"><center><b>Enter Your MySQL Information</b></center></td>

</tr>

<tr>

<td>MySQL Hostname</td>

<td><input type="text" name="mysql_hostname" size="40" value="<?php echo $_POST['mysql_hostname']; ?>"></td>

</tr>

<tr>

<td>MySQL Username</td>

<td><input type="text" name="mysql_username" size="40" value="<?php echo $_POST['mysql_username']; ?>"></td>

</tr>

<tr>

<td>MySQL Password</td>

<td><input type="text" name="mysql_password" size="40" value="<?php echo $_POST['mysql_password']; ?>"></td>

</tr>

<tr>

<td>MySQL Database</td>

<td><input type="text" name="mysql_database" size="40" value="<?php echo $_POST['mysql_database']; ?>"></td>

</tr>

<tr>

<td colspan="2"><center><input type="submit" name="submit" value="Submit"> <input type="reset" name="reset" value="Reset"></center></td>

</tr>

</table>

</form>



</body>

</html>

[ericakadisco]

Also, using a test script, I entered the same database information that’s in my bbpress config.php file and I can successfully connect to my database. The user, Disco, is the default user and is database administrator so there’s no reason why I should get access denied.