search

MasterVitronic / fusionpbx

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

Voicemail broken in latest stable #389

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?
1. Dial either *97 or *98

What is the expected output? What do you see instead?
When *97 is dialed, I am immediately hung up on and the log shows this:

2013-03-21 14:23:39.501486 [ERR] mod_lua.cpp:198 
...usr/local/freeswitch/scripts/app/voicemail/index.lua:137: attempt to index 
global 'dbh' (a nil value)
stack traceback:
    ...usr/local/freeswitch/scripts/app/voicemail/index.lua:137: in main chunk
    [C]: in function 'dofile'
    /usr/local/freeswitch/scripts/app.lua:48: in main chunk

When *98 is dialed, I am prompted to input my "id" (which I didn't have to do 
in previous versions) and when I do, freeswitch hangs up and shows this in the 
log:

2013-03-21 14:25:28.521476 [ERR] mod_lua.cpp:198 
...app/voicemail/resources/functions/check_password.lua:54: attempt to index 
global 'dbh' (a nil value)
stack traceback:
    ...app/voicemail/resources/functions/check_password.lua:54: in function 'check_password'
    ...usr/local/freeswitch/scripts/app/voicemail/index.lua:214: in main chunk
    [C]: in function 'dofile'
    /usr/local/freeswitch/scripts/app.lua:48: in main chunk

What version of the product are you using? On what operating system?
3.2 stable svn, LMDE

I am not using odbc, nor do I have any databases set up in the 
Advanced->Databases tab (because I never had to configure anything there in the 
past).  I didn't see anything in the documentation saying that I would need to 
in v3.2, so I gather that this is a bug.

Original issue reported on code.google.com by kin...@gmail.com on 21 Mar 2013 at 7:28

GoogleCodeExporter commented 9 years ago 
Sounds like you are using latest stable fusionpbx with the newest release of 
FreeSWITCH.

Advanced -> Command -> Switch command. Run the following. Report the result.
version 

Advanced -> Command -> Shell Command
svn info

If you are using FreeSWITCh 1.2.7 or Git head they changed the database syntax.

Original comment by markjcrane@gmail.com on 25 Mar 2013 at 6:22

GoogleCodeExporter commented 9 years ago 
with latest freeswitch, the dsn for the database connection has changed if you 
are using sqlite:

dbh = freeswitch.Dbh("core:"..db_path.."/"..db_name);
should be changed to 
dbh = freeswitch.Dbh("sqlite:///"..db_path.."/"..db_name);

in all lua scripts.

Original comment by phuy...@gmail.com on 29 Mar 2013 at 8:54

GoogleCodeExporter commented 9 years ago 
I have same problem with new installation.
Version: FreeSWITCH Version 1.2.8+git~20130426T222330Z~e495702e7d (git e495702 
2013-04-26 22:23:30Z)
svn info
Path: .
URL: http://fusionpbx.googlecode.com/svn/trunk/fusionpbx/app/exec
Repository Root: http://fusionpbx.googlecode.com/svn
Repository UUID: e2954ef0-caed-11de-bd98-e341d93cc3cc
Revision: 3948
Node Kind: directory
Schedule: normal
Last Changed Author: markjcrane@gmail.com
Last Changed Rev: 3695
Last Changed Date: 2013-01-19 19:49:54 -0500 (Sat, 19 Jan 2013)

Original comment by j...@jou.cat on 28 Apr 2013 at 12:30

GoogleCodeExporter commented 9 years ago 
The dev branch has the changes needed to connect to the database and will be 
released in FusionPBX 3.3.

Original comment by markjcrane@gmail.com on 28 Apr 2013 at 3:01

GoogleCodeExporter commented 9 years ago 
This problem is solved in the new release FusionPBX 3.3.

Original comment by markjcrane@gmail.com on 29 Apr 2013 at 1:54

GoogleCodeExporter commented 9 years ago 
Thank you Mark,
How can we upgrade to 3.3?

Original comment by joanjou....@gmail.com on 29 Apr 2013 at 4:15

GoogleCodeExporter commented 9 years ago 
Hello

I have the same problem. I upgraded from version 3.2 to version 3.3 but this 
didn't help. Any ideas? I use mysql, not sqlite.

2013-06-14 18:17:28.796934 [ERR] mod_lua.cpp:198 
...usr/local/freeswitch/scripts/app/voicemail/index.lua:137: attempt to index 
global 'dbh' (a nil value)
stack traceback:
        ...usr/local/freeswitch/scripts/app/voicemail/index.lua:138: in main chunk
        [C]: in function 'dofile'
        /usr/local/freeswitch/scripts/app.lua:48: in main chunk

Original comment by ivanov.e...@gmail.com on 14 Jun 2013 at 5:42

GoogleCodeExporter commented 9 years ago 
Hello All,

I am alos getting this error, i have Easy installation script on CentOS 6.5 
server. I am using mysql.

2014-01-23 01:00:59.072856 [ERR] switch_core_sqldb.c:1131 SQL ERR: [SELECT 
domain_uuid FROM v_domains WHERE domain_name = 'sip.c2avoice.com' ] no such 
table: v_domains
2014-01-23 01:00:59.072856 [ERR] freeswitch_lua.cpp:435 DBH NOT Connected.
2014-01-23 01:00:59.072856 [ERR] mod_lua.cpp:199 
/usr/local/freeswitch/scripts/app/voicemail/index.lua:132: attempt to 
concatenate global 'domain_uuid' (a nil value)
stack traceback:                                                                

        /usr/local/freeswitch/scripts/app/voicemail/index.lua:132: in main chunk                                                                                       
        [C]: in function 'dofile'                                                                                                                                      
        /usr/local/freeswitch/scripts/app.lua:49: in main chunk 

Other information :

Path: .
URL: http://fusionpbx.googlecode.com/svn/trunk/fusionpbx/app/exec
Repository Root: http://fusionpbx.googlecode.com/svn
Repository UUID: e2954ef0-caed-11de-bd98-e341d93cc3cc
Revision: 5127
Node Kind: directory
Schedule: normal
Last Changed Author: markjcrane@gmail.com
Last Changed Rev: 4605
Last Changed Date: 2013-09-29 07:42:55 +1000 (Sun, 29 Sep 2013)

version

FreeSWITCH Version 1.5.8b+git~20140121T113519Z~7adc20fd4a~64bit (git 7adc20f 
2014-01-21 11:35:19Z 64bit)

Thanks

Original comment by jkhan6...@gmail.com on 22 Jan 2014 at 2:06

GoogleCodeExporter commented 9 years ago 
1.5.8 is master branch not stable.

Original comment by nysoluti...@gmail.com on 22 Jan 2014 at 4:45

GoogleCodeExporter commented 9 years ago 
Also note you need to create odbc if you use mysql

Original comment by nysoluti...@gmail.com on 22 Jan 2014 at 4:53

GoogleCodeExporter commented 9 years ago 
[deleted comment]
GoogleCodeExporter commented 9 years ago 
@nysolutions installation of stable fs which is 1.2.17 will solve my issue ? 
and how to create ODBC ? any link or thread for reference for that

Original comment by jkhan6...@gmail.com on 23 Jan 2014 at 9:31

GoogleCodeExporter commented 9 years ago 
install unixODBC to connect ODBC to mySQLd and the config file for the database 
access odbc.ini (and config for ODBC in odbcinst.ini)

[fusionpbx]
Driver   = MySQL
SERVER   = localhost
PORT     = 3306
DATABASE = **
OPTION  = 67108864
Password  = **
Socket   = /var/lib/mysql/mysql.sock

Original comment by rjcroasd...@googlemail.com on 23 Jan 2014 at 9:58