INSERT INTO t_0008.tbLOchange (serial,c_date,c_type,is_admin,contents,param_1,param_2,param_3) VALUES ( '0201t253', now(),'2','Y','LO.mail.log.reg','idwook80@iremo.net','','super')
[2017-11-02 18:36:11] ERROR com.jlee.sol.db.manager.DBConnection.sqlDo(DBConnection.java:582) - [DB ERROR] Cannot excute query - INSERT INTO t_0008.tbLOchange (serial,c_date,c_type,is_admin,contents,param_1,param_2,param_3) VALUES ( '0201t253', now(),'2','Y','LO.mail.log.reg','idwook80@iremo.net','','super') - java.sql.SQLException: Field 'log' doesn't have a default value
[2017-11-02 18:36:11] DEBUG com.jlee.sol.db.manager.DBConnection.sqlDo(DBConnection.java:571) -
카테고리 없음2017. 11. 2. 18:41
OS/CentOS72017. 6. 23. 10:10
# yum -y install http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm# yum -y install mysql-community-server# systemctl start mysqld# systemctl enable mysqld# mysqlmysql>quit# vi /etc/my.cnf[client] default-character-set = utf8[mysql]default-character-set=utf8[mysqld]datadir=/var/lib/mysqlsocket=/var/lib/mysql/mysql.sockcharacter-set-server=utf8collation-server=utf8_general_ciinit_connect=SET collation_connection = utf8_general_ciinit_connect=SET NAMES utf8character-set-client-handshake = FALSEskip-character-set-client-handshake[mysqldump]default-character-set=utf8root 설정 및 보안설정
# /usr/bin/mysql_secure_installation
포트 허용
# firewall-cmd --permanent --zone=public --add-port=3306/tcp
# firewall-cmd --reload
'OS > CentOS7' 카테고리의 다른 글
| centos7 + apache +tomcat 연동 (0) | 2019.01.10 |
|---|---|
| CentOS7 Vnc 설정관련 (0) | 2017.06.22 |
| CentOS7 Locale설정 (0) | 2017.06.22 |
OS/CentOS72017. 6. 22. 17:53
cp /lib/systemd/system/vncserver@.service /etc/systemd/system/vncserver@:1.service
vnc 작동에 문제가 있는경우
/tmp/.X11-unix/X? 관련 데이터를 삭제후 재시작 으로 해결되는경우 있음
'OS > CentOS7' 카테고리의 다른 글
| centos7 + apache +tomcat 연동 (0) | 2019.01.10 |
|---|---|
| CentOS7 + Mysql (0) | 2017.06.23 |
| CentOS7 Locale설정 (0) | 2017.06.22 |
