Blog

Linux

General

Proxy, Firewall, and DNS

NFS

Open Journal System (OJS)

E-mail

Java

Oracle

Python

PDF Support

  • sudo apt-get install pdfmod
  • sudo apt-get install pdftoppm
  • pdftoppm input.pdf outputname -png

WordPress

  • CREATE DATABASE WP_USER;
  • CREATE USER ‘WP_USER’@’localhost’ IDENTIFIED BY ‘PASSWORD’;
  • GRANT ALL PRIVILEGES ON WP_USER.* TO ‘WP_USER’@’localhost’;

MySQL

  • Instalation
  • Backup
    • mysqldump –force –opt –user=$USER –password=$PASSWORD –databases $db | gzip -c > $OUTPUT/$db.gz
  • Restore
    • gzip -d $db.gz
    • mysql -u root -p $db < $db
  • Remote calls
    • CREATE USER ‘user’@’%’ IDENTIFIED BY ‘senha’;
    • GRANT ALL ON *.* TO user@’%’ WITH GRANT OPTION ;

PostgreSQL

  • Backup
    • su - postgres -c "/usr/bin/pg_dump $db | gzip -c > $DIR/$db.gz"
  • Restore
    • gunzip $db.gz
    • su - postgres -c "psql -d $db -f $DIR/$db"
  • Change postgres password
    • su -l postgres
    • psql
      • alter user postgres with password ‘<senha>’;
  • Remote Access
    • Edit postgresql.conf
      • Change:listen = ‘*’
    • Edit pg_hba.conf
      • Include:host all all 0.0.0.0 0.0.0.0 md5
  • Main

Locale

  • locale-gen pt_BR pt_BR.UTF-8
  • dpkg-reconfigure locales
  • apt-get dist-upgrade
  • vi /etc/default/locale
    • LANG=en_US.UTF-8
    • LANGUAGE=en_US.UTF-8
    • LC_CTYPE=en_US.UTF-8Se

[:en]General

Proxy, Firewall, and DNS

NFS

Open Journal System (OJS)

E-mail

Java

Oracle

Python

PDF Support

  • sudo apt-get install pdfmod
  • sudo apt-get install pdftoppm
  • pdftoppm input.pdf outputname -png

WordPress

  • CREATE DATABASE WP_USER;
  • CREATE USER ‘WP_USER’@’localhost’ IDENTIFIED BY ‘PASSWORD’;
  • GRANT ALL PRIVILEGES ON WP_USER.* TO ‘WP_USER’@’localhost’;

MySQL

  • Instalation
  • Backup
    • mysqldump –force –opt –user=$USER –password=$PASSWORD –databases $db | gzip -c > $OUTPUT/$db.gz
  • Restore
    • gzip -d $db.gz
    • mysql -u root -p $db < $db
  • Remote calls
    • GRANT ALL PRIVILEGES ON $db.* TO ‘$USER’@’%’ IDENTIFIED BY ‘$PASSWORD’ WITH GRANT OPTION;

PostgreSQL

  • Backup
    • su - postgres -c "/usr/bin/pg_dump $db | gzip -c > $DIR/$db.gz"
  • Restore
    • gunzip $db.gz
    • su - postgres -c "psql -d $db -f $DIR/$db"
  • Version 9.4
    • Create the file/etc/apt/sources.list.d/pgdg.list, and add a line for the repository
      • deb https://apt.postgresql.org/pub/repos/apt/trusty-pgdg main
    • Import the repository signing key, and update the package lists
      • wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | \
        sudo apt-key add -
        sudo apt-get update
  • Remote Access
    • Edit postgresql.conf
      • Change:listen = ‘*’
    • Edit pg_hba.conf
      • Include:host all all 0.0.0.0 0.0.0.0 md5
  • Main

Locale

  • locale-gen pt_BR pt_BR.UTF-8
  • dpkg-reconfigure locales
  • apt-get dist-upgrade
  • vi /etc/default/locale
    • LANG=en_US.UTF-8
    • LANGUAGE=en_US.UTF-8
    • LC_CTYPE=en_US.UTF-8Se

Eduardo Ogasawara

Eduardo Ogasawara has been a professor at the Department of Computer Science at the Federal Center for Technological Education of Rio de Janeiro (CEFET/RJ) since 2010. He holds a D.Sc. in Systems and Computer Engineering from COPPE/UFRJ. Between 2000 and 2007, he worked in the Information Technology (IT) sector, gaining extensive experience in workflows and project management. With a strong background in Data Science, he is currently focused on Data Mining and Time Series Analysis. He is a member of IEEE, ACM, and SBC. Throughout his career, he has authored numerous published articles and led projects funded by agencies such as CNPq and FAPERJ. Currently, he heads the Data Analytics Lab (DAL) at CEFET/RJ, where he continues to advance research in Data Science.