I have Joomla with phpBB bridge from the integration guide on these forums. Now I would like to get phpRaid to work with the same login but on the install I select phpBB auth but on the final screen i get a error. the error I get is

Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)



has anyone gotten this to work?? :flower:

It's not really that hard to make the integration. I use it flawlessly on our guildsite.

What you need to do is when it asks for PHPBB tableprefix set it to your joomla prefix.(I assume you use jos_users as your user table and by phpBB bri means the integration steps done in Thumanns fabulous post)

Then you will have to change a few things in the SQL syntax for in auth_phpbb.php.

Code: Select all

$sql = "SELECT user_id, username, user_password, user_active, user_level
      FROM " . USERS_TABLE . "
      WHERE username = '" . str_replace("\\'", "''", $username) . "'";

These are rows 66-68 in above mentioned file.

it should look like this

Code: Select all

$sql = "SELECT id, username, password, user_active, user_level
      FROM " . USERS_TABLE . "
      WHERE username = '" . str_replace("\\'", "''", $username) . "'";

And then you should be fine.

I may have hacked it in some other places too, i don't remember since it was quite a while ago i did it. But just check so you are directing to the correct table. phpRaid is only interested in the usertable, and check so all columnames in the SQL's correlate with your actual collumn names in the table.

[Edit: I read your post a little too quick]
About your error message, make sure you actually set the correct values for the database and the path's and so on. And i strongly recommend to have everything in the same database, it makes everything so much simpler.
[/Edit]
Good Luck