[Users] ERROR 1062 (23000): Duplicate entry

[Daniel-Constantin Mierla]

Hello,

reading again, I see you want to do it from MySQL. As Andreas Sikkema 
wrote, phplib_id needs to be just unique. Can be md5 over a random 
value. For ha1 and ha1b you have to read WWW Digest Authentication RFC 
to understand better. You can look in openserctl (openserctl and 
openserctl.base files) to see how the values are generated.

Cheers,
Daniel

On 03/21/07 15:54, alper ozbilen wrote:
> Dear Daniel,
>
> Thank you for your promt reply. I have already set my openserctl 
> config file as HAS_SERWEB="yes"
> But problem was not been fixed. is there another thing to make it fixed.
>
> Regards
> Alper Ozbilen
>
>
>> From: Daniel-Constantin Mierla <daniel at voice-system.ro>
>> Reply-To: daniel at voice-system.ro
>> To: Andreas Sikkema <h323 at ramdyne.nl>
>> CC: users at openser.org
>> Subject: Re: [Users] ERROR 1062 (23000): Duplicate entry
>> Date: Wed, 21 Mar 2007 15:22:17 +0200
>>
>> The issue is taht you have created serweb specific columns, but you 
>> didn't configured openserctl to populate them:
>>
>> See here how to fix:
>> http://openser.org/dokuwiki/doku.php/install:1.1.x-to-1.2.x#openserctl
>>
>> Cheers,
>> Daniel
>>
>> On 03/21/07 15:15, Andreas Sikkema wrote:
>>> On Wednesday 21 March 2007 14:05:05 alper ozbilen wrote:
>>>
>>>> I used openserctl add but mysql insert is vital to add user through 
>>>> php
>>>> interface.
>>>> As far as i know ha1 & ha1b & and phplib_id fields generated by 
>>>> md5sum??
>>>> must there be error in
>>>> md5sum ? if so, how can i do?
>>>>
>>>
>>> phplib_id need to be unique, but, IIRC, has no special meaning, so 
>>> anyting unique to the user can be put in there.
>>>
>>> We use a hybrid table consisting of all the columns from our 
>>> customer database and the columns openser needs to work for our 
>>> configuration. IIRC we don't even have the phplib_id column anymore, 
>>> but since I'm not in the office I can't check.
>>>
>>>
>>
>> _______________________________________________
>> Users mailing list
>> Users at openser.org
>> http://openser.org/cgi-bin/mailman/listinfo/users
>
> _________________________________________________________________
> Live Search Maps – find all the local information you need, right when 
> you need it. http://maps.live.com/?icid=hmtag2&FORM=MGAC01
>
>