Menu

#498 show tables command is unable to connect csql server

V2.1 Beta
open
nobody
Network (4)
5
2013-12-21
2009-02-10
No

SCENARIO 1:

I have closed the csql server in my localhost, Then
I run my csql client by connecting to another host through his IP address as
[lakshya@localhost my]$ csql -H 192.168.1.121 -P 5678
And found that "show tables;" command is "Unable to connect to csql server"

CSQL>show tables;
29177:3086526160:DatabaseManagerImpl.cxx:246:Shared memory open failed
29177:3086526160:SessionImpl.cxx:115:Unable to open the system database
Unable to connect to csql server

SCENARIO 2:

I opened the csql server in my localhost, Then
I run my csql client by connecting to another host through his IP address as
[lakshya@localhost my]$ csql -H 192.168.1.121 -P 5678
And found that "show tables;" command returns the tables present in local host
CSQL>show tables;
=============TableNames===================
stud
dept
products
BINTABLE
Store_Information
Geography
stu
dpt
loc
=========================================
The above tables are present in local host.

Discussion


Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.