with what userid/pw? my root user doesn't work.
Nope. It does *NOT* work for me.The same credentials you use to log into the standard web interface.
no such script on my box./root/admin-pw-reset
no such script on my box.
export PGPASSWORD='proformatique'; psql -P pager=off -U asterisk -d asterisk -c "SELECT \"passwd\" from \"user\" where \"id\"=1"
Error!
Wazo authentication server connection error
root 12790 0.0 0.0 12728 2268 pts/0 S+ 14:24 0:00 grep -i auth
xivo-au+ 31390 1.8 1.0 1229768 88880 ? Sl May16 98:06 /usr/bin/python /usr/bin/xivo-auth --user xivo-auth
root@wazo:~#
root@wazo:~# ps auxw|grep auth
xivo-au+ 2091 6.0 1.0 1229512 87808 ? Sl 14:30 0:02 /usr/bin/python /usr/bin/xivo-auth --user xivo-auth
root 4044 0.0 0.0 12728 2132 pts/0 S+ 14:30 0:00 grep auth
root@wazo:~# lsof -p 2091
COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME
xivo-auth 2091 xivo-auth cwd DIR 254,0 4096 2 /
xivo-auth 2091 xivo-auth rtd DIR 254,0 4096 2 /
xivo-auth 2091 xivo-auth txt REG 254,0 3781768 4463363 /usr/bin/python2.7
xivo-auth 2091 xivo-auth mem REG 254,0 33896 4467358 /usr/lib/python2.7/dist-packages/_billiard.x86_64-linux-gnu.so
xivo-auth 2091 xivo-auth mem REG 254,0 24872 4719562 /usr/lib/python2.7/lib-dynload/termios.x86_64-linux-gnu.so
xivo-auth 2091 xivo-auth mem REG 254,0 70016 4467615 /usr/lib/python2.7/dist-packages/_ldap.so
xivo-auth 2091 xivo-auth mem REG 254,0 71432 5374017 /usr/lib/python2.7/dist-packages/mx/DateTime/mxDateTime/mxDateTime.so
xivo-auth 2091 xivo-auth mem REG 254,0 537248 4460955 /usr/lib/x86_64-linux-gnu/libgmp.so.10.2.0
xivo-auth 2091 xivo-auth mem REG 254,0 191968 4458762 /usr/lib/x86_64-linux-gnu/libhogweed.so.2.5
xivo-auth 2091 xivo-auth mem REG 254,0 203520 4458769 /usr/lib/x86_64-linux-gnu/libnettle.so.4.7
xivo-auth 2091 xivo-auth mem REG 254,0 80384 4461302 /usr/lib/x86_64-linux-gnu/libtasn1.so.6.3.2
xivo-auth 2091 xivo-auth mem REG 254,0 285104 4460966 /usr/lib/x86_64-linux-gnu/libp11-kit.so.0.0.0
xivo-auth 2091 xivo-auth mem REG 254,0 1177416 4457948 /usr/lib/x86_64-linux-gnu/libgnutls-deb0.so.28.41.0
xivo-auth 2091 xivo-auth mem REG 254,0 113520 4463054 /usr/lib/x86_64-linux-gnu/libsasl2.so.2.0.25
xivo-auth 2091 xivo-auth mem REG 254,0 59576 4463057 /usr/lib/x86_64-linux-gnu/liblber-2.4.so.2.10.3
xivo-auth 2091 xivo-auth mem REG 254,0 84856 3408934 /lib/x86_64-linux-gnu/libresolv-2.19.so
xivo-auth 2091 xivo-auth mem REG 254,0 14256 3408373 /lib/x86_64-linux-gnu/libkeyutils.so.1.5
xivo-auth 2091 xivo-auth mem REG 254,0 48088 4463045 /usr/lib/x86_64-linux-gnu/libkrb5support.so.0.1
xivo-auth 2091 xivo-auth mem REG 254,0 14640 3407923 /lib/x86_64-linux-gnu/libcom_err.so.2.1
xivo-auth 2091 xivo-auth mem REG 254,0 195400 4463047 /usr/lib/x86_64-linux-gnu/libk5crypto.so.3.1
xivo-auth 2091 xivo-auth mem REG 254,0 867776 4463050 /usr/lib/x86_64-linux-gnu/libkrb5.so.3.3
xivo-auth 2091 xivo-auth mem REG 254,0 327088 4463056 /usr/lib/x86_64-linux-gnu/libldap_r-2.4.so.2.10.3
xivo-auth 2091 xivo-auth mem REG 254,0 306072 4463052 /usr/lib/x86_64-linux-gnu/libgssapi_krb5.so.2.2
xivo-auth 2091 xivo-auth mem REG 254,0 198640 4459952 /usr/lib/x86_64-linux-gnu/libpq.so.5.7
xivo-auth 2091 xivo-auth mem REG 254,0 207552 5112535 /usr/lib/python2.7/dist-packages/psycopg2/_psycopg.so
xivo-auth 2091 xivo-auth mem REG 254,0 18912 4467604 /usr/lib/python2.7/dist-packages/netifaces.so
xivo-auth 2091 xivo-auth mem REG 254,0 66856 3407908 /lib/x86_64-linux-gnu/libbz2.so.1.0.4
xivo-auth 2091 xivo-auth mem REG 254,0 47440 4719587 /usr/lib/python2.7/lib-dynload/bz2.x86_64-linux-gnu.so
xivo-auth 2091 xivo-auth mem REG 254,0 11248 4719573 /usr/lib/python2.7/lib-dynload/resource.x86_64-linux-gnu.so
xivo-auth 2091 xivo-auth mem REG 254,0 33736 4719561 /usr/lib/python2.7/lib-dynload/_multiprocessing.x86_64-linux-gnu.so
xivo-auth 2091 xivo-auth mem REG 254,0 31784 3408935 /lib/x86_64-linux-gnu/librt-2.19.so
xivo-auth 2091 xivo-auth mem REG 254,0 125160 4466999 /usr/lib/x86_64-linux-gnu/libyaml-0.so.2.0.4
xivo-auth 2091 xivo-auth mem REG 254,0 203232 4467141 /usr/lib/python2.7/dist-packages/_yaml.so
xivo-auth 2091 xivo-auth mem REG 254,0 19624 4723560 /usr/lib/python2.7/dist-packages/sqlalchemy/cresultproxy.so
xivo-auth 2091 xivo-auth mem REG 254,0 10272 4723561 /usr/lib/python2.7/dist-packages/sqlalchemy/cutils.so
xivo-auth 2091 xivo-auth mem REG 254,0 15808 4723559 /usr/lib/python2.7/dist-packages/sqlalchemy/cprocessors.so
xivo-auth 2091 xivo-auth mem REG 254,0 10464 4985560 /usr/lib/python2.7/dist-packages/markupsafe/_speedups.so
xivo-auth 2091 xivo-auth mem REG 254,0 54248 4719563 /usr/lib/python2.7/lib-dynload/_json.x86_64-linux-gnu.so
xivo-auth 2091 xivo-auth mem REG 254,0 160888 4464895 /usr/lib/python2.7/dist-packages/_cffi_backend.x86_64-linux-gnu.so
xivo-auth 2091 xivo-auth mem REG 254,0 907808 5112738 /usr/lib/python2.7/dist-packages/cryptography/hazmat/bindings/_openssl.x86_64-linux-gnu.so
xivo-auth 2091 xivo-auth mem REG 254,0 18904 3407981 /lib/x86_64-linux-gnu/libuuid.so.1.3.0
xivo-auth 2091 xivo-auth mem REG 254,0 31048 4460925 /usr/lib/x86_64-linux-gnu/libffi.so.6.0.2
xivo-auth 2091 xivo-auth mem REG 254,0 141184 4719583 /usr/lib/python2.7/lib-dynload/_ctypes.x86_64-linux-gnu.so
xivo-auth 2091 xivo-auth mem REG 254,0 29464 4719595 /usr/lib/python2.7/lib-dynload/_hashlib.x86_64-linux-gnu.so
xivo-auth 2091 xivo-auth mem REG 254,0 2066816 4471962 /usr/lib/x86_64-linux-gnu/libcrypto.so.1.0.0
xivo-auth 2091 xivo-auth mem REG 254,0 395176 4471963 /usr/lib/x86_64-linux-gnu/libssl.so.1.0.0
xivo-auth 2091 xivo-auth mem REG 254,0 97872 4719580 /usr/lib/python2.7/lib-dynload/_ssl.x86_64-linux-gnu.so
xivo-auth 2091 xivo-auth mem REG 254,0 1607712 4464444 /usr/lib/locale/locale-archive
xivo-auth 2091 xivo-auth mem REG 254,0 47712 3408924 /lib/x86_64-linux-gnu/libnss_files-2.19.so
xivo-auth 2091 xivo-auth mem REG 254,0 43592 3408927 /lib/x86_64-linux-gnu/libnss_nis-2.19.so
xivo-auth 2091 xivo-auth mem REG 254,0 89104 3408917 /lib/x86_64-linux-gnu/libnsl-2.19.so
xivo-auth 2091 xivo-auth mem REG 254,0 31632 3408919 /lib/x86_64-linux-gnu/libnss_compat-2.19.so
xivo-auth 2091 xivo-auth mem REG 254,0 1738176 3408909 /lib/x86_64-linux-gnu/libc-2.19.so
xivo-auth 2091 xivo-auth mem REG 254,0 1051056 3408914 /lib/x86_64-linux-gnu/libm-2.19.so
xivo-auth 2091 xivo-auth mem REG 254,0 109144 3407972 /lib/x86_64-linux-gnu/libz.so.1.2.8
xivo-auth 2091 xivo-auth mem REG 254,0 10680 3408941 /lib/x86_64-linux-gnu/libutil-2.19.so
xivo-auth 2091 xivo-auth mem REG 254,0 14664 3408913 /lib/x86_64-linux-gnu/libdl-2.19.so
xivo-auth 2091 xivo-auth mem REG 254,0 137384 3408444 /lib/x86_64-linux-gnu/libpthread-2.19.so
xivo-auth 2091 xivo-auth mem REG 254,0 140928 3408905 /lib/x86_64-linux-gnu/ld-2.19.so
xivo-auth 2091 xivo-auth 0u CHR 1,3 0t0 7480 /dev/null
xivo-auth 2091 xivo-auth 1u CHR 1,3 0t0 7480 /dev/null
xivo-auth 2091 xivo-auth 2u CHR 1,3 0t0 7480 /dev/null
xivo-auth 2091 xivo-auth 3w REG 254,0 30707 4200283 /var/log/xivo-auth.log
xivo-auth 2091 xivo-auth 4u CHR 1,3 0t0 7480 /dev/null
xivo-auth 2091 xivo-auth 5u 0000 0,11 0 7475 anon_inode
xivo-auth 2091 xivo-auth 6r CHR 1,9 0t0 7485 /dev/urandom
xivo-auth 2091 xivo-auth 7u IPv4 23359 0t0 TCP localhost:49950->localhost:amqp (ESTABLISHED)
xivo-auth 2091 xivo-auth 8u IPv4 23360 0t0 TCP localhost:49952->localhost:amqp (ESTABLISHED)
xivo-auth 2091 xivo-auth 9u IPv4 23326 0t0 TCP *:9497 (LISTEN)
xivo-auth 2091 xivo-auth 11u IPv4 22301 0t0 TCP localhost:44194->localhostostgresql (ESTABLISHED)
xivo-auth 2091 xivo-auth 12u IPv4 24008 0t0 TCP localhost:44220->localhostostgresql (ESTABLISHED)
xivo-auth 2091 xivo-auth 13u IPv4 24021 0t0 TCP localhost:50016->localhost:amqp (ESTABLISHED)
xivo-auth 2091 xivo-auth 15r CHR 1,9 0t0 7485 /dev/urandom
root@wazo:~#
that was just after I tried the /admin URLroot@wazo:/var/log# tail -f xivo-auth.log
2017-05-21 13:05:56,086 [2091] (INFO) (xivo-auth): (127.0.0.1) GET https://localhost:9497/0.1/backends 200
2017-05-21 13:07:57,403 [2091] (INFO) (xivo-auth): (127.0.0.1) GET https://localhost:9497/0.1/backends 200
2017-05-21 13:09:58,707 [2091] (INFO) (xivo-auth): (127.0.0.1) GET https://localhost:9497/0.1/backends 200
2017-05-21 13:12:00,023 [2091] (INFO) (xivo-auth): (127.0.0.1) GET https://localhost:9497/0.1/backends 200
2017-05-21 13:14:01,348 [2091] (INFO) (xivo-auth): (127.0.0.1) GET https://localhost:9497/0.1/backends 200
2017-05-21 13:16:02,664 [2091] (INFO) (xivo-auth): (127.0.0.1) GET https://localhost:9497/0.1/backends 200
2017-05-21 13:18:03,993 [2091] (INFO) (xivo-auth): (127.0.0.1) GET https://localhost:9497/0.1/backends 200
2017-05-21 13:20:05,285 [2091] (INFO) (xivo-auth): (127.0.0.1) GET https://localhost:9497/0.1/backends 200
2017-05-21 13:22:06,594 [2091] (INFO) (xivo-auth): (127.0.0.1) GET https://localhost:9497/0.1/backends 200
2017-05-21 13:24:07,910 [2091] (INFO) (xivo-auth): (127.0.0.1) GET https://localhost:9497/0.1/backends 200
2017-05-21 13:26:09,217 [2091] (INFO) (xivo-auth): (127.0.0.1) GET https://localhost:9497/0.1/backends 200
There is no request to the authentication server... Please check wazo-admin-ui log.nothing....
that was just after I tried the /admin URL
2017-05-21 13:26:11,028 [1639] (ERROR) (wazo_admin_ui.core.errors): <type 'exceptions.Exception'>
Traceback (most recent call last):
File "/usr/lib/python2.7/dist-packages/flask/app.py", line 1475, in full_dispatch_request
rv = self.dispatch_request()
File "/usr/lib/python2.7/dist-packages/flask/app.py", line 1461, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "/usr/lib/python2.7/dist-packages/flask_classful.py", line 231, in proxy
response = view(**request.view_args)
File "/usr/lib/python2.7/dist-packages/flask_classful.py", line 202, in inner
return fn(*args, **kwargs)
File "/usr/lib/python2.7/dist-packages/wazo_admin_ui/plugins/authentication/view.py", line 27, in post
return self._login()
File "/usr/lib/python2.7/dist-packages/wazo_admin_ui/plugins/authentication/view.py", line 35, in _login
if form.validate_on_submit():
File "/usr/lib/python2.7/dist-packages/flask_wtf/form.py", line 101, in validate_on_submit
return self.is_submitted() and self.validate()
File "/usr/lib/python2.7/dist-packages/wazo_admin_ui/plugins/authentication/form.py", line 45, in validate
raise ValidationError(l_('Wazo authentication server connection error'))
ValidationError: Wazo authentication server connection error
2017-05-21 13:26:11,030 [1639] (INFO) (wazo_admin_ui): (127.0.0.1) POST https://wazo.lerctr.org/admin/login/ 302
2017-05-21 13:26:11,106 [1639] (INFO) (wazo_admin_ui): (127.0.0.1) GET https://wazo.lerctr.org/admin/ 302
2017-05-21 13:26:11,188 [1639] (INFO) (wazo_admin_ui): (127.0.0.1) GET https://wazo.lerctr.org/admin/login/ 200
2017-05-21 13:26:11,422 [1639] (INFO) (wazo_admin_ui): (127.0.0.1) GET https://wazo.lerctr.org/admin/static/fonts/fontawesome-webfont.woff2?v=4.7.0 200
root@wazo:/var/log#
Link up your team and customers Phone System Live Chat Video Conferencing
Hosted or Self-managed. Up to 10 users free forever. No credit card. Try risk free.
Check your inbox!
We’ve sent you an email. Click on the button in the email body to verify your email address – (if you can not find it, check your spam folder).
Upon verification you will be directed to the 3CX setup wizard.