Re: [OpenSIPS-Users] OpenSIPS-CP errors

2021-01-13 Thread bobsy via Users 
Okay m4 dependency was missing.

> On 14 Jan 2021, at 1:07 pm, bobsy  wrote:
> 
> While I’m at it when I try to create a script using osipsconfig I get this :
> 
> 
>   Config generated : 
> /etc/opensips/opensips_loadbalancer_2021-1-14_13:6:
> 26.cfg = FAILED (). Press any key to continue
> 
> 
>> On 14 Jan 2021, at 12:55 pm, bobsy via Users > > 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: 
>> ", host: "opensips.vale.ski", 
>> referrer: "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.
>> 
>> 
>> ___
>> Users mailing list
>> Users@lists.opensips.org 
>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
> 

___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

Re: [OpenSIPS-Users] OpenSIPS-CP errors

2021-01-13 Thread bobsy via Users 
While I’m at it when I try to create a script using osipsconfig I get this :


  Config generated : /etc/opensips/opensips_loadbalancer_2021-1-14_13:6:
26.cfg = FAILED (). Press any key to continue


> On 14 Jan 2021, at 12:55 pm, bobsy via Users  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: 
> ", host: "opensips.vale.ski", 
> referrer: "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.
> 
> 
> ___
> Users mailing list
> Users@lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users

___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

Re: [OpenSIPS-Users] OpenSIPS-CP errors

2021-01-13 Thread bobsy via Users 
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:]
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  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: 
> ", host: "opensips.vale.ski", 
> referrer: "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.
> 
> 

___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

[OpenSIPS-Users] OpenSIPS-CP errors

2021-01-13 Thread bobsy via Users 
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:", host: 
"opensips.vale.ski", referrer: "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.


___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users