Menu

Can't make SQSH 2.1.7 with freetds 0.91

Help
2011-09-20
2013-05-23
  • Casey Boardman

    Casey Boardman - 2011-09-20

    On Solaris 10.  Freetds installed.

    SYBASE=/usr/local/freetds; export SYBASE
    ./configure --with-readline
    

    That looks right so far, based on other posts.

    in src/Makefile: 

    SYBASE_LIBS   =    -lct    -ltds -lnsl -ldl -lm
    

    That looks good, too.

    make
    

    yields (after building a bunch of stuff):

    gcc    -L/usr/local/freetds/lib -L/usr/local/lib cmd_alias.o cmd_bcp.o cmd_buf.o cmd_connect.o cmd_do.o cmd_echo.o cmd_exit.o cmd_for.o cmd_func.o cmd_go.o cmd_help.o cmd_history.o cmd_if.o cmd_input.o cmd_jobs.o cmd_kill.o cmd_lock.o cmd_loop.o cmd_misc.o cmd_read.o cmd_reconnect.o cmd_redraw.o cmd_reset.o cmd_return.o cmd_rpc.o cmd_set.o cmd_shell.o cmd_show.o cmd_sleep.o cmd_wait.o cmd_warranty.o cmd_while.o var_ctlib.o var_date.o var_debug.o var_dsp.o var_hist.o var_misc.o var_passwd.o var_readline.o var_thresh.o dsp.o dsp_bcp.o dsp_csv.o dsp_conv.o dsp_desc.o dsp_horiz.o dsp_html.o dsp_meta.o dsp_none.o dsp_out.o dsp_pretty.o dsp_vert.o dsp_x.o sqsh_alias.o sqsh_args.o sqsh_avl.o sqsh_buf.o sqsh_cmd.o sqsh_compat.o sqsh_ctx.o sqsh_debug.o sqsh_env.o sqsh_error.o sqsh_expand.o sqsh_fd.o sqsh_filter.o sqsh_fork.o sqsh_func.o sqsh_getopt.o sqsh_global.o sqsh_history.o sqsh_init.o sqsh_job.o sqsh_readline.o sqsh_sig.o sqsh_sigcld.o sqsh_stdin.o sqsh_strchr.o sqsh_tok.o sqsh_varbuf.o sqsh_main.o -lct    -ltds -lnsl -ldl -lm   -lreadline -lcurses  -o sqsh
    ld: warning: global symbol `_END_' has non-global binding:
            (file /usr/local/freetds/lib/libct.so value=LOCL);
    ld: warning: global symbol `_START_' has non-global binding:
            (file /usr/local/freetds/lib/libct.so value=LOCL);
    ld: fatal: file /usr/local/freetds/lib/libtds.a: unknown file type
    ld: fatal: File processing errors. No output written to sqsh
    collect2: ld returned 1 exit status
    make: ***  Error 1
    make: Leaving directory `/opt/BFMIfiles/src/sqsh-2.1.7/src'
    make: ***  Error 2

    Related to this: http://www.freetds.org/faq.html#where.is.libtds.so

    I am thrashing at this point.  Anybody have any bright ideas?

     
  • Casey Boardman

    Casey Boardman - 2011-09-21

    Removing -ltds from SYBASE_LIBS  (as suggested by the freetds mailing list) yeilds:

    gcc    -L/usr/local/freetds/lib -L/usr/local/lib cmd_alias.o cmd_bcp.o cmd_buf.o cmd_connect.o cmd_do.o cmd_echo.o cmd_exit.o cmd_for.o cmd_func.o cmd_go.o cmd_help.o cmd_history.o cmd_if.o cmd_input.o cmd_jobs.o cmd_kill.o cmd_lock.o cmd_loop.o cmd_misc.o cmd_read.o cmd_reconnect.o cmd_redraw.o cmd_reset.o cmd_return.o cmd_rpc.o cmd_set.o cmd_shell.o cmd_show.o cmd_sleep.o cmd_wait.o cmd_warranty.o cmd_while.o var_ctlib.o var_date.o var_debug.o var_dsp.o var_hist.o var_misc.o var_passwd.o var_readline.o var_thresh.o dsp.o dsp_bcp.o dsp_csv.o dsp_conv.o dsp_desc.o dsp_horiz.o dsp_html.o dsp_meta.o dsp_none.o dsp_out.o dsp_pretty.o dsp_vert.o dsp_x.o sqsh_alias.o sqsh_args.o sqsh_avl.o sqsh_buf.o sqsh_cmd.o sqsh_compat.o sqsh_ctx.o sqsh_debug.o sqsh_env.o sqsh_error.o sqsh_expand.o sqsh_fd.o sqsh_filter.o sqsh_fork.o sqsh_func.o sqsh_getopt.o sqsh_global.o sqsh_history.o sqsh_init.o sqsh_job.o sqsh_readline.o sqsh_sig.o sqsh_sigcld.o sqsh_stdin.o sqsh_strchr.o sqsh_tok.o sqsh_
    varbuf.o sqsh_main.o -lct    -lnsl -ldl -lm   -lreadline -lcurses  -o sqsh
    ld: warning: global symbol `_END_' has non-global binding:
            (file /usr/local/freetds/lib/libct.so value=LOCL);
    ld: warning: global symbol `_START_' has non-global binding:
            (file /usr/local/freetds/lib/libct.so value=LOCL);
    Undefined                       first referenced
    symbol                             in file
    libiconv_close                      /usr/local/freetds/lib/libct.so
    libiconv_open                       /usr/local/freetds/lib/libct.so
    libiconv                            /usr/local/freetds/lib/libct.so
    ld: fatal: Symbol referencing errors. No output written to sqsh
    collect2: ld returned 1 exit status
    make: ***  Error 1
    make: Leaving directory `/opt/BFMIfiles/src/sqsh-2.1.7/src'
    make: ***  Error 2

    That thread is happening here:  http://lists.ibiblio.org/pipermail/freetds/2011q3/027382.html

     
  • Casey Boardman

    Casey Boardman - 2011-09-22

    When editing src/Makefile, get rid of -ltds (as suggested here) and change -ldl to -liconv. 

    I got that last bit from the cygwin version of the sqsh README.  I used SYBASE=/usr/local/freetds/.

    After that I had to set the LD_LIBRARY_PATH=$SYBASE/lib/:/usr/local/lib/ to get the freetds and liconv libraries.

    Big thanks to the freetds mailing list.  http://lists.ibiblio.org/pipermail/freetds/2011q3/027382.html

     

Log in to post a comment.

MongoDB Logo MongoDB