Hi

I am attempting to create a TCP listener for an existing running database using SQL Central. The ip address for the machine is 10.11.12.17:

$ ip addr
1: lo: <LOOPBACK,UP,LOWER_UP> mtu 65536 qdisc noqueue state UNKNOWN group default qlen 1000
    link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00
    inet 127.0.0.1/8 scope host lo
       valid_lft forever preferred_lft forever
    inet6 ::1/128 scope host 
       valid_lft forever preferred_lft forever
2: enp0s3: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc pfifo_fast state UP group default qlen 1000
    link/ether 08:00:27:9a:55:ef brd ff:ff:ff:ff:ff:ff
    inet 10.11.12.17/24 brd 10.11.12.255 scope global enp0s3
       valid_lft forever preferred_lft forever
    inet6 fe80::a00:27ff:fe9a:55ef/64 scope link 
       valid_lft forever preferred_lft forever
$ cat hosts
127.0.0.1   localhost
10.11.12.17     sa

I can successfully ping the machine either as "ping sa" or "ping 10.11.12.17", but the IP address and host do not appear in the drop down when attempting to create a TCP listener using the SQL Central Listener wizard:

"Only the following address: 127.0.0.1 (localhost IPv4)"

Any suggestions of how they could appear?

asked 21 Jun, 11:56

bluefrog's gravatar image

bluefrog
183118
accept rate: 0%

There's no need to "setup a TCP/IP listener" for SQL Anywhere other than using the DBSRV17 executable (the networt server) - it uses TCP/IP by default, and as Ian has answered on your other question, defaults to use port 2638 if available or the first available "ephemeral port" (49152 or above).

(21 Jun, 12:06) Volker Barth

My first guess is you are starting a personal server (dbeng17). For connections from other machines, you need a network server (dbsrv17). I believe you need a different license to use a network server than a personal server.

permanent link

answered 21 Jun, 11:58

Ian%20McHardy's gravatar image

Ian McHardy
3.1k23354
accept rate: 38%

I downloaded the developer edition. Does that mean I cannot connect from another machine ?

(21 Jun, 12:17) bluefrog
Replies hidden
2

You can. AFAIK, the DevEd should contain both the network server (dbsrv17) and the personal server (dbeng17). It's basically the full software package with restricted license.

(21 Jun, 15:00) Volker Barth

Hi Volker

thanks for the tip. On the server I was using dbend17, instead of dbsrv17

SERVER

$ /opt/sqlanywhere17/bin64s/dbsrv17 -ga -x tcpip(port=49153) -n ftnode_sa /home/sa/sqlany17/ftnode_sa.db

I can now connect from another machine with SQL Central. I can also successfully ping the db:

CLIENT

$ dbping -d -c "uid=sadb;pwd=sadb;eng=ftnode_sa;links=tcpip(host=sa;port=49153);LOG=conn.log;dbn=ftnode_sa" SQL Anywhere Server Ping Utility Version 17.0.4.2053 Connected to SQL Anywhere 17.0.4.2053 server "ftnode_sa" and database "ftnode_sa" at address 10.11.12.17. Ping database successful.

One more question. Is there an equivalent of a Oracle sqlplus command line utility that comes with SQL Anywhere ?

(21 Jun, 18:31) bluefrog
Replies hidden
1

FWIW, it's dbeng17 (for "engine"), not dbend17:)

I don't know SQL*Plus but SQL Anywhere comes with Interactive SQL (DBISQL) as a graphical SQL query tool (also available within SQL Central), and there's an older dbisqlc utility with reduced functionality and minimal resource needs. Both do not offer a classic "command line interface" but allow the interactive execution of SQL commands, so DBISQL should certainly work for you.

Both tools allow to run complex SQL scripts, too.

(22 Jun, 03:42) Volker Barth
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:

×132

question asked: 21 Jun, 11:56

question was seen: 163 times

last updated: 22 Jun, 03:44