<HTML><BODY><span style="font-family: Arial, Tahoma, Verdana, sans-serif; font-size: 13px; line-height: 18.2000007629395px;" data-mce-style="font-family: Arial, Tahoma, Verdana, sans-serif; font-size: 13px; line-height: 18.2000007629395px;">I did't change a hostname. That was new installation - debian+sipwise.</span><br style="font-family: Arial, Tahoma, Verdana, sans-serif; font-size: 13px; line-height: 18.2000007629395px;" data-mce-style="font-family: Arial, Tahoma, Verdana, sans-serif; font-size: 13px; line-height: 18.2000007629395px;"><br style="font-family: Arial, Tahoma, Verdana, sans-serif; font-size: 13px; line-height: 18.2000007629395px;" data-mce-style="font-family: Arial, Tahoma, Verdana, sans-serif; font-size: 13px; line-height: 18.2000007629395px;"><p style="font-family: Arial, Tahoma, Verdana, sans-serif; font-size: 13px; line-height: 18.2000007629395px;" data-mce-style="font-family: Arial, Tahoma, Verdana, sans-serif; font-size: 13px; line-height: 18.2000007629395px;">cat /etc/ngcp_nodename</p><p style="font-family: Arial, Tahoma, Verdana, sans-serif; font-size: 13px; line-height: 18.2000007629395px;" data-mce-style="font-family: Arial, Tahoma, Verdana, sans-serif; font-size: 13px; line-height: 18.2000007629395px;">spce<br><br>I don't change anything there. I was install it 35 days ago.</p><br><br><br>Tue, 16 Sep 2014 11:18:26 +0200 от Alex Lutay <alutay@sipwise.com>:<br>
<blockquote style="border-left:1px solid #0857A6; margin:10px; padding:0 0 0 10px;">
<div id="">
<div class="js-helper js-readmsg-msg">
<style type="text/css"></style>
<div>
<base target="_self" href="https://e.mail.ru/">
<div id="style_14108591110000000527_BODY">Hi,<br>
<br>
Let me try to help you here.<br>
<br>
Brief history:<br>
- Sipwise tracks DB and config updates using the simple scripts:<br>
> <a href="https://github.com/sipwise/cfg-schema/tree/master/cfg_scripts/config" target="_blank">https://github.com/sipwise/cfg-schema/tree/master/cfg_scripts/config</a><br>
> <a href="https://github.com/sipwise/db-schema/tree/master/db_scripts/base" target="_blank">https://github.com/sipwise/db-schema/tree/master/db_scripts/base</a><br>
- The information about already executed scripts are stored in MySQL <br>
tables ngcp.db_schema and ngcp.cfg_schema.<br>
- Having a lot of different products CE (community edition), PRO (for <br>
professional usage) and Carrier (for huge telecoms providers) we need to <br>
store information about the host of script execution (column "node").<br>
- Historically we wrote there hostname of the server, later we <br>
released CE edition and noticed the problem that users are renaming the <br>
servers after installation, as a result the value into field "node" <br>
doesn't match for real hostname.<br>
- So, previously we suggested users update value in (column <br>
"ngcp.db_schema.node" and "ngcp.cfg_schema.node" to appropriate values).<br>
It produces another issues, like your one.<br>
- Finally we decided to stops using hostname there and introduced <br>
"nodename" (file which installed once and allows users easily renames <br>
servers):<br>
> root@spce:~# cat /etc/ngcp_nodename<br>
> spce<br>
> root@spce:~#<br>
<br>
Since that time new CE installations should have "spce" in <br>
"ngcp_nodename" as well as into field "node" of the tables above<br>
> <a href="https://github.com/sipwise/installer/commit/f9b49eb1282b93c0e6cb60c71ad0755c9fa6178f" target="_blank">https://github.com/sipwise/installer/commit/f9b49eb1282b93c0e6cb60c71ad0755c9fa6178f</a><br>
<br>
Also old systems (users manually changed "node" field in DB) should get <br>
DB update:<br>
> <a href="https://github.com/sipwise/upgrade/commit/34a620fb6d484b2de16204930bf4ec0f9088431a" target="_blank">https://github.com/sipwise/upgrade/commit/34a620fb6d484b2de16204930bf4ec0f9088431a</a><br>
<br>
I suppose you have installed mr3.4.1 and updated "node" field manually <br>
some time ago.<br>
So, to fix your issue just check that you have file "/etc/ngcp_nodename" <br>
with content "spce" and update DB:<br>
> mysql -u root ngcp -e 'update db_schema set node = "spce"; update cfg_schema set node = "spce";'<br>
<br>
and retry the DB/CFG upgrade part + apply new configs<br>
> ngcp-update-db-schema && ngcp-update-cfg-schema && ngcpcfg apply<br>
<br>
I hope it will bring some light on the issue for other users.<br>
Since that time you can change the hostname anytime.<br>
<br>
On 15/09/14 23:29, Sergey Kharlamov wrote:<br>
> I have a new installation mr3.4.1<br>
><br>
> Trying to do first update using command<br>
><br>
> apt-get update && apt-get upgrade && ngcp-update-db-schema &&<br>
> ngcp-update-cfg-schema && ngcpcfg apply<br>
><br>
> I see the error:<br>
[...skipped...]<br>
> Applying revision script<br>
> /usr/share/ngcp-db-schema/db_scripts/base/0070_not_replicated.up: ERROR<br>
> 1050 (42S01) at line 2: Table 'acc_backup' already exists<br>
><br>
> failed. :(<br>
><br>
> Please resolve the problem and run ngcp-update-db-schema again.<br>
<br>
-- <br>
Alexander Lutay<br>
Head of Quality Assurance<br>
Sipwise GmbH, Campus 21/Europaring F15<br>
AT-2345 Brunn am Gebirge<br>
<br>
Office: +43(0)13012036<br>
Email: <a href="/compose?To=alutay@sipwise.com">alutay@sipwise.com</a><br>
Website: <a href="http://www.sipwise.com" target="_blank">http://www.sipwise.com</a><br>
</div>
<base target="_self" href="https://e.mail.ru/">
</div>
</div>
</div>
</blockquote>
<br>
<br>-- <br>Sergey Kharlamov<br></BODY></HTML>