ODBC port_program_executable_not_found

[Michael McDaniel]

On Thu, Nov 03, 2005 at 08:36:32AM -0800, Michael McDaniel wrote:
> On Wed, Nov 02, 2005 at 03:07:21PM -0600, Jeff Einhorn wrote:
> > I followed the instructions for setting up ODBC mysql for erlang on trapexit
> > (http://www.trapexit.org/docs/howto/odbc-howto.html ) and I ran into the
> > following error?
> > 
> > =ERROR REPORT==== 2-Nov-2005::14:55:02 ===
> > 
> > Error in process <0.40.0> with exit value: {{badmatch,
> > {error,port_program_executable_not_found}},[{erl_eval,expr,3}]}
> > 
> > Any suggestions on where to start looking for the problem?  I did verify that
> > the odbc driver works with the odbctest program.
> > 
> > Thanks,
> > 
> > Jeff
> ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
> Later releases of Erlang (e.g. R10B-8) should "just work" and
> not need changes to the make or config files.
> 
> Presumably you received no errors in building erlang such as
> *** odbc application not built ***.  
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Apology for any confustion, if you're using the R10B-4 you will
receive

    odbc           : No odbc library found

and the howto describes how to get it working anyway.

As previously mentioned, the later R10B releases do not
have this problem.

~Michael

> 
> 
> I think the "port_program_exectutable" should be located at
> priv/bin/odbcserver under the erlang/lib/odbc-2.x directory
> (though I am not certain that is the program referenced by
> this error message).  Anyway...
> 
> 
> 
> If no errors about odbc during build, then for troubleshooting
> the immediate problem I suggest using strace thusly ...
> 
> $ strace erl > foo.log 2>&1
> application:start(odbc).
> q().
> $ echo "        now look at foo.log to investigate odbc problem"
>         now look at foo.log to investigate odbc problem
> $
> 
> For my R10B-8 install, it looks into 
> /usr/local/lib/erlang/lib/odbc-2.0.4/
> 
> Directory structure of this directory (and ebin and priv/bin)
> looks like
> $
> $ ls -las /usr/local/lib/erlang/lib/odbc-2.0.4/
> total 36
> 4 drwxrwxr-x   8  421 staff 4096 2005-10-25 02:19 .
> 4 drwxrwxr-x  46  421 staff 4096 2005-10-25 02:37 ..
> 4 drwxr-xr-x   2 root root  4096 2005-10-26 13:34 c_src
> 4 drwxrwxr-x   3  421 staff 4096 2005-10-25 02:19 doc
> 4 drwxr-xr-x   2 root root  4096 2005-10-26 13:34 ebin
> 4 drwxr-xr-x   2 root root  4096 2005-10-26 13:34 include
> 4 -rw-r--r--   1  421 staff  111 2005-10-25 02:19 info
> 4 drwxr-xr-x   4 root root  4096 2005-10-26 13:34 priv
> 4 drwxr-xr-x   2 root root  4096 2005-10-26 13:34 src
> $
> $ ls -las /usr/local/lib/erlang/lib/odbc-2.0.4/ebin
> total 52
>  4 drwxr-xr-x  2 root root   4096 2005-10-26 13:34 .
>  4 drwxrwxr-x  8  421 staff  4096 2005-10-25 02:19 ..
>  4 -rw-r--r--  1 root root    271 2005-10-26 13:34 odbc.app
>  4 -rw-r--r--  1 root root   1188 2005-10-26 13:34 odbc_app.beam
>  4 -rw-r--r--  1 root root     17 2005-10-26 13:34 odbc.appup
> 28 -rw-r--r--  1 root root  26348 2005-10-26 13:34 odbc.beam
>  4 -rw-r--r--  1 root root   1460 2005-10-26 13:34 odbc_sup.beam
> $
> $ ls -las /usr/local/lib/erlang/lib/odbc-2.0.4/priv/bin
> total 124
>   4 drwxr-xr-x  2 root root   4096 2005-10-26 13:34 .
>   4 drwxr-xr-x  4 root root   4096 2005-10-26 13:34 ..
> 116 -rwxr-xr-x  1 root root 114494 2005-10-26 13:34 odbcserver
> 
> 
> Also, I put the following two lines in my application to
> guarantee my environment variables
> 
>   os:putenv("ODBCINI", "/etc/unixODBC/odbc.ini") ,
>   os:putenv("ODBCSYSINI", "/etc/unixODBC/odbcinst.ini") ,
> 
> 
> Hope the above helps, please let us know what you find and your
> platform and version numbers.
> 
> ~Michael

-- 
Michael McDaniel
Portland, Oregon, USA
http://autosys.us
+1 503 283 5284