[OpenSIPS-Users] OpenSIPS-CP errors

[bobsy]

I also get this in OpenSIPS

 DBG:httpd:answer_to_connection: START *** cls=(nil), connection=0x55d766a1b220, url=/mi, method=POST, versio=HTTP/1.1, upload_data[48]=0x55d766a229cc, *con_cls=0x7f53f1f2d4d0
Jan 14 12:57:26 [27593] DBG:httpd:answer_to_connection: NOT a regular POST :o)
Jan 14 12:57:26 [27593] DBG:httpd:getConnectionHeader: key=[Host] value=[127.0.0.1:8888]
Jan 14 12:57:26 [27593] DBG:httpd:getConnectionHeader: Accept=*/*
Jan 14 12:57:26 [27593] DBG:httpd:getConnectionHeader: Content-Type=application/json
Jan 14 12:57:26 [27593] DBG:httpd:getConnectionHeader: Content-Length=48
Jan 14 12:57:26 [27593] DBG:httpd:answer_to_connection: got ContentType [3] with len [48]: {"jsonrpc":"2.0","id":1,"method":"dr_gw_status"}\nJan 14 12:57:26 [27593] DBG:httpd:answer_to_connection: START *** cls=(nil), connection=0x55d766a1b220, url=/mi, method=POST, versio=HTTP/1.1, upload_data[0]=(nil), *con_cls=0x7f53f1f2d4d0
Jan 14 12:57:26 [27593] DBG:httpd:answer_to_connection: normalised_url=[]
Jan 14 12:57:26 [27593] DBG:mi_http:mi_json_answer_to_connection: START *** cls=(nil), connection=0x55d766a1b220, url=, method=POST, version=HTTP/1.1, upload_data[48]=0x7f53f1f2b299, *con_cls=0x7f53f1f2d468
Jan 14 12:57:26 [27593] DBG:mi_http:mi_http_run_mi_cmd: got command=dr_gw_status
Jan 14 12:57:26 [27593] ERROR:core:handle_mi_request: Command not found

> On 14 Jan 2021, at 12:55 pm, bobsy <masked at vale.ski> wrote:
> 
> Hi,
> 
> I’m using opensips 3.1.1 from deb repo
> And opensips-cp 8.3.1
> With nginx and php7.3-fpm
> Postgresql for db
> 
> And I’ve configured mi_http for json…
> 
> I’m receiving a few errors like this:
> 
> Failed to issue total count query, error message : Array ( [0] => 42P01 [1] => 7 [2] => ERROR: relation "cc_agents" does not exist LINE 2: from cc_agents ^ ) [select count(id) from cc_agents]
> 
> On the call centre page and on the dialog page
> 
> 
> 2021/01/14 12:50:29 [error] 3849#3849: *289 FastCGI sent in stderr: "PHP message: PHP Warning:  Creating default object from empty value in /var/www/opensips-cp/config/tools/system/dialog/local.inc.php on line 27PHP message: PHP Notice:  Array to string conversion in /var/www/opensips-cp/web/tools/system/dialog/dialog.php on line 112" while reading response header from upstream, client: 119.18.18.117, server: opensips.vale.ski, request: "GET /tools/system/dialog/dialog.php HTTP/1.1", upstream: "fastcgi://unix:/run/php/php7.3-fpm.sock: <fastcgi://unix/run/php/php7.3-fpm.sock:>", host: "opensips.vale.ski", referrer: "http://opensips.vale.ski/menu.php <http://opensips.vale.ski/menu.php>”
> 
> I get this error on that page:
> 
> MI command failed with code -32601 (Method not found)
> 
> Any insight would be greatly appreciated.
> 
> 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20210114/5ecbecaf/attachment-0001.html>