Sponsor: VoiceMeUp - Corporate & Wholesale VoIP Services

VoIP Mailing List Archives
Mailing list archives for the VoIP community
 SearchSearch 

[Freeswitch-users] ODBC through JS


 
Post new topic   Reply to topic    VoIP Mailing List Archives Forum Index -> freeSWITCH Users
View previous topic :: View next topic  
Author Message
yudha2008 at gmail.com
Guest





PostPosted: Mon Oct 20, 2008 10:53 am    Post subject: [Freeswitch-users] ODBC through JS Reply with quote

Hi,

I have done all the changes but i cant able to run jsrun odbc.js

freeswitch@hp30094686650.optimus.co.in (freeswitch@hp30094686650.optimus.co.in)> 2008-10-20 19:34:29 [ERR] switch_odbc.c:160 switch_odbc_handle_connect() STATE: 01000 CODE 0 ERROR: [unixODBC][Driver Manager]Can't open lib '/usr/local/lib/libmyodbc3.so' : /usr/local/lib/libmyodbc3.so: file too short

2008-10-20 19:34:29 [ERR] mod_spidermonkey_odbc.c:235 odbc_exec() Database is not connected!
2008-10-20 19:34:29 [ERR] odbc.js:9 mod_spidermonkey() TypeError: session.hangup is not a function

Some one correct me where i am wrong

odbc ini:
[ODBC Data Sources]

myodbc = MySQL ODBC 2.50 Driver DSN
myodbc3 = MySQL ODBC 3.51 Driver DSN


[myodbc]
Driver = /usr/local/lib/libmyodbc.so
Description = MySQL ODBC 2.50 Driver DSN
SERVER = localhost
PORT = 3306
USER = optimus
Password = optimus
Database = test
OPTION = 3
SOCKET =


[myodbc3]
Driver = /usr/local/lib/libmyodbc3.so
Description = MySQL ODBC 3.51 Driver DSN
SERVER = localhost
PORT = 3306
USER = optimus
Password = optimus
Database = test
OPTION = 3
SOCKET =


[Default]
Driver = /usr/local/lib/libmyodbc3.so
Description = MySQL ODBC 3.51 Driver DSN
SERVER = localhost
PORT = 3306
USER = optimus
Password = optimus


--
Warm Regards,
N.Baskar
Back to top
xtpl.gayatri at gmail.com
Guest





PostPosted: Tue Oct 21, 2008 12:24 am    Post subject: [Freeswitch-users] ODBC through JS Reply with quote

freeswitch@hp30094686650.optimus.co.in (freeswitch@hp30094686650.optimus.co.in)> 2008-10-20 19:34:29 [ERR] switch_odbc.c:160 switch_odbc_handle_connect() STATE: 01000 CODE 0 ERROR: [unixODBC][Driver Manager]Can't open lib '/usr/local/lib/libmyodbc3.so' : /usr/local/lib/libmyodbc3.so: file too short

check if your .so has read permissions
i recoomend re-installing unixODBC or get some other drivers, i.e. if any provided by MySQL for ODBC

On Mon, Oct 20, 2008 at 8:39 PM, Baskar <yudha2008@gmail.com (yudha2008@gmail.com)> wrote:
Quote:
Hi,

I have done all the changes but i cant able to run jsrun odbc.js

freeswitch@hp30094686650.optimus.co.in (freeswitch@hp30094686650.optimus.co.in)> 2008-10-20 19:34:29 [ERR] switch_odbc.c:160 switch_odbc_handle_connect() STATE: 01000 CODE 0 ERROR: [unixODBC][Driver Manager]Can't open lib '/usr/local/lib/libmyodbc3.so' : /usr/local/lib/libmyodbc3.so: file too short

2008-10-20 19:34:29 [ERR] mod_spidermonkey_odbc.c:235 odbc_exec() Database is not connected!
2008-10-20 19:34:29 [ERR] odbc.js:9 mod_spidermonkey() TypeError: session.hangup is not a function

Some one correct me where i am wrong

odbc ini:
[ODBC Data Sources]


myodbc = MySQL ODBC 2.50 Driver DSN
myodbc3 = MySQL ODBC 3.51 Driver DSN


[myodbc]
Driver = /usr/local/lib/libmyodbc.so
Description = MySQL ODBC 2.50 Driver DSN
SERVER = localhost
PORT = 3306
USER = optimus
Password = optimus
Database = test
OPTION = 3
SOCKET =


[myodbc3]
Driver = /usr/local/lib/libmyodbc3.so

Description = MySQL ODBC 3.51 Driver DSN
SERVER = localhost
PORT = 3306
USER = optimus
Password = optimus
Database = test
OPTION = 3
SOCKET =


[Default]
Driver = /usr/local/lib/libmyodbc3.so
Description = MySQL ODBC 3.51 Driver DSN
SERVER = localhost
PORT = 3306
USER = optimus
Password = optimus


--
Warm Regards,
N.Baskar



_______________________________________________
Freeswitch-users mailing list
Freeswitch-users@lists.freeswitch.org (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




--
Regards,
Gayatri Kulkarni
Back to top
yudha2008 at gmail.com
Guest





PostPosted: Tue Oct 21, 2008 2:22 am    Post subject: [Freeswitch-users] ODBC through JS Reply with quote

Hi,

After setting the permission also i cant able to run the js odbc script

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-21 12:44:34 [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-21 12:44:34 [ERR] mod_spidermonkey_odbc.c:235 odbc_exec() Database is not connected!

Can any one specify which lib-odbc support for mysql i have this driver
Driver = /usr/local/lib/libmyodbc.so
but when i run the js script i get this above error

Some one help to resolve the problem .i have rebuilt the process also but still i face the error. Can some one point out where i am wrong .

--
Warm Regards,
N.Baskar
Back to top
Display posts from previous:   
Post new topic   Reply to topic    VoIP Mailing List Archives Forum Index -> freeSWITCH Users All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group

VoiceMeUp - Corporate & Wholesale VoIP Services