search

MasterVitronic / fusionpbx

Automatically exported from code.google.com/p/fusionpbx
0 stars 0 forks source link

switch_core_sqldb.c:464 Failure! PGSQL NOT AVAILABLE! Can't connect to DSN #484

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?
1. Create an IVR
2. Set an inbound route to transfer to the IVR
3. Place a test call

What is the expected output? What do you see instead?

The call should be answered by the IVR, instead we see the following:

54c4209e-3bee-11e3-b3c2-fde261063643 EXECUTE 
sofia/external/07881245707@85.13.199.22 lua(ivr_menu.lua) 

2013-10-23 15:17:06.527427 [CRIT] switch_core_sqldb.c:464 Failure! PGSQL NOT 
AVAILABLE! Can't connect to DSN hostaddr=127.0.0.1 dbname=fusionpbx 
user=fusionpbx password= options='-c client_min_messages=NOTICE' 
application_name='fusionpbx' 

2013-10-23 15:17:06.527427 [ERR] freeswitch_lua.cpp:354 Connection failed. DBH 
NOT Connected. 

2013-10-23 15:17:06.527427 [ERR] freeswitch_lua.cpp:435 DBH NOT Connected.

2013-10-23 15:17:06.527427 [ERR] mod_lua.cpp:200 
/usr/local/freeswitch/scripts/ivr_menu.lua:98: bad argument #1 to 'len' (string 
expected, got nil) 
stack traceback: 
[C]: in function 'len' 
/usr/local/freeswitch/scripts/ivr_menu.lua:98: in main chunk 

What version of the product are you using? On what operating system?
FusionPBX Revision: 4642
Freeswitch Version: 1.2.13
CentOS release 6.4 (Final)

Please provide any additional information below.

We have two installations both have been setup following these installation 
steps and both exhibit the same problem:
http://wiki.fusionpbx.com/index.php?title=CentOS_6.2_with_PostgreSQL
http://wiki.fusionpbx.com/index.php?title=Multi-Tenant

We have tested connectivity to the PGSQL databases and can confirm that the 
details in the config.lua file match that of what we can use to login using 
Advanced -> Adminer, as follows.

    database["system"] = "pgsql://hostaddr=127.0.0.1 port=5432 dbname=fusionpbx user=fusionpbx password= options='-c client_min_messages=NOTICE' application_name='fusionpbx'";
    database["switch"] = "pgsql://hostaddr=127.0.0.1 port=5432 dbname=freeswitch user=fusionpbx password= options='-c client_min_messages=NOTICE' application_name='freeswitch'";

Hope someone here can help.

Many Thanks,
Shaun

Original issue reported on code.google.com by shaun.st...@itec-support.co.uk on 23 Oct 2013 at 2:52

GoogleCodeExporter commented 9 years ago 
Not really a bug you need to get the postgres driver working with FreeSWITCH.
https://wiki.freeswitch.org/wiki/PostgreSQL_in_the_core

This is harder to do on CentOS. Ask in FreeSWITCH irc or mailing list and 
search the web for support on it.

Original comment by markjcrane@gmail.com on 27 Oct 2013 at 10:30