[SOLVED] SQL Anywhere developer edition: Howto start without interaction

HasC · 02-12-2010, 11:57 AM

I'm using SQL Anywhere 10.0.1.3415, on Debian 5. For starting the DBMS, I use this commands:

Code:

# source /opt/sqlanywhere10/bin32/sa_config.sh
# dbsrv10 /home/demo.db

And it works fine.

But, everytime I start the database, it keeps popping out this message:

Code:

Copyright (c) 2001-2007, iAnywhere Solutions, Inc. Portions copyright (c) 1988-2007, Sybase, Inc.
All rights reserved. All unpublished rights reserved.

Developer edition, not licensed for deployment.
Please confirm your acceptance of these license terms:
I accept and agree to abide by the terms and conditions of the
"IANYWHERE NO-CHARGE DEVELOPER EDITION LICENSE AGREEMENT".
Enter 'Y' for Yes and 'N' for No:

And I have to press 'Y' to init the database.

What I want is, start the database without having to type that "Y" over and over (Seems I need to purchase a license from Sybase for that...).

Or maybe, make the computer type the "Y" for me... For that, I've tried some shell redirections:

Code:

#  echo "Y" |  dbsrv10 /home/demo.db

Code:

#  echo -e "Y\n" |  dbsrv10 /home/demo.db

Code:

#  yes 'Y' | dbsrv10 /home/demo.db

But none worked. It keeps popping the "Enter Y" message.

So, any more suggestions?

TB0ne · 02-13-2010, 12:35 PM

Quote:

Originally Posted by HasC

I'm using SQL Anywhere 10.0.1.3415, on Debian 5. For starting the DBMS, I use this commands:

Code:

# source /opt/sqlanywhere10/bin32/sa_config.sh
# dbsrv10 /home/demo.db

And it works fine.

But, everytime I start the database, it keeps popping out this message:

Code:

Copyright (c) 2001-2007, iAnywhere Solutions, Inc. Portions copyright (c) 1988-2007, Sybase, Inc.
All rights reserved. All unpublished rights reserved.

Developer edition, not licensed for deployment.
Please confirm your acceptance of these license terms:
I accept and agree to abide by the terms and conditions of the
"IANYWHERE NO-CHARGE DEVELOPER EDITION LICENSE AGREEMENT".
Enter 'Y' for Yes and 'N' for No:

And I have to press 'Y' to init the database.

What I want is, start the database without having to type that "Y" over and over (Seems I need to purchase a license from Sybase for that...).

Or maybe, make the computer type the "Y" for me... For that, I've tried some shell redirections:

Code:

#  echo "Y" |  dbsrv10 /home/demo.db

Code:

#  echo -e "Y\n" |  dbsrv10 /home/demo.db

Code:

#  yes 'Y' | dbsrv10 /home/demo.db

But none worked. It keeps popping the "Enter Y" message.

So, any more suggestions?

Aside from paying for the commercial-software you're using, no.

You could write a small expect script to start this, but you're still deploying commercial software, without paying for it. Linux has many free DB's available for use/deployment, but if you want Sybase (outside of a development environment), you're either going to have to pay, or hit keys.

jschiwal · 02-13-2010, 12:37 PM

Try adding `< <(yes y)' to the end of the command.

HasC · 02-15-2010, 05:28 AM

Quote:

Originally Posted by TB0ne

[...] but you're still deploying commercial software, without paying for it. Linux has many free DB's available for use/deployment, but if you want Sybase (outside of a development environment), you're either going to have to pay, or hit keys.

Actually, I bought a license from Sybase, which I'm using for production servers at work (And we should use Sybase, it's bosses' call).
For development, I thought I can use development version but the 'Y or N' thing it's a hassle, after a few times (around 50, for me...). But I will try expect.

Quote:

Originally Posted by jschiwal

Try adding `< <(yes y)' to the end of the command.

Did this:

Code:

dbsrv10 /home/demo.db < <(yes y)

It didn't work - still asks for me to hit "Y".

HasC · 02-15-2010, 06:05 AM

Have to admit, didn't know about Expect :-$ But, it solved this problem!
Read a little, coded a little more, and voilá! There goes the hassle of typing "I do" myself over and over :-)

Another great tool for my collection, thanks for the help!

djtjlt · 11-09-2011, 06:22 AM

Quote:

Originally Posted by HasC

Have to admit, didn't know about Expect :-$ But, it solved this problem!
Read a little, coded a little more, and voilá! There goes the hassle of typing "I do" myself over and over :-)

Another great tool for my collection, thanks for the help!

Hello HasC. I have the same problem like you had. I found this post after long search for the solution. After I read it I studied expect a bit, and then tried to
make the script.
The script launches the server, I have put the text "Enter 'Y' for Yes and 'N' for No:" to expect, and then on the next line Send "y".
But this is not helping... The script starts, the server comes to the message asking Y or N, and then everything exits out, and server does not start...

Can you please let me know how you solved it ? Paste you expect script ?

Mine is here:
#!/usr/bin/expect -f

spawn /opt/sybase/SYBSsa9/bin64/dbsrv9 @/opt/sybase/SYBSsa9/bin64/startup.txt
expect "Enter 'Y' for Yes and 'N' for No:"
send "y"

Thank you.
Tadas.