<div dir="ltr">Hello Alexander<br><br class="gmail-Apple-interchange-newline"><table cellpadding="0" class="gmail-cf gmail-gJ" style="border-collapse:collapse;margin-top:0px;width:auto;font-family:"Google Sans",Roboto,RobotoDraft,Helvetica,Arial,sans-serif;font-size:14px;display:block"><tbody style="display:block"><tr class="gmail-acZ" style="height:auto;display:flex"><td class="gmail-gF gmail-gK" style="padding:0px;vertical-align:top;width:1122.58px;line-height:20px;display:block;max-height:20px"><span style="font-family:Arial,Helvetica,sans-serif;font-size:small">> we installed a new server including the latest version mr12.5.1.</span></td></tr></tbody></table><p class="MsoNormal"><span lang="EN-US">> After checking the system using ngcp-status --all the following message appears:<br>Sorry, I can't reproduce this issue.<br><br>ngcp-mysql-compare-dbs reports that in database '</span>provisioning' several tables like 'voip_dom_preferences', 'voip_contacts', 'voip_dbaliases', etc don't have required constraints.<br>I guess the constraints were created but with different names.<br>Show the output of "mysql provisioning -e 'show create table voip_dom_preferences\G'</p><p class="MsoNormal"><span lang="EN-US"><br></span></p></div><br><div class="gmail_quote gmail_quote_container"><div dir="ltr" class="gmail_attr">On Mon, Feb 3, 2025 at 4:42 PM Alexander Schwarz <<a href="mailto:schwarz@flow7.de">schwarz@flow7.de</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div class="msg-1348662025527585948">





<div lang="DE" style="overflow-wrap: break-word;">
<div class="m_-1348662025527585948WordSection1">
<p class="MsoNormal"><span lang="EN-US">Hello,<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">we installed a new server including the latest version mr12.5.1.<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">After checking the system using ngcp-status --all the following message appears:<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">DB: detect divergence in mysql schemes, run ngcp-mysql-compare-dbs to check detail.<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">.\ngcp-mysql-compare-dbs:<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">The following errors were found:<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">Element: constraints/provisioning/voip_contacts/voip_contacts_ibfk_1/subscriber_id/voip_subscribers/id is missing in local db<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">Element: constraints/provisioning/voip_dbaliases/voip_dbaliases_ibfk_1/domain_id/voip_domains/id is missing in local db<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">Element: constraints/provisioning/voip_dbaliases/voip_dbaliases_ibfk_2/subscriber_id/voip_subscribers/id is missing in local db<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">Element: constraints/provisioning/voip_dom_preferences/voip_dom_preferences_ibfk_1/domain_id/voip_domains/id is missing in local db<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">Element: constraints/provisioning/voip_dom_preferences/voip_dom_preferences_ibfk_2/attribute_id/voip_preferences/id is missing in local db<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">Element: constraints/provisioning/voip_fax_destinations/voip_fax_destinations_ibfk_1/subscriber_id/voip_subscribers/id is missing in local db<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">Element: constraints/provisioning/voip_fax_preferences/voip_fax_preferences_ibfk_1/subscriber_id/voip_subscribers/id is missing in local db<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">Element: constraints/provisioning/voip_peer_preferences/voip_peer_preferences_ibfk_1/peer_host_id/voip_peer_hosts/id is missing in local db<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">Element: constraints/provisioning/voip_peer_preferences/voip_peer_preferences_ibfk_2/attribute_id/voip_preferences/id is missing in local db<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">Element: constraints/provisioning/voip_subscribers/voip_subscribers_ibfk_1/domain_id/voip_domains/id is missing in local db<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">Element: constraints/provisioning/voip_usr_preferences/voip_usr_preferences_ibfk_1/subscriber_id/voip_subscribers/id is missing in local db<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">Element: constraints/provisioning/voip_usr_preferences/voip_usr_preferences_ibfk_2/attribute_id/voip_preferences/id is missing in local db<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">Would you please provide a fix for this issue?<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">We would like to update our productive systems for several reasons, but we fear that we will also receive this error<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">Best regards,<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">Alex<u></u><u></u></span></p>
</div>
</div>

-- <br>
Spce-user mailing list<br>
<a href="mailto:Spce-user@lists.sipwise.com" target="_blank">Spce-user@lists.sipwise.com</a><br>
<a href="http://lists.sipwise.com/mailman/listinfo/spce-user_lists.sipwise.com" rel="noreferrer" target="_blank">http://lists.sipwise.com/mailman/listinfo/spce-user_lists.sipwise.com</a><br>
</div></blockquote></div><div><br clear="all"></div><div><br></div><span class="gmail_signature_prefix">-- </span><br><div dir="ltr" class="gmail_signature"><div dir="ltr">WBR<div>---<br>Mykola Malkov</div></div></div>