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

New User

Apr 9, 2009, 8:50 AM

Views: 5720
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.


Apr 16, 2009, 8:00 AM

Views: 5606
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.