yiwenshao / practical-cryptdb Goto Github PK

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`

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!

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

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!

I was trying to get everything running. But currently I'm encountering several errors.

1. Execution of ./cdbserver.sh

-> 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