This module allows users to log in through external database validation. If a user is not known, an account will be created. Optionally synchronize the Security Roles for the user. (MS SQL and MySQL).
Input the connection string to connect to the external database. A connection string should look something like this: Data Source=192.168.0.55; Initial Catalog=DotNetNuke; User ID=DnnUser; Password=1A2b3C4d
The query to check the username and password in the external database. This could also be a stored procedure
External database is MySQL:
Check if the external database is MySQL.
Test the connection:
Fill out a username and password to test the connection and query. The click the "test login” link to see if the login works.
Label position: Select the placement of the labels for the textboxes (above or left). Default is above.
Redirect after login: Select the page in the portal where the user should be redirected to after a successful login. If there is no page specified, the module will try to redirect to the redirect page configured in the portal settings.
Enable the "Stay logged in" checkbox: Enable this option if you want to allow users to keep themselves logged in the next time they visit the site.
Header Text: This text will be displayed at the top of the module. You can use this for extra instructions or other information.
Footer Text: This text will be displayed at the bottom of the module.
Security Role Settings
Add security role:
Optionally select a existing security role to add to the user when the login is successful.
Security role SQL query:
The query to check the roles for the user in the external database. This could also be a stored procedure. When a role does not exists it will be created.
Passwords are NOT kept in the website database for security. These users have to login through the EasyLogin module to authenticate. Also make sure they cannot change their password through the DNN profile page.
Make sure the query or stored procedure only returns 1 result, otherwise login will fail.
Connecting to an external database could be blocked by your hosting provider. Make sure the server and/or firewall will allow connections to external databases.
When using MySQL, make sure the DotNet MySQL Connector is installed on your DNN installation. You can check this by verifying if the file "MySql.Data.dll” is present in the \Bin folder. This file is included in this package.
The password is sent unencrypted to the external database, so make sure the connection is secure.
NEVER store passwords unencrypted in a database.
Go to http://modules.vdwwd.eu for a live demo.