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

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

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