search

jaswdr / docker-image-sybase

SQL Anywhere Database Docker Image
16 stars 14 forks source link

I cant connect to the database #3

Closed MarianoGomezBidondo closed 4 years ago

MarianoGomezBidondo commented 4 years ago

Hi! After start the docker with docker run -d --name sqlAnywhere -p 2638:2638 jaschweder/sybase

I see the docker logs with and they are ok.

~ ❯ docker container logs sqlAnywhere
SQL Anywhere Network Server Version 16.0.0.2043
Developer edition, not licensed for deployment.

Copyright (c) 2014 SAP AG or an SAP affiliate company.
All rights reserved.
Use of this software is governed by the Sybase License Agreement.
Refer to http://www.sybase.com/softwarelicenses.

Connection limit (licensed seats): 3
Processors detected: 1 (containing 2 logical processors)
Maximum number of processors the server will use: 1 physical processor(s), 2 core(s)
This server is licensed to:
    Developer Edition
    Restricted Use
Running Linux 4.9.184-linuxkit #1 SMP Tue Jul 2 22:58:16 UTC 2019 on X86_64
Server built for X86_64 processor architecture
9116K of memory used for caching
Minimum cache size: 9116K, maximum cache size: 1838628K
Using a maximum page size of 4096 bytes
Multiprogramming level: minimum:2, current:20, maximum:80
Automatic tuning of multiprogramming level is enabled
Starting database "demo" (/opt/sqlanywhere16/demo.db) at Tue Dec 10 2019 19:11
Transaction log: demo.log
Starting checkpoint of "demo" (demo.db) at Tue Dec 10 2019 19:11
Finished checkpoint of "demo" (demo.db) at Tue Dec 10 2019 19:11
Database "demo" (demo.db) started at Tue Dec 10 2019 19:11
Database server started at Tue Dec 10 2019 19:11
Trying to start SharedMemory link ...
    SharedMemory link started successfully
Trying to start TCPIP link ...
Starting on port 2638
    TCPIP link started successfully
Now accepting requests

But i cant connect to the database because i'cant determine the ServiceName value in the connection string "jdbc:sqlanywhere:Uid=DBA;pwd=sql;servicename=SQLAnywhereDemo"

Also enter the container with "docker exec -it sqlAnywhere /bin/bash" and try to run command dbisql or dblocate and in all cases it gives me Permission denied

Any help? What is the ServiceName configured? Why i can't execute commands inside the container?

Regards!!!

MarianoGomezBidondo commented 4 years ago

I already conected using "jdbc:sqlanywhere:uid=DBA;pwd=sql;ServiceName=Demo;Host=localhost:2638" as connection string. Regards!