yiwenshao / practical-cryptdb Goto Github PK
View Code? Open in Web Editor NEWLicense: Other
License: Other
hi yiwen
I create a jdbc connection and make a simple query, but it returns following, any idea?
cdbclient.sh works perfect...
I used mysql-connector-java-5.1.45-bin.jar and openjdk version "1.8.0_171"
thank you .
------------- ExecJDBC Start Date = Sat May 19 21:31:51 EDT 2018-------------
(main/dml_handler.cc, 1320)
select auto_increment_increment AS auto_increment_increment
,character_set_client AS character_set_client
,character_set_connection AS character_set_connection
,character_set_results AS character_set_results
,character_set_server AS character_set_server
,collation_server AS collation_server
,init_connect AS init_connect
,interactive_timeout AS interactive_timeout
,license AS license
,lower_case_table_names AS lower_case_table_names
,max_allowed_packet AS `max_allowed_pa
Exception in thread "main" java.lang.NullPointerException
at ExecJDBC.main(ExecJDBC.java:52)
code ...
`Connection conn = null;
Statement stmt = null;
String rLine = "select * from emp";
StringBuffer sql = new StringBuffer();
java.util.Date now = null;
now = new java.util.Date();
System.out.println("------------- ExecJDBC Start Date = " + now + "-------------");
try {
// Register jdbcDriver
Class.forName("com.mysql.jdbc.Driver");
// make connection
conn = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3399/sonoo?verifyServerCertificate=false&useSSL=false", "root","letmein");
conn.setAutoCommit(true);
// Create Statement
stmt = conn.createStatement();
// loop thru input file and concatenate SQL statement fragments
if (rLine.endsWith(";")) {
sql.append(rLine);
execJDBC(stmt, sql);
sql = new StringBuffer();
} else {
sql.append("\n");
}
} catch (SQLException se) {
System.out.println(se.getMessage());
} catch (Exception e) {
e.printStackTrace();
// exit Cleanly
} finally {
try {
conn.close();
} catch (SQLException se) {
se.printStackTrace();
} // end finally
} // end try`
I created a Dockerfile for your project to be runnable as a Docker container: https://github.com/agribu/Practical-Cryptdb_Docker
It was successfully tested, thus, I can run the cdbserver and cdbclient and operate on CryptDB within the Docker container.
However, I can only use the cdbclient.sh file you created, based on /mysql-src/build/client/mysql.
Now, I want to start cdbserver within the Docker container and be able to connect from a local shell from outside the contrainer via a normal mysql client, which I installed via apt install on a Ubuntu 16.04 system running the docker environment.
$ mysql -uroot -pletmein -h 127.0.0.1 -P3399
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 2013 (HY000): Lost connection to MySQL server at 'reading initial communication packet', system error: 0
I was trying to get everything running. But currently I'm encountering several errors.
-> trying to connect via: mysql -u root -pletmein -h 127.0.0.1 -P 3399
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 2013 (HY000): Lost connection to MySQL server at 'reading initial communication packet', system error: 0
-> trying to execute ./cdbclient.sh
ERROR 1105 (HY000): #07000MySQL Proxy Lua script failed to execute. Check the error log.
--> on server side, the following message is displayed:
./cdbserver.sh
mkdir: cannot create directory `shadow': File exists
2017-10-30 11:20:02: (critical) plugin proxy 0.8.5 started
2017-10-30 11:20:51: (critical) (lua-error) [/opt/cryptdb/wrapper.lua]
[string "/opt/cryptdb/wrapper.lua"]:6: /opt/cryptdb/obj/libexecute.so: cannot open shared object file: No such file or directory
Hi Yiwen Shao, thank you very much at first because I'm just beginning to learn CryptDB, I can get a lot from her.
But when I run ./cdbclient.sh, I get the error:
"ERROR 1105 (HY000): #07000MySQL Proxy Lua script failed to execute. Check the error log."
I want to know what I can do,
Thank you very much!
Hello,
I am studying on the Cryptdb and I want to add/link the static library .a (the static library is a second project which I want to call it for functions) in the Cryptdb and after I want to call some functions from static library .a .
Could you help me please how to add the static library?
Thanks!
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google ❤️ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.