It can be a matter of db mode for usrloc, what it is its value?
I'm currently using `db_mode 2`.
I just tested the command `kamcmd ul.db_users location` with `db_mode 1`, and I encountered a different error in the log:
``` May 16 11:15:55 ip-10-0-1-63 /usr/sbin/kamailio[29873]: ERROR: db_postgres [km_dbase.c:267]: db_postgres_submit_query(): 0x7f4a0d8e8148 PQsendQuery Error: ERROR: function count(character varying, character varying) does not exist#012LINE 1: SELECT COUNT(DISTINCT username, domain) FROM location WHERE ...#012 ^#012HINT: No function matches the given name and argument types. You might need to add explicit type casts.#012 Query: SELECT COUNT(DISTINCT username, domain) FROM location WHERE (UNIX_TIMESTAMP(expires) = 0) OR (expires > NOW()) ```
I believe this is another manifestation of the same issue with PostgreSQL and `usrloc`.
It seems that the problem lies in the SQL query:
``` SELECT COUNT(DISTINCT username, domain) FROM location; ```
After conducting some research, I discovered that PostgreSQL does not support the `count` function with more than one column.
To achieve the same functionality, we could use the following query instead: ``` SELECT COUNT(DISTINCT CONCAT(username, '@', domain)) FROM location; ```