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@openser.org http://openser.org/cgi-bin/mailman/listinfo/users