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

[Lindsey Hans Joseph Lao]

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
>
> Lindsey Hans Joseph Lao wrote:
>
>> Hello,
>>
>> Yes Bogdan, I'm sure it is not replicated. I checked it through mysql 
>> and the subscriber table only contains one entry, that is the default 
>> user with password:openserrw.
>> Any resolutions for this?
>>
>> Thanks!
>>
>> Bogdan-Andrei Iancu wrote:
>>
>>> Hi,
>>>
>>> there was a recent post about this - are you sure that the username 
>>> and domain are no duplicated?
>>>
>>> regards,
>>> bogdan
>>>
>>> Lindsey Hans Joseph Lao wrote:
>>>
>>>> Hello,
>>>>
>>>> I happen to encounter this error in Openser 1.1.0 with TLS:
>>>>
>>>> ERROR 1062 (23000) at line 1: Duplicate entry '' for key 'phplib_id'
>>>> \E[37;31mERROR: introducing the new user '1050' to the database failed
>>>>
>>>> This happens when I try to add users to the mysql database using 
>>>> openserctl add username password email-address. Are there any 
>>>> workarounds for this? or is this a bug in the recent version?
>>>>
>>>> Thanks!
>>>>
>>>> ------------------------------------------------------------------------ 
>>>>
>>>>
>>>> _______________________________________________
>>>> Users mailing list
>>>> Users at openser.org
>>>> http://openser.org/cgi-bin/mailman/listinfo/users
>>>>  
>>>>
>>>
>>
>

-------------- 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.sip-router.org/pipermail/sr-users/attachments/20061004/d26c8ba6/attachment.bin>