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

[Bogdan-Andrei Iancu]

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
>>