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

[Lindsey Hans Joseph Lao]

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

-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
Size: 3249 bytes
Desc: S/MIME Cryptographic Signature
Url : http://lists.kamailio.org/pipermail/users/attachments/20061004/ef5efdc0/attachment.bin