Dont look too closely - thats just the icing on the cake :)
Armand A. Verstappen wrote:
>>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]
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
