Hello,

Attempts to run interactive sql from a command line on a linux server are failing:

> dbisql

-bash: /opt/sqlanywhere12/bin32/dbisql: file not found

Yet the file dbisql does exist.

'source'ing does not fix the problem.

This is a fresh install (ga1201, ubuntu12). Other command line utilities work normally (dblocate, dbinit, etc).

I'm puzzled. Any suggestions?

(Edit: more information)

> . /opt/sqlanywhere12/bin64/sa_config.sh
iAnywhere Solutions, Inc. One Sybase Drive, Dublin, CA 94568, USA
Copyright (c) 2001-2011, iAnywhere Solutions, Inc. Portions copyright (c) 
1988-2011, Sybase, Inc. All rights reserved. All unpublished rights reserved.

> which dbisql
/opt/sqlanywhere12/bin32/dbisql

> dbisql
-bash: /opt/sqlanywhere12/bin32/dbisql: No such file or directory

> ls -al /opt/sqlanywhere12/bin32/dbisql
-r-xr-xr-x 1 root root 340236 Jun 28 19:20 /opt/sqlanywhere12/bin32/dbisql

asked 28 Jun '12, 05:01

Mark's gravatar image

Mark
2415917
accept rate: 22%

edited 28 Jun '12, 18:21

What is the output of 'which dbisql'?

What are the permissions on /opt/sqlanywhere12/bin32/dbisql? Does this file have execute permissions?

(28 Jun '12, 09:18) Mark Culp

Thanks Mark, answers in the edited question.

This is a hosted VM on a remote server. The error message appears to be generated by bash.

(28 Jun '12, 18:20) Mark

Does

 hash -r

Help?

(29 Jun '12, 09:35) Dan Cummins
Replies hidden
Comment Text Removed

Thanks Dan, but no.

hash -t dbisql shows /opt/sqlanywhere12/bin32/dbisql

hash -r clears that path. Sourcing sa_config.sh resets it.

(02 Jul '12, 01:25) Mark

Documentation says (readme_en.txt in install bundle) and online:

"On 64-bit Linux distributions, you must install the 32-bit compatibility libraries if you want to use the administration tools. In particular, the 32-bit X11 libraries are required. On Ubuntu, run:

sudo apt-get install ia32-libs

This solved the issue.

> dbisql -nogui

(Not Connected)>

dbisql was never missing. dbisql was running but couldn't find some file that was in the 32bit libs.

A more descriptive error message saying which file was missing would be helpful for people like me!

permanent link

answered 02 Jul '12, 01:44

Mark's gravatar image

Mark
2415917
accept rate: 22%

edited 02 Jul '12, 01:49

1

Ironically, I am the one that added that readme item, but I too did not recognize/connect the error message with that problem. I thought about it after my original post, but you had alrady figured it out.

I've added the error message you provided to the readme item, to hopefully help people who run into this in the future. Thanks for providing that!

(04 Jul '12, 10:37) Dan Cummins

Cheers for that Dan.

(05 Jul '12, 20:59) Mark
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×79
×61

question asked: 28 Jun '12, 05:01

question was seen: 2,517 times

last updated: 05 Jul '12, 20:59