Extension talk:ExtAuthDB

Auth problem MW 1.15
It's not working... Theres no errors but when the extension is active I can't create accounts, the users/password of the MySQL Database are not working, and the wiki users/password are not working neither.

What can I do? --Romulocantor 16:10, 20 July 2009 (UTC)


 * This extension was created to use an external page for create accounts.. so that if you need again, then you could send me an email and I see to add an variable about this choice. -- Bilardi 15:12, 29 September 2009 (UTC)


 * Hi there... thanks for the response! Im using the 1.15 release and the extension is not working. Can you pls take a look at this? thanks mate.--Romulocantor 00:46, 6 October 2009 (UTC)

Nope, it doesn't work. I went through the steps and I've created a database user with privileges to the user table but no dice. I suspect it has something to do with the type of hash being used. Which algorithm does mediawiki use by default? Zoef1234 14:52, 1 October 2009 (UTC)


 * I'm using ExtAuthDB with 1.14.0 release and, about privileges, I'm using Extension:AdminWhiteList. Now, I'll install 1.15 release and I'll check errors because I don't understand which it is the problem. -- Bilardi 15:30, 1 October 2009 (UTC)


 * Hi all, I'm testing ExtAuthDB with 1.15.1 release and, .. it works: File:ExtAuthDB_with_1.15.1.png.. so that if you paste your parameters.. maybe I could help you.. -- Bilardi 16:42, 6 October 2009 (UTC)


 * Cool, here they are:

// add ExtAuthDB // MySQL Host Name. $wgExtAuthDB_MySQL_Host = '200.200.200.200'; // MySQL Username. $wgExtAuthDB_MySQL_Username = 'sqluser'; // MySQL Password. $wgExtAuthDB_MySQL_Password = 'password'; // MySQL Database Name. $wgExtAuthDB_MySQL_Database = 'usersdb'; // MySQL Database Table of users data. $wgExtAuthDB_MySQL_Table = 'userstbl'; // MySQL Database username column label. $wgExtAuthDB_MySQL_Login = 'LOGIN_UID'; // MySQL Database login password column label $wgExtAuthDB_MySQL_Pswrd = 'LOGIN_PWD'; // MySQL Database email column label $wgExtAuthDB_MySQL_Email = 'EMAIL'; // MySQL Database user real name column label $wgExtAuthDB_MySQL_RealN = 'REALNAME'; require_once("/var/www/wiki/extensions/ExtAuthDB/ExtAuthDB.php"); $wgAuth = new ExtAuthDB;

index.php looks blank with this (yes, I have tried the actual MySQL login and I can SELECT * FROM userstbl; fine) -- Zoef1234 16:17, 9 October 2009 (UTC)


 * Ok, but it is not all. I would like know:


 * result about MySQL command: 'desc userstbl'
 * lines about /var/log/apache2/?.*/error.log when you look index.php blank
 * log about host name instead IP number, into $wgExtAuthDB_MySQL_Host
 * log about query from wiki server shell: mysql -h 200.200.200.200 -u sqluser -ppassword usersdb -e "select * from userstbl"
 * -- Bilardi 16:58, 9 October 2009 (UTC)