Hello!
I configured FusionPBX according to this thread - https://www.pbxforums.com/threads/experimenting-with-a-full-load-sharing-cluster.867/
I'm calling to the extension 306, domain - fortest
Now I have an issue with the calls. In the fs_cli I see the error:
[ERR] switch_core_sqldb.c:1369 SQL ERR: [SELECT hostname FROM registrations WHERE reg_user = '306' AND realm = 'fortest' AND to_timestamp(expires) > NOW()] no such function: NOW
This ERROR comes from the script:
/usr/share/freeswitch/scripts/app/xml_handler/resources/scripts/directory/directory.lua
This script generates the query:
SELECT hostname FROM registrations WHERE reg_user = '306' AND realm = 'fortest' AND to_timestamp(expires) > NOW();
I found out, that this script sends this query to the fusionpbx database, when I execute this query at fusionpbx database, I got no results, but I have these records about registrations at the freeswitch database, registrations table. I think this is because of this part of the config - https://www.pbxforums.com/threads/experimenting-with-a-full-load-sharing-cluster.867/post-3687
So, my question is: is it possible (and how) to tell FreeSWICTH to write registrations to the fusionpbx.registrations table instead of freeswitch.registrations.table? And can you please tell me to what table the registration information is written in the vanilla install - to the fusionpbx DB or to the freeswitch DB or to both of them?)
Thanks in advance!
I configured FusionPBX according to this thread - https://www.pbxforums.com/threads/experimenting-with-a-full-load-sharing-cluster.867/
I'm calling to the extension 306, domain - fortest
Now I have an issue with the calls. In the fs_cli I see the error:
[ERR] switch_core_sqldb.c:1369 SQL ERR: [SELECT hostname FROM registrations WHERE reg_user = '306' AND realm = 'fortest' AND to_timestamp(expires) > NOW()] no such function: NOW
This ERROR comes from the script:
/usr/share/freeswitch/scripts/app/xml_handler/resources/scripts/directory/directory.lua
This script generates the query:
SELECT hostname FROM registrations WHERE reg_user = '306' AND realm = 'fortest' AND to_timestamp(expires) > NOW();
I found out, that this script sends this query to the fusionpbx database, when I execute this query at fusionpbx database, I got no results, but I have these records about registrations at the freeswitch database, registrations table. I think this is because of this part of the config - https://www.pbxforums.com/threads/experimenting-with-a-full-load-sharing-cluster.867/post-3687
So, my question is: is it possible (and how) to tell FreeSWICTH to write registrations to the fusionpbx.registrations table instead of freeswitch.registrations.table? And can you please tell me to what table the registration information is written in the vanilla install - to the fusionpbx DB or to the freeswitch DB or to both of them?)
Thanks in advance!
