FreePBX14 Stats

[Mystic8b]

Greetings! I apologize at once for my English ... And so: Should this work on freepbx14? I created a table as an example. My logger.conf contains:

queue_log_to_file  = yes
queue_adaptive_realtime = yes

My extconfig.conf contains:

queue_log => odbc,general,queue_log

The server is restarted after making changes, but the table is empty:

MariaDB [asterisk]> SELECT * FROM queue_log;
Empty set (0.00 sec)

I also get this when I open the report page:

  File "/usr/lib64/python2.7/site-packages/psycopg2/__init__.py", line 164, in connect
    conn = _connect(dsn, connection_factory=connection_factory, async=async)
sqlalchemy.exc.OperationalError: (OperationalError) could not connect to server: Connection refused
	Is the server running on host "localhost" (::1) and accepting
	TCP/IP connections on port 3306?
received invalid response to SSL negotiation: R
 None None

This is the end of the log, I can throw it off if necessary.

I'm in despair, please help

[roramirez]

You have a problem with connection to database. The credendials are using are ok?.

Maybe your system required use the 127.0.0.1 instead of localhost in configurtion file. The 3306 port is open?, please check it with netstat -putan

[Mystic8b]

ty, It was probably localhost, but now I get:

  File "/usr/lib64/python2.7/site-packages/psycopg2/__init__.py", line 164, in connect
    conn = _connect(dsn, connection_factory=connection_factory, async=async)
OperationalError: (OperationalError) received invalid response to SSL negotiation: R
 None None

But I'm not sure that this is the main problem, because the table in the database is empty for some unknown reason ...

Under the specified credendials, I successfully pass authorization in cli for mysql

[roramirez]

If the table is empty is because the Asterisk no writing the logs there.

If you need QPanel parse records, you need run parser_queuelog.py. This file is using to add the queue_log file and add the record into this table.

Anyway, if you have a Asterisk configuration, I think is a credentials issues from Asterisk