Project

General

Profile

Import Export DB wazo - Déconnexion Interface

Added by Romain Romain 11 months ago

Bonjour,

On a procédé a un import export de la base de donnée d'un xivo ,vers un autre xivo (changement de vm) on a ensuite upgrader le xivo en wazo. Jusqu’à la tout tourne parfaitement , un seul probleme , a chaque modification sur un "utilisateur" nous sommes déconnectes de l'interface d'administration, un peu pénible.

Si vous avez une idée ?

Romain


Replies (9)

RE: Import Export DB wazo - Déconnexion Interface - Added by Pascal Cadotte-Michaud 11 months ago

Bonjour,

c'est un comportement que je n'ai jamais rencontré mais ça donne l'impression que le serveur n'a pas la bonne heure.

RE: Import Export DB wazo - Déconnexion Interface - Added by Romain Romain 11 months ago

Je viens de vérifier la date , elle est bien synchro bizarre. Niveau log je n'ai pas grand d'explicite

la deconnexion apparaît seulement sur une modification des utilisateurs. Les autres modification sous le wazo sont ok

RE: Import Export DB wazo - Déconnexion Interface - Added by Pascal Cadotte-Michaud 11 months ago

Que ce passe-t-il dans les logs lors de la sauvegarde?

/var/log/wazo-auth.log
/var/log/xivo-confd.log
/var/log/nginx/xivo-*.log

RE: Import Export DB wazo - Déconnexion Interface - Added by Romain Romain 11 months ago

Voila les logs sur une déconnexion a 15:14:07 après modification sur un user.

/var/log/wazo-auth.log


2018-09-04 15:13:09,926 [1803] (INFO) (wazo-auth): (127.0.0.1) HEAD https://localhost:9497/0.1/token/5eb8695c-0a93-44a6-aece-2fc24f522af6?scope=amid.action.Setvar.create 204
2018-09-04 15:13:50,429 [1803] (INFO) (wazo-auth): (127.0.0.1) POST https://127.0.0.1:9497/0.1/token 200
2018-09-04 15:14:01,543 [1803] (INFO) (wazo-auth): (127.0.0.1) HEAD https://localhost:9497/0.1/token/e9765a8a-d9e1-4241-83f9-433a96f257bd?scope=dird.directories.reverse.default.00000000-0000-0000-0000-000000000000.read 204
2018-09-04 15:14:30,690 [1803] (INFO) (wazo-auth): (127.0.0.1) HEAD https://localhost:9497/0.1/token/19699168-8da2-4f46-a328-61a78c06a9cb?scope=confd.lines.read 204

/var/log/xivo-confd.log

2018-09-04 15:13:54,993 [1333] (INFO) (xivo_confd): (127.0.0.1) GET http://127.0.0.1:9487/1.1/wizard 200
2018-09-04 15:14:01,982 [1333] (INFO) (xivo_confd.http_server): GET http://127.0.0.1:9487/1.1/wizard
2018-09-04 15:14:01,985 [1333] (INFO) (xivo_confd): (127.0.0.1) GET http://127.0.0.1:9487/1.1/wizard 200
2018-09-04 15:14:02,037 [1333] (INFO) (xivo_confd.http_server): GET http://127.0.0.1:9487/1.1/devices
2018-09-04 15:14:02,064 [1333] (INFO) (xivo_confd): (127.0.0.1) GET http://127.0.0.1:9487/1.1/devices 200
2018-09-04 15:14:02,082 [1333] (INFO) (xivo_confd.http_server): GET http://127.0.0.1:9487/1.1/users/58/lines
2018-09-04 15:14:02,089 [1333] (INFO) (xivo_confd): (127.0.0.1) GET http://127.0.0.1:9487/1.1/users/58/lines 200
2018-09-04 15:14:02,091 [1333] (INFO) (xivo_confd.http_server): GET http://127.0.0.1:9487/1.1/lines/59
2018-09-04 15:14:02,141 [1333] (INFO) (xivo_confd): (127.0.0.1) GET http://127.0.0.1:9487/1.1/lines/59 200
2018-09-04 15:14:02,144 [1333] (INFO) (xivo_confd.http_server): GET http://127.0.0.1:9487/1.1/lines/59/endpoints/sip
2018-09-04 15:14:02,182 [1333] (INFO) (xivo_confd): (127.0.0.1) GET http://127.0.0.1:9487/1.1/lines/59/endpoints/sip 200
2018-09-04 15:14:02,185 [1333] (INFO) (xivo_confd.http_server): GET http://127.0.0.1:9487/1.1/endpoints/sip/63
2018-09-04 15:14:02,197 [1333] (INFO) (xivo_confd): (127.0.0.1) GET http://127.0.0.1:9487/1.1/endpoints/sip/63 200
2018-09-04 15:14:02,200 [1333] (INFO) (xivo_confd.http_server): GET http://127.0.0.1:9487/1.1/lines/59/extensions
2018-09-04 15:14:02,238 [1333] (INFO) (xivo_confd): (127.0.0.1) GET http://127.0.0.1:9487/1.1/lines/59/extensions 200
2018-09-04 15:14:02,241 [1333] (INFO) (xivo_confd.http_server): GET http://127.0.0.1:9487/1.1/extensions/124
2018-09-04 15:14:02,260 [1333] (INFO) (xivo_confd): (127.0.0.1) GET http://127.0.0.1:9487/1.1/extensions/124 200
2018-09-04 15:14:02,264 [1333] (INFO) (xivo_confd.http_server): GET http://127.0.0.1:9487/1.1/lines/59/extensions
2018-09-04 15:14:02,300 [1333] (INFO) (xivo_confd): (127.0.0.1) GET http://127.0.0.1:9487/1.1/lines/59/extensions 200
2018-09-04 15:14:02,303 [1333] (INFO) (xivo_confd.http_server): GET http://127.0.0.1:9487/1.1/extensions/124
2018-09-04 15:14:02,318 [1333] (INFO) (xivo_confd): (127.0.0.1) GET http://127.0.0.1:9487/1.1/extensions/124 200
2018-09-04 15:14:02,320 [1333] (INFO) (xivo_confd.http_server): GET http://127.0.0.1:9487/1.1/extensions/124
2018-09-04 15:14:02,335 [1333] (INFO) (xivo_confd): (127.0.0.1) GET http://127.0.0.1:9487/1.1/extensions/124 200
2018-09-04 15:14:02,342 [1333] (INFO) (xivo_confd.http_server): GET http://127.0.0.1:9487/1.1/users/58/voicemails
2018-09-04 15:14:02,348 [1333] (ERROR) (xivo_confd.helpers.common): Resource Not Found - UserVoicemail was not found ('user_id': 58)
2018-09-04 15:14:02,349 [1333] (INFO) (xivo_confd): (127.0.0.1) GET http://127.0.0.1:9487/1.1/users/58/voicemails 404
2018-09-04 15:14:02,351 [1333] (INFO) (xivo_confd.http_server): GET http://127.0.0.1:9487/1.1/users/58/funckeys
2018-09-04 15:14:02,365 [1333] (INFO) (xivo_confd): (127.0.0.1) GET http://127.0.0.1:9487/1.1/users/58/funckeys 200
2018-09-04 15:14:02,377 [1333] (INFO) (xivo_confd.http_server): GET http://127.0.0.1:9487/1.1/moh
2018-09-04 15:14:02,384 [1333] (INFO) (xivo_confd): (127.0.0.1) GET http://127.0.0.1:9487/1.1/moh 200
2018-09-04 15:14:02,386 [1333] (INFO) (xivo_confd.http_server): GET http://127.0.0.1:9487/1.1/cti_profiles
2018-09-04 15:14:02,390 [1333] (INFO) (xivo_confd): (127.0.0.1) GET http://127.0.0.1:9487/1.1/cti_profiles 200
2018-09-04 15:14:02,408 [1333] (INFO) (xivo_confd.http_server): PUT http://127.0.0.1:9487/1.1/users/58/funckeys with data {"keys":{"1":{"label":"KATIA","blf":true,"destination":{"type":"user","user_id":4}}}}
2018-09-04 15:14:02,739 [1333] (INFO) (xivo_confd): (127.0.0.1) PUT http://127.0.0.1:9487/1.1/users/58/funckeys 204
2018-09-04 15:14:02,742 [1333] (INFO) (xivo_confd.http_server): PUT http://127.0.0.1:9487/1.1/lines/59 with data {"protocol":"sip","context":"default","registrar":"default","position":"1","caller_id_name":"anthony charreau","id":"59"}
2018-09-04 15:14:03,175 [1333] (INFO) (xivo_confd): (127.0.0.1) PUT http://127.0.0.1:9487/1.1/lines/59 204
2018-09-04 15:14:03,178 [1333] (INFO) (xivo_confd.http_server): GET http://127.0.0.1:9487/1.1/lines/59
2018-09-04 15:14:03,229 [1333] (INFO) (xivo_confd): (127.0.0.1) GET http://127.0.0.1:9487/1.1/lines/59 200
2018-09-04 15:14:03,232 [1333] (INFO) (xivo_confd.http_server): GET http://127.0.0.1:9487/1.1/lines/59/endpoints/sip
2018-09-04 15:14:03,266 [1333] (INFO) (xivo_confd): (127.0.0.1) GET http://127.0.0.1:9487/1.1/lines/59/endpoints/sip 200
2018-09-04 15:14:03,269 [1333] (INFO) (xivo_confd.http_server): GET http://127.0.0.1:9487/1.1/endpoints/sip/63
2018-09-04 15:14:03,280 [1333] (INFO) (xivo_confd): (127.0.0.1) GET http://127.0.0.1:9487/1.1/endpoints/sip/63 200
2018-09-04 15:14:03,282 [1333] (INFO) (xivo_confd.http_server): GET http://127.0.0.1:9487/1.1/lines/59/extensions
2018-09-04 15:14:03,323 [1333] (INFO) (xivo_confd): (127.0.0.1) GET http://127.0.0.1:9487/1.1/lines/59/extensions 200
2018-09-04 15:14:03,325 [1333] (INFO) (xivo_confd.http_server): GET http://127.0.0.1:9487/1.1/extensions/124
2018-09-04 15:14:03,341 [1333] (INFO) (xivo_confd): (127.0.0.1) GET http://127.0.0.1:9487/1.1/extensions/124 200
2018-09-04 15:14:03,344 [1333] (INFO) (xivo_confd.http_server): PUT http://127.0.0.1:9487/1.1/extensions/124 with data {"exten":"315","context":"default","id":124}
2018-09-04 15:14:03,403 [1333] (INFO) (xivo_confd): (127.0.0.1) PUT http://127.0.0.1:9487/1.1/extensions/124 204
2018-09-04 15:14:03,406 [1333] (INFO) (xivo_confd.http_server): GET http://127.0.0.1:9487/1.1/lines/59/devices
2018-09-04 15:14:03,448 [1333] (INFO) (xivo_confd): (127.0.0.1) GET http://127.0.0.1:9487/1.1/lines/59/devices 200
2018-09-04 15:14:04,540 [1333] (INFO) (xivo_confd.http_server): GET http://127.0.0.1:9487/1.1/wizard
2018-09-04 15:14:04,544 [1333] (INFO) (xivo_confd): (127.0.0.1) GET http://127.0.0.1:9487/1.1/wizard 200
2018-09-04 15:14:04,640 [1333] (INFO) (xivo_confd.http_server): GET http://127.0.0.1:9487/1.1/wizard
2018-09-04 15:14:04,643 [1333] (INFO) (xivo_confd): (127.0.0.1) GET http://127.0.0.1:9487/1.1/wizard 200
2018-09-04 15:14:04,740 [1333] (INFO) (xivo_confd.http_server): GET http://127.0.0.1:9487/1.1/wizard
2018-09-04 15:14:04,743 [1333] (INFO) (xivo_confd): (127.0.0.1) GET http://127.0.0.1:9487/1.1/wizard 200
2018-09-04 15:14:04,840 [1333] (INFO) (xivo_confd.http_server): GET http://127.0.0.1:9487/1.1/wizard
2018-09-04 15:14:04,843 [1333] (INFO) (xivo_confd): (127.0.0.1) GET http://127.0.0.1:9487/1.1/wizard 200
2018-09-04 15:14:30,678 [1333] (INFO) (xivo_confd.http_server): GET https://localhost:9486/1.1/lines?name=openipgeneral
2018-09-04 15:14:30,774 [1333] (INFO) (xivo_confd): (127.0.0.1) GET https://localhost:9486/1.1/lines?name=openipgeneral 200
2018-09-04 15:15:29,466 [1333] (INFO) (xivo_confd.http_server): GET https://localhost:9486/1.1/lines?name=openipgeneral

et enfin : le xivo-access

80.12.58.247 - - [04/Sep/2018:15:14:04 +0200] "POST /service/ipbx/index.php/pbx_settings/users/?act=edit&id=58 HTTP/1.1" 302 5 "https://wazotest.test.fr/service/ipbx/index.php/pbx_settings/users/?act=edit&id=58" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/68.0.3440.106 Safari/537.36"
80.12.58.247 - - [04/Sep/2018:15:14:04 +0200] "GET /service/ipbx/index.php/pbx_settings/users/?act=list HTTP/1.1" 302 5 "https://wazotest.test.fr/service/ipbx/index.php/pbx_settings/users/?act=edit&id=58" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/68.0.3440.106 Safari/537.36"
80.12.58.247 - - [04/Sep/2018:15:14:04 +0200] "GET /xivo/index.php?go=%252Fservice%252Fipbx%252Findex.php%252Fpbx_settings%252Fusers%252F%253Fact%253Dlist HTTP/1.1" 302 5 "https://wazotest.test.fr/service/ipbx/index.php/pbx_settings/users/?act=edit&id=58" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/68.0.3440.106 Safari/537.36"
80.12.58.247 - - [04/Sep/2018:15:14:04 +0200] "GET /xivo/logoff.php?go=%252Fservice%252Fipbx%252Findex.php%252Fpbx_settings%252Fusers%252F%253Fact%253Dlist HTTP/1.1" 302 5 "https://wazotest.test.fr/service/ipbx/index.php/pbx_settings/users/?act=edit&id=58" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/68.0.3440.106 Safari/537.36"
80.12.58.247 - - [04/Sep/2018:15:14:04 +0200] "GET /index.php?go=%252Fservice%252Fipbx%252Findex.php%252Fpbx_settings%252Fusers%252F%253Fact%253Dlist HTTP/1.1" 200 3780 "https://wazotest.test.fr/service/ipbx/index.php/pbx_settings/users/?act=edit&id=58" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/68.0.3440.106 Safari/537.36"
80.12.58.247 - - [04/Sep/2018:15:14:04 +0200] "GET /extra-libs/wazo/css/login.css?1519850973 HTTP/1.1" 200 281 "https://wazotest.test.fr/index.php?go=%252Fservice%252Fipbx%252Findex.php%252Fpbx_settings%252Fusers%252F%253Fact%253Dlist" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/68.0.3440.106 Safari/537.36"
80.12.58.247 - - [04/Sep/2018:15:14:04 +0200] "GET /extra-libs/adminlte/js/adminlte.min.js?1519850973 HTTP/1.1" 200 9774 "https://wazotest.test.fr/index.php?go=%252Fservice%252Fipbx%252Findex.php%252Fpbx_settings%252Fusers%252F%253Fact%253Dlist" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/68.0.3440.106 Safari/537.36"
80.12.58.247 - - [04/Sep/2018:15:14:04 +0200] "GET /extra-libs/bootstrap/js/bootstrap.min.js?1519850973 HTTP/1.1" 200 36868 "https://wazotest.test.fr/index.php?go=%252Fservice%252Fipbx%252Findex.php%252Fpbx_settings%252Fusers%252F%253Fact%253Dlist" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/68.0.3440.106 Safari/537.36"
80.12.58.247 - - [04/Sep/2018:15:14:04 +0200] "GET /extra-libs/bootstrap/css/bootstrap.min.css?1519850973 HTTP/1.1" 200 121260 "https://wazotest.test.fr/index.php?go=%252Fservice%252Fipbx%252Findex.php%252Fpbx_settings%252Fusers%252F%253Fact%253Dlist" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/68.0.3440.106 Safari/537.36"
80.12.58.247 - - [04/Sep/2018:15:14:04 +0200] "GET /extra-libs/jquery/jquery-1.9.1.min.js?1519850973 HTTP/1.1" 200 92629 "https://wazotest.test.fr/index.php?go=%252Fservice%252Fipbx%252Findex.php%252Fpbx_settings%252Fusers%252F%253Fact%253Dlist" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/68.0.3440.106 Safari/537.36"
80.12.58.247 - - [04/Sep/2018:15:14:04 +0200] "GET /extra-libs/adminlte/css/adminlte.min.css?1519850973 HTTP/1.1" 200 90011 "https://wazotest.test.fr/index.php?go=%252Fservice%252Fipbx%252Findex.php%252Fpbx_settings%252Fusers%252F%253Fact%253Dlist" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/68.0.3440.106 Safari/537.36"
80.12.58.247 - - [04/Sep/2018:15:14:05 +0200] "GET /extra-libs/adminlte/css/fonts.css HTTP/1.1" 200 6193 "https://wazotest.test.fr/index.php?go=%252Fservice%252Fipbx%252Findex.php%252Fpbx_settings%252Fusers%252F%253Fact%253Dlist" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/68.0.3440.106 Safari/537.36"
80.12.58.247 - - [04/Sep/2018:15:14:05 +0200] "GET /extra-libs/bootstrap/fonts/glyphicons-halflings-regular.woff2 HTTP/1.1" 200 18041 "https://wazotest.test.fr/extra-libs/bootstrap/css/bootstrap.min.css?1519850973" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/68.0.3440.106 Safari/537.36"
80.12.58.247 - - [04/Sep/2018:15:14:05 +0200] "GET /extra-libs/adminlte/fonts/source-sans-pro-v9-latin_latin-ext-regular.woff2 HTTP/1.1" 200 21057 "https://wazotest.test.fr/extra-libs/adminlte/css/fonts.css" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/68.0.3440.106 Safari/537.36"

RE: Import Export DB wazo - Déconnexion Interface - Added by Romain Romain 11 months ago

Bonjour,

Je relance le sujet pour ce petit bug?

RE: Import Export DB wazo - Déconnexion Interface - Added by Romain Romain 10 months ago

en fouillant un peu le s log dans /log/xivo/xivo-web-interface/xivo.log

quand je fais une modification sur un utilisateur on peut voir que je me déconnecte avec l'utilisateur "unknow"...


[2018-10-08T11:55:49+02:00] [65.39.65.69] [root] [logon] [www] logon
[2018-10-08T11:56:09+02:00] [65.39.65.69] [root] [edit] [www] lo
[2018-10-08T11:56:12+02:00] [65.39.65.69] [unknow] [logoff] [www] logoff

RE: Import Export DB wazo - Déconnexion Interface - Added by Romain Romain 7 months ago

Bonjour a tous,

je me permets de re-up ce sujet.

Merci

RE: Import Export DB wazo - Déconnexion Interface - Added by Sébastien Duthil 7 months ago

Salut,

y'a pas grand chose dans les logs, c'est dur de trouver ce qui cloche...
Tu vois quelque chose dans /var/log/xivo-web-interface/xivo.log et error.log?

RE: Import Export DB wazo - Déconnexion Interface - Added by Romain Romain 7 months ago

Salut Sébastien,

le fichier error.log est vide.

Pour le xivo.log :

[2019-01-08T14:21:12+01:00] [65.39.65.69] [root] [logon] [www] logon
[2019-01-08T14:38:48+01:00] [65.39.65.69] [root] [edit] [www] lo
[2019-01-08T14:38:52+01:00] [65.39.65.69] [unknow] [logoff] [www] logoff
[2019-01-08T14:39:44+01:00] [65.39.65.69] [root] [logon] [www] logon
[2019-01-08T15:17:33+01:00] [65.39.65.69] [root] [edit] [www] lo
[2019-01-08T15:17:37+01:00] [65.39.65.69] [unknow] [logoff] [www] logoff

    (1-9/9)