Open Source RDBMS - Seamless, Scalable, Stable and Free

English | Login |Register


2
(click on this box to dismiss)

Connecting with csql to a remote host

I have started csql with:

"csql XE" or "csql -S XE" (XE being a database I have),

but I do not know how to connect to it from another computer using csql. 


Can someone tell me the approach I should use ?

링크 댓글 쓰기 (0) 선택된 답변
질문시간 3년 전
dolph
35
21 답변들
0

-S is for standalone, you need to try in client-server mode (-C).

Try a search with "csql host name" on this site and you'll find http://www.cubrid.org/how_to_use_csql_utilities:

To connect to a remote database using the CSQL Interpreter, you need to enter the remote database information in the databases.txt configuration file located in the databases directory under the CUBRID installation directory (the environment variable which stores the location is $CUBRID_DATABASES).

vi $CUBRID_DATABASES/databases.txt
# local db information
demodb /home/cubrid/CUBRID/CUBRID_DATABASES/demodb DBHOST /home/cubrid/CUBRID/CUBRID_DATABASES/demodb
# remote db information
testdb /home/cubrid/CUBRID/CUBRID_DATABASES/testdb 192.168.1.1 /home/cubrid/CUBRID/CUBRID_DATABASES/testdb

링크 댓글 쓰기 (0)
답변시간 3년 전
sqlcopter
284
0

A simpler solution if you don't want to modify databases.txt file is to just mention the remote ip as a parameter to csql like below:


csql -C demodb@192.168.1.3


Source:

http://www.cubrid.org/manual/840/en/Connecting%20to%20Remote%20Host

링크 댓글 쓰기 (0)
답변시간 3년 전
nicola_magdalena
248




You are either using a very old browser or a browser that is not supported.
In order to browse cubrid.org you need to have one of the following browsers:



Internet Explorer: Mozilla Firefox: Google Chrome: