|
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? |
|
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. I downloaded the developer edition. Does that mean I cannot connect from another machine ?
(21 Jun '17, 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 '17, 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 '17, 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 '17, 03:42)
Volker Barth
|
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).