4 Oct
2006
4 Oct
'06
10:28 a.m.
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!
4 Oct
4 Oct
11:23 a.m.
New subject: [Users] ERROR 1062 (23000) at line 1: Duplicate entry '' for key 'phplib_id'
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(a)openser.org
http://openser.org/cgi-bin/mailman/listinfo/users
12:35 p.m.
New subject: [Users] ERROR 1062 (23000) at line 1: Duplicate entry '' for key 'phplib_id'
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(a)openser.org
http://openser.org/cgi-bin/mailman/listinfo/users
2 p.m.
New subject: [Users] ERROR 1062 (23000) at line 1: Duplicate entry '' for key 'phplib_id'
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(a)openser.org
http://openser.org/cgi-bin/mailman/listinfo/users
2:14 p.m.
New subject: [Users] ERROR 1062 (23000) at line 1: Duplicate entry '' for key 'phplib_id'
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(a)openser.org
http://openser.org/cgi-bin/mailman/listinfo/users
2:20 p.m.
New subject: [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
>
2:50 p.m.
New subject: [Users] ERROR 1062 (23000) at line 1: Duplicate entry '' for key 'phplib_id'
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
>
2:55 p.m.
New subject: [Users] ERROR 1062 (23000) at line 1: Duplicate entry '' for key 'phplib_id'
you can run "MD5=md5 openserctl ...." or for a permanent change see in
openserctl.base file the MD5 definition.
regards,
bogdan
Lindsey Hans Joseph Lao wrote:
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
>
6627
days inactive
6627
days old
7 comments
2 participants
participants (2)
-
Bogdan-Andrei Iancu -
Lindsey Hans Joseph Lao