Joomla! Extensions Directory

The extensions and reviews listed in this area have been submitted by the community and their listing does not constitute or imply endorsement, recommendation, or favouring by Joomla!/OSM.

This content is provided as a free service to our visitors, and, as such, Joomla!/OSM cannot be held liable for the accuracy of the information. Visitors wishing to verify that the information is correct should contact the parties responsible for authoring the content and/or development of the extension.

User Authentication

Show All Developer's Extensions

MySQL Auth			componentmodule
Rating 12 votes	Developer:	Hery	Version:	0.9 (Updated 61 days ago)
	E-mail:	This e-mail address is being protected from spam bots, you need JavaScript enabled to view it	Compatibility:
	Views:	43,757	License:	GPLv2.0
	Favoured:	11	Type:	Non-Commercial
			Date Added:	Apr 18, 2006

This is an extension with a component and a module for Authenticate users right from a mysql usertable. All informations about the database (hostname, databasename etc) can be configured in admin. The Query to get the user information is also to be set in the admin backend. This was tested to authenticate phpBB users and drupal users. And should work with others as well.

Every user who logs in is registered automatically to your Joomla user table. And if they change password in the remote site, their password will be updated when they log back in joomla. (So the username and password are always synchronized)

UPDATE: Some of you said that the users are not shown in list as joomla users. It seems the users are in the database but since they dont' have names they are not shown in the Administration panel.

So please use the name field in the SQL Query to make it work well

UPDATE 7-sept-2006:
Sorry that the example I put here had an error. I forgot a '

This is the right example.

eg. SELECT name_field_in_my_table AS name, username_field_in_my_table AS username, email_field_in_my_table AS email FROM my_table WHERE username_field_in_my_table='%{user}' AND password_field_in_my_table=md5('%{pass}')

Report this listing

User Reviews (12)

Great tool, but new folks need to login twice by esteneker, December 7, 2007

This tool is working great, highly recommended!

It does have a small little nuisance. New users (with a user record in the external db, but not yet in the Joomla db) must login twice. The first login attempt will copy the user record into Joomla, but log you in. The 2nd login attempt will then log you in properly.

So this is a good component. If above little bug would be fixed, it would get a GREAT rating.

excellent by freya.impens, November 13, 2007

Works like a charm, easy to install and use.

I added a line of code to copy the usertype to the Joomla database though.

Excellent module/comp by muthukumars, September 24, 2007

Hi,

I am surprised my review was not published first time when I did. but anyway, I am doing it again.

I have two tables where login name, email is. it is joined through a field called ID. my query was as below:

SELECT t1.login as username, t2.email as email from jb_users t1,jb_emails t2 WHERE t1.id=t2.id and t1.login='%{user}' and t1.password='%{pass}.

It worked like a charm.

excellent tool

thanks
Muthukumar

Brill by uglykidjoe, June 20, 2007

Well this is my first review

Quick responce from the developer on a very small matter to enable this to work with Mendi's phpBB bridge. New version posted on his site in a matter of days.

Emails answered within minutes!

Now have a perfect Joomla - phpBB bridge that keeps users' passwords synchronised.

Please donate to this guy - I did! ( and Mendi)

Great Work! by ravenswood, December 7, 2006

This extension works really well as a way to automate creation of users using an existing userbase.
I used it to link to the Trellis desk database and it worked like a dream once I had worked out that trellis used sha1(md5(password)) to encrypt passwords. The only disappointment for me is that it can't act as a bridge but I realise is that is very specific to each application.

What would be really nice if possible, would be to use curl to login to the other application using the supplied credentials.

The author has provided very flexible options for login/logout registration etc.. If you don't need bridging then this is a fabulous contribution..

Full marks from me..

one word ... fantastic !! by pdemaers, November 22, 2006

Great component. Works like a dream and the support from the developer was absolutely first rate. I had some problems figuring out the query but he helped me step by step. It is people like him who make open source in general and Joomla in particular such a joy to work with.

worked great for phpbb by styol, November 9, 2006

I was able to map the logins on joomla to the user database of my phpBB forum... now all 700 of my forum members have instant membership at the new joomla site!

heres the code i had to use to get it to work with phpBB:

SELECT username AS name, username AS username, user_email AS email FROM phpbb_users WHERE username='%{user}' AND user_password=MD5('%{pass}')

Also suitable for Coppermine by GuidoR13, July 19, 2006

Nice component, I use it for Coppermine:

SELECT user_name as name, user_name as username, user_email as email FROM cpg_users WHERE user_name='%{user}' AND user_password='%{pass}' AND user_active=1

cpg_users -> you Coppermine table

BTW You should enhance the readme. One hint I was missing:
1st the Joomla DB is checked and - if user not found - the external user table.

crypt support? by adam_j_bradley, July 1, 2006

Worked great! Except I have discovered the user table I want to use is encrypted with crypt not md5 :( Any chance of changing this?

Happy to help.

Thanks in advance!

Adam

with Community Builder by Hery, April 21, 2006

I think that query should work if the remote site is CB-based.

If the local site is also CB-Based then you have to re-sync users because this component update only the jos_users table

nice component by joomlee, April 20, 2006

I downloaded it and tested it....its an excellent tool. I wanted to know whether it could work with community builder...as we all know username/passwd are stored in jos_users table.It should also check whether the user is approved..banned etc from component profiler . So is this the right qwery?

SELECT jos_users.id, jos_comprofiler.firstname, jos_users.username, jos-users.email FROM

jos_users ,jos_comprofiler WHERE jos_users.username='%{user}' and

jos_user.password=MD5('%{pass}') and jos_users.id=jos_comprofiler.id and
jos_comprofiler.approved=1 and jos_comprofiler.confirmed=1

Re: by Hery, April 19, 2006

I post here the reply to some requests of documentation.

In fact, this extension can be used if you have already a user table. What it requires is to be able to get the username and email from tht table.

e.g. if you have a table that has fields like username, email, password then the query can just be

SELECT username, email FROM yourtable WHERE username='%{user}' AND password='%{pass}'

if your password is MD5 encrypted (usually it is). Then you can use the query

SELECT username, email FROM yourtable WHERE username='%{user}' AND password=MD5('%{pass}')

If the username and password fields have other names in your table then you have to make them as aliases.

e.g. for a drupal site

SELECT name as username, mail as email FROM yourtable WHERE name='%{user}' AND pass=MD5('%{pass}')

Everything else (ACL and Admin status) can be done in Joomla as usual. Once users are authenticated, they become like any joomla users

Main Menu

Editor Blogs

Extension Categories

Who's Online

Directory Support

Disclaimer