[Users] ERROR 1062 (23000) at line 1: Duplicate entry '' for key 'phplib_id'

[Bogdan-Andrei Iancu]

you can run "MD5=md5 openserctl ...." or for a permanent change see in 
openserctl.base file the MD5 definition.

regards,
bogdan

Lindsey Hans Joseph Lao wrote:

> i have a utility called md5 installed in my freeBSD system. Can you 
> show me the way on how to integrate it with openserctl?
>
> Thanks!
>
> Bogdan-Andrei Iancu wrote:
>
>> from 1.0.x to 1.1.x there was a change in how the phplib_id is 
>> computed..now is done via md5sum to avoid any shell compatibility 
>> problems (as before).
>>
>> check if you have the md5 utility on your system (typically is 
>> md5sum) or check if it has a different name than "md5sum"
>>
>> regards,
>> bogdan
>>
>>
>> Lindsey Hans Joseph Lao wrote:
>>
>>> Indeed, it has an empty value in the table... i am unable to add 
>>> subscribers because the error shown below occurs. this happened when 
>>> i switched from openser1.0.1 no tls to openser 1.1.0-tls.  Here's 
>>> what happens when I try to add a user to the database:
>>>
>>> md5sum: not found
>>> md5sum: not found
>>> md5sum: not found
>>>
>>> then it prompts for my mysql password. I don't think I have 
>>> installed those to binaries. However, when using openser1.0.1. I 
>>> couldn't encountering this error...
>>> Probably a bug?
>>>
>>> Thanks!
>>>
>>> Bogdan-Andrei Iancu wrote:
>>>
>>>> ok-  it must be the phplib_id column - can you check its value in 
>>>> the table? is must not be NULL or empty...
>>>>
>>>> I suspect your openserctl fails to compute the phplib_id and you 
>>>> get a constant empty string for all subscribers.. do you get any 
>>>> errors? do you have "md5sum" and "awk" installed on your machine?
>>>>
>>>> regards,
>>>> bogdan
>>>>
>>
>