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

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