Projet

Général

Profil

Souci peer Xivo

Ajouté par yohan VITU il y a environ 3 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 environ 3 ans

Bonjour,

Que donne un xivo-service status all ?

RE: Souci peer Xivo - Ajouté par yohan VITU il y a environ 3 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 environ 3 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 environ 3 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 environ 3 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 environ 3 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 environ 3 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 environ 3 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 environ 3 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 environ 3 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.

    (1-10/10)