Project

General

Profile

Wazo on azure

Added by Dan Siemens over 2 years ago

The install will run but after you get a web page error of

error: xivo-confd must be running: Failed to connect to 127.0.0.1 port 9487: Connection refused

There are some references to the error on nerdvittles about clould-init package.

Azure has a debian 8 install but its likely not the same install as a minimal if you choose the iso on you own hardware.


Replies (7)

RE: Wazo on azure - Added by François Blackburn over 2 years ago

I've never installed wazo on Azure but you can check the status of wazo with:

xivo-service status all

And you can have more information about why xivo-confd doesn't run in:
/var/log/xivo-confd.log

and
systemctl status xivo-confd

RE: Wazo on azure - Added by Dan Siemens over 2 years ago

Looks like the db didn't get setup righ
Checking database...
Traceback (most recent call last):
File "/usr/bin/alembic", line 9, in <module>
load_entry_point('alembic==0.6.5', 'console_scripts', 'alembic')()
File "/usr/lib/python2.7/dist-packages/alembic/config.py", line 298, in main
CommandLine(prog=prog).main(argv=argv)
File "/usr/lib/python2.7/dist-packages/alembic/config.py", line 293, in main
self.run_cmd(cfg, options)
File "/usr/lib/python2.7/dist-packages/alembic/config.py", line 279, in run_cmd
**dict((k, getattr(options, k)) for k in kwarg)
File "/usr/lib/python2.7/dist-packages/alembic/command.py", line 233, in current
script.run_env()
File "/usr/lib/python2.7/dist-packages/alembic/script.py", line 203, in run_env
util.load_python_file(self.dir, 'env.py')
File "/usr/lib/python2.7/dist-packages/alembic/util.py", line 212, in load_python_file
module = load_module_py(module_id, path)
File "/usr/lib/python2.7/dist-packages/alembic/compat.py", line 58, in load_module_py
mod = imp.load_source(module_id, path, fp)
File "alembic/env.py", line 64, in <module>
run_migrations_online()
File "alembic/env.py", line 51, in run_migrations_online
connection = engine.connect()
File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1778, in connect
return self._connection_cls(self, **kwargs)
File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 60, in init
self.__connection = connection or engine.raw_connection()
File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1847, in raw_connection
return self.pool.unique_connection()
File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 280, in unique_connection
return ConnectionFairy._checkout(self)
File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 644, in _checkout
fairy = _ConnectionRecord.checkout(pool)
File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 440, in checkout
rec = pool._do_get()
File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 1057, in _do_get
return self._create_connection()
File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 285, in _create_connection
return _ConnectionRecord(self)
File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 411, in init
self.connection = self.
_connect()
File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 538, in connect
connection = self.__pool._creator()
File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/strategies.py", line 96, in connect
connection_invalidated=invalidated
File "/usr/lib/python2.7/dist-packages/sqlalchemy/util/compat.py", line 199, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb)
File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/strategies.py", line 90, in connect
return dialect.connect(*cargs, **cparams)
File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 377, in connect
return self.dbapi.connect(*cargs, **cparams)
File "/usr/lib/python2.7/dist-packages/psycopg2/__init
.py", line 164, in connect
conn = _connect(dsn, connection_factory=connection_factory, async=async)
sqlalchemy.exc.OperationalError: (OperationalError) FATAL: database "asterisk" does not exist
None None
Traceback (most recent call last):
File "/usr/bin/xivo-check-db", line 5, in <module>
main()
File "/usr/lib/python2.7/dist-packages/xivo_db/bin/check_db.py", line 26, in main
alembic.check_db()
File "/usr/lib/python2.7/dist-packages/xivo_db/alembic.py", line 32, in check_db
raise Exception('alembic command returned %s' % p.returncode)
Exception: alembic command returned 1
Checking services...
running rabbitmq-server
running consul
running postgresql
running nginx
running dahdi
running xivo-sysconfd
running xivo-confgend
running xivo-confd
running xivo-auth
stopped xivo-dxtora
stopped xivo-provd
stopped xivo-agid
stopped asterisk
stopped xivo-amid
stopped xivo-call-logs
stopped xivo-agentd
stopped xivo-ctid
stopped xivo-dird
stopped xivo-dird-phoned
stopped xivo-ctid-ng
stopped xivo-websocketd

RE: Wazo on azure - Added by Dan Siemens over 2 years ago

I dont' think its a localization error.

Comparing an iso install to a clould env. Its got to be something that isn't obvious. My goal it convert yet to rhel 7 yet. Just want to get the process down on my own installs.

RE: Wazo on azure - Added by Sylvain Boily over 2 years ago

I did an installation on azure with a minimal debian 8 jessie from azure market and followed the documentation http://documentation.wazo.community/en/stable/installation/installsystem.html#installing-from-a-minimal-debian-installation with the same issue. The problem is from the locale. The database is initialize with ASCII and we need to have UTF8.

RE: Wazo on azure - Added by Sylvain Boily over 2 years ago

To fix my installation, i did:

su - postgres
psql
postgres=# update pg_database set datallowconn = TRUE where datname = 'template0';
postgres=# \c template0
template0=# update pg_database set datistemplate = FALSE where datname = 'template1';
template0=# drop database template1;
template0=# create database template1 with template = template0 encoding = 'UTF8';
template0=# update pg_database set datistemplate = TRUE where datname = 'template1';
template0=# \c template1
template1=# update pg_database set datallowconn = FALSE where datname = 'template0';

Exit from psql

createdb asterisk

Return root

wazo-reset

RE: Wazo on azure - Added by Dan Siemens over 2 years ago

thanks for the instructions. They we very helpful!

    (1-7/7)