Vanilla 1 is no longer supported or maintained. If you need a copy, you can get it here.
HackerOne users: Testing against this community violates our program's Terms of Service and will result in your bounty being denied.

anope integration

edited February 2007 in Vanilla 1.0 Help

I am trying to integrate Vanilla with my Anope IRC services database. When I try to log in, I get this error:

A fatal, non-recoverable error has occurred Technical information (for support personel): Error Message An error occurred while attempting to validate your credentials Affected Elements Authenticator.Authenticate(); The error occurred on or near: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1

I have added this to conf/database.php:
// Anope integration $DatabaseTables['User'] = 'anope_ns_core'; $DatabaseColumns['User']['UserID'] = 'nc_id'; $DatabaseColumns['User']['Name'] = 'display'; $DatabaseColumns['User']['Password'] = 'pass'; $DatabaseColumns['User']['Email'] = 'email'; // New authentication module $Configuration["AUTHENTICATION_MODULE"] = "People/People.Class.Authenticator2.php";

.. and here is the modified part of my People.Class.Authenticator2.php:
// Anope integration stuff include('anopemd5.php'); $Password = pam_crypt($Password); // Retrieve matching username/password values $s = $this->Context->ObjectFactory->NewContextObject($this->Context, 'SqlBuilder'); $s->SetMainTable('User', 'u'); $s->AddJoin('Role', 'r', 'RoleID', 'u', 'RoleID', 'inner join'); $s->AddSelect(array('UserID','VerificationKey'), 'u'); $s->AddSelect('PERMISSION_SIGN_IN', 'r'); $s->AddWhere('u', 'Name', '', $Username, '='); $s->AddWhere('u', 'Password', '', $Password, '='); $s->EndWhereGroup();

Unfortunately my Anope database uses the "broken" Anope md5 encryption, so I had to use anopemd5.php. I have put in various echos, and it looks as though $Password is being set correctly, but mySQL obviously isn't happy.

Any help would be greatly appreciated!

-- Greg
This discussion has been closed.