Home: Perl Programming Help: DBI:
Perl authentication using mySQL table



Shotta
New User

Apr 9, 2009, 8:50 AM


Views: 5483
Perl authentication using mySQL table

Hi all,

I am programming an online auction application using mySQL and Perl per project requirement.

I need an algorithm/code/command to integrate perl authentication from a mySQL database table.

I want all users to connect to mySQL and authenticate with one mySQL login/password (possibly embedded in some button/ login interface) all users will be granted this initial connection to mySQL.

From there each user will authenticate further by comparing their username/password with two fields in a mySQL table (username, password)

The first process (connecting and authenticating to mySQL)is straightforward, I need help with authenticating by using the mySQL table using perl.I am new to perl and haven't found much on this approach from my resources.

Please assist.


1arryb
User

Apr 16, 2009, 8:00 AM


Views: 5369
Re: [Shotta] Perl authentication using mySQL table

Hi Shotta,

Take a look at OpenPlugin::Authenticate::DBI http://search.cpan.org/~eric/OpenPlugin-0.11/OpenPlugin/Authenticate/DBI.pm. It might be what you're looking for.

Cheers,

Larry