<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&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = 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&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = PostgreSQL Database Driver</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">Driver&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = /usr/local/lib/libodbcpsql.so</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">Trace&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = Yes</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">TraceFile&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = sql.log</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">Database&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = postgres</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">Servername&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = <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&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = &lt;username&gt;</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">Password&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = &lt;password&gt;</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">Port&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = 5432</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">Protocol&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = 6.4</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">ReadOnly&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = No</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">RowVersioning&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = No</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">ShowSystemTables&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = No</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">ShowOidColumn&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = No</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">FakeOidIndex&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = No</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">ConnSettings&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =</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&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = /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&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = 1</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">TraceFile&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = /var/log/odbctrace.out</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">Driver&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = /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">&lt;<a href="mailto:xtpl.gayatri@gmail.com">xtpl.gayatri@gmail.com</a>&gt;</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">&lt;<a href="mailto:jonas.gauffin@gmail.com" target="_blank">jonas.gauffin@gmail.com</a>&gt;</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 &quot;<span style="font-family: courier new,monospace;">postgres&quot; and not &quot;PostgreSQL&quot;</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">&lt;<a href="mailto:xtpl.gayatri@gmail.com" target="_blank">xtpl.gayatri@gmail.com</a>&gt;</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&gt;
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&#39;t figure out whats going on</span><br style="font-family: tahoma,sans-serif;">



<span style="font-family: tahoma,sans-serif;">Here&#39;s my script:<br><br></span>use(&quot;ODBC&quot;);<br><br>var DSN=&quot;PostgreSQL&quot;;<br>var DB_USER=&quot;&lt;username&gt;&quot;;<br>var DB_PASS=&quot;&lt;password&gt;&quot;;<br>



<br>var db = new ODBC(DSN, DB_USER, DB_PASS);<br>//console_log(&quot;notice&quot;,DB.path+&quot;\n&quot;);<br>if(db.connect()){<br>&nbsp; console_log(&quot;notice&quot;,&quot;Connected to DB&quot;);<br>}<br>else{<br>&nbsp; console_log(&quot;notice&quot;,&quot;Still probs&quot;);<br>



}<br><br><u><span style="font-family: tahoma,sans-serif;">Here&#39;s the output:</span></u><br>freeswitch@fedora&gt; 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">&lt;<a href="mailto:xtpl.gayatri@gmail.com" target="_blank">xtpl.gayatri@gmail.com</a>&gt;</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&gt; 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 = &lt;username&gt;</span><br style="font-family: courier new,monospace;">




<span style="font-family: courier new,monospace;">Password = &lt;password&gt;</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&nbsp;&nbsp;&nbsp;&nbsp; = PostgreSQL driver</span><br style="font-family: courier new,monospace;">




<span style="font-family: courier new,monospace;">Driver&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = /usr/local/lib/libodbpsql.so</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">Setup&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = /usr/local/lib/libodbpsqlS.so</span><br style="font-family: courier new,monospace;">




<span style="font-family: courier new,monospace;">UsageCount&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = 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">&lt;<a href="mailto:brian@freeswitch.org" target="_blank">brian@freeswitch.org</a>&gt;</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&#39;t load it in modules.conf.xml you load it in&nbsp;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>&nbsp;</span><span>Invalid ELF Header</span><span>&nbsp;</span>!!<br>




<br>--<span>&nbsp;</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>