<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none;"><!-- P {margin-top:0;margin-bottom:0;} --></style>
</head>
<body dir="ltr">
<div id="divtagdefaultwrapper" style="font-size:12pt;color:#000000;font-family:Calibri,Helvetica,sans-serif;" dir="ltr">
<p>Hi again,</p>
<p><br>
</p>
<p>we use the E164 Number as both the sip- and the web-username.</p>
<p>If I search for the number in Settings->Subscribers, it doesn't show up.</p>
<p><br>
</p>
<p>If I try to create the subscriber, the "Duplicate Entry" error is shown.</p>
<p><br>
</p>
<p>Terminating the subscriber wasn't possible, since the subscriber just never was there after initial creation. (For unknown reasons)</p>
<p>I tried terminating the related customer and then recreated it, but when again trying to create the subscriber,</p>
<p>there is the <span>"Duplicate Entry" error</span>.<br>
</p>
<p><br>
</p>
<p>So now there is an entry in the database for a subscriber number that doesn't show up in the search, leading to the error when trying to recreate it.<br>
</p>
<div><br>
</div>
<div>Will deleting the entry on db level from voip_subscribers mess things up in another place?</div>
<div>The dead entry in voip_subscribers also references an account_id that doesn't exist anymore.</div>
<div><br>
</div>
<div>Thanks again,</div>
<div><br>
</div>
<div>Ralf Eberhard<br>
</div>
<div><br>
</div>
<br>
<div style="color: rgb(0, 0, 0);">
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="divRplyFwdMsg" dir="ltr"><font style="font-size:11pt" face="Calibri, sans-serif" color="#000000"><b>Von:</b> Rene Krenn <rkrenn@sipwise.com><br>
<b>Gesendet:</b> Freitag, 5. Juni 2020 14:46<br>
<b>An:</b> Ralf Eberhard<br>
<b>Betreff:</b> AW: [Spce-user] Duplicate entry error on Subscriber creation</font>
<div> </div>
</div>
<div>
<div style="">
<p style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="font-family:"Calibri",sans-serif; color:black">>If not, what would be the way to cleanly delete that erroneous subscriber entry?</span></p>
<p style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="font-family:"Calibri",sans-serif; color:black">By design, subscribers and contracts are not deleted but terminated (=kept but hidden).</span></p>
<p style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="font-family:"Calibri",sans-serif; color:black">There are 3 main types of unique constraints involved to ensure consistency of a subscriber at db level:</span></p>
<p style="text-indent: -18pt; margin: 0cm 0cm 0.0001pt 36pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="font-family:"Calibri",sans-serif; color:black"><span style="">-<span style="font:7.0pt "Times New Roman"">
</span></span></span><span style="font-family:"Calibri",sans-serif; color:black">sipusername (have to be unique per domain)</span></p>
<p style="text-indent: -18pt; margin: 0cm 0cm 0.0001pt 36pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="font-family:"Calibri",sans-serif; color:black"><span style="">-<span style="font:7.0pt "Times New Roman"">
</span></span></span><span style="font-family:"Calibri",sans-serif; color:black">webusername (have to be unique per domain)</span></p>
<p style="text-indent: -18pt; margin: 0cm 0cm 0.0001pt 36pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="font-size:11.0pt; font-family:"Calibri",sans-serif; color:#1F497D"><span style="">-<span style="font:7.0pt "Times New Roman"">
</span></span></span><span style="font-family:"Calibri",sans-serif; color:black">numbers (have to be globally unique)</span><span style="font-size:11.0pt; font-family:"Calibri",sans-serif; color:#1F497D"></span></p>
<p style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="font-size:11.0pt; font-family:"Calibri",sans-serif; color:#1F497D">Teminating a subscriber considers all of this and is the safe way to go. If you see unique constraint errors such as
</span><span style=""><span style="font-family:"Calibri",sans-serif; color:black">"Failed to create subscriber (Duplicate entry '49xxxxxxxxx-3')", you might use sipusername/webusername or a numer already somewhere else.</span></span></p>
<p style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style=""><span style="font-family:"Calibri",sans-serif; color:black"> </span></span></p>
<p style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style=""><span style="font-family:"Calibri",sans-serif; color:black">br</span></span><span style="font-size:11.0pt; font-family:"Calibri",sans-serif; color:#1F497D"></span></p>
<p style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="font-size:11.0pt; font-family:"Calibri",sans-serif; color:#1F497D"> </span></p>
<div>
<div style="border:none; border-top:solid #E1E1E1 1.0pt; padding:3.0pt 0cm 0cm 0cm">
<p style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<b><span style="font-size:11.0pt; font-family:"Calibri",sans-serif" lang="DE">Von:</span></b><span style="font-size:11.0pt; font-family:"Calibri",sans-serif" lang="DE"> Ralf Eberhard via Spce-user [mailto:spce-user@lists.sipwise.com]
<br>
<b>Gesendet:</b> Freitag, 5. Juni 2020 14:26<br>
<b>An:</b> spce-user@lists.sipwise.com<br>
<b>Betreff:</b> [Spce-user] Duplicate entry error on Subscriber creation</span></p>
</div>
</div>
<p style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
</p>
<div id="divtagdefaultwrapper">
<p><span style=""><span style="font-family:"Calibri",sans-serif; color:black">Hello community,</span></span><span style="font-family:"Calibri",sans-serif; color:black"></span></p>
<p><span style="font-family:"Calibri",sans-serif; color:black"><br>
<br>
</span></p>
<p><span style=""><span style="font-family:"Calibri",sans-serif; color:black">after adding a subscriber to a customer, the subscriber doesn't show up under Customer>Subscribers.</span></span><span style="font-family:"Calibri",sans-serif; color:black"><br>
<br>
</span></p>
<p><span style=""><span style="font-family:"Calibri",sans-serif; color:black">When trying to create that subscriber again, we get the error "Failed to create subscriber (Duplicate entry '49xxxxxxxxx-3')"</span></span><span style="font-family:"Calibri",sans-serif; color:black"></span></p>
<p><span style="font-family:"Calibri",sans-serif; color:black"><br>
<br>
</span></p>
<div>
<p style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="font-family:"Calibri",sans-serif; color:black">select * from voip_subscribers where username = '49xxxxxxxx'; actually shows the subscriber. (With the correct account_id set)</span></p>
</div>
<div>
<p style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="font-family:"Calibri",sans-serif; color:black"> </span></p>
</div>
<div>
<p style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="font-family:"Calibri",sans-serif; color:black">After deleting the whole customer (via Web-Interface), the subscriber is still present in voip_subscribers.</span></p>
</div>
<div>
<p style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="font-family:"Calibri",sans-serif; color:black"> </span></p>
</div>
<div>
<p style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="font-family:"Calibri",sans-serif; color:black">Is it safe to just DELETE FROM voip_subscribers?</span></p>
</div>
<div>
<p style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="font-family:"Calibri",sans-serif; color:black">If not, what would be the way to cleanly delete that erroneous subscriber entry?</span></p>
</div>
<div>
<p style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="font-family:"Calibri",sans-serif; color:black"> </span></p>
</div>
<div>
<p style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="font-family:"Calibri",sans-serif; color:black">Thanks & kind regards,</span></p>
</div>
<div>
<p style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="font-family:"Calibri",sans-serif; color:black"> </span></p>
</div>
<div>
<p style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="font-family:"Calibri",sans-serif; color:black">Ralf Eberhard</span></p>
</div>
<p style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="font-family:"Calibri",sans-serif; color:black"> </span></p>
</div>
</div>
</div>
</div>
</div>
</body>
</html>