17 Jan
2008
17 Jan
'08
6:45 p.m.
Only one new entry can be added in the "subscriber" table. Or, "Duplicate
entry '' for key 3" error responses.
Is there any way to create more than one user in this table?
Kevin,
_________________________________________________________________
MSN圣诞礼物火热登场，免费发放中，快来领取吧！
http://im.live.cn/emoticons/?ID=18
17 Jan
17 Jan
9:39 p.m.
New subject: [OpenSER-Users] OpenSER: Table "subscriber", only one new user can be added?
I guess you have installed serweb tables as well. If you have installed
serweb tables there is a setting in /etc/openser/openserctlrc which you
have to set to 1 (something like USE_SERWEB)
klaus
KevinKinnan wrote:
Only one new entry can be added in the
"subscriber" table. Or,
"Duplicate entry '' for key 3" error responses.
Is there any way to create more than one user in this table?
Kevin,
------------------------------------------------------------------------
“七件武器，七种完美” 立刻体验！ <http://get.live.cn>
------------------------------------------------------------------------
_______________________________________________
Users mailing list
Users(a)lists.openser.org
http://lists.openser.org/cgi-bin/mailman/listinfo/users
10:03 p.m.
El Jueves, 17 de Enero de 2008, KevinKinnan escribió:
Only one new entry can be added in the
"subscriber" table. Or, "Duplicate
entry '' for key 3" error responses.
Is there any way to create more than one user in this table?
The problem is that the "phplib" column is a UNIQUE key so you must make it
unique for each entry. But when creating a user with "openserctl" it set this
field as NULL (or maybe it's configurable).
So since I don't know what "phplib" column is (I suppose for
"SerWeb") what I
do is deleting that key.
--
Iñaki Baz Castillo
10:13 p.m.
Hmm ... this serweb tables seems to be creating a lot of confusion.
We should modify the default openserctlrc to not ask for serweb tables install.
This is as simple as setting:
INSTALL_SERWEB_TABLES=no
If the serweb tables are installed, the you need to set:
HAS_SERWEB=yes
If you don't install serweb tables, then you need to have
HAS_SERWEB=no (the default value).
By having INSTALL_SERWEB_TABLES=no in the default openserctl will
avoid a lot of trouble for new users. Who ever want's to install the
serweb tables, will need to deal with it.
But by letting a new user to choose to install the table or not to
install is not good, because most of the time they will choose to
install it and then they will run into this issue.
Regards,
Ovidiu Sas
On Jan 17, 2008 4:03 PM, Iñaki Baz Castillo <ibc(a)aliax.net> wrote:
El Jueves, 17 de Enero de 2008, KevinKinnan escribió:
Only one new entry can be added in the
"subscriber" table. Or, "Duplicate
entry '' for key 3" error responses.
Is there any way to create more than one user in this table?
The problem is that the "phplib" column is a UNIQUE key so you must make it
unique for each entry. But when creating a user with "openserctl" it set this
field as NULL (or maybe it's configurable).
So since I don't know what "phplib" column is (I suppose for
"SerWeb") what I
do is deleting that key.
--
Iñaki Baz Castillo
_______________________________________________
Users mailing list
Users(a)lists.openser.org
http://lists.openser.org/cgi-bin/mailman/listinfo/users
18 Jan
18 Jan
9:26 a.m.
On Thursday 17 January 2008 22:13:55 Ovidiu Sas wrote:
Hmm ... this serweb tables seems to be creating a lot
of confusion.
By having INSTALL_SERWEB_TABLES=no in the default
openserctl will
avoid a lot of trouble for new users. Who ever want's to install the
serweb tables, will need to deal with it.
But by letting a new user to choose to install the table or not to
install is not good, because most of the time they will choose to
install it and then they will run into this issue.
Completely agree. I know many cases of new users having this first issue.
--
Iñaki Baz Castillo
ibc(a)in.ilimit.es
9:58 a.m.
New subject: [OpenSER-Users] OpenSER: Table "subscriber", only one new user can be added?
I have already added a note to the install script which tell the use to
activate HAS_SERWEB if serweb tables are installed.
Maybe we should add another note during serweb table installation
question: "...say "no" if you don't know..."
regards
klaus
Ovidiu Sas schrieb:
Hmm ... this serweb tables seems to be creating a lot
of confusion.
We should modify the default openserctlrc to not ask for serweb tables install.
This is as simple as setting:
INSTALL_SERWEB_TABLES=no
If the serweb tables are installed, the you need to set:
HAS_SERWEB=yes
If you don't install serweb tables, then you need to have
HAS_SERWEB=no (the default value).
By having INSTALL_SERWEB_TABLES=no in the default openserctl will
avoid a lot of trouble for new users. Who ever want's to install the
serweb tables, will need to deal with it.
But by letting a new user to choose to install the table or not to
install is not good, because most of the time they will choose to
install it and then they will run into this issue.
Regards,
Ovidiu Sas
On Jan 17, 2008 4:03 PM, Iñaki Baz Castillo <ibc(a)aliax.net> wrote:
El Jueves, 17 de Enero de 2008, KevinKinnan
escribió:
_______________________________________________
Users mailing list
Users(a)lists.openser.org
http://lists.openser.org/cgi-bin/mailman/listinfo/users Only one new entry can be added in the
"subscriber" table. Or, "Duplicate
entry '' for key 3" error responses.
Is there any way to create more than one user in this table?
The problem is that
the "phplib" column is a UNIQUE key so you must make it
unique for each entry. But when creating a user with "openserctl" it set this
field as NULL (or maybe it's configurable).
So since I don't know what "phplib" column is (I suppose for
"SerWeb") what I
do is deleting that key.
--
Iñaki Baz Castillo
_______________________________________________
Users mailing list
Users(a)lists.openser.org
http://lists.openser.org/cgi-bin/mailman/listinfo/users
11:32 a.m.
On Thursday 17 January 2008, Ovidiu Sas wrote:
Hmm ... this serweb tables seems to be creating a lot
of confusion.
We should modify the default openserctlrc to not ask for serweb tables
install. This is as simple as setting:
INSTALL_SERWEB_TABLES=no
If the serweb tables are installed, the you need to set:
HAS_SERWEB=yes
If you don't install serweb tables, then you need to have
HAS_SERWEB=no (the default value).
Hi,
sounds reasonable. As this creates really confusion among new users, i'll
later change this, and also improve the documentation a little bit.
Cheers,
Henning
6118
days inactive
6119
days old
6 comments
6 participants
participants (6)
-
Henning Westerholt -
Iñaki Baz Castillo -
Iñaki Baz Castillo -
KevinKinnan -
Klaus Darilion -
Ovidiu Sas