VoIP Mailing List Archives

[xtpl.gayatri at gmail.com]

latest version of odbc.ini:

[ODBC Data Sources]PostgreSQL = PostgreSQL Database Driver [PostgreSQL]Description = PostgreSQL Database Driver Driver = /usr/local/lib/libodbcpsql.soTrace = Yes TraceFile = sql.logDatabase = postgres Servername = 58.68.117.43UserName = <username> Password = <password>Port = 5432 Protocol = 6.4ReadOnly = No RowVersioning = NoShowSystemTables = No ShowOidColumn = NoFakeOidIndex = No ConnSettings =[Default] Driver = /usr/local/lib/libodbcpsql.so[ODBC] Trace = 1TraceFile = /var/log/odbctrace.out Driver = /usr/local/lib/libodbcpsql.so
On Fri, Oct 10, 2008 at 5:28 PM, Gayatri Kulkarni <xtpl.gayatri@gmail.com (xtpl.gayatri@gmail.com)> wrote:

[xtpl.gayatri at gmail.com]

either value for DSN name gives the same result

On Fri, Oct 10, 2008 at 4:27 PM, Jonas Gauffin <jonas.gauffin@gmail.com (jonas.gauffin@gmail.com)> wrote:

[xtpl.gayatri at gmail.com]

Like we have to add odbc-dsn as a parm name in the voicemail.xml for voice mail,
do we ave to do add it somewhere for running it in javascript too?

like i said before, i can successfully connect with same username, password, DSN through isql utility
why does fs not find the DSN name?


--
Regards,
Gayatri Kulkarni

[yudha2008 at gmail.com]

Hi,

I have read the above mail list but i cant able to clear this ODBC error.

while installing the unixodbc i deed not get any error but when i load the mod_spidermonkey_obdc i get these errors

freeswitch@hp30094686650.optimus.co.in (freeswitch@hp30094686650.optimus.co.in)> load mod_spidermonkey_odbc
2008-10-17 14:18:00 [CRIT] switch_loadable_module.c:767 switch_loadable_module_load_file() Error Loading module /usr/local/freeswitch/mod/mod_spidermonkey_odbc.so
**Cannot locate symbol 'switch_module_load' please make sure this is a valid module.**
API CALL [¶]ad(mod_spidermonkey_odbc)] output:
-ERR [Ä[]Ã

when i run the jsrun odbc.js i get this errors

freeswitch@hp30094686650.optimus.co.in (freeswitch@hp30094686650.optimus.co.in)> jsrun odbc.js
API CALL [jsrun(odbc.js)] output:
OK

freeswitch@hp30094686650.optimus.co.in (freeswitch@hp30094686650.optimus.co.in)> 2008-10-17 14:18:03 [ERR] switch_odbc.c:160 switch_odbc_handle_connect() STATE: IM002 CODE 0 ERROR: [unixODBC][Driver Manager]Data source name not found, and no default driver specified

2008-10-17 14:18:03 [ERR] mod_spidermonkey_odbc.c:235 odbc_exec() Database is not connected!
2008-10-17 14:18:03 [ERR] mod_spidermonkey_odbc.c:314 odbc_next_row() Database is not connected!

How can i clear this error help me to solve this problem....

--
Warm Regards,
N.Baskar

[brian at freeswitch.org]

mod_spidermonkey_odbc is loaded thru spidermonkey.conf.xml and not modules.conf.xml as its a sub module of mod_spidermonkey.

/b

On Oct 17, 2008, at 1:47 AM, Baskar wrote:

[yudha2008 at gmail.com]

Hi,

I did that too but still same error

please correct me where i am wrong


On Fri, Oct 17, 2008 at 2:20 PM, Brian West <brian@freeswitch.org (brian@freeswitch.org)> wrote:

[brian at freeswitch.org]

at the cli its "smload mod_spidermonkey_odbc"

/b

On Oct 17, 2008, at 2:30 AM, Baskar wrote:

[mike at jerris.com]

this error means you still have it in modules.conf.xml. Remove it.
On Oct 17, 2008, at 5:30 AM, Baskar wrote:

[yudha2008 at gmail.com]

Hi,

When i load the mod_spidermonkey command i get all mod_spidermonkey loaded successfully

freeswitch@hp30094686650.optimus.co.in (freeswitch@hp30094686650.optimus.co.in)> load mod_spidermonkey
2008-10-20 12:29:46 [CONSOLE] mod_spidermonkey.c:944 sm_load_file() Successfully Loaded [/usr/local/freeswitch/mod/mod_spidermonkey_teletone.so]
2008-10-20 12:29:46 [CONSOLE] mod_spidermonkey.c:944 sm_load_file() Successfully Loaded [/usr/local/freeswitch/mod/mod_spidermonkey_core_db.so]
2008-10-20 12:29:46 [CONSOLE] mod_spidermonkey.c:944 sm_load_file() Successfully Loaded [/usr/local/freeswitch/mod/mod_spidermonkey_socket.so]
2008-10-20 12:29:46 [CONSOLE] mod_spidermonkey.c:944 sm_load_file() Successfully Loaded [/usr/local/freeswitch/mod/mod_spidermonkey_odbc.so]
2008-10-20 12:29:46 [CONSOLE] switch_loadable_module.c:789 switch_loadable_module_load_file() Successfully Loaded [mod_spidermonkey]
2008-10-20 12:29:46 [NOTICE] switch_loadable_module.c:238 switch_loadable_module_process() Adding Application 'javascript'
2008-10-20 12:29:46 [NOTICE] switch_loadable_module.c:258 switch_loadable_module_process() Adding API Function 'jsrun'
2008-10-20 12:29:46 [NOTICE] switch_loadable_module.c:258 switch_loadable_module_process() Adding API Function 'jsapi'
API CALL [load(mod_spidermonkey)] output:
+OK

when i try to run a sample odbc code from freeswitch console like
freeswitch@hp30094686650.optimus.co.in (freeswitch@hp30094686650.optimus.co.in)> jsrun odbc.js
freeswitch@hp30094686650.optimus.co.in (freeswitch@hp30094686650.optimus.co.in)> API CALL [jsrun(odbc.js)] output:
OK

2008-10-20 12:29:50 [ERR] switch_odbc.c:160 switch_odbc_handle_connect() STATE: IM002 CODE 0 ERROR: [unixODBC][Driver Manager]Data source name not found, and no default driver specified

2008-10-20 12:29:50 [ERR] mod_spidermonkey_odbc.c:235 odbc_exec() Database is not connected!
2008-10-20 12:29:50 [ERR] mod_spidermonkey_odbc.c:235 odbc_exec() Database is not connected!
2008-10-20 12:29:50 [ERR] mod_spidermonkey_odbc.c:235 odbc_exec() Database is not connected!
2008-10-20 12:29:50 [ERR] mod_spidermonkey_odbc.c:235 odbc_exec() Database is not connected!
2008-10-20 12:29:50 [ERR] mod_spidermonkey_odbc.c:235 odbc_exec() Database is not connected!
2008-10-20 12:29:50 [ERR] mod_spidermonkey_odbc.c:235 odbc_exec() Database is not connected!
2008-10-20 12:29:50 [NOTICE] odbc.js:1 console_log() ==============================
2008-10-20 12:29:50 [ERR] mod_spidermonkey_odbc.c:235 odbc_exec() Database is not connected!
2008-10-20 12:29:50 [ERR] mod_spidermonkey_odbc.c:266 odbc_num_rows() Database is not connected!
2008-10-20 12:29:50 [ERR] mod_spidermonkey_odbc.c:314 odbc_next_row() Database is not connected!
2008-10-20 12:29:50 [NOTICE] odbc.js:1 console_log() ==============================

code is:
use("ODBC");

var people = {};
people["authur"] = 30;
people["ford"] = 42;
people["trillian"] = 29;
people["zaphod"] = 304;
people["marvin"] = 1000001;


db = new ODBC("freeswitch", "optimus", "optimus");
db.connect();

db.exec("create table demo (name varchar(255), age varchar(80));");

for (var i in people) {
sql = "insert into demo values('" + i + "', " + people[i] + ");";
console_log("debug", sql + "\n");
db.exec(sql);
}

sql = "select * from demo;";
var line = "==============================\n";

console_log("notice", line);

db.exec(sql);

console_log("debug", "row count: " + db.numRows() + "\n");

while(db.nextRow()) {
var row = db.getData();

for (var i in row) {
console_log("debug", "[" + i + "] = [" + row[i] + "]\n");
}

console_log("debug", "\n");
}

console_log("notice", line);

what should i specify in DSN.here i gave freeswitch which is a database
name.please assist me to solve this problem


--
Warm Regards,
N.Baskar

[xtpl.gayatri at gmail.com]

can you connect to the database from outside freeswitch? Using the isql command?
Try that first

Plus:
run odbcinst -j on my system, it shows me 3 files:
/usr/local/etc/odbc.ini /usr/local/etc/odbcinst.ini/root/.odbc.ini

When all these files are identical, i can successfully esatcblish the connection through my JS script

Please go through: http://www.unixodbc.org/odbcinst.html
--
Regards,
Gayatri Kulkarni

On Mon, Oct 20, 2008 at 12:28 PM, Baskar <yudha2008@gmail.com (yudha2008@gmail.com)> wrote:

[yudha2008 at gmail.com]

Hi,

Using isql i get these error
[root@hp30094686650 ~]# isql ODBC
[ISQL]ERROR: Could not SQLConnect


when i run odbcinst -j on my system, it shows me also 3 files

[root@hp30094686650 ~]# odbcinst -j
unixODBC 2.2.12
DRIVERS............: /usr/local/etc/odbcinst.ini
SYSTEM DATA SOURCES: /usr/local/etc/odbc.ini
USER DATA SOURCES..: /root/.odbc.ini



/usr/local/etc/.odbc.ini
[ODBC]
Description = mysql
Trace = Off
TraceFile = stderr
Driver = mysql
SERVER = 172.20.176.32
USER = optimus
PASSWORD = optimus
PORT = 3306
DATABASE = freeswitch


/usr/local/etc/odbcinst.ini

[mysql]
Description = MYSQL driver
Driver = /usr/local/lib/libmyodbc3.so
Setup = /usr/local/lib/libodbcmyS.so

CPTimeout =
CPReuse =
FileUsage = 1

I what to connect to mysql please correct me where i am worng
--
Warm Regards,
N.Baskar

[freeswitch-users at li...]

On 10/20/2008 5:25 AM, Baskar wrote:

[xtpl.gayatri at gmail.com]

First:
Syntax for isql: isql <DSN> <username> <password>

Next:
Make sure your /usr/local/etc/odbcinst.ini matches /root/.odbc.ini

Create a database in the DSN which you can test on

Sample odbc ini:[ODBC Data Sources]MySQL = MySQL Database Driver [MySQL]Description = MySQL Database Driver Driver = /usr/local/lib/<name-of-your-lib-odbc.so>Trace = Yes TraceFile = sql.logDatabase = <database name> Servername = <IP of server on which DB is installed>UserName = <username> Password = <password>Port = <port no for mysql> Protocol = 6.4ReadOnly = No RowVersioning = NoShowSystemTables = No ShowOidColumn = NoFakeOidIndex = No ConnSettings =[Default] Driver = /usr/local/lib/<name-of-your-lib-odbc.so>[ODBC] Trace = 1TraceFile = /var/log/odbctrace.out Driver = /usr/local/lib/<name-of-your-lib-odbc.so>
Follow steps given on: http://www.unixodbc.org/odbcinst.html ---