Related Topics • INFO: Expiration Date Field in the Users Table • INFO: Authentication Types in ILLiad • INFO: Basic ILLiad Authentication • INFO: LDAP Authentication • See more

Other Support Options • Contact Atlas Systems Phone Numbers, Support Options, Online Help, and more. • Listserv Pose a question to other users.

Page Tools Print this page E-mail this page

Feedback How helpful was this article? 5 Best 4 3 2 1Worst 0 N/A Suggestions:

SUMMARY

In some cases, libraries may want to import users to the ILLiad database rather than have customers register and create accounts themselves. In order to do this, however, you will need to choose usernames and passwords for your users. The username can be any string under 20 characters. The password can be any length, but is stored in the ILLiad database using MD5 one-way encryption. To create those passwords ahead of time for users, you will need to convert the password from plain text to an encrypted value.

Using the text "ill" as an example, the ILLiad version of that password would first be converted using standard MD5 encryption to the hexadecimal value:

2F9C691594932556EF427450338A74B7

The hexadecimal value would then be converted to a decimal value, two characters at a time:

47156105211481473786239661168051138116183

where 2F converts to 47, 9C converts to 156, 69 converts to 105, etc. You may use any tools you choose to create these passwords on your own and load them pre-encrypted. If you do not have that option, however, you can use the following tool to convert the password after loading it to the Users (or UsersALL for Shared Server installations) table.

WARNINGS

The following tool is for advanced users who have an understanding of how to load data to a SQL database. This program can be run on a schedule or manually but will affect every user in the Users table regardless of NVTGC. Please test this thoroughly before using in production.

Note: See the SQL Help files on DTS Import/Export Wizards or Creating a DTS Package for further information on how to import data.

USING THE MD5USERPASS.EXE TOOL

To run the MD5 ILLiad User Password Tool, you must run it on a machine that has a BDE Administrator and SQL connectivity to the SQL Server. This may be your web server or your SQL Server if they are separate. It would most likely be scheduled to run immediately after the import of users from an outside source to the database. The MD5 ILLiad User Password Tool does the following:

• Queries the ILLiad database's Users table for any records where Special = 'PTP' (for plain text password).
• Updates those user records so that the password is the MD5, numeric version of the original text.
• Changes the Special field from 'PTP' to NULL (the default blank value).

This means when you load the user information that has a plain text password, you would also need to set the Special field to 'PTP' for the tool to find it and convert the password.

COMMAND LINE PARAMETERS

You can run the executable from any folder on the machine and it can be scheduled via Windows Scheduled Tasks. There are two command line parameters that can be added to the program when it runs:

AUTO
This allows the program to run with no user input. It will run, convert the passwords and close on its own. (i.e. c:\illiad\admin\MD5UserPass.exe AUTO)

HIDEGUI
This can be added as well so that when the program runs automatically, it will run minimized. (i.e. c:\illiad\admin\MD5UserPass.exe AUTO HIDEGUI)

DOWNLOAD

The following link is a zipped file of the MD5UserPass.exe.

MD5 ILLiad User Password Tool