[ic] userDB structure (more questions)

[Chen Naor]

>  This doesn't seem
> to work with IC however, as it crops usernames at 16 characters.  Where
> is this limit set if I'm using text databases?

Yuo can change the username field size in dbconf/fooSQL/userdb.fooSQL
Database  userdb  COLUMN_DEF   "username=VARCHAR(20) NOT NULL PRIMARY KEY"

^^
> More importantly, I need to use SQL for the user DB, so I am planning
> on adding a table for this purpose, importing the required fields, and
> adding the missing fields that we want to preserve.  The problem I'm
> having now is that the existing database used an MD5 hash to store
> users' passwords.  I tried changing the default action to encrypt
> passwords in UserDB with:
>
> UserDB    default    crypt         1
>
> but wasn't able to login after a copy/paste an MD5 hash from the
> existing DB into my userdb.  Any suggestions?

IC use the crypt  function for password encryption - as default.
Look at {IC-root}/lib/Vend/UserDB.pm

Chen