「 月別アーカイブ：2020年05月 」 一覧

Overview Dataframe type in python is so useful to data processing and it’s possible to insert data as dataframe into MySQL . There is a sample of that. Environments Python 3.7.3MySQL 5.5.62 Step1 : Making the table Defining a table like the following. > CREATE DATABASE testdb; > CREATE TABLE testdb.mysql_table( col1 int ,col2 int ,col3 int ); Step2 : Making data Making data for insert from python. the data should be the same type as the table you will insert it. The column name of dataframe is also same as the table if they are different you will get …

Overview There are some samples to connect PostgreSQL, Oracle, MySQL from Python. How to connect PostgreSQL Package installation pip install psycopg2 Example import psycopg2 HOST = ‘your_host’ PORT = ‘5432’ DB_NAME = ‘your_db_name’ USER = ‘your_user_name’ PASSWORD = ‘your_password’ conn = psycopg2.connect("host=" + HOST + " port=" + PORT + " dbname=" + DB_NAME + " user=" + USER + " password=" + PASSWORD ) cur = conn.cursor() cur.execute("select version()") rows = cur.fetchall() cur.close() conn.close() print(rows) Connect to MySQL Package installation pip install mysqlclient Example import MySQLdb HOST = ‘your_host’ PORT = 3306 #Not str but int DB_NAME = ‘your_db_name’ …

Overview MySQL plugin for ReadyNAS is available if your NETGEATR NAS device is connected to online. The following shows how to install MySQL plugin and enable it. Environment ReadyNAS 6.10.3MySQL Server1.0.1 (plugin) Step1 : Install MySQL plugin At first let’s open ReadyNAS service from web browser. This page is refence to access it. NETGEAR ReadyNASの設定 After opening ReadyNAS home, select a Available Apps tab. When you input ‘mysql’ into the search box at left side , you can find MySQL server pugin and click install. Completed installation, then MySql Server shows at Installed Apps list. You may find ‘Launch’ button …

Ovewivew I encountered ORA-65096 when I tried to create user at Oracle 18c Express Edition. This is a example to fix ORA-65096. Environments OS : Windows10Oracle : 18c Express Edition Error SQL> CREATE USER user01 identified by password01 default tablespace USERS; ORA-65096: ORA-65096: invalid common user or role name Step1 : Checking database Oracle has two databases ,’CDB’ and ‘PDB’. It seems it’s not possible to create local user on CDB, so we have to check which database are used. SQL> show con_name; CON_NAME —————————— CDB$ROOT If you find CDB lie the above, It’s good to try change it to …

Overview Rundeck is functional Open Source Software for job management. It is more useful than cron because it can realize workflow, scheduling and so on. Following shows how to install Rundeck on CenOS and access it from a web browser. Rundeck https://www.rundeck.com/open-source Environment OS : CentOS7JDK : Openjdk8Rundeck : 3.0.13 Step1 : Installation of JDK At first you have to install JRE because Rundeck requires java runtime environment. This is a example to install JDK for it. #Installation of jdk $ sudo yum -y install java-1.8.0-openjdk java-1.8.0-openjdk-devel #Adding JAVA_HOME path in .bash_profile $vim .bash_profile export JAVA_HOME=/lib/jvm/java-1.8.0-openjdk-1.8.0.191.b12-1.el7_6.x86_64 export PATH=$PATH:$JAVA_HOME/bin export PATH=$PATH:$JAVA_HOME/jre/bin …

Overview There is a good library in python to make GUI, that is tkinter. It can display images too. Here, we are trying to change images periodically with tkinter. Python library to be used Following three libraries are used. tkinter ‘tkinter’ is used to make GUI. PIL(pillow) ‘PIL’ is used to deal with images in the python. threading ‘threading’ is used to change images automatically. Detail about that will be explained later. By the way, if you are using anaconda which contains these three libraries already , you don’t have to install them with pip command. Step1 : Display a …

Overivew As a result of mistake of crontab setting for a job, Over 200 thousands of activity log was created. Somehow it’s not possible to delete project. Maybe it has too much activity and it takes too much time more than accepted. In the following , There are procedure to delete whole MySQL database for rundeck and clean all jobs and activities so on. Environments OS : CentOS7MySQL：Ver. 15.1Rundeck：Ver. 3.0.13 Step1 : Backup of jobs If you drop the MySQL database for rundeck all jobs are removed. So you have to export the important jobs for you beforehand.The procedure is …