Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
282 views
in Technique[技术] by (71.8m points)

sql-server - SRV记录到Oracle / MSSQL(SRV Record to Oracle/MSSQL)

I would like to create a SRV Record to my Oracle and MSSQL DBMS on my Synology NAS.

(我想在Synology NAS上为我的Oracle和MSSQL DBMS创建一个SRV记录。)

Both DBMS running in Docker and the ports are default(1521/1433).

(在Docker中运行的DBMS和端口都是默认值(1521/1433)。)

I already created a rule in my fritzbox, so I can access both DBMS from the "outer world".

(我已经在fritzbox中创建了一条规则,因此可以从“外部世界”访问两个DBMS。)

For this purpose I want to use my 1&1 Domain and I created two subdomains.

(为此,我要使用1&1域,并创建了两个子域。)

One for Oracle and one for MSSQL.

(一种用于Oracle,另一种用于MSSQL。)

This are my settings for the subdomain SRV Records:

(这是我对子域SRV记录的设置:)

----------------------------------------
            | MSSQL       | Oracle
----------------------------------------
Service     | _sql        | _sql
----------------------------------------
Protocol    | TCP         | TCP
----------------------------------------
Target      | dyndns-url  | dyndns-url
----------------------------------------
Priority    | 10          | 10
----------------------------------------
Weight      | 0           | 0
----------------------------------------
Port        | 1433        | 1521
----------------------------------------
TTL         | 1 hour      | 1 hour
----------------------------------------

When I try to access the instances via my dyndns URL (Synology/DDNSS) then the connections are possible.

(当我尝试通过我的Dyndns URL(Synology / DDNSS)访问实例时,则可以建立连接。)

But when I want to use my 1&1 subdomains for this I cannot access my DBMS.

(但是,当我要为此使用1&1子域时,无法访问我的DBMS。)

The same I did with my Minecraft Server.

(与我的Minecraft服务器相同。)

It is also on the NAS.

(它也在NAS上。)

The procedure is the same.

(程序是一样的。)

1&1 SRV record points to my dyndns-url.

(1&1 SRV记录指向我的dyndns-url。)

The connection is possible.

(可以连接。)

Thanks for help.

(感谢帮助。)

BlackRose01

(黑色玫瑰01)

  ask by BlackRose01 translate from so

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Answer

0 votes
by (71.8m points)
等待大神答复

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...