anope integration

greg27 · February 2007

Hi,

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