MySQL Auth Plugin for Joomla 1.5 
Version
1.5 (last update on Mar 24, 2008)
Rating
Compatibility
Votes
10
Favoured
12
License
GPL
Non-Commercial
Type
Views
17204
Date Added
9 November 2007
bymikkelbreum on May 26, 2009
I know it does say 'external' db. But it would be nice if it could also use an alternate DB on same server. However, if you set 'Database Host' to 'localhost' you will not be able to log in as admin anymore!! be aware! If you set this plugin to use localhost, then logging in to admin area will result in denied acces and this error:
Warning: mysql_real_escape_string(): 26 is not
a valid MySQL-Link resource in /home/www/user/html/sitename/libraries/joomla/database/database/mysql.php on line 193 or something like that..
in case this happens go to your db admin (phpmyadmin maybe?) and there set the published status of the plugin to 0.
Warning: mysql_real_escape_string(): 26 is not
a valid MySQL-Link resource in /home/www/user/html/sitename/libraries/joomla/database/database/mysql.php on line 193 or something like that..
in case this happens go to your db admin (phpmyadmin maybe?) and there set the published status of the plugin to 0.
bymarkjansen.nl on February 22, 2009
I installed this plug-in and it worked right away! Simply great.
I do have one suggestion however: it would be great if this plugin would support sub-query's, or would enable the administrator to manually specify the query to use.
The current structure of the plug-in requires me to save the user username/password in the same table as the other user data (like first name, surname). I would like to be able to keep these kinds of data seperated.
I do have one suggestion however: it would be great if this plugin would support sub-query's, or would enable the administrator to manually specify the query to use.
The current structure of the plug-in requires me to save the user username/password in the same table as the other user data (like first name, surname). I would like to be able to keep these kinds of data seperated.
bysclg on November 25, 2008
It just works!
Set up the database info and off you go.
Exactly what I needed.
Set up the database info and off you go.
Exactly what I needed.
byrashan on June 30, 2008
The latest release (0.9) now supports both plain text and SHA-1 type passwords.
bydpayer on June 10, 2008
This plugin may be still in development so I only want to comment on a limitation I experienced, not to be critical.
The configuration of the module has a dropdown box to choose what kind of password is to be used. The only option is to use a MD5 hash of the password. I would have expected a plain text option as many apps use a plain text password for easier integration with other systems.
I hope the developer continues to develop a v 1.5 version of database authentication from an external MySQL db.
The configuration of the module has a dropdown box to choose what kind of password is to be used. The only option is to use a MD5 hash of the password. I would have expected a plain text option as many apps use a plain text password for easier integration with other systems.
I hope the developer continues to develop a v 1.5 version of database authentication from an external MySQL db.
Owner's reply
hi,
thanks for your suggesion and I have added your request to the latest release. In addition to plain text, the plugin now supports SHA-1 type hashes too. pls try the latest and let me know any bugs or other usefull feature requests.
You may add them here OR at the Joomlacode project site (better).
--
Rashan
bypardocorp on February 25, 2008
this was the plugin to use with moodle and really works !!!




