ip address is not listed

[Former Member]

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?

[VolkerBarth]

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).

[ian_mchardy]

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.

[Former Member]

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

[VolkerBarth]

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.

[Former Member]

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 ?

[VolkerBarth]

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.