//unlock certificate in stauts consumed that client can get it one more time
        public int unlockCert(string hostname)
        {
            SqlLite sql = new SqlLite();
            string  status;

            try
            {
                sql.updateCertFlag(hostname);    //unlock certificate
                return(0);
            }

            catch (Exception ex)
            {
                status = ex.Message;
                return(-1);
            }
        }