When I install the openipmp server in Ubuntu, there are error messages show on the shell.
shell#cd openipmp2/src/server
shell#chmod +x install.sh
shell#./install ERROR 1048 (23000) at line 1: Column 'CERT' cannot be null
ERROR 1048 (23000) at line 1: Column 'CERT' cannot be null
ERROR 1048 (23000) at line 1: Column 'CERT' cannot be null
ERROR 1048 (23000) at line 1: Column 'PRIVATE_KEY' cannot be null
I found the error is because of the openipmp2/src/server/OMADRMWS/admin_OMADRM.sh
The mysql command in the .sh file is as below.
mysql -f -u $1 -password=$2 -e "SET @device_ca:=LOAD_FILE('$CURR_DIR/../../Demo/data/OMACACert.der');INSERT INTO DEVICE_CA ( CERT ) VALUES ( @device_ca );" OMADRM
LOAD_FILE return NULL to @device_ca and then it causes INSERT fail.
I move the Demo/data/OMACACert.der to /tmp and modify the path from $CURR_DIR/../../Demo/data to /tmp in the admin_OMADRM.sh.
It does not work.
Anyone has idea about this issue? help me please!
My install environment:
Ubuntu 11.10
j2sdk-1_4_2_10-linux-i586.bin
j2re-1_4_2_10-linux-i586.bin
MySQL 5.1
JBoss 4.0.2
openipmp_v202
Best Regards
DaCheng
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Dear All
When I install the openipmp server in Ubuntu, there are error messages show on the shell.
shell#cd openipmp2/src/server
shell#chmod +x install.sh
shell#./install
ERROR 1048 (23000) at line 1: Column 'CERT' cannot be null
ERROR 1048 (23000) at line 1: Column 'CERT' cannot be null
ERROR 1048 (23000) at line 1: Column 'CERT' cannot be null
ERROR 1048 (23000) at line 1: Column 'PRIVATE_KEY' cannot be null
I found the error is because of the openipmp2/src/server/OMADRMWS/admin_OMADRM.sh
The mysql command in the .sh file is as below.
mysql -f -u $1 -password=$2 -e "SET @device_ca:=LOAD_FILE('$CURR_DIR/../../Demo/data/OMACACert.der');INSERT INTO DEVICE_CA ( CERT ) VALUES ( @device_ca );" OMADRM
LOAD_FILE return NULL to @device_ca and then it causes INSERT fail.
I move the Demo/data/OMACACert.der to /tmp and modify the path from $CURR_DIR/../../Demo/data to /tmp in the admin_OMADRM.sh.
It does not work.
Anyone has idea about this issue? help me please!
My install environment:
Ubuntu 11.10
j2sdk-1_4_2_10-linux-i586.bin
j2re-1_4_2_10-linux-i586.bin
MySQL 5.1
JBoss 4.0.2
openipmp_v202
Best Regards
DaCheng
It is MySQL un-compatible issue.
I use MySQL 4.1.11 to reinstall it and there is no errer message.
DaCheng
Hi DaCheng
I am neither able to find MySQL 4.1.11 source code nor download. Could you please let me know from where did you install MySQL 4.1.11?
Thanks
Supriya