<div dir="ltr">latest version of odbc.ini:<br><br><span style="font-family: courier new,monospace;">[ODBC Data Sources]</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">PostgreSQL = PostgreSQL Database Driver</span><br style="font-family: courier new,monospace;">
<br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">[PostgreSQL]</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">Description = PostgreSQL Database Driver</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">Driver = /usr/local/lib/libodbcpsql.so</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">Trace = Yes</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">TraceFile = sql.log</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">Database = postgres</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">Servername = <a href="http://58.68.117.43">58.68.117.43</a></span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">UserName = <username></span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">Password = <password></span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">Port = 5432</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">Protocol = 6.4</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">ReadOnly = No</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">RowVersioning = No</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">ShowSystemTables = No</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">ShowOidColumn = No</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">FakeOidIndex = No</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">ConnSettings =</span><br style="font-family: courier new,monospace;"><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">[Default]</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">Driver = /usr/local/lib/libodbcpsql.so</span><br style="font-family: courier new,monospace;"><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">[ODBC]</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">Trace = 1</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">TraceFile = /var/log/odbctrace.out</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">Driver = /usr/local/lib/libodbcpsql.so</span><br style="font-family: courier new,monospace;"><br style="font-family: courier new,monospace;"><br><div class="gmail_quote">
On Fri, Oct 10, 2008 at 5:28 PM, Gayatri Kulkarni <span dir="ltr"><<a href="mailto:xtpl.gayatri@gmail.com">xtpl.gayatri@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div dir="ltr">either value for DSN name gives the same result :(<div><div></div><div class="Wj3C7c"><br><br><div class="gmail_quote">On Fri, Oct 10, 2008 at 4:27 PM, Jonas Gauffin <span dir="ltr"><<a href="mailto:jonas.gauffin@gmail.com" target="_blank">jonas.gauffin@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div dir="ltr">your DSN name is "<span style="font-family: courier new,monospace;">postgres" and not "PostgreSQL"</span><div>
<div></div><div><br><br><div class="gmail_quote">On Fri, Oct 10, 2008 at 12:34 PM, Gayatri Kulkarni <span dir="ltr"><<a href="mailto:xtpl.gayatri@gmail.com" target="_blank">xtpl.gayatri@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div dir="ltr">Guys please help me on this<br>I am still getting that error<br><br><span style="font-family: courier new,monospace;"><b>freeswitch@fedora>
2008-10-07 17:27:24 [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</b><br><br><span style="font-family: tahoma,sans-serif;">I can connect to the database successfully using isql -v command</span><br style="font-family: tahoma,sans-serif;"><span style="font-family: tahoma,sans-serif;">I can't figure out whats going on</span><br style="font-family: tahoma,sans-serif;">
<span style="font-family: tahoma,sans-serif;">Here's my script:<br><br></span>use("ODBC");<br><br>var DSN="PostgreSQL";<br>var DB_USER="<username>";<br>var DB_PASS="<password>";<br>
<br>var db = new ODBC(DSN, DB_USER, DB_PASS);<br>//console_log("notice",DB.path+"\n");<br>if(db.connect()){<br> console_log("notice","Connected to DB");<br>}<br>else{<br> console_log("notice","Still probs");<br>
}<br><br><u><span style="font-family: tahoma,sans-serif;">Here's the output:</span></u><br>freeswitch@fedora> 2008-10-10 15:41:32 [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<br>
<br>2008-10-10 15:41:32 [NOTICE] testdb.js:1 console_log() Still probs<br><br><span style="font-family: tahoma,sans-serif;">Please Help me</span><br style="font-family: tahoma,sans-serif;"><br style="font-family: tahoma,sans-serif;">
<span style="font-family: tahoma,sans-serif;">Regards,</span><br style="font-family: tahoma,sans-serif;"><span style="font-family: tahoma,sans-serif;">Gayatri Kulkarni</span><br style="font-family: tahoma,sans-serif;"><br>
</span><div class="gmail_quote">On Tue, Oct 7, 2008 at 5:37 PM, Gayatri Kulkarni <span dir="ltr"><<a href="mailto:xtpl.gayatri@gmail.com" target="_blank">xtpl.gayatri@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div dir="ltr">Guys,<br>I am now having this problem:<br>when i run my script i get this error -<br><br><span style="font-family: courier new,monospace;">freeswitch@fedora> 2008-10-07 17:27:24 [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</span><br style="font-family: courier new,monospace;">
<br>my .<u>./etc/odbc.ini</u> looks like this:<br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">[postgres]</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">Driver = PostgreSQL</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">SERVER = localhost</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">PORT = 5432</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">DATABASE = postgres</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">UserName = <username></span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">Password = <password></span><br style="font-family: courier new,monospace;"><br>and .<u>./etc/odbcinst.ini:</u><br><span style="font-family: courier new,monospace;">[ODBC]</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">Trace = yes</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">TraceFile = /tmp/trace.log</span><br style="font-family: courier new,monospace;">
<br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">[PostgreSQL]</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">Description = PostgreSQL driver</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">Driver = /usr/local/lib/libodbpsql.so</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">Setup = /usr/local/lib/libodbpsqlS.so</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">UsageCount = 1000000</span><br style="font-family: courier new,monospace;"><br>-- <br>Regards,<br><font color="#888888">Gayatri Kulkarni<br><br></font><div class="gmail_quote">
<div><div></div><div>On Tue, Oct 7, 2008 at 11:32 AM, Brian West <span dir="ltr"><<a href="mailto:brian@freeswitch.org" target="_blank">brian@freeswitch.org</a>></span> wrote:<br>
</div></div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div><div></div><div><div>thats because you don't load it in modules.conf.xml you load it in conf/autoload_configs/spidermonkey.conf.xml<div>
<br></div><font color="#888888"><div>/b</div></font><div><div><br><div><div>On Oct 7, 2008, at 12:52 AM, Gayatri Kulkarni wrote:</div><br><blockquote type="cite"><span style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px;">Still the same :(<br>
It builds installs the shard library at {prefix}/freeswitch/lib directory<br>while all the modules .so files are in {prefix}/freeswitch/mod directory<br>If i copy the shared library to the mod directory, i get an error saying<span> </span><span>Invalid ELF Header</span><span> </span>!!<br>
<br>--<span> </span><br>Regards,<br>Gayatri Kulkarni</span></blockquote></div><br></div></div></div><br></div></div><div>_______________________________________________<br>
Freeswitch-users mailing list<br>
<a href="mailto:Freeswitch-users@lists.freeswitch.org" target="_blank">Freeswitch-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
<br></div></blockquote></div><br><br clear="all"><br>
</div>
</blockquote></div><br><br clear="all"><br>-- <br>Regards,<br>Gayatri Kulkarni<br>
</div>
<br>_______________________________________________<br>
Freeswitch-users mailing list<br>
<a href="mailto:Freeswitch-users@lists.freeswitch.org" target="_blank">Freeswitch-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
<br></blockquote></div><br></div></div></div>
<br>_______________________________________________<br>
Freeswitch-users mailing list<br>
<a href="mailto:Freeswitch-users@lists.freeswitch.org" target="_blank">Freeswitch-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
<br></blockquote></div><br><br clear="all"><br>-- <br>Regards,<br>Gayatri Kulkarni<br>
</div></div></div>
</blockquote></div><br><br clear="all"><br>-- <br>Regards,<br>Gayatri Kulkarni<br>
</div>