mysql5.7如何关闭ssl?

使用官方yum源安装,由于mysql5.7默认开启了ssl,安装在centos系统中,远程可以通过windows的navicat连接,但是通过另一台centos系统的mysql -u root -p -h ip地址连接时,则提示:ERROR 2003 (HY000): Can't connect to MySQL server on 'IP地址' (113)(113)。所以想请教,5.7这个版本如何将ssl关闭。

1个回答

Csdn user default icon
上传中...
上传图片
插入图片
抄袭、复制答案,以达到刷声望分或其他目的的行为,在CSDN问答是严格禁止的,一经发现立刻封号。是时候展现真正的技术了!
其他相关推荐
mysql5.7版本中如何禁止掉SSL功能,默认是开启的
哪位大神知道怎么关闭mysql的SSL功能,现在在5.7版本里面默认是开启的
在Win10系统下怎样才能正确配置MySQL5.7.20的SSL连接?
各位大佬,小弟现在遇到的问题是: 在win10系统中,为了数据库的安全,我需要配置MySQL的SSL连接,但是一直配置不成功, 所以想请教各位大佬,我该怎么样才能配置成功,谢谢!![图片说明](https://img-ask.csdn.net/upload/201711/20/1511143913_279675.png)
php7 mysql5.7 打架啦
问题是这样的,全新Ubuntu14.04 (aliyun)里安装了mysql 5.7.13 ![Mysql版本信息](https://img-ask.csdn.net/upload/201607/20/1468974692_51088.png) 然后下载编译的PHP7 ./configure 的参数为 --enable-ftp --enable-fpm --with-pdo-mysql=/usr/bin/mysql 提示成功生成Makefile。 继续make时则出现以下错误 ``` ext/pdo_mysql/.libs/pdo_mysql.o: In function `zm_info_pdo_mysql': /root/a/php-7.0.8/ext/pdo_mysql/pdo_mysql.c:162: undefined reference to `mysql_get_client_info' ext/pdo_mysql/.libs/mysql_driver.o: In function `pdo_mysql_check_liveness': /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:493: undefined reference to `mysql_ping' ext/pdo_mysql/.libs/mysql_driver.o: In function `pdo_mysql_last_insert_id': /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:292: undefined reference to `mysql_insert_id' ext/pdo_mysql/.libs/mysql_driver.o: In function `mysql_handle_rollback': /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:343: undefined reference to `mysql_rollback' ext/pdo_mysql/.libs/mysql_driver.o: In function `mysql_handle_commit': /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:330: undefined reference to `mysql_commit' ext/pdo_mysql/.libs/mysql_driver.o: In function `mysql_handle_quoter': /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:307: undefined reference to `mysql_real_escape_string' ext/pdo_mysql/.libs/mysql_driver.o: In function `mysql_handle_closer': /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:149: undefined reference to `mysql_close' ext/pdo_mysql/.libs/mysql_driver.o: In function `mysql_handle_autocommit': /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:357: undefined reference to `mysql_autocommit' ext/pdo_mysql/.libs/mysql_driver.o: In function `_pdo_mysql_error': /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:65: undefined reference to `mysql_stmt_errno' /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:93: undefined reference to `mysql_error' /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:101: undefined reference to `mysql_stmt_sqlstate' /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:67: undefined reference to `mysql_errno' /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:103: undefined reference to `mysql_sqlstate' /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:93: undefined reference to `mysql_error' ext/pdo_mysql/.libs/mysql_driver.o: In function `pdo_mysql_handle_factory': /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:585: undefined reference to `mysql_init' /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:627: undefined reference to `mysql_options' /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:660: undefined reference to `mysql_options' /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:690: undefined reference to `mysql_options' /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:703: undefined reference to `mysql_ssl_set' /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:730: undefined reference to `mysql_options' /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:742: undefined reference to `mysql_options' /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:775: undefined reference to `mysql_real_connect' /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:670: undefined reference to `mysql_options' /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:680: undefined reference to `mysql_options' ext/pdo_mysql/.libs/mysql_driver.o: In function `mysql_handle_autocommit': /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:357: undefined reference to `mysql_autocommit' ext/pdo_mysql/.libs/mysql_driver.o: In function `pdo_mysql_handle_factory': /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:703: undefined reference to `mysql_ssl_set' ext/pdo_mysql/.libs/mysql_driver.o: In function `pdo_mysql_get_attribute': /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:444: undefined reference to `mysql_stat' /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:426: undefined reference to `mysql_get_client_info' /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:430: undefined reference to `mysql_get_server_info' /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:434: undefined reference to `mysql_get_host_info' ext/pdo_mysql/.libs/mysql_driver.o: In function `mysql_handle_doer': /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:261: undefined reference to `mysql_real_query' /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:265: undefined reference to `mysql_affected_rows' /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:274: undefined reference to `mysql_next_result' /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:277: undefined reference to `mysql_store_result' /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:273: undefined reference to `mysql_more_results' /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:279: undefined reference to `mysql_free_result' ext/pdo_mysql/.libs/mysql_driver.o: In function `mysql_handle_preparer': /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:183: undefined reference to `mysql_get_server_version' /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:200: undefined reference to `mysql_stmt_init' /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:208: undefined reference to `mysql_stmt_prepare' /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:227: undefined reference to `mysql_stmt_param_count' /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:211: undefined reference to `mysql_errno' ext/pdo_mysql/.libs/mysql_statement.o: In function `pdo_mysql_stmt_cursor_closer': /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:902: undefined reference to `mysql_free_result' /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:907: undefined reference to `mysql_stmt_free_result' /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:913: undefined reference to `mysql_next_result' /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:916: undefined reference to `mysql_store_result' /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:911: undefined reference to `mysql_more_results' /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:918: undefined reference to `mysql_free_result' ext/pdo_mysql/.libs/mysql_statement.o: In function `pdo_mysql_fill_stmt_from_result': /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:135: undefined reference to `mysql_affected_rows' /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:142: undefined reference to `mysql_store_result' /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:149: undefined reference to `mysql_num_rows' /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:150: undefined reference to `mysql_num_fields' /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:151: undefined reference to `mysql_fetch_fields' /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:140: undefined reference to `mysql_use_result' ext/pdo_mysql/.libs/mysql_statement.o: In function `pdo_mysql_stmt_next_rowset': /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:408: undefined reference to `mysql_num_fields' /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:410: undefined reference to `mysql_stmt_free_result' /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:414: undefined reference to `mysql_free_result' /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:418: undefined reference to `mysql_more_results' /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:430: undefined reference to `mysql_next_result' ext/pdo_mysql/.libs/mysql_statement.o: In function `pdo_mysql_stmt_fetch': /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:632: undefined reference to `mysql_stmt_fetch' /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:661: undefined reference to `mysql_fetch_row' /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:672: undefined reference to `mysql_fetch_lengths' /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:665: undefined reference to `mysql_errno' ext/pdo_mysql/.libs/mysql_statement.o: In function `pdo_mysql_stmt_dtor': /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:55: undefined reference to `mysql_free_result' /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:63: undefined reference to `mysql_stmt_close' /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:95: undefined reference to `mysql_next_result' /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:99: undefined reference to `mysql_store_result' /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:93: undefined reference to `mysql_more_results' /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:101: undefined reference to `mysql_free_result' ext/pdo_mysql/.libs/mysql_statement.o: In function `pdo_mysql_stmt_execute_prepared_libmysql': /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:170: undefined reference to `mysql_stmt_bind_param' /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:175: undefined reference to `mysql_stmt_errno' ext/pdo_mysql/.libs/mysql_statement.o: In function `pdo_mysql_stmt_execute': /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:328: undefined reference to `mysql_free_result' /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:332: undefined reference to `mysql_real_query' ext/pdo_mysql/.libs/mysql_statement.o: In function `pdo_mysql_stmt_execute_prepared_libmysql': /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:170: undefined reference to `mysql_stmt_execute' ext/pdo_mysql/.libs/mysql_statement.o: In function `pdo_mysql_stmt_set_row_count': /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:121: undefined reference to `mysql_stmt_affected_rows' ext/pdo_mysql/.libs/mysql_statement.o: In function `pdo_mysql_stmt_execute_prepared_libmysql': /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:186: undefined reference to `mysql_stmt_result_metadata' /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:189: undefined reference to `mysql_fetch_fields' /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:200: undefined reference to `mysql_num_fields' /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:254: undefined reference to `mysql_stmt_bind_result' /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:261: undefined reference to `mysql_stmt_store_result' /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:209: undefined reference to `mysql_stmt_attr_set' collect2: error: ld returned 1 exit status make: *** [sapi/cli/php] Error 1 ```
关于Ubuntu16.04用tar.gz通用压缩包安装mysql5.7.17失败
系统Ubuntu16.04 64位 准备安装MySQL 57.7.17 概要 apt-cache search libaio #安装mysql依赖库 tar -zxvf -zxvf mysql-5.7.17-linux-glibc2.5-x86_64.tar.gz #解压压缩包 mv mysql-5.7.17-linux-glibc2.5-x86_64 mysql #修改名字 groupadd mysql #添加用户组 useradd -r -g mysql -s /bin/false mysql #添加用户 cd mysql #进入mysql目录 mkdir mysql-files #新建目录 chmod 750 mysql-files #给目录授权为mysql 用户 chown -R mysql . chgrp -R mysql . bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data #初始化mysql数据库 bin/mysql_ssl_rsa_setup #创建SSL证书,密钥文件和RSA密钥对文件 chown -R root . #给当前目录授权为用户root chown -R mysql data mysql-files bin/mysqld_safe --user=mysql & #启动mysql 问题卡在这了 ![图片说明](https://img-ask.csdn.net/upload/201704/04/1491243943_360085.jpg) 详细步骤 1.安装准备 1.1查看自己的Linux系统版本 命令: cat /etc/issue 再具体点:uname -a 86_64就代表64位的系统 OK,咱们确定了自己的系统,现在去MySQL官网下载二进制压缩包源文件 1.2官网下载安装包 https://dev.mysql.com/downloads/mysql/ ![图片说明](https://img-ask.csdn.net/upload/201704/04/1491244259_939400.jpg) 选择对应的安装包 ![图片说明](https://img-ask.csdn.net/upload/201704/04/1491244281_48676.jpg) ![图片说明](https://img-ask.csdn.net/upload/201704/04/1491244297_258139.jpg) 下载的话,有两种方式: 1.从官网下载,然后用FTP软件上传到服务器上。 2.使用在线下载的方式,使用命令: wget -P /usr/local/support https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.17-linux-glibc2.5-x86_64.tar.gz 注:-P /usr/local/support 是指定下载目录 不要问我为啥网速这么快。。。。我也震惊了 ![图片说明](https://img-ask.csdn.net/upload/201704/04/1491244091_52801.jpg) 2.开始安装: 参考官方文档 ①为了预防以前安装过mysql,导致旧版本遗留文件冲突,所以需要把以前安装的文件都删除掉 /etc/my.cnf /etc/msyql目录 查找命令: find / -name 文件名or目录名 删除命令: rm -rf 文件名or目录名 ②安装mysql的依赖库libaio 搜索命令 apt-cache search libaio apt-cache search libaio 如果搜索没有显示结果,就安装 安装命令:apt-get install libaio1 注:如果报错,则需要使用更新命令 apt-get update 更新后就可以安装依赖库了 ③解压压缩包 命令: tar -zxvf -zxvf mysql-5.7.17-linux-glibc2.5-x86_64.tar.gz ④改名字,便于操作 命令:mv mysql-5.7.17-linux-glibc2.5-x86_64 mysql ④添加用户组, 添加用户 groupadd mysql useradd -r -g mysql -s /bin/false mysql ⑤进入msyql目录,创建目录mysql-files cd mysql mkdir mysql-files ⑥给文件夹授权为用户mysql chmod 750 mysql-files chown -R mysql . chgrp -R mysql . ⑦初始化数据库 bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data ⑧创建SSL证书,密钥文件和RSA密钥对文件 bin/mysql_ssl_rsa_setup ⑨给当前目录授权为用户root chown -R root . chown -R mysql data mysql-files ⑩问题来了 每当我执行到这个命令时,就卡那不懂了。。。。请教大神,这是为什么 bin/mysqld_safe --user=mysql & # Next command is optional ![图片说明](https://img-ask.csdn.net/upload/201704/04/1491244374_944582.jpg) 然后: 执行 mysql -u root -p 再输入密码,显示: ![图片说明](https://img-ask.csdn.net/upload/201704/04/1491244197_897753.png) 尝试解决 网上搜的方法: 在my.cnf 中添加sockt ![图片说明](https://img-ask.csdn.net/upload/201704/04/1491244246_429225.png) 使用该方法启动 mysql -p --socket=/tmp/mysql.sock ![图片说明](https://img-ask.csdn.net/upload/201704/04/1491244255_351582.png) 另外,参考这篇博客 http://ng2.site/mysql/2016/11/16/install-mysql-offline.html 也是安装失败,请大神指点! ------------------------------------------------------------------------------------------------------------------------------------------------------ PS: 我用apt-get install mysql-server 可以成功安装,但是用通用二进制压缩包离线安装一直安装不成功,这个问题纠结我很久了,成了心结,所以一定要解决掉!
mysql5.7.17zip安装过程中遇到的问题
C:\Users\Administrator>mysqld --console 2017-04-06T07:42:13.052983Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see doc umentation for more details). 2017-04-06T07:42:13.052983Z 0 [Note] --secure-file-priv is set to NULL. Operatio ns related to importing and exporting data are disabled 2017-04-06T07:42:13.053984Z 0 [Note] mysqld (mysqld 5.7.17) starting as process 5388 ... 2017-04-06T07:42:13.062984Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows in terlocked functions 2017-04-06T07:42:13.063984Z 0 [Note] InnoDB: Uses event mutexes 2017-04-06T07:42:13.063984Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are u sed for memory barrier 2017-04-06T07:42:13.063984Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3 2017-04-06T07:42:13.064984Z 0 [Note] InnoDB: Number of pools: 1 2017-04-06T07:42:13.064984Z 0 [Note] InnoDB: Not using CPU crc32 instructions 2017-04-06T07:42:13.069984Z 0 [Note] InnoDB: Initializing buffer pool, total siz e = 128M, instances = 1, chunk size = 128M 2017-04-06T07:42:13.081985Z 0 [Note] InnoDB: Completed initialization of buffer pool 2017-04-06T07:42:13.199992Z 0 [Note] InnoDB: Highest supported file format is Ba rracuda. 2017-04-06T07:42:13.400003Z 0 [Note] InnoDB: Creating shared tablespace for temp orary tables 2017-04-06T07:42:13.402003Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2017-04-06T07:42:13.577013Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB. 2017-04-06T07:42:13.582014Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2017-04-06T07:42:13.583014Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2017-04-06T07:42:13.586014Z 0 [Note] InnoDB: Waiting for purge to start 2017-04-06T07:42:13.637017Z 0 [Note] InnoDB: 5.7.17 started; log sequence number 2534758 2017-04-06T07:42:13.639017Z 0 [Note] Plugin 'FEDERATED' is disabled. 2017-04-06T07:42:13.639017Z 0 [Note] InnoDB: Loading buffer pool(s) from D:\mysq l-5.7.17-winx64\mysql-5.7.17-winx64\data\ib_buffer_pool 2017-04-06T07:42:13.749023Z 0 [Warning] Failed to set up SSL because of the foll owing SSL library error: SSL context is not usable without certificate and priva te key 2017-04-06T07:42:13.755024Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 2017-04-06T07:42:13.757024Z 0 [Note] IPv6 is available. 2017-04-06T07:42:13.758024Z 0 [Note] - '::' resolves to '::'; 2017-04-06T07:42:13.760024Z 0 [Note] Server socket created on IP: '::'. 2017-04-06T07:42:13.884031Z 0 [Note] InnoDB: Buffer pool(s) load completed at 17 0406 15:42:13 2017-04-06T07:42:14.388060Z 0 [Note] Event Scheduler: Loaded 0 events 2017-04-06T07:42:14.389060Z 0 [Note] Executing 'SELECT * FROM INFORMATION_SCHEMA .TABLES;' to get a list of tables using the deprecated partition engine. You may use the startup option '--disable-partition-engine-check' to skip this check. 2017-04-06T07:42:14.391060Z 0 [Note] Beginning of list of non-natively partition ed tables 2017-04-06T07:42:14.427062Z 0 [Note] End of list of non-natively partitioned tab les 2017-04-06T07:42:14.428062Z 0 [Note] mysqld: ready for connections. Version: '5.7.17' socket: '' port: 3306 MySQL Community Server (GPL)
再往数据库中添加数据时,起初可以添加进去,之后不知道是把电脑关了还是怎么老报错,而且添加不进去了
Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing app
Spring Boot yml配置mysql连接禁用SSL不起作用
项目启动警告: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification. 根据提示更改: ![图片说明](https://img-ask.csdn.net/upload/201906/10/1560132685_591690.jpg) 重启项目不生效
数据库与eclipse连接时候出错
Wed Apr 13 22:46:22 CST 2016 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification. Wed Apr 13 22:46:22 CST 2016 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
MyBatis逆向工程提示javax.net.ssl.SSLException是什么问题?
请问MyBatis逆向工程提示javax.net.ssl.SSLException是什么问题?怎么解决? 错误提示: ``` Wed Jan 22 15:08:37 CST 2020 WARN: Caught while disconnecting... EXCEPTION STACK TRACE: ** BEGIN NESTED EXCEPTION ** javax.net.ssl.SSLException MESSAGE: closing inbound before receiving peer's close_notify STACKTRACE: javax.net.ssl.SSLException: closing inbound before receiving peer's close_notify at java.base/sun.security.ssl.Alert.createSSLException(Alert.java:133) at java.base/sun.security.ssl.Alert.createSSLException(Alert.java:117) at java.base/sun.security.ssl.TransportContext.fatal(TransportContext.java:308) at java.base/sun.security.ssl.TransportContext.fatal(TransportContext.java:264) at java.base/sun.security.ssl.TransportContext.fatal(TransportContext.java:255) at java.base/sun.security.ssl.SSLSocketImpl.shutdownInput(SSLSocketImpl.java:645) at java.base/sun.security.ssl.SSLSocketImpl.shutdownInput(SSLSocketImpl.java:624) at com.mysql.cj.protocol.a.NativeProtocol.quit(NativeProtocol.java:1284) at com.mysql.cj.NativeSession.quit(NativeSession.java:182) at com.mysql.cj.jdbc.ConnectionImpl.realClose(ConnectionImpl.java:1911) at com.mysql.cj.jdbc.ConnectionImpl.close(ConnectionImpl.java:730) at org.mybatis.generator.config.Context.closeConnection(Context.java:535) at org.mybatis.generator.config.Context.introspectTables(Context.java:468) at org.mybatis.generator.api.MyBatisGenerator.generate(MyBatisGenerator.java:222) at org.mybatis.generator.api.MyBatisGenerator.generate(MyBatisGenerator.java:133) at GeneratorSqlmap.generator(GeneratorSqlmap.java:27) at GeneratorSqlmap.main(GeneratorSqlmap.java:33) ** END NESTED EXCEPTION ** WARNING: An illegal reflective access operation has occurred WARNING: Illegal reflective access by org.mybatis.generator.internal.DomWriter (file:/F:/SSM%e9%a1%b9%e7%9b%ae%e5%ae%9e%e6%88%98/%e7%ac%ac%e4%b8%80%e4%bb%b6%20maven%e7%ae%a1%e7%90%86%e7%9a%84ssm%e6%a1%86%e6%9e%b6(%e8%af%a6%e8%a7%a3)/e3%e5%95%86%e5%9f%8e_day01/%e9%bb%91%e9%a9%ac32%e6%9c%9f/01.%e6%95%99%e6%a1%88-3.0/01.%e5%8f%82%e8%80%83%e8%b5%84%e6%96%99/mybatis/%e9%80%86%e5%90%91%e5%b7%a5%e7%a8%8b/generatorSqlmapCustom/lib/mybatis-generator-core-1.3.2.jar) to method com.sun.org.apache.xerces.internal.dom.CoreDocumentImpl.getXmlVersion() WARNING: Please consider reporting this to the maintainers of org.mybatis.generator.internal.DomWriter WARNING: Use --illegal-access=warn to enable warnings of further illegal reflective access operations WARNING: All illegal access operations will be denied in a future release ``` 工程结构: ![图片说明](https://img-ask.csdn.net/upload/202001/22/1579677296_992794.png) GeneratorSqlmap类 ``` public class GeneratorSqlmap { public void generator() throws Exception{ List<String> warnings = new ArrayList<String>(); boolean overwrite = true; File configFile = new File("generatorConfig.xml"); ConfigurationParser cp = new ConfigurationParser(warnings); Configuration config = cp.parseConfiguration(configFile); DefaultShellCallback callback = new DefaultShellCallback(overwrite); MyBatisGenerator myBatisGenerator = new MyBatisGenerator(config, callback, warnings); myBatisGenerator.generate(null); } public static void main(String[] args) throws Exception { try { GeneratorSqlmap generatorSqlmap = new GeneratorSqlmap(); generatorSqlmap.generator(); } catch (Exception e) { e.printStackTrace(); } } } ``` generatorConfig.xml ``` <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE generatorConfiguration PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN" "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd"> <generatorConfiguration> <context id="testTables" targetRuntime="MyBatis3"> <commentGenerator> <!-- 是否去除自动生成的注释 true:是 : false:否 --> <property name="suppressAllComments" value="true" /> </commentGenerator> <!--数据库连接的信息:驱动类、连接地址、用户名、密码 --> <jdbcConnection driverClass="com.mysql.cj.jdbc.Driver" connectionURL="jdbc:mysql://localhost:3306/e3mall?serverTimezone=UTC" userId="root" password="root"> </jdbcConnection> <!-- 默认false,把JDBC DECIMAL 和 NUMERIC 类型解析为 Integer,为 true时把JDBC DECIMAL 和 NUMERIC 类型解析为java.math.BigDecimal --> <javaTypeResolver> <property name="forceBigDecimals" value="false" /> </javaTypeResolver> <!-- targetProject:生成PO类的位置 --> <javaModelGenerator targetPackage="cn.e3mall.pojo" targetProject=".\src"> <!-- enableSubPackages:是否让schema作为包的后缀 --> <property name="enableSubPackages" value="false" /> <!-- 从数据库返回的值被清理前后的空格 --> <property name="trimStrings" value="true" /> </javaModelGenerator> <!-- targetProject:mapper映射文件生成的位置 --> <sqlMapGenerator targetPackage="cn.e3mall.mapper" targetProject=".\src"> <!-- enableSubPackages:是否让schema作为包的后缀 --> <property name="enableSubPackages" value="false" /> </sqlMapGenerator> <!-- targetPackage:mapper接口生成的位置 --> <javaClientGenerator type="XMLMAPPER" targetPackage="cn.e3mall.mapper" targetProject=".\src"> <!-- enableSubPackages:是否让schema作为包的后缀 --> <property name="enableSubPackages" value="false" /> </javaClientGenerator> <!-- 指定数据库表 --> <table schema="" tableName="tb_content"></table> <table schema="" tableName="tb_content_category"></table> <table schema="" tableName="tb_item"></table> <table schema="" tableName="tb_item_cat"></table> <table schema="" tableName="tb_item_desc"></table> <table schema="" tableName="tb_item_param"></table> <table schema="" tableName="tb_item_param_item"></table> <table schema="" tableName="tb_order"></table> <table schema="" tableName="tb_order_item"></table> <table schema="" tableName="tb_order_shipping"></table> <table schema="" tableName="tb_user"></table> </context> </generatorConfiguration> ```
hive输入show databases,连接MySQL出现这个,求大佬详细步骤解决,感谢,拜托了。
WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
Eclipse连接MySQL后运行正常,但出现了下述红色的字体,请问怎么解决这一问题?
Fri May 19 22:56:23 CST 2017 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
运行程序报以下错误,求大佬帮忙
Fri Dec 08 08:05:55 CST 2017 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification. 已经修改了mysql:localhost:3306/数据库名?useSSL=false,但是还是报以上错误
java与mysql连接出现的问题
Fri Sep 09 00:56:14 CST 2016 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification. java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:963) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3966) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3902) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:875) at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1712) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1228) at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2253) at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2284) at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2083) at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:806) at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) at java.lang.reflect.Constructor.newInstance(Unknown Source) at com.mysql.jdbc.Util.handleNewInstance(Util.java:404) at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:410) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:328) at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at com.jakey.util.DbUtil.getCon(DbUtil.java:19) at com.jakey.util.DbUtil.main(DbUtil.java:31 代码 package com.jakey.util; import java.sql.Connection; import java.sql.DriverManager; public class DbUtil { // 定义数据库驱动程序 private static final String driver = "com.mysql.jdbc.Driver"; // 数据库连接地址 private static final String url = "jdbc:mysql://localhost:3306/db_courseselect?useUnicode=true&characterEncoding=utf-8";// library表示数据库 private static final String user = "root"; private static final String password = "LWZ222MESSI"; private static Connection connection = null; // 连接数据库 public DbUtil(){ // 数据库操作可能出现异常 try { Class.forName(driver); System.out.println("加载驱动文件成功!"); connection = DriverManager.getConnection(url, user, password); System.out.println("获得连接对象成功!"); } catch (Exception exception) { exception.printStackTrace(); System.out.println("数据库连接失败"); } finally { } } public static Connection getConnection() { return connection; } public static void close(Connection connection ) throws Exception { if (connection != null) { try { connection.close(); } catch (Exception e) { // TODO: handle exception throw e; } } } }
ecplise连接mysql本地数据库登录失败!求大神知道怎么回事!
Mon Nov 06 03:47:19 CST 2017 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification. java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:964) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:873) at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1710) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1226) at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2191) at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2222) at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2017) at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:779) at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:513) at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:389) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:330) at java.sql.DriverManager.getConnection(DriverManager.java:582) at java.sql.DriverManager.getConnection(DriverManager.java:185) at my01.Login_main01.loginButton_actionPerformed(Login_main01.java:78) at my01.Login_main01.actionPerformed(Login_main01.java:105) at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995) at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318) at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387) at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242) at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236) at java.awt.Component.processMouseEvent(Component.java:6297) at javax.swing.JComponent.processMouseEvent(JComponent.java:3275) at java.awt.Component.processEvent(Component.java:6062) at java.awt.Container.processEvent(Container.java:2039) at java.awt.Component.dispatchEventImpl(Component.java:4660) at java.awt.Container.dispatchEventImpl(Container.java:2097) at java.awt.Component.dispatchEvent(Component.java:4488) at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4575) at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4236) at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4166) at java.awt.Container.dispatchEventImpl(Container.java:2083) at java.awt.Window.dispatchEventImpl(Window.java:2489) at java.awt.Component.dispatchEvent(Component.java:4488) at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:674) at java.awt.EventQueue.access$400(EventQueue.java:81) at java.awt.EventQueue$2.run(EventQueue.java:633) at java.awt.EventQueue$2.run(EventQueue.java:631) at java.security.AccessController.doPrivileged(Native Method) at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87) at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:98) at java.awt.EventQueue$3.run(EventQueue.java:647) at java.awt.EventQueue$3.run(EventQueue.java:645) at java.security.AccessController.doPrivileged(Native Method) at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87) at java.awt.EventQueue.dispatchEvent(EventQueue.java:644) at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269) at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161) at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)![图片](https://img-ask.csdn.net/upload/201711/06/1509965515_190525.jpg)
openssl和mysql冲突 ERR_remove_thread_state
openssl版本:openssl-1.1.0k mysql版本:mysql-5.7.27 静态库,编译报如下错误: /thirdparty/mysql/lib/libmysqlclient.a(ssl.cpp.o): In function `ERR_remove_thread_state': /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/extra/yassl/src/ssl.cpp:1619: multiple definition of `ERR_remove_thread_state' /home/lics/code/transfer/thirdparty/openssl/lib/libcrypto.a(err.o):err.c:(.text+0xb60): first defined here collect2: error: ld returned 1 exit status make[1]: [build] Error 1 (ignored) 请问有谁遇到过吗?
文件名我检查过没错,请问这是由什么引起的
Wed Jul 20 09:51:52 CST 2016 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification. Wed Jul 20 09:51:52 CST 2016 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification. Wed Jul 20 09:51:52 CST 2016 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification. Exception in thread "main" org.springframework.beans.factory.CannotLoadBeanClassException: Error loading class [com/hsp/service/imp/EmployeeService] for bean with name 'employeeService' defined in class path resource [applicationContext.xml]: problem with class file or dependent class; nested exception is java.lang.NoClassDefFoundError: IllegalName: com/hsp/service/imp/EmployeeService at org.springframework.beans.factory.support.AbstractBeanFactory.resolveBeanClass(AbstractBeanFactory.java:1144) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.predictBeanType(AbstractAutowireCapableBeanFactory.java:524) at org.springframework.beans.factory.support.AbstractBeanFactory.isFactoryBean(AbstractBeanFactory.java:1177) at org.springframework.beans.factory.support.AbstractBeanFactory.isFactoryBean(AbstractBeanFactory.java:758) at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:422) at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:728) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:380) at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:139) at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:83) at com.hsp.test.Test.main(Test.java:13) Caused by: java.lang.NoClassDefFoundError: IllegalName: com/hsp/service/imp/EmployeeService at java.lang.ClassLoader.preDefineClass(ClassLoader.java:477) at java.lang.ClassLoader.defineClass(ClassLoader.java:615) at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:124) at java.net.URLClassLoader.defineClass(URLClassLoader.java:260) at java.net.URLClassLoader.access$000(URLClassLoader.java:56) at java.net.URLClassLoader$1.run(URLClassLoader.java:195) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(URLClassLoader.java:188) at java.lang.ClassLoader.loadClass(ClassLoader.java:307) at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301) at java.lang.ClassLoader.loadClass(ClassLoader.java:252) at org.springframework.util.ClassUtils.forName(ClassUtils.java:211) at org.springframework.beans.factory.support.AbstractBeanDefinition.resolveBeanClass(AbstractBeanDefinition.java:385) at org.springframework.beans.factory.support.AbstractBeanFactory.resolveBeanClass(AbstractBeanFactory.java:1138) ... 9 more
MAC下,openFire连不上服务器,Error 报log4j:ERROR setFile(null,true) call failed.
cat: 1294: No such file or directory cat: 1294: No such file or directory log4j:ERROR setFile(null,true) call failed. java.io.FileNotFoundException: /logs/all.log (No such file or directory) log4j:ERROR setFile(null,true) call failed. java.io.FileNotFoundException: /logs/debug.log (No such file or directory) log4j:ERROR setFile(null,true) call failed. java.io.FileNotFoundException: /logs/info.log (No such file or directory) log4j:ERROR setFile(null,true) call failed. java.io.FileNotFoundException: /logs/warn.log (No such file or directory) Sun Sep 23 10:38:48 CST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification. 求怎么解决?这个目录也找不到
mysql.sock的所有者所属组以及权限全部都是问号?求助神回复如何删除,亦或是如何重建,必有重谢!!!
mysql.sock的所有者所属组以及权限全部都是问号?求助神回复如何删除,亦或是如何重建,必有重谢!!! 代码如下: [root@DBServer-BAK lib]# cd /tmp [root@DBServer-BAK tmp]# ll ls: 无法访问mysql.sock: 输入/输出错误 总用量 40 drwxr-xr-x 2 root root 4096 6月 25 11:16 hsperfdata_root s????????? ? ? ? ? ? mysql.sock -rw------- 1 mysql mysql 6 6月 25 11:34 mysql.sock.lock -rwxrwxrwx 1 root root 45 6月 25 11:46 mysql.sock.tar.gz drwx------ 3 root root 4096 6月 25 11:16 systemd-private-0a3b207663d847a183bbad804fca0ebd-colord.service-sic0B1 drwx------ 3 root root 4096 6月 25 11:16 systemd-private-0a3b207663d847a183bbad804fca0ebd-cups.service-4zk1XQ drwx------ 3 root root 4096 6月 25 11:16 systemd-private-0a3b207663d847a183bbad804fca0ebd-rtkit-daemon.service-aM0JqV drwx------ 3 root root 4096 6月 20 07:42 systemd-private-6d51751ab45a4174b26d3719b9ce8eee-colord.service-1RN8yw drwx------ 3 root root 4096 6月 20 07:42 systemd-private-6d51751ab45a4174b26d3719b9ce8eee-cups.service-vXDiW2 drwx------ 3 root root 4096 6月 20 07:42 systemd-private-6d51751ab45a4174b26d3719b9ce8eee-rtkit-daemon.service-zCu1j4 drwx------ 2 ytomsbag ytomsbag 4096 6月 21 11:23 tracker-extract-files.1000 错误日志如下: 2019-06-25T05:00:27.641394Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2019-06-25T05:00:27.642251Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2019-06-25T05:00:27.642263Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2019-06-25T05:00:27.643015Z 0 [Note] InnoDB: Waiting for purge to start 2019-06-25T05:00:27.693118Z 0 [Note] InnoDB: 5.7.19 started; log sequence number 2539728 2019-06-25T05:00:27.693642Z 0 [Note] InnoDB: Loading buffer pool(s) from /usr/local/mysql/data/ib_buffer_pool 2019-06-25T05:00:27.693845Z 0 [Note] Plugin 'FEDERATED' is disabled. 2019-06-25T05:00:27.694464Z 0 [Note] InnoDB: Buffer pool(s) load completed at 190625 13:00:27 2019-06-25T05:00:27.698589Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key 2019-06-25T05:00:27.698608Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 2019-06-25T05:00:27.698645Z 0 [Note] IPv6 is available. 2019-06-25T05:00:27.698657Z 0 [Note] - '::' resolves to '::'; 2019-06-25T05:00:27.698702Z 0 [Note] Server socket created on IP: '::'. 2019-06-25T05:00:27.698752Z 0 [ERROR] Could not create unix socket lock file tmp/mysql.sock.lock. 2019-06-25T05:00:27.698766Z 0 [ERROR] Unable to setup unix socket lock file. 2019-06-25T05:00:27.698773Z 0 [ERROR] Aborting 2019-06-25T05:00:27.698781Z 0 [Note] Binlog end
sonar 配置mysql 连接报错
sonar 版本 6.7 mysql 版本 8.0 配置:sonar.jdbc.url=jdbc:mysql://localhost:3306/sonar?useUnicode=true&characterEncoding=utf8&rewriteBatchedStatements=true&useConfigs=maxPerformance&useSSL=false sonar.jdbc.username=easy sonar.jdbc.password=nolove 错误信息:11:30:57.509 [WrapperSimpleAppMain] WARN org.sonar.application.config.JdbcSettings - JDBC URL is recommended to have the property 'useConfigs=maxPerformance' 2018.09.04 11:30:57 INFO app[][o.s.a.AppFileSystem] Cleaning or creating temp directory F:\service\sonarqube-6.7.4\temp 2018.09.04 11:30:57 INFO app[][o.s.a.es.EsSettings] Elasticsearch listening on /127.0.0.1:9001 2018.09.04 11:30:57 INFO app[][o.s.a.p.ProcessLauncherImpl] Launch process[[key='es', ipcIndex=1, logFilenamePrefix=es]] from [F:\service\sonarqube-6.7.4\elasticsearch]: F:\service\jdk1.8\jre\bin\java -XX:+UseConcMarkSweepGC -XX:CMSInitiatingOccupancyFraction=75 -XX:+UseCMSInitiatingOccupancyOnly -XX:+AlwaysPreTouch -server -Xss1m -Djava.awt.headless=true -Dfile.encoding=UTF-8 -Djna.nosys=true -Djdk.io.permissionsUseCanonicalPath=true -Dio.netty.noUnsafe=true -Dio.netty.noKeySetOptimization=true -Dio.netty.recycler.maxCapacityPerThread=0 -Dlog4j.shutdownHookEnabled=false -Dlog4j2.disable.jmx=true -Dlog4j.skipJansi=true -Xms512m -Xmx512m -XX:+HeapDumpOnOutOfMemoryError -Delasticsearch -Des.path.home=F:\service\sonarqube-6.7.4\elasticsearch -cp lib/* org.elasticsearch.bootstrap.Elasticsearch -Epath.conf=F:\service\sonarqube-6.7.4\temp\conf\es 2018.09.04 11:30:57 INFO app[][o.s.a.SchedulerImpl] Waiting for Elasticsearch to be up and running 2018.09.04 11:30:57 INFO app[][o.e.p.PluginsService] no modules loaded 2018.09.04 11:30:57 INFO app[][o.e.p.PluginsService] loaded plugin [org.elasticsearch.transport.Netty4Plugin] 2018.09.04 11:31:05 INFO app[][o.s.a.SchedulerImpl] Process[es] is up 2018.09.04 11:31:05 INFO app[][o.s.a.p.ProcessLauncherImpl] Launch process[[key='web', ipcIndex=2, logFilenamePrefix=web]] from [F:\service\sonarqube-6.7.4]: F:\service\jdk1.8\jre\bin\java -Djava.awt.headless=true -Dfile.encoding=UTF-8 -Djava.io.tmpdir=F:\service\sonarqube-6.7.4\temp -Xmx512m -Xms128m -XX:+HeapDumpOnOutOfMemoryError -cp ./lib/common/*;./lib/server/*;F:\service\sonarqube-6.7.4\lib\jdbc\mysql\mysql-connector-java-5.1.42.jar org.sonar.server.app.WebServer F:\service\sonarqube-6.7.4\temp\sq-process1179029085093446759properties Tue Sep 04 11:31:08 AWST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification. 2018.09.04 11:31:09 INFO app[][o.s.a.SchedulerImpl] Process [web] is stopped 2018.09.04 11:31:09 INFO app[][o.s.a.SchedulerImpl] Process [es] is stopped 2018.09.04 11:31:09 INFO app[][o.s.a.SchedulerImpl] SonarQube is stopped 2018.09.04 11:31:09 WARN app[][o.e.t.n.Netty4Transport] exception caught on transport layer [[id: 0xadc1a015, L:/127.0.0.1:53287 - R:/127.0.0.1:9001]], closing connection java.io.IOException: 远程主机强迫关闭了一个现有的连接。
相见恨晚的超实用网站
相见恨晚的超实用网站 持续更新中。。。
字节跳动视频编解码面经
三四月份投了字节跳动的实习(图形图像岗位),然后hr打电话过来问了一下会不会opengl,c++,shador,当时只会一点c++,其他两个都不会,也就直接被拒了。 七月初内推了字节跳动的提前批,因为内推没有具体的岗位,hr又打电话问要不要考虑一下图形图像岗,我说实习投过这个岗位不合适,不会opengl和shador,然后hr就说秋招更看重基础。我当时想着能进去就不错了,管他哪个岗呢,就同意了面试...
Java学习的正确打开方式
在博主认为,对于入门级学习java的最佳学习方法莫过于视频+博客+书籍+总结,前三者博主将淋漓尽致地挥毫于这篇博客文章中,至于总结在于个人,实际上越到后面你会发现学习的最好方式就是阅读参考官方文档其次就是国内的书籍,博客次之,这又是一个层次了,这里暂时不提后面再谈。博主将为各位入门java保驾护航,各位只管冲鸭!!!上天是公平的,只要不辜负时间,时间自然不会辜负你。 何谓学习?博主所理解的学习,它是一个过程,是一个不断累积、不断沉淀、不断总结、善于传达自己的个人见解以及乐于分享的过程。
程序员必须掌握的核心算法有哪些?
由于我之前一直强调数据结构以及算法学习的重要性,所以就有一些读者经常问我,数据结构与算法应该要学习到哪个程度呢?,说实话,这个问题我不知道要怎么回答你,主要取决于你想学习到哪些程度,不过针对这个问题,我稍微总结一下我学过的算法知识点,以及我觉得值得学习的算法。这些算法与数据结构的学习大多数是零散的,并没有一本把他们全部覆盖的书籍。下面是我觉得值得学习的一些算法以及数据结构,当然,我也会整理一些看过...
大学四年自学走来,这些私藏的实用工具/学习网站我贡献出来了
大学四年,看课本是不可能一直看课本的了,对于学习,特别是自学,善于搜索网上的一些资源来辅助,还是非常有必要的,下面我就把这几年私藏的各种资源,网站贡献出来给你们。主要有:电子书搜索、实用工具、在线视频学习网站、非视频学习网站、软件下载、面试/求职必备网站。 注意:文中提到的所有资源,文末我都给你整理好了,你们只管拿去,如果觉得不错,转发、分享就是最大的支持了。 一、电子书搜索 对于大部分程序员...
linux系列之常用运维命令整理笔录
本博客记录工作中需要的linux运维命令,大学时候开始接触linux,会一些基本操作,可是都没有整理起来,加上是做开发,不做运维,有些命令忘记了,所以现在整理成博客,当然vi,文件操作等就不介绍了,慢慢积累一些其它拓展的命令,博客不定时更新 free -m 其中:m表示兆,也可以用g,注意都要小写 Men:表示物理内存统计 total:表示物理内存总数(total=used+free) use...
比特币原理详解
一、什么是比特币 比特币是一种电子货币,是一种基于密码学的货币,在2008年11月1日由中本聪发表比特币白皮书,文中提出了一种去中心化的电子记账系统,我们平时的电子现金是银行来记账,因为银行的背后是国家信用。去中心化电子记账系统是参与者共同记账。比特币可以防止主权危机、信用风险。其好处不多做赘述,这一层面介绍的文章很多,本文主要从更深层的技术原理角度进行介绍。 二、问题引入 假设现有4个人...
python学习方法总结(内附python全套学习资料)
不要再问我python好不好学了 我之前做过半年少儿编程老师,一个小学四年级的小孩子都能在我的教学下独立完成python游戏,植物大战僵尸简单版,如果要肯花时间,接下来的网络开发也不是问题,人工智能也可以学个调包也没啥问题。。。。。所以python真的是想学就一定能学会的!!!! --------------------华丽的分割线-------------------------------- ...
python 简易微信实现(注册登录+数据库存储+聊天+GUI+文件传输)
socket+tkinter详解+简易微信实现 历经多天的努力,查阅了许多大佬的博客后终于实现了一个简易的微信O(∩_∩)O~~ 简易数据库的实现 使用pands+CSV实现数据库框架搭建 import socket import threading from pandas import * import pymysql import csv # 创建DataFrame对象 # 存储用户数据的表(...
程序员接私活怎样防止做完了不给钱?
首先跟大家说明一点,我们做 IT 类的外包开发,是非标品开发,所以很有可能在开发过程中会有这样那样的需求修改,而这种需求修改很容易造成扯皮,进而影响到费用支付,甚至出现做完了项目收不到钱的情况。 那么,怎么保证自己的薪酬安全呢? 我们在开工前,一定要做好一些证据方面的准备(也就是“讨薪”的理论依据),这其中最重要的就是需求文档和验收标准。一定要让需求方提供这两个文档资料作为开发的基础。之后开发...
网页实现一个简单的音乐播放器(大佬别看。(⊙﹏⊙))
今天闲着无事,就想写点东西。然后听了下歌,就打算写个播放器。 于是乎用h5 audio的加上js简单的播放器完工了。 演示地点演示 html代码如下` music 这个年纪 七月的风 音乐 ` 然后就是css`*{ margin: 0; padding: 0; text-decoration: none; list-...
Python十大装B语法
Python 是一种代表简单思想的语言,其语法相对简单,很容易上手。不过,如果就此小视 Python 语法的精妙和深邃,那就大错特错了。本文精心筛选了最能展现 Python 语法之精妙的十个知识点,并附上详细的实例代码。如能在实战中融会贯通、灵活使用,必将使代码更为精炼、高效,同时也会极大提升代码B格,使之看上去更老练,读起来更优雅。
数据库优化 - SQL优化
以实际SQL入手,带你一步一步走上SQL优化之路!
2019年11月中国大陆编程语言排行榜
2019年11月2日,我统计了某招聘网站,获得有效程序员招聘数据9万条。针对招聘信息,提取编程语言关键字,并统计如下: 编程语言比例 rank pl_ percentage 1 java 33.62% 2 cpp 16.42% 3 c_sharp 12.82% 4 javascript 12.31% 5 python 7.93% 6 go 7.25% 7 p...
通俗易懂地给女朋友讲:线程池的内部原理
餐盘在灯光的照耀下格外晶莹洁白,女朋友拿起红酒杯轻轻地抿了一小口,对我说:“经常听你说线程池,到底线程池到底是个什么原理?”
《奇巧淫技》系列-python!!每天早上八点自动发送天气预报邮件到QQ邮箱
将代码部署服务器,每日早上定时获取到天气数据,并发送到邮箱。 也可以说是一个小型人工智障。 知识可以运用在不同地方,不一定非是天气预报。
经典算法(5)杨辉三角
杨辉三角 是经典算法,这篇博客对它的算法思想进行了讲解,并有完整的代码实现。
Python实例大全(基于Python3.7.4)
博客说明: 这是自己写的有关python语言的一篇综合博客。 只作为知识广度和编程技巧学习,不过于追究学习深度,点到即止、会用即可。 主要是基础语句,如三大控制语句(顺序、分支、循环),随机数的生成,数据类型的区分和使用; 也会涉及常用的算法和数据结构,以及面试题相关经验; 主体部分是针对python的数据挖掘和数据分析,主要先攻爬虫方向:正则表达式匹配,常用数据清洗办法,scrapy及其他爬虫框架,数据存储方式及其实现; 最后还会粗略涉及人工智能领域,玩转大数据与云计算、进行相关的预测和分析。
腾讯算法面试题:64匹马8个跑道需要多少轮才能选出最快的四匹?
昨天,有网友私信我,说去阿里面试,彻底的被打击到了。问了为什么网上大量使用ThreadLocal的源码都会加上private static?他被难住了,因为他从来都没有考虑过这个问题。无独有偶,今天笔者又发现有网友吐槽了一道腾讯的面试题,我们一起来看看。 腾讯算法面试题:64匹马8个跑道需要多少轮才能选出最快的四匹? 在互联网职场论坛,一名程序员发帖求助到。二面腾讯,其中一个算法题:64匹...
面试官:你连RESTful都不知道我怎么敢要你?
干货,2019 RESTful最贱实践
刷了几千道算法题,这些我私藏的刷题网站都在这里了!
遥想当年,机缘巧合入了 ACM 的坑,周边巨擘林立,从此过上了"天天被虐似死狗"的生活… 然而我是谁,我可是死狗中的战斗鸡,智力不够那刷题来凑,开始了夜以继日哼哧哼哧刷题的日子,从此"读题与提交齐飞, AC 与 WA 一色 ",我惊喜的发现被题虐既刺激又有快感,那一刻我泪流满面。这么好的事儿作为一个正直的人绝不能自己独享,经过激烈的颅内斗争,我决定把我私藏的十几个 T 的,阿不,十几个刷题网...
为啥国人偏爱Mybatis,而老外喜欢Hibernate/JPA呢?
关于SQL和ORM的争论,永远都不会终止,我也一直在思考这个问题。昨天又跟群里的小伙伴进行了一番讨论,感触还是有一些,于是就有了今天这篇文。 声明:本文不会下关于Mybatis和JPA两个持久层框架哪个更好这样的结论。只是摆事实,讲道理,所以,请各位看官勿喷。 一、事件起因 关于Mybatis和JPA孰优孰劣的问题,争论已经很多年了。一直也没有结论,毕竟每个人的喜好和习惯是大不相同的。我也看...
SQL-小白最佳入门sql查询一
不要偷偷的查询我的个人资料,即使你再喜欢我,也不要这样,真的不好;
JavaScript 为什么能活到现在?
作者 | 司徒正美 责编 |郭芮 出品 | CSDN(ID:CSDNnews) JavaScript能发展到现在的程度已经经历不少的坎坷,早产带来的某些缺陷是永久性的,因此浏览器才有禁用JavaScript的选项。甚至在jQuery时代有人问出这样的问题,jQuery与JavaScript哪个快?在Babel.js出来之前,发明一门全新的语言代码代替JavaScript...
项目中的if else太多了,该怎么重构?
介绍 最近跟着公司的大佬开发了一款IM系统,类似QQ和微信哈,就是聊天软件。我们有一部分业务逻辑是这样的 if (msgType = "文本") { // dosomething } else if(msgType = "图片") { // doshomething } else if(msgType = "视频") { // doshomething } else { // doshom...
Nginx 原理和架构
Nginx 是一个免费的,开源的,高性能的 HTTP 服务器和反向代理,以及 IMAP / POP3 代理服务器。Nginx 以其高性能,稳定性,丰富的功能,简单的配置和低资源消耗而闻名。 Nginx 的整体架构 Nginx 里有一个 master 进程和多个 worker 进程。master 进程并不处理网络请求,主要负责调度工作进程:加载配置、启动工作进程及非停升级。worker 进程负责处...
致 Python 初学者
欢迎来到“Python进阶”专栏!来到这里的每一位同学,应该大致上学习了很多 Python 的基础知识,正在努力成长的过程中。在此期间,一定遇到了很多的困惑,对未来的学习方向感到迷茫。我非常理解你们所面临的处境。我从2007年开始接触 python 这门编程语言,从2009年开始单一使用 python 应对所有的开发工作,直至今天。回顾自己的学习过程,也曾经遇到过无数的困难,也曾经迷茫过、困惑过。开办这个专栏,正是为了帮助像我当年一样困惑的 Python 初学者走出困境、快速成长。希望我的经验能真正帮到你
Python 编程开发 实用经验和技巧
Python是一门很灵活的语言,也有很多实用的方法,有时候实现一个功能可以用多种方法实现,我这里总结了一些常用的方法和技巧,包括小数保留指定位小数、判断变量的数据类型、类方法@classmethod、制表符中文对齐、遍历字典、datetime.timedelta的使用等,会持续更新......
吐血推荐珍藏的Visual Studio Code插件
作为一名Java工程师,由于工作需要,最近一个月一直在写NodeJS,这种经历可以说是一部辛酸史了。好在有神器Visual Studio Code陪伴,让我的这段经历没有更加困难。眼看这段经历要告一段落了,今天就来给大家分享一下我常用的一些VSC的插件。 VSC的插件安装方法很简单,只需要点击左侧最下方的插件栏选项,然后就可以搜索你想要的插件了。 下面我们进入正题 Material Theme ...
“狗屁不通文章生成器”登顶GitHub热榜,分分钟写出万字形式主义大作
一、垃圾文字生成器介绍 最近在浏览GitHub的时候,发现了这样一个骨骼清奇的雷人项目,而且热度还特别高。 项目中文名:狗屁不通文章生成器 项目英文名:BullshitGenerator 根据作者的介绍,他是偶尔需要一些中文文字用于GUI开发时测试文本渲染,因此开发了这个废话生成器。但由于生成的废话实在是太过富于哲理,所以最近已经被小伙伴们给玩坏了。 他的文风可能是这样的: 你发现,...
相关热词 基于c#波形控件 c# 十进制转十六进制 对文件aes加密vc# c#读取栈中所有的值 c# rsa256加密 好 学c# 还是c++ c# 和java的差距 c# curl网络框架 c# https证书请求 c# 中崎
立即提问