免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
最近访问板块 发新帖
查看: 1949 | 回复: 1
打印 上一主题 下一主题

mysql ssl配置不成功 [复制链接]

论坛徽章:
0
跳转到指定楼层
1 [收藏(0)] [报告]
发表于 2009-06-11 16:34 |只看该作者 |倒序浏览
mysql ssl
近日 为了保证远程mysql 比较安全 所以 我作了openssl+mysql  但始终不成功
我的系统市AS4 UPDATE6 mysql和openssl都是系统自带的rpm包
我的配置如下  mysql ssl服务端
;;建几个目录和文件
  mkdir /usr/local/myssl
  cd /usr/local/myssl
  mkdir private newcerts
  touch index.txt
  echo "01" > serial
  ;;拷贝一份OpenSSL的缺省配置到当前目录
  cp /usr/local/openssl/openssl.cnf .
  ;;修改当前目录下的openssl.cnf,将。/demoCA替换为/usr/local/myssl,replace的具体用法见man
  replace ./demoCA /usr/local/myssl —— /usr/local/myssl/openssl.cnf
  ;;建立根证书
  openssl req -new -x509 -keyout private/cakey.pem -out cacert.pem -config openssl.cnf
  # Sample output:
  # Using configuration from /usr/local/myssl/openssl.cnf
  # Generating a 1024 bit RSA private key
  # ……++++++
  # ……++++++
  # writing new private key to '/usr/local/myssl/private/cakey.pem'
  # Enter PEM pass phrase:
  # Verifying password - Enter PEM pass phrase:
  # ——
  # You are about to be asked to enter information that will be
  # incorporated into your certificate request.
  # What you are about to enter is what is called a Distinguished Name
  # or a DN.
  # There are quite a few fields but you can leave some blank
  # For some fields there will be a default value,
  # If you enter '.', the field will be left blank.
  # ——
  # Country Name (2 letter code) [AU]:CN
  # State or Province Name (full name) [Some-State]:ZJ
  # Locality Name (eg, city) []:JX
  # Organization Name (eg, company) [Internet Widgits Pty Ltd]:Centeur CA
  # Organizational Unit Name (eg, section)[] :HN
  # Common Name (eg, YOUR name)[] :MySQL admin
  # Email Address []:lypdarling@gmail.com
  ;;建立服务端证书
  openssl req -new -keyout server-key.pem -out server-req.pem -days 3600 -config openssl.cnf
  # Sample output:
  # Using configuration from /usr/local/myssl/openssl.cnf
  # Generating a 1024 bit RSA private key
  # ……++++++
  # ……++++++
  # writing new private key to '/usr/local/myssl/server-key.pem'
  # Enter PEM pass phrase:
  # Verifying password - Enter PEM pass phrase:
  # ——
  # You are about to be asked to enter information that will be
  # incorporated into your certificate request.
  # What you are about to enter is what is called a Distinguished Name
  # or a DN.
  # There are quite a few fields but you can leave some blank
  # For some fields there will be a default value,
  # If you enter '.', the field will be left blank.
  # ——
  # Country Name (2 letter code) [AU]:CN
  # State or Province Name (full name) [Some-State]:ZJ
  # Locality Name (eg, city) []:JX
  # Organization Name (eg, company) [Internet Widgits Pty Ltd]:Centeur CA
  # Organizational Unit Name (eg, section) []:HN
  # Common Name (eg, YOUR name) []:MySQL server
  # Email Address []:lypdarling@gmail.com
  #
  # Please enter the following 'extra' attributes
  # to be sent with your certificate request
  # A challenge password []:
  # An optional company name []:
;;移除server-key中的passphrase(可选)
  openssl rsa -in server-key.pem -out server-key.pem
  ;;签署服务端证书
  openssl ca -policy policy_anything -out server-cert.pem -config openssl.cnf -infiles server-req.pem
  # Sample output:
  # Using configuration from /usr/local/myssl/openssl.cnf # Enter PEM pass phrase:
  # Check that the request matches the signature
  # Signature ok
  # The Subjects Distinguished Name is as follows
  # countryName :PRINTABLE:'CN'
  # organizationName :PRINTABLE:'Centeur CA'
  # commonName :PRINTABLE:'MySQL admin'
  # Certificate is to be certified until May 18 16:05:46 2006 GMT
  # (365 days)
  # Sign the certificate? [y/n]:y
  #
  #
  # 1 out of 1 certificate requests certified, commit? [y/n]y
  # Write out database with 1 new entries
  # Data Base Updated
客户端配置
openssl req -new -keyout client-key.pem -out client-req.pem -days 3600 -config openssl.cnf
  # Sample output:
  # Using configuration from /usr/local/myssl/openssl.cnf
  # Generating a 1024 bit RSA private key
  # ……++++++
  # ……++++++
  # writing new private key to '/usr/local/myssl/client-key.pem'
  # Enter PEM pass phrase:
  # Verifying password - Enter PEM pass phrase:
  # ——
  # You are about to be asked to enter information that will be
  # incorporated into your certificate request.
  # What you are about to enter is what is called a Distinguished Name
  # or a DN.
  # There are quite a few fields but you can leave some blank # For some fields there will be a default value,
  # If you enter '.', the field will be left blank.
  # ——# Country Name (2 letter code) [AU]:CN
  # State or Province Name (full name) [Some-State]:ZJ
  # Locality Name (eg, city) []:JX
  # Organization Name (eg, company) [Internet Widgits Pty Ltd]:Centeur CA
  # Organizational Unit Name (eg, section) []:HN
  # Common Name (eg, YOUR name) []:MySQL user
  # Email Address []:lypdarling@gmail.com
  #
  # Please enter the following 'extra' attributes
  # to be sent with your certificate request
  # A challenge password []:
  # An optional company name []:
;;移除client-key中的passphrase(可选)
  openssl rsa -in client-key.pem -out client-key.pem
         修改/etc/my.cnf,添加如下内容:
  [client]
  ssl-ca=/usr/local/myssl/cacert.pem
  ssl-cert=/usr/local/myssl/client-cert.pem
  ssl-key=/usr/local/myssl/client-key.pem
  [mysqld]
  ssl-ca=/usr/local/myssl/cacert.pem
  ssl-cert=/usr/local/myssl/server-cert.pem
  ssl-key=/usr/local/myssl/server-key.pem
  重启mysql服务
  /usr/local/etc/rc.d/mysql-server restart
  ;;签署客户端证书
  openssl ca -policy policy_anything -out client-cert.pem -config openssl.cnf -infiles client-req.pem
  # Sample output:
  # Using configuration from /usr/local/myssl/openssl.cnf
  # Enter PEM pass phrase:
  # Check that the request matches the signature
  # Signature ok
  # The Subjects Distinguished Name is as follows
  # countryName :PRINTABLE:'CN'
  # organizationName :PRINTABLE:'Centeur CA'
  # commonName :PRINTABLE:'MySQL user'
  # Certificate is to be certified until May 18 16:08:20 2006 GMT
  # (365 days)
  # Sign the certificate? [y/n]:y
  #
  #
  # 1 out of 1 certificate requests certified, commit? [y/n]y
  # Write out database with 1 new entries
  # Data Base Updated
然后再把服务器生成的client* 复制到客户端 但现在我启动服务器mysql  老提示Enter PEM pass phrase:
而且客户端连接服务器 时候也是提示Enter PEM pass phrase:
而且输入这个密码了 还提示让输入 我觉得就是密码不对了  但密码明明就是这个 我重搞了几次 还是这样

论坛徽章:
0
2 [报告]
发表于 2009-06-12 09:17 |只看该作者
真是郁闷
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号:11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们:huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP