<div dir="ltr"><div>check again the same query see if you have any duplicates</div>
<div> </div>
<div>select count(*) from subscriber;</div>
<div> </div>
<div>ram<br><br></div>
<div class="gmail_quote">On Thu, Aug 28, 2008 at 7:11 PM, Alex R. S. M <span dir="ltr"><<a href="mailto:alex_rsm@hotmail.com">alex_rsm@hotmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<div>Hi,<br><br>Ijust added mysql module to my openser 1.2 and tried to test it by adding a couple of SIP users to the database.<br>I can verified there is only one default sub in the database:<br><br>mysql> select count(*) from subscriber;<br>
+----------+<br>| count(*) |<br>+----------+<br>| 1 | <br>+----------+<br>1 row in set (0.00 sec)<br><br>mysql> show tables;<br><br><br>I can add the first subscriber:<br><br># openserctl add 100 100 100@localhost<br>
-e database engine 'MYSQL' loaded<br>-e Control engine 'FIFO' loaded<br>-e is_user: user counter=0<br>-e check_db_alias: alias counter=0<br>-e mysql_query<br>-e insert<br>-e 0<br>-e new user '100' added<br>
<br>Howver, When I try to add the second subscriber I am getting the following error:<br><br># openserctl add 101 101 101@localhost<br>-e database engine 'MYSQL' loaded<br>-e Control engine 'FIFO' loaded<br>
-e is_user: user counter=0<br>-e check_db_alias: alias counter=0<br>ERROR 1062 (23000) at line 1: Duplicate entry '' for key 3<br>-e mysql_query<br>-e insert<br>-e 0<br>-e \E[37;31mERROR: introducing the new user '101' to the database failed<br>
root@bling1:/etc/openser# <br><br>What might be the problem?<br><br>Thanks,<br>Alex<br><br>
<hr>
See what people are saying about Windows Live. Check out featured posts. <a href="http://www.windowslive.com/connect?ocid=TXT_TAGLM_WL_connect2_082008" target="_blank">Check It Out!</a></div><br>_______________________________________________<br>
Users mailing list<br><a href="mailto:Users@lists.kamailio.org">Users@lists.kamailio.org</a><br><a href="http://lists.kamailio.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.kamailio.org/cgi-bin/mailman/listinfo/users</a><br>
<br></blockquote></div><br></div>