Extension talk:AuthJoomla/ja

Hi

Thanks for a very useful extension. However, it does not work when the MediaWiki database tables are given a prefix. The problem is that the SQL user authentication query tries to parse a table in the joomla database containing both the joomla prefix, example (jos_) and the MediaWiki prefix, example (mw_). The table which is searched has the form "joomla_db.mw_jos_users". This table does not exist and an error is returned. The correct table should have been joomla_db.jos_users which is what results without the mw_ prefix attached.

Has anyone managed to get the extension to work with the MediaWiki database tablenames prefixed?

P.S. The extension works fine when no prefix is attached to the MediaWiki database tables.

I am running : Joomla 1.5.3 MediaWiki 1.12 (same result on 1.11.1) PHP 5.2.5 MySQL 5.0.45 Apache 2.2.6

Thanks

You can try to write yourself the queries: I made this: $query = 'SELECT password FROM jos_users WHERE username = \''. $username. '\' LIMIT 1'; $hash_password = mysql_fetch_object(mysql_query($query));

and this: $query = 'SELECT password FROM jos_users WHERE username = \''. $user->mName. '\' LIMIT 1'; $juser = mysql_fetch_object(mysql_query($query));

Thanks for replying but I am a bit lost. Where (in which file) do I place those queries??? It would be much more helpful, if you could provide a step by step guide.

Database error
I added the LocalSettings.php changes and created the extensions directory and file. All content copied exactly as provided. However, I get the following errors when I try to log in to my Mediawiki implementation:

Warning: mysql_real_escape_string expects parameter 2 to be resource, null given in [wiki directory]/includes/Database.php on line 1691

Warning: mysql_query: supplied argument is not a valid MySQL-Link resource in [wiki directory]/includes/Database.php on line 817

Database error: A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was:

(SQL query hidden)

from within function "AuthJoomla::authenticate". MySQL returned error "0: "

My configuration:
 * Joomla 1.5.2
 * MediaWiki 1.12
 * PHP 5.2.6
 * MySQL 5.0.45

I'd appreciate any advice on how to fix. Thanks!