Why don't you use openserctl add ....to add new user?
-----邮件原件----- 发件人: alper ozbilen [mailto:alperbilen@hotmail.com] 发送时间: 2007年3月21日 16:45 收件人: users@openser.org 主题: [Users] ERROR 1062 (23000): Duplicate entry
Dear All,
I can not insert a new subscriber from mysql console. When I look at subscireber table, ha1 & ha1b & and phplib_id fields looks null. So, i can only insert one new subscriber. When i attempt to insert second one, i get error written below:
ERROR 1062 (23000): Duplicate entry '' for key 3
Note : My insert sentence like that: insert into subscriber (username, domain, password, email_address) values ("testuser","myfon.com","testpasswd","emailoftestuser@myfon.com");
I am confused about what i should to do to fix null statement of ha1 & ha2 & and phplib_id fields.
on the other side, there is no probem to add new user through openserctl
What was the problem? I will wait your kind suggestion.
Regards, Alper Ozbilen
_________________________________________________________________ Exercise your brain! Try Flexicon. http://games.msn.com/en/flexicon/default.htm?icid=flexicon_hmemailtaglinemar...
_______________________________________________ Users mailing list Users@openser.org http://openser.org/cgi-bin/mailman/listinfo/users
I used openserctl add but mysql insert is vital to add user through php interface. As far as i know ha1 & ha1b & and phplib_id fields generated by md5sum?? must there be error in md5sum ? if so, how can i do?
Thanks again
From: ¹ùŸü jguo@qqtechnology.com To: "alper ozbilen" alperbilen@hotmail.com,users@openser.org Subject: ŽðžŽ: [Users] ERROR 1062 (23000): Duplicate entry Date: Wed, 21 Mar 2007 16:49:35 +0800
Why don't you use openserctl add ....to add new user?
Dear All,
I can not insert a new subscriber from mysql console. When I look at subscireber table, ha1 & ha1b & and phplib_id fields looks null. So, i can only insert one new subscriber. When i attempt to insert second one, i get error written below:
ERROR 1062 (23000): Duplicate entry '' for key 3
Note : My insert sentence like that: insert into subscriber (username, domain, password, email_address) values ("testuser","myfon.com","testpasswd","emailoftestuser@myfon.com");
I am confused about what i should to do to fix null statement of ha1 & ha2 & and phplib_id fields.
on the other side, there is no probem to add new user through openserctl
What was the problem? I will wait your kind suggestion.
Regards, Alper Ozbilen
Exercise your brain! Try Flexicon. http://games.msn.com/en/flexicon/default.htm?icid=flexicon_hmemailtaglinemar...
Users mailing list Users@openser.org http://openser.org/cgi-bin/mailman/listinfo/users
_________________________________________________________________ Get a FREE Web site, company branded e-mail and more from Microsoft Office Live! http://clk.atdmt.com/MRT/go/mcrssaub0050001411mrt/direct/01/
On Wednesday 21 March 2007 14:05:05 alper ozbilen wrote:
I used openserctl add but mysql insert is vital to add user through php interface. As far as i know ha1 & ha1b & and phplib_id fields generated by md5sum?? must there be error in md5sum ? if so, how can i do?
phplib_id need to be unique, but, IIRC, has no special meaning, so anyting unique to the user can be put in there.
We use a hybrid table consisting of all the columns from our customer database and the columns openser needs to work for our configuration. IIRC we don't even have the phplib_id column anymore, but since I'm not in the office I can't check.
The issue is taht you have created serweb specific columns, but you didn't configured openserctl to populate them:
See here how to fix: http://openser.org/dokuwiki/doku.php/install:1.1.x-to-1.2.x#openserctl
Cheers, Daniel
On 03/21/07 15:15, Andreas Sikkema wrote:
On Wednesday 21 March 2007 14:05:05 alper ozbilen wrote:
I used openserctl add but mysql insert is vital to add user through php interface. As far as i know ha1 & ha1b & and phplib_id fields generated by md5sum?? must there be error in md5sum ? if so, how can i do?
phplib_id need to be unique, but, IIRC, has no special meaning, so anyting unique to the user can be put in there.
We use a hybrid table consisting of all the columns from our customer database and the columns openser needs to work for our configuration. IIRC we don't even have the phplib_id column anymore, but since I'm not in the office I can't check.
Hi,
I have an ITSP account set up for IP, but they require a the username in the header in the first INVITE, so that they can authenticate it against the IP address. Is there a simple way to do that with OpenSER?
Thanks,
Scott Yagel PacketCall, Inc. syagel@packetcall.net
in which header?
Scott Yagel wrote:
Hi,
I have an ITSP account set up for IP, but they require a the username in the header in the first INVITE, so that they can authenticate it against the IP address. Is there a simple way to do that with OpenSER?
Thanks,
Scott Yagel PacketCall, Inc. syagel@packetcall.net
Users mailing list Users@openser.org http://openser.org/cgi-bin/mailman/listinfo/users
The 'from' header
Scott Yagel PacketCall, Inc. syagel@packetcall.net
-----Original Message----- From: Klaus Darilion [mailto:klaus.mailinglists@pernau.at] Sent: Wednesday, March 21, 2007 8:48 AM To: syagel@packetcall.net Cc: users@openser.org Subject: Re: [Users] username in header
in which header?
Scott Yagel wrote:
Hi,
I have an ITSP account set up for IP, but they require a the username in the header in the first INVITE, so that they can authenticate it against the IP address. Is there a simple way to do that with OpenSER?
Thanks,
Scott Yagel PacketCall, Inc. syagel@packetcall.net
Users mailing list Users@openser.org http://openser.org/cgi-bin/mailman/listinfo/users
Then here you are: http://openser.org/docs/modules/1.2.x/uac.html#AEN174
Regards, Ovidiu Sas
On 3/21/07, Scott Yagel syagel@packetcall.net wrote:
The 'from' header
Scott Yagel PacketCall, Inc. syagel@packetcall.net
-----Original Message----- From: Klaus Darilion [mailto:klaus.mailinglists@pernau.at] Sent: Wednesday, March 21, 2007 8:48 AM To: syagel@packetcall.net Cc: users@openser.org Subject: Re: [Users] username in header
in which header?
Scott Yagel wrote:
Hi,
I have an ITSP account set up for IP, but they require a the username in the header in the first INVITE, so that they can authenticate it against the IP address. Is there a simple way to do that with OpenSER?
Thanks,
Scott Yagel PacketCall, Inc. syagel@packetcall.net
Users mailing list Users@openser.org http://openser.org/cgi-bin/mailman/listinfo/users
Users mailing list Users@openser.org http://openser.org/cgi-bin/mailman/listinfo/users
Dear Daniel,
Thank you for your promt reply. I have already set my openserctl config file as HAS_SERWEB="yes" But problem was not been fixed. is there another thing to make it fixed.
Regards Alper Ozbilen
From: Daniel-Constantin Mierla daniel@voice-system.ro Reply-To: daniel@voice-system.ro To: Andreas Sikkema h323@ramdyne.nl CC: users@openser.org Subject: Re: [Users] ERROR 1062 (23000): Duplicate entry Date: Wed, 21 Mar 2007 15:22:17 +0200
The issue is taht you have created serweb specific columns, but you didn't configured openserctl to populate them:
See here how to fix: http://openser.org/dokuwiki/doku.php/install:1.1.x-to-1.2.x#openserctl
Cheers, Daniel
On 03/21/07 15:15, Andreas Sikkema wrote:
On Wednesday 21 March 2007 14:05:05 alper ozbilen wrote:
I used openserctl add but mysql insert is vital to add user through php interface. As far as i know ha1 & ha1b & and phplib_id fields generated by md5sum?? must there be error in md5sum ? if so, how can i do?
phplib_id need to be unique, but, IIRC, has no special meaning, so anyting unique to the user can be put in there.
We use a hybrid table consisting of all the columns from our customer database and the columns openser needs to work for our configuration. IIRC we don't even have the phplib_id column anymore, but since I'm not in the office I can't check.
Users mailing list Users@openser.org http://openser.org/cgi-bin/mailman/listinfo/users
_________________________________________________________________ Live Search Maps find all the local information you need, right when you need it. http://maps.live.com/?icid=hmtag2&FORM=MGAC01
Hello,
reading again, I see you want to do it from MySQL. As Andreas Sikkema wrote, phplib_id needs to be just unique. Can be md5 over a random value. For ha1 and ha1b you have to read WWW Digest Authentication RFC to understand better. You can look in openserctl (openserctl and openserctl.base files) to see how the values are generated.
Cheers, Daniel
On 03/21/07 15:54, alper ozbilen wrote:
Dear Daniel,
Thank you for your promt reply. I have already set my openserctl config file as HAS_SERWEB="yes" But problem was not been fixed. is there another thing to make it fixed.
Regards Alper Ozbilen
From: Daniel-Constantin Mierla daniel@voice-system.ro Reply-To: daniel@voice-system.ro To: Andreas Sikkema h323@ramdyne.nl CC: users@openser.org Subject: Re: [Users] ERROR 1062 (23000): Duplicate entry Date: Wed, 21 Mar 2007 15:22:17 +0200
The issue is taht you have created serweb specific columns, but you didn't configured openserctl to populate them:
See here how to fix: http://openser.org/dokuwiki/doku.php/install:1.1.x-to-1.2.x#openserctl
Cheers, Daniel
On 03/21/07 15:15, Andreas Sikkema wrote:
On Wednesday 21 March 2007 14:05:05 alper ozbilen wrote:
I used openserctl add but mysql insert is vital to add user through php interface. As far as i know ha1 & ha1b & and phplib_id fields generated by md5sum?? must there be error in md5sum ? if so, how can i do?
phplib_id need to be unique, but, IIRC, has no special meaning, so anyting unique to the user can be put in there.
We use a hybrid table consisting of all the columns from our customer database and the columns openser needs to work for our configuration. IIRC we don't even have the phplib_id column anymore, but since I'm not in the office I can't check.
Users mailing list Users@openser.org http://openser.org/cgi-bin/mailman/listinfo/users
Live Search Maps – find all the local information you need, right when you need it. http://maps.live.com/?icid=hmtag2&FORM=MGAC01
-
alper ozbilen -
Andreas Sikkema -
Daniel-Constantin Mierla -
Klaus Darilion -
Ovidiu Sas -
Scott Yagel -
郭军