dbsrv12 demo.db -xs HTTP(port=80) bash:syntax error near unexpected token `('

[Former Member]

I am able to start dbsrv12 with Web by Windows7 without facing problem but Ubuntu 12.10 I have downloaded SQLAny12, Web SQLAny12 and SQLAny16, all not able to start with -xs option

-xs HTTP also not able to start. Could not bind to address (::):80 since no IP address, I specify HOST=IP address also same error unexpected token `('

• I am able to start without using -xs option
• I already execute sa_config.sh and double confirm environment variable is set.
• I have tested double quotation when I specify option but still error.

[graeme_perrow]

When you say you've "tested double quotation", what exactly did you use? Update your question to include the exact command. Feel free to mask passwords or IP addresses (use a.b.c.d) if you wish but we need to see exactly what you entered.

[jeff_albion]

Thomas is correct: round brackets are interpreted by Bash. You need to quote around the bracketed argument:

 dbsrv12 demo.db -xs "http(port=80)"

However, if this still isn't working for you, you can also alternatively use curly brackets without quoting:

 dbsrv12 demo.db -xs http{port=80}

[Former Member]

I'm sorry I didn't use Linux for while due to some testing I am able to execute demo.db without -xs option, environment variable is OK

dbsrv12 demo.db -xs "http(port=80)" dbsrv12 demo.db -xs http{port=80} dbsrv12 demo.db -xs "http{port=80}"

ERROR show Could not bind to address (::):80 Can't start HTTP listener on address (::):80 Database server shutdown due to startup error TCPIP listener on IP address (::):2638 is exiting TCPIP listener on IP address 0.0.0.0:2638 is exiting

[Former Member]

I have tested to specify HOST by -x option but Unknow option "HOST" For Unix, quotation marks are required if more than one parameter is supplied: dbsrv12 demo.db -xs http{port=80} -x "tcpip{HOST=192.168.1.10;PORT=80}" I have tested dbsrv12 demo.db -xs http{port=80} -x "tcpip{MyIP=192.168.1.10;PORT=80}" it show Trying to start TCPIP link ... TCPIP communication link not started Unable to initialize requested communication links

[Former Member]

sorry MyIP=192.168.1.10;PORT=2638

[MarkCulp]

If you are trying to use a port less than 1000 on Unix (including Linux) then you must be running the server as root. Ports < 1000 are restricted on Unix to be only available to root user.

[thomas_duemesnil]

The Shell Bash is interpreting your Command line. Try to use double Quotes around the Parameter.

Kind Regards

[Former Member]

as I mentioned I have tested double quotation when I specify option I refer to manual it show several way, I have tested. I didn't try single quotation

[reimer_pods]

As Graeme suggested, please show us the complete statment you're trying to execute. That would allow answers to be more than guesswork.