VoIP Mailing List Archives

[mashudiflexi at telkom...]

Hi folks,
i try javascripts example for conference application and get this error,

2008-08-28 20:59:55 [ERR] mod_spidermonkey.c:3303 js_api_use() Error
loading ODBC
2008-08-28 20:59:55 [ERR] conference.js:10 mod_spidermonkey()
ReferenceError: ODBC is not defined

i have follow the instruction as documented on
http://wiki.freeswitch.org/wiki/Mod_spidermonkey_odbc.

please help.

*****************************************
Flexi-Gratis bicara sepanjang waktu se-Jawa Barat,
Banten dan DKI Jakarta.

Speedy-Gratis Internetan unlimited dari Pkl. 20.00
s/d 8.00 se- Jabodetabek, Banten, Karawang dan
Purwakarta
*****************************************

_______________________________________________
Freeswitch-users mailing list
Freeswitch-users@lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org

[jonas.gauffin at gmail...]

First you have to add

use("ODBC");

in your javascript.


On Thu, Aug 28, 2008 at 9:06 AM, mashudi <mashudiflexi@telkom.co.id> wrote:

[mashudiflexi at telkom...]

it is already

use("ODBC");


var DSN = "DB";
var DB_USER = "conce";
var DB_PASS = "password";

var line = "====================================\n";

var db = new ODBC(DSN, DB_USER, DB_PASS);
db.connect();
var sql;
var dtmf = new Object();
var replay = 1;

function mycb (session, type, data, arg) {

if (type == "dtmf") {
arg.digits += data.digit;
if (arg.digits.length >= 1) {
return false;
}
}
}

function get_route(digits)
{

sql = "select count(*) as count from conferences where pin = \""
+ digits +"\";";

var line = "====================================\n";

console_log("notice", "Menu Option Entered: " + digits +" \n sql
statment [" + sql + "]\n");
console_log("notice", line);

db.exec(sql);

while(db.nextRow()) {
var row = db.getData();
if (row["count"] >= 1) {
console_log("notice", "Found Conf Pin=[" +
digits + "]\n");
return digits;
} else {


and the odbc already running :

mashudi:/usr/local/freeswitch/scripts# isql -v DB
+---------------------------------------+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
+---------------------------------------+
SQL>



Jonas Gauffin wrote:

[jonas.gauffin at gmail...]

Have you specified in fs\conf\autoload_configs\spidermonkey.conf.xml
that odbc should be loaded?

On 8/29/08, mashudi <mashudiflexi@telkom.co.id> wrote:

[mashudiflexi at telkom...]

Hi Jonas.gauffin,
here is my configuration related to odbc ,

mashudi:/usr/local/freeswitch/conf/autoload_configs# more
spidermonkey.conf.xml
<configuration name="spidermonkey.conf" description="Spider Monkey
JavaScript Pl
ug-Ins">
<modules>
<load module="mod_spidermonkey_teletone"/>
<load module="mod_spidermonkey_core_db"/>
<load module="mod_spidermonkey_socket"/>
<load module="mod_spidermonkey_odbc"/>
</modules>
</configuration>


jonas.gauffin@gmail.com wrote:

[mike at jerris.com]

On Aug 29, 2008, at 2:58 AM, mashudi wrote:

[mashudiflexi at telkom...]

Michael Jerris wrote: