Unable to connect to DB

[Former Member]

Hi,

I have installed SQL Anywhere 17 on my Raspberry PI.

I have issued the command dbsrv17 -ud mysqlDB01.db and can see the message that the server is started

Next, I am using SQL Central on my laptop to connect to this DB. I have provided the below values.

Authentication: Database
UserID: murali
password: sql123

Action: connect to running database on another computer
Host: 192.168.8.100
Port: 2638
Server Name : mysqlDB01
Database name: mysqlDB01

My Ping to the Host works. However, when I test the DB connection, it fails. I ran an ifconfig command on RaspberryPI and got two values lo inet address=127.0.0.1 wlan0 inet address=192.168.8.100

Below is the error I get in SQL Central

Fri Jun 10 2016 16:04:19
16:04:19 Attempting to connect using:
UID=murali;PWD=********;DBN=mysqlDB01;ServerName=mysqlDB01;CON=SQL_DBC_61e47f37f0;LOG=C:\\Users\\I305544\\AppData\\Local\\Temp\\testcon9091539794935435267.tmp;ASTART=NO;Host=192.168.8.100:2638
16:04:19 Attempting to connect to a running server...
16:04:19 Attempting TCPIP connection (no sasrv.ini cached address)
16:04:19 Looking for server with name mysqldb01
16:04:19 Trying to find server at address 192.168.8.100:2638
16:04:19 Found server, verifying server name
16:04:19 A HOST value was specified, skipping LDAP check
16:04:19 Failed to connect over TCPIP
16:04:19 Removing failed address from sasrv.ini cache
16:04:19 Not attempting to autostart server
16:04:19 Cannot connect to server

I also noticed that the ping also fails at times. All my devices are on the same Internet connection supplied by my wifi dongle. So they are all on the same network.

Any suggestions.

Thanks, Murali

[VolkerBarth]

I'd suggest to start the server with -z debug logging, too (and adding -o console.log to write the messages to a file).

[Vlad]

Can you just try to ping the DB using dbping? There are two cases that you can test - just a simple pinging. E.g.

dbping -c "Host=dbServerHost"

Usually it can find my server either remotely, or locally.

Then you can use the key -d:

dbping -d -c "Host=dbServerHost;UID=ping;PWD=ping;"
SQL Anywhere Server Ping Utility Version 17.0.4.2053
Connected to SQL Anywhere 17.0.4.2053 server "cluster" and database "Vlad'sDB"
at address xx.xx.xx.xx.
Ping database successful.

[Former Member]

Thanks Vlad

[Vlad]

Have you solved the issue?

[Former Member]

yes, This has been resolved. But I got stuck with another problem described below.

[Vlad]

I know this comment is old, but have you noticed how you had resolved the connection problem? Or it simply disappeared... magically.

[Former Member · Accepted solution]

Thanks Volker. I was able to see the console log and the port was correct. May be it was a time out issue earlier, but now it works with the same settings.

[RADical_Systems]

Sorry, I couldn't work out hoe to reply rather than answer - this may or may not be an answer.

I don't know much about Pi's but in a Windows environment one of the first things I'd be looking at is the firewall. Is there a firewall on the Pi that needs to allow access on port 2638?

[Former Member]

Thanks for your response. I too had the same doubt. Hence, I am working behind the firewall just connecting to internet using my personal wifi dongle.