faisalrwp wrote on Saturday, November 15, 2014:
Hi all
I m a research student and try to integrate cryptdb with openemr.
Cryptdb acts as a proxy and sit between the calls coming from the webserver to the backend database.
I manually created the whole database of openemr in cryptdb.
Now i m at the configuration stage of openemr in ubuntu server. (Both cryptdb and openemr are on the same machine)
My target is …
I have my sql server installed.
It contains a database openemr.
I can access it from two ways … 1) through standard mysql access while it is running at port 3306 2) through cryptdb proxy which is activated at port 3307
I want to setup things in such a way that openemr works by connecting to the database using port 3307 where cryptdb proxy receives the queries from frontend and process them.
I tried to setup openemr and giving it the option (i alread have the database created) and then give the username password ip address and port 3307 in the next page
but
somehow it bypasses the 3307 thing and connect and work and create the tables again in the same database using standard sql access. (the table created by cryptdb have encrypted names and cryptdb translate the queries and track what are the encrypted names for the tables called and translates accordingly)
I repeated the step FOUR times but in vein.
I also tried to create a new databsae (openemrx) on the configuration page by selecting CREATE A NEW DATABASE and giving it the port of cryptdb proxy but yet it creates and configures the openemr using standard MYSQL instead of going through openemr.
I therefore come here to get help from you people to guide me how to accomplish this.
Anticipatory thanks.
Faisal