Sybase Central fix for SQL Anywhere

Classic Servoy
1

Recently, there’s been a few posting about the SQL Anywhere GUI tools (Sybase Central and Interactive SQL) suddenly stopping working. We tracked down this issue to the Apple Security Update 2007-004. This update changes the DYLD_LIBRARY_PATH, which our GUI tools rely on.

We’ve fixed this issue in the latest maintenance release for SQL Anywhere 10, namely 10.0.1. You can obtain this patch here:

http://downloads.sybase.com/swd/base.do

We’re in the process of finalizing the fix for version 9.0.2, and it will be available shortly in the form of an EBF (Express Bug Fix). I will post a message once this is done. In the mean time, Apple has documented a workaround to this problem here:

http://docs.info.apple.com/article.html?artnum=305509

For those looking to get the full install for SQL Anywhere 10.0.1, you can download the Developer Edition here:

http://www.ianywhere.com/forms/downloads/sql_anywhere/sqlany_10_developer_download.html

Thank you.

Jose Ramos
Product Manager
Sybase iAnywhere

2

Hi Jose, has this been addressed in 9.0? I discovered that the Apple Security Update 2007-004 also affected command line programs such as calling dbbackup from Servoy methods. See

3

Hi Jose,

Maybe I am not following Apple’s suggestions exactly but I can’t get their instructions for the ‘workaround’ to work either on my G5 or my MacIntel machine. Have you (or anybody?) got this to work so that Sybase Central 9.0.2 works on a Mac again? Neither adding their suggestion to the ‘info.plist’ nor issuing the sudo command seems to work for me. I still get those messages about ‘dbput9_r’ and ‘dbmlput9_r’ not being loaded and then when I try to make a connection to a running database it fails. The Apple help doesn’t say exactly where and how to add those variables to the info.plist so maybe I’m doing something wrong there but the sudo command seems pretty straight forward.

Any help greatly appreciated. I’m having to jump through all kinds of hoops when I want to create a new database, etc.

4

Hi Jose, John

I also spent (too) many hours trying to install the version 9.0.2, i. e. updating from 9.0.1 to 9.0.2. Although Jose described how to do it and said it works on his Mac, I never was able to get 9.0.2 running - very bad :-( I tried it on all sorts of Macs, including Intel Mac (MacBook Pro), no luck. That’s all a bit annoying, and adding the fact that there is no support of PPC Macs for version 10 makes things even more grave as it seems that in reality we can’t work with version 10 for a long time (if at all) as we have to find a solution fo that problem. And yes, customers don’t buy all new Intel Macs (server) just to be able to run version 10.

Best regards, Robert

john.allen:
Hi Jose,

Maybe I am not following Apple’s suggestions exactly but I can’t get their instructions for the ‘workaround’ to work either on my G5 or my MacIntel machine. Have you (or anybody?) got this to work so that Sybase Central 9.0.2 works on a Mac again? Neither adding their suggestion to the ‘info.plist’ nor issuing the sudo command seems to work for me. I still get those messages about ‘dbput9_r’ and ‘dbmlput9_r’ not being loaded and then when I try to make a connection to a running database it fails. The Apple help doesn’t say exactly where and how to add those variables to the info.plist so maybe I’m doing something wrong there but the sudo command seems pretty straight forward.

Any help greatly appreciated. I’m having to jump through all kinds of hoops when I want to create a new database, etc.

5

Robert Huber:
I also spent (too) many hours trying to install the version 9.0.2, i. e. updating from 9.0.1 to 9.0.2.

The following is not a solution, but an alternative and only took me 15 minutes (well: 10 minutes to understand that I CANNOT MAKE IT WORK and 5 minutes to do all the rest).

create the new dbs on a windows box or using Parallel/VMWare/Bootcamp
move them to OS X and administer them with Sybase Central/Interactive SQL 10

Just my 2 eurocents… :-)

6

Yes I do something similar in that I have the SQLAnywhere database running on my G5 with Servoy. Then I go to my neighbouring PC, start up Sybase Central and then log in remotely to the database running on the G5. It’s a real kluge job though because so far I have found that I have to shut down the servoy_repository i have running on the PC or Sybase Central always logs into that database even though I have chosen the one on my G5 (via the IP address). Somehow having the same name means it defaults to the local one.

7

john.allen:
Yes I do something similar in that I have the SQLAnywhere database running on my G5 with Servoy. Then I go to my neighbouring PC, start up Sybase Central and then log in remotely to the database running on the G5. It’s a real kluge job though because so far I have found that I have to shut down the servoy_repository i have running on the PC or Sybase Central always logs into that database even though I have chosen the one on my G5 (via the IP address). Somehow having the same name means it defaults to the local one.

This bug has been there from at least 3 years and I find disturbing, too.

Sybase People: can this be fixed, please? :-)

8

Riccardino:
This bug has been there from at least 3 years and I find disturbing, too.

Sybase People: can this be fixed, please? :-)

Thanks for reporting this. I’ll verify the problem and enter it into our bug tracking system.

Regarding the problem with SA 9.0.2 and the Apple security update, we’re finalizing the EBF that fixes this issue. I was hoping this would be done by now, but unfortunately we’ve hit some glitches that need to be addressed. We’re targetting to get this EBF out before the end of the month.

Thanks,
Jose

9

jramos:
Regarding the problem with SA 9.0.2 and the Apple security update, we’re finalizing the EBF that fixes this issue. I was hoping this would be done by now, but unfortunately we’ve hit some glitches that need to be addressed. We’re targetting to get this EBF out before the end of the month.

We finished our work on this EBF and posted it to the web. You can download it from here:

http://downloads.sybase.com/swd/base.do

Click on the SQL Anywhere link, then look for EBF build #3508 for the Mac OS X platform. Its posted date is June 26, 2007.

Thank you.

Jose

10

Hello Jose

This sounds good, but as we never managed to upgrade from 9.0.1 to 9.0.2, despite your help and advises (which we applied), we can’t use this latest upgrade, can we?

Best regards, Robert

PS: I would very much like to hear if someone was able to upgrade Sybase Central and Interactive SQL to 9.0.2 (from 9.0.1) on (Intel) Macs!?

jramos:

jramos:
Regarding the problem with SA 9.0.2 and the Apple security update, we’re finalizing the EBF that fixes this issue. I was hoping this would be done by now, but unfortunately we’ve hit some glitches that need to be addressed. We’re targetting to get this EBF out before the end of the month.

We finished our work on this EBF and posted it to the web. You can download it from here:

http://downloads.sybase.com/swd/base.do

Click on the SQL Anywhere link, then look for EBF build #3508 for the Mac OS X platform. Its posted date is June 26, 2007.

Thank you.

Jose

11

Robert Huber:
This sounds good, but as we never managed to upgrade from 9.0.1 to 9.0.2, despite your help and advises (which we applied), we can’t use this latest upgrade, can we?

Hi Robert,

This upgrade will only work on an existing 9.0.2 installation, so you would need to upgrade your 9.0.1 version to 9.0.2 before applying the EBF.

Thanks,
Jose

12

Hi Jose

If I only could! I did do the procedure you mentioned in a previous forum post but it just plain didn’t work.
Did you really ever upgrade from 9.0.1 to 9.0.2 on a Intel Mac and on a PowerPC Mac? And it worked? This upgrade just doesn’t seem to work (for me).

Best regards, Robert

jramos:

Robert Huber:
This sounds good, but as we never managed to upgrade from 9.0.1 to 9.0.2, despite your help and advises (which we applied), we can’t use this latest upgrade, can we?

Hi Robert,

This upgrade will only work on an existing 9.0.2 installation, so you would need to upgrade your 9.0.1 version to 9.0.2 before applying the EBF.

Thanks,
Jose

13

Hi Jose,

In doing the install I’m asked for my ‘Registration Key’. I copied and pasted the one I got on my last go round attempting to get Sybase Central to work back in April. But after trying this I’m told that it is an invalid key. In looking at the ‘About this installer’ menu item it says it is ‘Installer version 9.0.1’. Presumably it is just the installer that is that version and doesn’t need to be 9.0.2. But why is my registration key being rejected?

14

Oh, on a further note, I just noticed that at least Sybase Central is working on my G5 (without this new patch which I can’t install). Got no usual error messages and hooked up fine to a running SQLAnywhere database. Maybe with the various reboots I’ve done since trying the ‘temporary’ fix suggested by Sybase/Apple or perhaps since installing the recent new OS release (OS X.10), it now works. Haven’t tried to get it working on my MacIntel machine yet.

15

john.allen:
In doing the install I’m asked for my ‘Registration Key’. I copied and pasted the one I got on my last go round attempting to get Sybase Central to work back in April. But after trying this I’m told that it is an invalid key. In looking at the ‘About this installer’ menu item it says it is ‘Installer version 9.0.1’. Presumably it is just the installer that is that version and doesn’t need to be 9.0.2. But why is my registration key being rejected?

Hi John,

When installing the 9.0.2 EBF under the Mac Intel, you must run the command-line installer. The GUI installer does not work (it never did) under Mac Intel.

After you extract the tarball, you will find the binary “setup”. Simply run this and you’ll see the text-based installer.

You should not be asked for a registration number. The installer will look for the location of your ASA files (default /Applications/SQLAnywhere9). I just tried this on my Mac Intel and everything worked as expected.

Please let me know if you run into any other issues.

Thanks,
Jose

16

Is this patch though for the non-MacIntel machines too? Like my G5? Or is my G5 Sybase Central now working because of the the latest Apple upgrade on Tiger (10.4.10)? I did do those suggested workarounds mentioned earlier in this post but they didn’t work on my G5 at the time. Somehow though Sybase Central IS NOW working. But why? Should I disable those workarounds now because 10.4.10 fixed the problem?

Thanks,

John

17

Hi Jose,

Update. I just now installed the fix on my MacIntel machine following your instructions and the installation went fine without any errors. However I still get the same errors about the missing libraries, it still can’t ‘find’ any running servers and crashes as before when trying to connect to a running server. This is running 9.0.2. Any ideas? thoughts?

John

18

john.allen:
Hi Jose,

Update. I just now installed the fix on my MacIntel machine following your instructions and the installation went fine without any errors. However I still get the same errors about the missing libraries, it still can’t ‘find’ any running servers and crashes as before when trying to connect to a running server. This is running 9.0.2. Any ideas? thoughts?

John

Hi John,

A couple of things to keep in mind when using SQL Anywhere 9.0.2 under the Mac Intel:

  1. The “Find” button in Sybase Central will not work because it makes a call to the SQL Anywhere PPC dynamic libraries, which will fail - although this should not be happening on the Mac PPC, so please let me know if that is the case. Use the “dblocate” command-line utility to find the list of running servers.

  2. As you know, Sybase Central will need to connect to the db server via jConnect. The default is to use the iAnywhere JDBC driver, so you need to change this on the Advanced tab of the Connect dialog. Remember to use the server name “localhost:2638” (or which ever machine/port you are using). Type the db name in the appropriate field and then you should be good to go.

Let me know if you’re still running into problems.

Thanks,
Jose

19

OK still a few problems…

  1. The message about the missing libraries still comes up of course when starting Sybase Central. Is that OK?

  2. The ‘dblocate’ file is located in /Applications/SQLAnywhere9/System/bin32/. cd’d there via Terminal. Then tried to run it and got this:

[onc-qpr:SQLAnywhere9/System/bin32] john% ./dblocate
dyld: Library not loaded: libdbtool9_r.dylib
  Referenced from: /Applications/SQLAnywhere9/System/bin32/dblocate
  Reason: image not found
Trace/BPT trap
[onc-qpr:SQLAnywhere9/System/bin32] john%

However I’m not sure I need to use this as I was able to connect at least partially (see below)
3) Tried connecting from Sybase Central as follows:

  • Clicked on the connect button and selected ‘Adaptive Server Anywhere 9’
  • On the ‘Identification’ tab entered the User ID and the Password
  • Then on the ‘Database’ tab entered ‘localhost:2638’ for ‘Server name’
  • Went to the ‘Advanced’ tab, chose jConnect5 and entered ‘name=servoy_repository’

This works fine up to a point. It connects to the servoy_repository server and opens the servoy_repository database and, as usual, shows the other databases running under that server with a red x in their icon. Normally you just click on the ‘arrow’ to the left of those icons, the connect screen comes up again, you click OK and that database opens up to allow you to add columns, tables etc. However with this I have been unable to open up the other databases which are of course the ones I want to work on. If I click the little arrow, the open connection dialog comes up as expected but after hitting OK I’m told ‘already connected’ to that database. I am of course ‘connected’ but I can’t ‘open’ the database to access the tables and columns! I also tried under the ‘Advanced’ tab to add all the names of the databases I want to access as it suggests, i.e.
name=servoy_repository
name=kidney
and so on.
Nothing works to access/open up the actual databases I want to work on. What am I doing wrong?

Thanks for your help.

20

Hi John,

Let’s see if we can get your SA9 installation to behave properly :-)

john.allen:

  1. The message about the missing libraries still comes up of course when starting Sybase Central. Is that OK?

This message is OK. It only happens when running SQL Anywhere 9 on the Mac Intel, but you may ignore this message.

john.allen:
2) The ‘dblocate’ file is located in /Applications/SQLAnywhere9/System/bin32/. cd’d there via Terminal. Then tried to run it and got this:

[onc-qpr:SQLAnywhere9/System/bin32] john% ./dblocate

dyld: Library not loaded: libdbtool9_r.dylib
Referenced from: /Applications/SQLAnywhere9/System/bin32/dblocate
Reason: image not found
Trace/BPT trap
[onc-qpr:SQLAnywhere9/System/bin32] john%



However I'm not sure I need to use this as I was able to connect at least partially (see below)

This happens when you do not source the SQL Anywhere script (the utility is unable to find the lib path). When you open the command prompt, source the file /Applications/SQLAnywhere9/System/bin32/asa_config.sh. After this, you can run dblocate. BTW, you can also run Sybase Central right from there. The binary name is “scjview”.

john.allen:
3) Tried connecting from Sybase Central as follows:

  • Clicked on the connect button and selected ‘Adaptive Server Anywhere 9’
  • On the ‘Identification’ tab entered the User ID and the Password
  • Then on the ‘Database’ tab entered ‘localhost:2638’ for ‘Server name’
  • Went to the ‘Advanced’ tab, chose jConnect5 and entered ‘name=servoy_repository’

This works fine up to a point. It connects to the servoy_repository server and opens the servoy_repository database and, as usual, shows the other databases running under that server with a red x in their icon. Normally you just click on the ‘arrow’ to the left of those icons, the connect screen comes up again, you click OK and that database opens up to allow you to add columns, tables etc. However with this I have been unable to open up the other databases which are of course the ones I want to work on. If I click the little arrow, the open connection dialog comes up as expected but after hitting OK I’m told ‘already connected’ to that database. I am of course ‘connected’ but I can’t ‘open’ the database to access the tables and columns! I also tried under the ‘Advanced’ tab to add all the names of the databases I want to access as it suggests, i.e.
name=servoy_repository
name=kidney
and so on.
Nothing works to access/open up the actual databases I want to work on. What am I doing wrong?

Thanks for your help.

The problem here is that you are typing “name=servoy_repository” in the options box. Please leave the box empty, and follow the same procedure you described above. By default, Sybase Central will connect to servoy_repository. You will also see the other dbs, but this time the connection should be successful.

Hopefully this gets you up and running smoothly now!

Thanks,
Jose