> Vincent Stoessel wrote:
> > I boosted the username to 32 chars in the mysql.user and the mysql.db
> > tables.
> > Same error. I will try 64. But the docs seem to indicate that 16 is the
> > limit for the GRANT
> > command.
> >
> > Alan Knowles wrote:
> >
> >> one of the install hacks on nadmin modifies the field length of the
> >> mysql username to 64 chars.
> >>
>
> The workaround for me was to go ahead and manually add the user
> and privledges to the relevent mysql permission tables.
see the php manual entry for crypt. Your newer version php supports other
encryption methods that yield longer encrypted strings.
Then look at this bit of code from
snippet(SG0):/hklc_adminsite_host/argv0/dbsetup/dbsetup :
25: // new user!
26: $sguser = eregi_replace("[^A-z0-9]","",crypt($sgguid));
27: $sgpasswd = eregi_replace("[^A-z0-9]","",crypt($sguser));
feed a two character salt to crypt to force it to use unix_crypt algorithm.
Something like:
25: // new user!
26: $sguser =
eregi_replace("[^A-z0-9]","",crypt($sgguid,substr($sgguid,2,4)));
27: $sgpasswd =
eregi_replace("[^A-z0-9]","",crypt($sguser,substr($sguser,2,4)));
(It would have been more elegant to use a random salt, but for the sake of
the argument this will do)
wkr,
Armand.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
