<html>
<head>
<style>
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
FONT-SIZE: 10pt;
FONT-FAMILY:Tahoma
}
</style>
</head>
<body class='hmmessage'>
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='_new'>Check It Out!</a></body>
</html>