Forums » Discussions & Questions »
Souci peer Xivo
Ajouté par yohan VITU il y a presque 4 ans
Bonjour,
après avoir restauré une savegarde sur un ancien Xivo 16.08 qui a crasher, j'ai des soucis, impossible de provisioner un téléphone, et après
un peu de recherche dans les logs en fait c'est le peer qui ne se créé pas lors de la création de l'utilisateur :
j'ai cet erreur :
sip show peer v6npqj1v
Peer v6npqj1v not found.
Alors qu'il est bien présent dans mon interface web, section ligne utilisateur.
dans le xivo-confd j'ai cette erreur à répétition:
2021-02-17 18:01:27,761 [1358] (INFO) (service_discovery): registration failed, retrying in 2 seconds
2021-02-17 18:01:29,762 [1358] (INFO) (urllib3.connectionpool): Starting new HTTP connection (1): localhost
2021-02-17 18:01:29,763 [1358] (INFO) (xivo_confd.application): GET http://localhost:9487/1.1/infos
2021-02-17 18:01:29,765 [1358] (INFO) (xivo_confd): (127.0.0.1) GET http://localhost:9487/1.1/infos 200
2021-02-17 18:01:29,766 [1358] (INFO) (service_discovery): Registering xivo-confd on Consul as 106fa925-8dc2-461c-bca4-15bce927f4e5 with 192.168.81.125:9487
2021-02-17 18:01:29,767 [1358] (INFO) (urllib3.connectionpool): Starting new HTTPS connection (1): localhost
2021-02-17 18:01:29,768 [1358] (ERROR) (service_discovery): failed to register service
Traceback (most recent call last):
File "/usr/lib/python2.7/dist-packages/xivo/consul_helpers.py", line 121, in _register
self._registerer.register()
File "/usr/lib/python2.7/dist-packages/xivo/consul_helpers.py", line 226, in register
super(NotifyingRegisterer, self).register()
File "/usr/lib/python2.7/dist-packages/xivo/consul_helpers.py", line 170, in register
raise RegistererError(str(e))
RegistererError: ('Connection aborted.', error(111, 'Connection refused'))
2021-02-17 18:01:29,768 [1358] (INFO) (service_discovery): registration failed, retrying in 2 seconds
2021-02-17 18:01:31,769 [1358] (INFO) (urllib3.connectionpool): Starting new HTTP connection (1): localhost
2021-02-17 18:01:31,770 [1358] (INFO) (xivo_confd.application): GET http://localhost:9487/1.1/infos
2021-02-17 18:01:31,773 [1358] (INFO) (xivo_confd): (127.0.0.1) GET http://localhost:9487/1.1/infos 200
2021-02-17 18:01:31,774 [1358] (INFO) (service_discovery): Registering xivo-confd on Consul as 106fa925-8dc2-461c-bca4-15bce927f4e5 with 192.168.81.125:9487
2021-02-17 18:01:31,775 [1358] (INFO) (urllib3.connectionpool): Starting new HTTPS connection (1): localhost
2021-02-17 18:01:31,775 [1358] (ERROR) (service_discovery): failed to register service
Traceback (most recent call last):
File "/usr/lib/python2.7/dist-packages/xivo/consul_helpers.py", line 121, in _register
self._registerer.register()
File "/usr/lib/python2.7/dist-packages/xivo/consul_helpers.py", line 226, in register
super(NotifyingRegisterer, self).register()
File "/usr/lib/python2.7/dist-packages/xivo/consul_helpers.py", line 170, in register
raise RegistererError(str(e))
RegistererError: ('Connection aborted.', error(111, 'Connection refused'))
2021-02-17 18:01:31,775 [1358] (INFO) (service_discovery): registration failed, retrying in 2 seconds
j'ai déjà fait un xivo-update-config au cas où
Réponses (10)
RE: Souci peer Xivo - Ajouté par Laurent MEILLER il y a presque 4 ans
Bonjour,
Que donne un xivo-service status all
?
RE: Souci peer Xivo - Ajouté par yohan VITU il y a presque 4 ans
hello,
Checking database...
OK
Checking services...
running rabbitmq-server
stopped consul
running postgresql
running nginx
running dahdi
running xivo-sysconfd
running xivo-confgend
running xivo-confd
running xivo-auth
running xivo-dxtora
running xivo-provd
running xivo-agid
running asterisk
running xivo-amid
running xivo-call-logs
running xivo-agentd
stopped xivo-ctid
running xivo-dird
running xivo-dird-phoned
running xivo-ctid-ng
running xivo-websocketd
RE: Souci peer Xivo - Ajouté par yohan VITU il y a presque 4 ans
j'ai cette erreur :
/etc/init.d/consul restart
[....] Restarting consul (via systemctl): consul.serviceJob for consul.service failed. See 'systemctl status consul.service' and 'journalctl -xn' for details.
failed!
et j'obtiens cela :
systemctl status consul.service
● consul.service - Consul agent
Loaded: loaded (/lib/systemd/system/consul.service; enabled)
Active: failed (Result: exit-code) since jeu. 2021-02-18 20:59:40 CET; 14s ago
Process: 7116 ExecStartPost=/usr/bin/consul-wait-leader (code=exited, status=1/FAILURE)
Process: 7115 ExecStart=/usr/bin/consul agent -config-dir ${CONFIG_DIR} -pid-file /var/run/consul/consul.pid (code=exited, status=1/FAILURE)
Process: 7113 ExecStartPre=/usr/bin/install -d -o consul -g consul /var/run/consul (code=exited, status=0/SUCCESS)
Main PID: 7115 (code=exited, status=1/FAILURE)
févr. 18 20:59:10 xivo-hdv consul[7115]: consul: adding LAN server xivo (Addr: 127.0.0.1:8300) (DC: xivo)
févr. 18 20:59:10 xivo-hdv consul[7115]: consul: adding WAN server xivo (Addr: 127.0.0.1:8300) (DC: xivo)
févr. 18 20:59:10 xivo-hdv consul[7115]: serf: Attempting re-join to previously known node: xivo: 127.0.0.1:8302
févr. 18 20:59:10 xivo-hdv consul[7115]: serf: Re-joined to previously known node: xivo: 127.0.0.1:8301
févr. 18 20:59:10 xivo-hdv consul[7115]: serf: Re-joined to previously known node: xivo: 127.0.0.1:8302
févr. 18 20:59:10 xivo-hdv consul[7115]: ==> Error starting agent: Failed decoding check file "/var/lib/consul/checks/d21255cd5d6954bfaf2c190cdec2039c": un...JSON input
févr. 18 20:59:10 xivo-hdv systemd[1]: consul.service: main process exited, code=exited, status=1/FAILURE
févr. 18 20:59:40 xivo-hdv systemd[1]: consul.service: control process exited, code=exited status=1
févr. 18 20:59:40 xivo-hdv systemd[1]: Failed to start Consul agent.
févr. 18 20:59:40 xivo-hdv systemd[1]: Unit consul.service entered failed state.
Hint: Some lines were ellipsized, use -l to show in full.
RE: Souci peer Xivo - Ajouté par yohan VITU il y a presque 4 ans
J'ai supprimé le fichier
/var/lib/consul/checks/d21255cd5d6954bfaf2c190cdec2039c
Comme vue sur un forum, puis fait un restart de consul et j'ai ceci maintenant :
je n'ose aps redémarrer tous les services du Xivo..
systemctl status consul.service
● consul.service - Consul agent
Loaded: loaded (/lib/systemd/system/consul.service; enabled)
Active: failed (Result: exit-code) since jeu. 2021-02-18 21:12:03 CET; 11h ago
Process: 9355 ExecStartPost=/usr/bin/consul-wait-leader (code=exited, status=1/FAILURE)
Process: 9354 ExecStart=/usr/bin/consul agent -config-dir ${CONFIG_DIR} -pid-file /var/run/consul/consul.pid (code=exited, status=2)
Process: 9353 ExecStartPre=/usr/bin/install -d -o consul -g consul /var/run/consul (code=exited, status=0/SUCCESS)
Main PID: 9354 (code=exited, status=2)
févr. 18 21:11:34 xivo-hdv consul[9354]: github.com/hashicorp/consul/vendor/github.com/hashicorp/raft.(*Raft).(github.com/hashicorp/consul/vendor/github.com/has...t.run)-fm()
févr. 18 21:11:34 xivo-hdv consul[9354]: /gopath/src/github.com/hashicorp/consul/vendor/github.com/hashicorp/raft/raft.go:252 +0x20
févr. 18 21:11:34 xivo-hdv consul[9354]: github.com/hashicorp/consul/vendor/github.com/hashicorp/raft.(*raftState).goFunc.func1(0x18f36240, 0x19025a48)
févr. 18 21:11:34 xivo-hdv consul[9354]: /gopath/src/github.com/hashicorp/consul/vendor/github.com/hashicorp/raft/state.go:152 +0x3f
févr. 18 21:11:34 xivo-hdv consul[9354]: created by github.com/hashicorp/consul/vendor/github.com/hashicorp/raft.(*raftState).goFunc
févr. 18 21:11:34 xivo-hdv consul[9354]: /gopath/src/github.com/hashicorp/consul/vendor/github.com/hashicorp/raft/state.go:153 +0x46
févr. 18 21:11:34 xivo-hdv systemd[1]: consul.service: main process exited, code=exited, status=2/INVALIDARGUMENT
févr. 18 21:12:03 xivo-hdv systemd[1]: consul.service: control process exited, code=exited status=1
févr. 18 21:12:03 xivo-hdv systemd[1]: Failed to start Consul agent.
févr. 18 21:12:03 xivo-hdv systemd[1]: Unit consul.service entered failed state.
Hint: Some lines were ellipsized, use -l to show in full.
RE: Souci peer Xivo - Ajouté par yohan VITU il y a presque 4 ans
sudo -u consul /usr/bin/consul agent -config-dir /etc/consul/xivo -pid-file /var/run/consul/consul.pid
==> WARNING: BootstrapExpect Mode is specified as 1; this is the same as Bootstrap mode.
==> WARNING: Bootstrap mode enabled! Do not enable unless necessary
==> Starting Consul agent...
==> Starting Consul agent RPC...
==> Consul agent running!
Node name: 'xivo-hdv'
Datacenter: 'xivo-hdv'
Server: true (bootstrap: true)
Client Addr: 127.0.0.1 (HTTP: -1, HTTPS: 8500, DNS: -1, RPC: 8400)
Cluster Addr: 127.0.0.1 (LAN: 8301, WAN: 8302)
Gossip encrypt: false, RPC-TLS: false, TLS-Incoming: false
Atlas: <disabled>
==> Log data will now stream in as it occurs:
2021/02/19 08:24:44 [INFO] raft: Restored from snapshot 39-32781642-1610114386219
2021/02/19 08:24:44 [INFO] serf: Ignoring previous leave in snapshot
2021/02/19 08:24:44 [INFO] serf: EventMemberJoin: xivo-hdv 127.0.0.1
2021/02/19 08:24:44 [INFO] serf: Ignoring previous leave in snapshot
2021/02/19 08:24:44 [INFO] serf: EventMemberJoin: xivo-hdv.xivo-hdv 127.0.0.1
2021/02/19 08:24:44 [INFO] raft: Node at 127.0.0.1:8300 [Follower] entering Follower state
2021/02/19 08:24:44 [INFO] serf: Attempting re-join to previously known node: xivohdv: 127.0.0.1:8301
2021/02/19 08:24:44 [INFO] consul: adding LAN server xivo-hdv (Addr: 127.0.0.1:8300) (DC: xivo-hdv)
2021/02/19 08:24:44 [INFO] serf: Attempting re-join to previously known node: xivohdv.xivo-hdv: 127.0.0.1:8302
2021/02/19 08:24:44 [INFO] consul: adding WAN server xivo-hdv.xivo-hdv (Addr: 127.0.0.1:8300) (DC: xivo-hdv)
2021/02/19 08:24:44 [INFO] serf: Re-joined to previously known node: xivohdv: 127.0.0.1:8301
2021/02/19 08:24:44 [INFO] serf: Re-joined to previously known node: xivohdv.xivo-hdv: 127.0.0.1:8302
2021/02/19 08:24:44 [ERR] agent: failed to sync remote state: No cluster leader
2021/02/19 08:24:45 [WARN] raft: Heartbeat timeout reached, starting election
2021/02/19 08:24:45 [INFO] raft: Node at 127.0.0.1:8300 [Candidate] entering Candidate state
2021/02/19 08:24:46 [INFO] raft: Election won. Tally: 1
2021/02/19 08:24:46 [INFO] raft: Node at 127.0.0.1:8300 [Leader] entering Leader state
2021/02/19 08:24:46 [INFO] consul: cluster leadership acquired
2021/02/19 08:24:46 [INFO] consul: New leader elected: xivo-hdv
2021/02/19 08:24:46 [INFO] raft: Disabling EnableSingleNode (bootstrap)
2021/02/19 08:24:46 [ERR] raft: Failed to get log at 32781643: log not found
panic: log not found
goroutine 15 [running]:
panic(0x870f0c0, 0x18e1e778)
/goroot/src/runtime/panic.go:464 +0x326
github.com/hashicorp/consul/vendor/github.com/hashicorp/raft.(*Raft).processLogs(0x18f4e240, 0x1f9b79f, 0x0, 0x190b5080)
/gopath/src/github.com/hashicorp/consul/vendor/github.com/hashicorp/raft/raft.go:1157 +0x381
github.com/hashicorp/consul/vendor/github.com/hashicorp/raft.(*Raft).leaderLoop(0x18f4e240)
/gopath/src/github.com/hashicorp/consul/vendor/github.com/hashicorp/raft/raft.go:892 +0x394
github.com/hashicorp/consul/vendor/github.com/hashicorp/raft.(*Raft).runLeader(0x18f4e240)
/gopath/src/github.com/hashicorp/consul/vendor/github.com/hashicorp/raft/raft.go:838 +0x87c
github.com/hashicorp/consul/vendor/github.com/hashicorp/raft.(*Raft).run(0x18f4e240)
/gopath/src/github.com/hashicorp/consul/vendor/github.com/hashicorp/raft/raft.go:602 +0xa8
github.com/hashicorp/consul/vendor/github.com/hashicorp/raft.(*Raft).(github.com/hashicorp/consul/vendor/github.com/hashicorp/raft.run)-fm()
/gopath/src/github.com/hashicorp/consul/vendor/github.com/hashicorp/raft/raft.go:252 +0x20
github.com/hashicorp/consul/vendor/github.com/hashicorp/raft.(*raftState).goFunc.func1(0x18f4e240, 0x19025a38)
/gopath/src/github.com/hashicorp/consul/vendor/github.com/hashicorp/raft/state.go:152 +0x3f
created by github.com/hashicorp/consul/vendor/github.com/hashicorp/raft.(*raftState).goFunc
/gopath/src/github.com/hashicorp/consul/vendor/github.com/hashicorp/raft/state.go:153 +0x46
RE: Souci peer Xivo - Ajouté par yohan VITU il y a presque 4 ans
root@xivo-hdv:~# consul monitor
Error connecting to Consul agent: dial tcp 127.0.0.1:8400: getsockopt: connection refused
RE: Souci peer Xivo - Ajouté par Laurent MEILLER il y a presque 4 ans
Oui malheureusement consul qui se vautre est assez courant lors de snapshot ou arrêt intempestif d'une VM.
Pour retomber sur un XIVO fonctionnel voici la marche à suivre :
xivo-service stop /etc/init.d/xivo-auth stop /etc/init.d/consul stop rm -rf /var/lib/consul/* dpkg-reconfigure consul xivo-service start all
RE: Souci peer Xivo - Ajouté par yohan VITU il y a presque 4 ans
Impec, merci Laurent, tous les services sont maintenant ok ! :-)
xivo-service status all
Checking database...
OK
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
running xivo-dxtora
running xivo-provd
running xivo-agid
running asterisk
running xivo-amid
running xivo-call-logs
running xivo-agentd
running xivo-ctid
running xivo-dird
running xivo-dird-phoned
running xivo-ctid-ng
running xivo-websocketd
Par contre, j'ai toujorus mon souci de peer,
j'ai beau le créer dans l'interface web du Xivo, il se provisionne bien dans le poste, mais n'existe pas dans la Cli asterisk :
xivo-hdv*CLI> sip show peer 7vy7z1vm
Peer 7vy7z1vm not found.
C'est étonnant non ? :-/
RE: Souci peer Xivo - Ajouté par yohan VITU il y a presque 4 ans
Je ne sais pas si ca a un rapport avec mon souci mais j'ai cette erreur en boucle dans le log : xivo-confgend.log
2021-02-19 21:39:40+0100 [Confgen,71,127.0.0.1] Textual SQL expression 'name' should be explicitly declared as text('name')
2021-02-19 21:39:40+0100 [Confgen,71,127.0.0.1] Traceback (most recent call last):
2021-02-19 21:39:40+0100 [Confgen,71,127.0.0.1] File "/usr/lib/python2.7/dist-packages/xivo_confgen/confgen.py", line 61, in _write_response
2021-02-19 21:39:40+0100 [Confgen,71,127.0.0.1] content = getattr(frontend, callback)()
2021-02-19 21:39:40+0100 [Confgen,71,127.0.0.1] File "/usr/lib/python2.7/dist-packages/xivo_confgen/asterisk.py", line 74, in queues_conf
2021-02-19 21:39:40+0100 [Confgen,71,127.0.0.1] return self._generate_conf_from_generator(config_generator)
2021-02-19 21:39:40+0100 [Confgen,71,127.0.0.1] File "/usr/lib/python2.7/dist-packages/xivo_confgen/asterisk.py", line 78, in _generate_conf_from_generator
2021-02-19 21:39:40+0100 [Confgen,71,127.0.0.1] config_generator.generate(output)
2021-02-19 21:39:40+0100 [Confgen,71,127.0.0.1] File "/usr/lib/python2.7/dist-packages/xivo_confgen/generators/queues.py", line 33, in generate
2021-02-19 21:39:40+0100 [Confgen,71,127.0.0.1] for q in asterisk_conf_dao.find_queue_settings():
2021-02-19 21:39:40+0100 [Confgen,71,127.0.0.1] File "/usr/lib/python2.7/dist-packages/xivo_dao/helpers/db_manager.py", line 64, in wrapped
2021-02-19 21:39:40+0100 [Confgen,71,127.0.0.1] return func(session, *args, **kwargs)
2021-02-19 21:39:40+0100 [Confgen,71,127.0.0.1] File "/usr/lib/python2.7/dist-packages/xivo_dao/asterisk_conf_dao.py", line 563, in find_queue_settings
2021-02-19 21:39:40+0100 [Confgen,71,127.0.0.1] rows = session.query(Queue).filter(Queue.commented == 0).order_by('name').all()
2021-02-19 21:39:40+0100 [Confgen,71,127.0.0.1] File "<string>", line 2, in order_by
2021-02-19 21:39:40+0100 [Confgen,71,127.0.0.1] File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/base.py", line 191, in generate
2021-02-19 21:39:40+0100 [Confgen,71,127.0.0.1] fn(self, *args[1:], **kw)
2021-02-19 21:39:40+0100 [Confgen,71,127.0.0.1] File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 1325, in order_by
2021-02-19 21:39:40+0100 [Confgen,71,127.0.0.1] criterion = self._adapt_col_list(criterion, allow_coercion_to_text=False)
2021-02-19 21:39:40+0100 [Confgen,71,127.0.0.1] File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 224, in _adapt_col_list
2021-02-19 21:39:40+0100 [Confgen,71,127.0.0.1] for o in cols
2021-02-19 21:39:40+0100 [Confgen,71,127.0.0.1] File "/usr/lib/python2.7/dist-packages/sqlalchemy/sql/elements.py", line 3453, in _literal_as_text
2021-02-19 21:39:40+0100 [Confgen,71,127.0.0.1] _no_text_coercion(element)
2021-02-19 21:39:40+0100 [Confgen,71,127.0.0.1] File "/usr/lib/python2.7/dist-packages/sqlalchemy/sql/elements.py", line 3468, in _no_text_coercion
2021-02-19 21:39:40+0100 [Confgen,71,127.0.0.1] "extra": "%s " % extra if extra else "",
2021-02-19 21:39:40+0100 [Confgen,71,127.0.0.1] ArgumentError: Textual SQL expression 'name' should be explicitly declared as text('name')
2021-02-19 21:39:40+0100 [Confgen,71,127.0.0.1] cache hit on asterisk/queues.conf
2021-02-19 21:39:40+0100 [Confgen,71,127.0.0.1] serving asterisk/queues.conf in 0.005 seconds
2021-02-19 21:39:40+0100 [Confgen,72,127.0.0.1] Textual SQL expression 'exten' should be explicitly declared as text('exten')
2021-02-19 21:39:40+0100 [Confgen,72,127.0.0.1] Traceback (most recent call last):
2021-02-19 21:39:40+0100 [Confgen,72,127.0.0.1] File "/usr/lib/python2.7/dist-packages/xivo_confgen/confgen.py", line 61, in _write_response
2021-02-19 21:39:40+0100 [Confgen,72,127.0.0.1] content = getattr(frontend, callback)()
2021-02-19 21:39:40+0100 [Confgen,72,127.0.0.1] File "/usr/lib/python2.7/dist-packages/xivo_confgen/asterisk.py", line 60, in sip_conf
2021-02-19 21:39:40+0100 [Confgen,72,127.0.0.1] return self._generate_conf_from_generator(config_generator)
2021-02-19 21:39:40+0100 [Confgen,72,127.0.0.1] File "/usr/lib/python2.7/dist-packages/xivo_confgen/asterisk.py", line 78, in _generate_conf_from_generator
2021-02-19 21:39:40+0100 [Confgen,72,127.0.0.1] config_generator.generate(output)
2021-02-19 21:39:40+0100 [Confgen,72,127.0.0.1] File "/usr/lib/python2.7/dist-packages/xivo_confgen/generators/sip.py", line 37, in generate
2021-02-19 21:39:40+0100 [Confgen,72,127.0.0.1] self._generate(output)
2021-02-19 21:39:40+0100 [Confgen,72,127.0.0.1] File "/usr/lib/python2.7/dist-packages/xivo_confgen/generators/sip.py", line 51, in _generate
2021-02-19 21:39:40+0100 [Confgen,72,127.0.0.1] data_ccss = asterisk_conf_dao.find_extenfeatures_settings(['cctoggle'])
2021-02-19 21:39:40+0100 [Confgen,72,127.0.0.1] File "/usr/lib/python2.7/dist-packages/xivo_dao/helpers/db_manager.py", line 64, in wrapped
2021-02-19 21:39:40+0100 [Confgen,72,127.0.0.1] return func(session, *args, **kwargs)
2021-02-19 21:39:40+0100 [Confgen,72,127.0.0.1] File "/usr/lib/python2.7/dist-packages/xivo_dao/asterisk_conf_dao.py", line 301, in find_extenfeatures_settings
2021-02-19 21:39:40+0100 [Confgen,72,127.0.0.1] .order_by('exten'))
2021-02-19 21:39:40+0100 [Confgen,72,127.0.0.1] File "<string>", line 2, in order_by
2021-02-19 21:39:40+0100 [Confgen,72,127.0.0.1] File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/base.py", line 191, in generate
2021-02-19 21:39:40+0100 [Confgen,72,127.0.0.1] fn(self, *args[1:], **kw)
2021-02-19 21:39:40+0100 [Confgen,72,127.0.0.1] File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 1325, in order_by
2021-02-19 21:39:40+0100 [Confgen,72,127.0.0.1] criterion = self._adapt_col_list(criterion, allow_coercion_to_text=False)
2021-02-19 21:39:40+0100 [Confgen,72,127.0.0.1] File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 224, in _adapt_col_list
2021-02-19 21:39:40+0100 [Confgen,72,127.0.0.1] for o in cols
2021-02-19 21:39:40+0100 [Confgen,72,127.0.0.1] File "/usr/lib/python2.7/dist-packages/sqlalchemy/sql/elements.py", line 3453, in _literal_as_text
2021-02-19 21:39:40+0100 [Confgen,72,127.0.0.1] _no_text_coercion(element)
2021-02-19 21:39:40+0100 [Confgen,72,127.0.0.1] File "/usr/lib/python2.7/dist-packages/sqlalchemy/sql/elements.py", line 3468, in _no_text_coercion
2021-02-19 21:39:40+0100 [Confgen,72,127.0.0.1] "extra": "%s " % extra if extra else "",
2021-02-19 21:39:40+0100 [Confgen,72,127.0.0.1] ArgumentError: Textual SQL expression 'exten' should be explicitly declared as text('exten')
2021-02-19 21:39:40+0100 [Confgen,72,127.0.0.1] cache hit on asterisk/sip.conf
2021-02-19 21:39:40+0100 [Confgen,72,127.0.0.1] serving asterisk/sip.conf in 0.028 seconds
RE: Souci peer Xivo - Ajouté par Laurent MEILLER il y a presque 4 ans
On dirait (au vu de l'erreur) qu'il y'a une FIle d'attente mal configurée qui fait planter la génération des fichiers de conf dont surement celui des peer sip ce qui vous empêche donc de créer de nouveaux utilisateur.
Pouvez regarder dans la webi si il n'y aurait pas une file avec un nom contenant un caractère spécial ou un espace ou un champs vide ? et à ce moment là supprimer cette file et la recréer tout en faisant un tail des logs jusqu’à que l'erreur disparaisse.