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

[Bogdan-Andrei Iancu]

maybe we should add for the future a detection of the md5 utility to 
avoid this kind of problems

regards,
bogdan

Lindsey Hans Joseph Lao wrote:

> it worked!  :-)  thanks a lot!
> Bogdan-Andrei Iancu wrote:
>
>> 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
>>>>>>
>>>>
>>>
>>
>