6 ROOT_CERT_SQL=root-cert.sql
13 echo "`openssl x509 -in $fname -subject -noout -nameopt multiline \
18 function get_common_name()
23 common_name=`get_field $fname commonName`
24 if [[ $common_name == "" ]]; then
25 common_name=`get_field $fname organizationUnitName`
27 if [[ $common_name == "" ]]; then
28 common_name=`get_field $fname organizationName`
30 if [[ $common_name == "" ]]; then
31 common_name=`get_field $fname emailAddress`
34 echo "${common_name:1}" # cut first whitespace
37 function initialize_store_version()
39 sqlite3 $DB_PATH "INSERT INTO schema_info (version, description) \
40 VALUES (2, 'Tizen 3.0');"
43 function initialize_store_data()
45 echo "BEGIN TRANSACTION;" >> $ROOT_CERT_SQL
46 for fname in `find $SYSTEM_SSL_DIR/* | sort`
48 gname=`echo ${fname##*/}`
49 if [[ ! $gname =~ ^[0-9a-z]{8}\.[0-9]$ ]]; then
53 cert=`openssl x509 -in $fname -outform PEM`
54 subject_hash=`openssl x509 -in $fname -subject_hash -noout`
55 subject_hash_old=`openssl x509 -in $fname -subject_hash_old -noout`
56 common_name=`get_common_name $fname`
57 echo "INSERT INTO ssl (gname, certificate, file_hash, subject_hash,\
58 common_name, enabled, is_root_app_enabled) VALUES\
59 ('$gname', '$cert', '$subject_hash', '$subject_hash_old','$common_name', \
60 1, 1);" >> $ROOT_CERT_SQL
62 echo "END TRANSACTION;" >> $ROOT_CERT_SQL
67 initialize_store_version
70 sqlite3 $DB_PATH ".read $ROOT_CERT_SQL" && rm $ROOT_CERT_SQL