Jump to content

Guides

External Database

Within IPS 4 you can use an external database as a login handler. You would do this from the following location in your admin CP

System>Settings>Login Handlers

From here you can then set up the relevant details needed for connection

Database connection Details

In the first section you will need to enter all the details to connect to your mysql data. Ensure these details are 100% connect and can be connected to from the server where your IPS installation is located.

1.thumb.png.485edd9d3e6cd61e397e0149e574

 

Database Schema Details

This is where you will set up the information related to where your users are located. You will need to provide the Table and at minimum either an email address or username column. You can of course use both if you are using both methods of login.

You will need to add in the password column and tell the system how this password is stored. If this is encrypted you will need to ensure you provide the correct Encryption type.

There is also an additional clause which will allow you to add to the end of the query which returns users. So for example, you may have users who you do not want to have access and have a column named 'active'. This will allow you to add active=1 and it will add to the end of the sql statement 'WHERE active=1"

2.thumb.png.eb16e239b7444a9c303644deb17a

 

Login Settings

Finally you will need to set up which authentication type is being used, and whether or not to allow Admin CP login with this method.

3.thumb.png.f98fb619e20bafade5a39c45edd4


  Report Guide


×