[Spce-user] Failed to create domain

[Alex Lutay]

Dear Martin,

It is exactly the reason of the issue.
You can fix it by executing:
> mysql -u root -e "update provisioning.xmlhosts set port='5582' where description='Prosody'"

Do you have any ideas why you have zero there?
The proper value was inserted by the following DB statement:
> /usr/share/ngcp-db-schema/db_scripts/diff/15001.up

So, maybe you have check that you DB/code is up-to-date:
> apt-get update && apt-get upgrade && \
>   ngcp-update-db-schema && ngcp-update-cfg-schema && \
>   ngcpcfg apply

Tnx!

On 07/01/14 12:43, Martin Stix wrote:
> It says port 0:
>
> root at spce <mailto:root at spce>:~# mysql -u root -e "select * from
> provisioning.xmlhosts"
> +----+-----------+------+-------+----------+--------------+
> | id | ip        | port | path  | sip_port | description  |
> +----+-----------+------+-------+----------+--------------+
> |  1 | 127.0.0.1 | 8000 | /RPC2 |     5062 | Kamailio     |
> |  2 | 127.0.0.1 | 8090 | /     |     NULL | Sems         |
> |  3 | 127.0.0.1 | 5062 | /     |     NULL | Kamailio-SR  |
> |  4 | 127.0.0.1 | 5060 | /     |     NULL | Loadbalancer |
> |  5 | 127.0.0.1 |    0 | /     |     NULL | Prosody      |
> +----+-----------+------+-------+----------+--------------+

-- 
Alexander Lutay
Head of Quality Assurance
Sipwise GmbH, Campus 21/Europaring F15
AT-2345 Brunn am Gebirge

Office: +43(0)13012036
Email: alutay at sipwise.com
Website: http://www.sipwise.com