hibernate mysql ssl_使用Hibernate，Spring和JDBC配置SSL证书

柔情只为你懂 2022-10-27 00:26 172阅读 0赞

我正在尝试从使用用户名和密码登录到我的MySQL数据库服务器的未加密JDBC连接转移到使用SSL和基于证书的身份验证的连接。我在Spring

MVC中使用Hibernate。我的WebAppConfig文件如下所示：

package com.\*\*\*\*.PolicyManager.init;

import java.util.Properties;

import javax.annotation.Resource;

import javax.sql.DataSource;

import org.springframework.context.annotation.Bean;

import org.springframework.context.annotation.ComponentScan;

import org.springframework.context.annotation.Configuration;

import org.springframework.context.annotation.PropertySource;

import org.springframework.core.env.Environment;

import org.springframework.jdbc.datasource.DriverManagerDataSource;

import org.springframework.orm.hibernate4.HibernateTransactionManager;

import org.springframework.orm.hibernate4.LocalSessionFactoryBean;

import org.springframework.transaction.annotation.EnableTransactionManagement;

import org.springframework.web.servlet.config.annotation.EnableWebMvc;

import org.springframework.web.servlet.view.JstlView;

import org.springframework.web.servlet.view.UrlBasedViewResolver;

@Configuration

@ComponentScan("com.sprhib")

@EnableWebMvc

@EnableTransactionManagement

@PropertySource("classpath:application.properties")

public class WebAppConfig \{

private static final String PROPERTY\_NAME\_DATABASE\_DRIVER = "db.driver";

private static final String PROPERTY\_NAME\_DATABASE\_PASSWORD = "db.password";

private static final String PROPERTY\_NAME\_DATABASE\_URL = "db.urlSSL";

private static final String PROPERTY\_NAME\_DATABASE\_USERNAME = "db.username";

private static final String PROPERTY\_NAME\_HIBERNATE\_DIALECT = "hibernate.dialect";

private static final String PROPERTY\_NAME\_HIBERNATE\_SHOW\_SQL = "hibernate.show\_sql";

private static final String PROPERTY\_NAME\_ENTITYMANAGER\_PACKAGES\_TO\_SCAN = "entitymanager.packages.to.scan";

@Resource

private Environment env;

@Bean

public DataSource dataSource() \{

DriverManagerDataSource dataSource = new DriverManagerDataSource();

dataSource.setDriverClassName(env.getRequiredProperty(PROPERTY\_NAME\_DATABASE\_DRIVER));

dataSource.setUrl(env.getRequiredProperty(PROPERTY\_NAME\_DATABASE\_URL));

dataSource.setUsername(env.getRequiredProperty(PROPERTY\_NAME\_DATABASE\_USERNAME));

dataSource.setPassword(env.getRequiredProperty(PROPERTY\_NAME\_DATABASE\_PASSWORD));

return dataSource;

@Bean

public LocalSessionFactoryBean sessionFactory() \{

LocalSessionFactoryBean sessionFactoryBean = new LocalSessionFactoryBean();

sessionFactoryBean.setDataSource(dataSource());

sessionFactoryBean.setPackagesToScan(env.getRequiredProperty(

PROPERTY\_NAME\_ENTITYMANAGER\_PACKAGES\_TO\_SCAN));

sessionFactoryBean.setHibernateProperties(hibProperties());

return sessionFactoryBean;

private Properties hibProperties() \{

Properties properties = new Properties();

properties.put(PROPERTY\_NAME\_HIBERNATE\_DIALECT,

env.getRequiredProperty(PROPERTY\_NAME\_HIBERNATE\_DIALECT));

properties.put(PROPERTY\_NAME\_HIBERNATE\_SHOW\_SQL,

env.getRequiredProperty(PROPERTY\_NAME\_HIBERNATE\_SHOW\_SQL));

return properties;

@Bean

public HibernateTransactionManager transactionManager() \{

HibernateTransactionManager transactionManager =

new HibernateTransactionManager();

transactionManager.setSessionFactory(sessionFactory().getObject());

return transactionManager;

@Bean

public UrlBasedViewResolver setupViewResolver() \{

UrlBasedViewResolver resolver = new UrlBasedViewResolver();

resolver.setPrefix("/WEB-INF/pages/");

resolver.setSuffix(".jsp");

resolver.setViewClass(JstlView.class);

return resolver;

而我的属性配置文件(application.properties)如下：

\#DB properties:

db.driver=com.mysql.jdbc.Driver

db.url=jdbc:mysql://localhost:3306/PolicyManager

db.urlSSL=jdbc:mysql://localhost:3306/PolicyManager?autoReconnect=true&verifyServerCertificate=false&useSSL=true&requireSSL=true

db.username=myuser

db.password=mypass

\#Hibernate Configuration:

hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialect

hibernate.show\_sql=true

entitymanager.packages.to.scan=com.\*\*\*\*.PolicyManager.model

我已经在/ etc / mysql /

certs内部生成了正确的证书，并编辑了my.cnf以指向该证书，但是找不到有关如何配置我的数据库初始化特定方法以使用基于证书的身份验证的在线信息。无需将我的数据库用户名和密码以纯文本格式存储在服务器上。

任何人都可以提出解决方案或为我提供使用此WebAppConfig.java文件(hib属性，DriverManagerDataSource和LocalSessionFactoryBean)进行配置的教程吗？

hibernate mysql ssl_使用Hibernate，Spring和JDBC配置SSL证书

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关【SSL】ssl证书简介、ssl证书生成工具与ssl证书生成步骤

相关【SSL证书】如何申请SSL证书

相关 hibernate mysql ssl_使用Hibernate，Spring和JDBC配置SSL证书

相关 Socket证书SSL配置

相关 Nginx配置SSL证书

相关 Nginx配置SSL证书

相关 Nginx 配置 ssl 证书

相关 nginx配置ssl证书

相关 Tomcat配置SSL证书

相关 nginx配置ssl证书